SimpleMachines / SMF2.1

		$num_members = $modSettings['totalMembers'];

	// The database knows the amount when there are extra conditions.

	else

	{

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

			SELECT COUNT(*)

			FROM {db_prefix}members AS mem

			WHERE ' . $where,

			array_merge($where_params, array(

			))

		);

		list ($num_members) = $smcFunc['db_fetch_row']($request);

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

	}

	return $num_members;

}

{

	global $smcFunc;

	if ($member_name == null)

	{

		// Get the new user's name....

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

			SELECT real_name

			FROM {db_prefix}members

			WHERE id_member = {int:id_member}

			LIMIT 1',

			array(

				'id_member' => $memberID,

			)

		);

		list ($member_name) = $smcFunc['db_fetch_row']($request);

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

	}

	// This is really just a wrapper for making a new background task to deal with all the fun.

	$smcFunc['db_insert']('insert',

	if (is_null($id_member) && $user_info['is_guest'] == false)

		$id_member = $context['user']['id'];

	if (isset($id_member))

	{

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

			SELECT timezone

			FROM {db_prefix}members

			WHERE id_member = {int:id_member}',

			array(

				'id_member' => $id_member,

			)

		);

		list($timezone) = $smcFunc['db_fetch_row']($request);

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

	}

	if (empty($timezone) || !in_array($timezone, timezone_identifiers_list(DateTimeZone::ALL_WITH_BC)))

		$timezone = isset($modSettings['default_timezone']) ? $modSettings['default_timezone'] : date_default_timezone_get();