From: Lo?c C. <lo...@us...> - 2001-05-24 20:22:37
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/commands In directory usw-pr-cvs1:/tmp/cvs-serv16864/chat/lib/commands Modified Files: join.cmd.php3 Log Message: Forgotten to clean invitations to the target room Index: join.cmd.php3 =================================================================== RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/commands/join.cmd.php3,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -r1.5 -r1.6 *** join.cmd.php3 2001/05/22 20:40:34 1.5 --- join.cmd.php3 2001/05/24 20:22:35 1.6 *************** *** 232,235 **** --- 232,242 ---- $dbLink->query($queries[$i]); } + // Delete invitations sent to the current user for the room he is going to + // enter in + $dbLink->query("SELECT m_time FROM " . C_MSG_TBL . " WHERE username = 'SYS inviteTo' AND address = '$slashedNick' AND room = '$slashedTargetRoomName'"); + while (list($sentTime) = $dbLink->nextRecord()) + { + $dbLink->query("DELETE FROM " . C_MSG_TBL . " WHERE m_time = $sentTime AND (username = 'SYS inviteFrom' OR (username = 'SYS inviteTo' AND address = '$slashedNick'))"); + } // Update session data and enforce a complete refresh of the |