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

?>