SimpleMachines / SMF2.1

			list ($count_posts) = $smcFunc['db_fetch_row']($request2);

			$smcFunc['db_free_result']($request2);

			if (empty($count_posts))

			{

				// Lets get the members that need their post count restored.

				$request2 = $smcFunc['db_query']('', '

					SELECT id_member, COUNT(id_msg) AS post_count

					FROM {db_prefix}messages

					WHERE id_topic = {int:topic}

						AND approved = {int:is_approved}

					GROUP BY id_member',

					array(

						'topic' => $row['id_topic'],

						'is_approved' => 1,

					)

				);

				while ($member = $smcFunc['db_fetch_assoc']($request2))

					updateMemberData($member['id_member'], array('posts' => 'posts + ' . $member['post_count']));

				$smcFunc['db_free_result']($request2);

			}

			// Log it.

			logAction('restore_topic', array('topic' => $row['id_topic'], 'board' => $row['id_board'], 'board_to' => $row['id_previous_board']));

		)

	) !== false;

	if ($createTemporary)

	{

		// outer join the members table on the temporary table finding the members that have a post count but no posts in the message table

		$request = $smcFunc['db_query']('', '

			SELECT mem.id_member, mem.posts

			FROM {db_prefix}members AS mem

			LEFT OUTER JOIN {db_prefix}tmp_maint_recountposts AS res

			ON res.id_member = mem.id_member

			WHERE res.id_member IS null

				AND mem.posts != {int:zero}',

			array(

				'zero' => 0,

			)

		);

		// set the post count to zero for any delinquents we may have found

		while ($row = $smcFunc['db_fetch_assoc']($request))

		{

			$smcFunc['db_query']('', '

				UPDATE {db_prefix}members

				SET posts = {int:zero}

				WHERE id_member = {int:row}',

				array(

					'row' => $row['id_member'],

					'zero' => 0,

				)

			);

		}

		$smcFunc['db_free_result']($request);

	}

	// all done

	unset($_SESSION['total_members']);