https://www.icyphoenix.com/viewtopic.php?f=35&t=7982
-----------------------------------
brouhon
Sun 07 Aug, 2011 22:13

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

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 linenumbers=false]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`;[/code]

you got to sort out, what of this you need


-----------------------------------
brouhon
Mon 08 Aug, 2011 00:36

Re: Change Cms From Nuke Evolution To Icy Phoenix
-----------------------------------
thx man


