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' => '后台积分奖惩清零',
还没有评论,来说两句吧...