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
Change Cms From Nuke Evolution To Icy Phoenix
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
you got to sort out, what of this you need
there is a merge from posts and posts_text tables
you should fuind what you need there
something like this
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`;
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
Page 1 of 1
You cannot post new topicsYou cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events
This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Powered by Icy Phoenix based on phpBB
Generation Time: 0.9358s (PHP: 2% SQL: 98%)
SQL queries: 31 - Debug Off - GZIP Enabled