function generate_language_selectbox()
{
global $locales_search_option;
include_once "get_lib.php";
$selectedlanguage = get_lang_id();
// generate a html option list with available locales_entries
// taken from $locales_search_option in your scripts/config.php
// if user language is supported select this one, else default language
$select_option = $locales_search_option & pow(2, $selectedlanguage) == 0 ? 0 : $selectedlanguage;
$searchbox = '
<select name="language">
<option value="0">' . lang("global", "language_0") . '</option>';
for ($i = 1; $i < 9; $i++) {
if (($locales_search_option & pow(2, $i - 1)) != 0) {
$searchbox .= '
<option value="' . $i . '"';
if ($select_option == $i) {
$searchbox .= 'selected="selected"';
}
$searchbox .= '>' . lang("global", "language_" . $i) . '</option>';
}
}
$searchbox .= '
</select>';
return $searchbox;
}
function get_item_name($item_id)
{
global $world_db, $realm_id, $sql;
if ($item_id) {
$deplang = get_lang_id();
$result = $sql["world"]->query("SELECT name1 FROM items WHERE entry='" . $item_id . "'");
$item_name = $sql["world"]->num_rows($result) == 1 ? $sql["world"]->result($result, 0, "name1") : "ItemID: " . $item_id . " Not Found";
return $item_name;
} else {
return NULL;
}
}
function get_item_name($item_id, &$sqlw = 0)
{
global $world_db, $realm_id;
if ($item_id) {
if (empty($sqlw)) {
$sqlw = new SQL();
$sqlw->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);
}
$deplang = get_lang_id();
$result = $sqlw->query('
SELECT IFNULL(' . ($deplang != 0 ? 'name_loc' . $deplang . '' : 'NULL') . ', name) as name
FROM item_template
LEFT JOIN locales_item ON item_template.entry = locales_item.entry
WHERE item_template.entry = ' . $item_id . '');
$item_name = 1 == $sqlw->num_rows($result) ? $sqlw->result($result, 0, 'name') : 'ItemID: ' . $item_id . ' Not Found';
return $item_name;
} else {
return NULL;
}
}
function generate_language_selectbox()
{
global $lang_global, $locales_search_option;
include_once "get_lib.php";
$selectedlanguage = get_lang_id();
// generate a html option list with available locales_entries
// taken from $locales_search_option in your scripts/config.php
// if user language is supported select this one, else default language
$select_option = $locales_search_option & pow(2, $selectedlanguage) == 0 ? 0 : $selectedlanguage;
$searchbox = "\n <select name=\"language\">\n <option value=\"0\">{$lang_global['language_0']}</option>";
for ($i = 1; $i < 9; $i++) {
if (($locales_search_option & pow(2, $i - 1)) != 0) {
$searchbox .= "\n <option value=\"{$i}\"";
if ($select_option == $i) {
$searchbox .= "selected=\"selected\"";
}
$searchbox .= ">{$lang_global['language_' . $i]}</option>";
}
}
$searchbox .= "\n </select>";
return $searchbox;
}
function edit()
{
global $lang_global, $lang_item_templ, $lang_item, $lang_item_edit, $output, $world_db, $realm_id, $item_datasite, $lang_id_tab, $quest_datasite, $action_permission, $user_lvl, $creature_datasite;
wowhead_tt();
valid_login($action_permission['read']);
if (!isset($_GET['entry'])) {
redirect("item.php?error=1");
}
$sql = new SQL();
$sql->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);
$entry = $sql->quote_smart($_GET['entry']);
$deplang = get_lang_id();
$result = $sql->query("SELECT `item_template`.`entry`,`class`,`subclass`,`unk0`,IFNULL(" . ($deplang != 0 ? "name_loc{$deplang}" : "NULL") . ",`name`) as name,`displayid`,`Quality`,`Flags`,`BuyCount`,`BuyPrice`,`SellPrice`,`InventoryType`,`AllowableClass`,`AllowableRace`,`ItemLevel`,`RequiredLevel`,`RequiredSkill`,`RequiredSkillRank`,`requiredspell`,`requiredhonorrank`,`RequiredCityRank`,`RequiredReputationFaction`,`RequiredReputationRank`,`maxcount`,`stackable`,`ContainerSlots`,`stat_type1`,`stat_value1`,`stat_type2`,`stat_value2`,`stat_type3`,`stat_value3`,`stat_type4`,`stat_value4`,`stat_type5`,`stat_value5`,`stat_type6`,`stat_value6`,`stat_type7`,`stat_value7`,`stat_type8`,`stat_value8`,`stat_type9`,`stat_value9`,`stat_type10`,`stat_value10`,`dmg_min1`,`dmg_max1`,`dmg_type1`,`dmg_min2`,`dmg_max2`,`dmg_type2`,`armor`,`holy_res`,`fire_res`,`nature_res`,`frost_res`,`shadow_res`,`arcane_res`,`delay`,`ammo_type`,`RangedModRange`,`spellid_1`,`spelltrigger_1`,`spellcharges_1`,`spellppmRate_1`,`spellcooldown_1`,`spellcategory_1`,`spellcategorycooldown_1`,`spellid_2`,`spelltrigger_2`,`spellcharges_2`,`spellppmRate_2`,`spellcooldown_2`,`spellcategory_2`,`spellcategorycooldown_2`,`spellid_3`,`spelltrigger_3`,`spellcharges_3`,`spellppmRate_3`,`spellcooldown_3`,`spellcategory_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigger_4`,`spellcharges_4`,`spellppmRate_4`,`spellcooldown_4`,`spellcategory_4`,`spellcategorycooldown_4`,`spellid_5`,`spelltrigger_5`,`spellcharges_5`,`spellppmRate_5`,`spellcooldown_5`,`spellcategory_5`,`spellcategorycooldown_5`,`bonding`,`description`,`PageText`,`LanguageID`,`PageMaterial`,`startquest`,`lockid`,`Material`,`sheath`,`RandomProperty`,`RandomSuffix`,`block`,`itemset`,`MaxDurability`,`area`,`Map`,`BagFamily`,`TotemCategory`,`socketColor_1`,`socketContent_1`,`socketColor_2`,`socketContent_2`,`socketColor_3`,`socketContent_3`,`socketBonus`,`GemProperties`,`RequiredDisenchantSkill`,`ArmorDamageModifier`,`ScriptName`,`DisenchantID`,`FoodType`,`minMoneyLoot`,`maxMoneyLoot` FROM item_template LEFT JOIN locales_item ON item_template.entry = locales_item.entry WHERE item_template.entry = '{$entry}'");
if ($result) {
$item = $sql->fetch_assoc($result);
require_once "scripts/get_lib.php";
//$tooltip = get_item_tooltip($entry);
$output .= "<script type=\"text/javascript\" src=\"libs/js/tab.js\"></script>\n <center>\n <br /><br /><br />\n <form method=\"post\" action=\"item.php?action=do_update\" name=\"form1\">\n <input type=\"hidden\" name=\"backup_op\" value=\"0\"/>\n <input type=\"hidden\" name=\"type\" value=\"edit\"/>\n <input type=\"hidden\" name=\"entry\" value=\"{$entry}\"/>\n\n<div class=\"jtab-container\" id=\"container\">\n <ul class=\"jtabs\">\n <li><a href=\"#\" onclick=\"return showPane('pane1', this)\" id=\"tab1\">{$lang_item_edit['general_tab']}</a></li>\n <li><a href=\"#\" onclick=\"return showPane('pane2', this)\">{$lang_item_edit['additional_tab']}</a></li>\n <li><a href=\"#\" onclick=\"return showPane('pane3', this)\">{$lang_item_edit['stats_tab']}</a></li>\n <li><a href=\"#\" onclick=\"return showPane('pane4', this)\">{$lang_item_edit['damage_tab']}</a></li>\n <li><a href=\"#\" onclick=\"return showPane('pane5', this)\">{$lang_item_edit['spell_tab']}</a></li>\n <li><a href=\"#\" onclick=\"return showPane('pane7', this)\">{$lang_item_edit['sock_tab']}</a></li>\n <li><a href=\"#\" onclick=\"return showPane('pane6', this)\">{$lang_item_edit['req_tab']}</a></li>\n <li><a href=\"#\" onclick=\"return showPane('pane8', this)\">{$lang_item_edit['info']}</a></li>";
if ($item['DisenchantID']) {
$output .= "<li><a href=\"#\" onclick=\"return showPane('pane9', this)\">{$lang_item_edit['disenchant_tab']}</a></li>";
}
$output .= "</ul>\n <div class=\"jtab-panes\">";
$output .= "<div id=\"pane1\">\n <br /><br />\n<table class=\"lined\" style=\"width: 720px;\">\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['general']}:</td></tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['entry'], $lang_item_edit['entry_desc']) . "</td>\n <td>";
//$output .= maketooltip($entry, "$item_datasite$entry", $tooltip, "item_tooltip");
$output .= "</td>\n <td>" . makeinfocell($lang_item_edit['display_id'], $lang_item_edit['display_id_desc']) . "</td>\n <td><input type=\"text\" name=\"displayid\" size=\"8\" maxlength=\"11\" value=\"{$item['displayid']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['req_level'], $lang_item_edit['req_level_desc']) . "</td>\n <td><input type=\"text\" name=\"RequiredLevel\" size=\"8\" maxlength=\"4\" value=\"{$item['RequiredLevel']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['item_level'], $lang_item_edit['item_level_desc']) . "</td>\n <td><input type=\"text\" name=\"ItemLevel\" size=\"8\" maxlength=\"4\" value=\"{$item['ItemLevel']}\" /></td>\n</tr>\n\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['names']}:</td></tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['item_name'], $lang_item_edit['item_name_desc']) . "</td>\n <td colspan=\"3\"><input type=\"text\" name=\"name\" size=\"30\" maxlength=\"225\" value=\"{$item['name']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['script_name'], $lang_item_edit['script_name_desc']) . "</td>\n <td colspan=\"3\"><input type=\"text\" name=\"ScriptName\" size=\"30\" maxlength=\"100\" value=\"{$item['ScriptName']}\" /></td>\n</tr>\n\n<tr>\n <td>" . makeinfocell($lang_item_edit['description'], $lang_item_edit['description_desc']) . "</td>\n <td colspan=\"3\"><input type=\"text\" name=\"description\" size=\"30\" maxlength=\"225\" value=\"{$item['description']}\" /></td>\n <td colspan=\"4\"></td>\n</tr>\n\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['type']}:</td></tr>\n <tr>";
$class = array(0 => "", 1 => "", 2 => "", 4 => "", 5 => "", 6 => "", 7 => "", 9 => "", 11 => "", 12 => "", 13 => "", 14 => "", 15 => "");
$class[$item['class']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['class'], $lang_item_edit['class_desc']) . "</td>\n <td colspan=\"3\"><select name=\"class\">\n <option value=\"0\" {$class[0]}>0 - {$lang_item['consumable']}</option>\n <option value=\"1\" {$class[1]}>1 - {$lang_item['bag']}</option>\n <option value=\"2\" {$class[2]}>2 - {$lang_item['weapon']}</option>\n <option value=\"4\" {$class[4]}>4 - {$lang_item['armor']}</option>\n <option value=\"5\" {$class[5]}>5 - {$lang_item['reagent']}</option>\n <option value=\"6\" {$class[6]}>6 - {$lang_item['projectile']}</option>\n <option value=\"7\" {$class[7]}>7 - {$lang_item['trade_goods']}s</option>\n <option value=\"9\" {$class[9]}>9 - {$lang_item['recipe']}</option>\n <option value=\"11\" {$class[11]}>11 - {$lang_item['quiver']}</option>\n <option value=\"12\" {$class[12]}>12 - {$lang_item['quest']}</option>\n <option value=\"13\" {$class[13]}>13 - {$lang_item['key']}</option>\n <option value=\"14\" {$class[14]}>14 - {$lang_item['permanent']}</option>\n <option value=\"15\" {$class[15]}>15 - {$lang_item['misc_short']}</option>\n </select></td>";
unset($class);
$subclass = array(0 => array(0 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => ""), 1 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => ""), 2 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 10 => "", 11 => "", 12 => "", 13 => "", 14 => "", 15 => "", 16 => "", 17 => "", 18 => "", 19 => "", 20 => ""), 4 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 9 => ""), 6 => array(2 => "", 3 => ""), 7 => array(0 => "", 1 => "", 2 => "", 3 => ""), 9 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => ""), 11 => array(2 => "", 3 => ""), 13 => array(0 => "", 1 => ""));
$subclass[$item['class']][$item['subclass']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['subclass'], $lang_item_edit['subclass_desc']) . "</td>\n <td colspan=\"3\"><select name=\"subclass\">\n <option value=\"0\" {$subclass[0][0]}>0 - {$lang_item['none']}</option>\n <optgroup label=\"Class 0: {$lang_item['consumable']}\">\n <option value=\"0\" {$subclass[0][0]}>0 - {$lang_item['consumable']}</option>\n <option value=\"3\" {$subclass[0][3]}>3 - {$lang_item['potion']}</option>\n <option value=\"4\" {$subclass[0][4]}>4 - {$lang_item['scroll']}</option>\n <option value=\"5\" {$subclass[0][5]}>5 - {$lang_item['bandage']}</option>\n <option value=\"6\" {$subclass[0][6]}>6 - {$lang_item['healthstone']}</option>\n <option value=\"7\" {$subclass[0][7]}>7 - {$lang_item['combat_effect']}</option>\n <optgroup label=\"Class 1: {$lang_item['bag']}\">\n <option value=\"0\" {$subclass[1][0]}>0 - {$lang_item['bag']}</option>\n <option value=\"1\" {$subclass[1][1]}>1 - {$lang_item['soul_shards']}</option>\n <option value=\"2\" {$subclass[1][2]}>2 - {$lang_item['herbs']}</option>\n <option value=\"3\" {$subclass[1][3]}>3 - {$lang_item['enchanting']}</option>\n <option value=\"4\" {$subclass[1][4]}>4 - {$lang_item['engineering']}</option>\n <option value=\"5\" {$subclass[1][5]}>5 - {$lang_item['gems']}</option>\n <option value=\"6\" {$subclass[1][6]}>6 - {$lang_item['mining']}</option>\n <optgroup label=\"Class 2: {$lang_item['weapon']}\">\n <option value=\"0\" {$subclass[2][0]}>0 - {$lang_item['axe_1h']}</option>\n <option value=\"1\" {$subclass[2][2]}>1 - {$lang_item['axe_2h']}</option>\n <option value=\"2\" {$subclass[2][2]}>2 - {$lang_item['bow']}</option>\n <option value=\"3\" {$subclass[2][2]}>3 - {$lang_item['rifle']}</option>\n <option value=\"4\" {$subclass[2][4]}>4 - {$lang_item['mace_1h']}</option>\n <option value=\"5\" {$subclass[2][5]}>5 - {$lang_item['mace_2h']}</option>\n <option value=\"6\" {$subclass[2][6]}>6 - {$lang_item['polearm']}</option>\n <option value=\"7\" {$subclass[2][7]}>7 - {$lang_item['sword_1h']}</option>\n <option value=\"8\" {$subclass[2][8]}>8 - {$lang_item['sword_2h']}</option>\n <option value=\"10\" {$subclass[2][10]}>10 - {$lang_item['staff']}</option>\n <option value=\"11\" {$subclass[2][11]}>11 - {$lang_item['exotic_1h']}</option>\n <option value=\"12\" {$subclass[2][12]}>12 - {$lang_item['exotic_2h']}</option>\n <option value=\"13\" {$subclass[2][13]}>13 - {$lang_item['fist_weapon']}</option>\n <option value=\"14\" {$subclass[2][14]}>14 - {$lang_item['misc_weapon']}</option>\n <option value=\"15\" {$subclass[2][15]}>15 - {$lang_item['dagger']}</option>\n <option value=\"16\" {$subclass[2][16]}>16 - {$lang_item['thrown']}</option>\n <option value=\"17\" {$subclass[2][17]}>17 - {$lang_item['spear']}</option>\n <option value=\"18\" {$subclass[2][18]}>18 - {$lang_item['crossbow']}</option>\n <option value=\"19\" {$subclass[2][19]}>19 - {$lang_item['wand']}</option>\n <option value=\"20\" {$subclass[2][20]}>20 - {$lang_item['fishing_pole']}</option>\n </optgroup>\n <optgroup label=\"Class 4: {$lang_item['armor']}\">\n <option value=\"0\" {$subclass[4][0]}>0 - {$lang_item['misc']}</option>\n <option value=\"1\" {$subclass[4][1]}>1 - {$lang_item['cloth']}</option>\n <option value=\"2\" {$subclass[4][2]}>2 - {$lang_item['leather']}</option>\n <option value=\"3\" {$subclass[4][3]}>3 - {$lang_item['mail']}</option>\n <option value=\"4\" {$subclass[4][4]}>4 - {$lang_item['plate']}</option>\n <option value=\"5\" {$subclass[4][5]}>5 - {$lang_item['buckler']}</option>\n <option value=\"6\" {$subclass[4][6]}>6 - {$lang_item['shield']}</option>\n <option value=\"7\" {$subclass[4][7]}>7 - {$lang_item['libram']}</option>\n <option value=\"8\" {$subclass[4][8]}>8 - {$lang_item['idol']}</option>\n <option value=\"9\" {$subclass[4][9]}>9 - {$lang_item['totem']}</option>\n </optgroup>\n <optgroup label=\"Class 6: {$lang_item['projectile']}\">\n <option value=\"2\" {$subclass[6][2]}>2 - {$lang_item['arrows']}</option>\n <option value=\"3\" {$subclass[6][3]}>3 - {$lang_item['bullets']}</option>\n </optgroup>\n <optgroup label=\"Class 7: {$lang_item['trade_goods']}\">\n <option value=\"0\" {$subclass[7][0]}>0 - {$lang_item['trade_goods']}</option>\n <option value=\"1\" {$subclass[7][1]}>1 - {$lang_item['parts']}</option>\n <option value=\"2\" {$subclass[7][2]}>2 - {$lang_item['explosives']}</option>\n <option value=\"3\" {$subclass[7][3]}>3 - {$lang_item['devices']}</option>\n </optgroup>\n <optgroup label=\"Class 9: {$lang_item['recipe']}\">\n <option value=\"0\" {$subclass[9][0]}>0 - {$lang_item['book']}</option>\n <option value=\"1\" {$subclass[9][1]}>1 - {$lang_item['LW_pattern']}</option>\n <option value=\"2\" {$subclass[9][2]}>2 - {$lang_item['tailoring_pattern']}</option>\n <option value=\"3\" {$subclass[9][3]}>3 - {$lang_item['ENG_Schematic']}</option>\n <option value=\"4\" {$subclass[9][4]}>4 - {$lang_item['BS_plans']}</option>\n <option value=\"5\" {$subclass[9][5]}>5 - {$lang_item['cooking_recipe']}</option>\n <option value=\"6\" {$subclass[9][6]}>6 - {$lang_item['alchemy_recipe']}</option>\n <option value=\"7\" {$subclass[9][7]}>7 - {$lang_item['FA_manual']}</option>\n <option value=\"8\" {$subclass[9][8]}>8 - {$lang_item['ench_formula']}</option>\n <option value=\"9\" {$subclass[9][9]}>9 - {$lang_item['fishing_manual']}</option>\n <option value=\"10\" {$subclass[9][10]}>10 - {$lang_item['JC_formula']}</option>\n </optgroup>\n <optgroup label=\"Class 11: {$lang_item['quiver']}\">\n <option value=\"2\" {$subclass[11][2]}>2 - {$lang_item['quiver']}</option>\n <option value=\"3\" {$subclass[11][3]}>3 - {$lang_item['ammo_pouch']}</option>\n </optgroup>\n <optgroup label=\"Class 13: {$lang_item['key']}\">\n <option value=\"0\" {$subclass[13][0]}>0 - {$lang_item['key']}</option>\n <option value=\"1\" {$subclass[13][1]}>1 - {$lang_item['lockpick']}</option>\n </optgroup>\n </select></td>\n</tr>\n<tr>";
unset($subclass);
$quality = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "");
$quality[$item['Quality']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['quality'], $lang_item_edit['quality_desc']) . "</td>\n <td colspan=\"2\"><select name=\"Quality\">\n <option value=\"0\" {$quality[0]}>0 - {$lang_item['poor']}</option>\n <option value=\"1\" {$quality[1]}>1 - {$lang_item['common']}</option>\n <option value=\"2\" {$quality[2]}>2 - {$lang_item['uncommon']}</option>\n <option value=\"3\" {$quality[3]}>3 - {$lang_item['rare']}</option>\n <option value=\"4\" {$quality[4]}>4 - {$lang_item['epic']}</option>\n <option value=\"5\" {$quality[5]}>5 - {$lang_item['legendary']}</option>\n <option value=\"6\" {$quality[6]}>6 - {$lang_item['artifact']}</option>\n </select></td>";
unset($quality);
$inv_type = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => "", 11 => "", 12 => "", 13 => "", 14 => "", 15 => "", 16 => "", 17 => "", 18 => "", 19 => "", 20 => "", 21 => "", 22 => "", 23 => "", 24 => "", 25 => "", 26 => "");
$inv_type[$item['InventoryType']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['inv_type'], $lang_item_edit['inv_type_desc']) . "</td>\n <td colspan=\"2\"><select name=\"InventoryType\">\n <option value=\"0\" {$inv_type[0]}>0 - {$lang_item['other']}</option>\n <option value=\"1\" {$inv_type[1]}>1 - {$lang_item['head']}</option>\n <option value=\"2\" {$inv_type[2]}>2 - {$lang_item['neck']}</option>\n <option value=\"3\" {$inv_type[3]}>3 - {$lang_item['shoulder']}</option>\n <option value=\"4\" {$inv_type[4]}>4 - {$lang_item['shirt']}</option>\n <option value=\"5\" {$inv_type[5]}>5 - {$lang_item['chest']}</option>\n <option value=\"6\" {$inv_type[6]}>6 - {$lang_item['belt']}</option>\n <option value=\"7\" {$inv_type[7]}>7 - {$lang_item['legs']}</option>\n <option value=\"8\" {$inv_type[8]}>8 - {$lang_item['feet']}</option>\n <option value=\"9\" {$inv_type[9]}>9 - {$lang_item['belt']}</option>\n <option value=\"10\" {$inv_type[10]}>10 - {$lang_item['gloves']}</option>\n <option value=\"11\" {$inv_type[11]}>11 - {$lang_item['finger']}</option>\n <option value=\"12\" {$inv_type[12]}>12 - {$lang_item['trinket']}</option>\n <option value=\"13\" {$inv_type[13]}>13 - {$lang_item['one_hand']}</option>\n <option value=\"14\" {$inv_type[14]}>14 - {$lang_item['off_hand']}</option>\n <option value=\"15\" {$inv_type[15]}>15 - {$lang_item['bow']}</option>\n <option value=\"16\" {$inv_type[16]}>16 - {$lang_item['back']}</option>\n <option value=\"17\" {$inv_type[17]}>17 - {$lang_item['two_hand']}</option>\n <option value=\"18\" {$inv_type[18]}>18 - {$lang_item['bag']}</option>\n <option value=\"19\" {$inv_type[19]}>19 - {$lang_item['tabard']}</option>\n <option value=\"20\" {$inv_type[20]}>20 - {$lang_item['robe']}</option>\n <option value=\"21\" {$inv_type[21]}>21 - {$lang_item['main_hand']}</option>\n <option value=\"22\" {$inv_type[22]}>22 - {$lang_item['off_misc']}</option>\n <option value=\"23\" {$inv_type[23]}>23 - {$lang_item['tome']}</option>\n <option value=\"24\" {$inv_type[24]}>24 - {$lang_item['projectile']}</option>\n <option value=\"25\" {$inv_type[25]}>25 - {$lang_item['thrown']}</option>\n <option value=\"26\" {$inv_type[26]}>26 - {$lang_item['rifle']}</option>\n </select></td>\n\n <td>" . makeinfocell($lang_item_edit['flags'], $lang_item_edit['flags_desc']) . "</td>\n <td><input type=\"text\" name=\"Flags\" size=\"10\" maxlength=\"30\" value=\"{$item['Flags']}\" /></td>\n </tr>\n\n <tr>\n <td>" . makeinfocell($lang_item_edit['item_set'], $lang_item_edit['item_set_desc']) . "</td>\n <td><input type=\"text\" name=\"itemset\" size=\"10\" maxlength=\"30\" value=\"{$item['itemset']}\" /></td>";
unset($inv_type);
$bonding = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "");
$bonding[$item['bonding']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['bonding'], $lang_item_edit['bonding_desc']) . "</td>\n <td colspan=\"3\"><select name=\"bonding\">\n <option value=\"0\" {$bonding[0]}>0 - {$lang_item['no_bind']}</option>\n <option value=\"1\" {$bonding[1]}>1 - {$lang_item['bop']}</option>\n <option value=\"2\" {$bonding[2]}>2 - {$lang_item['boe']}</option>\n <option value=\"3\" {$bonding[3]}>3 - {$lang_item['bou']}</option>\n <option value=\"4\" {$bonding[4]}>4 - {$lang_item['quest_item']}</option>\n <option value=\"5\" {$bonding[5]}>5 - {$lang_item['quest_item']}1</option>\n </select></td>\n\n<td>" . makeinfocell($lang_item_edit['start_quest'], $lang_item_edit['start_quest_desc']) . "</td>\n<td><input type=\"text\" name=\"startquest\" size=\"10\" maxlength=\"30\" value=\"{$item['startquest']}\" /></td>\n\n</tr>\n</table>\n<br />{$lang_item_edit['short_rules_desc']}<br /><br />\n</div>";
unset($bonding);
$output .= "<div id=\"pane2\">\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['vendor']}:</td></tr>\n <tr>\n <td>" . makeinfocell($lang_item_edit['buy_count'], $lang_item_edit['buy_count_desc']) . "</td>\n <td><input type=\"text\" name=\"BuyCount\" size=\"8\" maxlength=\"3\" value=\"{$item['BuyCount']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['buy_price'], $lang_item_edit['buy_price_desc']) . "</td>\n <td><input type=\"text\" name=\"BuyPrice\" size=\"8\" maxlength=\"30\" value=\"{$item['BuyPrice']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['sell_price'], $lang_item_edit['sell_price_desc']) . "</td>\n <td><input type=\"text\" name=\"SellPrice\" size=\"8\" maxlength=\"30\" value=\"{$item['SellPrice']}\" /></td>\n <td></td><td></td>\n </tr>\n\n <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['container']}:</td></tr>\n <tr>\n\n <td>" . makeinfocell($lang_item_edit['max_count'], $lang_item_edit['max_count_desc']) . "</td>\n <td><input type=\"text\" name=\"maxcount\" size=\"6\" maxlength=\"5\" value=\"{$item['maxcount']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['stackable'], $lang_item_edit['stackable_desc']) . "</td>\n <td><input type=\"text\" name=\"stackable\" size=\"6\" maxlength=\"5\" value=\"{$item['stackable']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['bag_family'], $lang_item_edit['bag_family_desc']) . "</td>";
$bagfamily = array(0 => "", 1 => "", 2 => "", 3 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => "", 12 => "");
$bagfamily[$item['BagFamily']] = " selected=\"selected\" ";
$output .= "<td><select name=\"BagFamily\">\n <option value=\"0\" {$bagfamily[0]}>0 - {$lang_item['none']}</option>\n <option value=\"1\" {$bagfamily[1]}>1 - {$lang_item['arrows']}</option>\n <option value=\"2\" {$bagfamily[2]}>2 - {$lang_item['bullets']}</option>\n <option value=\"3\" {$bagfamily[3]}>3 - {$lang_item['soul_shards']}</option>\n <option value=\"6\" {$bagfamily[6]}>6 - {$lang_item['herbs']}</option>\n <option value=\"7\" {$bagfamily[7]}>7 - {$lang_item['enchanting']}</option>\n <option value=\"8\" {$bagfamily[8]}>8 - {$lang_item['engineering']}</option>\n <option value=\"9\" {$bagfamily[9]}>9 - {$lang_item['keys']}</option>\n <option value=\"10\" {$bagfamily[10]}>10 - {$lang_item['gems']}</option>\n <option value=\"12\" {$bagfamily[12]}>12 - {$lang_item['mining']}</option>\n </select></td>\n <td>" . makeinfocell($lang_item_edit['bag_slots'], $lang_item_edit['bag_slots_desc']) . "</td>\n <td><input type=\"text\" name=\"ContainerSlots\" size=\"10\" maxlength=\"3\" value=\"{$item['ContainerSlots']}\" /></td>\n </tr>\n <tr>\n\n <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['materials']}:</td></tr>";
unset($bagfamily);
$Material = array(-1 => "", 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "");
$Material[$item['Material']] = " selected=\"selected\" ";
$output .= "<tr>\n <td>" . makeinfocell($lang_item_edit['material'], $lang_item_edit['material_desc']) . "</td>\n <td colspan=\"2\"><select name=\"Material\">\n <option value=\"-1\" {$Material[-1]}>-1 - {$lang_item_edit['consumables']}</option>\n <option value=\"0\" {$Material[0]}>0 - {$lang_item_edit['none']}</option>\n <option value=\"1\" {$Material[1]}>1 - {$lang_item_edit['metal']}</option>\n <option value=\"2\" {$Material[2]}>2 - {$lang_item_edit['wood']}</option>\n <option value=\"3\" {$Material[3]}>3 - {$lang_item_edit['liquid']}</option>\n <option value=\"4\" {$Material[4]}>4 - {$lang_item_edit['jewelry']}</option>\n <option value=\"5\" {$Material[5]}>5 - {$lang_item_edit['chain']}</option>\n <option value=\"6\" {$Material[6]}>6 - {$lang_item_edit['plate']}</option>\n <option value=\"7\" {$Material[7]}>7 - {$lang_item_edit['cloth']}</option>\n <option value=\"8\" {$Material[8]}>8 - {$lang_item_edit['leather']}</option>\n </select></td>";
unset($Material);
$PageMaterial = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "");
$PageMaterial[$item['PageMaterial']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['page_material'], $lang_item_edit['page_material_desc']) . "</td>\n <td colspan=\"2\"><select name=\"PageMaterial\">\n <option value=\"0\" {$PageMaterial[0]}>0 - {$lang_item_edit['none']}</option>\n <option value=\"1\" {$PageMaterial[1]}>1 - {$lang_item_edit['parchment']}</option>\n <option value=\"2\" {$PageMaterial[2]}>2 - {$lang_item_edit['stone']}</option>\n <option value=\"3\" {$PageMaterial[3]}>3 - {$lang_item_edit['marble']}</option>\n <option value=\"4\" {$PageMaterial[4]}>4 - {$lang_item_edit['silver']}</option>\n <option value=\"5\" {$PageMaterial[5]}>5 - {$lang_item_edit['bronze']}</option>\n </select></td>";
unset($PageMaterial);
$output .= "<td>" . makeinfocell($lang_item_edit['max_durability'], $lang_item_edit['max_durability_desc']) . "</td>\n <td><input type=\"text\" name=\"MaxDurability\" size=\"8\" maxlength=\"30\" value=\"{$item['MaxDurability']}\" /></td>\n</tr>\n\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['RandomProperty']}:</td></tr>\n<tr>\n <td colspan=\"2\">" . makeinfocell($lang_item_edit['RandomProperty'], $lang_item_edit['RandomProperty_desc']) . "</td>\n <td colspan=\"2\"><input type=\"text\" name=\"RandomProperty\" size=\"8\" maxlength=\"30\" value=\"{$item['RandomProperty']}\" /></td>\n\n <td colspan=\"2\">" . makeinfocell($lang_item_edit['RandomSuffix'], $lang_item_edit['RandomSuffix_desc']) . "</td>\n <td colspan=\"2\"><input type=\"text\" name=\"RandomSuffix\" size=\"8\" maxlength=\"10\" value=\"{$item['RandomSuffix']}\" /></td>\n</tr>\n\n\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['other']}:</td></tr>\n <tr>\n <td>" . makeinfocell($lang_item_edit['area'], $lang_item_edit['area_desc']) . "</td>\n <td><input type=\"text\" name=\"area\" size=\"8\" maxlength=\"10\" value=\"{$item['area']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['map'], $lang_item_edit['map_desc']) . "</td>\n <td><input type=\"text\" name=\"Map\" size=\"8\" maxlength=\"10\" value=\"{$item['Map']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['page_text'], $lang_item_edit['page_text_desc']) . "</td>\n <td><input type=\"text\" name=\"PageText\" size=\"6\" maxlength=\"30\" value=\"{$item['PageText']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['unk0'], $lang_item_edit['unk0_desc']) . "</td>\n <td><input type=\"text\" name=\"unk0\" size=\"8\" maxlength=\"10\" value=\"{$item['unk0']}\" /></td>\n </tr>\n <tr>\n\n <tr>\n <td colspan=\"2\">" . makeinfocell($lang_item_edit['disenchant_id'], $lang_item_edit['disenchant_id_desc']) . "</td>\n <td><input type=\"text\" name=\"DisenchantID\" size=\"10\" maxlength=\"10\" value=\"{$item['DisenchantID']}\" /></td>\n\n <td colspan=\"2\">" . makeinfocell($lang_item_edit['req_skill_disenchant'], $lang_item_edit['req_skill_disenchant_desc']) . "</td>\n <td><input type=\"text\" name=\"RequiredDisenchantSkill\" size=\"10\" maxlength=\"10\" value=\"{$item['RequiredDisenchantSkill']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['lock_id'], $lang_item_edit['lock_id_desc']) . "</td>\n <td><input type=\"text\" name=\"lockid\" size=\"8\" maxlength=\"30\" value=\"{$item['lockid']}\" /></td>\n </tr>";
$LanguageID = array(0 => "", 1 => "", 2 => "", 3 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => "", 11 => "", 12 => "", 13 => "", 14 => "", 33 => "");
$LanguageID[$item['LanguageID']] = " selected=\"selected\" ";
$output .= "<tr>\n <td>" . makeinfocell($lang_item_edit['lang_id'], $lang_item_edit['lang_id_desc']) . "</td>\n <td colspan=\"2\"><select name=\"LanguageID\">\n <option value=\"0\" {$LanguageID[0]}>0 - {$lang_item_edit['other']}</option>\n <option value=\"1\" {$LanguageID[1]}>1 - Orcish</option>\n <option value=\"2\" {$LanguageID[2]}>2 - Darnassian</option>\n <option value=\"3\" {$LanguageID[3]}>3 - Taurahe</option>\n <option value=\"6\" {$LanguageID[6]}>6 - Dwarvish</option>\n <option value=\"7\" {$LanguageID[7]}>7 - Common</option>\n <option value=\"8\" {$LanguageID[8]}>8 - Demonic</option>\n <option value=\"9\" {$LanguageID[9]}>9 - Titan</option>\n <option value=\"10\" {$LanguageID[10]}>10 - Thelassian</option>\n <option value=\"11\" {$LanguageID[11]}>11 - Draconic</option>\n <option value=\"12\" {$LanguageID[12]}>12 - Kalimag</option>\n <option value=\"13\" {$LanguageID[13]}>13 - Gnomish</option>\n <option value=\"14\" {$LanguageID[14]}>14 - Troll</option>\n <option value=\"33\" {$LanguageID[33]}>33 - Gutterspeak</option>\n </select></td>";
unset($LanguageID);
$sheath = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 7 => "");
$sheath[$item['sheath']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['sheath'], $lang_item_edit['sheath_desc']) . "</td>\n <td colspan=\"2\"><select name=\"sheath\">\n <option value=\"0\" {$sheath[0]}>0 - {$lang_item_edit['other']}</option>\n <option value=\"1\" {$sheath[1]}>1 - {$lang_item['sword_2h']}</option>\n <option value=\"2\" {$sheath[2]}>2 - {$lang_item['staff']}</option>\n <option value=\"3\" {$sheath[3]}>3 - {$lang_item['sword_1h']}</option>\n <option value=\"4\" {$sheath[4]}>4 - {$lang_item['shield']}</option>\n <option value=\"5\" {$sheath[5]}>5 - {$lang_item['rod']}</option>\n <option value=\"7\" {$sheath[7]}>7 - {$lang_item['off_hand']}</option>\n </select></td>\n\n <td>" . makeinfocell($lang_item_edit['totem_category'], $lang_item_edit['totem_category_desc']) . "</td>\n <td><input type=\"text\" name=\"TotemCategory\" size=\"8\" maxlength=\"10\" value=\"{$item['TotemCategory']}\" /></td>\n </tr>\n\n </table><br /><br />\n </div>";
unset($sheath);
$output .= "<div id=\"pane3\">\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['stats']}:</td></tr>\n <tr>\n\n <td>" . makeinfocell($lang_item_edit['stat_type'] . " 1", $lang_item_edit['stat_type_desc']) . "</td>\n <td><select name=\"stat_type1\">";
output_status_options($item['stat_type1']);
$output .= "</select></td>\n\n <td><input type=\"text\" name=\"stat_value1\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value1']}\" /></td>\n <td>" . makeinfocell($lang_item_edit['stat_type'] . " 2", $lang_item_edit['stat_type_desc']) . "</td>\n <td><select name=\"stat_type2\">";
output_status_options($item['stat_type2']);
$output .= "</select></td>\n\n <td><input type=\"text\" name=\"stat_value2\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value2']}\" /></td>\n </tr>\n <tr>\n <td>" . makeinfocell($lang_item_edit['stat_type'] . " 3", $lang_item_edit['stat_type_desc']) . "</td>\n <td><select name=\"stat_type3\">";
output_status_options($item['stat_type3']);
$output .= "</select></td>\n\n <td><input type=\"text\" name=\"stat_value3\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value3']}\" /></td>\n <td>" . makeinfocell($lang_item_edit['stat_type'] . " 4", $lang_item_edit['stat_type_desc']) . "</td>\n <td><select name=\"stat_type4\">";
output_status_options($item['stat_type4']);
$output .= "</select></td>\n\n <td><input type=\"text\" name=\"stat_value4\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value4']}\" /></td>\n </tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['stat_type'] . " 5", $lang_item_edit['stat_type_desc']) . "</td>\n <td><select name=\"stat_type5\">";
output_status_options($item['stat_type5']);
$output .= "</select></td>\n\n <td><input type=\"text\" name=\"stat_value5\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value5']}\" /></td>\n <td>" . makeinfocell($lang_item_edit['stat_type'] . " 6", $lang_item_edit['stat_type_desc']) . "</td>\n <td><select name=\"stat_type6\">";
output_status_options($item['stat_type1']);
$output .= "</select></td>\n\n <td><input type=\"text\" name=\"stat_value6\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value6']}\" /></td>\n </tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['stat_type'] . " 7", $lang_item_edit['stat_type_desc']) . "</td>\n <td><select name=\"stat_type7\">";
output_status_options($item['stat_type7']);
$output .= "</select></td>\n <td><input type=\"text\" name=\"stat_value7\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value7']}\" /></td>\n <td>" . makeinfocell($lang_item_edit['stat_type'] . " 8", $lang_item_edit['stat_type_desc']) . "</td>\n <td><select name=\"stat_type8\">";
output_status_options($item['stat_type8']);
$output .= "</select></td>\n\n <td><input type=\"text\" name=\"stat_value8\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value8']}\" /></td>\n </tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['stat_type'] . " 9", $lang_item_edit['stat_type_desc']) . "</td>\n <td><select name=\"stat_type9\">";
output_status_options($item['stat_type9']);
$output .= "</select></td>\n <td><input type=\"text\" name=\"stat_value9\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value9']}\" /></td>\n <td>" . makeinfocell($lang_item_edit['stat_type'] . " 10", $lang_item_edit['stat_type_desc']) . "</td>\n <td><select name=\"stat_type10\">";
output_status_options($item['stat_type10']);
$output .= "</select></td>\n\n <td><input type=\"text\" name=\"stat_value10\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value10']}\" /></td>\n </tr>\n\n <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['resis_armor']}:</td></tr>\n <tr>\n <td colspan=\"2\">" . makeinfocell($lang_item['armor'], $lang_item_edit['armor_desc']) . "</td>\n <td><input type=\"text\" name=\"armor\" size=\"10\" maxlength=\"30\" value=\"{$item['armor']}\" /></td>\n\n <td colspan=\"2\">" . makeinfocell($lang_item['block'], $lang_item_edit['block_desc']) . "</td>\n <td><input type=\"text\" name=\"block\" size=\"10\" maxlength=\"30\" value=\"{$item['block']}\" /></td>\n </tr>\n <tr>\n <td colspan=\"2\">" . makeinfocell($lang_item['res_holy'], $lang_item_edit['res_holy_desc']) . "</td>\n <td><input type=\"text\" name=\"holy_res\" size=\"10\" maxlength=\"30\" value=\"{$item['holy_res']}\" /></td>\n\n <td colspan=\"2\">" . makeinfocell($lang_item['res_fire'], $lang_item_edit['res_fire_desc']) . "</td>\n <td><input type=\"text\" name=\"fire_res\" size=\"10\" maxlength=\"30\" value=\"{$item['fire_res']}\" /></td>\n </tr>\n <tr>\n <td colspan=\"2\">" . makeinfocell($lang_item['res_nature'], $lang_item_edit['res_nature_desc']) . "</td>\n <td><input type=\"text\" name=\"nature_res\" size=\"10\" maxlength=\"30\" value=\"{$item['nature_res']}\" /></td>\n\n <td colspan=\"2\">" . makeinfocell($lang_item['res_frost'], $lang_item_edit['res_frost_desc']) . "</td>\n <td><input type=\"text\" name=\"frost_res\" size=\"10\" maxlength=\"30\" value=\"{$item['frost_res']}\" /></td>\n </tr>\n <tr>\n <td colspan=\"2\">" . makeinfocell($lang_item['res_shadow'], $lang_item_edit['res_shadow_desc']) . "</td>\n <td><input type=\"text\" name=\"shadow_res\" size=\"10\" maxlength=\"30\" value=\"{$item['shadow_res']}\" /></td>\n\n <td colspan=\"2\">" . makeinfocell($lang_item['res_arcane'], $lang_item_edit['res_arcane_desc']) . "</td>\n <td><input type=\"text\" name=\"arcane_res\" size=\"10\" maxlength=\"30\" value=\"{$item['arcane_res']}\" /></td>\n </tr>\n\n </table><br /><br />\n </div>";
$output .= "<div id=\"pane4\">\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['weapon_properties']}:</td></tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['delay'], $lang_item_edit['delay_desc']) . "</td>\n <td colspan=\"2\"><input type=\"text\" name=\"delay\" size=\"10\" maxlength=\"11\" value=\"{$item['delay']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['ranged_mod'], $lang_item_edit['ranged_mod_desc']) . "</td>\n <td colspan=\"2\"><input type=\"text\" name=\"RangedModRange\" size=\"10\" maxlength=\"40\" value=\"{$item['RangedModRange']}\" /></td>\n</tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['armor_dmg_mod'], $lang_item_edit['armor_dmg_mod_desc']) . "</td>\n <td colspan=\"2\"><input type=\"text\" name=\"ArmorDamageModifier\" size=\"10\" maxlength=\"40\" value=\"{$item['ArmorDamageModifier']}\" /></td>";
$ammo_type = array(0 => "", 2 => "", 3 => "");
$ammo_type[$item['ammo_type']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['ammo_type'], $lang_item_edit['ammo_type_desc']) . "</td>\n <td colspan=\"2\"><select name=\"ammo_type\">\n <option value=\"0\" {$ammo_type[0]}>0 - {$lang_item['none']}</option>\n <option value=\"2\" {$ammo_type[2]}>2 - {$lang_item['arrows']}</option>\n <option value=\"3\" {$ammo_type[3]}>3 - {$lang_item['bullets']}</option>\n </select></td>\n</tr>\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['weapon_damage']}:</td></tr>\n<tr>";
unset($ammo_type);
$output .= "<td>" . makeinfocell($lang_item_edit['damage_type'] . " 1", $lang_item_edit['damage_type_desc']) . "</td>\n <td colspan=\"2\"><select name=\"dmg_type1\">";
output_dmgtype_options($item['dmg_type1']);
$output .= "</select></td>\n\n <td>" . makeinfocell($lang_item_edit['dmg_min_max'], $lang_item_edit['dmg_min_max_desc']) . "</td>\n <td colspan=\"4\"><input type=\"text\" name=\"dmg_min1\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_min1']}\" /> - <input type=\"text\" name=\"dmg_max1\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_max1']}\" /></td>\n\n</tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['damage_type'] . " 2", $lang_item_edit['damage_type_desc']) . "</td>\n <td colspan=\"2\"><select name=\"dmg_type2\">";
output_dmgtype_options($item['dmg_type2']);
$output .= "</select></td>\n\n <td>" . makeinfocell($lang_item_edit['dmg_min_max'], $lang_item_edit['dmg_min_max_desc']) . "</td>\n <td colspan=\"4\"><input type=\"text\" name=\"dmg_min2\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_min2']}\" /> - <input type=\"text\" name=\"dmg_max2\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_max2']}\" /></td>\n\n</tr>\n</table><br /><br />\n </div>";
$output .= "<div id=\"pane5\">\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n<tr>\n <td colspan=\"2\">{$lang_item_edit['item_spell']} 1</td>\n <td>" . makeinfocell($lang_item_edit['spell_id'], $lang_item_edit['spell_id_desc']) . "</td>\n <td><input type=\"text\" name=\"spellid_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_1']}\" /></td>";
$spelltrigger_1 = array(0 => "", 1 => "", 2 => "", 4 => "");
$spelltrigger_1[$item['spelltrigger_1']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['spell_trigger'], $lang_item_edit['spell_trigger_desc']) . "</td>\n <td><select name=\"spelltrigger_1\">\n <option value=\"0\" {$spelltrigger_1[0]}>0: {$lang_item['spell_use']}</option>\n <option value=\"1\" {$spelltrigger_1[1]}>1: {$lang_item['spell_equip']}</option>\n <option value=\"2\" {$spelltrigger_1[2]}>2: {$lang_item['spell_coh']}</option>\n <option value=\"4\" {$spelltrigger_1[4]}>4: {$lang_item['soul_stone']}</option>\n </select></td>\n <td>" . makeinfocell($lang_item_edit['spell_charges'], $lang_item_edit['spell_charges_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcharges_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_1']}\" /></td>\n</tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['spell_cooldown'], $lang_item_edit['spell_cooldown_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcooldown_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_1']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['spell_category'], $lang_item_edit['spell_category_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcategory_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_1']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['spell_category_cooldown'], $lang_item_edit['spell_category_cooldown_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcategorycooldown_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_1']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['ppm_rate'], $lang_item_edit['ppm_rate_desc']) . "</td>\n <td><input type=\"text\" name=\"spellppmRate_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellppmRate_1']}\" /></td>\n</tr>\n<tr><td colspan=\"6\" class=\"hidden\"></td></tr>\n<tr>\n <td colspan=\"2\">{$lang_item_edit['item_spell']} 2</td>\n <td>" . makeinfocell($lang_item_edit['spell_id'], $lang_item_edit['spell_id_desc']) . "</td>\n <td><input type=\"text\" name=\"spellid_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_2']}\" /></td>";
unset($spelltrigger_1);
$spelltrigger_2 = array(0 => "", 1 => "", 2 => "", 4 => "");
$spelltrigger_2[$item['spelltrigger_2']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['spell_trigger'], $lang_item_edit['spell_trigger_desc']) . "</td>\n <td><select name=\"spelltrigger_2\">\n <option value=\"0\" {$spelltrigger_2[0]}>0: {$lang_item['spell_use']}</option>\n <option value=\"1\" {$spelltrigger_2[1]}>1: {$lang_item['spell_equip']}</option>\n <option value=\"2\" {$spelltrigger_2[2]}>2: {$lang_item['spell_coh']}</option>\n <option value=\"4\" {$spelltrigger_2[4]}>4: {$lang_item['soul_stone']}</option>\n </select></td>\n <td>" . makeinfocell($lang_item_edit['spell_charges'], $lang_item_edit['spell_charges_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcharges_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_2']}\" /></td>\n</tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['spell_cooldown'], $lang_item_edit['spell_cooldown_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcooldown_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_2']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['spell_category'], $lang_item_edit['spell_category_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcategory_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_2']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['spell_category_cooldown'], $lang_item_edit['spell_category_cooldown_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcategorycooldown_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_2']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['ppm_rate'], $lang_item_edit['ppm_rate_desc']) . "</td>\n <td><input type=\"text\" name=\"spellppmRate_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellppmRate_2']}\" /></td>\n</tr>\n<tr><td colspan=\"6\" class=\"hidden\"></td></tr>\n<tr>\n <td colspan=\"2\">{$lang_item_edit['item_spell']} 3</td>\n <td>" . makeinfocell($lang_item_edit['spell_id'], $lang_item_edit['spell_id_desc']) . "</td>\n <td><input type=\"text\" name=\"spellid_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_3']}\" /></td>";
unset($spelltrigger_2);
$spelltrigger_3 = array(0 => "", 1 => "", 2 => "", 4 => "");
$spelltrigger_3[$item['spelltrigger_3']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['spell_trigger'], $lang_item_edit['spell_trigger_desc']) . "</td>\n <td><select name=\"spelltrigger_3\">\n <option value=\"0\" {$spelltrigger_3[0]}>0: {$lang_item['spell_use']}</option>\n <option value=\"1\" {$spelltrigger_3[1]}>1: {$lang_item['spell_equip']}</option>\n <option value=\"2\" {$spelltrigger_3[2]}>2: {$lang_item['spell_coh']}</option>\n <option value=\"4\" {$spelltrigger_3[4]}>4: {$lang_item['soul_stone']}</option>\n </select></td>\n <td>" . makeinfocell($lang_item_edit['spell_charges'], $lang_item_edit['spell_charges_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcharges_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_3']}\" /></td>\n</tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['spell_cooldown'], $lang_item_edit['spell_cooldown_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcooldown_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_3']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['spell_category'], $lang_item_edit['spell_category_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcategory_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_3']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['spell_category_cooldown'], $lang_item_edit['spell_category_cooldown_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcategorycooldown_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_3']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['ppm_rate'], $lang_item_edit['ppm_rate_desc']) . "</td>\n <td><input type=\"text\" name=\"spellppmRate_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellppmRate_3']}\" /></td>\n</tr>\n<tr><td colspan=\"6\" class=\"hidden\"></td></tr>\n<tr>\n <td colspan=\"2\">{$lang_item_edit['item_spell']} 4</td>\n <td>" . makeinfocell($lang_item_edit['spell_id'], $lang_item_edit['spell_id_desc']) . "</td>\n <td><input type=\"text\" name=\"spellid_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_4']}\" /></td>";
unset($spelltrigger_3);
$spelltrigger_4 = array(0 => "", 1 => "", 2 => "", 4 => "");
$spelltrigger_4[$item['spelltrigger_4']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['spell_trigger'], $lang_item_edit['spell_trigger_desc']) . "</td>\n <td><select name=\"spelltrigger_4\">\n <option value=\"0\" {$spelltrigger_4[0]}>0: {$lang_item['spell_use']}</option>\n <option value=\"1\" {$spelltrigger_4[1]}>1: {$lang_item['spell_equip']}</option>\n <option value=\"2\" {$spelltrigger_4[2]}>2: {$lang_item['spell_coh']}</option>\n <option value=\"4\" {$spelltrigger_4[4]}>4: {$lang_item['soul_stone']}</option>\n </select></td>\n <td>" . makeinfocell($lang_item_edit['spell_charges'], $lang_item_edit['spell_charges_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcharges_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_4']}\" /></td>\n</tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['spell_cooldown'], $lang_item_edit['spell_cooldown_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcooldown_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_4']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['spell_category'], $lang_item_edit['spell_category_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcategory_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_4']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['spell_category_cooldown'], $lang_item_edit['spell_category_cooldown_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcategorycooldown_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_4']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['ppm_rate'], $lang_item_edit['ppm_rate_desc']) . "</td>\n <td><input type=\"text\" name=\"spellppmRate_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellppmRate_4']}\" /></td>\n</tr>\n<tr><td colspan=\"6\" class=\"hidden\"></td></tr>\n<tr>\n <td colspan=\"2\">{$lang_item_edit['item_spell']} 5</td>\n <td>" . makeinfocell($lang_item_edit['spell_id'], $lang_item_edit['spell_id_desc']) . "</td>\n <td><input type=\"text\" name=\"spellid_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_5']}\" /></td>";
unset($spelltrigger_4);
$spelltrigger_5 = array(0 => "", 1 => "", 2 => "", 4 => "");
$spelltrigger_5[$item['spelltrigger_5']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['spell_trigger'], $lang_item_edit['spell_trigger_desc']) . "</td>\n <td><select name=\"spelltrigger_5\">\n <option value=\"0\" {$spelltrigger_5[0]}>0: {$lang_item['spell_use']}</option>\n <option value=\"1\" {$spelltrigger_5[1]}>1: {$lang_item['spell_equip']}</option>\n <option value=\"2\" {$spelltrigger_5[2]}>2: {$lang_item['spell_coh']}</option>\n <option value=\"4\" {$spelltrigger_5[4]}>4: {$lang_item['soul_stone']}</option>\n </select></td>\n <td>" . makeinfocell($lang_item_edit['spell_charges'], $lang_item_edit['spell_charges_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcharges_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_5']}\" /></td>\n</tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['spell_cooldown'], $lang_item_edit['spell_cooldown_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcooldown_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_5']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['spell_category'], $lang_item_edit['spell_category_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcategory_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_5']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['spell_category_cooldown'], $lang_item_edit['spell_category_cooldown_desc']) . "</td>\n <td><input type=\"text\" name=\"spellcategorycooldown_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_5']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['ppm_rate'], $lang_item_edit['ppm_rate_desc']) . "</td>\n <td><input type=\"text\" name=\"spellppmRate_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellppmRate_5']}\" /></td>\n</tr>\n\n</table>\n </div>";
unset($spelltrigger_5);
$output .= "<div id=\"pane6\">\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n <tr>";
$AllowableClass = array(-1 => "", 1 => "", 2 => "", 4 => "", 8 => "", 16 => "", 32 => "", 64 => "", 128 => "", 256 => "", 512 => "", 1024 => "");
if ($item['AllowableClass'] == -1) {
$AllowableClass[-1] = " selected=\"selected\" ";
} else {
if ($item['AllowableClass'] & 1) {
$AllowableClass[1] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 2) {
$AllowableClass[2] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 4) {
$AllowableClass[4] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 8) {
$AllowableClass[8] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 16) {
$AllowableClass[16] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 32) {
$AllowableClass[32] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 64) {
$AllowableClass[64] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 128) {
$AllowableClass[128] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 256) {
$AllowableClass[256] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 512) {
$AllowableClass[512] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 1024) {
$AllowableClass[1024] = " selected=\"selected\" ";
}
}
$output .= "<td>" . makeinfocell($lang_item_edit['allow_class'], $lang_item_edit['allow_class_desc']) . "</td>\n <td><select multiple=\"multiple\" name=\"AllowableClass[]\" size=\"5\">\n <option value=\"-1\" {$AllowableClass[-1]}>-1 - {$lang_item_edit['all']}</option>\n <option value=\"1\" {$AllowableClass[1]}>1 - {$lang_id_tab['warrior']}</option>\n <option value=\"2\" {$AllowableClass[2]}>2 - {$lang_id_tab['paladin']}</option>\n <option value=\"4\" {$AllowableClass[4]}>4 - {$lang_id_tab['hunter']}</option>\n <option value=\"8\" {$AllowableClass[8]}>8 - {$lang_id_tab['rogue']}</option>\n <option value=\"16\" {$AllowableClass[16]}>16 - {$lang_id_tab['priest']}</option>\n <option value=\"32\" {$AllowableClass[32]}>32 - FUTURE_1</option>\n <option value=\"64\" {$AllowableClass[64]}>64 - {$lang_id_tab['shaman']}</option>\n <option value=\"128\" {$AllowableClass[128]}>128 - {$lang_id_tab['mage']}</option>\n <option value=\"256\" {$AllowableClass[256]}>256 - {$lang_id_tab['warlock']}</option>\n <option value=\"512\" {$AllowableClass[512]}>512 - FUTURE_2</option>\n <option value=\"1024\" {$AllowableClass[1024]}>1024 - {$lang_id_tab['druid']}</option>\n </select></td>";
unset($AllowableClass);
$AllowableRace = array(-1 => "", 1 => "", 2 => "", 4 => "", 8 => "", 16 => "", 32 => "", 64 => "", 128 => "", 256 => "", 512 => "");
if ($item['AllowableRace'] == -1) {
$AllowableRace[-1] = " selected=\"selected\" ";
} else {
if ($item['AllowableRace'] & 1) {
$AllowableRace[1] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 2) {
$AllowableRace[2] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 4) {
$AllowableRace[4] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 8) {
$AllowableRace[8] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 16) {
$AllowableRace[16] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 32) {
$AllowableRace[32] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 64) {
$AllowableRace[64] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 128) {
$AllowableRace[128] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 256) {
$AllowableRace[256] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 512) {
$AllowableRace[512] = " selected=\"selected\" ";
}
}
$output .= "<td>" . makeinfocell($lang_item_edit['allow_race'], $lang_item_edit['allow_race_desc']) . "</td>\n <td><select multiple=\"multiple\" name=\"AllowableRace[]\" size=\"5\">\n <option value=\"-1\" {$AllowableRace[-1]}>-1 - {$lang_item_edit['all']}</option>\n <option value=\"1\" {$AllowableRace[1]}>1 - {$lang_id_tab['human']}</option>\n <option value=\"2\" {$AllowableRace[2]}>2 - {$lang_id_tab['orc']}</option>\n <option value=\"4\" {$AllowableRace[4]}>4 - {$lang_id_tab['dwarf']}</option>\n <option value=\"8\" {$AllowableRace[8]}>8 - {$lang_id_tab['nightelf']}</option>\n <option value=\"16\" {$AllowableRace[16]}>16 - {$lang_id_tab['undead']}</option>\n <option value=\"32\" {$AllowableRace[32]}>32 - {$lang_id_tab['tauren']}</option>\n <option value=\"64\" {$AllowableRace[64]}>64 - {$lang_id_tab['gnome']}</option>\n <option value=\"128\" {$AllowableRace[128]}>128 - {$lang_id_tab['troll']}</option>\n <option value=\"256\" {$AllowableRace[256]}>256 - {$lang_id_tab['draenei']}</option>\n <option value=\"512\" {$AllowableRace[512]}>512 - {$lang_id_tab['bloodelf']}</option>\n </select></td>\n</tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['req_skill'], $lang_item_edit['req_skill_desc']) . "</td>\n <td><input type=\"text\" name=\"RequiredSkill\" size=\"15\" maxlength=\"30\" value=\"{$item['RequiredSkill']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['req_skill_rank'], $lang_item_edit['req_skill_rank_desc']) . "</td>\n <td><input type=\"text\" name=\"RequiredSkillRank\" size=\"15\" maxlength=\"30\" value=\"{$item['RequiredSkillRank']}\" /></td>\n</tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['req_spell'], $lang_item_edit['req_spell_desc']) . "</td>\n <td><input type=\"text\" name=\"requiredspell\" size=\"15\" maxlength=\"30\" value=\"{$item['requiredspell']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['req_honor_rank'], $lang_item_edit['req_honor_rank_desc']) . "</td>\n <td><input type=\"text\" name=\"requiredhonorrank\" size=\"15\" maxlength=\"30\" value=\"{$item['requiredhonorrank']}\" /></td>\n</tr>\n<tr>\n <td>" . makeinfocell($lang_item_edit['req_rep_faction'], $lang_item_edit['req_rep_faction_desc']) . "</td>\n <td><input type=\"text\" name=\"RequiredReputationFaction\" size=\"15\" maxlength=\"30\" value=\"{$item['RequiredReputationFaction']}\" /></td>";
unset($AllowableRace);
$RequiredReputationRank = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "");
$RequiredReputationRank[$item['RequiredReputationRank']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['req_rep_rank'], $lang_item_edit['req_rep_rank_desc']) . "</td>\n <td><select name=\"RequiredReputationRank\">\n <option value=\"0\" {$RequiredReputationRank[0]}>0 - {$lang_item_edit['hated']}</option>\n <option value=\"1\" {$RequiredReputationRank[1]}>1 - {$lang_item_edit['hostile']}</option>\n <option value=\"2\" {$RequiredReputationRank[2]}>2 - {$lang_item_edit['unfriendly']}</option>\n <option value=\"3\" {$RequiredReputationRank[3]}>3 - {$lang_item_edit['neutral']}</option>\n <option value=\"4\" {$RequiredReputationRank[4]}>4 - {$lang_item_edit['friendly']}</option>\n <option value=\"5\" {$RequiredReputationRank[5]}>5 - {$lang_item_edit['honored']}</option>\n <option value=\"6\" {$RequiredReputationRank[6]}>6 - {$lang_item_edit['reverted']}</option>\n <option value=\"7\" {$RequiredReputationRank[7]}>7 - {$lang_item_edit['exalted']}</option>\n </select></td>\n</tr>\n<tr>\n <td colspan=\"2\">" . makeinfocell($lang_item_edit['req_city_rank'], $lang_item_edit['req_city_rank_desc']) . "</td>\n <td colspan=\"2\"><input type=\"text\" name=\"RequiredCityRank\" size=\"15\" maxlength=\"30\" value=\"{$item['RequiredCityRank']}\" /></td>\n</tr>\n\n </table><br /><br />\n </div>";
unset($RequiredReputationRank);
$output .= "<div id=\"pane7\">\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n<tr>";
$socketColor_1 = array(0 => "", 1 => "", 2 => "", 4 => "", 8 => "");
$socketColor_1[$item['socketColor_1']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['socket_color'] . " 1", $lang_item_edit['socket_color_desc']) . "</td>\n <td><select name=\"socketColor_1\">\n <option value=\"0\" {$socketColor_1[0]}>0: {$lang_item['none']}</option>\n <option value=\"1\" {$socketColor_1[1]}>1: {$lang_item['socket_meta']}</option>\n <option value=\"2\" {$socketColor_1[2]}>2: {$lang_item['socket_red']}</option>\n <option value=\"4\" {$socketColor_1[4]}>4: {$lang_item['socket_yellow']}</option>\n <option value=\"8\" {$socketColor_1[8]}>8: {$lang_item['socket_blue']}</option>\n </select></td>\n <td>" . makeinfocell($lang_item_edit['socket_content'] . " 1", $lang_item_edit['socket_content_desc']) . "</td>\n <td><input type=\"text\" name=\"socketContent_1\" size=\"15\" maxlength=\"10\" value=\"{$item['socketContent_1']}\" /></td>\n</tr>\n<tr>";
unset($socketColor_1);
$socketColor_2 = array(0 => "", 1 => "", 2 => "", 4 => "", 8 => "");
$socketColor_2[$item['socketColor_2']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['socket_color'] . " 2", $lang_item_edit['socket_color_desc']) . "</td>\n <td><select name=\"socketColor_2\">\n <option value=\"0\" {$socketColor_2[0]}>0: {$lang_item['none']}</option>\n <option value=\"1\" {$socketColor_2[1]}>1: {$lang_item['socket_meta']}</option>\n <option value=\"2\" {$socketColor_2[2]}>2: {$lang_item['socket_red']}</option>\n <option value=\"4\" {$socketColor_2[4]}>4: {$lang_item['socket_yellow']}</option>\n <option value=\"8\" {$socketColor_2[8]}>8: {$lang_item['socket_blue']}</option>\n </select></td>\n\n <td>" . makeinfocell($lang_item_edit['socket_content'] . " 2", $lang_item_edit['socket_content_desc']) . "</td>\n <td><input type=\"text\" name=\"socketContent_2\" size=\"15\" maxlength=\"10\" value=\"{$item['socketContent_2']}\" /></td>\n</tr>\n<tr>";
unset($socketColor_2);
$socketColor_3 = array(0 => "", 1 => "", 2 => "", 4 => "", 8 => "");
$socketColor_3[$item['socketColor_3']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell($lang_item_edit['socket_color'] . " 3", $lang_item_edit['socket_color_desc']) . "</td>\n <td><select name=\"socketColor_3\">\n <option value=\"0\" {$socketColor_3[0]}>0: {$lang_item['none']}</option>\n <option value=\"1\" {$socketColor_3[1]}>1: {$lang_item['socket_meta']}</option>\n <option value=\"2\" {$socketColor_3[2]}>2: {$lang_item['socket_red']}</option>\n <option value=\"4\" {$socketColor_3[4]}>4: {$lang_item['socket_yellow']}</option>\n <option value=\"8\" {$socketColor_3[8]}>8: {$lang_item['socket_blue']}</option>\n </select></td>\n\n <td>" . makeinfocell($lang_item_edit['socket_content'] . " 3", $lang_item_edit['socket_content_desc']) . "</td>\n <td><input type=\"text\" name=\"socketContent_3\" size=\"15\" maxlength=\"10\" value=\"{$item['socketContent_3']}\" /></td>\n</tr>\n\n<tr>\n <td>" . makeinfocell($lang_item_edit['socket_bonus'], $lang_item_edit['socket_bonus_desc']) . "</td>\n <td><input type=\"text\" name=\"socketBonus\" size=\"15\" maxlength=\"10\" value=\"{$item['socketBonus']}\" /></td>\n\n <td>" . makeinfocell($lang_item_edit['gem_properties'], $lang_item_edit['gem_properties_desc']) . "</td>\n <td><input type=\"text\" name=\"GemProperties\" size=\"15\" maxlength=\"10\" value=\"{$item['GemProperties']}\" /></td>\n</tr>\n\n </table><br /><br />\n </div>";
$output .= "<div id=\"pane8\">\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n <tr class=\"large_bold\"><td colspan=\"5\" class=\"hidden\" align=\"left\">{$lang_item_edit['dropped_by']}: {$lang_item_edit['top_x']}</td></tr>\n <tr>\n <th width=\"1%\">ID</th>\n <th width=\"35%\">{$lang_item_edit['mob_name']}</th>\n <th width=\"10%\">{$lang_item_edit['mob_level']}</th>\n <th width=\"25%\">{$lang_item_edit['mob_drop_chance']}</th>\n <th width=\"25%\">{$lang_item_edit['mob_quest_drop_chance']}</th>\n </tr>";
$result2 = $sql->query("SELECT entry,ChanceOrQuestChance,`groupid` FROM creature_loot_template WHERE item = {$item['entry']} ORDER BY `groupid`,ChanceOrQuestChance DESC LIMIT 5");
while ($info = $sql->fetch_row($result2)) {
$result3 = $sql->query("SELECT creature_template.entry,IFNULL(" . ($deplang != 0 ? "name_loc{$deplang}" : "NULL") . ",`name`) as name,maxlevel FROM creature_template LEFT JOIN locales_creature ON creature_template.entry = locales_creature.entry WHERE lootid = {$info[0]} LIMIT 1");
while ($mob = $sql->fetch_row($result3)) {
$output .= "<tr><td>";
if ($user_lvl >= $action_permission['delete']) {
$output .= "<a class=\"tooltip\" href=\"creature.php?action=edit&entry={$mob['0']}&error=4\" target=\"_blank\">{$mob['0']}</a>";
} else {
$output .= "{$mob['0']}";
}
$output .= "</td>\n <td><a class=\"tooltip\" href=\"{$creature_datasite}{$mob['0']}\" target=\"_blank\">{$mob['1']}</a></td>\n <td>{$mob['2']}</td>\n <td>{$info['1']}%</td>\n <td>{$info['2']}%</td></tr>";
}
}
$result2 = $sql->query("SELECT creature_template.entry,IFNULL(" . ($deplang != 0 ? "name_loc{$deplang}" : "NULL") . ",`name`) as name,maxlevel FROM creature_template LEFT JOIN locales_creature ON creature_template.entry = locales_creature.entry WHERE creature_template.entry IN (SELECT entry FROM npc_vendor WHERE item = {$item['entry']}) ORDER BY maxlevel DESC LIMIT 5");
if ($sql->num_rows($result2)) {
$output .= "<tr class=\"large_bold\"><td colspan=\"4\" class=\"hidden\" align=\"left\">{$lang_item_edit['sold_by']}: {$lang_item_edit['limit_x']}</td></tr>";
while ($mob = $sql->fetch_row($result2)) {
$output .= "<tr>\n <td width=\"10%\">";
if ($user_lvl >= $action_permission['delete']) {
$output .= "<a class=\"tooltip\" href=\"creature.php?action=edit&entry={$mob['0']}&error=4\" target=\"_blank\">{$mob['0']}</a>";
} else {
$output .= "{$mob['0']}";
}
$output .= "\n <td width=\"10%\">{$mob['2']}</td>\n <td width=\"80%\" colspan=\"2\" align=\"left\">\n <a class=\"tooltip\" href=\"{$creature_datasite}{$mob['0']}\" target=\"_blank\">{$mob['1']}</a></td>\n </td></tr>";
}
}
$result2 = $sql->query("SELECT quest_template.entry,IFNULL(" . ($deplang != 0 ? "title_loc{$deplang}" : "NULL") . ",`title`) as title,QuestLevel FROM quest_template LEFT JOIN locales_quest ON quest_template.entry = locales_quest.entry WHERE ( SrcItemId = {$item['entry']} OR ReqItemId1 = {$item['entry']} OR\n ReqItemId2 = {$item['entry']} OR ReqItemId3 = {$item['entry']} OR ReqItemId4 = {$item['entry']} OR RewItemId1 = {$item['entry']} OR\n RewItemId2 = {$item['entry']} OR RewItemId3 = {$item['entry']} OR RewItemId4 = {$item['entry']} ) ORDER BY QuestLevel DESC");
if ($sql->num_rows($result2)) {
$output .= "<tr class=\"large_bold\"><td colspan=\"4\" class=\"hidden\" align=\"left\">{$lang_item_edit['involved_in_quests']}:</td></tr>";
while ($quest = $sql->fetch_row($result2)) {
$output .= "<tr><td width=\"20%\">id: {$quest['0']}</td>\n <td width=\"80%\" colspan=\"3\" align=\"left\"><a class=\"tooltip\" href=\"{$quest_datasite}{$quest['0']}\" target=\"_blank\">({$quest['2']}) {$quest['1']}</a></td></tr>";
}
}
$result2 = $sql->query("SELECT quest_template.entry,IFNULL(" . ($deplang != 0 ? "title_loc{$deplang}" : "NULL") . ",`title`) as title,QuestLevel FROM quest_template LEFT JOIN locales_quest ON quest_template.entry = locales_quest.entry WHERE ( RewChoiceItemId1 = {$item['entry']} OR RewChoiceItemId2 = {$item['entry']} OR\n RewChoiceItemId3 = {$item['entry']} OR RewChoiceItemId4 = {$item['entry']} OR RewChoiceItemId5 = {$item['entry']} OR RewChoiceItemId6 = {$item['entry']} )\n ORDER BY QuestLevel DESC");
if ($sql->num_rows($result2)) {
$output .= "<tr class=\"large_bold\"><td colspan=\"4\" class=\"hidden\" align=\"left\">{$lang_item_edit['reward_from_quest']}:</td></tr>";
while ($quest = $sql->fetch_row($result2)) {
$output .= "<tr><td width=\"20%\">id: {$quest['0']}</td>\n <td width=\"80%\" colspan=\"3\" align=\"left\"><a class=\"tooltip\" href=\"{$quest_datasite}{$quest['0']}\" target=\"_blank\">({$quest['2']}) {$quest['1']}</a></td></tr>";
}
}
$output .= "</tr></table><br /><br />\n </div>";
if ($item['DisenchantID']) {
$output .= "<div id=\"pane9\">\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\n <tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_item_edit['disenchant_templ']}: {$item['DisenchantID']}</td></tr>\n <tr><td colspan=\"6\">";
$cel_counter = 0;
$row_flag = 0;
$output .= "<table class=\"hidden\" align=\"center\"><tr>";
$result1 = $sql->query("SELECT item,ChanceOrQuestChance,`groupid`,mincountOrRef,maxcount,lootcondition,condition_value1, condition_value2 FROM disenchant_loot_template WHERE entry = {$item['DisenchantID']} ORDER BY ChanceOrQuestChance DESC");
while ($item = $sql->fetch_row($result1)) {
$cel_counter++;
$tooltip = get_item_name($item[0]) . " ({$item['0']})<br />{$lang_item_edit['drop_chance']}: {$item['1']}%<br />{$lang_item_edit['quest_drop_chance']}: {$item['2']}%<br />{$lang_item_edit['drop_chance']}: {$item['3']}-{$item['4']}<br />{$lang_item_edit['lootcondition']}: {$item['5']}<br />{$lang_item_edit['condition_value1']}: {$item['6']}<br />{$lang_item_edit['condition_value2']}: {$item['7']}";
$output .= "<td>";
$output .= maketooltip("<img src=\"" . get_item_icon($item[0]) . "\" class=\"icon_border\" alt=\"\" />", "{$item_datasite}{$item['0']}", $tooltip, "item_tooltip");
$output .= "<br /><input type=\"checkbox\" name=\"del_de_items[]\" value=\"{$item['0']}\" /></td>";
if ($cel_counter >= 16) {
$cel_counter = 0;
$output .= "</tr><tr>";
$row_flag++;
}
}
if ($row_flag) {
$output .= "<td colspan=\"" . (16 - $cel_counter) . "\"></td>";
}
$output .= "</td></tr></table>\n </td>\n</tr>\n<tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_item_edit['add_items_to_templ']}:</td></tr>\n<tr>\n<td>" . makeinfocell($lang_item_edit['loot_item_id'], $lang_item_edit['loot_item_id_desc']) . "</td>\n <td><input type=\"text\" name=\"de_item\" size=\"8\" maxlength=\"10\" value=\"\" /></td>\n<td>" . makeinfocell($lang_item_edit['loot_drop_chance'], $lang_item_edit['loot_drop_chance_desc']) . "</td>\n <td><input type=\"text\" name=\"de_ChanceOrQuestChance\" size=\"8\" maxlength=\"11\" value=\"0\" /></td>\n<td>" . makeinfocell($lang_item_edit['loot_quest_drop_chance'], $lang_item_edit['loot_quest_drop_chance_desc']) . "</td>\n <td><input type=\"text\" name=\"de_groupid\" size=\"8\" maxlength=\"10\" value=\"0\" /></td>\n</tr>\n<tr>\n<td>" . makeinfocell($lang_item_edit['min_count'], $lang_item_edit['min_count_desc']) . "</td>\n <td><input type=\"text\" name=\"de_mincountOrRef\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>\n<td>" . makeinfocell($lang_item_edit['max_count'], $lang_item_edit['max_count_desc']) . "</td>\n <td><input type=\"text\" name=\"de_maxcount\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>\n</tr>\n<tr>\n<td>" . makeinfocell($lang_item_edit['lootcondition'], $lang_item_edit['lootcondition_desc']) . "</td>\n <td><input type=\"text\" name=\"de_lootcondition\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>\n<td>" . makeinfocell($lang_item_edit['condition_value1'], $lang_item_edit['condition_value1_desc']) . "</td>\n <td><input type=\"text\" name=\"de_condition_value1\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>\n<td>" . makeinfocell($lang_item_edit['condition_value2'], $lang_item_edit['condition_value2_desc']) . "</td>\n <td><input type=\"text\" name=\"de_condition_value2\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>\n</tr>\n</table>\n</div>";
}
$output .= "</div>\n</div>\n<br />\n</form>\n\n<script type=\"text/javascript\">setupPanes(\"container\", \"tab1\")</script>";
unset($socketColor_3);
$output .= "\n <table class=\"hidden\">\n <tr>\n <td>";
if ($user_lvl >= $action_permission['delete']) {
makebutton($lang_item_edit['del_item'], "item.php?action=delete&entry={$entry}\" type=\"wrn", 180);
}
$output .= "\n </td>\n <td>";
if ($user_lvl >= $action_permission['update']) {
makebutton($lang_item_edit['update'], "javascript:do_submit('form1',0)\" type=\"wrn", 180);
}
$output .= "\n </td>\n <td>";
if ($user_lvl >= $action_permission['insert']) {
makebutton($lang_item_edit['export_sql'], "javascript:do_submit('form1',1)", 180);
}
$output .= "\n </td>\n <td>";
makebutton($lang_global['back'], "javascript:window.history.back()", 130);
$output .= "\n </td>\n <td>";
makebutton($lang_item_edit['new_search'], "item.php", 130);
$output .= "\n </td>\n </tr>\n </table>\n </center>\n";
} else {
error($lang_item_edit['item_not_found']);
exit;
}
}
function do_update()
{
global $world_db, $realm_id, $action_permission, $user_lvl, $locales_search_option;
// on update, use replace.. and else insert
if ($_POST['insert'] == "1") {
if ($user_lvl < $action_permission['insert']) {
redirect("creature.php?error=9");
}
$db_action_creature = "INSERT";
} else {
if ($user_lvl < $action_permission['update']) {
redirect("creature.php?error=9");
}
$db_action_creature = "REPLACE";
}
//($del_trainer_spell || $del_loot_items || $del_skin_items || $del_pp_items || $del_questrelation || $del_involvedrelation || $del_vendor_item ) &&
if ($user_lvl < $action_permission['delete']) {
redirect("creature.php?error=9");
}
$deplang = get_lang_id();
if (!isset($_POST['entry']) || $_POST['entry'] === '') {
redirect("creature.php?error=1");
}
$sql = new SQL();
$sql->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);
$entry = $sql->quote_smart($_POST['entry']);
if (isset($_POST['difficulty_entry_1']) && $_POST['difficulty_entry_1'] != '') {
$difficulty_entry_1 = $sql->quote_smart($_POST['difficulty_entry_1']);
} else {
$difficulty_entry_1 = 0;
}
if (isset($_POST['modelid1']) && $_POST['modelid2'] != '') {
$modelid1 = $sql->quote_smart($_POST['modelid1']);
} else {
$modelid1 = 0;
}
if (isset($_POST['modelid3']) && $_POST['modelid3'] != '') {
$modelid3 = $sql->quote_smart($_POST['modelid3']);
} else {
$modelid3 = 0;
}
if (isset($_POST['name']) && $_POST['name'] != '') {
$name = $sql->quote_smart($_POST['name']);
} else {
$name = "";
}
if (isset($_POST['subname']) && $_POST['subname'] != '') {
$subname = $sql->quote_smart($_POST['subname']);
} else {
$subname = "";
}
if (isset($_POST['minlevel']) && $_POST['minlevel'] != '') {
$minlevel = $sql->quote_smart($_POST['minlevel']);
} else {
$minlevel = 0;
}
if (isset($_POST['maxlevel']) && $_POST['maxlevel'] != '') {
$maxlevel = $sql->quote_smart($_POST['maxlevel']);
} else {
$maxlevel = 0;
}
if (isset($_POST['faction_A']) && $_POST['faction_A'] != '') {
$faction_A = $sql->quote_smart($_POST['faction_A']);
} else {
$faction_A = 0;
}
if (isset($_POST['faction_H']) && $_POST['faction_H'] != '') {
$faction_H = $sql->quote_smart($_POST['faction_H']);
} else {
$faction_H = 0;
}
if (isset($_POST['npcflag'])) {
$npcflag = $sql->quote_smart($_POST['npcflag']);
} else {
$npcflag = 0;
}
if (isset($_POST['speed_walk']) && $_POST['speed_walk'] != '') {
$speed_walk = $sql->quote_smart($_POST['speed_walk']);
} else {
$speed_walk = 0;
}
if (isset($_POST['rank']) && $_POST['rank'] != '') {
$rank = $sql->quote_smart($_POST['rank']);
} else {
$rank = 0;
}
if (isset($_POST['mindmg']) && $_POST['mindmg'] != '') {
$mindmg = $sql->quote_smart($_POST['mindmg']);
} else {
$mindmg = 0;
}
if (isset($_POST['maxdmg']) && $_POST['maxdmg'] != '') {
$maxdmg = $sql->quote_smart($_POST['maxdmg']);
} else {
$maxdmg = 0;
}
if (isset($_POST['dmgschool']) && $_POST['dmgschool'] != '') {
$dmgschool = $sql->quote_smart($_POST['dmgschool']);
} else {
$dmgschool = 0;
}
if (isset($_POST['attackpower']) && $_POST['attackpower'] != '') {
$attackpower = $sql->quote_smart($_POST['attackpower']);
} else {
$attackpower = 0;
}
if (isset($_POST['baseattacktime']) && $_POST['baseattacktime'] != '') {
$baseattacktime = $sql->quote_smart($_POST['baseattacktime']);
} else {
$baseattacktime = 0;
}
if (isset($_POST['rangeattacktime']) && $_POST['rangeattacktime'] != '') {
$rangeattacktime = $sql->quote_smart($_POST['rangeattacktime']);
} else {
$rangeattacktime = 0;
}
if (isset($_POST['unit_flags']) && $_POST['unit_flags'] != '') {
$unit_flags = $sql->quote_smart($_POST['unit_flags']);
} else {
$unit_flags = 0;
}
if (isset($_POST['dynamicflags']) && $_POST['dynamicflags'] != '') {
$dynamicflags = $sql->quote_smart($_POST['dynamicflags']);
} else {
$dynamicflags = 0;
}
if (isset($_POST['family']) && $_POST['family'] != '') {
$family = $sql->quote_smart($_POST['family']);
} else {
$family = 0;
}
if (isset($_POST['trainer_type']) && $_POST['trainer_type'] != '') {
$trainer_type = $sql->quote_smart($_POST['trainer_type']);
} else {
$trainer_type = 0;
}
if (isset($_POST['trainer_spell']) && $_POST['trainer_spell'] != '') {
$trainer_spell = $sql->quote_smart($_POST['trainer_spell']);
} else {
$trainer_spell = 0;
}
if (isset($_POST['trainer_class']) && $_POST['trainer_class'] != '') {
$trainer_class = $sql->quote_smart($_POST['trainer_class']);
} else {
$trainer_class = 0;
}
if (isset($_POST['trainer_race']) && $_POST['trainer_race'] != '') {
$trainer_race = $sql->quote_smart($_POST['trainer_race']);
} else {
$trainer_race = 0;
}
if (isset($_POST['minrangedmg']) && $_POST['minrangedmg'] != '') {
$minrangedmg = $sql->quote_smart($_POST['minrangedmg']);
} else {
$minrangedmg = 0;
}
if (isset($_POST['maxrangedmg']) && $_POST['maxrangedmg'] != '') {
$maxrangedmg = $sql->quote_smart($_POST['maxrangedmg']);
} else {
$maxrangedmg = 0;
}
if (isset($_POST['rangedattackpower']) && $_POST['rangedattackpower'] != '') {
$rangedattackpower = $sql->quote_smart($_POST['rangedattackpower']);
} else {
$rangedattackpower = 0;
}
if (isset($_POST['combat_reach']) && $_POST['combat_reach'] != '') {
$combat_reach = $sql->quote_smart($_POST['combat_reach']);
} else {
$combat_reach = 0;
}
if (isset($_POST['type']) && $_POST['type'] != '') {
$type = $sql->quote_smart($_POST['type']);
} else {
$type = 0;
}
if (isset($_POST['flags_extra']) && $_POST['flags_extra'] != '') {
$flags_extra = $sql->quote_smart($_POST['flags_extra']);
} else {
$flags_extra = 0;
}
if (isset($_POST['type_flags']) && $_POST['type_flags'] != '') {
$type_flags = $sql->quote_smart($_POST['type_flags']);
} else {
$type_flags = 0;
}
if (isset($_POST['lootid']) && $_POST['lootid'] != '') {
$lootid = $sql->quote_smart($_POST['lootid']);
} else {
$lootid = 0;
}
if (isset($_POST['pickpocketloot']) && $_POST['pickpocketloot'] != '') {
$pickpocketloot = $sql->quote_smart($_POST['pickpocketloot']);
} else {
$pickpocketloot = 0;
}
if (isset($_POST['skinloot']) && $_POST['skinloot'] != '') {
$skinloot = $sql->quote_smart($_POST['skinloot']);
} else {
$skinloot = 0;
}
if (isset($_POST['resistance1']) && $_POST['resistance1'] != '') {
$resistance1 = $sql->quote_smart($_POST['resistance1']);
} else {
$resistance1 = 0;
}
if (isset($_POST['resistance2']) && $_POST['resistance2'] != '') {
$resistance2 = $sql->quote_smart($_POST['resistance2']);
} else {
$resistance2 = 0;
}
if (isset($_POST['resistance3']) && $_POST['resistance3'] != '') {
$resistance3 = $sql->quote_smart($_POST['resistance3']);
} else {
$resistance3 = 0;
}
if (isset($_POST['resistance4']) && $_POST['resistance4'] != '') {
$resistance4 = $sql->quote_smart($_POST['resistance4']);
} else {
$resistance4 = 0;
}
if (isset($_POST['resistance5']) && $_POST['resistance5'] != '') {
$resistance5 = $sql->quote_smart($_POST['resistance5']);
} else {
$resistance5 = 0;
}
if (isset($_POST['resistance6']) && $_POST['resistance6'] != '') {
$resistance6 = $sql->quote_smart($_POST['resistance6']);
} else {
$resistance6 = 0;
}
if (isset($_POST['spell1']) && $_POST['spell1'] != '') {
$spell1 = $sql->quote_smart($_POST['spell1']);
} else {
$spell1 = 0;
}
if (isset($_POST['spell2']) && $_POST['spell2'] != '') {
$spell2 = $sql->quote_smart($_POST['spell2']);
} else {
$spell2 = 0;
}
if (isset($_POST['spell3']) && $_POST['spell3'] != '') {
$spell3 = $sql->quote_smart($_POST['spell3']);
} else {
$spell3 = 0;
}
if (isset($_POST['spell4']) && $_POST['spell4'] != '') {
$spell4 = $sql->quote_smart($_POST['spell4']);
} else {
$spell4 = 0;
}
if (isset($_POST['mingold']) && $_POST['mingold'] != '') {
$mingold = $sql->quote_smart($_POST['mingold']);
} else {
$mingold = 0;
}
if (isset($_POST['maxgold']) && $_POST['maxgold'] != '') {
$maxgold = $sql->quote_smart($_POST['maxgold']);
} else {
$maxgold = 0;
}
if (isset($_POST['AIName']) && $_POST['AIName'] != '') {
$AIName = $sql->quote_smart($_POST['AIName']);
} else {
$AIName = "";
}
if (isset($_POST['MovementType']) && $_POST['MovementType'] != '') {
$MovementType = $sql->quote_smart($_POST['MovementType']);
} else {
$MovementType = 0;
}
if (isset($_POST['InhabitType']) && $_POST['InhabitType'] != '') {
$InhabitType = $sql->quote_smart($_POST['InhabitType']);
} else {
$InhabitType = 0;
}
if (isset($_POST['ScriptName']) && $_POST['ScriptName'] != '') {
$ScriptName = $sql->quote_smart($_POST['ScriptName']);
} else {
$ScriptName = "";
}
if (isset($_POST['RacialLeader']) && $_POST['RacialLeader'] != '') {
$RacialLeader = $sql->quote_smart($_POST['RacialLeader']);
} else {
$RacialLeader = 0;
}
if (isset($_POST['ChanceOrQuestChance']) && $_POST['ChanceOrQuestChance'] != '') {
$ChanceOrQuestChance = $sql->quote_smart($_POST['ChanceOrQuestChance']);
} else {
$ChanceOrQuestChance = 0;
}
if (isset($_POST['groupid']) && $_POST['groupid'] != '') {
$groupid = $sql->quote_smart($_POST['groupid']);
} else {
$groupid = 0;
}
if (isset($_POST['mincountOrRef']) && $_POST['mincountOrRef'] != '') {
$mincountOrRef = $sql->quote_smart($_POST['mincountOrRef']);
} else {
$mincountOrRef = 0;
}
if (isset($_POST['maxcount']) && $_POST['maxcount'] != '') {
$maxcount = $sql->quote_smart($_POST['maxcount']);
} else {
$maxcount = 0;
}
if (isset($_POST['lootcondition']) && $_POST['lootcondition'] != '') {
$lootcondition = $sql->quote_smart($_POST['lootcondition']);
} else {
$lootcondition = 0;
}
if (isset($_POST['condition_value1']) && $_POST['condition_value1'] != '') {
$condition_value1 = $sql->quote_smart($_POST['condition_value1']);
} else {
$condition_value1 = 0;
}
if (isset($_POST['condition_value2']) && $_POST['condition_value2'] != '') {
$condition_value2 = $sql->quote_smart($_POST['condition_value2']);
} else {
$condition_value2 = 0;
}
if (isset($_POST['item']) && $_POST['item'] != '') {
$item = $sql->quote_smart($_POST['item']);
} else {
$item = 0;
}
if (isset($_POST['del_loot_items']) && $_POST['del_loot_items'] != '') {
$del_loot_items = $sql->quote_smart($_POST['del_loot_items']);
} else {
$del_loot_items = NULL;
}
if (isset($_POST['involvedrelation']) && $_POST['involvedrelation'] != '') {
$involvedrelation = $sql->quote_smart($_POST['involvedrelation']);
} else {
$involvedrelation = 0;
}
if (isset($_POST['del_involvedrelation']) && $_POST['del_involvedrelation'] != '') {
$del_involvedrelation = $sql->quote_smart($_POST['del_involvedrelation']);
} else {
$del_involvedrelation = NULL;
}
if (isset($_POST['questrelation']) && $_POST['questrelation'] != '') {
$questrelation = $sql->quote_smart($_POST['questrelation']);
} else {
$questrelation = 0;
}
if (isset($_POST['del_questrelation']) && $_POST['del_questrelation'] != '') {
$del_questrelation = $sql->quote_smart($_POST['del_questrelation']);
} else {
$del_questrelation = NULL;
}
if (isset($_POST['del_vendor_item']) && $_POST['del_vendor_item'] != '') {
$del_vendor_item = $sql->quote_smart($_POST['del_vendor_item']);
} else {
$del_vendor_item = NULL;
}
if (isset($_POST['vendor_item']) && $_POST['vendor_item'] != '') {
$vendor_item = $sql->quote_smart($_POST['vendor_item']);
} else {
$vendor_item = 0;
}
if (isset($_POST['vendor_maxcount']) && $_POST['vendor_maxcount'] != '') {
$vendor_maxcount = $sql->quote_smart($_POST['vendor_maxcount']);
} else {
$vendor_maxcount = 0;
}
if (isset($_POST['vendor_incrtime']) && $_POST['vendor_incrtime'] != '') {
$vendor_incrtime = $sql->quote_smart($_POST['vendor_incrtime']);
} else {
$vendor_incrtime = 0;
}
if (isset($_POST['vendor_extended_cost']) && $_POST['vendor_extended_cost'] != '') {
$vendor_extended_cost = $sql->quote_smart($_POST['vendor_extended_cost']);
} else {
$vendor_extended_cost = 0;
}
if (isset($_POST['skin_ChanceOrQuestChance']) && $_POST['skin_ChanceOrQuestChance'] != '') {
$skin_ChanceOrQuestChance = $sql->quote_smart($_POST['skin_ChanceOrQuestChance']);
} else {
$skin_ChanceOrQuestChance = 0;
}
if (isset($_POST['skin_groupid']) && $_POST['skin_groupid'] != '') {
$skin_groupid = $sql->quote_smart($_POST['skin_groupid']);
} else {
$skin_groupid = 0;
}
if (isset($_POST['skin_mincountOrRef']) && $_POST['skin_mincountOrRef'] != '') {
$skin_mincountOrRef = $sql->quote_smart($_POST['skin_mincountOrRef']);
} else {
$skin_mincountOrRef = 0;
}
if (isset($_POST['skin_maxcount']) && $_POST['skin_maxcount'] != '') {
$skin_maxcount = $sql->quote_smart($_POST['skin_maxcount']);
} else {
$skin_maxcount = 0;
}
if (isset($_POST['skin_lootcondition']) && $_POST['skin_lootcondition'] != '') {
$skin_lootcondition = $sql->quote_smart($_POST['skin_lootcondition']);
} else {
$skin_lootcondition = 0;
}
if (isset($_POST['skin_condition_value1']) && $_POST['skin_condition_value1'] != '') {
$skin_condition_value1 = $sql->quote_smart($_POST['skin_condition_value1']);
} else {
$skin_condition_value1 = 0;
}
if (isset($_POST['skin_condition_value2']) && $_POST['skin_condition_value2'] != '') {
$skin_condition_value2 = $sql->quote_smart($_POST['skin_condition_value2']);
} else {
$skin_condition_value2 = 0;
}
if (isset($_POST['skin_item']) && $_POST['skin_item'] != '') {
$skin_item = $sql->quote_smart($_POST['skin_item']);
} else {
$skin_item = 0;
}
if (isset($_POST['del_skin_items']) && $_POST['del_skin_items'] != '') {
$del_skin_items = $sql->quote_smart($_POST['del_skin_items']);
} else {
$del_skin_items = NULL;
}
if (isset($_POST['pp_ChanceOrQuestChance']) && $_POST['pp_ChanceOrQuestChance'] != '') {
$pp_ChanceOrQuestChance = $sql->quote_smart($_POST['pp_ChanceOrQuestChance']);
} else {
$pp_ChanceOrQuestChance = 0;
}
if (isset($_POST['pp_groupid']) && $_POST['pp_groupid'] != '') {
$pp_groupid = $sql->quote_smart($_POST['pp_groupid']);
} else {
$pp_groupid = 0;
}
if (isset($_POST['pp_mincountOrRef']) && $_POST['pp_mincountOrRef'] != '') {
$pp_mincountOrRef = $sql->quote_smart($_POST['pp_mincountOrRef']);
} else {
$pp_mincountOrRef = 0;
}
if (isset($_POST['pp_maxcount']) && $_POST['pp_maxcount'] != '') {
$pp_maxcount = $sql->quote_smart($_POST['pp_maxcount']);
} else {
$pp_maxcount = 0;
}
if (isset($_POST['pp_lootcondition']) && $_POST['pp_lootcondition'] != '') {
$pp_lootcondition = $sql->quote_smart($_POST['pp_lootcondition']);
} else {
$pp_lootcondition = 0;
}
if (isset($_POST['pp_condition_value1']) && $_POST['pp_condition_value1'] != '') {
$pp_condition_value1 = $sql->quote_smart($_POST['pp_condition_value1']);
} else {
$pp_condition_value1 = 0;
}
if (isset($_POST['pp_condition_value2']) && $_POST['pp_condition_value2'] != '') {
$pp_condition_value2 = $sql->quote_smart($_POST['pp_condition_value2']);
} else {
$pp_condition_value2 = 0;
}
if (isset($_POST['pp_item']) && $_POST['pp_item'] != '') {
$pp_item = $sql->quote_smart($_POST['pp_item']);
} else {
$pp_item = 0;
}
if (isset($_POST['del_pp_items']) && $_POST['del_pp_items'] != '') {
$del_pp_items = $sql->quote_smart($_POST['del_pp_items']);
} else {
$del_pp_items = NULL;
}
if (isset($_POST['trainer_spell']) && $_POST['trainer_spell'] != '') {
$trainer_spell = $sql->quote_smart($_POST['trainer_spell']);
} else {
$trainer_spell = 0;
}
if (isset($_POST['spellcost']) && $_POST['spellcost'] != '') {
$spellcost = $sql->quote_smart($_POST['spellcost']);
} else {
$spellcost = 0;
}
if (isset($_POST['reqskill']) && $_POST['reqskill'] != '') {
$reqskill = $sql->quote_smart($_POST['reqskill']);
} else {
$reqskill = 0;
}
if (isset($_POST['reqskillvalue']) && $_POST['reqskillvalue'] != '') {
$reqskillvalue = $sql->quote_smart($_POST['reqskillvalue']);
} else {
$reqskillvalue = 0;
}
if (isset($_POST['reqlevel']) && $_POST['reqlevel'] != '') {
$reqlevel = $sql->quote_smart($_POST['reqlevel']);
} else {
$reqlevel = 0;
}
if (isset($_POST['del_trainer_spell']) && $_POST['del_trainer_spell'] != '') {
$del_trainer_spell = $sql->quote_smart($_POST['del_trainer_spell']);
} else {
$del_trainer_spell = NULL;
}
if ($locales_search_option != 0) {
// locales
for ($lc = 1; $lc < 9; $lc++) {
if (isset($_POST['name_loc' . $lc]) && $_POST['name_loc' . $lc] != '' && !preg_match('/^[\\t\\v\\b\\f\\a\\n\\r\\\\"\\? <>[](){}_=+-|!@#$%^&*~`.,\\0]{1,30}$/', $_POST['name_loc' . $lc])) {
$name_loc[$lc] = $sql->quote_smart($_POST['name_loc' . $lc]);
} else {
$name_loc[$lc] = '';
}
if (isset($_POST['subname_loc' . $lc]) && $_POST['subname_loc' . $lc] != '' && !preg_match('/^[\\t\\v\\b\\f\\a\\n\\r\\\\"\\? <>[](){}_=+-|!@#$%^&*~`.,\\0]{1,30}$/', $_POST['subname_loc' . $lc])) {
$subname_loc[$lc] = $sql->quote_smart($_POST['subname_loc' . $lc]);
} else {
$subname_loc[$lc] = '';
}
}
}
$tmp = 0;
for ($t = 0; $t < count($npcflag); $t++) {
if ($npcflag[$t] & 1) {
$tmp = $tmp + 1;
}
if ($npcflag[$t] & 2) {
$tmp = $tmp + 2;
}
if ($npcflag[$t] & 16) {
$tmp = $tmp + 16;
}
if ($npcflag[$t] & 128) {
$tmp = $tmp + 128;
}
if ($npcflag[$t] & 4096) {
$tmp = $tmp + 4096;
}
if ($npcflag[$t] & 8192) {
$tmp = $tmp + 8192;
}
if ($npcflag[$t] & 16384) {
$tmp = $tmp + 16384;
}
if ($npcflag[$t] & 65536) {
$tmp = $tmp + 65536;
}
if ($npcflag[$t] & 131072) {
$tmp = $tmp + 131072;
}
if ($npcflag[$t] & 262144) {
$tmp = $tmp + 262144;
}
if ($npcflag[$t] & 524288) {
$tmp = $tmp + 524288;
}
if ($npcflag[$t] & 1048576) {
$tmp = $tmp + 1048576;
}
if ($npcflag[$t] & 2097152) {
$tmp = $tmp + 2097152;
}
if ($npcflag[$t] & 4194304) {
$tmp = $tmp + 4194304;
}
if ($npcflag[$t] & 268435456) {
$tmp = $tmp + 268435456;
}
}
$npcflag = $tmp ? $tmp : 0;
// insert or update creature
$sql_query = "{$db_action_creature} INTO creature_template ( entry, difficulty_entry_1, modelid1, modelid3, name, subname, minlevel, maxlevel, faction_A, faction_H, npcflag, speed_walk, rank, mindmg, maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, flags_extra, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, ScriptName) VALUES ( '{$entry}', '{$difficulty_entry_1}', '{$modelid1}', '{$modelid3}', '{$name}', '{$subname}', '{$minlevel}', '{$maxlevel}', '{$faction_A}', '{$faction_A}', '{$npcflag}', '{$speed_walk}', '{$rank}', '{$mindmg}', '{$maxdmg}', '{$dmgschool}', '{$attackpower}', '{$baseattacktime}', '{$rangeattacktime}', '{$unit_flags}', '{$dynamicflags}', '{$family}', '{$trainer_type}', '{$trainer_spell}', '{$trainer_class}', '{$trainer_race}', '{$minrangedmg}', '{$maxrangedmg}', '{$rangedattackpower}', '{$type}', '{$flags_extra}', '{$type_flags}', '{$lootid}', '{$pickpocketloot}', '{$skinloot}', '{$resistance1}', '{$resistance2}', '{$resistance3}', '{$resistance4}', '{$resistance5}', '{$resistance6}', '{$spell1}', '{$spell2}', '{$spell3}', '{$spell4}', '{$mingold}', '{$maxgold}', '{$AIName}', '{$MovementType}', '{$InhabitType}', '{$RacialLeader}', '{$ScriptName}' );\n";
if ($trainer_spell) {
$sql_query .= "{$db_action_creature} INTO npc_trainer (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES ({$entry},{$trainer_spell},{$spellcost},{$reqskill} ,{$reqskillvalue} ,{$reqlevel});\n";
}
if ($del_trainer_spell) {
foreach ($del_trainer_spell as $spell_id) {
$sql_query .= "DELETE FROM npc_trainer WHERE entry = {$entry} AND spell = {$spell_id};\n";
}
}
if ($item) {
$sql_query .= "{$db_action_creature} INTO creature_loot_template (entry, item, ChanceOrQuestChance, `groupid`, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2) VALUES ({$lootid},{$item},'{$ChanceOrQuestChance}', '{$groupid}' ,{$mincountOrRef} ,{$maxcount} ,{$lootcondition} ,{$condition_value1} ,{$condition_value2});\n";
}
if ($del_loot_items) {
foreach ($del_loot_items as $item_id) {
$sql_query .= "DELETE FROM creature_loot_template WHERE entry = {$lootid} AND item = {$item_id};\n";
}
}
if ($skin_item) {
$sql_query .= "{$db_action_creature} INTO skinning_loot_template (entry, item, ChanceOrQuestChance, `groupid`, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2) VALUES ({$skinloot},{$skin_item},'{$skin_ChanceOrQuestChance}', '{$skin_groupid}' ,{$skin_mincountOrRef} ,{$skin_maxcount} ,{$skin_lootcondition} ,{$skin_condition_value1} ,{$skin_condition_value2});\n";
}
if ($del_skin_items) {
foreach ($del_skin_items as $item_id) {
$sql_query .= "DELETE FROM skinning_loot_template WHERE entry = {$skinloot} AND item = {$item_id};\n";
}
}
if ($pp_item) {
$sql_query .= "{$db_action_creature} INTO pickpocketing_loot_template (entry, item, ChanceOrQuestChance, `groupid`, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2) VALUES ({$pickpocketloot},{$pp_item},'{$pp_ChanceOrQuestChance}', '{$pp_groupid}' ,{$pp_mincountOrRef} ,{$pp_maxcount} ,{$pp_lootcondition} ,{$pp_condition_value1} ,{$pp_condition_value2});\n";
}
if ($del_pp_items) {
foreach ($del_pp_items as $item_id) {
$sql_query .= "DELETE FROM pickpocketing_loot_template WHERE entry = {$pickpocketloot} AND item = {$item_id};\n";
}
}
if ($questrelation) {
$sql_query .= "{$db_action_creature} INTO creature_questrelation (id, quest) VALUES ({$entry},{$questrelation});\n";
}
if ($involvedrelation) {
$sql_query .= "{$db_action_creature} INTO creature_involvedrelation (id, quest) VALUES ({$entry},{$involvedrelation});\n";
}
if ($del_questrelation) {
foreach ($del_questrelation as $quest_id) {
$sql_query .= "DELETE FROM creature_questrelation WHERE id = {$entry} AND quest = {$quest_id};\n";
}
}
if ($del_involvedrelation) {
foreach ($del_involvedrelation as $quest_id) {
$sql_query .= "DELETE FROM creature_involvedrelation WHERE id = {$entry} AND quest = {$quest_id};\n";
}
}
if ($del_vendor_item) {
foreach ($del_vendor_item as $item_id) {
$sql_query .= "DELETE FROM npc_vendor WHERE entry = {$entry} AND item = {$item_id};\n";
}
}
if ($vendor_item) {
$sql_query .= "{$db_action_creature} INTO npc_vendor (entry, item, maxcount, incrtime, ExtendedCost) VALUES ({$entry},{$vendor_item},{$vendor_maxcount},{$vendor_incrtime},{$vendor_extended_cost});\n";
}
if ($locales_search_option != 0) {
if ($name_loc) {
$sql_query .= "{$db_action_creature} INTO locales_creature (`entry`, `name_loc1`, `name_loc2`, `name_loc3`, `name_loc4`, `name_loc5`, `name_loc6`, `name_loc7`, `name_loc8`, `subname_loc1`, `subname_loc2`, `subname_loc3`, `subname_loc4`, `subname_loc5`, `subname_loc6`, `subname_loc7`, `subname_loc8`) VALUES ('{$entry}', '{$name_loc['1']}', '{$name_loc['2']}', '{$name_loc['3']}', '{$name_loc['4']}', '{$name_loc['5']}', '{$name_loc['6']}', '{$name_loc['7']}', '{$name_loc['8']}', '{$subname_loc['1']}', '{$subname_loc['2']}', '{$subname_loc['3']}', '{$subname_loc['4']}', '{$subname_loc['5']}', '{$subname_loc['6']}', '{$subname_loc['7']}', '{$subname_loc['8']}');\n";
}
}
if (isset($_POST['backup_op']) && $_POST['backup_op'] == 1) {
$sql->close();
Header("Content-type: application/octet-stream");
Header("Content-Disposition: attachment; filename=creatureid_{$entry}.sql");
echo $sql_query;
exit;
redirect("creature.php?action=edit&entry={$entry}&error=4");
} else {
$sql_query = explode(';', $sql_query);
foreach ($sql_query as $tmp_query) {
if ($tmp_query && $tmp_query != "\n") {
$result = $sql->query($tmp_query);
}
}
$sql->close();
}
if ($result) {
redirect("creature.php?action=edit&entry={$entry}&error=4");
} else {
redirect("creature.php");
}
}
function edit()
{
global $lang_global, $lang_game_object, $output, $world_db, $realm_id, $item_datasite, $go_datasite, $go_type, $quest_datasite;
wowhead_tt();
if (!isset($_GET['entry'])) {
redirect("game_object.php?error=1");
}
$sql = new SQL();
$sql->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);
$entry = $sql->quote_smart($_GET['entry']);
require_once "./scripts/get_lib.php";
$deplang = get_lang_id();
$result = $sql->query("SELECT gameobject_template.`entry`,`type`,`displayId`,IFNULL(" . ($deplang != 0 ? "name_loc{$deplang}" : "NULL") . ",`name`) as name,`faction`,`flags`,`size`,`data0`,`data1`,`data2`,`data3`,`data4`,`data5`,`data6`,`data7`,`data8`,`data9`,`data10`,`data11`,`data12`,`data13`,`data14`,`data15`,`data16`,`data17`,`data18`,`data19`,`data20`,`data21`,`data22`,`data23`,`ScriptName` FROM gameobject_template LEFT JOIN locales_gameobject ON gameobject_template.entry = locales_gameobject.entry WHERE gameobject_template.entry = '{$entry}'");
if ($go = $sql->fetch_assoc($result)) {
$output .= "<script type=\"text/javascript\" src=\"libs/js/tab.js\"></script>\r\n <center>\r\n <br /><br /><br />\r\n <form method=\"post\" action=\"game_object.php?action=do_update\" name=\"form1\">\r\n <input type=\"hidden\" name=\"backup_op\" value=\"0\"/>\r\n <input type=\"hidden\" name=\"opp_type\" value=\"edit\"/>\r\n <input type=\"hidden\" name=\"entry\" value=\"{$entry}\"/>\r\n\r\n<div class=\"jtab-container\" id=\"container\">\r\n <ul class=\"jtabs\">\r\n <li><a href=\"#\" onclick=\"return showPane('pane1', this)\" id=\"tab1\">{$lang_game_object['general']}</a></li>\r\n <li><a href=\"#\" onclick=\"return showPane('pane2', this)\">{$lang_game_object['datas']}</a></li>";
if ($go['type'] == 3) {
$output .= "<li><a href=\"#\" onclick=\"return showPane('pane3', this)\">{$lang_game_object['loot']}</a></li>";
}
$output .= "<li><a href=\"#\" onclick=\"return showPane('pane4', this)\">{$lang_game_object['quests']}</a></li>\r\n </ul>\r\n <div class=\"jtab-panes\">";
$output .= "<div id=\"pane1\"><br /><br />\r\n<table class=\"lined\" style=\"width: 720px;\">\r\n<tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_game_object['general']}:</td></tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['entry'], $lang_game_object['entry_desc']) . "</td>\r\n <td><a href=\"{$go_datasite}{$go['entry']}\" target=\"_blank\">{$go['entry']}</a></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['name'], $lang_game_object['name_desc']) . "</td>\r\n <td ><input type=\"text\" name=\"name\" size=\"25\" maxlength=\"100\" value=\"{$go['name']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['faction'], $lang_game_object['faction_desc']) . "</td>\r\n <td><input type=\"text\" name=\"faction\" size=\"10\" maxlength=\"4\" value=\"{$go['faction']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['type'], $lang_game_object['type_desc']) . "</td>\r\n <td colspan=\"3\"><select name=\"type\">";
foreach ($go_type as $type) {
$output .= "<option value=\"{$type['0']}\" ";
if ($type[0] == $go['type']) {
$output .= "selected=\"selected\" ";
}
$output .= ">({$type['0']}) {$type['1']}</option>";
}
$output .= "</select></td>\r\n <td>" . makeinfocell($lang_game_object['displayId'], $lang_game_object['displayId_desc']) . "</td>\r\n <td><input type=\"text\" name=\"displayId\" size=\"10\" maxlength=\"11\" value=\"{$go['displayId']}\" /></td>\r\n\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['flags'], $lang_game_object['flags_desc']) . "</td>\r\n <td><input type=\"text\" name=\"flags\" size=\"10\" maxlength=\"4\" value=\"{$go['flags']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['size'], $lang_game_object['size_desc']) . "</td>\r\n <td><input type=\"text\" name=\"size\" size=\"10\" maxlength=\"25\" value=\"{$go['size']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['script_name'], $lang_game_object['ScriptName_desc']) . "</td>\r\n <td><input type=\"text\" name=\"ScriptName\" size=\"10\" maxlength=\"100\" value=\"{$go['ScriptName']}\" /></td>\r\n</tr>\r\n\r\n<tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_game_object['data']}:</td></tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 0", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data0\" size=\"10\" maxlength=\"11\" value=\"{$go['data0']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 1", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data1\" size=\"10\" maxlength=\"11\" value=\"{$go['data1']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 2", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data2\" size=\"10\" maxlength=\"11\" value=\"{$go['data2']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 3", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data3\" size=\"10\" maxlength=\"11\" value=\"{$go['data3']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 4", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data4\" size=\"10\" maxlength=\"11\" value=\"{$go['data4']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 5", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data5\" size=\"10\" maxlength=\"11\" value=\"{$go['data5']}\" /></td>\r\n</tr>\r\n</table><br />";
$result1 = $sql->query("SELECT COUNT(*) FROM gameobject WHERE id = '{$go['entry']}'");
$output .= "<tr><td colspan=\"6\">{$lang_game_object['go_swapned']} : " . $sql->result($result1, 0) . " {$lang_game_object['times']}.</td></tr>\r\n\r\n<br />\r\n</div>\r\n\r\n<div id=\"pane2\">\r\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\r\n\r\n<tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_game_object['data']}:</td></tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 6", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data6\" size=\"10\" maxlength=\"11\" value=\"{$go['data6']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 7", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data7\" size=\"10\" maxlength=\"11\" value=\"{$go['data7']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 8", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data8\" size=\"10\" maxlength=\"11\" value=\"{$go['data8']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 9", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data9\" size=\"10\" maxlength=\"11\" value=\"{$go['data9']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 10", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data10\" size=\"10\" maxlength=\"11\" value=\"{$go['data10']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 11", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data11\" size=\"10\" maxlength=\"11\" value=\"{$go['data11']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 12", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data12\" size=\"10\" maxlength=\"11\" value=\"{$go['data12']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 13", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data13\" size=\"10\" maxlength=\"11\" value=\"{$go['data13']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 14", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data14\" size=\"10\" maxlength=\"11\" value=\"{$go['data14']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 15", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data15\" size=\"10\" maxlength=\"11\" value=\"{$go['data15']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 16", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data16\" size=\"10\" maxlength=\"11\" value=\"{$go['data16']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 17", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data17\" size=\"10\" maxlength=\"11\" value=\"{$go['data17']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 18", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data18\" size=\"10\" maxlength=\"11\" value=\"{$go['data18']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 19", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data19\" size=\"10\" maxlength=\"11\" value=\"{$go['data19']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 20", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data20\" size=\"10\" maxlength=\"11\" value=\"{$go['data20']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell($lang_game_object['data'] . " 21", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data21\" size=\"10\" maxlength=\"11\" value=\"{$go['data21']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 22", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data22\" size=\"10\" maxlength=\"11\" value=\"{$go['data22']}\" /></td>\r\n\r\n <td>" . makeinfocell($lang_game_object['data'] . " 23", $lang_game_object['data_desc']) . "</td>\r\n <td><input type=\"text\" name=\"data23\" size=\"10\" maxlength=\"11\" value=\"{$go['data23']}\" /></td>\r\n</tr>\r\n</table>\r\n<br />\r\n</div>";
if ($go['type'] == 3) {
$output .= "<div id=\"pane3\">\r\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\r\n <tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_game_object['loot_tmpl_id']}:</td></tr>\r\n<tr>\r\n <td colspan=\"6\">";
require_once "scripts/get_lib.php";
$cel_counter = 0;
$row_flag = 0;
$output .= "<table class=\"hidden\" align=\"center\"><tr>";
$result1 = $sql->query("SELECT item,ChanceOrQuestChance,`groupid`,mincountOrRef,maxcount, lootcondition, condition_value1, condition_value2 FROM gameobject_loot_template WHERE entry = {$go['data1']} ORDER BY ChanceOrQuestChance DESC");
while ($item = $sql->fetch_row($result1)) {
$cel_counter++;
$tooltip = get_item_name($item[0]) . " ({$item['0']})<br />{$lang_game_object['drop_chance']}: {$item['1']}%<br />{$lang_game_object['quest_drop_chance']}: {$item['2']}%<br />{$lang_game_object['drop_chance']}: {$item['3']}-{$item['4']}<br />{$lang_game_object['lootcondition']}: {$item['5']}<br />{$lang_game_object['condition_value1']}: {$item['6']}<br />{$lang_game_object['condition_value2']}: {$item['7']}";
$output .= "<td>";
$output .= maketooltip("<img src=\"" . get_item_icon($item[0]) . "\" class=\"icon_border\" alt=\"\" />", "{$item_datasite}{$item['0']}", "{$tooltip}", "item_tooltip", "target=\"_blank\"");
$output .= "<br /><input type=\"checkbox\" name=\"del_loot_items[]\" value=\"{$item['0']}\" /></td>";
if ($cel_counter >= 16) {
$cel_counter = 0;
$output .= "</tr><tr>";
$row_flag++;
}
}
if ($row_flag) {
$output .= "<td colspan=\"" . (16 - $cel_counter) . "\"></td>";
}
$output .= "</td></tr></table>\r\n </td>\r\n</tr>\r\n<tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_game_object['add_items_to_templ']}:</td></tr>\r\n<tr>\r\n<td>" . makeinfocell($lang_game_object['loot_item_id'], $lang_game_object['loot_item_id_desc']) . "</td>\r\n <td><input type=\"text\" name=\"item\" size=\"8\" maxlength=\"10\" value=\"\" /></td>\r\n<td>" . makeinfocell($lang_game_object['loot_drop_chance'], $lang_game_object['loot_drop_chance_desc']) . "</td>\r\n <td><input type=\"text\" name=\"ChanceOrQuestChance\" size=\"8\" maxlength=\"11\" value=\"0\" /></td>\r\n<td>" . makeinfocell($lang_game_object['loot_quest_drop_chance'], $lang_game_object['loot_quest_drop_chance_desc']) . "</td>\r\n <td><input type=\"text\" name=\"groupid\" size=\"8\" maxlength=\"10\" value=\"0\" /></td>\r\n</tr>\r\n<tr>\r\n<td>" . makeinfocell($lang_game_object['min_count'], $lang_game_object['min_count_desc']) . "</td>\r\n <td><input type=\"text\" name=\"mincountOrRef\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>\r\n<td>" . makeinfocell($lang_game_object['max_count'], $lang_game_object['max_count_desc']) . "</td>\r\n <td><input type=\"text\" name=\"maxcount\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>\r\n</tr>\r\n<tr>\r\n<td>" . makeinfocell($lang_game_object['lootcondition'], $lang_game_object['lootcondition_desc']) . "</td>\r\n <td><input type=\"text\" name=\"lootcondition\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>\r\n<td>" . makeinfocell($lang_game_object['condition_value1'], $lang_game_object['condition_value1_desc']) . "</td>\r\n <td><input type=\"text\" name=\"condition_value1\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>\r\n<td>" . makeinfocell($lang_game_object['condition_value2'], $lang_game_object['condition_value2']) . "</td>\r\n <td><input type=\"text\" name=\"condition_value2\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>\r\n</tr>\r\n</table><br />{$lang_game_object['check_to_delete']}<br /><br />\r\n</div>";
}
$output .= "<div id=\"pane4\">\r\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\r\n <tr class=\"large_bold\"><td colspan=\"2\" class=\"hidden\" align=\"left\">{$lang_game_object['start_quests']}:</td></tr>";
$result1 = $sql->query("SELECT quest FROM gameobject_questrelation WHERE id = {$go['entry']}");
while ($quest = $sql->fetch_row($result1)) {
$query1 = $sql->query("SELECT QuestLevel, IFNULL(" . ($deplang != 0 ? "title_loc{$deplang}" : "NULL") . ",`title`) as Title FROM quest_template LEFT JOIN locales_quest ON quest_template.entry = locales_quest.entry WHERE quest_template.entry ='{$quest['0']}'");
$quest_templ = $sql->fetch_row($query1);
$output .= "<tr><td width=\"5%\"><input type=\"checkbox\" name=\"del_questrelation[]\" value=\"{$quest['0']}\" /></td>\r\n <td width=\"95%\" align=\"left\"><a class=\"tooltip\" href=\"{$quest_datasite}{$quest['0']}\" target=\"_blank\">({$quest_templ[0]}) {$quest_templ['1']}</a></td></tr>";
}
$output .= "<tr class=\"large_bold\" align=\"left\"><td colspan=\"2\" class=\"hidden\">{$lang_game_object['add_starts_quests']}:</td></tr>\r\n <tr><td colspan=\"2\" align=\"left\">" . makeinfocell($lang_game_object['quest_id'], $lang_game_object['quest_id_desc']) . " :\r\n <input type=\"text\" name=\"questrelation\" size=\"8\" maxlength=\"8\" value=\"\" /></td></tr>\r\n\r\n<tr class=\"large_bold\"><td colspan=\"2\" class=\"hidden\" align=\"left\">{$lang_game_object['ends_quests']}:</td></tr>";
$result1 = $sql->query("SELECT quest FROM gameobject_involvedrelation WHERE id = {$go['entry']}");
while ($quest = $sql->fetch_row($result1)) {
$query1 = $sql->query("SELECT QuestLevel, IFNULL(" . ($deplang != 0 ? "title_loc{$deplang}" : "NULL") . ",`title`) as Title FROM quest_template LEFT JOIN locales_quest ON quest_template.entry = locales_quest.entry WHERE quest_template.entry ='{$quest['0']}'");
$quest_templ = $sql->fetch_row($query1);
$output .= "<tr><td width=\"5%\"><input type=\"checkbox\" name=\"del_involvedrelation[]\" value=\"{$quest['0']}\" /></td>\r\n <td width=\"95%\" align=\"left\"><a class=\"tooltip\" href=\"{$quest_datasite}{$quest['0']}\" target=\"_blank\">({$quest_templ[0]}) {$quest_templ['1']}</a></td></tr>";
}
$output .= "<tr class=\"large_bold\" align=\"left\"><td colspan=\"2\" class=\"hidden\">{$lang_game_object['add_ends_quests']}:</td></tr>\r\n <tr><td colspan=\"2\" align=\"left\">" . makeinfocell($lang_game_object['quest_id'], $lang_game_object['quest_id_desc']) . " :\r\n <input type=\"text\" name=\"involvedrelation\" size=\"8\" maxlength=\"8\" value=\"\" /></td></tr>\r\n\r\n</table><br />{$lang_game_object['check_to_delete']}<br /><br />\r\n</div>\r\n\r\n</div>\r\n</div>\r\n<br />\r\n</form>\r\n\r\n<script type=\"text/javascript\">setupPanes(\"container\", \"tab1\")</script>";
$output .= "<table class=\"hidden\">\r\n <tr><td>";
makebutton($lang_game_object['save_to_db'], "javascript:do_submit('form1',0)", 180);
makebutton($lang_game_object['del_go'], "game_object.php?action=delete&entry={$entry}", 180);
makebutton($lang_game_object['del_spawns'], "game_object.php?action=delete_spwn&entry={$entry}", 180);
makebutton($lang_game_object['save_to_script'], "javascript:do_submit('form1',1)", 180);
$output .= "</td></tr><tr><td>";
makebutton($lang_game_object['lookup_go'], "game_object.php", 760);
$output .= "</td></tr>\r\n </table></center>";
$sql->close();
} else {
$sql->close();
error($lang_game_object['tmpl_not_found']);
exit;
}
}
function get_item_tooltip($item_id)
{
global $lang_item, $lang_id_tab, $world_db, $realm_id, $language;
if ($item_id) {
$sqlw = new SQL();
$sqlw->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);
$deplang = get_lang_id();
$result_1 = $sqlw->query("SELECT stat_type1,stat_value1,stat_type2,\r\n stat_value2,stat_type3,stat_value3,stat_type4,stat_value4,stat_type5,\r\n stat_value5,stat_type6,stat_value6,stat_type7,stat_value7,stat_type8,\r\n stat_value8,stat_type9,stat_value9,stat_type10,stat_value10,armor,\r\n holy_res,fire_res,nature_res,frost_res,arcane_res,shadow_res,spellid_1,\r\n spellid_2,spellid_3,spellid_4,spellid_5,\r\n IFNULL(" . ($deplang != 0 ? "name_loc{$deplang}" : "NULL") . ",name),class,subclass,\r\n Quality,RequiredLevel,dmg_min1,dmg_max1,dmg_type1,dmg_min2,dmg_max2,\r\n dmg_type2,delay,bonding,description,itemset,item_template.entry,\r\n InventoryType,ItemLevel,displayid,maxcount,spelltrigger_1,spelltrigger_2,\r\n spelltrigger_3,spelltrigger_4,spelltrigger_5,ContainerSlots,\r\n spellcharges_1,spellcharges_2,spellcharges_3,spellcharges_4,\r\n spellcharges_5,AllowableClass,socketColor_1,socketColor_2,socketColor_3,\r\n RandomProperty,RandomSuffix\r\n FROM item_template LEFT JOIN locales_item ON item_template.entry = locales_item.entry\r\n WHERE item_template.entry = '{$item_id}' LIMIT 1");
if ($item = $sqlw->fetch_row($result_1)) {
$tooltip = "";
$itemname = htmlspecialchars($item[32]);
switch ($item[35]) {
case 0:
//Grey Poor
$tooltip .= "<font color='#b2c2b9' class='large'>{$itemname}</font><br />";
break;
case 1:
//White Common
$tooltip .= "<font color='white' class='large'>{$itemname}</font><br />";
break;
case 2:
//Green Uncommon
$tooltip .= "<font color='#1eff00' class='large'>{$itemname}</font><br />";
break;
case 3:
//Blue Rare
$tooltip .= "<font color='#0070dd' class='large'>{$itemname}</font><br />";
break;
case 4:
//Purple Epic
$tooltip .= "<font color='#a335ee' class='large'>{$itemname}</font><br />";
break;
case 5:
//Orange Legendary
$tooltip .= "<font color='orange' class='large'>{$itemname}</font><br />";
break;
case 6:
//Red Artifact
$tooltip .= "<font color='red' class='large'>{$itemname}</font><br />";
break;
default:
}
$tooltip .= "<font color='white'>";
switch ($item[53]) {
case 1:
//Binds when Picked Up
$tooltip .= "{$lang_item['bop']}<br />";
break;
case 2:
//Binds when Equipped
$tooltip .= "{$lang_item['boe']}<br />";
break;
case 3:
//Binds when Used
$tooltip .= "{$lang_item['bou']}<br />";
break;
case 4:
//Quest Item
$tooltip .= "{$lang_item['quest_item']}<br />";
break;
default:
}
if ($item[60]) {
$tooltip .= "{$lang_item['unique']}<br />";
}
$tooltip .= "<br />";
switch ($item[57]) {
case 1:
$tooltip .= "{$lang_item['head']} - ";
break;
case 2:
$tooltip .= "{$lang_item['neck']} - ";
break;
case 3:
$tooltip .= "{$lang_item['shoulder']} - ";
break;
case 4:
$tooltip .= "{$lang_item['shirt']} - ";
break;
case 5:
$tooltip .= "{$lang_item['chest']} - ";
break;
case 6:
$tooltip .= "{$lang_item['belt']} - ";
break;
case 7:
$tooltip .= "{$lang_item['legs']} - ";
break;
case 8:
$tooltip .= "{$lang_item['feet']} - ";
break;
case 9:
$tooltip .= "{$lang_item['wrist']} - ";
break;
case 10:
$tooltip .= "{$lang_item['gloves']} - ";
break;
case 11:
$tooltip .= "{$lang_item['finger']} - ";
break;
case 12:
$tooltip .= "{$lang_item['trinket']} - ";
break;
case 13:
$tooltip .= "{$lang_item['one_hand']} - ";
break;
case 14:
$tooltip .= "{$lang_item['off_hand']} - ";
break;
case 16:
$tooltip .= "{$lang_item['back']} - ";
break;
case 18:
$tooltip .= "{$lang_item['bag']}";
break;
case 19:
$tooltip .= "{$lang_item['tabard']} - ";
break;
case 20:
$tooltip .= "{$lang_item['robe']} - ";
break;
case 21:
$tooltip .= "{$lang_item['main_hand']} - ";
break;
case 23:
$tooltip .= "{$lang_item['tome']} - ";
break;
default:
}
switch ($item[33]) {
case 0:
//Consumable
$tooltip .= "{$lang_item['consumable']}<br />";
break;
case 2:
//Weapon
switch ($item[34]) {
case 0:
$tooltip .= "{$lang_item['axe_1h']}<br />";
break;
case 1:
$tooltip .= "{$lang_item['axe_2h']}<br />";
break;
case 2:
$tooltip .= "{$lang_item['bow']}<br />";
break;
case 3:
$tooltip .= "{$lang_item['rifle']}<br />";
break;
case 4:
$tooltip .= "{$lang_item['mace_1h']}<br />";
break;
case 5:
$tooltip .= "{$lang_item['mace_2h']}<br />";
break;
case 6:
$tooltip .= "{$lang_item['polearm']}<br />";
break;
case 7:
$tooltip .= "{$lang_item['sword_1h']}<br />";
break;
case 8:
$tooltip .= "{$lang_item['sword_2h']}<br />";
break;
case 10:
$tooltip .= "{$lang_item['staff']}<br />";
break;
case 11:
$tooltip .= "{$lang_item['exotic_1h']}<br />";
break;
case 12:
$tooltip .= "{$lang_item['exotic_2h']}<br />";
break;
case 13:
$tooltip .= "{$lang_item['fist_weapon']}<br />";
break;
case 14:
$tooltip .= "{$lang_item['misc_weapon']}<br />";
break;
case 15:
$tooltip .= "{$lang_item['dagger']}<br />";
break;
case 16:
$tooltip .= "{$lang_item['thrown']}<br />";
break;
case 17:
$tooltip .= "{$lang_item['spear']}<br />";
break;
case 18:
$tooltip .= "{$lang_item['crossbow']}<br />";
break;
case 19:
$tooltip .= "{$lang_item['wand']}<br />";
break;
case 20:
$tooltip .= "{$lang_item['fishing_pole']}<br />";
break;
default:
}
break;
case 4:
//Armor
switch ($item[34]) {
case 0:
$tooltip .= "{$lang_item['misc']}<br />";
break;
case 1:
$tooltip .= "{$lang_item['cloth']}<br />";
break;
case 2:
$tooltip .= "{$lang_item['leather']}<br />";
break;
case 3:
$tooltip .= "{$lang_item['mail']}<br />";
break;
case 4:
$tooltip .= "{$lang_item['plate']}<br />";
break;
case 6:
$tooltip .= "{$lang_item['shield']}<br />";
break;
default:
}
break;
case 6:
//Projectile
switch ($item[34]) {
case 2:
$tooltip .= "{$lang_item['arrows']}<br />";
break;
case 3:
$tooltip .= "{$lang_item['bullets']}<br />";
break;
default:
}
break;
case 7:
//Trade Goods
switch ($item[34]) {
case 0:
$tooltip .= "{$lang_item['trade_goods']}<br />";
break;
case 1:
$tooltip .= "{$lang_item['parts']}<br />";
break;
case 2:
$tooltip .= "{$lang_item['explosives']}<br />";
break;
case 3:
$tooltip .= "{$lang_item['devices']}<br />";
break;
default:
}
break;
case 9:
//Recipe
switch ($item[34]) {
case 0:
$tooltip .= "{$lang_item['book']}<br />";
break;
case 1:
$tooltip .= "{$lang_item['LW_pattern']}<br />";
break;
case 2:
$tooltip .= "{$lang_item['tailoring_pattern']}<br />";
break;
case 3:
$tooltip .= "{$lang_item['ENG_Schematic']}<br />";
break;
case 4:
$tooltip .= "{$lang_item['BS_plans']}<br />";
break;
case 5:
$tooltip .= "{$lang_item['cooking_recipe']}<br />";
break;
case 6:
$tooltip .= "{$lang_item['alchemy_recipe']}<br />";
break;
case 7:
$tooltip .= "{$lang_item['FA_manual']}<br />";
break;
case 8:
$tooltip .= "{$lang_item['ench_formula']}<br />";
break;
case 9:
$tooltip .= "{$lang_item['JC_formula']}<br />";
break;
default:
}
break;
case 11:
//Quiver
switch ($item[34]) {
case 2:
$tooltip .= " {$lang_item['quiver']}<br />";
break;
case 3:
$tooltip .= " {$lang_item['ammo_pouch']}<br />";
break;
default:
}
break;
case 12:
//Quest
if ($item[53] != 4) {
$tooltip .= "{$lang_item['quest_item']}<br />";
}
break;
case 13:
//key
switch ($item[34]) {
case 0:
$tooltip .= "{$lang_item['key']}<br />";
break;
case 1:
$tooltip .= "{$lang_item['lockpick']}<br />";
break;
default:
}
break;
default:
}
$tooltip .= "{$item['20']} {$lang_item['armor']}<br />";
for ($f = 37; $f <= 51; $f += 3) {
$dmg_type = $item[$f + 2];
$min_dmg_value = $item[$f];
$max_dmg_value = $item[$f + 1];
if ($min_dmg_value && $max_dmg_value) {
switch ($dmg_type) {
case 0:
// Physical
$tooltip .= "{$min_dmg_value} - {$max_dmg_value} {$lang_item['damage']}<br />(" . ($item[52] ? round(($min_dmg_value + $max_dmg_value) / 2 / ($item[52] / 1000), 2) : $min_dmg_value) . " DPS) {$lang_item['speed']} : " . $item[52] / 1000 . "<br />";
break;
case 1:
// Holy
$tooltip .= "{$min_dmg_value} - {$max_dmg_value} {$lang_item['holy_dmg']}<br />";
break;
case 2:
// Fire
$tooltip .= "{$min_dmg_value} - {$max_dmg_value} {$lang_item['fire_dmg']}<br />";
break;
case 3:
// Nature
$tooltip .= "{$min_dmg_value} - {$max_dmg_value} {$lang_item['nature_dmg']}<br />";
break;
case 4:
// Frost
$tooltip .= "{$min_dmg_value} - {$max_dmg_value} {$lang_item['frost_dmg']}<br />";
break;
case 5:
// Shadow
$tooltip .= "{$min_dmg_value} - {$max_dmg_value} {$lang_item['shadow_dmg']}<br />";
break;
case 6:
// Arcane
$tooltip .= "{$min_dmg_value} - {$max_dmg_value} {$lang_item['arcane_dmg']}<br />";
break;
default:
}
}
}
//basic status
for ($s = 0; $s <= 18; $s += 2) {
$stat_value = $item[$s + 1];
if ($item[$s] && $stat_value) {
switch ($item[$s]) {
case 1:
$tooltip .= "+{$stat_value} {$lang_item['health']}<br />";
break;
case 2:
$tooltip .= "+{$stat_value} {$lang_item['mana']}<br />";
break;
case 3:
$tooltip .= "+{$stat_value} {$lang_item['agility']}<br />";
break;
case 4:
$tooltip .= "+{$stat_value} {$lang_item['strength']}<br />";
break;
case 5:
$tooltip .= "+{$stat_value} {$lang_item['intellect']}<br />";
break;
case 6:
$tooltip .= "+{$stat_value} {$lang_item['spirit']}<br />";
break;
case 7:
$tooltip .= "+{$stat_value} {$lang_item['stamina']}<br />";
break;
default:
$flag_rating = 1;
}
}
}
if ($item[21]) {
$tooltip .= "{$item['21']} {$lang_item['res_holy']}<br />";
}
if ($item[25]) {
$tooltip .= "{$item['25']} {$lang_item['res_arcane']}<br />";
}
if ($item[22]) {
$tooltip .= "{$item['22']} {$lang_item['res_fire']}<br />";
}
if ($item[23]) {
$tooltip .= "{$item['23']} {$lang_item['res_nature']}<br />";
}
if ($item[24]) {
$tooltip .= "{$item['24']} {$lang_item['res_frost']}<br />";
}
if ($item[26]) {
$tooltip .= "{$item['26']} {$lang_item['res_shadow']}<br />";
}
//sockets
for ($p = 72; $p <= 74; $p++) {
if ($item[$p]) {
switch ($item[$p]) {
case 1:
$tooltip .= "<img src='img/socket_meta.gif' alt='' /><font color='gray'> {$lang_item['socket_meta']}</font><br />";
break;
case 2:
$tooltip .= "<img src='img/socket_red.gif' alt='' /><font color='red'> {$lang_item['socket_red']}</font><br />";
break;
case 4:
$tooltip .= "<img src='img/socket_yellow.gif' alt='' /><font color='yellow'> {$lang_item['socket_yellow']}</font><br />";
break;
case 8:
$tooltip .= "<img src='img/socket_blue.gif' alt='' /><font color='blue'> {$lang_item['socket_blue']}</font><br />";
break;
default:
}
}
}
//level requierment
if ($item[36]) {
$tooltip .= "{$lang_item['lvl_req']} {$item['36']}<br />";
}
//allowable classes
if ($item[71] && $item[71] != -1 && $item[71] != 1503) {
$tooltip .= "{$lang_item['class']}:";
if ($item[71] & 1) {
$tooltip .= " {$lang_id_tab['warrior']} ";
}
if ($item[71] & 2) {
$tooltip .= " {$lang_id_tab['paladin']} ";
}
if ($item[71] & 4) {
$tooltip .= " {$lang_id_tab['hunter']} ";
}
if ($item[71] & 8) {
$tooltip .= " {$lang_id_tab['rogue']} ";
}
if ($item[71] & 16) {
$tooltip .= " {$lang_id_tab['priest']} ";
}
if ($item[71] & 64) {
$tooltip .= " {$lang_id_tab['shaman']} ";
}
if ($item[71] & 128) {
$tooltip .= " {$lang_id_tab['mage']} ";
}
if ($item[71] & 256) {
$tooltip .= " {$lang_id_tab['warlock']} ";
}
if ($item[71] & 1024) {
$tooltip .= " {$lang_id_tab['druid']} ";
}
$tooltip .= "<br />";
}
//number of bag slots
if ($item[66]) {
$tooltip .= " {$item['66']} {$lang_item['slots']}<br />";
}
$tooltip .= "</font><br /><font color='#1eff00'>";
//random enchantments
if ($item[75] || $item[76]) {
$tooltip .= "< Random enchantment ><br />";
}
//Ratings additions.
if (isset($flag_rating)) {
for ($s = 0; $s <= 18; $s += 2) {
$stat_type = $item[$s];
$stat_value = $item[$s + 1];
if ($stat_type && $stat_value) {
switch ($stat_type) {
case 12:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['DEFENCE_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 13:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['DODGE_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 14:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['PARRY_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 15:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['SHIELD_BLOCK_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 16:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['MELEE_HIT_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 17:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['RANGED_HIT_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 18:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['SPELL_HIT_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 19:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['MELEE_CS_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 20:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['RANGED_CS_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 21:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['SPELL_CS_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 22:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['MELEE_HA_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 23:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['RANGED_HA_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 24:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['SPELL_HA_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 25:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['MELEE_CA_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 26:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['RANGED_CA_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 27:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['SPELL_CA_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 28:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['MELEE_HASTE_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 29:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['RANGED_HASTE_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 30:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['SPELL_HASTE_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 31:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['HIT_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 32:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['CS_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 33:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['HA_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 34:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['CA_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 35:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['RESILIENCE_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
case 36:
$tooltip .= "{$lang_item['spell_equip']}: {$lang_item['improves']} {$lang_item['HASTE_RATING']} {$lang_item['rating_by']} {$stat_value}.<br />";
break;
default:
}
}
}
}
//add equip spellid to status
for ($s1 = 27; $s1 <= 31; $s1++) {
if ($item[$s1]) {
switch ($item[$s1 + 34]) {
case 0:
$tooltip .= "{$lang_item['spell_use']}: ";
break;
case 1:
$tooltip .= "{$lang_item['spell_equip']}: ";
break;
case 2:
$tooltip .= "{$lang_item['spell_coh']}: ";
break;
default:
}
$tooltip .= " {$item[$s1]}<br />";
if ($item[$s1]) {
if ($item[$s1 + 40]) {
$tooltip .= abs($item[$s1 + 40]) . " {$lang_item['charges']}.<br />";
}
}
}
}
$tooltip .= "</font>";
if ($item[55]) {
include_once "id_tab.php";
$tooltip .= "<br /><font color='orange'>{$lang_item['item_set']} : " . get_itemset_name($item[55]) . " ({$item['55']})</font>";
}
if ($item[54]) {
$tooltip .= "<br /><font color='orange'>''" . str_replace("\"", " '", $item[54]) . "'</font>";
}
} else {
$tooltip = "Item ID: {$item_id} Not Found";
}
return $tooltip;
} else {
return NULL;
}
}
function char_quest(&$sqlr, &$sqlc)
{
global $output, $lang_global, $lang_char, $realm_id, $world_db, $characters_db, $action_permission, $user_lvl, $user_name, $quest_datasite, $itemperpage;
wowhead_tt();
if (empty($_GET['id'])) {
error($lang_global['empty_fields']);
}
if (empty($_GET['realm'])) {
$realmid = $realm_id;
} else {
$realmid = $sqlr->quote_smart($_GET['realm']);
if (is_numeric($realmid)) {
$sqlc->connect($characters_db[$realmid]['addr'], $characters_db[$realmid]['user'], $characters_db[$realmid]['pass'], $characters_db[$realmid]['name']);
} else {
$realmid = $realm_id;
}
}
$id = $sqlc->quote_smart($_GET['id']);
if (is_numeric($id)) {
} else {
$id = 0;
}
//==========================$_GET and SECURE=================================
$start = isset($_GET['start']) ? $sqlc->quote_smart($_GET['start']) : 0;
if (is_numeric($start)) {
} else {
$start = 0;
}
$order_by = isset($_GET['order_by']) ? $sqlc->quote_smart($_GET['order_by']) : 1;
if (is_numeric($order_by)) {
} else {
$order_by = 1;
}
$dir = isset($_GET['dir']) ? $sqlc->quote_smart($_GET['dir']) : 0;
if (preg_match('/^[01]{1}$/', $dir)) {
} else {
$dir = 0;
}
$order_dir = $dir ? 'ASC' : 'DESC';
$dir = $dir ? 0 : 1;
//==========================$_GET and SECURE end=============================
$result = $sqlc->query('SELECT account, name, race, class, level, gender
FROM characters WHERE guid = ' . $id . ' LIMIT 1');
if ($sqlc->num_rows($result)) {
$char = $sqlc->fetch_assoc($result);
$owner_acc_id = $sqlc->result($result, 0, 'account');
$result = $sqlr->query('SELECT gmlevel, username FROM account WHERE id = ' . $char['account'] . '');
$owner_gmlvl = $sqlr->result($result, 0, 'gmlevel');
$owner_name = $sqlr->result($result, 0, 'username');
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name) {
$output .= '
<center>
<div id="tab_content">
<div id="tab">
<ul>
<li><a href="char.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['char_sheet'] . '</a></li>
<li><a href="char_inv.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['inventory'] . '</a></li>
<li><a href="char_extra.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['extra'] . '</a></li>
' . ($char['level'] < 10 ? '' : '<li><a href="char_talent.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['talents'] . '</a></li>') . '
<li><a href="char_achieve.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['achievements'] . '</a></li>
<li><a href="char_rep.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['reputation'] . '</a></li>
<li><a href="char_skill.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['skills'] . '</a></li>';
if (char_get_class_name($char['class']) === 'Hunter') {
$output .= '
<li><a href="char_pets.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['pets'] . '</a></li>';
}
$output .= '
<li><a href="char_friends.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['friends'] . '</a></li>
<li><a href="char_spell.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['spells'] . '</a></li>
<li><a href="char_mail.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['mail'] . '</a></li>
</ul>
<ul>';
// selected char tab at last
$output .= '
<li id="selected"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['quests'] . '</a></li>';
$output .= '
</ul>
</div>
<div id="tab_content2">
<font class="bold">
' . htmlentities($char['name']) . ' -
<img src="img/c_icons/' . $char['race'] . '-' . $char['gender'] . '.gif"
onmousemove="toolTip(\'' . char_get_race_name($char['race']) . '\', \'item_tooltip\')" onmouseout="toolTip()" alt="" />
<img src="img/c_icons/' . $char['class'] . '.gif"
onmousemove="toolTip(\'' . char_get_class_name($char['class']) . '\',\'item_tooltip\')" onmouseout="toolTip()" alt="" /> - lvl ' . char_get_level_color($char['level']) . '
</font>
<br /><br />
<table class="lined" style="width: 550px;">
<tr>
<th width="10%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=0&dir=' . $dir . '"' . ($order_by == 0 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_id'] . '</a></th>
<th width="7%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=1&dir=' . $dir . '"' . ($order_by == 1 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_level'] . '</a></th>
<th width="78%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=2&dir=' . $dir . '"' . ($order_by == 2 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_title'] . '</a></th>
<th width="5%"><img src="img/aff_qst.png" width="14" height="14" border="0" alt="" /></th>
</tr>';
$result = $sqlc->query('SELECT quest, status, rewarded FROM character_queststatus WHERE guid = ' . $id . ' AND ( status = 3 OR status = 1 ) ORDER BY status DESC');
$quests_1 = array();
$quests_3 = array();
if ($sqlc->num_rows($result)) {
while ($quest = $sqlc->fetch_assoc($result)) {
$deplang = get_lang_id();
$query1 = $sqlc->query('SELECT QuestLevel, IFNULL(' . ($deplang != 0 ? '`title_loc' . $deplang . '`' : 'NULL') . ', title) as Title FROM `' . $world_db[$realmid]['name'] . '`.`quest_template` LEFT JOIN `' . $world_db[$realmid]['name'] . '`.`locales_quest` ON `quest_template`.`entry` = `locales_quest`.`entry` WHERE `quest_template`.`entry` = \'' . $quest['quest'] . '\'');
$quest_info = $sqlc->fetch_assoc($query1);
if (1 == $quest['status']) {
array_push($quests_1, array($quest['quest'], $quest_info['QuestLevel'], $quest_info['Title'], $quest['rewarded']));
} else {
array_push($quests_3, array($quest['quest'], $quest_info['QuestLevel'], $quest_info['Title']));
}
}
unset($quest);
unset($quest_info);
aasort($quests_1, $order_by, $dir);
$orderby = $order_by;
if (2 < $orderby) {
$orderby = 1;
}
aasort($quests_3, $orderby, $dir);
$all_record = count($quests_1);
foreach ($quests_3 as $data) {
$output .= '
<tr>
<td>' . $data[0] . '</td>
<td>(' . $data[1] . ')</td>
<td align="left"><a href="' . $quest_datasite . $data[0] . '" target="_blank">' . htmlentities($data[2]) . '</a></td>
<td><img src="img/aff_qst.png" width="14" height="14" alt="" /></td>
</tr>';
}
unset($quest_3);
if (count($quests_1)) {
$output .= '
</table>
<table class="hidden" style="width: 550px;">
<tr align="right">
<td>';
$output .= generate_pagination('char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=' . $order_by . '&dir=' . ($dir ? 0 : 1), $all_record, $itemperpage, $start);
$output .= '
</td>
</tr>
</table>
<table class="lined" style="width: 550px;">
<tr>
<th width="10%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=0&dir=' . $dir . '"' . ($order_by == 0 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_id'] . '</a></th>
<th width="7%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=1&dir=' . $dir . '"' . ($order_by == 1 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_level'] . '</a></th>
<th width="68%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=2&dir=' . $dir . '"' . ($order_by == 2 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_title'] . '</a></th>
<th width="10%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=3&dir=' . $dir . '"' . ($order_by == 3 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['rewarded'] . '</a></th>
<th width="5%"><img src="img/aff_tick.png" width="14" height="14" border="0" alt="" /></th>
</tr>';
$i = 0;
foreach ($quests_1 as $data) {
if ($i < $start + $itemperpage && $i >= $start) {
$output .= '
<tr>
<td>' . $data[0] . '</td>
<td>(' . $data[1] . ')</td>
<td align="left"><a href="' . $quest_datasite . $data[0] . '" target="_blank">' . htmlentities($data[2]) . '</a></td>
<td><img src="img/aff_' . ($data[3] ? 'tick' : 'qst') . '.png" width="14" height="14" alt="" /></td>
<td><img src="img/aff_tick.png" width="14" height="14" alt="" /></td>
</tr>';
}
$i++;
}
unset($data);
unset($quest_1);
$output .= '
<tr align="right">
<td colspan="5">';
$output .= generate_pagination('char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=' . $order_by . '&dir=' . ($dir ? 0 : 1), $all_record, $itemperpage, $start);
$output .= '
</td>
</tr>';
}
} else {
$output .= '
<tr>
<td colspan="4"><p>' . $lang_char['no_act_quests'] . '</p></td>
</tr>';
}
//---------------Page Specific Data Ends here----------------------------
//---------------Character Tabs Footer-----------------------------------
$output .= '
</table>
</div>
</div>
<br />
<table class="hidden">
<tr>
<td>';
// button to user account page, user account page has own security
makebutton($lang_char['chars_acc'], 'user.php?action=edit_user&id=' . $owner_acc_id . '', 130);
$output .= '
</td>
<td>';
// only higher level GM with delete access can edit character
// character edit allows removal of character items, so delete permission is needed
if ($user_lvl > $owner_gmlvl && $user_lvl >= $action_permission['delete']) {
makebutton($lang_char['edit_button'], 'char_edit.php?id=' . $id . '&realm=' . $realmid . '', 130);
$output .= '
</td>
<td>';
}
// only higher level GM with delete access, or character owner can delete character
if ($user_lvl > $owner_gmlvl && $user_lvl >= $action_permission['delete'] || $owner_name === $user_name) {
makebutton($lang_char['del_char'], 'char_list.php?action=del_char_form&check%5B%5D=' . $id . '" type="wrn', 130);
$output .= '
</td>
<td>';
}
// only GM with update permission can send mail, mail can send items, so update permission is needed
if ($user_lvl >= $action_permission['update']) {
makebutton($lang_char['send_mail'], 'mail.php?type=ingame_mail&to=' . $char['name'] . '', 130);
$output .= '
</td>
<td>';
}
makebutton($lang_global['back'], 'javascript:window.history.back()" type="def', 130);
$output .= '
</td>
</tr>
</table>
<br />
</center>
<!-- end of char_quest.php -->';
} else {
error($lang_char['no_permission']);
}
} else {
error($lang_char['no_char_found']);
}
}
function char_quest()
{
global $output, $realm_id, $world_db, $logon_db, $characters_db, $action_permission, $locales_search_option, $site_encoding, $user_lvl, $user_name, $base_datasite, $quest_datasite, $itemperpage, $sql, $core;
if (empty($_GET["id"])) {
error(lang("global", "empty_fields"));
}
if (empty($_GET["realm"])) {
$realmid = $realm_id;
} else {
$realmid = $sql["logon"]->quote_smart($_GET["realm"]);
if (is_numeric($realmid)) {
$sql["char"]->connect($characters_db[$realmid]['addr'], $characters_db[$realmid]['user'], $characters_db[$realmid]['pass'], $characters_db[$realmid]['name'], $characters_db[$realmid]["encoding"]);
} else {
$realmid = $realm_id;
}
}
$id = $sql["char"]->quote_smart($_GET["id"]);
if (!is_numeric($id)) {
$id = 0;
}
//==========================$_GET and SECURE=================================
$start = isset($_GET["start"]) ? $sql["char"]->quote_smart($_GET["start"]) : 0;
if (!is_numeric($start)) {
$start = 0;
}
$order_by = isset($_GET["order_by"]) ? $sql["char"]->quote_smart($_GET["order_by"]) : 1;
if (!is_numeric($order_by)) {
} else {
$order_by = 1;
}
$dir = isset($_GET["dir"]) ? $sql["char"]->quote_smart($_GET["dir"]) : 0;
if (!preg_match('/^[01]{1}$/', $dir)) {
$dir = 0;
}
$order_dir = $dir ? 'ASC' : 'DESC';
$dir = $dir ? 0 : 1;
//==========================$_GET and SECURE end=============================
if ($core == 1) {
$result = $sql["char"]->query("SELECT acct, name, race, class, level, gender\r\n FROM characters WHERE guid='" . $id . "' LIMIT 1");
} else {
$result = $sql["char"]->query("SELECT account AS acct, name, race, class, level, gender\r\n FROM characters WHERE guid='" . $id . "' LIMIT 1");
}
if ($sql["char"]->num_rows($result)) {
$char = $sql["char"]->fetch_assoc($result);
// we get user permissions first
$owner_acc_id = $sql["char"]->result($result, 0, 'acct');
if ($core == 1) {
$result = $sql["logon"]->query("SELECT login FROM accounts WHERE acct='" . $char["acct"] . "'");
} else {
$result = $sql["logon"]->query("SELECT username AS login FROM account WHERE id='" . $char["acct"] . "'");
}
$owner_name = $sql["logon"]->result($result, 0, 'login');
$s_query = "SELECT *, SecurityLevel AS gm FROM config_accounts WHERE Login='******'";
$s_result = $sql["mgr"]->query($s_query);
$s_fields = $sql["mgr"]->fetch_assoc($s_result);
$owner_gmlvl = $s_fields["gm"];
$view_mod = $s_fields["View_Mod_Quest"];
if ($owner_gmlvl >= 1073741824) {
$owner_gmlvl -= 1073741824;
}
// owner configured overrides
$view_override = false;
if ($view_mod > 0) {
if ($view_mod == 1) {
} elseif ($view_mod == 2) {
// only registered users may view this page
if ($user_lvl > -1) {
$view_override = true;
}
}
}
// visibility overrides for specific tabs
$view_inv_override = false;
if ($s_fields["View_Mod_Inv"] > 0) {
if ($s_fields["View_Mod_Inv"] == 1) {
} elseif ($s_fields["View_Mod_Inv"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_inv_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_inv_override = true;
}
}
$view_talent_override = false;
if ($s_fields["View_Mod_Talent"] > 0) {
if ($s_fields["View_Mod_Talent"] == 1) {
} elseif ($s_fields["View_Mod_Talent"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_talent_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_talent_override = true;
}
}
$view_achieve_override = false;
if ($s_fields["View_Mod_Achieve"] > 0) {
if ($s_fields["View_Mod_Achieve"] == 1) {
} elseif ($s_fields["View_Mod_Achieve"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_achieve_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_achieve_override = true;
}
}
$view_friends_override = false;
if ($s_fields["View_Mod_Friends"] > 0) {
if ($s_fields["View_Mod_Friends"] == 1) {
} elseif ($s_fields["View_Mod_Friends"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_friends_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_friends_override = true;
}
}
$view_view_override = false;
if ($s_fields["View_Mod_View"] > 0) {
if ($s_fields["View_Mod_View"] == 1) {
} elseif ($s_fields["View_Mod_View"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_view_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_view_override = true;
}
}
if ($view_override || $user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$output .= '
<div class="tab">
<ul>
<li><a href="char.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "char_sheet") . '</a></li>';
if ($view_inv_override) {
$output .= '
<li><a href="char_inv.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "inventory") . '</a></li>';
}
if ($view_talent_override) {
$output .= '
' . ($char["level"] < 10 ? '' : '<li><a href="char_talent.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "talents") . '</a></li>') . '';
}
if ($view_achieve_override) {
$output .= '
<li><a href="char_achieve.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "achievements") . '</a></li>';
}
$output .= '
<li class="selected"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "quests") . '</a></li>';
if ($view_friends_override) {
$output .= '
<li><a href="char_friends.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "friends") . '</a></li>';
}
if ($view_view_override) {
$output .= '
<li><a href="char_view.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "view") . '</a></li>';
}
$output .= '
</ul>
</div>
<div class="tab_content center center_text">
<span class="bold">
' . htmlentities($char["name"], ENT_COMPAT, $site_encoding) . ' -
<img src="img/c_icons/' . $char["race"] . '-' . $char["gender"] . '.gif" onmousemove="oldtoolTip(\'' . char_get_race_name($char["race"]) . '\', \'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" />
<img src="img/c_icons/' . $char["class"] . '.gif" onmousemove="oldtoolTip(\'' . char_get_class_name($char["class"]) . '\', \'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" /> - ' . lang("char", "level_short") . char_get_level_color($char["level"]) . '
</span>
<br />
<br />
<table class="lined" id="ch_que_questsA">
<tr>
<th style="width: 10%;"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=0&dir=' . $dir . '"' . ($order_by == 0 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "quest_id") . '</a></th>
<th style="width: 7%;"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=1&dir=' . $dir . '"' . ($order_by == 1 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "quest_level") . '</a></th>
<th style="width: 78%;"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=2&dir=' . $dir . '"' . ($order_by == 2 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "quest_title") . '</a></th>
<th style="width: 5%;"><img src="img/aff_qst.png" width="14" height="14" alt="" /></th>
</tr>';
if ($core == 1) {
$result = $sql["char"]->query("SELECT quest_id, completed\r\n FROM questlog\r\n WHERE player_guid='" . $id . "'");
} elseif ($core == 2) {
$result = $sql["char"]->query("SELECT quest AS quest_id, status AS completed\r\n FROM character_queststatus\r\n WHERE guid='" . $id . "' AND rewarded=0 AND status<>0");
} else {
$result = $sql["char"]->query("SELECT quest AS quest_id, status AS completed\r\n FROM character_queststatus\r\n WHERE guid='" . $id . "' AND status<>0");
}
$quests_1 = array();
$quests_3 = array();
if ($sql["char"]->num_rows($result)) {
while ($quest = $sql["char"]->fetch_assoc($result)) {
$deplang = get_lang_id();
if ($core == 1) {
$query1 = $sql["char"]->query("SELECT *, questlevel, Title AS Title1 FROM `" . $world_db[$realmid]['name'] . "`.quests " . ($locales_search_option != 0 ? "LEFT JOIN `" . $world_db[$realmid]['name'] . "`.quests_localized ON (quests_localized.entry=quests.entry AND language_code='" . $locales_search_option . "' ) " : " ") . "WHERE quests.entry='" . $quest["quest_id"] . "'");
} elseif ($core == 2) {
$query1 = $sql["char"]->query("SELECT *, QuestLevel AS questlevel, Title AS Title1 FROM `" . $world_db[$realmid]['name'] . "`.quest_template " . ($locales_search_option != 0 ? "LEFT JOIN `" . $world_db[$realmid]['name'] . "`.locales_quest ON locales_quest.entry=quest_template.entry " : " ") . "WHERE quest_template.entry='" . $quest["quest_id"] . "'");
} else {
$query1 = $sql["char"]->query("SELECT *, Level AS questlevel, Title AS Title1 FROM `" . $world_db[$realmid]['name'] . "`.quest_template " . ($locales_search_option != 0 ? "LEFT JOIN `" . $world_db[$realmid]['name'] . "`.locales_quest ON locales_quest.entry=quest_template.Id " : " ") . "WHERE quest_template.Id='" . $quest["quest_id"] . "'");
}
$quest_info = $sql["char"]->fetch_assoc($query1);
// Localization
if ($locales_search_option == 0) {
$quest_info["title"] = $quest_info["Title1"];
} else {
if ($core == 1) {
$quest_info["title"] = $quest_info["Title"];
} else {
$quest_info["title"] = $quest_info["Title_loc" . $locales_search_option];
}
}
if ($quest["completed"] == 1) {
array_push($quests_1, array($quest["quest_id"], $quest_info["questlevel"], $quest_info["title"], $quest["rewarded"]));
} else {
array_push($quests_3, array($quest["quest_id"], $quest_info["questlevel"], $quest_info["title"]));
}
}
unset($quest);
unset($quest_info);
aasort($quests_1, $order_by, $dir);
$orderby = $order_by;
if ($orderby > 2) {
$orderby = 1;
}
aasort($quests_3, $orderby, $dir);
$all_record = count($quests_1);
foreach ($quests_3 as $data) {
$output .= '
<tr>
<td>' . $data[0] . '</td>
<td>(' . $data[1] . ')</td>
<td align="left"><a href="' . $base_datasite . $quest_datasite . $data[0] . '" rel="external">' . htmlentities($data[2], ENT_COMPAT, $site_encoding) . '</a></td>
<td><img src="img/aff_qst.png" width="14" height="14" alt="" /></td>
</tr>';
}
unset($quest_3);
if (count($quests_1)) {
$output .= '
</table>
<table class="hidden" id="ch_que_questsB">
<tr align="right">
<td>';
$output .= generate_pagination('char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=' . $order_by . '&dir=' . ($dir ? 0 : 1), $all_record, $itemperpage, $start);
$output .= '
</td>
</tr>
</table>
<table class="lined" id="ch_que_questsC">
<tr>
<th style="width: 10%;"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=0&dir=' . $dir . '"' . ($order_by == 0 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "quest_id") . '</a></th>
<th style="width: 7%;"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=1&dir=' . $dir . '"' . ($order_by == 1 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "quest_level") . '</a></th>
<th style="width: 68%;"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=2&dir=' . $dir . '"' . ($order_by == 2 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "quest_title") . '</a></th>
<th style="width: 10%;"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=3&dir=' . $dir . '"' . ($order_by == 3 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "rewarded") . '</a></th>
<th style="width: 5%;"><img src="img/aff_tick.png" width="14" height="14" alt="" /></th>
</tr>';
$i = 0;
foreach ($quests_1 as $data) {
if ($i < $start + $itemperpage && $i >= $start) {
$output .= '
<tr>
<td>' . $data[0] . '</td>
<td>(' . $data[1] . ')</td>
<td align="left"><a href="' . $base_datasite . $quest_datasite . $data[0] . '" rel="external">' . htmlentities($data[2], ENT_COMPAT, $site_encoding) . '</a></td>
<td><img src="img/aff_' . ($data[3] ? 'tick' : 'qst') . '.png" width="14" height="14" alt="" /></td>
<td><img src="img/aff_tick.png" width="14" height="14" alt="" /></td>
</tr>';
}
$i++;
}
unset($data);
unset($quest_1);
$output .= '
<tr align="right">
<td colspan="5">';
$output .= generate_pagination('char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=' . $order_by . '&dir=' . ($dir ? 0 : 1), $all_record, $itemperpage, $start);
$output .= '
</td>
</tr>';
}
} else {
$output .= '
<tr>
<td colspan="4"><p>' . lang("char", "no_act_quests") . '</p></td>
</tr>';
}
//---------------Page Specific Data Ends here----------------------------
//---------------Character Tabs Footer-----------------------------------
$output .= '
</table>
</div>
<br />
<table class="hidden center">
<tr>
<td>';
// button to user account page, user account page has own security
makebutton(lang("char", "chars_acc"), 'user.php?action=edit_user&id=' . $owner_acc_id . '', 130);
$output .= '
</td>
<td>';
// only higher level GM with delete access can edit character
// character edit allows removal of character items, so delete permission is needed
if ($user_lvl > $owner_gmlvl && $user_lvl >= $action_permission["delete"]) {
//makebutton($lang_char["edit_button"], 'char_edit.php?id='.$id.'&realm='.$realmid.'', 130);
$output .= '
</td>
<td>';
}
// only higher level GM with delete access, or character owner can delete character
if ($user_lvl > $owner_gmlvl && $user_lvl >= $action_permission["delete"] || $owner_name === $user_name) {
makebutton(lang("char", "del_char"), 'char_list.php?action=del_char_form&check%5B%5D=' . $id . '" type="wrn', 130);
$output .= '
</td>
<td>';
}
// only GM with update permission can send mail, mail can send items, so update permission is needed
if ($user_lvl >= $action_permission["update"]) {
makebutton(lang("char", "send_mail"), 'mail.php?type=ingame_mail&to=' . $char["name"] . '', 130);
$output .= '
</td>
<td>';
}
makebutton(lang("global", "back"), 'javascript:window.history.back()" type="def', 130);
$output .= '
</td>
</tr>
</table>
<br />
<!-- end of char_quest.php -->';
} else {
error(lang("char", "no_permission"));
}
} else {
error(lang("char", "no_char_found"));
}
}
function GetTCSVArray()
{
global $arFiles;
$arr = array();
foreach ($arFiles as $f) {
$MESS = array();
$key = replace_lang_id($f['PATH'], '#LANG_ID#');
$lang_id = get_lang_id($f['PATH']);
include $_SERVER["DOCUMENT_ROOT"] . $f['PATH'];
if (is_array($MESS)) {
foreach ($MESS as $m => $v) {
$arr[$key][$m][$lang_id] = $v;
}
}
}
return $arr;
}
function char_quest(&$sqlr, &$sqlc)
{
global $output, $lang_global, $lang_char, $realm_id, $world_db, $characters_db, $action_permission, $user_lvl, $user_name, $quest_datasite, $itemperpage;
wowhead_tt();
require_once 'core/char/char_security.php';
//==========================$_GET and SECURE=================================
$start = isset($_GET['start']) ? $sqlc->quote_smart($_GET['start']) : 0;
if (is_numeric($start)) {
} else {
$start = 0;
}
$order_by = isset($_GET['order_by']) ? $sqlc->quote_smart($_GET['order_by']) : 1;
if (is_numeric($order_by)) {
} else {
$order_by = 1;
}
$dir = isset($_GET['dir']) ? $sqlc->quote_smart($_GET['dir']) : 0;
if (preg_match('/^[01]{1}$/', $dir)) {
} else {
$dir = 0;
}
$order_dir = $dir ? 'ASC' : 'DESC';
$dir = $dir ? 0 : 1;
//==========================$_GET and SECURE end=============================
$result = $sqlc->query('SELECT account, name, race, class, level, gender
FROM characters WHERE guid = ' . $id . ' LIMIT 1');
if ($sqlc->num_rows($result)) {
$char = $sqlc->fetch_assoc($result);
$owner_acc_id = $sqlc->result($result, 0, 'account');
$result = $sqlr->query('SELECT `username`, `gmlevel` FROM `account` LEFT JOIN `account_access` ON `account`.`id`=`account_access`.`id` WHERE `account`.`id` = ' . $owner_acc_id . ' ORDER BY `gmlevel` DESC LIMIT 1');
$owner_name = $sqlr->result($result, 0, 'username');
$owner_gmlvl = $sqlr->result($result, 0, 'gmlevel');
if (empty($owner_gmlvl)) {
$owner_gmlvl = 0;
}
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name) {
$output .= '
<center>
<div id="tab_content">
<h1>' . $lang_char['quests'] . '</h1>
<br />';
require_once 'core/char/char_header.php';
$output .= '
<br /><br />
<table class="lined" style="width: 550px;">
<tr>
<th width="10%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=0&dir=' . $dir . '"' . ($order_by == 0 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_id'] . '</a></th>
<th width="7%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=1&dir=' . $dir . '"' . ($order_by == 1 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_level'] . '</a></th>
<th width="78%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=2&dir=' . $dir . '"' . ($order_by == 2 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_title'] . '</a></th>
<th width="5%"><img src="img/aff_qst.png" width="14" height="14" border="0" alt="" /></th>
</tr>';
$result = $sqlc->query('SELECT quest, status FROM character_queststatus WHERE guid = ' . $id . ' AND ( status = 3 OR status = 1 ) ORDER BY status DESC');
$quests_1 = array();
$quests_3 = array();
if ($sqlc->num_rows($result)) {
while ($quest = $sqlc->fetch_assoc($result)) {
$deplang = get_lang_id();
$query1 = $sqlc->query('SELECT Level, IFNULL(' . ($deplang != 0 ? '`title_loc' . $deplang . '`' : 'NULL') . ', title) as Title FROM `' . $world_db[$realmid]['name'] . '`.`quest_template` LEFT JOIN `' . $world_db[$realmid]['name'] . '`.`locales_quest` ON `quest_template`.`id` = `locales_quest`.`entry` WHERE `quest_template`.`id` = \'' . $quest['quest'] . '\'');
$quest_info = $sqlc->fetch_assoc($query1);
if (1 == $quest['status']) {
array_push($quests_1, array($quest['quest'], $quest_info['QuestLevel'], $quest_info['Title'], $quest['rewarded']));
} else {
array_push($quests_3, array($quest['quest'], $quest_info['QuestLevel'], $quest_info['Title']));
}
}
unset($quest);
unset($quest_info);
aasort($quests_1, $order_by, $dir);
$orderby = $order_by;
if (2 < $orderby) {
$orderby = 1;
}
aasort($quests_3, $orderby, $dir);
$all_record = count($quests_1);
foreach ($quests_3 as $data) {
$output .= '
<tr>
<td>' . $data[0] . '</td>
<td>(' . $data[1] . ')</td>
<td align="left"><a href="' . $quest_datasite . $data[0] . '" target="_blank">' . htmlentities($data[2]) . '</a></td>
<td><img src="img/aff_qst.png" width="14" height="14" alt="" /></td>
</tr>';
}
unset($quest_3);
if (count($quests_1)) {
$output .= '
</table>
<table class="hidden" style="width: 550px;">
<tr align="right">
<td>';
$output .= generate_pagination('char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=' . $order_by . '&dir=' . ($dir ? 0 : 1), $all_record, $itemperpage, $start);
$output .= '
</td>
</tr>
</table>
<table class="lined" style="width: 550px;">
<tr>
<th width="10%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=0&dir=' . $dir . '"' . ($order_by == 0 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_id'] . '</a></th>
<th width="7%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=1&dir=' . $dir . '"' . ($order_by == 1 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_level'] . '</a></th>
<th width="68%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=2&dir=' . $dir . '"' . ($order_by == 2 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_title'] . '</a></th>
<th width="10%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=3&dir=' . $dir . '"' . ($order_by == 3 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['rewarded'] . '</a></th>
<th width="5%"><img src="img/aff_tick.png" width="14" height="14" border="0" alt="" /></th>
</tr>';
$i = 0;
foreach ($quests_1 as $data) {
if ($i < $start + $itemperpage && $i >= $start) {
$output .= '
<tr>
<td>' . $data[0] . '</td>
<td>(' . $data[1] . ')</td>
<td align="left"><a href="' . $quest_datasite . $data[0] . '" target="_blank">' . htmlentities($data[2]) . '</a></td>
<td><img src="img/aff_' . ($data[3] ? 'tick' : 'qst') . '.png" width="14" height="14" alt="" /></td>
<td><img src="img/aff_tick.png" width="14" height="14" alt="" /></td>
</tr>';
}
$i++;
}
unset($data);
unset($quest_1);
$output .= '
<tr align="right">
<td colspan="5">';
$output .= generate_pagination('char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=' . $order_by . '&dir=' . ($dir ? 0 : 1), $all_record, $itemperpage, $start);
$output .= '
</td>
</tr>';
}
} else {
$output .= '
<tr>
<td colspan="4"><p>' . $lang_char['no_act_quests'] . '</p></td>
</tr>';
}
//---------------Page Specific Data Ends here----------------------------
//---------------Character Tabs Footer-----------------------------------
$output .= '
</table>
</div>
</div>
<br />';
require_once 'core/char/char_footer.php';
$output .= '
<br />
</center>
<!-- end of char_quest.php -->';
} else {
error($lang_char['no_permission']);
}
} else {
error($lang_char['no_char_found']);
}
}
function do_update($mode)
{
global $world_db, $realm_id, $action_permission, $user_lvl, $locales_search_option, $sqlw;
$deplang = get_lang_id();
if (!isset($_POST['entry']) || $_POST['entry'] === '') {
redirect("vendor.php?error=1");
}
$entry = $sqlw->quote_smart($_POST['entry']);
// ADD/EDIT ITEM
if (isset($_POST['amount']) && $_POST['amount'] != '') {
$amount = $sqlw->quote_smart($_POST['amount']);
} else {
$amount = 0;
}
if (isset($_POST['maxamount']) && $_POST['maxamount'] != '') {
$max_amount = $sqlw->quote_smart($_POST['maxamount']);
} else {
$max_amount = 0;
}
if (isset($_POST['inctime']) && $_POST['inctime'] != '') {
$inctime = $sqlw->quote_smart($_POST['inctime']);
} else {
$inctime = 0;
}
if (isset($_POST['item']) && $_POST['item'] != '') {
$item = $sqlw->quote_smart($_POST['item']);
} else {
$item = 0;
}
if (isset($_POST['extended_cost']) && $_POST['extended_cost'] != '') {
$extended_cost = $sqlw->quote_smart($_POST['extended_cost']);
} else {
$extended_cost = 0;
}
// RESTRICTIONS
if (isset($_POST['racemask']) && $_POST['racemask'] != '') {
$racemask = $sqlw->quote_smart($_POST['racemask']);
} else {
$racemask = 0;
}
if (isset($_POST['reqrepfaction']) && $_POST['reqrepfaction'] != '') {
$reqrepfaction = $sqlw->quote_smart($_POST['reqrepfaction']);
} else {
$reqrepfaction = 0;
}
if (isset($_POST['reqrepfactionvalue']) && $_POST['reqrepfactionvalue'] != '') {
$reqrepfactionvalue = $sqlw->quote_smart($_POST['reqrepfactionvalue']);
} else {
$reqrepfactionvalue = 0;
}
if (isset($_POST['cannotbuyattextid']) && $_POST['cannotbuyattextid'] != '') {
$cannotbuyattextid = $sqlw->quote_smart($_POST['cannotbuyattextid']);
} else {
$cannotbuyattextid = 0;
}
if (isset($_POST['canbuyattextid']) && $_POST['canbuyattextid'] != '') {
$canbuyattextid = $sqlw->quote_smart($_POST['canbuyattextid']);
} else {
$canbuyattextid = 0;
}
// insert or update creature
if ($mode == "1") {
// check if item already exists
$query = "SELECT * FROM vendors WHERE entry = '" . $entry . "' AND item = '" . $item . "'";
$result = $sqlw->query($query);
if ($sqlw->num_rows($result) > 0) {
$sql_query = "UPDATE vendors SET entry = '" . $entry . "', item = '" . $item . "', amount = '" . $amount . "', \r\n max_amount = '" . $max_amount . "', inctime = '" . $inctime . "', \r\n extended_cost = '" . $extended_cost . "' WHERE entry = '" . $entry . "' AND item = '" . $item . "'";
} else {
// ADD NEW ITEM
$sql_query = "INSERT INTO vendors ( entry, item, amount, max_amount, inctime,\r\n extended_cost) VALUES ( '{$entry}', '{$item}', '{$amount}', '{$max_amount}', '{$inctime}',\r\n '{$extended_cost}' )";
}
} elseif ($mode == "2") {
// DELETE ITEM(s)
$sql_query = "";
foreach ($_POST['check'] as $item) {
$sql_query .= "DELETE FROM vendors WHERE item = '" . $item . "';\n";
}
} elseif ($mode == "3") {
// UPDATE RESTRICTIONS
// check if we have an entry
// if we do, update it, else make a new one
$query = "SELECT * FROM vendor_restrictions WHERE entry = '" . $entry . "'";
$result = $sqlw->query($query);
if ($sqlw->num_rows($result) > 0) {
$sql_query = "UPDATE vendor_restrictions SET racemask = '" . $racemask . "', reqrepfaction = '" . $reqrepfaction . "', \r\n reqrepfactionvalue = '" . $reqrepfactionvalue . "', cannotbuyattextid = '" . $cannotbuyattextid . "', \r\n canbuyattextid = '" . $canbuyattextid . "' WHERE entry = '" . $entry . "'";
} else {
$sql_query = "INSERT INTO vendor_restrictions (entry, racemask, reqrepfaction, reqrepfactionvalue,\r\n cannotbuyattextid, canbuyattextid)\r\n VALUES ('" . $entry . "', '" . $racemask . "', '" . $reqrepfaction . "', '" . $reqrepfactionvalue . "', '" . $cannotbuyattextid . "', '" . $canbuyattextid . "')";
}
}
if (isset($_POST['backup_op']) && $_POST['backup_op'] == 1) {
//$sqlw->close();
Header("Content-type: application/octet-stream");
Header("Content-Disposition: attachment; filename=vendor_{$entry}.sql");
echo $sql_query;
exit;
redirect("vendor.php?action=edit&entry={$entry}&error=4");
} else {
$sql_query = explode(';', $sql_query);
foreach ($sql_query as $tmp_query) {
if ($tmp_query && $tmp_query != "\n") {
$result = $sqlw->query($tmp_query);
}
}
//$sqlw->close();
}
if ($result) {
redirect("vendor.php?action=edit&entry={$entry}&error=4");
} else {
redirect("vendor.php");
}
}
function edit()
{
global $output, $world_db, $realm_id, $item_datasite, $lang_id_tab, $quest_datasite, $action_permission, $user_lvl, $creature_datasite, $sqlw;
//wowhead_tt();
valid_login($action_permission['view']);
if (!isset($_GET['entry'])) {
redirect("item.php?error=1");
}
/*$sql = new SQL;
$sql->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);*/
$entry = $sqlw->quote_smart($_GET['entry']);
$deplang = get_lang_id();
// this_is_junk: ArcEmu stores the quantity you get when you buy an item in the vendors table
// Both MaNGOS databases that I have (UDB 371 and YTDB 507 have ZERO items with requiredhonorrank that is not ZERO.
// Same for requiredcityrank.
// I don't know what socketcontent_* does in MaNGOS, it's ZERO unless it equals socketcolor_*
// which is probably why ArcEmu has Unknown columns after each socket_color_* field.
// ArcEmu doesn't have a scriptname field.
// ArcEmu doesn't seem to have a field like DisenchantID
// I'm not sure what minmoneyloot and maxmoneyloot actually do.
//$result = $sql->query("SELECT `items`.`entry`,`class`,`subclass`,`field4`,IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name1`) as name,`displayid`,`Quality`,`Flags`,`BuyPrice`,`SellPrice`,`InventoryType`,`AllowableClass`,`AllowableRace`,`ItemLevel`,`RequiredLevel`,`RequiredSkill`,`RequiredSkillRank`,`requiredspell`,`RequiredFaction`,`RequiredFactionStanding`,`unique`,`maxcount`,`ContainerSlots`,`stat_type1`,`stat_value1`,`stat_type2`,`stat_value2`,`stat_type3`,`stat_value3`,`stat_type4`,`stat_value4`,`stat_type5`,`stat_value5`,`stat_type6`,`stat_value6`,`stat_type7`,`stat_value7`,`stat_type8`,`stat_value8`,`stat_type9`,`stat_value9`,`stat_type10`,`stat_value10`,`dmg_min1`,`dmg_max1`,`dmg_type1`,`dmg_min2`,`dmg_max2`,`dmg_type2`,`armor`,`holy_res`,`fire_res`,`nature_res`,`frost_res`,`shadow_res`,`arcane_res`,`delay`,`ammo_type`,`Range`,`spellid_1`,`spelltrigger_1`,`spellcharges_1`,`spellcooldown_1`,`spellcategory_1`,`spellcategorycooldown_1`,`spellid_2`,`spelltrigger_2`,`spellcharges_2`,`spellcooldown_2`,`spellcategory_2`,`spellcategorycooldown_2`,`spellid_3`,`spelltrigger_3`,`spellcharges_3`,`spellcooldown_3`,`spellcategory_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigger_4`,`spellcharges_4`,`spellcooldown_4`,`spellcategory_4`,`spellcategorycooldown_4`,`spellid_5`,`spelltrigger_5`,`spellcharges_5`,`spellcooldown_5`,`spellcategory_5`,`spellcategorycooldown_5`,`bonding`,items.`description`,`Page_id`,`Page_language`,`Page_Material`,`quest_id`,`lock_id`,`lock_Material`,`sheathid`,`RandomProp`,`RandomSuffix`,`block`,`itemset`,`MaxDurability`,`zonenameid`,`Mapid`,`BagFamily`,`TotemCategory`,`socket_Color_1`,`socket_Color_2`,`socket_Color_3`,`socket_Bonus`,`GemProperties`,`ReqDisenchantSkill`,`ArmorDamageModifier`,itempetfood.`Food_Type` FROM items LEFT JOIN items_localized ON items.entry = items_localized.entry LEFT JOIN itempetfood ON items.entry = itempetfood.entry WHERE items.entry = '$entry'");
$result = $sqlw->query("SELECT `items`.`entry`,`class`,`subclass`,`field4`,`name1`,`displayid`,`Quality`,`Flags`,`BuyPrice`,`SellPrice`,`InventoryType`,`AllowableClass`,`AllowableRace`,`ItemLevel`,`RequiredLevel`,`RequiredSkill`,`RequiredSkillRank`,`requiredspell`,`RequiredFaction`,`RequiredFactionStanding`,`unique`,`maxcount`,`ContainerSlots`,`stat_type1`,`stat_value1`,`stat_type2`,`stat_value2`,`stat_type3`,`stat_value3`,`stat_type4`,`stat_value4`,`stat_type5`,`stat_value5`,`stat_type6`,`stat_value6`,`stat_type7`,`stat_value7`,`stat_type8`,`stat_value8`,`stat_type9`,`stat_value9`,`stat_type10`,`stat_value10`,`dmg_min1`,`dmg_max1`,`dmg_type1`,`dmg_min2`,`dmg_max2`,`dmg_type2`,`armor`,`holy_res`,`fire_res`,`nature_res`,`frost_res`,`shadow_res`,`arcane_res`,`delay`,`ammo_type`,`Range`,`spellid_1`,`spelltrigger_1`,`spellcharges_1`,`spellcooldown_1`,`spellcategory_1`,`spellcategorycooldown_1`,`spellid_2`,`spelltrigger_2`,`spellcharges_2`,`spellcooldown_2`,`spellcategory_2`,`spellcategorycooldown_2`,`spellid_3`,`spelltrigger_3`,`spellcharges_3`,`spellcooldown_3`,`spellcategory_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigger_4`,`spellcharges_4`,`spellcooldown_4`,`spellcategory_4`,`spellcategorycooldown_4`,`spellid_5`,`spelltrigger_5`,`spellcharges_5`,`spellcooldown_5`,`spellcategory_5`,`spellcategorycooldown_5`,`bonding`,items.`description`,`Page_id`,`Page_language`,`Page_Material`,`quest_id`,`lock_id`,`lock_Material`,`sheathid`,`RandomProp`,`RandomSuffix`,`block`,`itemset`,`MaxDurability`,`zonenameid`,`Mapid`,`BagFamily`,`TotemCategory`,`socket_Color_1`,`socket_Color_2`,`socket_Color_3`,`socket_Bonus`,`GemProperties`,`ReqDisenchantSkill`,`ArmorDamageModifier` FROM items WHERE items.entry = '{$entry}'");
if ($result) {
$item = $sqlw->fetch_assoc($result);
require_once "libs/get_lib.php";
//$tooltip = get_item_tooltip($entry);
$output .= "<script type=\"text/javascript\" src=\"libs/js/tab.js\"></script>\r\n <center>\r\n <br /><br /><br />\r\n <form method=\"post\" action=\"item.php?action=do_update\" name=\"form1\">\r\n <input type=\"hidden\" name=\"backup_op\" value=\"0\"/>\r\n <input type=\"hidden\" name=\"type\" value=\"edit\"/>\r\n <input type=\"hidden\" name=\"entry\" value=\"{$entry}\"/>\r\n\r\n<div class=\"jtab-container\" id=\"container\">\r\n <ul class=\"jtabs\">\r\n <li><a href=\"#\" onclick=\"return showPane('pane1', this)\" id=\"tab1\">" . lang('item_edit', 'general_tab') . "</a></li>\r\n <li><a href=\"#\" onclick=\"return showPane('pane2', this)\">" . lang('item_edit', 'additional_tab') . "</a></li>\r\n <li><a href=\"#\" onclick=\"return showPane('pane3', this)\">" . lang('item_edit', 'stats_tab') . "</a></li>\r\n <li><a href=\"#\" onclick=\"return showPane('pane4', this)\">" . lang('item_edit', 'damage_tab') . "</a></li>\r\n <li><a href=\"#\" onclick=\"return showPane('pane5', this)\">" . lang('item_edit', 'spell_tab') . "</a></li>\r\n <li><a href=\"#\" onclick=\"return showPane('pane7', this)\">" . lang('item_edit', 'sock_tab') . "</a></li>\r\n <li><a href=\"#\" onclick=\"return showPane('pane6', this)\">" . lang('item_edit', 'req_tab') . "</a></li>\r\n <li><a href=\"#\" onclick=\"return showPane('pane8', this)\">" . lang('item_edit', 'info') . "</a></li>";
if ($item['DisenchantID']) {
$output .= "<li><a href=\"#\" onclick=\"return showPane('pane9', this)\">" . lang('item_edit', 'disenchant_tab') . "</a></li>";
}
$output .= "</ul>\r\n <div class=\"jtab-panes\">";
$output .= "<div id=\"pane1\">\r\n <br /><br />\r\n<table class=\"lined\" style=\"width: 720px;\">\r\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'general') . ":</td></tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'entry'), lang('item_edit', 'entry_desc')) . "</td>\r\n <td>";
// this_is_junk: I re-enabled display of item ID, even if it isn't guaranteed to work with wowhead. :P
$output .= maketooltip($entry, "{$item_datasite}{$entry}", $tooltip, "item_tooltip");
$output .= "</td>\r\n <td>" . makeinfocell(lang('item_edit', 'display_id'), lang('item_edit', 'display_id_desc')) . "</td>\r\n <td><input type=\"text\" name=\"displayid\" size=\"8\" maxlength=\"11\" value=\"{$item['displayid']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'req_level'), lang('item_edit', 'req_level_desc')) . "</td>\r\n <td><input type=\"text\" name=\"RequiredLevel\" size=\"8\" maxlength=\"4\" value=\"{$item['RequiredLevel']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'item_level'), lang('item_edit', 'item_level_desc')) . "</td>\r\n <td><input type=\"text\" name=\"ItemLevel\" size=\"8\" maxlength=\"4\" value=\"{$item['ItemLevel']}\" /></td>\r\n</tr>\r\n\r\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'names') . ":</td></tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'item_name'), lang('item_edit', 'item_name_desc')) . "</td>\r\n <td colspan=\"3\"><input type=\"text\" name=\"name\" size=\"30\" maxlength=\"225\" value=\"" . htmlentities($item['name1']) . "\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'description'), lang('item_edit', 'description_desc')) . "</td>\r\n <td colspan=\"3\"><input type=\"text\" name=\"description\" size=\"30\" maxlength=\"225\" value=\"" . htmlentities($item['description']) . "\" /></td>\r\n</tr>\r\n\r\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'type') . ":</td></tr>\r\n <tr>";
$class = array(0 => "", 1 => "", 2 => "", 4 => "", 5 => "", 6 => "", 7 => "", 9 => "", 11 => "", 12 => "", 13 => "", 14 => "", 15 => "");
$class[$item['class']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'class'), lang('item_edit', 'class_desc')) . "</td>\r\n <td colspan=\"3\"><select name=\"class\">\r\n <option value=\"0\" {$class[0]}>0 - " . lang('item', 'consumable') . "</option>\r\n <option value=\"1\" {$class[1]}>1 - " . lang('item', 'bag') . "</option>\r\n <option value=\"2\" {$class[2]}>2 - " . lang('item', 'weapon') . "</option>\r\n <option value=\"4\" {$class[4]}>4 - " . lang('item', 'armor') . "</option>\r\n <option value=\"5\" {$class[5]}>5 - " . lang('item', 'reagent') . "</option>\r\n <option value=\"6\" {$class[6]}>6 - " . lang('item', 'projectile') . "</option>\r\n <option value=\"7\" {$class[7]}>7 - " . lang('item', 'trade_goods') . "s</option>\r\n <option value=\"9\" {$class[9]}>9 - " . lang('item', 'recipe') . "</option>\r\n <option value=\"11\" {$class[11]}>11 - " . lang('item', 'quiver') . "</option>\r\n <option value=\"12\" {$class[12]}>12 - " . lang('item', 'quest') . "</option>\r\n <option value=\"13\" {$class[13]}>13 - " . lang('item', 'key') . "</option>\r\n <option value=\"14\" {$class[14]}>14 - " . lang('item', 'permanent') . "</option>\r\n <option value=\"15\" {$class[15]}>15 - " . lang('item', 'misc_short') . "</option>\r\n </select></td>";
unset($class);
$subclass = array(0 => array(0 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => ""), 1 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => ""), 2 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 10 => "", 11 => "", 12 => "", 13 => "", 14 => "", 15 => "", 16 => "", 17 => "", 18 => "", 19 => "", 20 => ""), 4 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 9 => ""), 6 => array(2 => "", 3 => ""), 7 => array(0 => "", 1 => "", 2 => "", 3 => ""), 9 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => ""), 11 => array(2 => "", 3 => ""), 13 => array(0 => "", 1 => ""));
$subclass[$item['class']][$item['subclass']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'subclass'), lang('item_edit', 'subclass_desc')) . "</td>\r\n <td colspan=\"3\"><select name=\"subclass\">\r\n <option value=\"0\" {$subclass[0][0]}>0 - " . lang('item', 'none') . "</option>\r\n <optgroup label=\"Class 0: " . lang('item', 'consumable') . "\">\r\n <option value=\"0\" {$subclass[0][0]}>0 - " . lang('item', 'consumable') . "</option>\r\n <option value=\"3\" {$subclass[0][3]}>3 - " . lang('item', 'potion') . "</option>\r\n <option value=\"4\" {$subclass[0][4]}>4 - " . lang('item', 'scroll') . "</option>\r\n <option value=\"5\" {$subclass[0][5]}>5 - " . lang('item', 'bandage') . "</option>\r\n <option value=\"6\" {$subclass[0][6]}>6 - " . lang('item', 'healthstone') . "</option>\r\n <option value=\"7\" {$subclass[0][7]}>7 - " . lang('item', 'combat_effect') . "</option>\r\n <optgroup label=\"Class 1: " . lang('item', 'bag') . "\">\r\n <option value=\"0\" {$subclass[1][0]}>0 - " . lang('item', 'bag') . "</option>\r\n <option value=\"1\" {$subclass[1][1]}>1 - " . lang('item', 'soul_shards') . "</option>\r\n <option value=\"2\" {$subclass[1][2]}>2 - " . lang('item', 'herbs') . "</option>\r\n <option value=\"3\" {$subclass[1][3]}>3 - " . lang('item', 'enchanting') . "</option>\r\n <option value=\"4\" {$subclass[1][4]}>4 - " . lang('item', 'engineering') . "</option>\r\n <option value=\"5\" {$subclass[1][5]}>5 - " . lang('item', 'gems') . "</option>\r\n <option value=\"6\" {$subclass[1][6]}>6 - " . lang('item', 'mining') . "</option>\r\n <optgroup label=\"Class 2: " . lang('item', 'weapon') . "\">\r\n <option value=\"0\" {$subclass[2][0]}>0 - " . lang('item', 'axe_1h') . "</option>\r\n <option value=\"1\" {$subclass[2][2]}>1 - " . lang('item', 'axe_2h') . "</option>\r\n <option value=\"2\" {$subclass[2][2]}>2 - " . lang('item', 'bow') . "</option>\r\n <option value=\"3\" {$subclass[2][2]}>3 - " . lang('item', 'rifle') . "</option>\r\n <option value=\"4\" {$subclass[2][4]}>4 - " . lang('item', 'mace_1h') . "</option>\r\n <option value=\"5\" {$subclass[2][5]}>5 - " . lang('item', 'mace_2h') . "</option>\r\n <option value=\"6\" {$subclass[2][6]}>6 - " . lang('item', 'polearm') . "</option>\r\n <option value=\"7\" {$subclass[2][7]}>7 - " . lang('item', 'sword_1h') . "</option>\r\n <option value=\"8\" {$subclass[2][8]}>8 - " . lang('item', 'sword_2h') . "</option>\r\n <option value=\"10\" {$subclass[2][10]}>10 - " . lang('item', 'staff') . "</option>\r\n <option value=\"11\" {$subclass[2][11]}>11 - " . lang('item', 'exotic_1h') . "</option>\r\n <option value=\"12\" {$subclass[2][12]}>12 - " . lang('item', 'exotic_2h') . "</option>\r\n <option value=\"13\" {$subclass[2][13]}>13 - " . lang('item', 'fist_weapon') . "</option>\r\n <option value=\"14\" {$subclass[2][14]}>14 - " . lang('item', 'misc_weapon') . "</option>\r\n <option value=\"15\" {$subclass[2][15]}>15 - " . lang('item', 'dagger') . "</option>\r\n <option value=\"16\" {$subclass[2][16]}>16 - " . lang('item', 'thrown') . "</option>\r\n <option value=\"17\" {$subclass[2][17]}>17 - " . lang('item', 'spear') . "</option>\r\n <option value=\"18\" {$subclass[2][18]}>18 - " . lang('item', 'crossbow') . "</option>\r\n <option value=\"19\" {$subclass[2][19]}>19 - " . lang('item', 'wand') . "</option>\r\n <option value=\"20\" {$subclass[2][20]}>20 - " . lang('item', 'fishing_pole') . "</option>\r\n </optgroup>\r\n <optgroup label=\"Class 4: " . lang('item', 'armor') . "\">\r\n <option value=\"0\" {$subclass[4][0]}>0 - " . lang('item', 'misc') . "</option>\r\n <option value=\"1\" {$subclass[4][1]}>1 - " . lang('item', 'cloth') . "</option>\r\n <option value=\"2\" {$subclass[4][2]}>2 - " . lang('item', 'leather') . "</option>\r\n <option value=\"3\" {$subclass[4][3]}>3 - " . lang('item', 'mail') . "</option>\r\n <option value=\"4\" {$subclass[4][4]}>4 - " . lang('item', 'plate') . "</option>\r\n <option value=\"5\" {$subclass[4][5]}>5 - " . lang('item', 'buckler') . "</option>\r\n <option value=\"6\" {$subclass[4][6]}>6 - " . lang('item', 'shield') . "</option>\r\n <option value=\"7\" {$subclass[4][7]}>7 - " . lang('item', 'libram') . "</option>\r\n <option value=\"8\" {$subclass[4][8]}>8 - " . lang('item', 'idol') . "</option>\r\n <option value=\"9\" {$subclass[4][9]}>9 - " . lang('item', 'totem') . "</option>\r\n </optgroup>\r\n <optgroup label=\"Class 6: " . lang('item', 'projectile') . "\">\r\n <option value=\"2\" {$subclass[6][2]}>2 - " . lang('item', 'arrows') . "</option>\r\n <option value=\"3\" {$subclass[6][3]}>3 - " . lang('item', 'bullets') . "</option>\r\n </optgroup>\r\n <optgroup label=\"Class 7: " . lang('item', 'trade_goods') . "\">\r\n <option value=\"0\" {$subclass[7][0]}>0 - " . lang('item', 'trade_goods') . "</option>\r\n <option value=\"1\" {$subclass[7][1]}>1 - " . lang('item', 'parts') . "</option>\r\n <option value=\"2\" {$subclass[7][2]}>2 - " . lang('item', 'explosives') . "</option>\r\n <option value=\"3\" {$subclass[7][3]}>3 - " . lang('item', 'devices') . "</option>\r\n </optgroup>\r\n <optgroup label=\"Class 9: " . lang('item', 'recipe') . "\">\r\n <option value=\"0\" {$subclass[9][0]}>0 - " . lang('item', 'book') . "</option>\r\n <option value=\"1\" {$subclass[9][1]}>1 - " . lang('item', 'LW_pattern') . "</option>\r\n <option value=\"2\" {$subclass[9][2]}>2 - " . lang('item', 'tailoring_pattern') . "</option>\r\n <option value=\"3\" {$subclass[9][3]}>3 - " . lang('item', 'ENG_Schematic') . "</option>\r\n <option value=\"4\" {$subclass[9][4]}>4 - " . lang('item', 'BS_plans') . "</option>\r\n <option value=\"5\" {$subclass[9][5]}>5 - " . lang('item', 'cooking_recipe') . "</option>\r\n <option value=\"6\" {$subclass[9][6]}>6 - " . lang('item', 'alchemy_recipe') . "</option>\r\n <option value=\"7\" {$subclass[9][7]}>7 - " . lang('item', 'FA_manual') . "</option>\r\n <option value=\"8\" {$subclass[9][8]}>8 - " . lang('item', 'ench_formula') . "</option>\r\n <option value=\"9\" {$subclass[9][9]}>9 - " . lang('item', 'fishing_manual') . "</option>\r\n <option value=\"10\" {$subclass[9][10]}>10 - " . lang('item', 'JC_formula') . "</option>\r\n </optgroup>\r\n <optgroup label=\"Class 11: " . lang('item', 'quiver') . "\">\r\n <option value=\"2\" {$subclass[11][2]}>2 - " . lang('item', 'quiver') . "</option>\r\n <option value=\"3\" {$subclass[11][3]}>3 - " . lang('item', 'ammo_pouch') . "</option>\r\n </optgroup>\r\n <optgroup label=\"Class 13: " . lang('item', 'key') . "\">\r\n <option value=\"0\" {$subclass[13][0]}>0 - " . lang('item', 'key') . "</option>\r\n <option value=\"1\" {$subclass[13][1]}>1 - " . lang('item', 'lockpick') . "</option>\r\n </optgroup>\r\n </select></td>\r\n</tr>\r\n<tr>";
unset($subclass);
$quality = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "");
$quality[$item['Quality']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'quality'), lang('item_edit', 'quality_desc')) . "</td>\r\n <td colspan=\"2\"><select name=\"Quality\">\r\n <option value=\"0\" {$quality[0]}>0 - " . lang('item', 'poor') . "</option>\r\n <option value=\"1\" {$quality[1]}>1 - " . lang('item', 'common') . "</option>\r\n <option value=\"2\" {$quality[2]}>2 - " . lang('item', 'uncommon') . "</option>\r\n <option value=\"3\" {$quality[3]}>3 - " . lang('item', 'rare') . "</option>\r\n <option value=\"4\" {$quality[4]}>4 - " . lang('item', 'epic') . "</option>\r\n <option value=\"5\" {$quality[5]}>5 - " . lang('item', 'legendary') . "</option>\r\n <option value=\"6\" {$quality[6]}>6 - " . lang('item', 'artifact') . "</option>\r\n <option value=\"7\" {$quality[7]}>7 - " . lang('item', 'heirloom') . "</option>\r\n </select></td>";
unset($quality);
$inv_type = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => "", 11 => "", 12 => "", 13 => "", 14 => "", 15 => "", 16 => "", 17 => "", 18 => "", 19 => "", 20 => "", 21 => "", 22 => "", 23 => "", 24 => "", 25 => "", 26 => "");
$inv_type[$item['InventoryType']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'inv_type'), lang('item_edit', 'inv_type_desc')) . "</td>\r\n <td colspan=\"2\"><select name=\"InventoryType\">\r\n <option value=\"0\" {$inv_type[0]}>0 - " . lang('item', 'other') . "</option>\r\n <option value=\"1\" {$inv_type[1]}>1 - " . lang('item', 'head') . "</option>\r\n <option value=\"2\" {$inv_type[2]}>2 - " . lang('item', 'neck') . "</option>\r\n <option value=\"3\" {$inv_type[3]}>3 - " . lang('item', 'shoulder') . "</option>\r\n <option value=\"4\" {$inv_type[4]}>4 - " . lang('item', 'shirt') . "</option>\r\n <option value=\"5\" {$inv_type[5]}>5 - " . lang('item', 'chest') . "</option>\r\n <option value=\"6\" {$inv_type[6]}>6 - " . lang('item', 'belt') . "</option>\r\n <option value=\"7\" {$inv_type[7]}>7 - " . lang('item', 'legs') . "</option>\r\n <option value=\"8\" {$inv_type[8]}>8 - " . lang('item', 'feet') . "</option>\r\n <option value=\"9\" {$inv_type[9]}>9 - " . lang('item', 'belt') . "</option>\r\n <option value=\"10\" {$inv_type[10]}>10 - " . lang('item', 'gloves') . "</option>\r\n <option value=\"11\" {$inv_type[11]}>11 - " . lang('item', 'finger') . "</option>\r\n <option value=\"12\" {$inv_type[12]}>12 - " . lang('item', 'trinket') . "</option>\r\n <option value=\"13\" {$inv_type[13]}>13 - " . lang('item', 'one_hand') . "</option>\r\n <option value=\"14\" {$inv_type[14]}>14 - " . lang('item', 'off_hand') . "</option>\r\n <option value=\"15\" {$inv_type[15]}>15 - " . lang('item', 'bow') . "</option>\r\n <option value=\"16\" {$inv_type[16]}>16 - " . lang('item', 'back') . "</option>\r\n <option value=\"17\" {$inv_type[17]}>17 - " . lang('item', 'two_hand') . "</option>\r\n <option value=\"18\" {$inv_type[18]}>18 - " . lang('item', 'bag') . "</option>\r\n <option value=\"19\" {$inv_type[19]}>19 - " . lang('item', 'tabard') . "</option>\r\n <option value=\"20\" {$inv_type[20]}>20 - " . lang('item', 'robe') . "</option>\r\n <option value=\"21\" {$inv_type[21]}>21 - " . lang('item', 'main_hand') . "</option>\r\n <option value=\"22\" {$inv_type[22]}>22 - " . lang('item', 'off_misc') . "</option>\r\n <option value=\"23\" {$inv_type[23]}>23 - " . lang('item', 'tome') . "</option>\r\n <option value=\"24\" {$inv_type[24]}>24 - " . lang('item', 'projectile') . "</option>\r\n <option value=\"25\" {$inv_type[25]}>25 - " . lang('item', 'thrown') . "</option>\r\n <option value=\"26\" {$inv_type[26]}>26 - " . lang('item', 'rifle') . "</option>\r\n </select></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'flags'), lang('item_edit', 'flags_desc')) . "</td>\r\n <td><input type=\"text\" name=\"Flags\" size=\"10\" maxlength=\"30\" value=\"{$item['Flags']}\" /></td>\r\n </tr>\r\n\r\n <tr>\r\n <td>" . makeinfocell(lang('item_edit', 'item_set'), lang('item_edit', 'item_set_desc')) . "</td>\r\n <td><input type=\"text\" name=\"itemset\" size=\"10\" maxlength=\"30\" value=\"{$item['itemset']}\" /></td>";
unset($inv_type);
$bonding = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "");
$bonding[$item['bonding']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'bonding'), lang('item_edit', 'bonding_desc')) . "</td>\r\n <td colspan=\"3\"><select name=\"bonding\">\r\n <option value=\"0\" {$bonding[0]}>0 - " . lang('item', 'no_bind') . "</option>\r\n <option value=\"1\" {$bonding[1]}>1 - " . lang('item', 'bop') . "</option>\r\n <option value=\"2\" {$bonding[2]}>2 - " . lang('item', 'boe') . "</option>\r\n <option value=\"3\" {$bonding[3]}>3 - " . lang('item', 'bou') . "</option>\r\n <option value=\"4\" {$bonding[4]}>4 - " . lang('item', 'quest_item') . "</option>\r\n <option value=\"5\" {$bonding[5]}>5 - " . lang('item', 'quest_item') . "1</option>\r\n </select></td>\r\n\r\n<td>" . makeinfocell(lang('item_edit', 'start_quest'), lang('item_edit', 'start_quest_desc')) . "</td>\r\n<td><input type=\"text\" name=\"startquest\" size=\"10\" maxlength=\"30\" value=\"{$item['quest_id']}\" /></td>\r\n\r\n</tr>\r\n</table>\r\n<br />" . lang('item_edit', 'short_rules_desc') . "<br /><br />\r\n</div>";
unset($bonding);
$split_buy = substr($item['BuyPrice'], 0, -4) . " " . substr($item['BuyPrice'], -4, 2) . " " . substr($item['BuyPrice'], -2) . "";
$split_sell = substr($item['SellPrice'], 0, -4) . " " . substr($item['SellPrice'], -4, 2) . " " . substr($item['SellPrice'], -2) . "";
$output .= "<div id=\"pane2\">\r\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\r\n <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'vendor') . ":</td></tr>\r\n <tr>\r\n <td>" . makeinfocell(lang('item_edit', 'buy_price'), lang('item_edit', 'buy_price_desc')) . "</td>\r\n <td><input type=\"text\" name=\"BuyPrice\" size=\"8\" maxlength=\"30\" value=\"{$split_buy}\" /></td>\r\n <td>" . makeinfocell(lang('item_edit', 'sell_price'), lang('item_edit', 'sell_price_desc')) . "</td>\r\n <td><input type=\"text\" name=\"SellPrice\" size=\"8\" maxlength=\"30\" value=\"{$split_sell}\" /></td>\r\n <td></td><td></td>\r\n <td></td><td></td>\r\n </tr>\r\n\r\n <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'container') . ":</td></tr>\r\n <tr>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'max_count'), lang('item_edit', 'max_count_desc')) . "</td>\r\n <td><input type=\"text\" name=\"maxcount\" size=\"6\" maxlength=\"5\" value=\"{$item['maxcount']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'bag_family'), lang('item_edit', 'bag_family_desc')) . "</td>";
$bagfamily = array(0 => "", 1 => "", 2 => "", 3 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => "", 12 => "");
$bagfamily[$item['BagFamily']] = " selected=\"selected\" ";
$output .= "<td><select name=\"BagFamily\">\r\n <option value=\"0\" {$bagfamily[0]}>0 - " . lang('item', 'none') . "</option>\r\n <option value=\"1\" {$bagfamily[1]}>1 - " . lang('item', 'arrows') . "</option>\r\n <option value=\"2\" {$bagfamily[2]}>2 - " . lang('item', 'bullets') . "</option>\r\n <option value=\"3\" {$bagfamily[3]}>3 - " . lang('item', 'soul_shards') . "</option>\r\n <option value=\"6\" {$bagfamily[6]}>6 - " . lang('item', 'herbs') . "</option>\r\n <option value=\"7\" {$bagfamily[7]}>7 - " . lang('item', 'enchanting') . "</option>\r\n <option value=\"8\" {$bagfamily[8]}>8 - " . lang('item', 'engineering') . "</option>\r\n <option value=\"9\" {$bagfamily[9]}>9 - " . lang('item', 'keys') . "</option>\r\n <option value=\"10\" {$bagfamily[10]}>10 - " . lang('item', 'gems') . "</option>\r\n <option value=\"12\" {$bagfamily[12]}>12 - " . lang('item', 'mining') . "</option>\r\n </select></td>\r\n <td>" . makeinfocell(lang('item_edit', 'bag_slots'), lang('item_edit', 'bag_slots_desc')) . "</td>\r\n <td><input type=\"text\" name=\"ContainerSlots\" size=\"10\" maxlength=\"3\" value=\"{$item['ContainerSlots']}\" /></td>\r\n\r\n <td></td>\r\n <td></td>\r\n </tr>\r\n <tr>\r\n\r\n <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'materials') . ":</td></tr>";
unset($bagfamily);
$Material = array(-1 => "", 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "");
$Material[$item['lock_Material']] = " selected=\"selected\" ";
$output .= "<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'material'), lang('item_edit', 'material_desc')) . "</td>\r\n <td colspan=\"2\"><select name=\"Material\">\r\n <option value=\"-1\" {$Material[-1]}>-1 - " . lang('item_edit', 'consumables') . "</option>\r\n <option value=\"0\" {$Material[0]}>0 - " . lang('item_edit', 'none') . "</option>\r\n <option value=\"1\" {$Material[1]}>1 - " . lang('item_edit', 'metal') . "</option>\r\n <option value=\"2\" {$Material[2]}>2 - " . lang('item_edit', 'wood') . "</option>\r\n <option value=\"3\" {$Material[3]}>3 - " . lang('item_edit', 'liquid') . "</option>\r\n <option value=\"4\" {$Material[4]}>4 - " . lang('item_edit', 'jewelry') . "</option>\r\n <option value=\"5\" {$Material[5]}>5 - " . lang('item_edit', 'chain') . "</option>\r\n <option value=\"6\" {$Material[6]}>6 - " . lang('item_edit', 'plate') . "</option>\r\n <option value=\"7\" {$Material[7]}>7 - " . lang('item_edit', 'cloth') . "</option>\r\n <option value=\"8\" {$Material[8]}>8 - " . lang('item_edit', 'leather') . "</option>\r\n </select></td>";
unset($Material);
$PageMaterial = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "");
$PageMaterial[$item['Page_Material']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'page_material'), lang('item_edit', 'page_material_desc')) . "</td>\r\n <td colspan=\"2\"><select name=\"PageMaterial\">\r\n <option value=\"0\" {$PageMaterial[0]}>0 - " . lang('item_edit', 'none') . "</option>\r\n <option value=\"1\" {$PageMaterial[1]}>1 - " . lang('item_edit', 'parchment') . "</option>\r\n <option value=\"2\" {$PageMaterial[2]}>2 - " . lang('item_edit', 'stone') . "</option>\r\n <option value=\"3\" {$PageMaterial[3]}>3 - " . lang('item_edit', 'marble') . "</option>\r\n <option value=\"4\" {$PageMaterial[4]}>4 - " . lang('item_edit', 'silver') . "</option>\r\n <option value=\"5\" {$PageMaterial[5]}>5 - " . lang('item_edit', 'bronze') . "</option>\r\n </select></td>";
unset($PageMaterial);
$output .= "<td>" . makeinfocell(lang('item_edit', 'max_durability'), lang('item_edit', 'max_durability_desc')) . "</td>\r\n <td><input type=\"text\" name=\"MaxDurability\" size=\"8\" maxlength=\"30\" value=\"{$item['MaxDurability']}\" /></td>\r\n</tr>\r\n\r\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'RandomProperty') . ":</td></tr>\r\n<tr>\r\n <td colspan=\"2\">" . makeinfocell(lang('item_edit', 'RandomProperty'), lang('item_edit', 'RandomProperty_desc')) . "</td>\r\n <td colspan=\"2\"><input type=\"text\" name=\"RandomProperty\" size=\"8\" maxlength=\"30\" value=\"{$item['RandomProp']}\" /></td>\r\n\r\n <td colspan=\"2\">" . makeinfocell(lang('item_edit', 'RandomSuffix'), lang('item_edit', 'RandomSuffix_desc')) . "</td>\r\n <td colspan=\"2\"><input type=\"text\" name=\"RandomSuffix\" size=\"8\" maxlength=\"10\" value=\"{$item['RandomSuffix']}\" /></td>\r\n</tr>\r\n\r\n\r\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'other') . ":</td></tr>\r\n <tr>\r\n <td>" . makeinfocell(lang('item_edit', 'area'), lang('item_edit', 'area_desc')) . "</td>\r\n <td><input type=\"text\" name=\"area\" size=\"8\" maxlength=\"10\" value=\"{$item['zonenameid']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'map'), lang('item_edit', 'map_desc')) . "</td>\r\n <td><input type=\"text\" name=\"Map\" size=\"8\" maxlength=\"10\" value=\"{$item['Mapid']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'page_text'), lang('item_edit', 'page_text_desc')) . "</td>\r\n <td><input type=\"text\" name=\"PageText\" size=\"6\" maxlength=\"30\" value=\"{$item['Page_id']}\" /></td>\r\n\r\n <td></td>\r\n <td></td>\r\n </tr>\r\n <tr>\r\n\r\n <tr>\r\n\r\n <td colspan=\"2\">" . makeinfocell(lang('item_edit', 'req_skill_disenchant'), lang('item_edit', 'req_skill_disenchant_desc')) . "</td>\r\n <td><input type=\"text\" name=\"RequiredDisenchantSkill\" size=\"10\" maxlength=\"10\" value=\"{$item['ReqDisenchantSkill']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'lock_id'), lang('item_edit', 'lock_id_desc')) . "</td>\r\n <td><input type=\"text\" name=\"lock_id\" size=\"8\" maxlength=\"30\" value=\"{$item['lock_id']}\" /></td>\r\n <td colspan=\"2\"></td>\r\n <td></td>\r\n </tr>";
$LanguageID = array(0 => "", 1 => "", 2 => "", 3 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => "", 11 => "", 12 => "", 13 => "", 14 => "", 33 => "");
$LanguageID[$item['page_Language']] = " selected=\"selected\" ";
$output .= "<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'lang_id'), lang('item_edit', 'lang_id_desc')) . "</td>\r\n <td colspan=\"2\"><select name=\"LanguageID\">\r\n <option value=\"0\" {$LanguageID[0]}>0 - " . lang('item_edit', 'other') . "</option>\r\n <option value=\"1\" {$LanguageID[1]}>1 - Orcish</option>\r\n <option value=\"2\" {$LanguageID[2]}>2 - Darnassian</option>\r\n <option value=\"3\" {$LanguageID[3]}>3 - Taurahe</option>\r\n <option value=\"6\" {$LanguageID[6]}>6 - Dwarvish</option>\r\n <option value=\"7\" {$LanguageID[7]}>7 - Common</option>\r\n <option value=\"8\" {$LanguageID[8]}>8 - Demonic</option>\r\n <option value=\"9\" {$LanguageID[9]}>9 - Titan</option>\r\n <option value=\"10\" {$LanguageID[10]}>10 - Thelassian</option>\r\n <option value=\"11\" {$LanguageID[11]}>11 - Draconic</option>\r\n <option value=\"12\" {$LanguageID[12]}>12 - Kalimag</option>\r\n <option value=\"13\" {$LanguageID[13]}>13 - Gnomish</option>\r\n <option value=\"14\" {$LanguageID[14]}>14 - Troll</option>\r\n <option value=\"33\" {$LanguageID[33]}>33 - Gutterspeak</option>\r\n </select></td>";
unset($LanguageID);
$sheath = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 7 => "");
$sheath[$item['sheathid']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'sheath'), lang('item_edit', 'sheath_desc')) . "</td>\r\n <td colspan=\"2\"><select name=\"sheath\">\r\n <option value=\"0\" {$sheath[0]}>0 - " . lang('item_edit', 'other') . "</option>\r\n <option value=\"1\" {$sheath[1]}>1 - " . lang('item', 'sword_2h') . "</option>\r\n <option value=\"2\" {$sheath[2]}>2 - " . lang('item', 'staff') . "</option>\r\n <option value=\"3\" {$sheath[3]}>3 - " . lang('item', 'sword_1h') . "</option>\r\n <option value=\"4\" {$sheath[4]}>4 - " . lang('item', 'shield') . "</option>\r\n <option value=\"5\" {$sheath[5]}>5 - " . lang('item', 'rod') . "</option>\r\n <option value=\"7\" {$sheath[7]}>7 - " . lang('item', 'off_hand') . "</option>\r\n </select></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'totem_category'), lang('item_edit', 'totem_category_desc')) . "</td>\r\n <td><input type=\"text\" name=\"TotemCategory\" size=\"8\" maxlength=\"10\" value=\"{$item['TotemCategory']}\" /></td>\r\n </tr>\r\n\r\n </table><br /><br />\r\n </div>";
unset($sheath);
$output .= "<div id=\"pane3\">\r\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\r\n <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'stats') . ":</td></tr>\r\n <tr>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'stat_type') . " 1", lang('item_edit', 'stat_type_desc')) . "</td>\r\n <td><select name=\"stat_type1\">";
output_status_options($item['stat_type1']);
$output .= "</select></td>\r\n\r\n <td><input type=\"text\" name=\"stat_value1\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value1']}\" /></td>\r\n <td>" . makeinfocell(lang('item_edit', 'stat_type') . " 2", lang('item_edit', 'stat_type_desc')) . "</td>\r\n <td><select name=\"stat_type2\">";
output_status_options($item['stat_type2']);
$output .= "</select></td>\r\n\r\n <td><input type=\"text\" name=\"stat_value2\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value2']}\" /></td>\r\n </tr>\r\n <tr>\r\n <td>" . makeinfocell(lang('item_edit', 'stat_type') . " 3", lang('item_edit', 'stat_type_desc')) . "</td>\r\n <td><select name=\"stat_type3\">";
output_status_options($item['stat_type3']);
$output .= "</select></td>\r\n\r\n <td><input type=\"text\" name=\"stat_value3\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value3']}\" /></td>\r\n <td>" . makeinfocell(lang('item_edit', 'stat_type') . " 4", lang('item_edit', 'stat_type_desc')) . "</td>\r\n <td><select name=\"stat_type4\">";
output_status_options($item['stat_type4']);
$output .= "</select></td>\r\n\r\n <td><input type=\"text\" name=\"stat_value4\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value4']}\" /></td>\r\n </tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'stat_type') . " 5", lang('item_edit', 'stat_type_desc')) . "</td>\r\n <td><select name=\"stat_type5\">";
output_status_options($item['stat_type5']);
$output .= "</select></td>\r\n\r\n <td><input type=\"text\" name=\"stat_value5\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value5']}\" /></td>\r\n <td>" . makeinfocell(lang('item_edit', 'stat_type') . " 6", lang('item_edit', 'stat_type_desc')) . "</td>\r\n <td><select name=\"stat_type6\">";
output_status_options($item['stat_type1']);
$output .= "</select></td>\r\n\r\n <td><input type=\"text\" name=\"stat_value6\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value6']}\" /></td>\r\n </tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'stat_type') . " 7", lang('item_edit', 'stat_type_desc')) . "</td>\r\n <td><select name=\"stat_type7\">";
output_status_options($item['stat_type7']);
$output .= "</select></td>\r\n <td><input type=\"text\" name=\"stat_value7\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value7']}\" /></td>\r\n <td>" . makeinfocell(lang('item_edit', 'stat_type') . " 8", lang('item_edit', 'stat_type_desc')) . "</td>\r\n <td><select name=\"stat_type8\">";
output_status_options($item['stat_type8']);
$output .= "</select></td>\r\n\r\n <td><input type=\"text\" name=\"stat_value8\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value8']}\" /></td>\r\n </tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'stat_type') . " 9", lang('item_edit', 'stat_type_desc')) . "</td>\r\n <td><select name=\"stat_type9\">";
output_status_options($item['stat_type9']);
$output .= "</select></td>\r\n <td><input type=\"text\" name=\"stat_value9\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value9']}\" /></td>\r\n <td>" . makeinfocell(lang('item_edit', 'stat_type') . " 10", lang('item_edit', 'stat_type_desc')) . "</td>\r\n <td><select name=\"stat_type10\">";
output_status_options($item['stat_type10']);
$output .= "</select></td>\r\n\r\n <td><input type=\"text\" name=\"stat_value10\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value10']}\" /></td>\r\n </tr>\r\n\r\n <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'resis_armor') . ":</td></tr>\r\n <tr>\r\n <td colspan=\"2\">" . makeinfocell(lang('item', 'armor'), lang('item_edit', 'armor_desc')) . "</td>\r\n <td><input type=\"text\" name=\"armor\" size=\"10\" maxlength=\"30\" value=\"{$item['armor']}\" /></td>\r\n\r\n <td colspan=\"2\">" . makeinfocell(lang('item', 'block'), lang('item_edit', 'block_desc')) . "</td>\r\n <td><input type=\"text\" name=\"block\" size=\"10\" maxlength=\"30\" value=\"{$item['block']}\" /></td>\r\n </tr>\r\n <tr>\r\n <td colspan=\"2\">" . makeinfocell(lang('item', 'res_holy'), lang('item_edit', 'res_holy_desc')) . "</td>\r\n <td><input type=\"text\" name=\"holy_res\" size=\"10\" maxlength=\"30\" value=\"{$item['holy_res']}\" /></td>\r\n\r\n <td colspan=\"2\">" . makeinfocell(lang('item', 'res_fire'), lang('item_edit', 'res_fire_desc')) . "</td>\r\n <td><input type=\"text\" name=\"fire_res\" size=\"10\" maxlength=\"30\" value=\"{$item['fire_res']}\" /></td>\r\n </tr>\r\n <tr>\r\n <td colspan=\"2\">" . makeinfocell(lang('item', 'res_nature'), lang('item_edit', 'res_nature_desc')) . "</td>\r\n <td><input type=\"text\" name=\"nature_res\" size=\"10\" maxlength=\"30\" value=\"{$item['nature_res']}\" /></td>\r\n\r\n <td colspan=\"2\">" . makeinfocell(lang('item', 'res_frost'), lang('item_edit', 'res_frost_desc')) . "</td>\r\n <td><input type=\"text\" name=\"frost_res\" size=\"10\" maxlength=\"30\" value=\"{$item['frost_res']}\" /></td>\r\n </tr>\r\n <tr>\r\n <td colspan=\"2\">" . makeinfocell(lang('item', 'res_shadow'), lang('item_edit', 'res_shadow_desc')) . "</td>\r\n <td><input type=\"text\" name=\"shadow_res\" size=\"10\" maxlength=\"30\" value=\"{$item['shadow_res']}\" /></td>\r\n\r\n <td colspan=\"2\">" . makeinfocell(lang('item', 'res_arcane'), lang('item_edit', 'res_arcane_desc')) . "</td>\r\n <td><input type=\"text\" name=\"arcane_res\" size=\"10\" maxlength=\"30\" value=\"{$item['arcane_res']}\" /></td>\r\n </tr>\r\n\r\n </table><br /><br />\r\n </div>";
$output .= "<div id=\"pane4\">\r\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\r\n <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'weapon_properties') . ":</td></tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'delay'), lang('item_edit', 'delay_desc')) . "</td>\r\n <td colspan=\"2\"><input type=\"text\" name=\"delay\" size=\"10\" maxlength=\"11\" value=\"{$item['delay']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'ranged_mod'), lang('item_edit', 'ranged_mod_desc')) . "</td>\r\n <td colspan=\"2\"><input type=\"text\" name=\"RangedModRange\" size=\"10\" maxlength=\"40\" value=\"{$item['Range']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'armor_dmg_mod'), lang('item_edit', 'armor_dmg_mod_desc')) . "</td>\r\n <td colspan=\"2\"><input type=\"text\" name=\"ArmorDamageModifier\" size=\"10\" maxlength=\"40\" value=\"{$item['ArmorDamageModifier']}\" /></td>";
$ammo_type = array(0 => "", 2 => "", 3 => "");
$ammo_type[$item['ammo_type']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'ammo_type'), lang('item_edit', 'ammo_type_desc')) . "</td>\r\n <td colspan=\"2\"><select name=\"ammo_type\">\r\n <option value=\"0\" {$ammo_type[0]}>0 - " . lang('item', 'none') . "</option>\r\n <option value=\"2\" {$ammo_type[2]}>2 - " . lang('item', 'arrows') . "</option>\r\n <option value=\"3\" {$ammo_type[3]}>3 - " . lang('item', 'bullets') . "</option>\r\n </select></td>\r\n</tr>\r\n<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'weapon_damage') . ":</td></tr>\r\n<tr>";
unset($ammo_type);
$output .= "<td>" . makeinfocell(lang('item_edit', 'damage_type') . " 1", lang('item_edit', 'damage_type_desc')) . "</td>\r\n <td colspan=\"2\"><select name=\"dmg_type1\">";
output_dmgtype_options($item['dmg_type1']);
$output .= "</select></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'dmg_min_max'), lang('item_edit', 'dmg_min_max_desc')) . "</td>\r\n <td colspan=\"4\"><input type=\"text\" name=\"dmg_min1\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_min1']}\" /> - <input type=\"text\" name=\"dmg_max1\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_max1']}\" /></td>\r\n\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'damage_type') . " 2", lang('item_edit', 'damage_type_desc')) . "</td>\r\n <td colspan=\"2\"><select name=\"dmg_type2\">";
output_dmgtype_options($item['dmg_type2']);
$output .= "</select></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'dmg_min_max'), lang('item_edit', 'dmg_min_max_desc')) . "</td>\r\n <td colspan=\"4\"><input type=\"text\" name=\"dmg_min2\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_min2']}\" /> - <input type=\"text\" name=\"dmg_max2\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_max2']}\" /></td>\r\n\r\n</tr>\r\n</table><br /><br />\r\n </div>";
$output .= "<div id=\"pane5\">\r\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\r\n<tr>\r\n <td colspan=\"2\">" . lang('item_edit', 'item_spell') . " 1</td>\r\n <td>" . makeinfocell(lang('item_edit', 'spell_id'), lang('item_edit', 'spell_id_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellid_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_1']}\" /></td>";
$spelltrigger_1 = array(0 => "", 1 => "", 2 => "", 4 => "");
$spelltrigger_1[$item['spelltrigger_1']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'spell_trigger'), lang('item_edit', 'spell_trigger_desc')) . "</td>\r\n <td><select name=\"spelltrigger_1\">\r\n <option value=\"0\" {$spelltrigger_1[0]}>0: " . lang('item', 'spell_use') . "</option>\r\n <option value=\"1\" {$spelltrigger_1[1]}>1: " . lang('item', 'spell_equip') . "</option>\r\n <option value=\"2\" {$spelltrigger_1[2]}>2: " . lang('item', 'spell_coh') . "</option>\r\n <option value=\"4\" {$spelltrigger_1[4]}>4: " . lang('item', 'soul_stone') . "</option>\r\n </select></td>\r\n <td>" . makeinfocell(lang('item_edit', 'spell_charges'), lang('item_edit', 'spell_charges_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcharges_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_1']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'spell_cooldown'), lang('item_edit', 'spell_cooldown_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcooldown_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_1']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'spell_category'), lang('item_edit', 'spell_category_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcategory_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_1']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'spell_category_cooldown'), lang('item_edit', 'spell_category_cooldown_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcategorycooldown_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_1']}\" /></td>\r\n\r\n <td></td>\r\n <td></td>\r\n</tr>\r\n<tr><td colspan=\"6\" class=\"hidden\"></td></tr>\r\n<tr>\r\n <td colspan=\"2\">" . lang('item_edit', 'item_spell') . " 2</td>\r\n <td>" . makeinfocell(lang('item_edit', 'spell_id'), lang('item_edit', 'spell_id_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellid_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_2']}\" /></td>";
unset($spelltrigger_1);
$spelltrigger_2 = array(0 => "", 1 => "", 2 => "", 4 => "");
$spelltrigger_2[$item['spelltrigger_2']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'spell_trigger'), lang('item_edit', 'spell_trigger_desc')) . "</td>\r\n <td><select name=\"spelltrigger_2\">\r\n <option value=\"0\" {$spelltrigger_2[0]}>0: " . lang('item', 'spell_use') . "</option>\r\n <option value=\"1\" {$spelltrigger_2[1]}>1: " . lang('item', 'spell_equip') . "</option>\r\n <option value=\"2\" {$spelltrigger_2[2]}>2: " . lang('item', 'spell_coh') . "</option>\r\n <option value=\"4\" {$spelltrigger_2[4]}>4: " . lang('item', 'soul_stone') . "</option>\r\n </select></td>\r\n <td>" . makeinfocell(lang('item_edit', 'spell_charges'), lang('item_edit', 'spell_charges_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcharges_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_2']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'spell_cooldown'), lang('item_edit', 'spell_cooldown_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcooldown_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_2']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'spell_category'), lang('item_edit', 'spell_category_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcategory_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_2']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'spell_category_cooldown'), lang('item_edit', 'spell_category_cooldown_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcategorycooldown_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_2']}\" /></td>\r\n\r\n <td></td>\r\n <td></td>\r\n</tr>\r\n<tr><td colspan=\"6\" class=\"hidden\"></td></tr>\r\n<tr>\r\n <td colspan=\"2\">" . lang('item_edit', 'item_spell') . " 3</td>\r\n <td>" . makeinfocell(lang('item_edit', 'spell_id'), lang('item_edit', 'spell_id_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellid_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_3']}\" /></td>";
unset($spelltrigger_2);
$spelltrigger_3 = array(0 => "", 1 => "", 2 => "", 4 => "");
$spelltrigger_3[$item['spelltrigger_3']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'spell_trigger'), lang('item_edit', 'spell_trigger_desc')) . "</td>\r\n <td><select name=\"spelltrigger_3\">\r\n <option value=\"0\" {$spelltrigger_3[0]}>0: " . lang('item', 'spell_use') . "</option>\r\n <option value=\"1\" {$spelltrigger_3[1]}>1: " . lang('item', 'spell_equip') . "</option>\r\n <option value=\"2\" {$spelltrigger_3[2]}>2: " . lang('item', 'spell_coh') . "</option>\r\n <option value=\"4\" {$spelltrigger_3[4]}>4: " . lang('item', 'soul_stone') . "</option>\r\n </select></td>\r\n <td>" . makeinfocell(lang('item_edit', 'spell_charges'), lang('item_edit', 'spell_charges_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcharges_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_3']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'spell_cooldown'), lang('item_edit', 'spell_cooldown_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcooldown_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_3']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'spell_category'), lang('item_edit', 'spell_category_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcategory_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_3']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'spell_category_cooldown'), lang('item_edit', 'spell_category_cooldown_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcategorycooldown_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_3']}\" /></td>\r\n\r\n <td></td>\r\n <td></td>\r\n</tr>\r\n<tr><td colspan=\"6\" class=\"hidden\"></td></tr>\r\n<tr>\r\n <td colspan=\"2\">" . lang('item_edit', 'item_spell') . " 4</td>\r\n <td>" . makeinfocell(lang('item_edit', 'spell_id'), lang('item_edit', 'spell_id_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellid_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_4']}\" /></td>";
unset($spelltrigger_3);
$spelltrigger_4 = array(0 => "", 1 => "", 2 => "", 4 => "");
$spelltrigger_4[$item['spelltrigger_4']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'spell_trigger'), lang('item_edit', 'spell_trigger_desc')) . "</td>\r\n <td><select name=\"spelltrigger_4\">\r\n <option value=\"0\" {$spelltrigger_4[0]}>0: " . lang('item', 'spell_use') . "</option>\r\n <option value=\"1\" {$spelltrigger_4[1]}>1: " . lang('item', 'spell_equip') . "</option>\r\n <option value=\"2\" {$spelltrigger_4[2]}>2: " . lang('item', 'spell_coh') . "</option>\r\n <option value=\"4\" {$spelltrigger_4[4]}>4: " . lang('item', 'soul_stone') . "</option>\r\n </select></td>\r\n <td>" . makeinfocell(lang('item_edit', 'spell_charges'), lang('item_edit', 'spell_charges_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcharges_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_4']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'spell_cooldown'), lang('item_edit', 'spell_cooldown_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcooldown_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_4']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'spell_category'), lang('item_edit', 'spell_category_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcategory_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_4']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'spell_category_cooldown'), lang('item_edit', 'spell_category_cooldown_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcategorycooldown_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_4']}\" /></td>\r\n\r\n <td></td>\r\n <td></td>\r\n</tr>\r\n<tr><td colspan=\"6\" class=\"hidden\"></td></tr>\r\n<tr>\r\n <td colspan=\"2\">" . lang('item_edit', 'item_spell') . " 5</td>\r\n <td>" . makeinfocell(lang('item_edit', 'spell_id'), lang('item_edit', 'spell_id_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellid_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_5']}\" /></td>";
unset($spelltrigger_4);
$spelltrigger_5 = array(0 => "", 1 => "", 2 => "", 4 => "");
$spelltrigger_5[$item['spelltrigger_5']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'spell_trigger'), lang('item_edit', 'spell_trigger_desc')) . "</td>\r\n <td><select name=\"spelltrigger_5\">\r\n <option value=\"0\" {$spelltrigger_5[0]}>0: " . lang('item', 'spell_use') . "</option>\r\n <option value=\"1\" {$spelltrigger_5[1]}>1: " . lang('item', 'spell_equip') . "</option>\r\n <option value=\"2\" {$spelltrigger_5[2]}>2: " . lang('item', 'spell_coh') . "</option>\r\n <option value=\"4\" {$spelltrigger_5[4]}>4: " . lang('item', 'soul_stone') . "</option>\r\n </select></td>\r\n <td>" . makeinfocell(lang('item_edit', 'spell_charges'), lang('item_edit', 'spell_charges_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcharges_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_5']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'spell_cooldown'), lang('item_edit', 'spell_cooldown_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcooldown_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_5']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'spell_category'), lang('item_edit', 'spell_category_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcategory_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_5']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'spell_category_cooldown'), lang('item_edit', 'spell_category_cooldown_desc')) . "</td>\r\n <td><input type=\"text\" name=\"spellcategorycooldown_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_5']}\" /></td>\r\n\r\n <td></td>\r\n <td></td>\r\n</tr>\r\n\r\n</table>\r\n </div>";
unset($spelltrigger_5);
$output .= "<div id=\"pane6\">\r\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\r\n <tr>";
$AllowableClass = array(-1 => "", 1 => "", 2 => "", 4 => "", 8 => "", 16 => "", 32 => "", 64 => "", 128 => "", 256 => "", 512 => "", 1024 => "");
if ($item['AllowableClass'] == -1) {
$AllowableClass[-1] = " selected=\"selected\" ";
} else {
if ($item['AllowableClass'] & 1) {
$AllowableClass[1] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 2) {
$AllowableClass[2] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 4) {
$AllowableClass[4] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 8) {
$AllowableClass[8] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 16) {
$AllowableClass[16] = " selected=\"selected\" ";
}
//if ($item['AllowableClass'] & 32) $AllowableClass[32] = " selected=\"selected\" ";
if ($item['AllowableClass'] & 64) {
$AllowableClass[64] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 128) {
$AllowableClass[128] = " selected=\"selected\" ";
}
if ($item['AllowableClass'] & 256) {
$AllowableClass[256] = " selected=\"selected\" ";
}
//if ($item['AllowableClass'] & 512) $AllowableClass[512] = " selected=\"selected\" ";
if ($item['AllowableClass'] & 1024) {
$AllowableClass[1024] = " selected=\"selected\" ";
}
}
$output .= "<td>" . makeinfocell(lang('item_edit', 'allow_class'), lang('item_edit', 'allow_class_desc')) . "</td>\r\n <td><select multiple=\"multiple\" name=\"AllowableClass[]\" size=\"5\">\r\n <option value=\"-1\" {$AllowableClass[-1]}>-1 - " . lang('item_edit', 'all') . "</option>\r\n <option value=\"1\" {$AllowableClass[1]}>1 - " . lang('id_tab', 'warrior') . "</option>\r\n <option value=\"2\" {$AllowableClass[2]}>2 - " . lang('id_tab', 'paladin') . "</option>\r\n <option value=\"4\" {$AllowableClass[4]}>4 - " . lang('id_tab', 'hunter') . "</option>\r\n <option value=\"8\" {$AllowableClass[8]}>8 - " . lang('id_tab', 'rogue') . "</option>\r\n <option value=\"16\" {$AllowableClass[16]}>16 - " . lang('id_tab', 'priest') . "</option>\r\n <!-- option value=\"32\" {$AllowableClass[32]}>32 - FUTURE_1</option -->\r\n <option value=\"64\" {$AllowableClass[64]}>64 - " . lang('id_tab', 'shaman') . "</option>\r\n <option value=\"128\" {$AllowableClass[128]}>128 - " . lang('id_tab', 'mage') . "</option>\r\n <option value=\"256\" {$AllowableClass[256]}>256 - " . lang('id_tab', 'warlock') . "</option>\r\n <!-- option value=\"512\" {$AllowableClass[512]}>512 - FUTURE_2</option -->\r\n <option value=\"1024\" {$AllowableClass[1024]}>1024 - " . lang('id_tab', 'druid') . "</option>\r\n </select></td>";
unset($AllowableClass);
$AllowableRace = array(-1 => "", 1 => "", 2 => "", 4 => "", 8 => "", 16 => "", 32 => "", 64 => "", 128 => "", 256 => "", 512 => "");
if ($item['AllowableRace'] == -1) {
$AllowableRace[-1] = " selected=\"selected\" ";
} else {
if ($item['AllowableRace'] & 1) {
$AllowableRace[1] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 2) {
$AllowableRace[2] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 4) {
$AllowableRace[4] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 8) {
$AllowableRace[8] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 16) {
$AllowableRace[16] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 32) {
$AllowableRace[32] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 64) {
$AllowableRace[64] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 128) {
$AllowableRace[128] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 256) {
$AllowableRace[256] = " selected=\"selected\" ";
}
if ($item['AllowableRace'] & 512) {
$AllowableRace[512] = " selected=\"selected\" ";
}
}
$output .= "<td>" . makeinfocell(lang('item_edit', 'allow_race'), lang('item_edit', 'allow_race_desc')) . "</td>\r\n <td><select multiple=\"multiple\" name=\"AllowableRace[]\" size=\"5\">\r\n <option value=\"-1\" {$AllowableRace[-1]}>-1 - " . lang('item_edit', 'all') . "</option>\r\n <option value=\"1\" {$AllowableRace[1]}>1 - " . lang('id_tab', 'human') . "</option>\r\n <option value=\"2\" {$AllowableRace[2]}>2 - " . lang('id_tab', 'orc') . "</option>\r\n <option value=\"4\" {$AllowableRace[4]}>4 - " . lang('id_tab', 'dwarf') . "</option>\r\n <option value=\"8\" {$AllowableRace[8]}>8 - " . lang('id_tab', 'nightelf') . "</option>\r\n <option value=\"16\" {$AllowableRace[16]}>16 - " . lang('id_tab', 'undead') . "</option>\r\n <option value=\"32\" {$AllowableRace[32]}>32 - " . lang('id_tab', 'tauren') . "</option>\r\n <option value=\"64\" {$AllowableRace[64]}>64 - " . lang('id_tab', 'gnome') . "</option>\r\n <option value=\"128\" {$AllowableRace[128]}>128 - " . lang('id_tab', 'troll') . "</option>\r\n <option value=\"256\" {$AllowableRace[256]}>256 - " . lang('id_tab', 'draenei') . "</option>\r\n <option value=\"512\" {$AllowableRace[512]}>512 - " . lang('id_tab', 'bloodelf') . "</option>\r\n </select></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'req_skill'), lang('item_edit', 'req_skill_desc')) . "</td>\r\n <td><input type=\"text\" name=\"RequiredSkill\" size=\"15\" maxlength=\"30\" value=\"{$item['RequiredSkill']}\" /></td>\r\n\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'req_skill_rank'), lang('item_edit', 'req_skill_rank_desc')) . "</td>\r\n <td><input type=\"text\" name=\"RequiredSkillRank\" size=\"15\" maxlength=\"30\" value=\"{$item['RequiredSkillRank']}\" /></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'req_spell'), lang('item_edit', 'req_spell_desc')) . "</td>\r\n <td><input type=\"text\" name=\"requiredspell\" size=\"15\" maxlength=\"30\" value=\"{$item['requiredspell']}\" /></td>\r\n\r\n <td></td>\r\n <td></td>\r\n</tr>\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'req_rep_faction'), lang('item_edit', 'req_rep_faction_desc')) . "</td>\r\n <td><input type=\"text\" name=\"RequiredReputationFaction\" size=\"15\" maxlength=\"30\" value=\"{$item['RequiredFaction']}\" /></td>";
unset($AllowableRace);
$RequiredReputationRank = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "");
$RequiredReputationRank[$item['RequiredFactionStanding']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'req_rep_rank'), lang('item_edit', 'req_rep_rank_desc')) . "</td>\r\n <td><select name=\"RequiredReputationRank\">\r\n <option value=\"0\" {$RequiredReputationRank[0]}>0 - " . lang('item_edit', 'hated') . "</option>\r\n <option value=\"1\" {$RequiredReputationRank[1]}>1 - " . lang('item_edit', 'hostile') . "</option>\r\n <option value=\"2\" {$RequiredReputationRank[2]}>2 - " . lang('item_edit', 'unfriendly') . "</option>\r\n <option value=\"3\" {$RequiredReputationRank[3]}>3 - " . lang('item_edit', 'neutral') . "</option>\r\n <option value=\"4\" {$RequiredReputationRank[4]}>4 - " . lang('item_edit', 'friendly') . "</option>\r\n <option value=\"5\" {$RequiredReputationRank[5]}>5 - " . lang('item_edit', 'honored') . "</option>\r\n <option value=\"6\" {$RequiredReputationRank[6]}>6 - " . lang('item_edit', 'reverted') . "</option>\r\n <option value=\"7\" {$RequiredReputationRank[7]}>7 - " . lang('item_edit', 'exalted') . "</option>\r\n </select></td>\r\n</tr>\r\n\r\n </table><br /><br />\r\n </div>";
unset($RequiredReputationRank);
$output .= "<div id=\"pane7\">\r\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\r\n<tr>";
$socketColor_1 = array(0 => "", 1 => "", 2 => "", 4 => "", 8 => "");
$socketColor_1[$item['socket_Color_1']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'socket_color') . " 1", lang('item_edit', 'socket_color_desc')) . "</td>\r\n <td><select name=\"socketColor_1\">\r\n <option value=\"0\" {$socketColor_1[0]}>0: " . lang('item', 'none') . "</option>\r\n <option value=\"1\" {$socketColor_1[1]}>1: " . lang('item', 'socket_meta') . "</option>\r\n <option value=\"2\" {$socketColor_1[2]}>2: " . lang('item', 'socket_red') . "</option>\r\n <option value=\"4\" {$socketColor_1[4]}>4: " . lang('item', 'socket_yellow') . "</option>\r\n <option value=\"8\" {$socketColor_1[8]}>8: " . lang('item', 'socket_blue') . "</option>\r\n </select></td>\r\n <td></td>\r\n <td></td>\r\n</tr>\r\n<tr>";
unset($socketColor_1);
$socketColor_2 = array(0 => "", 1 => "", 2 => "", 4 => "", 8 => "");
$socketColor_2[$item['socket_Color_2']] = " selected=\"selected\" ";
$output .= "<td>" . makeinfocell(lang('item_edit', 'socket_color') . " 2", lang('item_edit', 'socket_color_desc')) . "</td>\r\n <td><select name=\"socketColor_2\">\r\n <option value=\"0\" {$socketColor_2[0]}>0: " . lang('item', 'none') . "</option>\r\n <option value=\"1\" {$socketColor_2[1]}>1: " . lang('item', 'socket_meta') . "</option>\r\n <option value=\"2\" {$socketColor_2[2]}>2: " . lang('item', 'socket_red') . "</option>\r\n <option value=\"4\" {$socketColor_2[4]}>4: " . lang('item', 'socket_yellow') . "</option>\r\n <option value=\"8\" {$socketColor_2[8]}>8: " . lang('item', 'socket_blue') . "</option>\r\n </select></td>\r\n\r\n <td></td>\r\n <td></td>\r\n</tr>\r\n<tr>";
unset($socketColor_2);
$socketColor_3 = array(0 => "", 1 => "", 2 => "", 4 => "", 8 => "");
$socketColor_3[$item['socket_Color_3']] = " selected=\"selected\" ";
// this_is_junk: socket bonus comes from SpellItemEnchantment.dbc... to display it correctly we need that dbc in the CoreManager DB.
// gem properties does it too.
$output .= "<td>" . makeinfocell(lang('item_edit', 'socket_color') . " 3", lang('item_edit', 'socket_color_desc')) . "</td>\r\n <td><select name=\"socketColor_3\">\r\n <option value=\"0\" {$socketColor_3[0]}>0: " . lang('item', 'none') . "</option>\r\n <option value=\"1\" {$socketColor_3[1]}>1: " . lang('item', 'socket_meta') . "</option>\r\n <option value=\"2\" {$socketColor_3[2]}>2: " . lang('item', 'socket_red') . "</option>\r\n <option value=\"4\" {$socketColor_3[4]}>4: " . lang('item', 'socket_yellow') . "</option>\r\n <option value=\"8\" {$socketColor_3[8]}>8: " . lang('item', 'socket_blue') . "</option>\r\n </select></td>\r\n\r\n <td></td>\r\n <td></td>\r\n</tr>\r\n\r\n<tr>\r\n <td>" . makeinfocell(lang('item_edit', 'socket_bonus'), lang('item_edit', 'socket_bonus_desc')) . "</td>\r\n <td><input type=\"text\" name=\"socketBonus\" size=\"15\" maxlength=\"10\" value=\"{$item['socket_Bonus']}\" /></td>\r\n\r\n <td>" . makeinfocell(lang('item_edit', 'gem_properties'), lang('item_edit', 'gem_properties_desc')) . "</td>\r\n <td><input type=\"text\" name=\"GemProperties\" size=\"15\" maxlength=\"10\" value=\"{$item['GemProperties']}\" /></td>\r\n</tr>\r\n\r\n </table><br /><br />\r\n </div>";
$output .= "<div id=\"pane8\">\r\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">";
// DROPPED BY
// this_is_junk: ArcEmu doesn't have a field to match groupid
$result2 = $sqlw->query("SELECT entryid,normal10percentchance,normal25percentchance,heroic10percentchance,heroic25percentchance FROM loot_creatures WHERE itemid = {$item['entry']} ORDER BY normal10percentchance DESC");
if ($sqlw->num_rows($result2)) {
$output .= "<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'dropped_by') . ": " . lang('item_edit', 'top_x') . "</td></tr>";
$output .= "<tr>\r\n <th width=\"1%\">ID</th>\r\n <th width=\"35%\">" . lang('item_edit', 'mob_name') . "</th>\r\n <th width=\"10%\">" . lang('item_edit', 'mob_minlevel') . "</th>\r\n <th width=\"10%\">" . lang('item_edit', 'mob_maxlevel') . "</th>\r\n <th width=\"6%\">" . lang('item_edit', 'norm10_drop_chance') . "</th>\r\n <th width=\"6%\">" . lang('item_edit', 'norm25_drop_chance') . "</th>\r\n <th width=\"6%\">" . lang('item_edit', 'hero10_drop_chance') . "</th>\r\n <th width=\"7%\">" . lang('item_edit', 'hero25_drop_chance') . "</th>\r\n </tr>";
while ($info = $sqlw->fetch_assoc($result2)) {
//$result3 = $sql->query("SELECT creature_names.entry,IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`creature_names`.`name`) as name FROM creature_names LEFT JOIN creature_names_localized ON creature_names.entry = creature_names_localized.id LEFT JOIN loot_creatures ON creature_names.entry = loot_creatures.entryid WHERE itemid = {$info[0]} LIMIT 1");
$result3 = $sqlw->query("SELECT creature_names.entry,`name`,creature_proto.minlevel,creature_proto.maxlevel FROM creature_names LEFT JOIN creature_proto ON creature_names.entry = creature_proto.entry WHERE creature_names.entry = " . $info['entryid'] . " LIMIT 1");
while ($mob = $sqlw->fetch_assoc($result3)) {
$output .= "<tr><td>";
if ($user_lvl >= $action_permission['delete']) {
$output .= "<a class=\"tooltip\" href=\"creature.php?action=edit&entry=" . $mob['entry'] . "&error=4\" target=\"_blank\">" . $mob['entry'] . "</a>";
} else {
$output .= $mob['entry'];
}
$output .= "</td>\r\n <td><a class=\"tooltip\" href=\"{$creature_datasite}" . $mob['entry'] . " target=\"_blank\">" . $mob['name'] . "</a></td>\r\n <td>" . $mob['minlevel'] . "</td>\r\n <td>" . $mob['maxlevel'] . "</td>\r\n <td>" . $info['normal10percentchance'] . "%</td>\r\n <td>" . $info['normal25percentchance'] . "%</td>\r\n <td>" . $info['heroic10percentchance'] . "%</td>\r\n <td>" . $info['heroic25percentchance'] . "%</td>";
}
}
}
// SOLD BY
//$result2 = $sql->query("SELECT creature_names.entry,IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`creature_names`.`name`) as name FROM creature_names LEFT JOIN creature_names_localized ON creature_names.entry = creature_names_localized.id WHERE creature_names.entry IN (SELECT entry FROM vendors WHERE item = {$item['entry']}) LIMIT 5");
$result2 = $sqlw->query("SELECT creature_names.entry,`creature_names`.`name` FROM creature_names LEFT JOIN creature_names_localized ON creature_names.entry = creature_names_localized.id WHERE creature_names.entry IN (SELECT entry FROM vendors WHERE item = {$item['entry']})");
if ($sqlw->num_rows($result2)) {
$output .= "<tr class=\"large_bold\"><td colspan=\"9\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'sold_by') . "</td></tr>";
$output .= "<tr>\r\n <th width=\"1%\">ID</th>\r\n <th width=\"80%\" align=\"left\">" . lang('item_edit', 'mob_name') . "</th>\r\n </tr>";
while ($mob = $sqlw->fetch_row($result2)) {
$output .= "<tr>\r\n <td width=\"10%\">";
if ($user_lvl >= $action_permission['delete']) {
$output .= "<a class=\"tooltip\" href=\"creature.php?action=edit&entry={$mob['0']}&error=4\" target=\"_blank\">{$mob['0']}</a>";
} else {
$output .= "{$mob['0']}";
}
$output .= "\r\n \r\n <td width=\"80%\" colspan=\"8\" align=\"left\">\r\n <a class=\"tooltip\" href=\"{$creature_datasite}{$mob['0']}\" target=\"_blank\">{$mob['1']}</a></td>\r\n </td></tr>";
}
}
// QUEST ITEM
//$result2 = $sql->query("SELECT quests.entry,IFNULL(".($deplang<>0?"title_loc$deplang":"NULL").",`quests`.`title`) as title,QuestLevel FROM quests LEFT JOIN quests_localized ON quests.entry = quests_localized.entry WHERE ( SrcItem = {$item['entry']} OR ReqItemId1 = {$item['entry']} OR
$result2 = $sqlw->query("SELECT quests.entry,`quests`.`title`,QuestLevel FROM quests LEFT JOIN quests_localized ON quests.entry = quests_localized.entry WHERE ( SrcItem = {$item['entry']} OR ReqItemId1 = {$item['entry']} OR\r\n ReqItemId2 = {$item['entry']} OR ReqItemId3 = {$item['entry']} OR ReqItemId4 = {$item['entry']} ) ORDER BY QuestLevel DESC");
if ($sqlw->num_rows($result2)) {
$output .= "<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'involved_in_quests') . ":</td></tr>";
$output .= "<tr>\r\n <th width=\"1%\">ID</th>\r\n <th width=\"80%\">" . lang('item_edit', 'mob_name') . "</th>\r\n </tr>";
while ($quest = $sqlw->fetch_row($result2)) {
$output .= "<tr><td width=\"20%\">id: {$quest['0']}</td>\r\n <td width=\"80%\" colspan=\"6\" align=\"left\"><a class=\"tooltip\" href=\"{$quest_datasite}{$quest['0']}\" target=\"_blank\">({$quest['2']}) {$quest['1']}</a></td><td></td></tr>";
}
}
// QUEST REWARD
$result2 = $sqlw->query("SELECT quests.entry,IFNULL(" . ($deplang != 0 ? "title_loc{$deplang}" : "NULL") . ",`quests`.`title`) as title,QuestLevel FROM quests LEFT JOIN quests_localized ON quests.entry = quests_localized.entry WHERE ( RewChoiceItemId1 = {$item['entry']} OR RewChoiceItemId2 = {$item['entry']} OR\r\n RewChoiceItemId3 = {$item['entry']} OR RewChoiceItemId4 = {$item['entry']} OR RewChoiceItemId5 = {$item['entry']} OR RewChoiceItemId6 = {$item['entry']} OR RewItemId1 = {$item['entry']} OR\r\n RewItemId2 = {$item['entry']} OR RewItemId3 = {$item['entry']} OR RewItemId4 = {$item['entry']} )\r\n ORDER BY QuestLevel DESC");
if ($sqlw->num_rows($result2)) {
$output .= "<tr class=\"large_bold\"><td colspan=\"9\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'reward_from_quest') . ":</td></tr>";
while ($quest = $sqlw->fetch_row($result2)) {
$output .= "<tr><td width=\"20%\">id: {$quest['0']}</td>\r\n <td width=\"80%\" colspan=\"7\" align=\"left\"><a class=\"tooltip\" href=\"{$quest_datasite}{$quest['0']}\" target=\"_blank\">({$quest['2']}) {$quest['1']}</a></td></tr>";
}
}
$output .= "</tr></table><br /><br />\r\n </div>";
if ($item['DisenchantID']) {
$output .= "<div id=\"pane9\">\r\n <br /><br /><table class=\"lined\" style=\"width: 720px;\">\r\n <tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'disenchant_templ') . ": {$item['DisenchantID']}</td></tr>\r\n <tr><td colspan=\"6\">";
$cel_counter = 0;
$row_flag = 0;
$output .= "<table class=\"hidden\" align=\"center\"><tr>";
$result1 = $sqlw->query("SELECT item,ChanceOrQuestChance,`groupid`,mincountOrRef,maxcount,lootcondition,condition_value1, condition_value2 FROM disenchant_loot_template WHERE entry = {$item['DisenchantID']} ORDER BY ChanceOrQuestChance DESC");
while ($item = $sqlw->fetch_row($result1)) {
$cel_counter++;
$tooltip = get_item_name($item[0]) . " ({$item['0']})<br />" . lang('item_edit', 'drop_chance') . ": {$item['1']}%<br />" . lang('item_edit', 'quest_drop_chance') . ": {$item['2']}%<br />" . lang('item_edit', 'drop_chance') . ": {$item['3']}-{$item['4']}<br />" . lang('item_edit', 'lootcondition') . ": {$item['5']}<br />" . lang('item_edit', 'condition_value1') . ": {$item['6']}<br />" . lang('item_edit', 'condition_value2') . ": {$item['7']}";
$output .= "<td>";
$output .= maketooltip("<img src=\"" . get_item_icon($item[0]) . "\" class=\"icon_border\" alt=\"\" />", "{$item_datasite}{$item['0']}", $tooltip, "item_tooltip");
$output .= "<br /><input type=\"checkbox\" name=\"del_de_items[]\" value=\"{$item['0']}\" /></td>";
if ($cel_counter >= 16) {
$cel_counter = 0;
$output .= "</tr><tr>";
$row_flag++;
}
}
if ($row_flag) {
$output .= "<td colspan=\"" . (16 - $cel_counter) . "\"></td>";
}
$output .= "</td></tr></table>\r\n </td>\r\n</tr>\r\n<tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">" . lang('item_edit', 'add_items_to_templ') . ":</td></tr>\r\n<tr>\r\n<td>" . makeinfocell(lang('item_edit', 'loot_item_id'), lang('item_edit', 'loot_item_id_desc')) . "</td>\r\n <td><input type=\"text\" name=\"de_item\" size=\"8\" maxlength=\"10\" value=\"\" /></td>\r\n<td>" . makeinfocell(lang('item_edit', 'loot_drop_chance'), lang('item_edit', 'loot_drop_chance_desc')) . "</td>\r\n <td><input type=\"text\" name=\"de_ChanceOrQuestChance\" size=\"8\" maxlength=\"11\" value=\"0\" /></td>\r\n<td>" . makeinfocell(lang('item_edit', 'loot_quest_drop_chance'), lang('item_edit', 'loot_quest_drop_chance_desc')) . "</td>\r\n <td><input type=\"text\" name=\"de_groupid\" size=\"8\" maxlength=\"10\" value=\"0\" /></td>\r\n</tr>\r\n<tr>\r\n<td>" . makeinfocell(lang('item_edit', 'min_count'), lang('item_edit', 'min_count_desc')) . "</td>\r\n <td><input type=\"text\" name=\"de_mincountOrRef\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>\r\n<td>" . makeinfocell(lang('item_edit', 'max_count'), lang('item_edit', 'max_count_desc')) . "</td>\r\n <td><input type=\"text\" name=\"de_maxcount\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>\r\n</tr>\r\n<tr>\r\n<td>" . makeinfocell(lang('item_edit', 'lootcondition'), lang('item_edit', 'lootcondition_desc')) . "</td>\r\n <td><input type=\"text\" name=\"de_lootcondition\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>\r\n<td>" . makeinfocell(lang('item_edit', 'condition_value1'), lang('item_edit', 'condition_value1_desc')) . "</td>\r\n <td><input type=\"text\" name=\"de_condition_value1\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>\r\n<td>" . makeinfocell(lang('item_edit', 'condition_value2'), lang('item_edit', 'condition_value2_desc')) . "</td>\r\n <td><input type=\"text\" name=\"de_condition_value2\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>\r\n</tr>\r\n</table>\r\n</div>";
}
$output .= "</div>\r\n</div>\r\n<br />\r\n</form>\r\n\r\n<script type=\"text/javascript\">setupPanes(\"container\", \"tab1\")</script>";
unset($socketColor_3);
$output .= "\r\n <table class=\"hidden\">\r\n <tr>\r\n <td>";
if ($user_lvl >= $action_permission['delete']) {
makebutton(lang('item_edit', 'del_item'), "item.php?action=delete&entry={$entry}\" type=\"wrn", 180);
}
$output .= "\r\n </td>\r\n <td>";
if ($user_lvl >= $action_permission['update']) {
makebutton(lang('item_edit', 'update'), "javascript:do_submit('form1',0)\" type=\"wrn", 180);
}
$output .= "\r\n </td>\r\n <td>";
if ($user_lvl >= $action_permission['insert']) {
makebutton(lang('item_edit', 'export_sql'), "javascript:do_submit('form1',1)", 180);
}
$output .= "\r\n </td></tr><tr>\r\n <td>";
makebutton(lang('global', 'back'), "javascript:window.history.back()", 130);
$output .= "\r\n </td>\r\n <td>";
makebutton(lang('item_edit', 'new_search'), "item.php", 130);
$output .= "\r\n </td>\r\n </tr>\r\n </table>\r\n </center>\r\n";
} else {
error(lang('item_edit', 'item_not_found'));
exit;
}
}
