整合discuz X2.5后用户免激活设置

用户在其他应用注册后切换到论坛会提示激活，这是因为用户虽然注册到了ucenter但是在discuz X2.5中仍然没有用户的数据，只要在其他应用注册时同时将用户的相关数据写入到即可，相关表有:

pre_common_member 用户表
pre_common_member_status 用户状态表
pre_common_member_count 用户数据统计表
pre_common_member_profile 用户个人信息表
pre_common_member_field_forum 用户论坛设置表
pre_common_member_field_home 用户家园设置表
pre_common_syscache 系统缓存表
pre_common_stat 统计表

相关SQL如下：

REPLACE INTO pre_common_member SET `uid`='用户id' , `username`='用户名' , `password`='随机密码' , `email`='用户邮箱' , `adminid`='0' , `groupid`='10' , `regdate`='时间戳' , `emailstatus`='0' , `credits`='0' , `timeoffset`='9999';

REPLACE INTO pre_common_member_status SET `uid`='用户id' , `regip`='注册IP' , `lastip`='注册IP' , `lastvisit`='时间戳' , `lastactivity`='时间戳' , `lastpost`='0' , `lastsendmail`='0';

REPLACE INTO pre_common_member_count SET `uid`='用户id' , `extcredits1`='0' , `extcredits2`='0' , `extcredits3`='0' , `extcredits4`='0' , `extcredits5`='0' , `extcredits6`='0' , `extcredits7`='0' , `extcredits8`='0';

REPLACE INTO pre_common_member_profile SET `uid`='用户id';
REPLACE INTO pre_common_member_field_forum SET `uid`='用户id';
REPLACE INTO pre_common_member_field_home SET `uid`='用户id';
UPDATE pre_common_stat SET `register`=`register`+1 WHERE `daytime` = '当前日期如:20120624';

REPLACE INTO pre_common_syscache SET `cname`='userstats' , `ctype`='1' , `dateline`='时间戳' , `data`='a:2:{s:12:"totalmembers";s:1:"6";s:10:"newsetuser";s:6:"用户名";}';

 

最后一句中的a:2:{s:12:"totalmembers";s:1:"6";s:10:"newsetuser";s:6:"用户名";}是将数组序列化了，原数组形如：

$arr = array ( 'totalmembers' => '用户总数','newsetuser' => '用户名');