OOo補給站（http://ooo.tn.edu.tw）的討論區是 CBB4.0.3，但因為發現在搬移討論區時會出現空白畫面，此外，有些區塊無法使用，因此，二話不說，直接升級成 X-Forum 5.7.5 再說。原本拿之前的 3.0.8的升級語法來轉換資料 X-Forum ，但結果發現是行不通的！

因此，修改了一下語法，有需要的可以拿去試試看（對原資料是不會有影響的，請安心服用）。

使用時，請先裝好 X-Forum 5.7.5，然後，到 phpMyAdmin 中將以下語法貼上（請自己把「前置字串」換成真實的前置字串），執行之即可（一開始會先清空 X-Forum 資料是正常的喔～）。

TRUNCATE 前置字串_xf_archive;
TRUNCATE 前置字串_xf_attachments;
TRUNCATE 前置字串_xf_categories;
TRUNCATE 前置字串_xf_digest;
TRUNCATE 前置字串_xf_extras;
TRUNCATE 前置字串_xf_field;
TRUNCATE 前置字串_xf_forums;
TRUNCATE 前置字串_xf_moderates;
TRUNCATE 前置字串_xf_online;
TRUNCATE 前置字串_xf_posts;
TRUNCATE 前置字串_xf_posts_text;
TRUNCATE 前置字串_xf_reads_forum;
TRUNCATE 前置字串_xf_reads_topic;
TRUNCATE 前置字串_xf_report;
TRUNCATE 前置字串_xf_topics;
TRUNCATE 前置字串_xf_visibility;
TRUNCATE 前置字串_xf_votedata;

INSERT INTO 前置字串_xf_archive (`topic_id`, `post_id`, `post_text`) SELECT * FROM 前置字串_bb_archive;

INSERT INTO 前置字串_xf_attachments (`attach_id`, `post_id`, `name_saved`, `name_disp`, `mimetype`, `online`, `attach_time`, `download`) SELECT * FROM 前置字串_bb_attachments;

INSERT INTO 前置字串_xf_categories (`cat_id`, `cat_image`, `cat_title`, `cat_description`, `cat_order`, `cat_url`) SELECT * FROM 前置字串_bb_categories;

INSERT INTO 前置字串_xf_digest SELECT * FROM 前置字串_bb_digest;

INSERT INTO 前置字串_xf_forums (`forum_id`, `forum_name`, `forum_desc`, `parent_forum`, `forum_moderator`, `forum_topics`, `forum_posts`, `forum_last_post_id`, `cat_id` , `hot_threshold`, `forum_order`, `attach_maxkb`, `attach_ext`) SELECT * FROM 前置字串_bb_forums;

INSERT INTO 前置字串_xf_moderates SELECT * FROM 前置字串_bb_moderates;

INSERT INTO 前置字串_xf_online SELECT * FROM 前置字串_bb_online;

INSERT INTO 前置字串_xf_posts (`post_id`, `pid`, `topic_id`, `forum_id`, `post_time`, `uid`, `poster_name`, `poster_ip`, `subject`, `icon`, `attachsig`, `approved`, `post_karma`, `attachment`, `require_reply`) SELECT * FROM 前置字串_bb_posts;

INSERT INTO 前置字串_xf_posts_text (`post_id`, `post_text`, `post_edit`) SELECT `post_id`, `post_text`, `post_edit` FROM 前置字串_bb_posts_text;

INSERT INTO 前置字串_xf_reads_forum SELECT * FROM 前置字串_bb_reads_forum;

INSERT INTO 前置字串_xf_reads_topic  SELECT * FROM 前置字串_bb_reads_topic;
INSERT INTO 前置字串_xf_report SELECT * FROM 前置字串_bb_report;
INSERT INTO 前置字串_xf_topics (`topic_id`, `topic_title`, `topic_poster`, `topic_time`, `topic_views`, `topic_replies`, `topic_last_post_id`, `forum_id`, `topic_status`, `topic_subject`, `topic_sticky`, `topic_digest`, `digest_time`, `approved`, `poster_name`, `rating`, `votes`, `topic_haspoll`, `poll_id`) SELECT `topic_id`, `topic_title`, `topic_poster`, `topic_time`, `topic_views`, `topic_replies`, `topic_last_post_id`, `forum_id`, `topic_status`, `type_id`, `topic_sticky`, `topic_digest`, `digest_time`, `approved`, `poster_name`, `rating`, `votes`, `topic_haspoll`, `poll_id` FROM 前置字串_bb_topics;
INSERT INTO 前置字串_xf_votedata SELECT * FROM 前置字串_bb_votedata;