zones.php

<?php

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

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

@list($type) = extract_values($podrazdel);

$cache_key = cache_key($type);

if(!$zones = load_cache(2, $cache_key))
{

	unset($zones);

	$rows = $DB->select('
		SELECT *, areatableID as area, name_loc0 as name 
		FROM aowow_zones
			{WHERE
			mapID = ?d}
			{OR mapID > ?d}
		{LIMIT ?d}
		',
		isset($type) ? $type : DBSIMPLE_SKIP,
		(isset($type)&&$type==2) ? $type : DBSIMPLE_SKIP,
		($AoWoWconf['limit']!=0)? $AoWoWconf['limit']: DBSIMPLE_SKIP
	);
	$zones = array();
	foreach ($rows as $row) {
		
		if ($row['x_min'] == 0) {
			$row['instance'] = "Yes";
		}
		$zones[] = $row;
	}
	
	save_cache(5, $cache_key, $zones);
}

global $page;
$page = array(
	'Mapper' => false,
	'Book' => false,
	'Title' => $smarty->get_config_vars('Zones'),
	'tab' => 0,
	'type' => 0,
	'typeid' => 0,
	'path' => path(0, 6, $type)
);
$smarty->assign('page', $page);

$smarty->assign('zones', $zones);
// Количество MySQL запросов
$smarty->assign('mysql', $DB->getStatistics());
// Загружаем страницу
$smarty->display('zones.tpl');

?>