/**
*
* @param type $id
* @return type
*/
function spellinfo($id)
{
global $DB;
$row = $DB->selectRow('
SELECT s.*, i.iconname
FROM ?_aowow_spell s, ?_aowow_spellicons i
WHERE
s.spellID=?
AND i.id = s.spellicon
LIMIT 1
', $id);
return spellinfo2($row);
}
FROM ?_itemset
WHERE name LIKE ?
', $nsearch);
foreach ($rows as $numRow => $row) {
$found['itemset'][] = itemsetinfo2($row);
}
// Ищем спеллы
$rows = $DB->select('
SELECT ?#, spellID
FROM ?_spell s, ?_spellicons i
WHERE
s.spellname like ?
AND i.id = s.spellicon
', $spell_cols[2], $nsearch);
foreach ($rows as $numRow => $row) {
$found['spell'][] = spellinfo2($row);
}
$keys = array_keys($found);
if (count($found) == 1 and count($found[$keys[0]]) == 1) {
header("Location: ?" . $keys[0] . '=' . $found[$keys[0]][0]['entry']);
} else {
$smarty->assign('found', $found);
// Если хоть одна информация о вещи найдена - передаём массив с информацией о вещях шаблонизатору
if (isset($allitems)) {
$smarty->assign('allitems', $allitems);
}
if (isset($allspells)) {
$smarty->assign('allspells', $allspells);
}
// Параметры страницы
$page = array();
// Talents
// todo
} else {
$spells['sort'] = "'name'";
// просто спеллы
$rows = $DB->select('
SELECT
?#, `s`.`spellID`
FROM ?_spell s, ?_spellicons i
WHERE
i.id=s.spellicon
{LIMIT ?d}
', $spell_cols[2], $AoWoWconf['limit'] != 0 ? $AoWoWconf['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);
}
$teachspells = $DB->select('
SELECT ?#, spellID
FROM ?_npc_trainer, ?_aowow_spell, ?_aowow_spellicons
WHERE
entry=?d
AND spellID=Spell
AND id=spellicon
', $spell_cols[2], $npc['entry']);
if ($teachspells) {
if (!isset($npc['teaches'])) {
$npc['teaches'] = array();
}
foreach ($teachspells as $teachspell) {
$num = count($npc['teaches']);
$npc['teaches'][$num] = array();
$npc['teaches'][$num] = spellinfo2($teachspell);
}
}
unset($teachspells);
// Продает:
$rows_s = $DB->select('
SELECT ?#, i.entry, i.maxcount, n.`maxcount` as `drop-maxcount`
{, l.name_loc?d AS `name_loc`}
FROM ?_npc_vendor n, ?_aowow_icons, ?_item_template i
{LEFT JOIN (?_locales_item l) ON l.entry=i.entry AND ?d}
WHERE
n.entry=?
AND i.entry=n.item
AND id=i.displayid
', $item_cols[2], $_SESSION['locale'] ? $_SESSION['locale'] : DBSIMPLE_SKIP, $_SESSION['locale'] ? 1 : DBSIMPLE_SKIP, $id);
if ($rows_s) {
FROM ?_udwbase_spell s, ?_udwbase_spellicons i
WHERE
((s.effect1itemtype=?d
OR s.effect2itemtype=?d
OR s.effect3itemtype=?)
AND (i.id = s.spellicon))
', $spell_cols[2], $item['entry'], $item['entry'], $item['entry']);
if ($rows_cf) {
$item['createdfrom'] = array();
foreach ($rows_cf as $numRow => $row) {
$skillrow = $DB->selectRow('
SELECT skillID, min_value, max_value
FROM ?_udwbase_skill_line_ability
WHERE spellID=?d
LIMIT 1', $row['spellID']);
$item['createdfrom'][] = spellinfo2(array_merge($row, $skillrow));
}
unset($skillrow);
}
unset($rows_cf);
// Ловится в ...
$drops_fi = drop('?_fishing_loot_template', $item['entry']);
if ($drops_fi) {
$item['fishedin'] = array();
foreach ($drops_fi as $lootid => $drop) {
// Обычные локации
$row = $DB->selectRow('
SELECT name_loc' . $_SESSION['locale'] . ' AS name, areatableID as id
FROM ?_udwbase_zones
WHERE
areatableID=?d
SELECT s.*, i.iconname
FROM ?_spell s, ?_spellicons i
WHERE
s.spellname_loc' . $_SESSION['locale'] . ' = ?
AND s.spellID <> ?d
AND (
(s.effect1id = ?d AND s.effect1id!=0)
OR (s.effect2id = ?d AND s.effect2id!=0)
OR (s.effect3id = ?d AND s.effect3id!=0)
)
AND i.id=s.spellicon
', $spell['name'], $spell['entry'], $row['effect1id'], $row['effect2id'], $row['effect3id']);
if ($seealso) {
$spell['seealso'] = array();
foreach ($seealso as $i => $row) {
$spell['seealso'][] = spellinfo2($row);
}
unset($seealso);
}
// Кто обучает этому спеллу
$spell['taughtbynpc'] = array();
// Список тренеров, обучающих нужному спеллу
$trainers = $DB->selectCol('SELECT entry FROM npc_trainer WHERE spell = ?d', $spell['entry']);
if ($trainers) {
$taughtbytrainers = $DB->select('
SELECT ?#, c.entry
{ , name_loc?d AS name_loc, subname_loc' . $_SESSION['locale'] . ' AS subname_loc }
FROM ?_factiontemplate, creature_template c
{ LEFT JOIN (locales_creature l) ON c.entry = l.entry AND ? }
WHERE
c.entry IN (?a)
}
unset($rows_cf);
// Добывается из спелла
$drops_sp = drop('spell_loot_template', $item['entry']);
if ($drops_sp) {
$item['containedinspell'] = array();
foreach ($drops_sp as $lootid => $drop) {
$rows = $DB->select('
SELECT s.?#, s.spellID
FROM ?_spell s, ?_spellicons i
WHERE
s.spellID = ?d
AND i.id = s.spellicon
', $spell_cols[2], $lootid);
foreach ($rows as $row) {
$item['containedinspell'][] = array_merge(spellinfo2($row), $drop);
}
unset($rows);
}
}
unset($drops_sp);
// Цель критерии
$rows = $DB->select('
SELECT a.id, a.faction, a.name_loc?d AS name, a.description_loc?d AS description, a.category, a.points, s.iconname, z.areatableID
FROM ?_spellicons s, ?_achievementcriteria c, ?_achievement a
LEFT JOIN (?_zones z) ON a.map != -1 AND a.map = z.mapID
WHERE
a.icon = s.id
AND a.id = c.refAchievement
AND c.type IN (?a)
AND c.value1 = ?d
