Discuz論壇教程之積分記錄表pre_common_credit_log中operation字段含義一覽,下面就是字段的一些解釋和介紹,趕緊來看看吧!
Discuz論壇積分記錄存在于表pre_common_credit_log中,表結構為:
C R E A T E T A B L E `pre_common_credit_log` (
`logid` mediumint(8) unsigned NOT N U L L A U T O_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' => '后臺積分獎懲清零',
新聞熱點
疑難解答