|
From: Lo?c C. <lo...@us...> - 2001-06-30 20:42:34
|
Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/commands
In directory usw-pr-cvs1:/tmp/cvs-serv11653/chat/lib/commands
Modified Files:
join.cmd.php3 invite.cmd.php3
Log Message:
Invitations were not displayed
Index: join.cmd.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/commands/join.cmd.php3,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -r1.10 -r1.11
*** join.cmd.php3 2001/06/30 14:05:29 1.10
--- join.cmd.php3 2001/06/30 20:42:31 1.11
***************
*** 231,238 ****
$dbLink->query($queries[$i]);
}
! // Delete invitations sent to the current user for the room he is going to
! // enter in (check if m_time isn't null to enforce the use of existing
! // indexes)
! $dbLink->query("DELETE FROM " . C_MSG_TBL . " WHERE m_time != '' AND room = '$slashedTargetRoomName' AND address = '$slashedNick' AND username = 'SYS inviteTo'");
// 2. Rooms table
--- 231,237 ----
$dbLink->query($queries[$i]);
}
! // Delete invitations sent to the current user (check if m_time isn't null
! // to enforce the use of existing indexes)
! $dbLink->query("DELETE FROM " . C_MSG_TBL . " WHERE m_time != '' AND room = '\\\*\\\' AND address = '$slashedNick' AND username = 'SYS inviteTo'");
// 2. Rooms table
Index: invite.cmd.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/commands/invite.cmd.php3,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -r1.13 -r1.14
*** invite.cmd.php3 2001/06/10 14:57:48 1.13
--- invite.cmd.php3 2001/06/30 20:42:31 1.14
***************
*** 66,77 ****
. '(room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
. 'VALUES ('
! . '\'' . $slashedCurrentRoomName . '\', '
! . '\'SYS inviteTo\', '
. $latin1 . ', '
. '%TIME%, '
! . '\'%ADDRESSEE%\', '
! . '\'#666699\', '
! . '\'' . $theMessage . '\', '
! . '\'' . $theMessage . '\''
. ')';
--- 66,77 ----
. '(room, username, latin1, m_time, address, color, msg_original, msg_enhanced) '
. 'VALUES ('
! . "'\\\*\\\', "
! . "'SYS inviteTo', "
. $latin1 . ', '
. '%TIME%, '
! . "'%ADDRESSEE%', "
! . "'#666699', "
! . "'$theMessage', "
! . "'$theMessage'"
. ')';
|