总积分是衡量用户级别的唯一标准,您可以在此设定用户的总积分计算公式,其中 posts 代表发帖数 (主题 + 回复数);threads 代表用户发表的主题数;digestposts 代表精华帖数;oltime 代表用户总在线时间(小时);friends 代表好友数;doings 代表发表的记录数;blogs 代表发表的日志数;albums 代表上传的相册数;sharings 代表发表的分享数;extcredits1~extcredits8 分别代表上述 8 个自定义积分。公式中可使用包括 + - * / () 在内的运算符号
默认:
发帖数+精华帖数*5+威望*2+金钱+贡献
表达式:
posts+digestposts*5+extcredits1*2+extcredits2+extcredits3
设置:
全局--积分设置--查看积分规则
积分排名:
select uid,username,credits from pre_common_member;
积分记录:
root@iZ2513jnt1xZ:/var/log/mysql# tail -10000 mysql.log|grep credits|grep SET|grep UPDATE
2021-07-02T16:44:30.088098Z 5947 Query UPDATE pre_common_member_count SET `extcredits2`=`extcredits2`+'60' WHERE uid IN ('5')
2021-07-02T16:44:59.474907Z 5986 Query UPDATE pre_common_member SET `credits`='9' , `groupid`='10' WHERE `uid`='5'
2021-07-02T16:52:27.490601Z 6334 Query UPDATE pre_common_member_count SET `extcredits2`=`extcredits2`+'30' WHERE uid IN ('5')
2021-07-02T16:52:27.492155Z 6334 Query UPDATE pre_common_member SET `credits`='39' WHERE `uid`='5'