[phpMyChat CVS] CVS: phpMyChat-0.15/chat/lib/commands join.cmd.php3,1.10,1.11 invite.cmd.php3,1.13,1.14

[Lo?c C. <lo...@us...>]

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'"
  					. ')';