【结】message记录

xhsoft

我只想删除某个人的聊天记录

xhsoft

??

shangxy

某人发出去的聊天记录还是接受到的聊天记录？

xhsoft

发出去的

shangxy

你把mucmessage都清空了还有聊天记录？

xhsoft

是的

shangxy

看看mucroom这个表

xhsoft

还是有一些

shangxy

这3个是查询聊天记录用到的sql语句楼主可以研究一下：
  cLoadMessage = 'select d.* from (select a.roomid from mucmemberhistory a, mucmemberhistory b' +
                 ' where a.roomid = b.roomid' +
                 ' and a.jid = ''%S''' +
                 ' and b.jid= ''%S'') c, mucmessage d' +
                 ' where c.roomid = d.roomid order by d.MessageID desc';

  cQueryRoomID = 'select a.roomid from mucmemberhistory a, mucmemberhistory b' +
                 ' where a.roomid = b.roomid and a.jid = ''%S'' and b.jid= ''%S'' order by a.roomid desc';

  cQueryRoomMessage = 'select * from mucmessage where roomid = ''%S'' order by MessageID desc';

  cLoadMessageByRoom = 'select a.creationDate, a.username, a.body, a.html from mucMessage a, ' +
                       ' (select roomId from mucroom where name = ''%S'') b' +
                       ' where a.roomid = b.roomid order by a.MessageID desc';

xhsoft

哦，先结了吧