[Phpbb-checkins] CVS: phpBB2 privmsg.php,1.84,1.85

[Paul S. O. <ps...@us...>]

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