}
echo "</td></tr>";
$number++;
}
}
if ($rows = $dDB->select("SELECT *\n FROM `gameobject_template` join `gameobject_questrelation`\n WHERE\n `gameobject_questrelation`.`quest` = ?d AND\n `gameobject_questrelation`.`id` = `gameobject_template`.`entry`", $quest['entry'])) {
foreach ($rows as $go) {
localiseGameobject($go);
echo "<tr><td><a style='float: right;' href=\"?map&obj={$go['entry']}\">{$lang['map']}</a>";
echo "<a href=\"?object={$go['entry']}\">{$go['name']}</a></td></tr>";
$number++;
}
}
if ($rows = $dDB->select("SELECT `entry`, `name`,`Quality`, `displayid` FROM `item_template` WHERE `startquest` = ?d", $quest['entry'])) {
foreach ($rows as $item) {
localiseItem($item);
echo '<tr><td class=reward> ' . text_show_item($item['entry'], $item['displayid']);
echo ' <a class=' . $Quality[$item['Quality']] . ' href="?item=' . $item['entry'] . '">' . $item['name'] . '</a>';
$number++;
}
}
if ($number == 0) {
echo "<tr><td bgColor=#ff0000>{$lang['quest_not_found']}</td></tr>";
}
$number = 0;
echo "<tr><td class = head>{$lang['end_q']}:</td></tr>";
if ($rows = $dDB->select("SELECT *\n FROM `creature_template` join `creature_involvedrelation`\n WHERE\n `creature_involvedrelation`.`quest` = ?d AND\n `creature_involvedrelation`.`id` = `creature_template`.`entry`", $quest['entry'])) {
foreach ($rows as $creature) {
localiseCreature($creature);
$loyality = getLoyality($creature['faction_A']);
echo "<tr><td><a style='float: right;' href=\"?map&npc={$creature['entry']}\">{$lang['map']}</a>";
function getItem($item_id, $fields = "*")
{
global $dDB, $config;
$item = $dDB->selectRow("-- CACHE: 1h\n SELECT {$fields} FROM `item_template` WHERE `entry` = ?d", $item_id);
if ($item) {
localiseItem($item);
}
return $item;
}
function r_questRelation($data)
{
global $dDB;
// Search creature quest giver
if ($src = $dDB->select('SELECT `entry`, `name`, `subname`, `faction_A`
FROM `creature_template` left join `creature_questrelation` ON `creature_template`.`entry` = `creature_questrelation`.`id`
WHERE `creature_questrelation`.`quest` = ?d', $data['entry'])) {
foreach ($src as $creature) {
localiseCreature($creature);
r_npcRName($creature);
}
return;
}
// Search GO quest giver
if ($src = $dDB->select('SELECT `entry`, `name`
FROM `gameobject_template` left join `gameobject_questrelation` ON `gameobject_template`.`entry` = `gameobject_questrelation`.`id`
WHERE `gameobject_questrelation`.`quest` = ?d', $data['entry'])) {
foreach ($src as $go) {
localiseGameobject($go);
r_objName($go);
}
return;
}
// Search item quest giver
if ($src = $dDB->select("SELECT `entry`, `name`, `Quality` FROM `item_template` WHERE `startquest` = ?d", $data['entry'])) {
foreach ($src as $item) {
localiseItem($item);
r_itemName($item);
}
return;
}
echo '---(?)---';
}
