Change Cms From Nuke Evolution To Icy Phoenix »  Show posts from    to     

Icy Phoenix


Old Support Topics - Change Cms From Nuke Evolution To Icy Phoenix



brouhon [ Sun 07 Aug, 2011 22:13 ]
Post subject: Change Cms From Nuke Evolution To Icy Phoenix
hi ppl,
i have one small question regarding the database
i would like to change my current cms to icy phoenix
and i have a small problem
i can take over almost all important stuff from the evo database with minor changes
the problem is the forums data since post_texts and the posts data are splitted up in 2 tables
and icy has this in one table
is it possible to merge the content of the two evo tables into the icy 1 ?

c ya ferdi


spydie [ Mon 08 Aug, 2011 00:16 ]
Post subject: Re: Change Cms From Nuke Evolution To Icy Phoenix
have a look at database update script or sql files in install folder from version 1.3.0.53.x

there is a merge from posts and posts_text tables

you should fuind what you need there

something like this
Code: [Hide] [Select]
INSERT INTO `___posts___`
SELECT p.post_id, p.topic_id, p.forum_id, p.poster_id, p.post_time, p.poster_ip, p.post_username, t.post_subject, t.post_text, t.post_text_compiled, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, t.edit_notes, p.post_edit_time, p.post_edit_count, p.post_edit_id, p.post_attachment, p.post_bluecard, p.enable_autolinks_acronyms
FROM `phpbb_posts` p, `phpbb_posts_text` t
WHERE p.post_id = t.post_id
ORDER BY p.post_id;

RENAME TABLE `phpbb_posts` TO `_old_phpbb_posts`;
RENAME TABLE `phpbb_posts_text` TO `_old_phpbb_posts_text`;
RENAME TABLE `___posts___` TO `phpbb_posts`;


you got to sort out, what of this you need


brouhon [ Mon 08 Aug, 2011 00:36 ]
Post subject: Re: Change Cms From Nuke Evolution To Icy Phoenix
thx man




Powered by Icy Phoenix