spells.php

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

require_once('includes/allspells.php');

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

global $DB;
global $UDWBaseconf;
global $spell_cols;

@list($s1, $s2, $s3) = explode('.', $podrazdel);

$cache_str = (!isset($s1)?'x':intval($s1)).'_'.(!isset($s2)?'x':intval($s2)).'_'.(!isset($s3)?'x':intval($s3));

if(!$spells = load_cache(15, $cache_str))
{
	unset($spells);

	$spells = array();
	if($s1 == 7)
	{
		$title = $smarty->get_config_vars('Class_spells');
		// Классовые
		$rows = $DB->select('
				SELECT ?#, s.`spellID`, sk.skillID
				FROM ?_udwbase_spell s, ?_udwbase_skill_line_ability sla, ?_udwbase_spellicons i, ?_udwbase_skill sk
				WHERE
					s.spellID = sla.spellID
					AND s.levelspell >= 1
					AND i.id=s.spellicon
					{AND sla.classmask = ?d}
					{AND sla.skillID=?d}
					AND sla.skillID=sk.skillID
				ORDER BY s.levelspell
				{LIMIT ?d}
			',
			$spell_cols[2],
			(isset($s2))? pow(2, ($s2-1)): DBSIMPLE_SKIP,
			(isset($s3))? $s3: DBSIMPLE_SKIP,
			($UDWBaseconf['limit']!=0)? $UDWBaseconf['limit']: DBSIMPLE_SKIP
		);
	}
	elseif($s1 > 0)
	{
		switch($s1)
		{
			case 6:
				$title = $smarty->get_config_vars('Оружейные навыки');
				break;
			case 8:
				$title = $smarty->get_config_vars('Специализации брони');
				break;
			case 10:
				$title = $smarty->get_config_vars('Языки');
				break;
			case 9:
				$title = $smarty->get_config_vars('Вспомогательные профессии');
				break;
			case 11:
				$title = $smarty->get_config_vars('Профессии');
				break;
			default:
				$title = '???';
				break;
		}
		$spells['sort'] = "'skill', 'name'";
		// Профессии & other
		$rows = $DB->select('
			SELECT
				?#, `s`.`spellID`,
				sla.skillID, sla.min_value, sla.max_value
			FROM ?_udwbase_spell s, ?_udwbase_skill_line_ability sla, ?_udwbase_spellicons i, ?_udwbase_skill sk
			WHERE
				s.spellID = sla.spellID
				AND i.id=s.spellicon
				{AND sk.categoryID=?d}
				{AND sla.skillID=?d}
				AND sla.skillID=sk.skillID
			{LIMIT ?d}
		',
		$spell_cols[2],
		$s1,
		(isset($s2))? $s2: DBSIMPLE_SKIP,
		($UDWBaseconf['limit']!=0)? $UDWBaseconf['limit']: DBSIMPLE_SKIP
		);
	}
	elseif($s1 == -3)
	{
		$title = $smarty->get_config_vars('Pet_spells');
		// Петы
		$spells['sort'] = "'name'";
		if (!isset($s2))
			$pets = array(270, 653, 210, 211, 213, 209, 214, 212, 763, 215, 654, 764, 655, 217, 767, 236, 768, 203, 218, 251, 766, 656, 208, 761, 189, 188, 205, 204);
		$rows = $DB->select('
				SELECT
					?#, `s`.`spellID`, sk.skillID
				FROM ?_udwbase_spell s, ?_udwbase_skill_line_ability sla, ?_udwbase_spellicons i, ?_udwbase_skill sk
				WHERE
					s.spellID = sla.spellID
					AND s.levelspell > 0
					AND i.id=s.spellicon
					{AND sla.skillID=?d}
					{AND sla.skillID IN (?a)}
					AND sla.skillID=sk.skillID
				{LIMIT ?d}
			',
			$spell_cols[2],
			(isset($s2))? $s2: DBSIMPLE_SKIP,
			(isset($pets))? $pets: DBSIMPLE_SKIP,
			($UDWBaseconf['limit']!=0)? $UDWBaseconf['limit']: DBSIMPLE_SKIP
		);
	}
	elseif($s1 == -4)
	{
		$title = $smarty->get_config_vars('Racial_spells');
		$spells['sort'] = "'name'";
		// Racial Traits
		$rows = $DB->select('
			SELECT
				?#, `s`.`spellID`
			FROM ?_udwbase_spell s, ?_udwbase_spellicons i
			WHERE
				s.spellID IN (SELECT spellID FROM ?_udwbase_skill_line_ability WHERE racemask>0)
				AND i.id=s.spellicon
			{LIMIT ?d}
			',
			$spell_cols[2],
			($UDWBaseconf['limit']!=0)? $UDWBaseconf['limit']: DBSIMPLE_SKIP
		);
	}
	elseif ($s1==-2) {
		// Talents
		// todo
	}
	else
	{
		$spells['sort'] = "'name'";
		// просто спеллы
		$rows = $DB->select('
			SELECT
				?#, `s`.`spellID`
			FROM ?_udwbase_spell s, ?_udwbase_spellicons i
			WHERE
				i.id=s.spellicon
			{LIMIT ?d}
		',
		$spell_cols[2],
		($UDWBaseconf['limit']!=0)? $UDWBaseconf['limit']: DBSIMPLE_SKIP
		);
	}

	foreach($rows as $i => $row)
		$spells['data'][] = spellinfo2($row);

	save_cache(15, $cache_str, $spells);
}
global $page;
$page = array(
	'Mapper' => false,
	'Book' => false,
	'Title' => ($title?$title.' - ':'').$smarty->get_config_vars('Spells'),
	'tab' => 0,
	'type' => 6,
	'typeid' => 0,
	'path' => "[0, 1, ".intval($s1).", ".intval($s2).", ".intval($s3)."]",
	'sort' => isset($spells['sort'])?$spells['sort']:"'level','name'"
);
$smarty->assign('page', $page);

// Статистика выполнения mysql запросов
$smarty->assign('mysql', $DB->getStatistics());
// Если хоть одна информация о вещи найдена - передаём массив с информацией о вещях шаблонизатору
if (isset($allitems))
	$smarty->assign('allitems',$allitems);
if (count($allspells)>=0)
	$smarty->assign('allspells',$allspells);
if (count($spells)>=0)
	$smarty->assign('spells',$spells['data']);
// Загружаем страницу
$smarty->display('spells.tpl');

?>