Discuz!积分记录表pre_common_credit_log中operation字段含义一览

来源：互联网发布：深圳市软件行业协会编辑：程序博客网时间：2024/05/29 17:04

Discuz!积分记录存在于表pre_common_credit_log中，表结构为：

CREATE TABLE `pre_common_credit_log` (  `logid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0',  `operation` char(3) NOT NULL DEFAULT '',  `relatedid` int(10) unsigned NOT NULL,  `dateline` int(10) unsigned NOT NULL,  `extcredits1` int(10) NOT NULL,  `extcredits2` int(10) NOT NULL,  `extcredits3` int(10) NOT NULL,  `extcredits4` int(10) NOT NULL,  `extcredits5` int(10) NOT NULL,  `extcredits6` int(10) NOT NULL,  `extcredits7` int(10) NOT NULL,  `extcredits8` int(10) NOT NULL,  PRIMARY KEY (`logid`),  KEY `uid` (`uid`),  KEY `operation` (`operation`),  KEY `relatedid` (`relatedid`),  KEY `dateline` (`dateline`)) ;

uid：对应积分变更的用户id；

relatedid：积分官更关联内容id

dateline：积分变更时间；

extcredits1-8：对应积分变更数额；

operation：积分变更项目类型，参考下方列表：

'TRC' => '任务奖励积分','RTC' => '发表悬赏主题扣除积分','RAC' => '最佳答案获取悬赏积分','MRC' => '道具随即获取积分','TFR' => '积分转账转出','RCV' => '积分转账接收','CEC' => '积分兑换','ECU' => '通过 UCenter 兑换积分支出','SAC' => '出售附件获得积分','BAC' => '购买附件支出积分','PRC' => '帖子被评分所得积分','RSC' => '评分帖子扣除自己的积分','STC' => '出售主题获得积分','BTC' => '购买主题支出积分','AFD' => '购买积分即积分充值','UGP' => '购买扩展用户组','RPC' => '举报功能中的奖惩','ACC' => '参与活动扣除积分','RCT' => '回帖奖励','RCA' => '回帖中奖','RCB' => '返还回帖奖励积分','CDC' => '卡密充值','BMC' => '购买道具','AGC' => '获得红包','BGC' => '埋下红包','RGC' => '回收红包','RKC' => '竞价排名','BME' => '购买勋章','RPR' => '后台积分奖惩','RPZ' => '后台积分奖惩清零',

0 0