$text"; } function output_status_options($stat_type_offset) { global $lang_item, $output; $stat_type = array( 0 => "", 1 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "",12 => "", 13 => "",14 => "",15 => "",16 => "",17 => "",18 => "",19 => "",20 => "",21 => "",22 => "", 23 => "",24 => "",25 => "",26 => "",27 => "",28 => "",29 => "",30 => "",31 => "",32 => "", 33 => "",34 => "",35 => "",36 => ""); if (!$stat_type_offset) $stat_type_offset = 0; $stat_type[$stat_type_offset] = " selected=\"selected\" "; $output .= " "; return; } function output_dmgtype_options($dmg_type_offset) { global $lang_item, $output; $dmg_type = array( 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => ""); if (!$dmg_type_offset) $dmg_type_offset = 0; $dmg_type[$dmg_type_offset] = " selected=\"selected\" "; $output .= " "; return; } //######################################################################################################################## // PRINT ITEM SEARCH FORM //######################################################################################################################## function search() { global $lang_global, $lang_item, $lang_item_edit, $output, $mmfpm_db, $world_db, $realm_id, $action_permission, $user_lvl; valid_login($action_permission['read']); $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']); $sqlm = new SQL; $sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']); $result = $sqlw->query("SELECT count(*) FROM item_template"); $tot_items = $sqlw->result($result, 0); $output .= "
{$lang_item_edit['search_item']}
{$lang_item_edit['entry']}: {$lang_item_edit['item_name']}: {$lang_item_edit['model_id']}:
{$lang_item_edit['class']}: {$lang_item_edit['quality']}: {$lang_item_edit['inv_type']}: {$lang_item_edit['req_level']}:
{$lang_item_edit['spell_id']} 1: {$lang_item_edit['spell_id']} 2: {$lang_item_edit['spell_id']} 3: {$lang_item_edit['spell_id']} 4:
{$lang_item_edit['item_level']}: {$lang_item_edit['item_set']}: {$lang_item_edit['flags']}:
{$lang_item_edit['bonding']}: {$lang_item_edit['custom_search']}:
-----------------------------------------------------------------------------------------------------------------------------------------------
"; if($user_lvl >= $action_permission['insert']) makebutton($lang_item_edit['add_new_item'], "item.php?action=add_new&error=3",130); makebutton($lang_item_edit['search'], "javascript:do_submit()",130); $output .= " {$lang_item_edit['tot_items_in_db']}: $tot_items


"; } //######################################################################################################################## // SHOW SEARCH RESULTS //######################################################################################################################## function do_search() { global $lang_global, $lang_item, $lang_item_edit, $output, $world_db, $realm_id, $item_datasite, $sql_search_limit, $itemperpage, $action_permission, $user_lvl; valid_login($action_permission['read']); wowhead_tt(); $deplang = get_lang_id(); if(($_POST['class'] == "-1")&&($_POST['Quality'] == "-1")&&($_POST['InventoryType'] == "-1")&&($_POST['bonding'] == "-1") &&(!isset($_POST['entry'])||$_POST['entry'] === '')&&(!isset($_POST['name'])||$_POST['name'] === '')&&(!isset($_POST['displayid'])||$_POST['displayid'] === '')&&(!isset($_POST['RequiredLevel'])||$_POST['RequiredLevel'] === '') &&(!isset($_POST['spellid_1'])||$_POST['spellid_1'] === '')&&(!isset($_POST['spellid_2'])||$_POST['spellid_2'] === '')&&(!isset($_POST['spellid_3'])||$_POST['spellid_3'] === '')&&(!isset($_POST['spellid_4'])||$_POST['spellid_4'] === '') &&(!isset($_POST['ItemLevel'])||$_POST['ItemLevel'] === '')&&(!isset($_POST['itemset'])||$_POST['itemset'] === '')&&(!isset($_POST['Flags'])||$_POST['Flags'] === '') &&(!isset($_POST['custom_search'])||$_POST['custom_search'] === '')) redirect("item.php?error=1"); $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']); $class = $sqlw->quote_smart($_POST['class']); $Quality = $sqlw->quote_smart($_POST['Quality']); $InventoryType = $sqlw->quote_smart($_POST['InventoryType']); $bonding = $sqlw->quote_smart($_POST['bonding']); if ($_POST['entry'] != '') $entry = $sqlw->quote_smart($_POST['entry']); if ($_POST['name'] != '') $name = $sqlw->quote_smart($_POST['name']); if ($_POST['displayid'] != '') $displayid = $sqlw->quote_smart($_POST['displayid']); if ($_POST['RequiredLevel'] != '') $RequiredLevel = $sqlw->quote_smart($_POST['RequiredLevel']); if ($_POST['spellid_1'] != '') $spellid_1 = $sqlw->quote_smart($_POST['spellid_1']); if ($_POST['spellid_2'] != '') $spellid_2 = $sqlw->quote_smart($_POST['spellid_2']); if ($_POST['spellid_3'] != '') $spellid_3 = $sqlw->quote_smart($_POST['spellid_3']); if ($_POST['spellid_4'] != '') $spellid_4 = $sqlw->quote_smart($_POST['spellid_4']); if ($_POST['ItemLevel'] != '') $ItemLevel = $sqlw->quote_smart($_POST['ItemLevel']); if ($_POST['itemset'] != '') $itemset = $sqlw->quote_smart($_POST['itemset']); if ($_POST['Flags'] != '') $Flags = $sqlw->quote_smart($_POST['Flags']); if ($_POST['custom_search'] != '') $custom_search = $sqlw->quote_smart($_POST['custom_search']); else $custom_search = ""; $where = "WHERE item_template.entry > 0 "; if($custom_search) $where .= "AND $custom_search "; if($class != "-1") $where .= "AND class = '$class' "; if($Quality != "-1") $where .= "AND Quality = '$Quality' "; if($InventoryType != "-1") $where .= "AND InventoryType = '$InventoryType' "; if($bonding != "-1") $where .= "AND bonding = '$bonding' "; if(isset($entry)) $where .= "AND item_template.entry = '$entry' "; if(isset($name)) $where .= "AND IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) LIKE '%$name%' "; if(isset($displayid)) $where .= "AND displayid = '$displayid' "; if(isset($RequiredLevel)) $where .= "AND RequiredLevel = '$RequiredLevel' "; if(isset($spellid_1)) $where .= "AND (spellid_1 = '$spellid_1' OR spellid_2 = '$spellid_1' OR spellid_3 = '$spellid_1' OR spellid_4 = '$spellid_1' OR spellid_5 = '$spellid_1') "; if(isset($spellid_2)) $where .= "AND (spellid_1 = '$spellid_2' OR spellid_2 = '$spellid_2' OR spellid_3 = '$spellid_2' OR spellid_4 = '$spellid_2' OR spellid_5 = '$spellid_2') "; if(isset($spellid_3)) $where .= "AND (spellid_1 = '$spellid_3' OR spellid_2 = '$spellid_3' OR spellid_3 = '$spellid_3' OR spellid_4 = '$spellid_3' OR spellid_5 = '$spellid_3') "; if(isset($spellid_4)) $where .= "AND (spellid_1 = '$spellid_4' OR spellid_2 = '$spellid_4' OR spellid_3 = '$spellid_4' OR spellid_4 = '$spellid_4' OR spellid_5 = '$spellid_4') "; if(isset($ItemLevel)) $where .= "AND ItemLevel = '$ItemLevel' "; if(isset($itemset)) $where .= "AND itemset = '$itemset' "; if(isset($Flags)) $where .= "AND Flags = '$Flags' "; if($where == "WHERE item_template.entry > 0 ") redirect("item.php?error=1"); $result = $sqlw->query("SELECT item_template.entry,displayid,IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) as name,RequiredLevel,ItemLevel FROM item_template LEFT JOIN locales_item ON item_template.entry = locales_item.entry $where ORDER BY item_template.entry LIMIT $sql_search_limit"); $total_items_found = $sqlw->num_rows($result); $output .= "
"; makebutton($lang_item_edit['new_search'], "item.php",130); $output .= " {$lang_item_edit['items_found']} : $total_items_found : {$lang_global['limit']} $sql_search_limit
"; for ($i=0; $i<$total_items_found; $i++) { $item = $sqlw->fetch_row($result); //$tooltip = get_item_tooltip($item[0]); $output .= " "; } $output .= "
{$lang_item_edit['entry']} {$lang_item_edit['display_id']} {$lang_item_edit['item_name']} {$lang_item_edit['req_level']} {$lang_item_edit['item_level']}
$item[0] \"\" ".htmlentities($item[2])." $item[3] $item[4]

"; } //######################################################################################################################## // ADD NEW ITEM //######################################################################################################################## function add_new() { global $lang_global, $lang_item, $lang_id_tab, $lang_item_edit, $output, $item_datasite, $action_permission, $user_lvl; valid_login($action_permission['insert']); wowhead_tt(); $output .= "



"; $output .= "


{$lang_item_edit['general']}:
".makeinfocell($lang_item_edit['entry'],$lang_item_edit['entry_desc'])." ".makeinfocell($lang_item_edit['display_id'],$lang_item_edit['display_id_desc'])." ".makeinfocell($lang_item_edit['req_level'],$lang_item_edit['req_level_desc'])." ".makeinfocell($lang_item_edit['item_level'],$lang_item_edit['item_level_desc'])."
{$lang_item_edit['names']}:
".makeinfocell($lang_item_edit['item_name'],$lang_item_edit['item_name_desc'])." ".makeinfocell($lang_item_edit['script_name'],$lang_item_edit['script_name_desc'])."
".makeinfocell($lang_item_edit['description'],$lang_item_edit['description_desc'])."
{$lang_item_edit['type']}:
".makeinfocell($lang_item_edit['class'],$lang_item_edit['class_desc'])." ".makeinfocell($lang_item_edit['subclass'],$lang_item_edit['subclass_desc'])."
".makeinfocell($lang_item_edit['quality'],$lang_item_edit['quality_desc'])." ".makeinfocell($lang_item_edit['inv_type'],$lang_item_edit['inv_type_desc'])." ".makeinfocell($lang_item_edit['flags'],$lang_item_edit['flags_desc'])."
".makeinfocell($lang_item_edit['item_set'],$lang_item_edit['item_set_desc'])." ".makeinfocell($lang_item_edit['bonding'],$lang_item_edit['bonding_desc'])." ".makeinfocell($lang_item_edit['start_quest'],$lang_item_edit['start_quest_desc'])."

{$lang_item_edit['short_rules_desc']}

"; $output .= "


{$lang_item_edit['vendor']}:
".makeinfocell($lang_item_edit['buy_count'],$lang_item_edit['buy_count_desc'])." ".makeinfocell($lang_item_edit['buy_price'],$lang_item_edit['buy_price_desc'])." ".makeinfocell($lang_item_edit['sell_price'],$lang_item_edit['sell_price_desc'])."
{$lang_item_edit['container']}:
".makeinfocell($lang_item_edit['max_count'],$lang_item_edit['max_count_desc'])." ".makeinfocell($lang_item_edit['stackable'],$lang_item_edit['stackable_desc'])." ".makeinfocell($lang_item_edit['bag_family'],$lang_item_edit['bag_family_desc'])." ".makeinfocell($lang_item_edit['bag_slots'],$lang_item_edit['bag_slots_desc'])."
{$lang_item_edit['materials']}:
".makeinfocell($lang_item_edit['material'],$lang_item_edit['material_desc'])." ".makeinfocell($lang_item_edit['page_material'],$lang_item_edit['page_material_desc'])." ".makeinfocell($lang_item_edit['max_durability'],$lang_item_edit['max_durability_desc'])."
{$lang_item_edit['RandomProperty']}:
".makeinfocell($lang_item_edit['RandomProperty'],$lang_item_edit['RandomProperty_desc'])." ".makeinfocell($lang_item_edit['RandomSuffix'],$lang_item_edit['RandomSuffix_desc'])."
{$lang_item_edit['other']}:
".makeinfocell($lang_item_edit['area'],$lang_item_edit['area_desc'])." ".makeinfocell($lang_item_edit['map'],$lang_item_edit['map_desc'])." ".makeinfocell($lang_item_edit['page_text'],$lang_item_edit['page_text_desc'])." ".makeinfocell($lang_item_edit['unk0'],$lang_item_edit['unk0_desc'])."
".makeinfocell($lang_item_edit['disenchant_id'],$lang_item_edit['disenchant_id_desc'])." ".makeinfocell($lang_item_edit['req_skill_disenchant'],$lang_item_edit['req_skill_disenchant_desc'])." ".makeinfocell($lang_item_edit['lock_id'],$lang_item_edit['lock_id_desc'])."
".makeinfocell($lang_item_edit['lang_id'],$lang_item_edit['lang_id_desc'])." ".makeinfocell($lang_item_edit['sheath'],$lang_item_edit['sheath_desc'])." ".makeinfocell($lang_item_edit['totem_category'],$lang_item_edit['totem_category_desc'])."


"; $output .= "


{$lang_item_edit['stats']}:
".makeinfocell($lang_item_edit['stat_type']." 1",$lang_item_edit['stat_type_desc'])." ".makeinfocell($lang_item_edit['stat_type']." 2",$lang_item_edit['stat_type_desc'])."
".makeinfocell($lang_item_edit['stat_type']." 3",$lang_item_edit['stat_type_desc'])." ".makeinfocell($lang_item_edit['stat_type']." 4",$lang_item_edit['stat_type_desc'])."
".makeinfocell($lang_item_edit['stat_type']." 5",$lang_item_edit['stat_type_desc'])." ".makeinfocell($lang_item_edit['stat_type']." 6",$lang_item_edit['stat_type_desc'])."
".makeinfocell($lang_item_edit['stat_type']." 7",$lang_item_edit['stat_type_desc'])." ".makeinfocell($lang_item_edit['stat_type']." 8",$lang_item_edit['stat_type_desc'])."
".makeinfocell($lang_item_edit['stat_type']." 9",$lang_item_edit['stat_type_desc'])." ".makeinfocell($lang_item_edit['stat_type']." 10",$lang_item_edit['stat_type_desc'])."
{$lang_item_edit['resis_armor']}:
".makeinfocell($lang_item['armor'],$lang_item_edit['armor_desc'])." ".makeinfocell($lang_item['block'],$lang_item_edit['block_desc'])."
".makeinfocell($lang_item['res_holy'],$lang_item_edit['res_holy_desc'])." ".makeinfocell($lang_item['res_fire'],$lang_item_edit['res_fire_desc'])."
".makeinfocell($lang_item['res_nature'],$lang_item_edit['res_nature_desc'])." ".makeinfocell($lang_item['res_frost'],$lang_item_edit['res_frost_desc'])."
".makeinfocell($lang_item['res_shadow'],$lang_item_edit['res_shadow_desc'])." ".makeinfocell($lang_item['res_arcane'],$lang_item_edit['res_arcane_desc'])."


"; $output .= "


{$lang_item_edit['weapon_properties']}:
".makeinfocell($lang_item_edit['delay'],$lang_item_edit['delay_desc'])." ".makeinfocell($lang_item_edit['ranged_mod'],$lang_item_edit['ranged_mod_desc'])."
".makeinfocell($lang_item_edit['armor_dmg_mod'],$lang_item_edit['armor_dmg_mod_desc'])." ".makeinfocell($lang_item_edit['ammo_type'],$lang_item_edit['ammo_type_desc'])."
{$lang_item_edit['weapon_damage']}:
".makeinfocell($lang_item_edit['damage_type']." 1",$lang_item_edit['damage_type_desc'])." ".makeinfocell($lang_item_edit['dmg_min_max'],$lang_item_edit['dmg_min_max_desc'])." -
".makeinfocell($lang_item_edit['damage_type']." 2",$lang_item_edit['damage_type_desc'])." ".makeinfocell($lang_item_edit['dmg_min_max'],$lang_item_edit['dmg_min_max_desc'])." -


"; $output .= "


{$lang_item_edit['item_spell']} 1 ".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])." ".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])." ".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."
".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])." ".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])." ".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])." ".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."
{$lang_item_edit['item_spell']} 2 ".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])." ".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])." ".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."
".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])." ".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])." ".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])." ".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."
{$lang_item_edit['item_spell']} 3 ".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])." ".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])." ".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."
".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])." ".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])." ".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])." ".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."
{$lang_item_edit['item_spell']} 4 ".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])." ".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])." ".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."
".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])." ".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])." ".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])." ".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."
{$lang_item_edit['item_spell']} 5 ".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])." ".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])." ".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."
".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])." ".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])." ".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])." ".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."


"; $output .= "


".makeinfocell($lang_item_edit['allow_class'],$lang_item_edit['allow_class_desc'])." ".makeinfocell($lang_item_edit['allow_race'],$lang_item_edit['allow_race_desc'])."
".makeinfocell($lang_item_edit['req_skill'],$lang_item_edit['req_skill_desc'])." ".makeinfocell($lang_item_edit['req_skill_rank'],$lang_item_edit['req_skill_rank_desc'])."
".makeinfocell($lang_item_edit['req_spell'],$lang_item_edit['req_spell_desc'])." ".makeinfocell($lang_item_edit['req_honor_rank'],$lang_item_edit['req_honor_rank_desc'])."
".makeinfocell($lang_item_edit['req_rep_faction'],$lang_item_edit['req_rep_faction_desc'])." ".makeinfocell($lang_item_edit['req_rep_rank'],$lang_item_edit['req_rep_rank_desc'])."
".makeinfocell($lang_item_edit['req_city_rank'],$lang_item_edit['req_city_rank_desc'])."


"; $output .= "


".makeinfocell($lang_item_edit['socket_color']." 1",$lang_item_edit['socket_color_desc'])." ".makeinfocell($lang_item_edit['socket_content']." 1",$lang_item_edit['socket_content_desc'])."
".makeinfocell($lang_item_edit['socket_color']." 2",$lang_item_edit['socket_color_desc'])." ".makeinfocell($lang_item_edit['socket_content']." 2",$lang_item_edit['socket_content_desc'])."
".makeinfocell($lang_item_edit['socket_color']." 3",$lang_item_edit['socket_color_desc'])." ".makeinfocell($lang_item_edit['socket_content']." 3",$lang_item_edit['socket_content_desc'])."
".makeinfocell($lang_item_edit['socket_bonus'],$lang_item_edit['socket_bonus_desc'])." ".makeinfocell($lang_item_edit['gem_properties'],$lang_item_edit['gem_properties_desc'])."



"; $output .= "
"; makebutton($lang_item_edit['update'], "javascript:do_submit('form1',0)",180); makebutton($lang_item_edit['export_sql'], "javascript:do_submit('form1',1)",180); makebutton($lang_item_edit['search_items'], "item.php",180); $output .= "
"; } //######################################################################################################################## // EDIT ITEM FORM //######################################################################################################################## 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 .= "



"; $output .= "


"; $class = array( 0 => "", 1 => "", 2 => "", 4 => "", 5 => "", 6 => "", 7 => "", 9 => "", 11 => "", 12 => "", 13 => "", 14 => "",15 => "" ); $class[$item['class']] = " selected=\"selected\" "; $output .= ""; 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 .= ""; unset($subclass); $quality = array( 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "" ); $quality[$item['Quality']] = " selected=\"selected\" "; $output .= ""; 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 .= ""; unset($inv_type); $bonding = array( 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "" ); $bonding[$item['bonding']] = " selected=\"selected\" "; $output .= "
{$lang_item_edit['general']}:
".makeinfocell($lang_item_edit['entry'],$lang_item_edit['entry_desc'])." "; //$output .= maketooltip($entry, "$item_datasite$entry", $tooltip, "item_tooltip"); $output .= " ".makeinfocell($lang_item_edit['display_id'],$lang_item_edit['display_id_desc'])." ".makeinfocell($lang_item_edit['req_level'],$lang_item_edit['req_level_desc'])." ".makeinfocell($lang_item_edit['item_level'],$lang_item_edit['item_level_desc'])."
{$lang_item_edit['names']}:
".makeinfocell($lang_item_edit['item_name'],$lang_item_edit['item_name_desc'])." ".makeinfocell($lang_item_edit['script_name'],$lang_item_edit['script_name_desc'])."
".makeinfocell($lang_item_edit['description'],$lang_item_edit['description_desc'])."
{$lang_item_edit['type']}:
".makeinfocell($lang_item_edit['class'],$lang_item_edit['class_desc'])." ".makeinfocell($lang_item_edit['subclass'],$lang_item_edit['subclass_desc'])."
".makeinfocell($lang_item_edit['quality'],$lang_item_edit['quality_desc'])." ".makeinfocell($lang_item_edit['inv_type'],$lang_item_edit['inv_type_desc'])." ".makeinfocell($lang_item_edit['flags'],$lang_item_edit['flags_desc'])."
".makeinfocell($lang_item_edit['item_set'],$lang_item_edit['item_set_desc'])." ".makeinfocell($lang_item_edit['bonding'],$lang_item_edit['bonding_desc'])." ".makeinfocell($lang_item_edit['start_quest'],$lang_item_edit['start_quest_desc'])."

{$lang_item_edit['short_rules_desc']}

"; unset($bonding); $output .= "


"; $bagfamily = array( 0 => "", 1 => "", 2 => "", 3 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => "", 12 => "" ); $bagfamily[$item['BagFamily']] = " selected=\"selected\" "; $output .= ""; unset($bagfamily); $Material = array( -1 => "", 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => ""); $Material[$item['Material']] = " selected=\"selected\" "; $output .= ""; unset($Material); $PageMaterial = array( 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => ""); $PageMaterial[$item['PageMaterial']] = " selected=\"selected\" "; $output .= ""; unset($PageMaterial); $output .= ""; $LanguageID = array( 0 => "", 1 => "", 2 => "", 3 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => "", 11 => "", 12 => "", 13 => "", 14 => "", 33 => ""); $LanguageID[$item['LanguageID']] = " selected=\"selected\" "; $output .= ""; unset($LanguageID); $sheath = array( 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 7 => ""); $sheath[$item['sheath']] = " selected=\"selected\" "; $output .= "
{$lang_item_edit['vendor']}:
".makeinfocell($lang_item_edit['buy_count'],$lang_item_edit['buy_count_desc'])." ".makeinfocell($lang_item_edit['buy_price'],$lang_item_edit['buy_price_desc'])." ".makeinfocell($lang_item_edit['sell_price'],$lang_item_edit['sell_price_desc'])."
{$lang_item_edit['container']}:
".makeinfocell($lang_item_edit['max_count'],$lang_item_edit['max_count_desc'])." ".makeinfocell($lang_item_edit['stackable'],$lang_item_edit['stackable_desc'])." ".makeinfocell($lang_item_edit['bag_family'],$lang_item_edit['bag_family_desc'])." ".makeinfocell($lang_item_edit['bag_slots'],$lang_item_edit['bag_slots_desc'])."
{$lang_item_edit['materials']}:
".makeinfocell($lang_item_edit['material'],$lang_item_edit['material_desc'])." ".makeinfocell($lang_item_edit['page_material'],$lang_item_edit['page_material_desc'])." ".makeinfocell($lang_item_edit['max_durability'],$lang_item_edit['max_durability_desc'])."
{$lang_item_edit['RandomProperty']}:
".makeinfocell($lang_item_edit['RandomProperty'],$lang_item_edit['RandomProperty_desc'])." ".makeinfocell($lang_item_edit['RandomSuffix'],$lang_item_edit['RandomSuffix_desc'])."
{$lang_item_edit['other']}:
".makeinfocell($lang_item_edit['area'],$lang_item_edit['area_desc'])." ".makeinfocell($lang_item_edit['map'],$lang_item_edit['map_desc'])." ".makeinfocell($lang_item_edit['page_text'],$lang_item_edit['page_text_desc'])." ".makeinfocell($lang_item_edit['unk0'],$lang_item_edit['unk0_desc'])."
".makeinfocell($lang_item_edit['disenchant_id'],$lang_item_edit['disenchant_id_desc'])." ".makeinfocell($lang_item_edit['req_skill_disenchant'],$lang_item_edit['req_skill_disenchant_desc'])." ".makeinfocell($lang_item_edit['lock_id'],$lang_item_edit['lock_id_desc'])."
".makeinfocell($lang_item_edit['lang_id'],$lang_item_edit['lang_id_desc'])." ".makeinfocell($lang_item_edit['sheath'],$lang_item_edit['sheath_desc'])." ".makeinfocell($lang_item_edit['totem_category'],$lang_item_edit['totem_category_desc'])."


"; unset($sheath); $output .= "


{$lang_item_edit['stats']}:
".makeinfocell($lang_item_edit['stat_type']." 1",$lang_item_edit['stat_type_desc'])." ".makeinfocell($lang_item_edit['stat_type']." 2",$lang_item_edit['stat_type_desc'])."
".makeinfocell($lang_item_edit['stat_type']." 3",$lang_item_edit['stat_type_desc'])." ".makeinfocell($lang_item_edit['stat_type']." 4",$lang_item_edit['stat_type_desc'])."
".makeinfocell($lang_item_edit['stat_type']." 5",$lang_item_edit['stat_type_desc'])." ".makeinfocell($lang_item_edit['stat_type']." 6",$lang_item_edit['stat_type_desc'])."
".makeinfocell($lang_item_edit['stat_type']." 7",$lang_item_edit['stat_type_desc'])." ".makeinfocell($lang_item_edit['stat_type']." 8",$lang_item_edit['stat_type_desc'])."
".makeinfocell($lang_item_edit['stat_type']." 9",$lang_item_edit['stat_type_desc'])." ".makeinfocell($lang_item_edit['stat_type']." 10",$lang_item_edit['stat_type_desc'])."
{$lang_item_edit['resis_armor']}:
".makeinfocell($lang_item['armor'],$lang_item_edit['armor_desc'])." ".makeinfocell($lang_item['block'],$lang_item_edit['block_desc'])."
".makeinfocell($lang_item['res_holy'],$lang_item_edit['res_holy_desc'])." ".makeinfocell($lang_item['res_fire'],$lang_item_edit['res_fire_desc'])."
".makeinfocell($lang_item['res_nature'],$lang_item_edit['res_nature_desc'])." ".makeinfocell($lang_item['res_frost'],$lang_item_edit['res_frost_desc'])."
".makeinfocell($lang_item['res_shadow'],$lang_item_edit['res_shadow_desc'])." ".makeinfocell($lang_item['res_arcane'],$lang_item_edit['res_arcane_desc'])."


"; $output .= "


"; $ammo_type = array( 0 => "", 2 => "", 3 => "" ); $ammo_type [$item['ammo_type']] = " selected=\"selected\" "; $output .= ""; unset($ammo_type); $output .= "
{$lang_item_edit['weapon_properties']}:
".makeinfocell($lang_item_edit['delay'],$lang_item_edit['delay_desc'])." ".makeinfocell($lang_item_edit['ranged_mod'],$lang_item_edit['ranged_mod_desc'])."
".makeinfocell($lang_item_edit['armor_dmg_mod'],$lang_item_edit['armor_dmg_mod_desc'])." ".makeinfocell($lang_item_edit['ammo_type'],$lang_item_edit['ammo_type_desc'])."
{$lang_item_edit['weapon_damage']}:
".makeinfocell($lang_item_edit['damage_type']." 1",$lang_item_edit['damage_type_desc'])." ".makeinfocell($lang_item_edit['dmg_min_max'],$lang_item_edit['dmg_min_max_desc'])." -
".makeinfocell($lang_item_edit['damage_type']." 2",$lang_item_edit['damage_type_desc'])." ".makeinfocell($lang_item_edit['dmg_min_max'],$lang_item_edit['dmg_min_max_desc'])." -


"; $output .= "


"; $spelltrigger_1 = array( 0 => "", 1 => "", 2 => "", 4 => ""); $spelltrigger_1 [$item['spelltrigger_1']] = " selected=\"selected\" "; $output .= ""; unset($spelltrigger_1); $spelltrigger_2 = array( 0 => "", 1 => "", 2 => "", 4 => ""); $spelltrigger_2 [$item['spelltrigger_2']] = " selected=\"selected\" "; $output .= ""; unset($spelltrigger_2); $spelltrigger_3 = array( 0 => "", 1 => "", 2 => "", 4 => ""); $spelltrigger_3 [$item['spelltrigger_3']] = " selected=\"selected\" "; $output .= ""; unset($spelltrigger_3); $spelltrigger_4 = array( 0 => "", 1 => "", 2 => "", 4 => ""); $spelltrigger_4 [$item['spelltrigger_4']] = " selected=\"selected\" "; $output .= ""; unset($spelltrigger_4); $spelltrigger_5 = array( 0 => "", 1 => "", 2 => "", 4 => ""); $spelltrigger_5 [$item['spelltrigger_5']] = " selected=\"selected\" "; $output .= "
{$lang_item_edit['item_spell']} 1 ".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])." ".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])." ".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."
".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])." ".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])." ".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])." ".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."
{$lang_item_edit['item_spell']} 2 ".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])." ".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])." ".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."
".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])." ".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])." ".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])." ".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."
{$lang_item_edit['item_spell']} 3 ".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])." ".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])." ".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."
".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])." ".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])." ".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])." ".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."
{$lang_item_edit['item_spell']} 4 ".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])." ".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])." ".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."
".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])." ".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])." ".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])." ".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."
{$lang_item_edit['item_spell']} 5 ".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])." ".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])." ".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."
".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])." ".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])." ".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])." ".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."
"; unset($spelltrigger_5); $output .= "


"; $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 .= ""; 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 .= ""; unset($AllowableRace); $RequiredReputationRank = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5=> "", 6 => "", 7 => ""); $RequiredReputationRank [$item['RequiredReputationRank']] = " selected=\"selected\" "; $output .= "
".makeinfocell($lang_item_edit['allow_class'],$lang_item_edit['allow_class_desc'])." ".makeinfocell($lang_item_edit['allow_race'],$lang_item_edit['allow_race_desc'])."
".makeinfocell($lang_item_edit['req_skill'],$lang_item_edit['req_skill_desc'])." ".makeinfocell($lang_item_edit['req_skill_rank'],$lang_item_edit['req_skill_rank_desc'])."
".makeinfocell($lang_item_edit['req_spell'],$lang_item_edit['req_spell_desc'])." ".makeinfocell($lang_item_edit['req_honor_rank'],$lang_item_edit['req_honor_rank_desc'])."
".makeinfocell($lang_item_edit['req_rep_faction'],$lang_item_edit['req_rep_faction_desc'])." ".makeinfocell($lang_item_edit['req_rep_rank'],$lang_item_edit['req_rep_rank_desc'])."
".makeinfocell($lang_item_edit['req_city_rank'],$lang_item_edit['req_city_rank_desc'])."


"; unset($RequiredReputationRank); $output .= "


"; $socketColor_1 = array(0 => "", 1 => "", 2 => "", 4 => "", 8=> ""); $socketColor_1 [$item['socketColor_1']] = " selected=\"selected\" "; $output .= ""; unset($socketColor_1); $socketColor_2 = array(0 => "", 1 => "", 2 => "", 4 => "", 8=> ""); $socketColor_2 [$item['socketColor_2']] = " selected=\"selected\" "; $output .= ""; unset($socketColor_2); $socketColor_3 = array(0 => "", 1 => "", 2 => "", 4 => "", 8=> ""); $socketColor_3 [$item['socketColor_3']] = " selected=\"selected\" "; $output .= "
".makeinfocell($lang_item_edit['socket_color']." 1",$lang_item_edit['socket_color_desc'])." ".makeinfocell($lang_item_edit['socket_content']." 1",$lang_item_edit['socket_content_desc'])."
".makeinfocell($lang_item_edit['socket_color']." 2",$lang_item_edit['socket_color_desc'])." ".makeinfocell($lang_item_edit['socket_content']." 2",$lang_item_edit['socket_content_desc'])."
".makeinfocell($lang_item_edit['socket_color']." 3",$lang_item_edit['socket_color_desc'])." ".makeinfocell($lang_item_edit['socket_content']." 3",$lang_item_edit['socket_content_desc'])."
".makeinfocell($lang_item_edit['socket_bonus'],$lang_item_edit['socket_bonus_desc'])." ".makeinfocell($lang_item_edit['gem_properties'],$lang_item_edit['gem_properties_desc'])."


"; $output .= "


"; $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 .= ""; } } $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 .= ""; while ($mob = $sql->fetch_row($result2)){ $output .= ""; } } $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 ReqItemId2 = {$item['entry']} OR ReqItemId3 = {$item['entry']} OR ReqItemId4 = {$item['entry']} OR RewItemId1 = {$item['entry']} OR RewItemId2 = {$item['entry']} OR RewItemId3 = {$item['entry']} OR RewItemId4 = {$item['entry']} ) ORDER BY QuestLevel DESC"); if ($sql->num_rows($result2)){ $output .= ""; while ($quest = $sql->fetch_row($result2)){ $output .= ""; } } $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 RewChoiceItemId3 = {$item['entry']} OR RewChoiceItemId4 = {$item['entry']} OR RewChoiceItemId5 = {$item['entry']} OR RewChoiceItemId6 = {$item['entry']} ) ORDER BY QuestLevel DESC"); if ($sql->num_rows($result2)){ $output .= ""; while ($quest = $sql->fetch_row($result2)){ $output .= ""; } } $output .= "
{$lang_item_edit['dropped_by']}: {$lang_item_edit['top_x']}
ID {$lang_item_edit['mob_name']} {$lang_item_edit['mob_level']} {$lang_item_edit['mob_drop_chance']} {$lang_item_edit['mob_quest_drop_chance']}
"; if($user_lvl >= $action_permission['delete']) $output .="$mob[0]"; else $output .="$mob[0]"; $output .=" $mob[1] $mob[2] $info[1]% $info[2]%
{$lang_item_edit['sold_by']}: {$lang_item_edit['limit_x']}
"; if($user_lvl >= $action_permission['delete']) $output .="$mob[0]"; else $output .="$mob[0]"; $output .=" $mob[2] $mob[1]
{$lang_item_edit['involved_in_quests']}:
id: $quest[0] ($quest[2]) $quest[1]
{$lang_item_edit['reward_from_quest']}:
id: $quest[0] ($quest[2]) $quest[1]


"; if ($item['DisenchantID']){ $output .= "


{$lang_item_edit['disenchant_templ']}: {$item['DisenchantID']}
"; $cel_counter = 0; $row_flag = 0; $output .= ""; $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])
{$lang_item_edit['drop_chance']}: $item[1]%
{$lang_item_edit['quest_drop_chance']}: $item[2]%
{$lang_item_edit['drop_chance']}: $item[3]-$item[4]
{$lang_item_edit['lootcondition']}: $item[5]
{$lang_item_edit['condition_value1']}: $item[6]
{$lang_item_edit['condition_value2']}: $item[7]"; $output .= ""; if ($cel_counter >= 16) { $cel_counter = 0; $output .= ""; $row_flag++; } }; if ($row_flag) $output .= ""; $output .= "
"; $output .= maketooltip("\"\"", "$item_datasite$item[0]", $tooltip, "item_tooltip"); $output .= "
{$lang_item_edit['add_items_to_templ']}:
".makeinfocell($lang_item_edit['loot_item_id'],$lang_item_edit['loot_item_id_desc'])." ".makeinfocell($lang_item_edit['loot_drop_chance'],$lang_item_edit['loot_drop_chance_desc'])." ".makeinfocell($lang_item_edit['loot_quest_drop_chance'],$lang_item_edit['loot_quest_drop_chance_desc'])."
".makeinfocell($lang_item_edit['min_count'],$lang_item_edit['min_count_desc'])." ".makeinfocell($lang_item_edit['max_count'],$lang_item_edit['max_count_desc'])."
".makeinfocell($lang_item_edit['lootcondition'],$lang_item_edit['lootcondition_desc'])." ".makeinfocell($lang_item_edit['condition_value1'],$lang_item_edit['condition_value1_desc'])." ".makeinfocell($lang_item_edit['condition_value2'],$lang_item_edit['condition_value2_desc'])."
"; } $output .= "

"; unset($socketColor_3); $output .= "
"; if($user_lvl >= $action_permission['delete']) makebutton($lang_item_edit['del_item'], "item.php?action=delete&entry=$entry\" type=\"wrn",180); $output .= " "; if($user_lvl >= $action_permission['update']) makebutton($lang_item_edit['update'], "javascript:do_submit('form1',0)\" type=\"wrn",180); $output .= " "; if($user_lvl >= $action_permission['insert']) makebutton($lang_item_edit['export_sql'], "javascript:do_submit('form1',1)",180); $output .= " "; makebutton($lang_global['back'], "javascript:window.history.back()", 130); $output .= " "; makebutton($lang_item_edit['new_search'], "item.php",130); $output .= "
"; } else { error($lang_item_edit['item_not_found']); exit(); } } //######################################################################################################################## //DO UPDATE ITEM //######################################################################################################################## function do_update() { global $world_db, $realm_id, $action_permission, $user_lvl; valid_login($action_permission['update']); if (!isset($_POST['type']) || $_POST['type'] === '') redirect("item.php?error=1"); if (!isset($_POST['entry']) || $_POST['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($_POST['entry']); if (isset($_POST['class']) && $_POST['class'] != '') $class = $sql->quote_smart($_POST['class']); else $class = 0; if (isset($_POST['subclass']) && $_POST['subclass'] != '') $subclass = $sql->quote_smart($_POST['subclass']); else $subclass = 0; if (isset($_POST['name']) && $_POST['name'] != '') $name = $sql->quote_smart($_POST['name']); else $name = 0; if (isset($_POST['displayid']) && $_POST['displayid'] != '') $displayid = $sql->quote_smart($_POST['displayid']); else $displayid = 0; if (isset($_POST['Quality']) && $_POST['Quality'] != '') $Quality = $sql->quote_smart($_POST['Quality']); else $Quality = 0; if (isset($_POST['Flags']) && $_POST['Flags'] != '') $Flags = $sql->quote_smart($_POST['Flags']); else $Flags = 0; if (isset($_POST['BuyCount']) && $_POST['BuyCount'] != '') $BuyCount = $sql->quote_smart($_POST['BuyCount']); else $BuyCount = 0; if (isset($_POST['BuyPrice']) && $_POST['BuyPrice'] != '') $BuyPrice = $sql->quote_smart($_POST['BuyPrice']); else $BuyPrice = 0; if (isset($_POST['SellPrice']) && $_POST['SellPrice'] != '') $SellPrice = $sql->quote_smart($_POST['SellPrice']); else $SellPrice = 0; if (isset($_POST['InventoryType']) && $_POST['InventoryType'] != '') $InventoryType = $sql->quote_smart($_POST['InventoryType']); else $AllowableClass = 0; if (isset($_POST['AllowableClass'])) $AllowableClass = $sql->quote_smart($_POST['AllowableClass']); else $AllowableClass = -1; if (isset($_POST['AllowableRace'])) $AllowableRace = $sql->quote_smart($_POST['AllowableRace']); else $AllowableRace = -1; if (isset($_POST['ItemLevel']) && $_POST['ItemLevel'] != '') $ItemLevel = $sql->quote_smart($_POST['ItemLevel']); else $ItemLevel = 1; if (isset($_POST['RequiredLevel']) && $_POST['RequiredLevel'] != '') $RequiredLevel = $sql->quote_smart($_POST['RequiredLevel']); else $RequiredLevel = 0; if (isset($_POST['RequiredSkill']) && $_POST['RequiredSkill'] != '') $RequiredSkill = $sql->quote_smart($_POST['RequiredSkill']); else $RequiredSkill = 0; if (isset($_POST['RequiredSkillRank']) && $_POST['RequiredSkillRank'] != '') $RequiredSkillRank = $sql->quote_smart($_POST['RequiredSkillRank']); else $RequiredSkillRank = 0; if (isset($_POST['requiredspell']) && $_POST['requiredspell'] != '') $requiredspell = $sql->quote_smart($_POST['requiredspell']); else $requiredspell = 0; if (isset($_POST['requiredhonorrank']) && $_POST['requiredhonorrank'] != '') $requiredhonorrank = $sql->quote_smart($_POST['requiredhonorrank']); else $requiredhonorrank = 0; if (isset($_POST['RequiredCityRank']) && $_POST['RequiredCityRank'] != '') $RequiredCityRank = $sql->quote_smart($_POST['RequiredCityRank']); else $RequiredCityRank = 0; if (isset($_POST['RequiredReputationFaction']) && $_POST['RequiredReputationFaction'] != '') $RequiredReputationFaction = $sql->quote_smart($_POST['RequiredReputationFaction']); else $RequiredReputationFaction = 0; if (isset($_POST['RequiredReputationRank']) && $_POST['RequiredReputationRank'] != '') $RequiredReputationRank = $sql->quote_smart($_POST['RequiredReputationRank']); else $RequiredReputationRank = 0; if (isset($_POST['maxcount']) && $_POST['maxcount'] != '') $maxcount = $sql->quote_smart($_POST['maxcount']); else $maxcount = 0; if (isset($_POST['stackable']) && $_POST['stackable'] != '') $stackable = $sql->quote_smart($_POST['stackable']); else $description = 0; if (isset($_POST['ContainerSlots']) && $_POST['ContainerSlots'] != '') $ContainerSlots = $sql->quote_smart($_POST['ContainerSlots']); else $ContainerSlots = 0; if (isset($_POST['stat_type1']) && $_POST['stat_type1'] != '') $stat_type1 = $sql->quote_smart($_POST['stat_type1']); else $stat_type1 = 0; if (isset($_POST['stat_value1']) && $_POST['stat_value1'] != '') $stat_value1 = $sql->quote_smart($_POST['stat_value1']); else $stat_value1 = 0; if (isset($_POST['stat_type2']) && $_POST['stat_type2'] != '') $stat_type2 = $sql->quote_smart($_POST['stat_type2']); else $stat_type2 = 0; if (isset($_POST['stat_value2']) && $_POST['stat_value2'] != '') $stat_value2 = $sql->quote_smart($_POST['stat_value2']); else $stat_value2 = 0; if (isset($_POST['stat_type3']) && $_POST['stat_type3'] != '') $stat_type3 = $sql->quote_smart($_POST['stat_type3']); else $stat_type3 = 0; if (isset($_POST['stat_value3']) && $_POST['stat_value3'] != '') $stat_value3 = $sql->quote_smart($_POST['stat_value3']); else $stat_value3 = 0; if (isset($_POST['stat_type4']) && $_POST['stat_type4'] != '') $stat_type4 = $sql->quote_smart($_POST['stat_type4']); else $stat_type4 = 0; if (isset($_POST['stat_value4']) && $_POST['stat_value4'] != '') $stat_value4 = $sql->quote_smart($_POST['stat_value4']); else $stat_value4 = 0; if (isset($_POST['stat_type5']) && $_POST['stat_type5'] != '') $stat_type5 = $sql->quote_smart($_POST['stat_type5']); else $stat_type5 = 0; if (isset($_POST['stat_value5']) && $_POST['stat_value5'] != '') $stat_value5 = $sql->quote_smart($_POST['stat_value5']); else $stat_value5 = 0; if (isset($_POST['stat_type6']) && $_POST['stat_type6'] != '') $stat_type6 = $sql->quote_smart($_POST['stat_type6']); else $stat_type6 = 0; if (isset($_POST['stat_value6']) && $_POST['stat_value6'] != '') $stat_value6 = $sql->quote_smart($_POST['stat_value6']); else $stat_value6 = 0; if (isset($_POST['stat_type7']) && $_POST['stat_type7'] != '') $stat_type7 = $sql->quote_smart($_POST['stat_type7']); else $stat_type7 = 0; if (isset($_POST['stat_value7']) && $_POST['stat_value7'] != '') $stat_value7 = $sql->quote_smart($_POST['stat_value7']); else $stat_value7 = 0; if (isset($_POST['stat_type8']) && $_POST['stat_type8'] != '') $stat_type8 = $sql->quote_smart($_POST['stat_type8']); else $stat_type8 = 0; if (isset($_POST['stat_value8']) && $_POST['stat_value8'] != '') $stat_value8 = $sql->quote_smart($_POST['stat_value8']); else $stat_value8 = 0; if (isset($_POST['stat_type9']) && $_POST['stat_type9'] != '') $stat_type9 = $sql->quote_smart($_POST['stat_type9']); else $stat_type9 = 0; if (isset($_POST['stat_value9']) && $_POST['stat_value9'] != '') $stat_value9 = $sql->quote_smart($_POST['stat_value9']); else $stat_value9 = 0; if (isset($_POST['stat_type10']) && $_POST['stat_type10'] != '') $stat_type10 = $sql->quote_smart($_POST['stat_type10']); else $stat_type10 = 0; if (isset($_POST['stat_value10']) && $_POST['stat_value10'] != '') $stat_value10 = $sql->quote_smart($_POST['stat_value10']); else $stat_value10 = 0; if (isset($_POST['dmg_min1']) && $_POST['dmg_min1'] != '') $dmg_min1 = $sql->quote_smart($_POST['dmg_min1']); else $dmg_min1 = 0; if (isset($_POST['dmg_max1']) && $_POST['dmg_max1'] != '') $dmg_max1 = $sql->quote_smart($_POST['dmg_max1']); else $dmg_max1 = 0; if (isset($_POST['dmg_type1']) && $_POST['dmg_type1'] != '') $dmg_type1 = $sql->quote_smart($_POST['dmg_type1']); else $dmg_type1 = 0; if (isset($_POST['dmg_min2']) && $_POST['dmg_min2'] != '') $dmg_min2 = $sql->quote_smart($_POST['dmg_min2']); else $dmg_min2 = 0; if (isset($_POST['dmg_max2']) && $_POST['dmg_max2'] != '') $dmg_max2 = $sql->quote_smart($_POST['dmg_max2']); else $dmg_max2 = 0; if (isset($_POST['dmg_type2']) && $_POST['dmg_type2'] != '') $dmg_type2 = $sql->quote_smart($_POST['dmg_type2']); else $dmg_type2 = 0; if (isset($_POST['armor']) && $_POST['armor'] != '') $armor = $sql->quote_smart($_POST['armor']); else $armor = 0; if (isset($_POST['holy_res']) && $_POST['holy_res'] != '') $holy_res = $sql->quote_smart($_POST['holy_res']); else $holy_res = 0; if (isset($_POST['fire_res']) && $_POST['fire_res'] != '') $fire_res = $sql->quote_smart($_POST['fire_res']); else $fire_res = 0; if (isset($_POST['nature_res']) && $_POST['nature_res'] != '') $nature_res = $sql->quote_smart($_POST['nature_res']); else $nature_res = 0; if (isset($_POST['frost_res']) && $_POST['frost_res'] != '') $frost_res = $sql->quote_smart($_POST['frost_res']); else $frost_res = 0; if (isset($_POST['shadow_res']) && $_POST['shadow_res'] != '') $shadow_res = $sql->quote_smart($_POST['shadow_res']); else $shadow_res = 0; if (isset($_POST['arcane_res']) && $_POST['arcane_res'] != '') $arcane_res = $sql->quote_smart($_POST['arcane_res']); else $arcane_res = 0; if (isset($_POST['delay']) && $_POST['delay'] != '') $delay = $sql->quote_smart($_POST['delay']); else $delay = 0; if (isset($_POST['ammo_type']) && $_POST['ammo_type'] != '') $ammo_type = $sql->quote_smart($_POST['ammo_type']); else $ammo_type = 0; if (isset($_POST['RangedModRange']) && $_POST['RangedModRange'] != '') $RangedModRange = $sql->quote_smart($_POST['RangedModRange']); else $RangedModRange = 0; if (isset($_POST['spellid_1']) && $_POST['spellid_1'] != '') $spellid_1 = $sql->quote_smart($_POST['spellid_1']); else $spellid_1 = 0; if (isset($_POST['spelltrigger_1']) && $_POST['spelltrigger_1'] != '') $spelltrigger_1 = $sql->quote_smart($_POST['spelltrigger_1']); else $spelltrigger_1 = 0; if (isset($_POST['spellcharges_1']) && $_POST['spellcharges_1'] != '') $spellcharges_1 = $sql->quote_smart($_POST['spellcharges_1']); else $spellcharges_1 = 0; if (isset($_POST['spellcooldown_1']) && $_POST['spellcooldown_1'] != '') $spellcooldown_1 = $sql->quote_smart($_POST['spellcooldown_1']); else $spellcooldown_1 = -1; if (isset($_POST['spellcategory_1']) && $_POST['spellcategory_1'] != '') $spellcategory_1 = $sql->quote_smart($_POST['spellcategory_1']); else $spellcategory_1 = 0; if (isset($_POST['spellcategorycooldown_1']) && $_POST['spellcategorycooldown_1'] != '') $spellcategorycooldown_1 = $sql->quote_smart($_POST['spellcategorycooldown_1']); else $spellcategorycooldown_1 = -1; if (isset($_POST['spellppmRate_1']) && $_POST['spellppmRate_1'] != '') $spellppmRate_1 = $sql->quote_smart($_POST['spellppmRate_1']); else $spellppmRate_1 = 0; if (isset($_POST['spellid_2']) && $_POST['spellid_2'] != '') $spellid_2 = $sql->quote_smart($_POST['spellid_2']); else $spellid_2 = 0; if (isset($_POST['spelltrigger_2']) && $_POST['spelltrigger_2'] != '') $spelltrigger_2 = $sql->quote_smart($_POST['spelltrigger_2']); else $spelltrigger_2 = 0; if (isset($_POST['spellcharges_2']) && $_POST['spellcharges_2'] != '') $spellcharges_2 = $sql->quote_smart($_POST['spellcharges_2']); else $spellcharges_2 = 0; if (isset($_POST['spellcooldown_2']) && $_POST['spellcooldown_2'] != '') $spellcooldown_2 = $sql->quote_smart($_POST['spellcooldown_2']); else $spellcooldown_2 = -1; if (isset($_POST['spellcategory_2']) && $_POST['spellcategory_2'] != '') $spellcategory_2 = $sql->quote_smart($_POST['spellcategory_2']); else $spellcategory_2 = 0; if (isset($_POST['spellcategorycooldown_2']) && $_POST['spellcategorycooldown_2'] != '') $spellcategorycooldown_2 = $sql->quote_smart($_POST['spellcategorycooldown_2']); else $spellcategorycooldown_2 = -1; if (isset($_POST['spellppmRate_2']) && $_POST['spellppmRate_2'] != '') $spellppmRate_2 = $sql->quote_smart($_POST['spellppmRate_2']); else $spellppmRate_2 = 0; if (isset($_POST['spellid_3']) && $_POST['spellid_3'] != '') $spellid_3 = $sql->quote_smart($_POST['spellid_3']); else $spellid_3 = 0; if (isset($_POST['spelltrigger_3']) && $_POST['spelltrigger_3'] != '') $spelltrigger_3 = $sql->quote_smart($_POST['spelltrigger_3']); else $spelltrigger_3 = 0; if (isset($_POST['spellcharges_3']) && $_POST['spellcharges_3'] != '') $spellcharges_3 = $sql->quote_smart($_POST['spellcharges_3']); else $spellcharges_3 = 0; if (isset($_POST['spellcooldown_3']) && $_POST['spellcooldown_3'] != '') $spellcooldown_3 = $sql->quote_smart($_POST['spellcooldown_3']); else $spellcooldown_3 = -1; if (isset($_POST['spellcategory_3']) && $_POST['spellcategory_3'] != '') $spellcategory_3 = $sql->quote_smart($_POST['spellcategory_3']); else $description = 0; if (isset($_POST['spellcategorycooldown_3']) && $_POST['spellcategorycooldown_3'] != '') $spellcategorycooldown_3 = $sql->quote_smart($_POST['spellcategorycooldown_3']); else $spellcategorycooldown_3 = -1; if (isset($_POST['spellppmRate_3']) && $_POST['spellppmRate_3'] != '') $spellppmRate_3 = $sql->quote_smart($_POST['spellppmRate_3']); else $spellppmRate_3 = 0; if (isset($_POST['spellid_4']) && $_POST['spellid_4'] != '') $spellid_4 = $sql->quote_smart($_POST['spellid_4']); else $spellid_4 = 0; if (isset($_POST['spelltrigger_4']) && $_POST['spelltrigger_4'] != '') $spelltrigger_4 = $sql->quote_smart($_POST['spelltrigger_4']); else $spelltrigger_4 = 0; if (isset($_POST['spellcharges_4']) && $_POST['spellcharges_4'] != '') $spellcharges_4 = $sql->quote_smart($_POST['spellcharges_4']); else $spellcharges_4 = 0; if (isset($_POST['spellcooldown_4']) && $_POST['spellcooldown_4'] != '') $spellcooldown_4 = $sql->quote_smart($_POST['spellcooldown_4']); else $spellcooldown_4 = -1; if (isset($_POST['spellcategory_4']) && $_POST['spellcategory_4'] != '') $spellcategory_4 = $sql->quote_smart($_POST['spellcategory_4']); else $spellcategory_4 = 0; if (isset($_POST['spellcategorycooldown_4']) && $_POST['spellcategorycooldown_4'] != '') $spellcategorycooldown_4 = $sql->quote_smart($_POST['spellcategorycooldown_4']); else $spellcategorycooldown_4 = -1; if (isset($_POST['spellppmRate_4']) && $_POST['spellppmRate_4'] != '') $spellppmRate_4 = $sql->quote_smart($_POST['spellppmRate_4']); else $spellppmRate_4 = 0; if (isset($_POST['spellid_5']) && $_POST['spellid_5'] != '') $spellid_5 = $sql->quote_smart($_POST['spellid_5']); else $spellid_5 = 0; if (isset($_POST['spelltrigger_5']) && $_POST['spelltrigger_5'] != '') $spelltrigger_5 = $sql->quote_smart($_POST['spelltrigger_5']); else $spelltrigger_5 = 0; if (isset($_POST['spellcharges_5']) && $_POST['spellcharges_5'] != '') $spellcharges_5 = $sql->quote_smart($_POST['spellcharges_5']); else $spellcharges_5 = 0; if (isset($_POST['spellcooldown_5']) && $_POST['spellcooldown_5'] != '') $spellcooldown_5 = $sql->quote_smart($_POST['spellcooldown_5']); else $spellcooldown_5 = -1; if (isset($_POST['spellcategory_5']) && $_POST['spellcategory_5'] != '') $spellcategory_5 = $sql->quote_smart($_POST['spellcategory_5']); else $spellcategory_5 = 0; if (isset($_POST['spellcategorycooldown_5']) && $_POST['spellcategorycooldown_5'] != '') $spellcategorycooldown_5 = $sql->quote_smart($_POST['spellcategorycooldown_5']); else $spellcategorycooldown_5 = -1; if (isset($_POST['spellppmRate_5']) && $_POST['spellppmRate_5'] != '') $spellppmRate_5 = $sql->quote_smart($_POST['spellppmRate_5']); else $spellppmRate_5 = 0; if (isset($_POST['bonding']) && $_POST['bonding'] != '') $bonding = $sql->quote_smart($_POST['bonding']); else $bonding = 0; if (isset($_POST['description']) && $_POST['description'] != '') $description = $sql->quote_smart($_POST['description']); else $description = ""; if (isset($_POST['PageText']) && $_POST['PageText'] != '') $PageText = $sql->quote_smart($_POST['PageText']); else $PageText = 0; if (isset($_POST['LanguageID']) && $_POST['LanguageID'] != '') $LanguageID = $sql->quote_smart($_POST['LanguageID']); else $LanguageID = 0; if (isset($_POST['PageMaterial']) && $_POST['PageMaterial'] != '') $PageMaterial = $sql->quote_smart($_POST['PageMaterial']); else $PageMaterial = 0; if (isset($_POST['startquest']) && $_POST['startquest'] != '') $startquest = $sql->quote_smart($_POST['startquest']); else $startquest = 0; if (isset($_POST['lockid']) && $_POST['lockid'] != '') $lockid = $sql->quote_smart($_POST['lockid']); else $lockid = 0; if (isset($_POST['Material']) && $_POST['Material'] != '') $Material = $sql->quote_smart($_POST['Material']); else $Material = 0; if (isset($_POST['sheath']) && $_POST['sheath'] != '') $sheath = $sql->quote_smart($_POST['sheath']); else $sheath = 0; if (isset($_POST['RandomProperty']) && $_POST['RandomProperty'] != '') $RandomProperty = $sql->quote_smart($_POST['RandomProperty']); else $RandomProperty = 0; if (isset($_POST['block ']) && $_POST['block '] != '') $block = $sql->quote_smart($_POST['block']); else $block = 0; if (isset($_POST['itemset']) && $_POST['itemset'] != '') $itemset = $sql->quote_smart($_POST['itemset']); else $itemset = 0; if (isset($_POST['MaxDurability']) && $_POST['MaxDurability'] != '') $MaxDurability = $sql->quote_smart($_POST['MaxDurability']); else $MaxDurability = 0; if (isset($_POST['area']) && $_POST['area'] != '') $area = $sql->quote_smart($_POST['area']); else $area = 0; if (isset($_POST['BagFamily']) && $_POST['BagFamily'] != '') $BagFamily = $sql->quote_smart($_POST['BagFamily']); else $BagFamily = 0; if (isset($_POST['Map']) && $_POST['Map'] != '') $Map = $sql->quote_smart($_POST['Map']); else $Map = 0; if (isset($_POST['ScriptName']) && $_POST['ScriptName'] != '') $ScriptName = $sql->quote_smart($_POST['ScriptName']); else $ScriptName = 0; if (isset($_POST['DisenchantID']) && $_POST['DisenchantID'] != '') $DisenchantID = $sql->quote_smart($_POST['DisenchantID']); else $DisenchantID = 0; if (isset($_POST['RequiredDisenchantSkill']) && $_POST['RequiredDisenchantSkill'] != '') $RequiredDisenchantSkill = $sql->quote_smart($_POST['RequiredDisenchantSkill']); else $RequiredDisenchantSkill = -1; if (isset($_POST['unk0']) && $_POST['unk0'] != '') $unk0 = $sql->quote_smart($_POST['unk0']); else $unk0 = -1; if (isset($_POST['RandomSuffix']) && $_POST['RandomSuffix'] != '') $RandomSuffix = $sql->quote_smart($_POST['RandomSuffix']); else $RandomSuffix = 0; if (isset($_POST['TotemCategory']) && $_POST['TotemCategory'] != '') $TotemCategory = $sql->quote_smart($_POST['TotemCategory']); else $TotemCategory = 0; if (isset($_POST['socketColor_1']) && $_POST['socketColor_1'] != '') $socketColor_1 = $sql->quote_smart($_POST['socketColor_1']); else $socketColor_1 = 0; if (isset($_POST['socketContent_1']) && $_POST['socketContent_1'] != '') $socketContent_1 = $sql->quote_smart($_POST['socketContent_1']); else $socketContent_1 = 0; if (isset($_POST['socketColor_2']) && $_POST['socketColor_2'] != '') $socketColor_2 = $sql->quote_smart($_POST['socketColor_2']); else $socketColor_2 = 0; if (isset($_POST['socketContent_2']) && $_POST['socketContent_2'] != '') $socketContent_2 = $sql->quote_smart($_POST['socketContent_2']); else $socketContent_2 = 0; if (isset($_POST['socketColor_3']) && $_POST['socketColor_3'] != '') $socketColor_3 = $sql->quote_smart($_POST['socketColor_3']); else $socketColor_3 = 0; if (isset($_POST['socketContent_3']) && $_POST['socketContent_3'] != '') $socketContent_3 = $sql->quote_smart($_POST['socketContent_3']); else $socketContent_3 = 0; if (isset($_POST['socketBonus']) && $_POST['socketBonus'] != '') $socketBonus = $sql->quote_smart($_POST['socketBonus']); else $socketBonus = 0; if (isset($_POST['GemProperties']) && $_POST['GemProperties'] != '') $GemProperties = $sql->quote_smart($_POST['GemProperties']); else $GemProperties = 0; if (isset($_POST['ArmorDamageModifier']) && $_POST['ArmorDamageModifier'] != '') $ArmorDamageModifier = $sql->quote_smart($_POST['ArmorDamageModifier']); else $ArmorDamageModifier = 0; if (isset($_POST['de_ChanceOrQuestChance']) && $_POST['de_ChanceOrQuestChance'] != '') $de_ChanceOrQuestChance = $sql->quote_smart($_POST['de_ChanceOrQuestChance']); else $de_ChanceOrQuestChance = 0; if (isset($_POST['de_groupid']) && $_POST['de_groupid'] != '') $de_groupid = $sql->quote_smart($_POST['de_groupid']); else $de_groupid = 0; if (isset($_POST['de_mincountOrRef']) && $_POST['de_mincountOrRef'] != '') $de_mincountOrRef = $sql->quote_smart($_POST['de_mincountOrRef']); else $de_mincountOrRef = 0; if (isset($_POST['de_maxcount']) && $_POST['de_maxcount'] != '') $de_maxcount = $sql->quote_smart($_POST['de_maxcount']); else $de_maxcount = 0; if (isset($_POST['de_lootcondition']) && $_POST['de_lootcondition'] != '') $de_lootcondition = $sql->quote_smart($_POST['de_lootcondition']); else $de_lootcondition = 0; if (isset($_POST['de_condition_value1']) && $_POST['de_condition_value1'] != '') $de_condition_value1 = $sql->quote_smart($_POST['de_condition_value1']); else $de_condition_value1 = 0; if (isset($_POST['de_condition_value2']) && $_POST['de_condition_value2'] != '') $de_condition_value2 = $sql->quote_smart($_POST['de_condition_value2']); else $de_condition_value2 = 0; if (isset($_POST['de_item']) && $_POST['de_item'] != '') $de_item = $sql->quote_smart($_POST['de_item']); else $de_item = 0; if (isset($_POST['del_de_items']) && $_POST['del_de_items'] != '') $del_de_items = $sql->quote_smart($_POST['del_de_items']); else $del_de_items = NULL; $tmp = 0; if ($AllowableClass[0] != -1){ for ($t=0; $tquery("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 ($item_templ = $sql->fetch_assoc($result)){ if ($item_templ['class'] != $class) $sql_query .= "class='$class',"; if ($item_templ['subclass'] != $subclass) $sql_query .= "subclass='$subclass',"; if ($item_templ['name'] != $name) $sql_query .= "name='$name',"; if ($item_templ['displayid'] != $displayid) $sql_query .= "displayid='$displayid',"; if ($item_templ['Quality'] != $Quality) $sql_query .= "Quality='$Quality',"; if ($item_templ['Flags'] != $Flags) $sql_query .= "Flags='$Flags',"; if ($item_templ['BuyCount'] != $BuyCount) $sql_query .= "BuyCount='$BuyCount',"; if ($item_templ['BuyPrice'] != $BuyPrice) $sql_query .= "BuyPrice='$BuyPrice',"; if ($item_templ['SellPrice'] != $SellPrice) $sql_query .= "SellPrice='$SellPrice',"; if ($item_templ['InventoryType'] != $InventoryType) $sql_query .= "InventoryType='$InventoryType',"; if ($item_templ['AllowableClass'] != $AllowableClass) $sql_query .= "AllowableClass='$AllowableClass',"; if ($item_templ['AllowableRace'] != $AllowableRace) $sql_query .= "AllowableRace='$AllowableRace',"; if ($item_templ['ItemLevel'] != $ItemLevel) $sql_query .= "ItemLevel='$ItemLevel',"; if ($item_templ['RequiredLevel'] != $RequiredLevel) $sql_query .= "RequiredLevel='$RequiredLevel',"; if ($item_templ['RequiredSkill'] != $RequiredSkill) $sql_query .= "RequiredSkill='$RequiredSkill',"; if ($item_templ['RequiredSkillRank'] != $RequiredSkillRank) $sql_query .= "RequiredSkillRank='$RequiredSkillRank',"; if ($item_templ['requiredspell'] != $requiredspell) $sql_query .= "requiredspell='$requiredspell',"; if ($item_templ['requiredhonorrank'] != $requiredhonorrank) $sql_query .= "requiredhonorrank='$requiredhonorrank',"; if ($item_templ['RequiredCityRank'] != $RequiredCityRank) $sql_query .= "RequiredCityRank='$RequiredCityRank',"; if ($item_templ['RequiredReputationFaction'] != $RequiredReputationFaction) $sql_query .= "RequiredReputationFaction='$RequiredReputationFaction',"; if ($item_templ['RequiredReputationRank'] != $RequiredReputationRank) $sql_query .= "RequiredReputationRank='$RequiredReputationRank',"; if ($item_templ['maxcount'] != $maxcount) $sql_query .= "maxcount='$maxcount',"; if ($item_templ['stackable'] != $stackable) $sql_query .= "stackable='$stackable',"; if ($item_templ['ContainerSlots'] != $ContainerSlots) $sql_query .= "ContainerSlots='$ContainerSlots',"; if ($item_templ['stat_type1'] != $stat_type1) $sql_query .= "stat_type1='$stat_type1',"; if ($item_templ['stat_value1'] != $stat_value1) $sql_query .= "stat_value1='$stat_value1',"; if ($item_templ['stat_type2'] != $stat_type2) $sql_query .= "stat_type2='$stat_type2',"; if ($item_templ['stat_value2'] != $stat_value2) $sql_query .= "stat_value2='$stat_value2',"; if ($item_templ['stat_type3'] != $stat_type3) $sql_query .= "stat_type3='$stat_type3',"; if ($item_templ['stat_value3'] != $stat_value3) $sql_query .= "stat_value3='$stat_value3',"; if ($item_templ['stat_type4'] != $stat_type4) $sql_query .= "stat_type4='$stat_type4',"; if ($item_templ['stat_value4'] != $stat_value4) $sql_query .= "stat_value4='$stat_value4',"; if ($item_templ['stat_type5'] != $stat_type5) $sql_query .= "stat_type5='$stat_type5',"; if ($item_templ['stat_value5'] != $stat_value5) $sql_query .= "stat_value5='$stat_value5',"; if ($item_templ['stat_type6'] != $stat_type6) $sql_query .= "stat_type6='$stat_type6',"; if ($item_templ['stat_value6'] != $stat_value6) $sql_query .= "stat_value6='$stat_value6',"; if ($item_templ['stat_type7'] != $stat_type7) $sql_query .= "stat_type7='$stat_type7',"; if ($item_templ['stat_value7'] != $stat_value7) $sql_query .= "stat_value7='$stat_value7',"; if ($item_templ['stat_type8'] != $stat_type8) $sql_query .= "stat_type8='$stat_type8',"; if ($item_templ['stat_value8'] != $stat_value8) $sql_query .= "stat_value8='$stat_value8',"; if ($item_templ['stat_type9'] != $stat_type9) $sql_query .= "stat_type9='$stat_type9',"; if ($item_templ['stat_value9'] != $stat_value9) $sql_query .= "stat_value9='$stat_value9',"; if ($item_templ['stat_type10'] != $stat_type10) $sql_query .= "stat_type10='$stat_type10',"; if ($item_templ['stat_value10'] != $stat_value10) $sql_query .= "stat_value10='$stat_value10',"; if ($item_templ['dmg_min1'] != $dmg_min1) $sql_query .= "dmg_min1='$dmg_min1',"; if ($item_templ['dmg_max1'] != $dmg_max1) $sql_query .= "dmg_max1='$dmg_max1',"; if ($item_templ['dmg_type1'] != $dmg_type1) $sql_query .= "dmg_type1='$dmg_type1',"; if ($item_templ['dmg_min2'] != $dmg_min2) $sql_query .= "dmg_min2='$dmg_min2',"; if ($item_templ['dmg_max2'] != $dmg_max2) $sql_query .= "dmg_max2='$dmg_max2',"; if ($item_templ['dmg_type2'] != $dmg_type2) $sql_query .= "dmg_type2='$dmg_type2',"; if ($item_templ['armor'] != $armor) $sql_query .= "armor='$armor',"; if ($item_templ['holy_res'] != $holy_res) $sql_query .= "holy_res='$holy_res',"; if ($item_templ['fire_res'] != $fire_res) $sql_query .= "fire_res='$fire_res',"; if ($item_templ['nature_res'] != $nature_res) $sql_query .= "nature_res='$nature_res',"; if ($item_templ['frost_res'] != $frost_res) $sql_query .= "frost_res='$frost_res',"; if ($item_templ['shadow_res'] != $shadow_res) $sql_query .= "shadow_res='$shadow_res',"; if ($item_templ['arcane_res'] != $arcane_res) $sql_query .= "arcane_res='$arcane_res',"; if ($item_templ['delay'] != $delay) $sql_query .= "delay='$delay',"; if ($item_templ['ammo_type'] != $ammo_type) $sql_query .= "ammo_type='$ammo_type',"; if ($item_templ['RangedModRange'] != $RangedModRange) $sql_query .= "RangedModRange='$RangedModRange',"; if ($item_templ['spellid_1'] != $spellid_1) $sql_query .= "spellid_1='$spellid_1',"; if ($item_templ['spelltrigger_1'] != $spelltrigger_1) $sql_query .= "spelltrigger_1='$spelltrigger_1',"; if ($item_templ['spellcharges_1'] != $spellcharges_1) $sql_query .= "spellcharges_1='$spellcharges_1',"; if ($item_templ['spellppmRate_1'] != $spellppmRate_1) $sql_query .= "spellppmRate_1='$spellppmRate_1',"; if ($item_templ['spellcooldown_1'] != $spellcooldown_1) $sql_query .= "spellcooldown_1='$spellcooldown_1',"; if ($item_templ['spellcategory_1'] != $spellcategory_1) $sql_query .= "spellcategory_1='$spellcategory_1',"; if ($item_templ['spellcategorycooldown_1'] != $spellcategorycooldown_1) $sql_query .= "spellcategorycooldown_1='$spellcategorycooldown_1',"; if ($item_templ['spellid_2'] != $spellid_2) $sql_query .= "spellid_2='$spellid_2',"; if ($item_templ['spelltrigger_2'] != $spelltrigger_2) $sql_query .= "spelltrigger_2='$spelltrigger_2',"; if ($item_templ['spellcharges_2'] != $spellcharges_2) $sql_query .= "spellcharges_2='$spellcharges_2',"; if ($item_templ['spellppmRate_2'] != $spellppmRate_2) $sql_query .= "spellppmRate_2='$spellppmRate_2',"; if ($item_templ['spellcooldown_2'] != $spellcooldown_2) $sql_query .= "spellcooldown_2='$spellcooldown_2',"; if ($item_templ['spellcategory_2'] != $spellcategory_2) $sql_query .= "spellcategory_2='$spellcategory_2',"; if ($item_templ['spellcategorycooldown_2'] != $spellcategorycooldown_2) $sql_query .= "spellcategorycooldown_2='$spellcategorycooldown_2',"; if ($item_templ['spellid_3'] != $spellid_3) $sql_query .= "spellid_3='$spellid_3',"; if ($item_templ['spelltrigger_3'] != $spelltrigger_3) $sql_query .= "spelltrigger_3='$spelltrigger_3',"; if ($item_templ['spellcharges_3'] != $spellcharges_3) $sql_query .= "spellcharges_3='$spellcharges_3',"; if ($item_templ['spellppmRate_3'] != $spellppmRate_3) $sql_query .= "spellppmRate_3='$spellppmRate_3',"; if ($item_templ['spellcooldown_3'] != $spellcooldown_3) $sql_query .= "spellcooldown_3='$spellcooldown_3',"; if ($item_templ['spellcategory_3'] != $spellcategory_3) $sql_query .= "spellcategory_3='$spellcategory_3',"; if ($item_templ['spellcategorycooldown_3'] != $spellcategorycooldown_3) $sql_query .= "spellcategorycooldown_3='$spellcategorycooldown_3',"; if ($item_templ['spellid_4'] != $spellid_4) $sql_query .= "spellid_4='$spellid_4',"; if ($item_templ['spelltrigger_4'] != $spelltrigger_4) $sql_query .= "spelltrigger_4='$spelltrigger_4',"; if ($item_templ['spellcharges_4'] != $spellcharges_4) $sql_query .= "spellcharges_4='$spellcharges_4',"; if ($item_templ['spellppmRate_4'] != $spellppmRate_4) $sql_query .= "spellppmRate_4='$spellppmRate_4',"; if ($item_templ['spellcooldown_4'] != $spellcooldown_4) $sql_query .= "spellcooldown_4='$spellcooldown_4',"; if ($item_templ['spellcategory_4'] != $spellcategory_4) $sql_query .= "spellcategory_4='$spellcategory_4',"; if ($item_templ['spellcategorycooldown_4'] != $spellcategorycooldown_4) $sql_query .= "spellcategorycooldown_4='$spellcategorycooldown_4', "; if ($item_templ['spellid_5'] != $spellid_5) $sql_query .= "spellid_5='$spellid_5',"; if ($item_templ['spelltrigger_5'] != $spelltrigger_5) $sql_query .= "spelltrigger_5='$spelltrigger_5',"; if ($item_templ['spellcharges_5'] != $spellcharges_5) $sql_query .= "spellcharges_5='$spellcharges_5',"; if ($item_templ['spellppmRate_5'] != $spellppmRate_5) $sql_query .= "spellppmRate_5='$spellppmRate_5',"; if ($item_templ['spellcooldown_5'] != $spellcooldown_5) $sql_query .= "spellcooldown_5='$spellcooldown_5',"; if ($item_templ['spellcategory_5'] != $spellcategory_5) $sql_query .= "spellcategory_5='$spellcategory_5',"; if ($item_templ['spellcategorycooldown_5'] != $spellcategorycooldown_5) $sql_query .= "spellcategorycooldown_5='$spellcategorycooldown_5',"; if ($item_templ['bonding'] != $bonding) $sql_query .= "bonding='$bonding',"; if ($item_templ['description'] != $description) $sql_query .= "description='$description',"; if ($item_templ['PageText'] != $PageText) $sql_query .= "PageText='$PageText',"; if ($item_templ['LanguageID'] != $LanguageID) $sql_query .= "LanguageID='$LanguageID',"; if ($item_templ['PageMaterial'] != $PageMaterial) $sql_query .= "PageMaterial='$PageMaterial',"; if ($item_templ['startquest'] != $startquest) $sql_query .= "startquest='$startquest',"; if ($item_templ['lockid'] != $lockid) $sql_query .= "lockid='$lockid',"; if ($item_templ['Material'] != $Material) $sql_query .= "Material='$Material',"; if ($item_templ['sheath'] != $sheath) $sql_query .= "sheath='$sheath',"; if ($item_templ['RandomProperty'] != $RandomProperty) $sql_query .= "RandomProperty='$RandomProperty',"; if ($item_templ['block'] != $block) $sql_query .= "block='$block',"; if ($item_templ['itemset'] != $itemset) $sql_query .= "itemset='$itemset',"; if ($item_templ['MaxDurability'] != $MaxDurability) $sql_query .= "MaxDurability='$MaxDurability',"; if ($item_templ['area'] != $area) $sql_query .= "area='$area',"; if ($item_templ['BagFamily'] != $BagFamily) $sql_query .= "BagFamily='$BagFamily',"; if ($item_templ['Map'] != $Map) $sql_query .= "Map='$Map',"; if ($item_templ['ScriptName'] != $ScriptName) $sql_query .= "ScriptName='$ScriptName',"; if ($item_templ['DisenchantID'] != $DisenchantID) $sql_query .= "DisenchantID='$DisenchantID',"; if ($item_templ['RequiredDisenchantSkill'] != $RequiredDisenchantSkill) $sql_query .= "RequiredDisenchantSkill='$RequiredDisenchantSkill',"; if ($item_templ['ArmorDamageModifier'] != $ArmorDamageModifier) $sql_query .= "ArmorDamageModifier='$ArmorDamageModifier',"; if ($item_templ['unk0'] != $unk0) $sql_query .= "unk0='$unk0',"; if ($item_templ['RandomSuffix'] != $RandomSuffix) $sql_query .= "RandomSuffix='$RandomSuffix',"; if ($item_templ['TotemCategory'] != $TotemCategory) $sql_query .= "TotemCategory='$TotemCategory',"; if ($item_templ['socketColor_1'] != $socketColor_1) $sql_query .= "socketColor_1='$socketColor_1',"; if ($item_templ['socketContent_1'] != $socketContent_1) $sql_query .= "socketContent_1='$socketContent_1',"; if ($item_templ['socketColor_2'] != $socketColor_2) $sql_query .= "socketColor_2='$socketColor_2',"; if ($item_templ['socketContent_2'] != $socketContent_2) $sql_query .= "socketContent_2='$socketContent_2',"; if ($item_templ['socketColor_3'] != $socketColor_3) $sql_query .= "socketColor_3='$socketColor_3',"; if ($item_templ['socketContent_3'] != $socketContent_3) $sql_query .= "socketContent_3='$socketContent_3',"; if ($item_templ['socketBonus'] != $socketBonus) $sql_query .= "socketBonus='$socketBonus',"; if ($item_templ['GemProperties'] != $GemProperties) $sql_query .= "GemProperties='$GemProperties',"; $sql->free_result($result); unset($item_templ); if (($sql_query == "UPDATE item_template SET ")&&(!$de_item)&&(!$del_de_items)){ $sql->close(); redirect("item.php?action=edit&entry=$entry&error=6"); } else { if ($sql_query != "UPDATE item_template SET "){ $sql_query[strlen($sql_query)-1] = " "; $sql_query .= " WHERE entry = '$entry';\n"; } else $sql_query = ""; } if ($de_item){ $sql_query .= "INSERT INTO disenchant_loot_template (entry, item, ChanceOrQuestChance, `groupid`, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2) VALUES ($DisenchantID,$de_item,'$de_ChanceOrQuestChance', '$de_groupid' ,$de_mincountOrRef ,$de_maxcount ,$de_lootcondition ,$de_condition_value1 ,$de_condition_value2);\n"; } if ($del_de_items){ foreach($del_de_items as $item_id) $sql_query .= "DELETE FROM disenchant_loot_template WHERE entry = $DisenchantID AND item = $item_id;\n"; } } else { $sql->close(); redirect("item.php?error=5"); } } else { $sql->close(); redirect("item.php?error=5"); } if ( isset($_POST['backup_op']) && ($_POST['backup_op'] == 1) ){ $sql->close(); Header("Content-type: application/octet-stream"); Header("Content-Disposition: attachment; filename=itemid_$entry.sql"); echo $sql_query; exit(); } 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("item.php?action=edit&entry=$entry&error=4"); else redirect("item.php"); } //####################################################################################################### // DELETE ITEM //####################################################################################################### function delete() { global $lang_global, $lang_item_edit, $output, $action_permission, $user_lvl; valid_login($action_permission['delete']); if(isset($_GET['entry'])) $entry = $_GET['entry']; else redirect("item.php?error=1"); $output .= "

{$lang_global['are_you_sure']}


{$lang_item_edit['item_id']}: $entry {$lang_global['will_be_erased']}

"; makebutton($lang_global['yes'], "item.php?action=do_delete&entry=$entry\" type=\"warn",130); makebutton($lang_global['no'], "item.php",130); $output .= "

"; } //######################################################################################################################## // DO DELETE ITEM //######################################################################################################################## function do_delete() { global $world_db, $realm_id, $action_permission, $user_lvl; valid_login($action_permission['delete']); if(isset($_GET['entry'])) $entry = $_GET['entry']; else redirect("item.php?error=1"); $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']); $result = $sqlw->query("DELETE FROM item_template WHERE entry = '$entry'"); redirect("item.php"); } //############################################################################# // MAIN //############################################################################# $err = (isset($_GET['error'])) ? $_GET['error'] : NULL; $output .= "
"; switch ($err) { case 1: $output .= "

{$lang_global['empty_fields']}

"; break; case 2: $output .= "

{$lang_item_edit['search_results']}

"; break; case 3: $output .= "

{$lang_item_edit['add_new_item']}

"; break; case 4: $output .= "

{$lang_item_edit['edit_item']}

"; break; case 5: $output .= "

{$lang_item_edit['err_adding_item']}

"; break; case 6: $output .= "

{$lang_item_edit['err_no_field_updated']}

"; break; default: //no error $output .= "

{$lang_item_edit['search_items']}

"; } $output .= "
"; $action = (isset($_GET['action'])) ? $_GET['action'] : NULL; switch ($action) { case "search": search(); break; case "do_search": do_search(); break; case "add_new": add_new(); break; case "do_update": do_update(); break; case "edit": edit(); break; case "delete": delete(); break; case "do_delete": do_delete(); break; default: search(); } require_once("footer.php"); ?>