經常遇到此類情況:後台誤操作,不小心刪除後台 discuz 代碼,導致找不到 discuz 代碼設置或者論壇的 discuz 代碼無法正常使用;

下面主要講述 Discuz7.0.0 版本遇到此類情況的一個解決方法,這裏以常用的 Flash 為例;

論壇後台 => 工具 => 數據庫 => 升級:

INSERT INTO cdb_bbcodes VALUES ('21','0','0','flash','bb_flash.gif','

','Flash Movie','嵌入 Flash 動畫','1','請輸入 Flash 動畫的 URL:','1','20');

  • INSERT INTO cdb_bbcodes VALUES ('21','0','0','flash','bb_flash.gif','<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0" width="550" height="400"><param name="allowScriptAccess" value="sameDomain"><param name="movie" value="{1}"><param name="quality" value="high"><param name="bgcolor" value="#ffffff"><embed src="{1}" quality="high" bgcolor="#ffffff" width="550" height="400" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" wmode="transparent" /></object>','Flash Movie','嵌入 Flash 動畫','1','請輸入 Flash 動畫的 URL:','1','20');

複製上面的代碼執行下,執行後,不小心刪除的 Flash 代碼就可以正常看到了。

其他的 discuz 代碼都可以在論壇的 install 目錄下 discuz.sql 文件內看到對應的 SQL 語句。

其他的 discuz 代碼的 SQL 語句內容如下:

INSERT INTO cdb_bbcodes VALUES ('1','2','1','b i u','popup_simple','','','粗體 斜體 下劃線','1','','1','0');
INSERT INTO cdb_bbcodes VALUES ('2','1','1','font','popup_fontname','','','字體','1','','1','1');
INSERT INTO cdb_bbcodes VALUES ('3','2','1','size','popup_fontsize','','','大小','1','','1','2');
INSERT INTO cdb_bbcodes VALUES ('4','2','1','color','popup_forecolor','','','顏色','1','','1','3');
INSERT INTO cdb_bbcodes VALUES ('5','2','1','align','popup_justify','','','對齊','1','','1','4');
INSERT INTO cdb_bbcodes VALUES ('6','2','1','url','cmd_createlink','','','鏈接','1','','1','5');
INSERT INTO cdb_bbcodes VALUES ('7','1','1','email','cmd_email','','','Email','1','','1','6');
INSERT INTO cdb_bbcodes VALUES ('8','2','1','img','cmd_insertimage','','','圖片','1','','1','7');
INSERT INTO cdb_bbcodes VALUES ('9','2','1','media','popup_media','','','多媒體','1','','1','8');
INSERT INTO cdb_bbcodes VALUES ('10','2','1','quote','cmd_quote','','','引用','1','','1','9');
INSERT INTO cdb_bbcodes VALUES ('11','2','1','code','cmd_code','','','代碼','1','','1','10');
INSERT INTO cdb_bbcodes VALUES ('12','2','1','list','popup_list','','','列表','1','','1','11');
INSERT INTO cdb_bbcodes VALUES ('13','2','1','indent outdent','popup_dent','','','縮進','1','','1','12');
INSERT INTO cdb_bbcodes VALUES ('14','1','1','float','popup_float','','','浮動','1','','1','13');
INSERT INTO cdb_bbcodes VALUES ('15','2','1','table','cmd_table','','','表格','1','','1','14');
INSERT INTO cdb_bbcodes VALUES ('16','1','1','free','cmd_free','','','免費信息','1','','1','15');
INSERT INTO cdb_bbcodes VALUES ('17','2','1','hide','cmd_hide','','','隱藏內容','1','','1','16');
INSERT INTO cdb_bbcodes VALUES ('18','2','1','smilies','popup_smilies','','','表情','1','','1','17');
INSERT INTO cdb_bbcodes VALUES ('19','2','1','tools','popup_tools','','','工具','1','','1','99');
INSERT INTO cdb_bbcodes VALUES ('20','0','0','fly','bb_fly.gif','<marquee width="90%" behavior="alternate" scrollamount="3">{1}</marquee>','[fly]This is sample text[/fly]','使內容橫向滾動,這個效果類似 HTML 的 marquee 標籤,注意:這個效果只在 Internet Explorer 瀏覽器下有效。','1','請輸入滾動顯示的文字:','1','19');
INSERT INTO cdb_bbcodes VALUES ('21','0','0','flash','bb_flash.gif','<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0" width="550" height="400"><param name="allowScriptAccess" value="sameDomain"><param name="movie" value="{1}"><param name="quality" value="high"><param name="bgcolor" value="#ffffff"><embed src="{1}" quality="high" bgcolor="#ffffff" width="550" height="400" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" wmode="transparent" /></object>','Flash Movie','嵌入 Flash 動畫','1','請輸入 Flash 動畫的 URL:','1','20');
INSERT INTO cdb_bbcodes VALUES ('22','1','0','qq','bb_qq.gif','<a href="http://wpa.qq.com/msgrd?V=1&Uin=1&Site=%5BDiscuz!%5D&Menu=yes" target="_blank"><img src="http://wpa.qq.com/pa?p=1:{1}:1" border="0"></a>','[qq]688888[/qq]','顯示 QQ 在線狀態,點這個圖標可以和他 (她) 聊天','1','請輸入顯示在線狀態 QQ 號碼:','1','21');
INSERT INTO cdb_bbcodes VALUES ('23','0','0','sup','bb_sup.gif','<sup>{1}</sup>','X[sup]2[/sup]','上標','1','請輸入上標文字:','1','22');
INSERT INTO cdb_bbcodes VALUES ('24','0','0','sub','bb_sub.gif','<sub>{1}</sub>','X[sub]2[/sub]','下標','1','請輸入下標文字:','1','23');