1
I have had a few emails about how to upgrade from newbb to X-Forum. The following SQL you can fire you will need to replace
prefix_ with your database prefix but this will copy all the data from newbb to xforum and allow it to be used.
le="color: #000000"><?php TRUNCATE prefix__xf_archive; TRUNCATE prefix__xf_attachments; TRUNCATE prefix__xf_categories; TRUNCATE prefix__xf_digest; TRUNCATE prefix__xf_extras; TRUNCATE prefix__xf_field; TRUNCATE prefix__xf_forums; TRUNCATE prefix__xf_moderates; TRUNCATE prefix__xf_online; TRUNCATE prefix__xf_posts; TRUNCATE prefix__xf_posts_text; TRUNCATE prefix__xf_reads_forum; TRUNCATE prefix__xf_reads_topic; TRUNCATE prefix__xf_report; TRUNCATE prefix__xf_topics; TRUNCATE prefix__xf_visibility; TRUNCATE prefix__xf_votedata; INSERT INTO prefix__xf_archive SELECT * FROM prefix__bb_archive; INSERT INTO prefix__xf_attachments SELECT * FROM prefix__bb_attachments; INSERT INTO prefix__xf_categories SELECT * FROM prefix__bb_categories; INSERT INTO prefix__xf_digest SELECT * FROM prefix__bb_digest; INSERT INTO prefix__xf_forums SELECT * FROM prefix__bb_forums; INSERT INTO prefix__xf_moderates SELECT * FROM prefix__bb_moderates; INSERT INTO prefix__xf_online SELECT * FROM prefix__bb_online; INSERT INTO prefix__xf_posts (post_id, pid, topic_id, forum_id, post_time, uid, poster_name, poster_ip, `subject`, dohtml, dosmiley, doxcode, dobr, doimage, icon, attachsig,approved,post_karma,attachment,require_reply) SELECT * FROM prefix__bb_posts; INSERT INTO prefix__xf_posts_text SELECT * FROM prefix__bb_posts_text; INSERT INTO prefix__xf_reads_forum SELECT * FROM prefix__bb_reads_forum; INSERT INTO prefix__xf_reads_topic SELECT * FROM prefix__bb_reads_topic; INSERT INTO prefix__xf_report SELECT * FROM prefix__bb_report; INSERT INTO prefix__xf_topics SELECT * FROM prefix__bb_topics; INSERT INTO prefix__xf_votedata SELECT * FROM prefix__bb_votedata;
You will be able to fire this in phpmyadmin or SQL tools like sqlYog from webYog.
