SimpleMachines / SMF2.1

 * @param string $sort A string telling ORDER BY how to sort the results

 * @return array An array of information about the bans for the list

 */

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

{

	global $smcFunc;

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

		SELECT bg.id_ban_group, bg.name, bg.ban_time, bg.expire_time, bg.reason, bg.notes, COUNT(bi.id_ban) AS num_triggers

		FROM {db_prefix}ban_groups AS bg

			LEFT JOIN {db_prefix}ban_items AS bi ON (bi.id_ban_group = bg.id_ban_group)

		GROUP BY bg.id_ban_group, bg.name, bg.ban_time, bg.expire_time, bg.reason, bg.notes

		ORDER BY {raw:sort}

		LIMIT {int:offset}, {int:limit}',

		array(

			'sort' => $sort,

			'offset' => $start,

			'limit' => $items_per_page,

		)

	);

	$bans = array();

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

		$bans[] = $row;

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

	return $bans;

}

/**

 * Get the total number of ban from the ban group table

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

 * @return array An array of information about known spiders

 */

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

{

	global $smcFunc;

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

		SELECT id_spider, spider_name, user_agent, ip_info

		FROM {db_prefix}spiders

		ORDER BY {raw:sort}

		LIMIT {int:start}, {int:items}',

		array(

			'sort' => $sort,

			'start' => $start,

			'items' => $items_per_page,

		)

	);

	$spiders = array();

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

		$spiders[$row['id_spider']] = $row;

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

	return $spiders;

}

/**

 * Callback function for createList()

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

 * @return array An array of spider log data

 */

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

{

	global $smcFunc;

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

		SELECT sl.id_spider, sl.url, sl.log_time, s.spider_name

		FROM {db_prefix}log_spider_hits AS sl

			INNER JOIN {db_prefix}spiders AS s ON (s.id_spider = sl.id_spider)

		ORDER BY {raw:sort}

		LIMIT {int:start}, {int:items}',

		array(

			'sort' => $sort,

			'start' => $start,

			'items' => $items_per_page,

		)

	);

	$spider_logs = array();

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

		$spider_logs[] = $row;

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

	return $spider_logs;

}

/**

 * Callback function for createList()

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

 * @return array An array of spider statistics info

 */

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

{

	global $smcFunc;

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

		SELECT ss.id_spider, ss.stat_date, ss.page_hits, s.spider_name

		FROM {db_prefix}log_spider_stats AS ss

			INNER JOIN {db_prefix}spiders AS s ON (s.id_spider = ss.id_spider)

		ORDER BY {raw:sort}

		LIMIT {int:start}, {int:items}',

		array(

			'sort' => $sort,

			'start' => $start,

			'items' => $items_per_page,

		)

	);

	$spider_stats = array();

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

		$spider_stats[] = $row;

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

	return $spider_stats;

}

/**

 * Callback function for createList()

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

 * @return array An array of holidays, each of which is an array containing the id, year, month, day and title of the holiday

 */

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

{

	global $smcFunc;

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

		SELECT id_holiday, YEAR(event_date) AS year, MONTH(event_date) AS month, DAYOFMONTH(event_date) AS day, title

		FROM {db_prefix}calendar_holidays

		ORDER BY {raw:sort}

		LIMIT {int:start}, {int:max}',

		array(

			'sort' => $sort,

			'start' => $start,

			'max' => $items_per_page,

		)

	);

	$holidays = array();

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

		$holidays[] = $row;

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

	return $holidays;

}

/**

 * Helper function to get the total number of holidays