Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post 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
 



 
brouhonSend private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post 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: [Download] [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
 




____________
Out of Order
 
spydieSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Change Cms From Nuke Evolution To Icy Phoenix 
 
thx man
 



 
brouhonSend private message  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
You cannot post new topics
You 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