|
From: Paul S. O. <ps...@us...> - 2002-02-23 17:49:19
|
Update of /cvsroot/phpbb/phpBB2
In directory usw-pr-cvs1:/tmp/cvs-serv22517
Modified Files:
privmsg.php
Log Message:
Fix SQL problem bug #520293
Index: privmsg.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/privmsg.php,v
retrieving revision 1.84
retrieving revision 1.85
diff -C2 -r1.84 -r1.85
*** privmsg.php 19 Feb 2002 22:04:29 -0000 1.84
--- privmsg.php 23 Feb 2002 17:49:13 -0000 1.85
***************
*** 699,708 ****
}
! $sql = "UPDATE " . USERS_TABLE . "
! SET user_new_privmsg = user_new_privmsg - 1
! WHERE user_id IN ($update_pm_sql)";
! if ( !($result = $db->sql_query($sql)) )
{
! message_die(GENERAL_ERROR, "Couldn't update users new msg counters", "", __LINE__, __FILE__, $sql);
}
--- 699,711 ----
}
! if ( $update_pm_sql != "" )
{
! $sql = "UPDATE " . USERS_TABLE . "
! SET user_new_privmsg = user_new_privmsg - 1
! WHERE user_id IN ($update_pm_sql)";
! if ( !($result = $db->sql_query($sql)) )
! {
! message_die(GENERAL_ERROR, "Couldn't update users new msg counters", "", __LINE__, __FILE__, $sql);
! }
}
***************
*** 723,732 ****
}
! $sql = "UPDATE " . USERS_TABLE . "
! SET user_unread_privmsg = user_unread_privmsg - 1
! WHERE user_id IN ($update_pm_sql)";
! if ( !($result = $db->sql_query($sql)) )
{
! message_die(GENERAL_ERROR, "Couldn't update users new msg counters", "", __LINE__, __FILE__, $sql);
}
}
--- 726,738 ----
}
! if ( $update_pm_sql != "" )
{
! $sql = "UPDATE " . USERS_TABLE . "
! SET user_unread_privmsg = user_unread_privmsg - 1
! WHERE user_id IN ($update_pm_sql)";
! if ( !($result = $db->sql_query($sql)) )
! {
! message_die(GENERAL_ERROR, "Couldn't update users new msg counters", "", __LINE__, __FILE__, $sql);
! }
}
}
|