竹貓星球

代碼: 選擇全部

一般錯誤 
  
Error in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0 WHERE user_id = 2' at line 2

UPDATE phpbb_users SET user_posts = user_posts 0 WHERE user_id = 2

Line : 489
File : functions_post.php 
   

代碼: 選擇全部

function update_post_stats(&$mode, &$post_data, &$forum_id, &$topic_id, &$post_id, &$user_id) 
{ 
   global $db; 

   $sign = ($mode == 'delete') ? '- 1' : '+ 1'; 
/// 
/// Begin edit 
/// 
   $edited_sign = ($mode == 'delete') ? '0' : '+ 1'; 

/// 
/// End edit 
/// 

   $forum_update_sql = "forum_posts = forum_posts $sign"; 
   $topic_update_sql = ''; 

   if ($mode == 'delete') 
   { 
      if ($post_data['last_post']) 
      { 
         if ($post_data['first_post']) 
         { 
            $forum_update_sql .= ', forum_topics = forum_topics - 1'; 
         } 
         else 
         { 

            $topic_update_sql .= 'topic_replies = topic_replies - 1'; 

            $sql = "SELECT MAX(post_id) AS last_post_id 
               FROM " . POSTS_TABLE . " 
               WHERE topic_id = $topic_id"; 
            if (!($result = $db->sql_query($sql))) 
            { 
               message_die(GENERAL_ERROR, 'Error in deleting post', '', __LINE__, __FILE__, $sql); 
            } 

            if ($row = $db->sql_fetchrow($result)) 
            { 
               $topic_update_sql .= ', topic_last_post_id = ' . $row['last_post_id']; 
            } 
         } 

         if ($post_data['last_topic']) 
         { 
            $sql = "SELECT MAX(post_id) AS last_post_id 
               FROM " . POSTS_TABLE . " 
               WHERE forum_id = $forum_id"; 
            if (!($result = $db->sql_query($sql))) 
            { 
               message_die(GENERAL_ERROR, 'Error in deleting post', '', __LINE__, __FILE__, $sql); 
            } 

            if ($row = $db->sql_fetchrow($result)) 
            { 
               $forum_update_sql .= ($row['last_post_id']) ? ', forum_last_post_id = ' . $row['last_post_id'] : ', forum_last_post_id = 0'; 
            } 
         } 
      } 
      else if ($post_data['first_post']) 
      { 
         $sql = "SELECT MIN(post_id) AS first_post_id 
            FROM " . POSTS_TABLE . " 
            WHERE topic_id = $topic_id"; 
         if (!($result = $db->sql_query($sql))) 
         { 
            message_die(GENERAL_ERROR, 'Error in deleting post', '', __LINE__, __FILE__, $sql); 
         } 

         if ($row = $db->sql_fetchrow($result)) 
         { 
            $topic_update_sql .= 'topic_replies = topic_replies - 1, topic_first_post_id = ' . $row['first_post_id']; 
         } 
      } 
      else 
      { 
         $topic_update_sql .= 'topic_replies = topic_replies - 1'; 
      } 
   } 
   else if ($mode != 'poll_delete') 
   { 
      $forum_update_sql .= ", forum_last_post_id = $post_id" . (($mode == 'newtopic') ? ", forum_topics = forum_topics $sign" : ""); 
      $topic_update_sql = "topic_last_post_id = $post_id" . (($mode == 'reply') ? ", topic_replies = topic_replies $sign" : ", topic_first_post_id = $post_id"); 
   } 
   else 
   { 
      $topic_update_sql .= 'topic_vote = 0'; 
   } 

   $sql = "UPDATE " . FORUMS_TABLE . " SET 
      $forum_update_sql 
      WHERE forum_id = $forum_id"; 
   if (!$db->sql_query($sql)) 
   { 
      message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql); 
   } 

   if ($topic_update_sql != '') 
   { 
      $sql = "UPDATE " . TOPICS_TABLE . " SET 
         $topic_update_sql 
         WHERE topic_id = $topic_id"; 
      if (!$db->sql_query($sql)) 
      { 
         message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql); 
      } 
   } 

if ($mode != 'poll_delete') 
   { 
    
      $sql = "UPDATE " . USERS_TABLE . " 
         SET user_posts = user_posts $edited_sign 
         WHERE user_id = $user_id";        
    
          
      if (!$db->sql_query($sql, END_TRANSACTION)) 
      { 
         message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql); 
      } 
   } 

   return; 
}