竹貓星球

代碼: 選擇全部

//
// Update post stats and details
//
function update_post_stats(&$mode, &$post_data, &$forum_id, &$topic_id, &$post_id, &$user_id)
{
	global $db;
	$sign = ($mode == 'delete') ? '- 1' : '+ 1';

代碼: 選擇全部

	$money ='+ 0';
	if($mode == 'newtopic')
	{
		$money ='+ 30'; // newtopic get money value
	}elseif($mode == 'reply')
	{
		$money ='+ 20'; // reply get money value
	}

代碼: 選擇全部

			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 ($post_data['first_post'])
			{
				$forum_update_sql .= ', forum_topics = forum_topics - 1';
				$money ='- 30';  //delete 主題
			}
			else
			{
				$topic_update_sql .= 'topic_replies = topic_replies - 1';
				$money ='- 20'; //delete 回覆
				$sql = "SELECT MAX(post_id) AS last_post_id
					FROM " . POSTS_TABLE . " 
					WHERE topic_id = $topic_id";

代碼: 選擇全部

		$sql = "UPDATE " . USERS_TABLE . "
			SET user_posts = user_posts $sign
			WHERE user_id = $user_id";

代碼: 選擇全部

		$sql = "UPDATE " . USERS_TABLE . "
			SET user_posts = user_posts $sign , user_money = user_money $money
			WHERE user_id = $user_id";