source: aowow/object.php

<?php

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 gameobject_questrelation q, quest_template o
                WHERE
                        q.id = ?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 ?#
                FROM gameobject_involvedrelation i, quest_template q
                WHERE
                        i.id = ?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);

        // Положения объектофф:
        $data = $DB->select('SELECT position_y as y, position_x as x, map as m, spawntimesecs FROM gameobject WHERE id = ?d', $id);
        position($data);

        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');

?>