Update of /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/index_libs
In directory usw-pr-cvs1:/tmp/cvs-serv12055/chat/lib/index_libs
Modified Files:
do_enter_db_work.lib.php3
Log Message:
added m_id in the pmc_messages table to fix messages loss in the message frame
Index: do_enter_db_work.lib.php3
===================================================================
RCS file: /cvsroot/phpmychat/phpMyChat-0.15/chat/lib/index_libs/do_enter_db_work.lib.php3,v
retrieving revision 1.23
retrieving revision 1.24
diff -C2 -r1.23 -r1.24
*** do_enter_db_work.lib.php3 2001/06/30 20:42:31 1.23
--- do_enter_db_work.lib.php3 2001/11/26 20:22:16 1.24
***************
*** 158,162 ****
// if m_time and rooms aren'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 welcome'");
$aQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
. '(room, username, m_time, address, color, msg_original, msg_enhanced) '
--- 158,162 ----
// if m_time and rooms aren't null to enforce the use of existing
// indexes)
! $dbLink->query("DELETE FROM " . C_MSG_TBL . " WHERE m_id > 0 AND room > '' AND address = '$slashedNick' AND username = 'SYS welcome'");
$aQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
. '(room, username, m_time, address, color, msg_original, msg_enhanced) '
***************
*** 201,205 ****
// Deletes the old welcome messages sent to the current user (check if
// m_time and rooms aren'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 welcome'");
$aQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
. '(room, username, m_time, address, color, msg_original, msg_enhanced) '
--- 201,205 ----
// Deletes the old welcome messages sent to the current user (check if
// m_time and rooms aren't null to enforce the use of existing indexes)
! $dbLink->query("DELETE FROM " . C_MSG_TBL . " WHERE m_id > 0 AND room > '' AND address = '$slashedNick' AND username = 'SYS welcome'");
$aQuery = 'INSERT INTO ' . C_MSG_TBL . ' '
. '(room, username, m_time, address, color, msg_original, msg_enhanced) '
***************
*** 264,268 ****
* 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'");
?>
--- 264,268 ----
* enforce the use of existing indexes)
*/
! $dbLink->query("DELETE FROM " . C_MSG_TBL . " WHERE m_id > 0 AND room = '\\\*\\\' AND address = '$slashedNick' AND username = 'SYS inviteTo'");
?>
|
