Discuz! Version X of the conversion tutorial between local and remote attachments

Before proceeding with the operation, please backup the database

1. Transfer from local to remote

Forum backend - Global - Upload settings - Enable remote attachments

Move the folder in the local attachment directory 'data/attachment' to a remote server

Execute SQL statements in the database

The forum's（0 represents local, 1 represents remote）

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;

The portal's

update pre_portal_article_title set remote=1 where remote=0;

update pre_portal_attachment set remote=1 where remote=0;

update pre_portal_topic_pic set remote=1 where remote=0;

The value of 'remote' in the album table can also be set to 'remote=2' (forum attachment images saved to the album)

update pre_home_pic set remote=remote+1;

2、 Remote transfer to local

Close the remote attachment settings in the background, move the attachment to the data/attachment directory on the local server, and then execute SQL

0 represents local, 1 represents remote

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;

gateway

update pre_portal_article_title set remote=0 where remote=1;

update pre_portal_attachment set remote=0 where remote=1;

update pre_portal_topic_pic set remote=0 where remote=1;

update pre_home_pic set remote=remote-1