2014年6月10日 星期二
2014 / 06 / 11 RO Shop for Discuz X3 研究中。
【 參 考 】
Discuz 開發平台：http://open.discuz.net/?ac=document&page=faq
Discuz 技術文庫：http://dev.discuz.org/wiki/index.php?title=%E9%A6%96%E9%A1%B5
Discuz X2.5數據庫：http://dev.discuz.org/wiki/index.php?title=Discuz!_X2.5%E6%95%B0%E6%8D%AE%E5%AD%97%E5%85%B8
2014 / 06 / 10 Discuz 有關自訂積分 -> 用戶統計表
表名：pre_common_member_count
UPdate：
UPDATE `pre_common_member_count` SET `uid`=[value-1],`extcredits1`=[value-2],`extcredits2`=[value-3],`extcredits3`=[value-4],`extcredits4`=[value-5],`extcredits5`=[value-6],`extcredits6`=[value-7],`extcredits7`=[value-8],`extcredits8`=[value-9],`friends`=[value-10],`posts`=[value-11],`threads`=[value-12],`digestposts`=[value-13],`doings`=[value-14],`blogs`=[value-15],`albums`=[value-16],`sharings`=[value-17],`attachsize`=[value-18],`views`=[value-19],`oltime`=[value-20],`todayattachs`=[value-21],`todayattachsize`=[value-22],`feeds`=[value-23],`follower`=[value-24],`following`=[value-25],`newfollower`=[value-26],`blacklist`=[value-27] WHERE 1
// LIB
DROP TABLE IF EXISTS pre_common_member_count;
CREATE TABLE pre_common_member_count (
uid mediumint(8) unsigned NOT NULL COMMENT '会员id',
extcredits1 int(10) NOT NULL default '0' COMMENT '声望',
extcredits2 int(10) NOT NULL default '0' COMMENT '金钱',
extcredits3 int(10) NOT NULL default '0' COMMENT '扩展',
extcredits4 int(10) NOT NULL default '0' COMMENT '扩展',
extcredits5 int(10) NOT NULL default '0' COMMENT '扩展',
extcredits6 int(10) NOT NULL default '0' COMMENT '扩展',
extcredits7 int(10) NOT NULL default '0' COMMENT '扩展',
extcredits8 int(10) NOT NULL default '0' COMMENT '扩展',
friends smallint(6) unsigned NOT NULL default '0' COMMENT '好友个数 home',
posts mediumint(8) unsigned NOT NULL default '0' COMMENT '帖子数',
threads mediumint(8) unsigned NOT NULL default '0' COMMENT '主题数',
digestposts smallint(6) unsigned NOT NULL default '0' COMMENT '精华数',
doings smallint(6) unsigned NOT NULL default '0' COMMENT '记录数',
blogs smallint(6) unsigned NOT NULL default '0' COMMENT '日志数',
albums smallint(6) unsigned NOT NULL default '0' COMMENT '相册数',
sharings smallint(6) unsigned NOT NULL default '0' COMMENT '分享数',
attachsize int(10) unsigned NOT NULL default '0' COMMENT '上传附件占用的空间 home',
views mediumint(8) unsigned NOT NULL default '0' COMMENT '空间查看数',
oltime smallint(6) unsigned NOT NULL default '0' COMMENT '在线时间',
todayattachs smallint(6) unsigned NOT NULL default '0' COMMENT '当天上传附件数',
todayattachsize int(10) unsigned NOT NULL default '0' COMMENT '当天上传附件容量',
feeds mediumint(8) unsigned NOT NULL default '0' COMMENT '广播数',
follower mediumint(8) unsigned NOT NULL default '0' COMMENT '听众数量',
following mediumint(8) unsigned NOT NULL default '0' COMMENT '收听数量',
newfollower mediumint(8) unsigned NOT NULL default '0' COMMENT '新增听众数量',
PRIMARY KEY (uid),
KEY posts (posts)
) ENGINE=MyISAM COMMENT='用户统计表';
2014年6月4日 星期三
訂閱：
文章 (Atom)