albertlast / SMF2.1

 * @param array $search_vars An array of variables for the search string

 * @return int The number of subscribed users matching the given parameters

 */

function list_getSubscribedUserCount($id_sub, $search_string, $search_vars = array())

{

	global $smcFunc;

	// Get the total amount of users.

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

		SELECT COUNT(*) AS total_subs

		FROM {db_prefix}log_subscribed AS ls

			LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = ls.id_member)

		WHERE ls.id_subscribe = {int:current_subscription} ' . $search_string . '

			AND (ls.end_time != {int:no_end_time} OR ls.payments_pending != {int:no_pending_payments})',

		array_merge($search_vars, array(

			'current_subscription' => $id_sub,

			'no_end_time' => 0,

			'no_pending_payments' => 0,

		))

	);

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

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

	return $memberCount;

}

/**

 * Return the subscribed users list, for the given parameters.

  * Callback for createList().

  * @return int The total number of warning templates

  */

function list_getWarningTemplateCount()

{

	global $smcFunc, $user_info;

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

		SELECT COUNT(*)

		FROM {db_prefix}log_comments

		WHERE comment_type = {string:warntpl}

			AND (id_recipient = {string:generic} OR id_recipient = {int:current_member})',

		array(

			'warntpl' => 'warntpl',

			'generic' => 0,

			'current_member' => $user_info['id'],

		)

	);

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

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

	return $totalWarns;

}

/**

 * Callback for createList().