$query = "
			UPDATE
				com_forum_list,
				com_subboard_list,
				com_board_list,
				page_user_data
			SET
				forum_post_number = forum_post_number + 1,
				forum_thread_number = forum_thread_number + 1,
				forum_last_poster = ".$session->user_id.",
				forum_last_post_at = NOW(),
				forum_last_post = LAST_INSERT_ID(),
				forum_last_thread = ".$new_thread_id.",
				subboard_post_number = subboard_post_number + 1,
				subboard_thread_number = subboard_thread_number + 1,
				subboard_last_poster = ".$session->user_id.",
				subboard_last_post = LAST_INSERT_ID(),
				subboard_last_post_at = NOW(),
				subboard_last_thread = ".$new_thread_id.",
				board_post_number = board_post_number + 1,
				board_thread_number = board_thread_number + 1,
				board_last_poster = ".$session->user_id.",
				board_last_post = LAST_INSERT_ID(),
				board_last_post_at = NOW(),
				board_last_thread = ".$new_thread_id.",
				user_post_number = user_post_number + 1,
				user_thread_number = user_thread_number + 1
			WHERE
				forum_id = ".$_GET['forum_id']." AND
				forum_parent = subboard_id AND
				subboard_parent = board_id AND
				user_id = ".$session->user_id."
		";

		if (!$result = mysql_query($query))
		{
			die("mysql error: ".mysql_error());
		}

            forum_last_post = LAST_INSERT_ID(), 
            forum_last_thread = ".$new_thread_id.", 
            subboard_post_number = subboard_post_number + 1, 
            subboard_thread_number = subboard_thread_number + 1,

            com_forum_list.forum_last_post = LAST_INSERT_ID(), 
            com_forum_list.forum_last_thread = ".$new_thread_id.", 
            com_subboard_list.subboard_post_number = com_subboard_list.subboard_post_number + 1, 
            com_subboard_list.subboard_thread_number = com_subboard_list.subboard_thread_number + 1,

/*update forum*/

		$query = "
			UPDATE
				com_forum_list
			SET
				com_forum_list.forum_post_number = com_forum_list.forum_post_number + 1,
				com_forum_list.forum_thread_number = com_forum_list.forum_thread_number + 1,
				com_forum_list.forum_last_poster = ".$session->user_id.",
				com_forum_list.forum_last_post_at = NOW(),
				com_forum_list.forum_last_post = LAST_INSERT_ID(),
				com_forum_list.forum_last_thread = ".$new_thread_id."
			WHERE
				com_forum_list.forum_id = ".$_GET['forum_id']."
		";


		if (!$result = mysql_query($query))
		{
			mdie("mysql error(3): ".mysql_error());
		}

/*update subboard*/

		$query = "
			SELECT
				forum_parent
			FROM
				com_forum_list
			WHERE
				forum_id = ".$_GET['forum_id']."
		";

		if (!$result = mysql_query($query))
		{
			mdie("mysql error(4): ".mysql_error());
		}

		$temp = mysql_fetch_assoc($result);
		$forum_parent = $temp['forum_parent'];

		$query = "
			UPDATE
				com_subboard_list
			SET
				com_subboard_list.subboard_post_number = com_subboard_list.subboard_post_number + 1,
				com_subboard_list.subboard_thread_number = com_subboard_list.subboard_thread_number + 1,
				com_subboard_list.subboard_last_poster = ".$session->user_id.",
				com_subboard_list.subboard_last_post = LAST_INSERT_ID(),
				com_subboard_list.subboard_last_post_at = NOW(),
				com_subboard_list.subboard_last_thread = ".$new_thread_id."
			WHERE
				 com_subboard_list.subboard_id = ".$forum_parent."
		";

		if (!$result = mysql_query($query))
		{
			mdie("mysql error(5): ".mysql_error());
		}

/*update board*/

		$query = "
			SELECT
				subboard_parent
			FROM
				com_subboard_list
			WHERE
				subboard_id = ".$forum_parent."
		";

		if (!$result = mysql_query($query))
		{
			mdie("mysql error(6): ".mysql_error());
		}

		$temp = mysql_fetch_assoc($result);
		$subboard_parent = $temp['subboard_parent'];

		$query = "
			UPDATE
				com_board_list
			SET
				com_board_list.board_post_number = com_board_list.board_post_number + 1,
				com_board_list.board_thread_number = com_board_list.board_thread_number + 1,
				com_board_list.board_last_poster = ".$session->user_id.",
				com_board_list.board_last_post = LAST_INSERT_ID(),
				com_board_list.board_last_post_at = NOW(),
				com_board_list.board_last_thread = ".$new_thread_id."
			WHERE
				com_board_list.board_id = ".$subboard_parent."
		";

		if (!$result = mysql_query($query))
		{
			mdie("mysql error(7): ".mysql_error());
		}

/*update user data*/

		$query = "
			UPDATE
				page_user_data
			SET
				page_user_data.user_post_number = page_user_data.user_post_number + 1,
				page_user_data.user_thread_number = page_user_data.user_thread_number + 1
			WHERE
				page_user_data.user_id = ".$session->user_id."
		";

		if (!$result = mysql_query($query))
		{
			mdie("mysql error(8): ".mysql_error());
		}