设为首页收藏本站淘宝杂货铺

从F到0 - From F to 0

 找回密码
 注册已关闭
搜索
查看: 339|回复: 0
收起左侧

Discuz! X 几条SQL语句实现全部清零并免费论坛所有的主题售价,付费积分下载的图片附件

[复制链接]
发表于 2023-1-28 07:44:45 | 显示全部楼层 |阅读模式
1.png
2.png
清除主题价格数据:
  1. UPDATE pre_forum_thread SET price = 0;
复制代码

3.png
清除图片附件价格数据:
  1. UPDATE pre_forum_attachment_0 SET price = 0;
  2. UPDATE pre_forum_attachment_1 SET price = 0;
  3. UPDATE pre_forum_attachment_2 SET price = 0;
  4. UPDATE pre_forum_attachment_3 SET price = 0;
  5. UPDATE pre_forum_attachment_4 SET price = 0;
  6. UPDATE pre_forum_attachment_5 SET price = 0;
  7. UPDATE pre_forum_attachment_6 SET price = 0;
  8. UPDATE pre_forum_attachment_7 SET price = 0;
  9. UPDATE pre_forum_attachment_8 SET price = 0;
  10. UPDATE pre_forum_attachment_9 SET price = 0;
复制代码

SQL语句执行后,所有付费查看的主题售价,需要积分下载的附件将全部清零并免费。

相关帖子

您需要登录后才可以回帖 登录 | 注册已关闭

本版积分规则

QQ|手机版|Archiver|从F到0 ( 蒙ICP备17002595号-1 )
蒙公网安备15010402000325号

腾讯云安全认证

GMT+8, 2024-3-29 23:18 , Processed in 0.434025 second(s), 22 queries .

Powered by Discuz! X3.4 Licensed

Copyright © 2001-2021, Tencent Cloud.

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