:::
tad - XOOPS小秘方 | 2011-03-23 | 人氣:10488

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;


網友個人意見,不代表本站立場,對於發言內容,由發表者自負責任。
:::

訂閱 / 取消電子報

目前訂閱人數: 955 人

線上使用者

11人線上 (4人在瀏覽最新消息)

會員: 0

訪客: 11

更多…

網站佈景


(共 5 個樣板佈景)