新人求救，关于DVBBS7.1 SP1 转 Discuz 的难题！

本人打算将执掌了三年的西北地区最大的娱乐论坛转换成 Discuz 论坛，可是论坛的帖子中有很多会员上传的附件以[mp][/mp]、[upload][/upload]形式存在，数据转换后附件都无法正常使用了，恳请各位提供一个好的办法转换，谢谢。

搜傲娱乐论坛：http://www.soao.net

更新数据库，执行一些查询语句，作全局替换操作：）

UPDATE cdb_threads SET subject = REPLACE(subject, '[mp];', '[wmv]');
UPDATE cdb_threads SET subject = REPLACE(subject, '[upload]', '[url=');
UPDATE cdb_threads SET subject = REPLACE(subject, '[/mp]', '[/wmv]');
UPDATE cdb_threads SET subject = REPLACE(subject, '[/upload]', '[/url]');

UPDATE cdb_posts SET subject = REPLACE(subject, '[mp];', '[wmv]');
UPDATE cdb_posts SET subject = REPLACE(subject, '[upload]', '[url=');
UPDATE cdb_posts SET subject = REPLACE(subject, '[/mp]', '[/wmv]');
UPDATE cdb_posts SET subject = REPLACE(subject, '[/upload]', '[/url]');

UPDATE cdb_posts SET message = REPLACE(message, '[mp];', '[wmv]');
UPDATE cdb_posts SET message = REPLACE(message, '[upload]', '[url=');
UPDATE cdb_posts SET message = REPLACE(message, '[/mp]', '[/wmv]');
UPDATE cdb_posts SET message = REPLACE(message, '[/upload]', '[/url]');

UPDATE cdb_pms SET subject = REPLACE(subject, '[mp];', '[wmv]');
UPDATE cdb_pms SET subject = REPLACE(subject, '[upload]', '[url=');
UPDATE cdb_pms SET subject = REPLACE(subject, '[/mp]', '[/wmv]');
UPDATE cdb_pms SET subject = REPLACE(subject, '[/upload]', '[/url]');

UPDATE cdb_pms SET message = REPLACE(message, '[mp];', '[wmv]');
UPDATE cdb_pms SET message = REPLACE(message, '[upload]', '[url=');
UPDATE cdb_pms SET message = REPLACE(message, '[/mp]', '[/wmv]');
UPDATE cdb_pms SET message = REPLACE(message, '[/upload]', '[/url]');

这样就可以解决你的一些问题了。

原帖由 bmli 于 2006-5-27 02:26 发表

谢谢，现在去试试