Discuz X3.2本地附件转远程附件和远程附件转本地附件的方法-Super Mouse

友情提醒：本文最后更新于6年前，文中所描述的信息可能已发生改变，请仔细核实。如有建议请评论留言

这个教程已经烂大街，但是网上采集来采集去内容乱七八糟，多走了很多弯路，之前不知道几句sql代码就能实现，差点花钱买插件替换帖子中的图片地址。。。
首先去目录下找到/data/wwwroot/config/config_global.php
编辑：

$_config['admincp']['runquery'] = '0';
//是否开启后台执行SQL语句 ↑

1 2	$_config['admincp']['runquery'] = '0'; //是否开启后台执行SQL语句 ↑

将= ‘0’; 改为 = ‘1’; 开启后台SQL升级
然后复制下面的代码进行远程转换，同时需要将本地/data/wwwroot/data/attachment/ 中的内容上传到远程附件服务器中。

update pre_forum_attachment_0 set remote=1 where remote=0;
update pre_forum_attachment_1 set remote=1 where remote=0;
update pre_forum_attachment_2 set remote=1 where remote=0;
update pre_forum_attachment_3 set remote=1 where remote=0;
update pre_forum_attachment_4 set remote=1 where remote=0;
update pre_forum_attachment_5 set remote=1 where remote=0;
update pre_forum_attachment_6 set remote=1 where remote=0;
update pre_forum_attachment_7 set remote=1 where remote=0;
update pre_forum_attachment_8 set remote=1 where remote=0;
update pre_forum_attachment_9 set remote=1 where remote=0;

update pre_forum_attachment_0 set remote=1 where remote=0;

update pre_forum_attachment_1 set remote=1 where remote=0;

update pre_forum_attachment_2 set remote=1 where remote=0;

update pre_forum_attachment_3 set remote=1 where remote=0;

update pre_forum_attachment_4 set remote=1 where remote=0;

update pre_forum_attachment_5 set remote=1 where remote=0;

update pre_forum_attachment_6 set remote=1 where remote=0;

update pre_forum_attachment_7 set remote=1 where remote=0;

update pre_forum_attachment_8 set remote=1 where remote=0;

update pre_forum_attachment_9 set remote=1 where remote=0;

上面的SQL语句实现了论坛附件 forum 转换成远程附件，关闭方法如下：

update pre_forum_attachment_0 set remote=0 where remote=1;
update pre_forum_attachment_1 set remote=0 where remote=1;
update pre_forum_attachment_2 set remote=0 where remote=1;
update pre_forum_attachment_3 set remote=0 where remote=1;
update pre_forum_attachment_4 set remote=0 where remote=1;
update pre_forum_attachment_5 set remote=0 where remote=1;
update pre_forum_attachment_6 set remote=0 where remote=1;
update pre_forum_attachment_7 set remote=0 where remote=1;
update pre_forum_attachment_8 set remote=0 where remote=1;
update pre_forum_attachment_9 set remote=0 where remote=1;

update pre_forum_attachment_0 set remote=0 where remote=1;

update pre_forum_attachment_1 set remote=0 where remote=1;

update pre_forum_attachment_2 set remote=0 where remote=1;

update pre_forum_attachment_3 set remote=0 where remote=1;

update pre_forum_attachment_4 set remote=0 where remote=1;

update pre_forum_attachment_5 set remote=0 where remote=1;

update pre_forum_attachment_6 set remote=0 where remote=1;

update pre_forum_attachment_7 set remote=0 where remote=1;

update pre_forum_attachment_8 set remote=0 where remote=1;

update pre_forum_attachment_9 set remote=0 where remote=1;

将forum转换成本地附件

Discuz X3.2本地附件转远程附件和远程附件转本地附件的方法

Rat

相关推荐

留下您的评论抢沙发

中国金鱼

置顶推荐

觉得文章有用就打赏一下文章作者

非常感谢你的打赏，我们将继续给力更多优质内容，让我们一起创建更加美好的网络世界！

支付宝扫一扫打赏

微信扫一扫打赏

Rat