Discuz!批量设置附件售价方法

那爱

Discuz!批量设置附件售价，也可以批量清零附件售价。在Discuz! X3.1测试成功，在其他环境有待测试。
1.建议您先备份一下数据库，防止执行出错导致的数据丢失
2.在discuz后台——站长——数据库——升级，执行这行代码
需要注意的是，这行代码你需要进行一些修改
1.请您将tuzi123_数据表前缀修改为你的discuz数据表前缀，默认是pre_
2.修改set price = 0后面的0为你要设置的discuz附件售价，如果你要清零附件售价，请填写0

1. ccode('update tuzi123_forum_attachment_0 set price = 0;
   
2. update tuzi123_forum_attachment_1 set price = 0;
   
3. update tuzi123_forum_attachment_2 set price = 0;
   
4. update tuzi123_forum_attachment_3 set price = 0;
   
5. update tuzi123_forum_attachment_4 set price = 0;
   
6. update tuzi123_forum_attachment_5 set price = 0;
   
7. update tuzi123_forum_attachment_6 set price = 0;
   
8. update tuzi123_forum_attachment_7 set price = 0;
   
9. update tuzi123_forum_attachment_8 set price = 0;
   
10. update tuzi123_forum_attachment_9 set price = 0')

复制代码

3.更新Discuz缓存，即可