Antonis Farangitakis
96 lines
2.3 KiB
PHP
96 lines
2.3 KiB
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/allobjects.php');
|
|
require_once ('includes/allitems.php');
|
|
require_once ('includes/allcomments.php');
|
|
require_once ('includes/allquests.php');
|
|
|
|
$smarty->config_load($conf_file, 'object');
|
|
|
|
// номер объекта;
|
|
$id = $podrazdel;
|
|
|
|
if (!$object = load_cache(3, intval($id))) {
|
|
unset($object);
|
|
|
|
// БД
|
|
global $DB;
|
|
|
|
// Данные об объекте:
|
|
$object = array();
|
|
$object = objectinfo($id, 1);
|
|
|
|
// Начиниают квесты...
|
|
$rows_qs = $DB->select('
|
|
SELECT o.?#
|
|
FROM ?_quest_relations q, ?_quest_template o
|
|
WHERE
|
|
q.entry = ?d
|
|
AND o.entry = q.quest
|
|
', $quest_cols[2], $id
|
|
);
|
|
if ($rows_qs) {
|
|
$object['starts'] = array();
|
|
foreach ($rows_qs as $numRow => $row)
|
|
$object['starts'][] = GetQuestInfo($row, 0xFFFFFF);
|
|
}
|
|
unset($rows_qs);
|
|
|
|
// Заканчивают квесты...
|
|
$rows_qe = $DB->select('
|
|
SELECT i.?#
|
|
FROM ?_quest_relations i, ?_quest_template q
|
|
WHERE
|
|
i.entry = ?d
|
|
AND q.entry = i.quest
|
|
', $quest_cols[2], $id
|
|
);
|
|
if ($rows_qe) {
|
|
$object['ends'] = array();
|
|
foreach ($rows_qe as $numRow => $row)
|
|
$object['ends'][] = GetQuestInfo($row, 0xFFFFFF);
|
|
}
|
|
unset($rows_qe);
|
|
|
|
// Положения объектофф:
|
|
position($object['entry'], 'gameobject');
|
|
|
|
save_cache(3, $object['entry'], $object);
|
|
}
|
|
|
|
global $page;
|
|
$page = array(
|
|
'Mapper' => false,
|
|
'Book' => false,
|
|
'Title' => $object['name'] . ' - ' . $smarty->get_config_vars('Objects'),
|
|
'tab' => 0,
|
|
'type' => 2,
|
|
'typeid' => $object['entry'],
|
|
'path' => '[0,5,' . $object['type'] . ']'
|
|
);
|
|
if ($object['pagetext'])
|
|
$page['Book'] = true;
|
|
$page['Mapper'] = true;
|
|
|
|
$smarty->assign('page', $page);
|
|
|
|
// Комментарии
|
|
$smarty->assign('comments', getcomments($page['type'], $page['typeid']));
|
|
|
|
if (isset($allitems))
|
|
$smarty->assign('allitems', $allitems);
|
|
if (isset($object))
|
|
$smarty->assign('object', $object);
|
|
// Количество MySQL запросов
|
|
$smarty->assign('mysql', $DB->getStatistics());
|
|
$smarty->display('object.tpl'); |