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; } }