Discuz!X3.4本地附件全部修改为远程附件的方法

古城技术联盟

进行操作前，请备份数据库

5 \! P8 r( d! B. _/ L) D

一、本地转到远程

1、论坛后台–全局–上传设置–启用远程附件

2、将本地附件目录data/attachment里面的文件夹移动到远程服务器上

3、数据库执行sql语句

% v# p$ t& ?% r7 u# K3 Q

论坛：

1. update pre_forum_attachment_0 set remote=1 where remote=0;
     t+ A5 _  v$ l1 O, q
2. update pre_forum_attachment_1 set remote=1 where remote=0;
   . `# [0 j" O6 g  F
3. update pre_forum_attachment_2 set remote=1 where remote=0;
   
4. update pre_forum_attachment_3 set remote=1 where remote=0;
   
5. update pre_forum_attachment_4 set remote=1 where remote=0;
   
6. update pre_forum_attachment_5 set remote=1 where remote=0;
   ) h1 ]1 o7 O. C& }# f4 k+ B
7. update pre_forum_attachment_6 set remote=1 where remote=0;
   
8. update pre_forum_attachment_7 set remote=1 where remote=0;
   - G( A  a/ E' i! d' i
9. update pre_forum_attachment_8 set remote=1 where remote=0;
   
10. update pre_forum_attachment_9 set remote=1 where remote=0;

复制代码

门户：

1. update pre_portal_article_title set remote=1 where remote=0;
   
2. update pre_portal_attachment set remote=1 where remote=0;
   
3. update pre_portal_topic_pic set remote=1 where remote=0;

复制代码

- N9 [$ \7 q6 I9 _- x* l

相册：

. p  ?- q! ?8 N/ ^

相册表中的remote取值还有一种情况为remote=2(论坛附件图片保存到相册)

1. update pre_home_pic set remote=remote+1;

复制代码

3 Q0 z: s- ]# x' V  J

二、远程转到本地

后台关闭远程附件设置，将附件移动到本地服务器的 data/attachment目录后执行sql即可

, d, K) r( E8 e0 x" _* [  {

1. update pre_forum_attachment_0 set remote=0 where remote=1;
   
2. update pre_forum_attachment_1 set remote=0 where remote=1;
   
3. update pre_forum_attachment_2 set remote=0 where remote=1;
   . r# W: _; D# C7 c* M% t
4. update pre_forum_attachment_3 set remote=0 where remote=1;
   
5. update pre_forum_attachment_4 set remote=0 where remote=1;
   
6. update pre_forum_attachment_5 set remote=0 where remote=1;
   
7. update pre_forum_attachment_6 set remote=0 where remote=1;
   , Z3 Y( ?: d' T9 {3 T7 |
8. update pre_forum_attachment_7 set remote=0 where remote=1;
   
9. update pre_forum_attachment_8 set remote=0 where remote=1;
   - d( U* y# t$ G- I
10. update pre_forum_attachment_9 set remote=0 where remote=1;
    8 X! Y8 ]1 D- |4 s- G, u- r$ X
11. update pre_portal_article_title set remote=0 where remote=1;
    / B0 X( F  L% h9 ~' ]5 f1 h
12. update pre_portal_attachment set remote=0 where remote=1;
    / U0 G' I4 \2 W2 a% d
13. update pre_portal_topic_pic set remote=0 where remote=1;
    
14. update pre_home_pic set remote=remote-1;

复制代码

注：（where remote=0表示本地，where remote=1表示远程， pre_表示数据库表前缀）