|
plid |
uid |
isnew |
pmnum |
lastupdate |
lastdateline |
plid |
authorid |
pmtype |
subject |
members |
min_max |
dateline |
lastmessage |
|
0 |
3 |
1491468155 |
1491468155 |
4 |
1 |
你好啊1！！！！ |
2 |
2_4 |
1491467872 |
a:3:{s:12:”lastauthorid”;s:1:”2″;s:10:”lastauthor”;s:3:”tlw”;s:11:”lastsummary”;s:24:”继续来发送消息了“;} |
|||
|
0 |
3 |
1491468155 |
1491468155 |
2 |
1 |
hao a!!!!! |
2 |
2_3 |
1491465880 |
a:3:{s:12:”lastauthorid”;s:1:”2″;s:10:”lastauthor”;s:3:”tlw”;s:11:”lastsummary”;s:24:”继续来发送消息了“;} |
会话列表
SELECT * FROM `discuz_v32`.pre_ucenter_pm_members m
LEFT JOIN `discuz_v32`.pre_ucenter_pm_lists t ON t.plid=m.plid
WHERE m.uid=‘2’
ORDER BY m.lastdateline DESC
LIMIT 0, 15
uc_pm_members 用户短消息状态表。
|
字段名 |
数据类型 |
默认值 |
允许非空 |
自动递增 |
备注 |
|
plid |
mediumint(8) unsigned |
0 |
NO |
会话列表ID |
|
|
uid |
mediumint(8) unsigned |
0 |
NO |
会话作者ID |
|
|
isnew |
tinyint(1) unsigned |
0 |
NO |
是否未读短消息 |
|
|
pmnum |
int(10) unsigned |
0 |
NO |
会话短消息数目 |
|
|
lastupdate |
int(10) unsigned |
0 |
NO |
上一次会话时间 |
|
|
lastdateline |
int(10) unsigned |
0 |
NO |
最后一次会话时间 |
uc_pm_lists 短消息会话表。
|
字段名 |
数据类型 |
默认值 |
允许非空 |
自动递增 |
备注 |
|
plid |
mediumint(8) unsigned |
NO |
是 |
会话列表ID |
|
|
authorid |
mediumint(8) unsigned |
0 |
NO |
会话作者ID |
|
|
pmtype |
tinyint(1) unsigned |
0 |
NO |
短消息类型 |
|
|
subject |
varchar(80) |
NO |
短消息标题 |
||
|
members |
smallint(5) unsigned |
0 |
NO |
短消息内容 |
|
|
min_max |
varchar(17) |
NO |
会话关系 |
||
|
dateline |
int(10) unsigned |
0 |
NO |
开始时间 |
|
|
lastmessage |
text |
NO |
最后一条短消息内容 |
tlw 的uid=2
lily 的uid=5
tlw发送消息给lily
[2017–04–06 17:11:20]Uclient: SELECT lastupdate FROM `discuz_v32`.pre_ucenter_pm_members WHERE uid=‘5’ ORDER BY lastupdate DESC LIMIT 1
[2017–04–06 17:11:20]Uclient: SELECT COUNT(*) FROM `discuz_v32`.pre_ucenter_pm_members m LEFT JOIN `discuz_v32`.pre_ucenter_pm_lists t ON m.plid=t.plid WHERE uid=‘5’ AND lastupdate>‘1491383480’ AND t.pmtype=1
[2017–04–06 17:11:20]Uclient: SELECT COUNT(*) FROM `discuz_v32`.pre_ucenter_pm_lists WHERE authorid=‘5’ AND dateline>‘1491383480’
[2017–04–06 17:11:20]Uclient: SELECT uid, blacklist FROM `discuz_v32`.pre_ucenter_memberfields WHERE uid IN (‘2’)
[2017–04–06 17:11:20]Uclient: SELECT uid FROM `discuz_v32`.pre_ucenter_members WHERE username IN(”)
[2017–04–06 17:11:20]Uclient: SELECT plid, min_max FROM `discuz_v32`.pre_ucenter_pm_lists WHERE min_max IN (‘2_5’)
[2017–04–06 17:11:20]Uclient: INSERT INTO `discuz_v32`.pre_ucenter_pm_indexes(plid) VALUES(‘3’)
[2017–04–06 17:11:20]Uclient: INSERT INTO `discuz_v32`.pre_ucenter_pm_messages_3(pmid, plid, authorid, message, dateline, delstatus) VALUES(‘8’, ‘3’, ‘5’, ‘我是lily（uid=5）我来给tlw(uid=2)发送消息！！！！！！‘, ‘1491469880’, 0)
[2017–04–06 17:11:20]Uclient: INSERT INTO `discuz_v32`.pre_ucenter_pm_members(plid, uid, isnew, pmnum, lastupdate, lastdateline) VALUES(‘3’, ‘2’, ‘1’, ‘1’, ‘0’, ‘1491469880’)
[2017–04–06 17:11:20]Uclient: UPDATE `discuz_v32`.pre_ucenter_pm_members SET isnew=1, pmnum=pmnum+1, lastdateline=‘1491469880’ WHERE plid=‘3’ AND uid=‘2’
[2017–04–06 17:11:20]Uclient: INSERT INTO `discuz_v32`.pre_ucenter_pm_members(plid, uid, isnew, pmnum, lastupdate, lastdateline) VALUES(‘3’, ‘5’, ‘0’, ‘1’, ‘1491469880’, ‘1491469880’)
[2017–04–06 17:11:20]Uclient: UPDATE `discuz_v32`.pre_ucenter_pm_members SET isnew=0, pmnum=pmnum+1, lastupdate=‘1491469880’, lastdateline=‘1491469880’ WHERE plid=‘3’ AND uid=‘5’
[2017–04–06 17:11:20]Uclient: UPDATE `discuz_v32`.pre_ucenter_pm_lists SET lastmessage=‘a:3:{s:12:\”lastauthorid\”;s:1:\”5\”;s:10:\”lastauthor\”;s:4:\”lily\”;s:11:\”lastsummary\”;s:70:\”我是lily（uid=5）我来给tlw(uid=2)发送消息！！！！！！\”;}’ WHERE plid=‘3’
[2017–04–06 17:11:20]Uclient: REPLACE INTO `discuz_v32`.pre_ucenter_newpm(uid) VALUES (‘2’)
本文原地址：https://www.eqiday.cn/261.html
郑重声明内容版权声明：除非注明，否则皆为本站原创文章。如有侵权联系进行删除！
