phpcms v9 站内信测试报告

发信：

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member_detail` WHERE `userid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member_detail` WHERE `userid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_message` WHERE `send_from_id` = 'www'

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `username` = 'member3' LIMIT 1

INSERT INTO `phpcmsv9`.`v9_message`(`send_from_id`,`send_to_id`,`subject`,`content`,`message_time`,`status`,`folder`) VALUES ('www','member3','测试第二个站内信','测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容测试第二个站内信内容','1555236967','1','inbox')

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member_detail` WHERE `userid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member_detail` WHERE `userid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_message` WHERE `send_from_id` = 'www'

SELECT * FROM `phpcmsv9`.`v9_member_menu` WHERE `display` = '1' AND `parentid` = '0' ORDER BY listorder LIMIT 20

SELECT COUNT(*) AS num FROM `phpcmsv9`.`v9_message` WHERE `send_to_id` = 'www' AND `folder` = 'inbox' AND `status` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_message_group` WHERE `typeid` = '1' AND `groupid` = '2' AND `status` = '1'

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

SELECT `islock` FROM `phpcmsv9`.`v9_member` WHERE `userid` = '1' LIMIT 1

SELECT `data` FROM `phpcmsv9`.`v9_session` WHERE `sessionid` = 'ccq8cu7fck8u0qf812b2r55pa4' LIMIT 1

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

REPLACE INTO `phpcmsv9`.`v9_session`(`sessionid`,`userid`,`ip`,`lastvisit`,`roleid`,`groupid`,`m`,`c`,`a`,`data`) VALUES ('ccq8cu7fck8u0qf812b2r55pa4','1','127.0.0.1','1555236969','1','0','','','','code|s:4:"eklu";userid|s:1:"1";roleid|s:1:"1";pc_hash|s:6:"3VT5Pd";lock_screen|i:0;')

DELETE FROM `phpcmsv9`.`v9_session` WHERE `lastvisit`<1555235169

收信：

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member_detail` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member_detail` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT COUNT(*) AS num FROM `phpcmsv9`.`v9_message` WHERE `send_to_id` = 'member3' AND `folder` = 'inbox' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_message` WHERE `send_to_id` = 'member3' AND `folder` = 'inbox' ORDER BY messageid DESC LIMIT 0, 8

SELECT COUNT(*) AS num FROM `phpcmsv9`.`v9_message` WHERE `replyid` = '3' LIMIT 1

SELECT COUNT(*) AS num FROM `phpcmsv9`.`v9_message` WHERE `replyid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member_menu` WHERE `display` = '1' AND `parentid` = '0' ORDER BY listorder LIMIT 20

SELECT COUNT(*) AS num FROM `phpcmsv9`.`v9_message` WHERE `send_to_id` = 'member3' AND `folder` = 'inbox' AND `status` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_message_group` WHERE `typeid` = '1' AND `groupid` = '2' AND `status` = '1'

看信： 

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member_detail` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member_detail` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_message` WHERE `send_to_id` = 'member3' AND `messageid` = '3' LIMIT 1

UPDATE `phpcmsv9`.`v9_message` SET `status`='0' WHERE `messageid` = '3'

SELECT * FROM `phpcmsv9`.`v9_message` WHERE `messageid` = '3' LIMIT 1

SELECT COUNT(*) AS num FROM `phpcmsv9`.`v9_message` WHERE `replyid` = '3' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member_menu` WHERE `display` = '1' AND `parentid` = '0' ORDER BY listorder LIMIT 20

SELECT COUNT(*) AS num FROM `phpcmsv9`.`v9_message` WHERE `send_to_id` = 'member3' AND `folder` = 'inbox' AND `status` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_message_group` WHERE `typeid` = '1' AND `groupid` = '2' AND `status` = '1'

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `username` = 'www' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '1' LIMIT 1

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

SELECT `islock` FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT `data` FROM `phpcmsv9`.`v9_session` WHERE `sessionid` = 'tvpkvvoqrs09381hfa40623qk7' LIMIT 1

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

REPLACE INTO `phpcmsv9`.`v9_session`(`sessionid`,`userid`,`ip`,`lastvisit`,`roleid`,`groupid`,`m`,`c`,`a`,`data`) VALUES ('tvpkvvoqrs09381hfa40623qk7','0','127.0.0.1','1555237078','0','0','','','','code|s:4:"bgru";')

DELETE FROM `phpcmsv9`.`v9_session` WHERE `lastvisit`<1555235278

回信：

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member_detail` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member_detail` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_message` WHERE `send_from_id` = 'member3'

SELECT * FROM `phpcmsv9`.`v9_message` WHERE `send_to_id` = 'member3' AND `messageid` = '3' LIMIT 1

INSERT INTO `phpcmsv9`.`v9_message`(`send_from_id`,`message_time`,`status`,`folder`,`content`,`subject`,`replyid`,`send_to_id`) VALUES ('member3','1555237181','1','inbox','www 你好，我已经收到了你发的短信','Re: 测试第二个站内信','3','www')

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member_detail` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member_detail` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_message` WHERE `send_to_id` = 'member3' AND `messageid` = '3' LIMIT 1

UPDATE `phpcmsv9`.`v9_message` SET `status`='0' WHERE `messageid` = '3'

SELECT * FROM `phpcmsv9`.`v9_message` WHERE `messageid` = '3' LIMIT 1

SELECT COUNT(*) AS num FROM `phpcmsv9`.`v9_message` WHERE `replyid` = '3' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_message` WHERE `replyid` = '3' ORDER BY messageid ASC LIMIT 0, 10

SELECT * FROM `phpcmsv9`.`v9_member_menu` WHERE `display` = '1' AND `parentid` = '0' ORDER BY listorder LIMIT 20

SELECT COUNT(*) AS num FROM `phpcmsv9`.`v9_message` WHERE `send_to_id` = 'member3' AND `folder` = 'inbox' AND `status` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_message_group` WHERE `typeid` = '1' AND `groupid` = '2' AND `status` = '1'

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `username` = 'www' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '1' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `username` = 'member3' LIMIT 1

SELECT * FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

SELECT `islock` FROM `phpcmsv9`.`v9_member` WHERE `userid` = '4' LIMIT 1

SELECT `data` FROM `phpcmsv9`.`v9_session` WHERE `sessionid` = 'tvpkvvoqrs09381hfa40623qk7' LIMIT 1


SET character_set_connection='utf8',character_set_results='utf8',character_set_client=binary, sql_mode=''

REPLACE INTO `phpcmsv9`.`v9_session`(`sessionid`,`userid`,`ip`,`lastvisit`,`roleid`,`groupid`,`m`,`c`,`a`,`data`) VALUES ('tvpkvvoqrs09381hfa40623qk7','0','127.0.0.1','1555237182','0','0','','','','code|s:4:"ue3z";')

DELETE FROM `phpcmsv9`.`v9_session` WHERE `lastvisit`<1555235382