quests.php

<?php

// Необходима функция questinfo
require_once('includes/allquests.php');

$smarty->config_load($conf_file, 'quest');

// Разделяем из запроса класс и подкласс квестов
@list($Type, $ZoneOrSort) = extract_values($podrazdel);

$cache_key = cache_key($Type, $ZoneOrSort);
$request_limit = $AoWoWconf['limit'];

if(!$quests = load_cache(QUEST_LISTING, $cache_key))
{
	unset($quests);

	$rows = $DB->select("
		SELECT q.?#
		{
			, l.Title_loc?d AS Title_loc
		}
		FROM quest_template q
		{ LEFT JOIN (locales_quest l) ON l.entry=q.Id AND ? }
		WHERE
			1 = 1
			{ AND ZoneOrSort = ? }
			{ AND ZoneOrSort IN (?a) }
			AND q.Title NOT IN ('','----','?????')
			AND q.Title NOT LIKE '<DEPRECATED>%'
			AND q.Title NOT LIKE '<NYI>%'
			AND q.Title NOT LIKE '<nyi>%'
			AND q.Title NOT LIKE '<TEST>%'
			AND q.Title NOT LIKE '<TXT>%'
			AND q.Title NOT LIKE '<UNUSED%'
		ORDER BY Title
		{LIMIT ?d}
		",
		$quest_cols[2],
		($_SESSION['locale']>0)? $_SESSION['locale']: DBSIMPLE_SKIP,
		($_SESSION['locale']>0)? 1: DBSIMPLE_SKIP,
		isset($ZoneOrSort) ? $ZoneOrSort : DBSIMPLE_SKIP,
		(!isset($ZoneOrSort) && isset($Type)) ? $quest_class[$Type] : DBSIMPLE_SKIP,
		($AoWoWconf['limit'] > 0)? $AoWoWconf['limit']: DBSIMPLE_SKIP
	);

	$quests = array();
	foreach($rows as $row)
		$quests[] = GetQuestInfo($row, QUEST_DATAFLAG_LISTINGS);

	save_cache(QUEST_LISTING, $cache_key, $quests);
}

if(!$quests_tot = load_cache(QUEST_TOT, 'quest_tot'))
{
    unset($quests_tot);
    
    $quests_tot = $DB->select("
		SELECT COUNT(q.Id) as quest_tot
		FROM quest_template q
		WHERE
			q.Title NOT IN ('','----','?????')
			AND q.Title NOT LIKE '<DEPRECATED>%'
			AND q.Title NOT LIKE '<NYI>%'
			AND q.Title NOT LIKE '<nyi>%'
			AND q.Title NOT LIKE '<TEST>%'
			AND q.Title NOT LIKE '<TXT>%'
			AND q.Title NOT LIKE '<UNUSED%'
		"
	);

	save_cache(QUEST_LISTING, 'quest_tot', $quests_tot[0]['quest_tot']);
}

global $page;
$page = array(
	'Mapper' => false,
	'Book' => false,
	'Title' => $smarty->get_config_vars('Quests'),
	'tab' => 0,
	'type' => 0,
	'typeid' => 0,
	'path' => path(0, 3, $Type, $ZoneOrSort) // TODO
);

$smarty->assign('request_limit', $request_limit);
$smarty->assign('page', $page);
$smarty->assign('quests',$quests);
$smarty->assign('quests_tot',(is_array($quests_tot) ? $quests_tot[0]['quest_tot'] : $quests_tot));
// Количество MySQL запросов
$smarty->assign('mysql', $DB->getStatistics());
// Загружаем страницу
$smarty->display('quests.tpl');

?>