SimpleMachines / SMF2.1

 * @param array $where_parameters The parameters for the WHERE clause

 * @return int The number of group requests

 */

function list_getGroupRequestCount($where, $where_parameters)

{

	global $smcFunc;

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

		SELECT COUNT(*)

		FROM {db_prefix}log_group_requests AS lgr

		WHERE ' . $where,

		array_merge($where_parameters, array(

		))

	);

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

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

	return $totalRequests;

}

/**

 * Callback function for createList()

 * @param string $approve_query Not used here

 * @return int The number of users on the watch list

 */

function list_getWatchedUserCount($approve_query)

{

	global $smcFunc, $modSettings;

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

		SELECT COUNT(*)

		FROM {db_prefix}members

		WHERE warning >= {int:warning_watch}',

		array(

			'warning_watch' => $modSettings['warning_watch'],

		)

	);

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

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

	return $totalMembers;

}

/**

 * Callback for createList().

 * @param string $approve_query A query to pull only approved items

 * @return int The total number of posts by watched users

 */

function list_getWatchedUserPostsCount($approve_query)

{

	global $smcFunc, $modSettings;

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

		SELECT COUNT(*)

			FROM {db_prefix}messages AS m

				INNER JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)

				INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)

			WHERE mem.warning >= {int:warning_watch}

				AND {query_see_board}

				' . $approve_query,

		array(

			'warning_watch' => $modSettings['warning_watch'],

		)

	);

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

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

	return $totalMemberPosts;

}

/**

 * Callback for createList().

 * @param string $approve_query Additional restrictions based on the boards the approver can see

 * @return int The number of unapproved attachments

 */

function list_getNumUnapprovedAttachments($approve_query)

{

	global $smcFunc;

	// How many unapproved attachments in total?

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

		SELECT COUNT(*)

		FROM {db_prefix}attachments AS a

			INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)

			INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)

		WHERE a.approved = {int:not_approved}

			AND a.attachment_type = {int:attachment_type}

			AND {query_see_board}

			' . $approve_query,

		array(

			'not_approved' => 0,

			'attachment_type' => 0,

		)

	);

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

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

	return $total_unapproved_attachments;

}

/**

 * Approve a post, just the one.

 * @param array $where_vars The parameters for $where

 * @return int Number of user errors

 */

function list_getUserErrorCount($where, $where_vars = array())

{

	global $smcFunc;

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

		SELECT COUNT(*) AS error_count

		FROM {db_prefix}log_errors

		WHERE ' . $where,

		$where_vars

	);

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

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

	return (int) $count;

}

/**

 * Gets all of the errors generated by a user's actions. Callback for the list in track_activity

 * @param array $where_vars The parameters for $where

 * @return int Count of messages matching the IP

 */

function list_getIPMessageCount($where, $where_vars = array())

{

	global $smcFunc;

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

		SELECT COUNT(*) AS message_count

		FROM {db_prefix}messages AS m

			INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)

		WHERE {query_see_board} AND ' . $where,

		$where_vars

	);

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

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

	return (int) $count;

}

/**

 * Gets all the posts made from a particular IP

 * @param array $where_vars An array of parameters for $where

 * @return int count of messages matching the IP

 */

function list_getLoginCount($where, $where_vars = array())

{

	global $smcFunc;

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

		SELECT COUNT(*) AS message_count

		FROM {db_prefix}member_logins

		WHERE id_member = {int:id_member}',

		array(

			'id_member' => $where_vars['current_member'],

		)

	);

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

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

	return (int) $count;

}

/**

 * Callback for the list in trackLogins.

 * @param int $memID The ID of the member

 * @return int The number of profile edits

 */

function list_getProfileEditCount($memID)

{

	global $smcFunc;

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

		SELECT COUNT(*) AS edit_count

		FROM {db_prefix}log_actions

		WHERE id_log = {int:log_type}

			AND id_member = {int:owner}',

		array(

			'log_type' => 2,

			'owner' => $memID,

		)

	);

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

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

	return (int) $edit_count;

}

/**

 * Loads up information about a user's profile edits. Callback for the list in trackEdits()

 * @param int $event_id The ID of the event

 * @return int|bool The ID of the poster or false if the event was not found

 */

function getEventPoster($event_id)

{

	global $smcFunc;

	// A simple database query, how hard can that be?

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

		SELECT id_member

		FROM {db_prefix}calendar

		WHERE id_event = {int:id_event}

		LIMIT 1',

		array(

			'id_event' => $event_id,

		)

	);

	// No results, return false.

	if ($smcFunc['db_num_rows'] === 0)

		return false;

	// Grab the results and return.

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

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

	return (int) $poster;

}

/**

 * Consolidating the various INSERT statements into this function.