Discuz!官方免费开源建站系统

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索

新人求救,关于DVBBS7.1 SP1 转 Discuz 的难题!

[复制链接]
三口一瓶 发表于 2006-5-26 22:07:09 | 显示全部楼层 |阅读模式
本人打算将执掌了三年的西北地区最大的娱乐论坛转换成 Discuz 论坛,可是论坛的帖子中有很多会员上传的附件以[mp][/mp]、[upload][/upload]形式存在,数据转换后附件都无法正常使用了,恳请各位提供一个好的办法转换,谢谢。

搜傲娱乐论坛:http://www.soao.net
bmli 发表于 2006-5-27 02:15:23 | 显示全部楼层
更新数据库,执行一些查询语句,作全局替换操作:)
回复

使用道具 举报

bmli 发表于 2006-5-27 02:26:57 | 显示全部楼层
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:28:16 | 显示全部楼层
这样就可以解决你的一些问题了。
回复

使用道具 举报

 楼主| 三口一瓶 发表于 2006-5-27 13:01:58 | 显示全部楼层
原帖由 bmli 于 2006-5-27 02:26 发表

谢谢,现在去试试
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )star

GMT+8, 2024-12-25 15:44 , Processed in 0.022761 second(s), 4 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回顶部 返回列表