}
$tp->assign('reward', $rewardTP);
// Disenchant
if ($itemData['DisenchantID']) {
$de = $mysql->getRows("SELECT item_template.name,item_template.entry,item_template.Quality,disenchant_loot_template.item,disenchant_loot_template.ChanceOrQuestChance,disenchant_loot_template.mincountOrRef,disenchant_loot_template.maxcount\n\t FROM `disenchant_loot_template`,`item_template`\n\t WHERE disenchant_loot_template.item = item_template.entry and disenchant_loot_template.entry = ?1 limit 20", $itemData['DisenchantID'], 'world');
if ($de) {
$deTP = '<div class="rel-tab"><p class="rel-de"/><h3>Disenchants into:</h3></div>
<div class="data" style="clear: both;" id="big-results">
<table class="data-table"><thead><tr class="masthead"><td><a class="noLink">Name</a></td><td align="center"><a class="noLink">Drop Chance</a></td><td align="center"><a class="noLink">Count</a></td></tr></thead><tbody>';
foreach ($de as $mob) {
$ids .= $mob['entry'] . ',';
}
$cc = $mysql->getRows("select itemnumber,itemicon,itemhtml from itemicon where itemnumber in (?1-1)", $ids, 'armory');
if ($cc) {
foreach ($cc as $icon) {
$icons[$icon['itemnumber']] = $icon;
}
}
foreach ($de as $mob) {
$icons[$mob['entry']] = validate_icon($icons[$mob['entry']], $mob['entry']);
$deTP .= '<tr><td><strong><a onMouseOver="setTipText(\'' . system::htmlcode($icons[$mob['entry']]['itemhtml']) . '\')" href="item-info.php?i=' . $mob['entry'] . '" class="staticTip rarity' . $mob['Quality'] . '">
<img align="middle" border="0" height="48" alt="" src="images/icon48/' . $icons[$mob['entry']]['itemicon'] . '.png"> ' . $mob['name'] . '</a></strong></td><td class="centeralign">' . round($mob['ChanceOrQuestChance'], 2) . '%</td>
<td>' . ($mob['mincountOrRef'] == $mob['maxcount'] ? $mob['maxcount'] : $mob['mincountOrRef'] . '-' . $mob['maxcount']) . '</td></tr>';
}
$deTP .= '</tbody></table></div>';
}
}
$tp->assign('de', $deTP);
$c->assign('content', $tp->output);
$c->display();
$_SYSTEM->printFooter();
function start()
{
global $config, $SQL, $mysql, $_SYSTEM;
$il = $this->per_page;
$st = $this->per_page * $this->page;
$LIMIT = 'LIMIT ' . $st . ', ' . $il;
$data = array();
$d = $mysql->getRows("SELECT name,displayid,ItemLevel,entry,Flags,RequiredLevel,class,subclass,Quality FROM `item_template` WHERE name LIKE '%?1%'\n\t\t" . ($this->ItemClass != -1 ? 'and class = ' . $this->ItemClass : '') . " " . ($this->ItemSubClass != -1 ? 'and subclass = ' . $this->ItemSubClass : '') . " ORDER BY ItemLevel DESC {$LIMIT}", $this->name, 'world');
$this->count = mysql_result($mysql->query("SELECT count(*) FROM `item_template` WHERE name LIKE '%" . $this->name . "%' " . ($this->ItemClass != -1 ? 'and class = ' . $this->ItemClass : '') . " " . ($this->ItemSubClass != -1 ? 'and subclass = ' . $this->ItemSubClass : ''), 'world'), 0) or $this->count = 0;
if (!$d) {
return;
}
foreach ($d as $dat) {
$ids .= $dat['entry'] . ',';
}
$c = $mysql->getRows("select itemnumber,itemicon,itemhtml from itemicon where itemnumber in (?1-1)", $ids, 'armory');
if ($c) {
foreach ($c as $icon) {
$icons[$icon['itemnumber']] = $icon;
}
}
foreach ($d as $key => $dat) {
$icons[$dat['entry']] = validate_icon($icons[$dat['entry']], $dat['entry']);
$d[$key]['icon'] = $icons[$dat['entry']]['itemicon'];
$d[$key]['tooltip'] = system::htmlcode($icons[$dat['entry']]['itemhtml']);
}
$quest = $mysql->getRows("SELECT `SrcItemId` as id FROM `quest_template` WHERE `SrcItemId` IN (?1-1)", $ids, 'world');
$vendor = $mysql->getRows("SELECT `item` as id FROM `npc_vendor` WHERE `item` IN (?1-1)", $ids, 'world');
$chest = $mysql->getRows("SELECT `gameobject_loot_template`.`item` as id FROM `gameobject_loot_template`,`gameobject_template` WHERE gameobject_template.entry = gameobject_loot_template.entry `item` IN (?1-1)", $ids, 'world');
$drop = $mysql->getRows("SELECT `item` as id FROM `creature_loot_template` WHERE `item` IN (?1-1)", $ids, 'world');
$quest_rew = $mysql->getRows("SELECT RewChoiceItemId1,RewChoiceItemId2,RewChoiceItemId3,RewChoiceItemId4,RewChoiceItemId5,RewChoiceItemId6,\n RewItemId1,RewItemId2,RewItemId3,RewItemId4\n FROM `quest_template` WHERE `RewChoiceItemId1`IN (?1-1) OR `RewChoiceItemId2`IN (?1-1)\n\tOR `RewChoiceItemId3`IN (?1-1) OR `RewChoiceItemId4`IN (?1-1) OR `RewChoiceItemId5`IN (?1-1) OR `RewChoiceItemId6`IN (?1-1)\n\tOR `RewItemId1`IN (?1-1) OR `RewItemId2`IN (?1-1) OR `RewItemId3`IN (?1-1) OR `RewItemId4`IN (?1-1)", $ids, 'world');
foreach ($d as $key => $dat) {
$id = $dat['entry'];
$d[$key]['source'] = '';
if ($quest) {
foreach ($quest as $q) {
if (in_array($id, $q)) {
$d[$key]['source'] .= 'Quest Item, ';
break;
}
}
}
if ($vendor) {
foreach ($vendor as $q) {
if (in_array($id, $q)) {
if ($dat['Flags'] & 32768 == 32768) {
$d[$key]['source'] .= 'PVP Reward, ';
break;
} else {
$d[$key]['source'] .= 'Vendor, ';
break;
}
}
}
}
if ($chest) {
foreach ($chest as $q) {
if (in_array($id, $q)) {
$d[$key]['source'] .= 'Chest Drop, ';
break;
}
}
}
if ($drop) {
foreach ($drop as $q) {
if (in_array($id, $q)) {
$d[$key]['source'] .= 'Drop, ';
break;
}
}
}
if ($quest_rew) {
foreach ($quest_rew as $q) {
if (in_array($id, $q)) {
$d[$key]['source'] .= 'Quest Reward, ';
break;
}
}
}
if (!$d[$key]['source']) {
$d[$key]['source'] = 'Created, ';
}
$d[$key]['source'] = substr($d[$key]['source'], 0, -2);
}
$data = $d;
return $data;
}
