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

从F到0 - From F to 0

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

Discuz! X 几条SQL语句实现取消、清除、清零论坛全部所有主题(图片、附件)的阅读权限

[复制链接]
发表于 2022-9-16 20:40:55 | 显示全部楼层 |阅读模式
当论坛需要批量取消阅读权限时,无需繁琐的人工批量操作,仅需几条SQL语句即可完成。

清除主题阅读权限:
1.png
  1. UPDATE pre_forum_thread SET readperm = 0;
复制代码

清除附件(图片)阅读权限:
2.png
3.png

  1. UPDATE pre_forum_attachment_0 SET readperm = 0;
  2. UPDATE pre_forum_attachment_1 SET readperm = 0;
  3. UPDATE pre_forum_attachment_2 SET readperm = 0;
  4. UPDATE pre_forum_attachment_3 SET readperm = 0;
  5. UPDATE pre_forum_attachment_4 SET readperm = 0;
  6. UPDATE pre_forum_attachment_5 SET readperm = 0;
  7. UPDATE pre_forum_attachment_6 SET readperm = 0;
  8. UPDATE pre_forum_attachment_7 SET readperm = 0;
  9. UPDATE pre_forum_attachment_8 SET readperm = 0;
  10. UPDATE pre_forum_attachment_9 SET readperm = 0;
复制代码

相关帖子

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

本版积分规则

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

腾讯云安全认证

GMT+8, 2024-3-29 07:28 , Processed in 0.442026 second(s), 22 queries .

Powered by Discuz! X3.4 Licensed

Copyright © 2001-2021, Tencent Cloud.

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