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>"; echo "<a href=\"?npc={$creature['entry']}\">{$creature['name']}</a> ({$loyality})"; if ($creature['subname'] != "") { echo "<br><FONT color=#008800 size=-3><{$creature['subname']}></FONT>"; } echo "</td></tr>"; $number++; } } if ($rows = $dDB->select("SELECT *\n FROM `gameobject_template` join `gameobject_involvedrelation`\n WHERE\n `gameobject_involvedrelation`.`quest` = ?d AND\n `gameobject_involvedrelation`.`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>";
function getCreature($creature_id, $fields = "*") { global $dDB; if ($creature = $dDB->selectRow("-- CACHE: 1h\n SELECT {$fields} FROM `creature_template` WHERE `entry` = ?d", $creature_id)) { localiseCreature($creature); } return $creature; }
function r_questInvolvedrelation($data) { global $dDB; // Search creature quest giver if ($src = $dDB->select('SELECT `entry`, `name`, `subname`, `faction_A` FROM `creature_template` left join `creature_involvedrelation` ON `creature_template`.`entry` = `creature_involvedrelation`.`id` WHERE `creature_involvedrelation`.`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_involvedrelation` ON `gameobject_template`.`entry` = `gameobject_involvedrelation`.`id` WHERE `gameobject_involvedrelation`.`quest` = ?d', $data['entry'])) { foreach ($src as $go) { localiseGameobject($go); r_objName($go); } return; } echo '---(?)---'; }