SimpleMachines / SMF2.1

 * @param string $sort A string indicating how to sort the results

 * @return array An array of info about the smileys

 */

function list_getSmileys($start, $items_per_page, $sort)

{

	global $smcFunc;

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

		SELECT id_smiley, code, filename, description, smiley_row, smiley_order, hidden

		FROM {db_prefix}smileys

		ORDER BY {raw:sort}',

		array(

			'sort' => $sort,

		)

	);

	$smileys = array();

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

		$smileys[] = $row;

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

	return $smileys;

}

/**

 * Callback function for createList().

 * @param string $sort A string indicating how to sort the items (not used here)

 * @return array An array of information about message icons

 */

function list_getMessageIcons($start, $items_per_page, $sort)

{

	global $smcFunc;

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

		SELECT m.id_icon, m.title, m.filename, m.icon_order, m.id_board, b.name AS board_name

		FROM {db_prefix}message_icons AS m

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

		WHERE ({query_see_board} OR b.id_board IS NULL)

		ORDER BY m.icon_order',

		array()

	);

	$message_icons = array();

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

		$message_icons[] = $row;

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

	return $message_icons;

}

?>

 * @param int $member_id The ID of the member

 * @return array An array of IPs used in posts by this member

 */

function banLoadAdditionalIPsMember($member_id)

{

	global $smcFunc;

	// Find some additional IP's used by this member.

	$message_ips = array();

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

		SELECT DISTINCT poster_ip

		FROM {db_prefix}messages

		WHERE id_member = {int:current_user}

			AND poster_ip IS NOT NULL

		ORDER BY poster_ip',

		array(

			'current_user' => $member_id,

		)

	);

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

		$message_ips[] = inet_dtop($row['poster_ip']);

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

	return $message_ips;

}

/**

 * @param int $member_id The ID of the member

 * @param int $member_id The ID of the member

 * @return array An array of IPs associated with error messages generated by this user

 */

function banLoadAdditionalIPsError($member_id)

{

	global $smcFunc;

	$error_ips = array();

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

		SELECT DISTINCT ip

		FROM {db_prefix}log_errors

		WHERE id_member = {int:current_user}

			AND ip IS NOT NULL

		ORDER BY ip',

		array(

			'current_user' => $member_id,

		)

	);

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

	    $error_ips[] = inet_dtop($row['ip']);

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

	return $error_ips;

}

/**

 * This function handles submitted forms that add, modify or remove ban triggers.