Icy Phoenix :: View topic - Change Cms From Nuke Evolution 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