dz x2.5中与7.2的重点用户表大致对应

随手记录一下

 

cdb_members对应新的pre_common_member

cdb_memberfields对应 pre_common_profile

 

字段设置略有改动,如果做通行证程序的时候注意此问题

 

 

记录x2.5的注册sql流程

/*!\C binary *//*!*/;
SET @@session.character_set_client=63,@@session.collation_connection=33,@@session.collation_server=33/*!*/;
INSERT INTO `redhomebbs`.cdb_uc_members SET secques=”, username=’kanghq2′, password=’d200a9c48eb4c38177af6571778b1419′, email=’kanghq2@qq.com’, regip=’192.168.120.185′, regdate=’1334381182′, salt=’e63def’
/*!*/;
# at 4316
#120414 13:26:22 server id 1 end_log_pos 4436 Query thread_id=284 exec_time=0 error_code=0
SET TIMESTAMP=1334381182/*!*/;
INSERT INTO `redhomebbs`.cdb_uc_memberfields SET uid=’124151′
/*!*/;
# at 4436
#120414 13:26:22 server id 1 end_log_pos 4736 Query thread_id=283 exec_time=0 error_code=0
use redhomebbs/*!*/;
SET TIMESTAMP=1334381182/*!*/;
REPLACE INTO pre_common_member SET `uid`=124151 , `username`=’kanghq2′ , `password`=’7ce5916a14125dcad401b05f4d5c02e8′ , `email`=’kanghq2@qq.com’ , `adminid`=0 , `groupid`=10 , `regdate`=1334381182 , `credits`=0 , `timeoffset`=9999
/*!*/;
# at 4736
#120414 13:26:22 server id 1 end_log_pos 5003 Query thread_id=283 exec_time=0 error_code=0
SET TIMESTAMP=1334381182/*!*/;
REPLACE INTO pre_common_member_status SET `uid`=124151 , `regip`=’192.168.120.185′ , `lastip`=’192.168.120.185′ , `lastvisit`=1334381182 , `lastactivity`=1334381182 , `lastpost`=0 , `lastsendmail`=0
/*!*/;
# at 5003
#120414 13:26:22 server id 1 end_log_pos 5269 Query thread_id=283 exec_time=0 error_code=0
SET TIMESTAMP=1334381182/*!*/;
REPLACE INTO pre_common_member_count SET `uid`=124151 , `extcredits1`=0 , `extcredits2`=0 , `extcredits3`=0 , `extcredits4`=0 , `extcredits5`=0 , `extcredits6`=0 , `extcredits7`=0 , `extcredits8`=0
/*!*/;
# at 5269
#120414 13:26:22 server id 1 end_log_pos 5393 Query thread_id=283 exec_time=0 error_code=0
SET TIMESTAMP=1334381182/*!*/;
REPLACE INTO pre_common_member_profile SET `uid`=124151
/*!*/;
# at 5393
#120414 13:26:22 server id 1 end_log_pos 5521 Query thread_id=283 exec_time=0 error_code=0
SET TIMESTAMP=1334381182/*!*/;
REPLACE INTO pre_common_member_field_forum SET `uid`=124151
/*!*/;
# at 5521
#120414 13:26:22 server id 1 end_log_pos 5648 Query thread_id=283 exec_time=0 error_code=0
SET TIMESTAMP=1334381182/*!*/;
REPLACE INTO pre_common_member_field_home SET `uid`=124151
/*!*/;
# at 5648
#120414 13:26:22 server id 1 end_log_pos 5893 Query thread_id=283 exec_time=0 error_code=0
SET TIMESTAMP=1334381182/*!*/;
REPLACE INTO pre_common_syscache SET `cname`=’userstats’ , `ctype`=1 , `dateline`=1334381182 , `data`=’a:2:{s:12:\”totalmembers\”;i:56788;s:10:\”newsetuser\”;s:7:\”kanghq2\”;}’
/*!*/;
# at 5893
#120414 13:26:22 server id 1 end_log_pos 6157 Query thread_id=283 exec_time=0 error_code=0
SET TIMESTAMP=1334381182/*!*/;
DELETE FROM pre_common_session WHERE sid=’8ciZpP’ OR lastactivity<1334379982 OR (uid=’0′ AND ip1=’192′ AND ip2=’168′ AND ip3=’120′ AND ip4=’185′ AND lastactivity>1334381122) OR (uid=’124151′)
/*!*/;
# at 6157
#120414 13:26:22 server id 1 end_log_pos 6499 Query thread_id=283 exec_time=0 error_code=0
SET TIMESTAMP=1334381182/*!*/;
INSERT INTO pre_common_session SET `sid`=’8ciZpP’ , `ip1`=’192′ , `ip2`=’168′ , `ip3`=’120′ , `ip4`=’185′ , `uid`=’124151′ , `username`=’kanghq2′ , `groupid`=’10’ , `invisible`=’0′ , `action`=0 , `lastactivity`=’1334381024′ , `lastolupdate`=’1334380201′ , `fid`=0 , `tid`=0
/*!*/;
# at 6499
#120414 13:26:22 server id 1 end_log_pos 6656 Query thread_id=283 exec_time=0 error_code=0
SET TIMESTAMP=1334381182/*!*/;
INSERT INTO pre_common_statuser SET `uid`=124151 , `daytime`=’20120414′ , `type`=’login’
/*!*/;
# at 6656
#120414 13:26:22 server id 1 end_log_pos 6798 Query thread_id=283 exec_time=0 error_code=0
SET TIMESTAMP=1334381182/*!*/;
UPDATE pre_common_stat SET `login`=`login`+1 WHERE `daytime` = ‘20120414’
/*!*/;
# at 6798
#120414 13:26:22 server id 1 end_log_pos 6826 Intvar
SET INSERT_ID=27/*!*/;
# at 6826
#120414 13:26:22 server id 1 end_log_pos 7060 Query thread_id=283 exec_time=0 error_code=0
SET TIMESTAMP=1334381182/*!*/;
INSERT INTO pre_common_credit_rule_log SET `uid`=124151 , `rid`=’15’ , `fid`=0 , `total`=1 , `cyclenum`=1 , `dateline`=1334381182 , `extcredits1`=5 , `extcredits3`=0
/*!*/;
# at 7060
#120414 13:26:22 server id 1 end_log_pos 7219 Query thread_id=283 exec_time=0 error_code=0
SET TIMESTAMP=1334381182/*!*/;
UPDATE pre_common_member_count SET `extcredits1`=`extcredits1`+’5′ WHERE uid IN (‘124151’)
/*!*/;
# at 7219
#120414 13:26:22 server id 1 end_log_pos 7348 Query thread_id=283 exec_time=0 error_code=0
SET TIMESTAMP=1334381182/*!*/;
UPDATE pre_common_member SET `credits`=5 WHERE `uid`=124151
/*!*/;
# at 7348
#120414 13:26:22 server id 1 end_log_pos 7496 Query thread_id=283 exec_time=0 error_code=0
SET TIMESTAMP=1334381182/*!*/;
UPDATE pre_common_stat SET `register`=`register`+1 WHERE `daytime` = ‘20120414’
/*!*/;

Read More

dx2.5中从core剥离的get_title_page在哪里~

最近改造一个老版本的插件

 

列表页显示空白,开启debug之后报错如下

Call to undefined function get_title_page() in /root/www/XXXXX/source/plugin/weitie/weitie_forumdisplay.inc.php on line 128

 

查了dz的wiki,,get_title_page这个函数还是x2老版本的core包里面的函数

/**
 * 返回带第几页的title
 * @global  $_G
 * @param string $navtitle 源标题
 * @param int $page 页码
 * @return string
 */
function get_title_page($navtitle, $page){
	if($page > 1) {
    ......
}

 

x2.5的时候对core进行了很大的精简,

所以现在需要使用get_title_page,他已经被转移到helper去了

调用方法

helper_seo::get_title_page

即变为了helper_seo的静态方法,直接调用即可.

 

 

Read More