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 '---(?)---';
}
