[phpMyChat CVS] CVS: phpMyChat-0.15/chat users_popup_low.php3,1.11,1.12 users_popup.php3,1.12,1.13

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

Update of /cvsroot/phpmychat/phpMyChat-0.15/chat
In directory usw-pr-cvs1:/tmp/cvs-serv424/chat

Modified Files:
	users_popup_low.php3 users_popup.php3 
Log Message:
Optimize a bit the first SQL query

Index: users_popup_low.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/users_popup_low.php3,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -r1.11 -r1.12
*** users_popup_low.php3	2001/04/19 21:05:04	1.11
--- users_popup_low.php3	2001/04/21 19:38:28	1.12
***************
*** 90,95 ****
  $dbLink			= new pmcDB;
  $roomQueryPart	= (dbSessionIsRegistered('currentRoom') && $dbSessionVars['roomType'] == 0)
! 				? '(m.type = 1 OR (m.type = 0 AND m.room =\'' . pmcSlashSingleQuotes($dbSessionVars['currentRoom']) . '\'))'
! 				: 'm.type = 1';
  
  
--- 90,95 ----
  $dbLink			= new pmcDB;
  $roomQueryPart	= (dbSessionIsRegistered('currentRoom') && $dbSessionVars['roomType'] == 0)
! 				? '(type = 1 OR (type = 0 AND room =\'' . pmcSlashSingleQuotes($dbSessionVars['currentRoom']) . '\'))'
! 				: 'type = 1';
  
  
***************
*** 108,117 ****
  if ($isBeep > 0)
  {
! 	$beepQuery		= 'SELECT m.m_time FROM ' . C_MSG_TBL . ' m '
  					. ' WHERE '
! 					.	'm.m_time > ' . $lastCheck . ' AND '
! 					.	'm.username = \'SYS enter\' AND '
  					.	$roomQueryPart . ' '
! 					. 'ORDER BY m.m_time DESC '
  					. 'LIMIT 1';
  	$dbLink->query($beepQuery);
--- 108,117 ----
  if ($isBeep > 0)
  {
! 	$beepQuery		= 'SELECT m_time FROM ' . C_MSG_TBL . ' '
  					. ' WHERE '
! 					.	'm_time > ' . $lastCheck . ' AND '
! 					.	'username = \'SYS enter\' AND '
  					.	$roomQueryPart . ' '
! 					. 'ORDER BY m_time DESC '
  					. 'LIMIT 1';
  	$dbLink->query($beepQuery);

Index: users_popup.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/users_popup.php3,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -r1.12 -r1.13
*** users_popup.php3	2001/04/19 21:05:04	1.12
--- users_popup.php3	2001/04/21 19:38:28	1.13
***************
*** 89,94 ****
  $dbLink			= new pmcDB;
  $roomQueryPart	= (dbSessionIsRegistered('currentRoom') && $dbSessionVars['roomType'] == 0)
! 				? '(m.type = 1 OR (m.type = 0 AND m.room =\'' . pmcSlashSingleQuotes($dbSessionVars['currentRoom']) . '\'))'
! 				: 'm.type = 1';
  
  
--- 89,94 ----
  $dbLink			= new pmcDB;
  $roomQueryPart	= (dbSessionIsRegistered('currentRoom') && $dbSessionVars['roomType'] == 0)
! 				? '(type = 1 OR (type = 0 AND room =\'' . pmcSlashSingleQuotes($dbSessionVars['currentRoom']) . '\'))'
! 				: 'type = 1';
  
  
***************
*** 107,116 ****
  if ($isBeep > 0)
  {
! 	$beepQuery		= 'SELECT m.m_time FROM ' . C_MSG_TBL . ' m '
  					. ' WHERE '
! 					.	'm.m_time > ' . $lastCheck . ' AND '
! 					.	'm.username = \'SYS enter\' AND '
  					.	$roomQueryPart . ' '
! 					. 'ORDER BY m.m_time DESC '
  					. 'LIMIT 1';
  	$dbLink->query($beepQuery);
--- 107,116 ----
  if ($isBeep > 0)
  {
! 	$beepQuery		= 'SELECT m_time FROM ' . C_MSG_TBL . ' '
  					. ' WHERE '
! 					.	'm_time > ' . $lastCheck . ' AND '
! 					.	'username = \'SYS enter\' AND '
  					.	$roomQueryPart . ' '
! 					. 'ORDER BY m_time DESC '
  					. 'LIMIT 1';
  	$dbLink->query($beepQuery);