factions.php

<?php
/*
* UDWBase: WOWDB Web Interface
*
* © UDW 2009-2011
*
* Released under the terms and conditions of the
* GNU General Public License (http://gnu.org).
*
*/

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

global $DB;

$rows = $DB->select('
	SELECT factionID, team, name_loc'.$_SESSION['locale'].' as name, side
	FROM ?_udwbase_factions
	WHERE
		reputationListID!=-1
	'
);
if(!$factions = load_cache(19, 'x'))
{
	unset($factions);

	$factions = array();
	foreach ($rows as $numRow=>$row)
	{
		$factions[$numRow] = array();
		$factions[$numRow]['entry'] = $row['factionID'];
		if ($row['team']!=0)
			$factions[$numRow]['group'] = $DB->selectCell('SELECT name_loc'.$_SESSION['locale'].' FROM ?_udwbase_factions WHERE factionID=? LIMIT 1', $row['team']);
		if ($row['side'])
			$factions[$numRow]['side'] = $row['side'];
		$factions[$numRow]['name'] = $row['name'];
	}
	save_cache(19, 'x', $factions);
}

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

// Статистика выполнения mysql запросов
$smarty->assign('mysql', $DB->getStatistics());
$smarty->assign('factions',$factions);
// Загружаем страницу
$smarty->display('factions.tpl');
?>