discuz运营一些常用sql语句

    清零所有附件下载次数

    UPDATE pre_forum_attachment SET downloads = 0

    清零所有附件下载用户记录

    同:清空所有用户的积分变化的记录

    清零所有帖子的访问次数

    UPDATE pre_forum_thread SET views = 0

    清空所有用户的积分变化的记录【不是把所有用户的积分变成0,只是每次积分变化的记录】

    DELETE FROM pre_common_credit_log

    清空所有系统提醒消息

    DELETE FROM pre_home_notification

    清空所有站内短消息

    DELETE FROM `pre_ucenter_pm_lists` WHERE 1 ;
    DELETE FROM `pre_ucenter_pm_members` WHERE 1 ;
    DELETE FROM `pre_ucenter_pm_members` WHERE 1 ;
    DELETE FROM `pre_ucenter_pm_messages_0` WHERE 1 ;
    DELETE FROM `pre_ucenter_pm_messages_1` WHERE 1 ;
    DELETE FROM `pre_ucenter_pm_messages_2` WHERE 1 ;
    DELETE FROM `pre_ucenter_pm_messages_3` WHERE 1 ;
    DELETE FROM `pre_ucenter_pm_messages_4` WHERE 1 ;
    DELETE FROM `pre_ucenter_pm_messages_5` WHERE 1 ;
    DELETE FROM `pre_ucenter_pm_messages_6` WHERE 1 ;
    DELETE FROM `pre_ucenter_pm_messages_7` WHERE 1 ;
    DELETE FROM `pre_ucenter_pm_messages_8` WHERE 1 ;
    DELETE FROM `pre_ucenter_pm_messages_9` WHERE 1 ;
    avatar
    • 本文由 发表于 2018年11月16日00:26:18
    • 转载请务必保留本文链接:https://www.huojunqiang.com/80.html
    discuz只允许管理员和自己查看个人资料 discuz

    discuz只允许管理员和自己查看个人资料

    discuz的个人资料经常有人写了较详细的个人隐私资料或者一些垃圾广告信息,为了保护个人隐私和防止垃圾信息传播,需要修改一下discuz源码禁止游客和其他用户查看,只让管理员和用户自己查看自己的资料。...
    Discuz! 内置全局变量整理 discuz

    Discuz! 内置全局变量整理

    浏览次数:$_G 回复次数:$_G 部分全局变量整理: 风格变量篇 $_G => Array ( $_G => 当前风格ID $_G => 当前风格名 $_G => 当前模板体...