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);
|
