To fix this open /includes/mcp/mcp_post.php and find:
Code: Select all
$sql = 'UPDATE ' . USERS_TABLE . '
SET user_posts = user_posts - 1
WHERE user_id = ' . $post_info['user_id'] .'
AND user_posts > 0';
$db->sql_query($sql);
$sql = 'UPDATE ' . USERS_TABLE . '
SET user_posts = user_posts + 1
WHERE user_id = ' . $userdata['user_id'];
$db->sql_query($sql);
Code: Select all
/*** 2013-10-15 BEGIN AmigoJack
Also consider users topic count ***/
if( $post_info['topic_first_post_id']== $post_id ) {
$sql= 'UPDATE '. USERS_TABLE. '
SET user_topics= user_topics- 1
WHERE user_id= '. $post_info['user_id']. '
AND user_topics> 0';
$db-> sql_query( $sql );
$sql= 'UPDATE '. USERS_TABLE. '
SET user_topics= user_topics+ 1
WHERE user_id= '. $userdata['user_id'];
$db-> sql_query( $sql );
}
/*** 2013-10-15 END ***/