Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- @include('../config/db_conf.php');
- $conn = mysqli_connect($host, $dbuser, $dbpass, $worlddb);
- if (!$conn) {
- die("Connection failed: " . mysqli_connect_error());
- }
- $entry = $_GET['entry'];
- $sql = "SELECT * FROM item_template WHERE entry = $entry";
- $result = mysqli_query($conn, $sql);
- if (mysqli_num_rows($result) > 0) {
- while($row = mysqli_fetch_assoc($result)) {
- $name = $row['name'];
- $quality = $row['Quality'];
- $bonding = $row['bonding'];
- $invtype = $row['InventoryType'];
- $class = $row['class'];
- $subclass = $row['subclass'];
- $contslots = $row['ContainerSlots'];
- $stat_type1 = $row['stat_type1'];
- $stat_type2 = $row['stat_type2'];
- $stat_type3 = $row['stat_type3'];
- $stat_type4 = $row['stat_type4'];
- $stat_type5 = $row['stat_type5'];
- $stat_type6 = $row['stat_type6'];
- $stat_type7 = $row['stat_type7'];
- $stat_type8 = $row['stat_type8'];
- $stat_type9 = $row['stat_type9'];
- $stat_type10 = $row['stat_type10'];
- $stat_value1 = $row['stat_value1'];
- $stat_value2 = $row['stat_value2'];
- $stat_value3 = $row['stat_value3'];
- $stat_value4 = $row['stat_value4'];
- $stat_value5 = $row['stat_value5'];
- $stat_value6 = $row['stat_value6'];
- $stat_value7 = $row['stat_value7'];
- $stat_value8 = $row['stat_value8'];
- $stat_value9 = $row['stat_value9'];
- $stat_value10 = $row['stat_value10'];
- $stat_type11 = $row['stat_type1'];
- $stat_type22 = $row['stat_type2'];
- $stat_type33 = $row['stat_type3'];
- $stat_type44 = $row['stat_type4'];
- $stat_type55 = $row['stat_type5'];
- $stat_type66 = $row['stat_type6'];
- $stat_type77 = $row['stat_type7'];
- $stat_type88 = $row['stat_type8'];
- $stat_type99 = $row['stat_type9'];
- $stat_type100 = $row['stat_type10'];
- $stat_type111 = $row['stat_type1'];
- $stat_type222 = $row['stat_type2'];
- $stat_type333 = $row['stat_type3'];
- $stat_type444 = $row['stat_type4'];
- $stat_type555 = $row['stat_type5'];
- $stat_type666 = $row['stat_type6'];
- $stat_type777 = $row['stat_type7'];
- $stat_type888 = $row['stat_type8'];
- $stat_type999 = $row['stat_type9'];
- $stat_type1000 = $row['stat_type10'];
- $durability = $row['MaxDurability'];
- $requiredlevel = $row['RequiredLevel'];
- $itemlevel = $row['ItemLevel'];
- }
- } else {
- echo "0 results";
- }
- if($class == "0") {
- if($subclass=="0") {
- $itemtype = "Consumable";
- }
- }
- if($class == "0") {
- if($subclass=="1") {
- $itemtype = "Potion";
- }
- }
- if($class == "0") {
- if($subclass=="2") {
- $itemtype = "Elixir";
- }
- }
- if($class == "0") {
- if($subclass=="3") {
- $itemtype = "Flask";
- }
- }
- if($class == "0") {
- if($subclass=="4") {
- $itemtype = "Scroll";
- }
- }
- if($class == "0") {
- if($subclass=="5") {
- $itemtype = "Food & Drink";
- }
- }
- if($class == "0") {
- if($subclass=="6") {
- $itemtype = "Item Enhancement";
- }
- }
- if($class == "0") {
- if($subclass=="7") {
- $itemtype = "Bandage";
- }
- }
- if($class == "0") {
- if($subclass=="8") {
- $itemtype = "Other";
- }
- }
- if($class == "1") {
- if($subclass=="0") {
- $itemtype = "Bag";
- }
- }
- if($class == "1") {
- if($subclass=="1") {
- $itemtype = "Soul Bag";
- }
- }
- if($class == "1") {
- if($subclass=="2") {
- $itemtype = "Herb Bag";
- }
- }
- if($class == "1") {
- if($subclass=="3") {
- $itemtype = "Enchanting Bag";
- }
- }
- if($class == "1") {
- if($subclass=="4") {
- $itemtype = "Engineering Bag";
- }
- }
- if($class == "1") {
- if($subclass=="5") {
- $itemtype = "Gem Bag";
- }
- }
- if($class == "1") {
- if($subclass=="6") {
- $itemtype = "Mining Bag";
- }
- }
- if($class == "1") {
- if($subclass=="7") {
- $itemtype = "Leatherworking Bag";
- }
- }
- if($class == "1") {
- if($subclass=="8") {
- $itemtype = "Inscription Bag";
- }
- }
- if($class == "2") {
- if($subclass=="0") {
- $itemtype = "Axe";
- }
- }
- if($class == "2") {
- if($subclass=="1") {
- $itemtype = "Axe";
- }
- }
- if($class == "2") {
- if($subclass=="2") {
- $itemtype = "Bow";
- }
- }
- if($class == "2") {
- if($subclass=="3") {
- $itemtype = "Gun";
- }
- }
- if($class == "2") {
- if($subclass=="4") {
- $itemtype = "Mace";
- }
- }
- if($class == "2") {
- if($subclass=="5") {
- $itemtype = "Mace";
- }
- }
- if($class == "2") {
- if($subclass=="6") {
- $itemtype = "Polearm";
- }
- }
- if($class == "2") {
- if($subclass=="7") {
- $itemtype = "Sword";
- }
- }
- if($class == "2") {
- if($subclass=="8") {
- $itemtype = "Sword";
- }
- }
- if($class == "2") {
- if($subclass=="9") {
- $itemtype = "Obsolete";
- }
- }
- if($class == "2") {
- if($subclass=="10") {
- $itemtype = "Staff";
- }
- }
- if($class == "2") {
- if($subclass=="11") {
- $itemtype = "Exotic";
- }
- }
- if($class == "2") {
- if($subclass=="12") {
- $itemtype = "Exotic";
- }
- }
- if($class == "2") {
- if($subclass=="13") {
- $itemtype = "Fist Weapon";
- }
- }
- if($class == "2") {
- if($subclass=="14") {
- $itemtype = "Miscellaneous";
- }
- }
- if($class == "2") {
- if($subclass=="15") {
- $itemtype = "Dagger";
- }
- }
- if($class == "2") {
- if($subclass=="16") {
- $itemtype = "Thrown";
- }
- }
- if($class == "2") {
- if($subclass=="17") {
- $itemtype = "Spear";
- }
- }
- if($class == "2") {
- if($subclass=="18") {
- $itemtype = "Crossbow";
- }
- }
- if($class == "2") {
- if($subclass=="19") {
- $itemtype = "Wand";
- }
- }
- if($class == "2") {
- if($subclass=="20") {
- $itemtype = "Fishing Pole";
- }
- }
- if($class == "3") {
- if($subclass=="0") {
- $itemtype = "Red";
- }
- }
- if($class == "3") {
- if($subclass=="1") {
- $itemtype = "Blue";
- }
- }
- if($class == "3") {
- if($subclass=="2") {
- $itemtype = "Yellow";
- }
- }
- if($class == "3") {
- if($subclass=="3") {
- $itemtype = "Purple";
- }
- }
- if($class == "3") {
- if($subclass=="4") {
- $itemtype = "Green";
- }
- }
- if($class == "3") {
- if($subclass=="5") {
- $itemtype = "Orange";
- }
- }
- if($class == "3") {
- if($subclass=="6") {
- $itemtype = "Meta";
- }
- }
- if($class == "3") {
- if($subclass=="7") {
- $itemtype = "Simple";
- }
- }
- if($class == "3") {
- if($subclass=="8") {
- $itemtype = "Prismatic";
- }
- }
- if($class == "4") {
- if($subclass=="0") {
- $itemtype = "Miscellaneous";
- }
- }
- if($class == "4") {
- if($subclass=="1") {
- $itemtype = "Cloth";
- }
- }
- if($class == "4") {
- if($subclass=="2") {
- $itemtype = "Leather";
- }
- }
- if($class == "4") {
- if($subclass=="3") {
- $itemtype = "Mail";
- }
- }
- if($class == "4") {
- if($subclass=="4") {
- $itemtype = "Plate";
- }
- }
- if($class == "4") {
- if($subclass=="5") {
- $itemtype = "Buckler";
- }
- }
- if($class == "4") {
- if($subclass=="6") {
- $itemtype = "Shield";
- }
- }
- if($class == "4") {
- if($subclass=="7") {
- $itemtype = "Libram";
- }
- }
- if($class == "4") {
- if($subclass=="8") {
- $itemtype = "Idol";
- }
- }
- if($class == "4") {
- if($subclass=="9") {
- $itemtype = "Totem";
- }
- }
- if($class == "4") {
- if($subclass=="10") {
- $itemtype = "Sigil";
- }
- }
- if($class == "5") {
- if($subclass=="0") {
- $itemtype = "Reagent";
- }
- }
- if($class == "6") {
- if($subclass=="0") {
- $itemtype = "Wand";
- }
- }
- if($class == "6") {
- if($subclass=="1") {
- $itemtype = "Bolt";
- }
- }
- if($class == "6") {
- if($subclass=="2") {
- $itemtype = "Arrow";
- }
- }
- if($class == "6") {
- if($subclass=="3") {
- $itemtype = "Bullet";
- }
- }
- if($class == "6") {
- if($subclass=="4") {
- $itemtype = "Thrown";
- }
- }
- if($class == "7") {
- if($subclass=="0") {
- $itemtype = "Trade Goods";
- }
- }
- if($class == "7") {
- if($subclass=="1") {
- $itemtype = "Parts";
- }
- }
- if($class == "7") {
- if($subclass=="2") {
- $itemtype = "Explosives";
- }
- }
- if($class == "7") {
- if($subclass=="3") {
- $itemtype = "Explosives";
- }
- }
- if($class == "7") {
- if($subclass=="4") {
- $itemtype = "Jewelcrafting";
- }
- }
- if($class == "7") {
- if($subclass=="5") {
- $itemtype = "Cloth";
- }
- }
- if($class == "7") {
- if($subclass=="6") {
- $itemtype = "Leather";
- }
- }
- if($class == "7") {
- if($subclass=="7") {
- $itemtype = "Metal & Stone";
- }
- }
- if($class == "7") {
- if($subclass=="8") {
- $itemtype = "Meat";
- }
- }
- if($class == "7") {
- if($subclass=="9") {
- $itemtype = "Herb";
- }
- }
- if($class == "7") {
- if($subclass=="10") {
- $itemtype = "Elemental";
- }
- }
- if($class == "7") {
- if($subclass=="11") {
- $itemtype = "Other";
- }
- }
- if($class == "7") {
- if($subclass=="12") {
- $itemtype = "Enchanting";
- }
- }
- if($class == "7") {
- if($subclass=="13") {
- $itemtype = "Materials";
- }
- }
- if($class == "7") {
- if($subclass=="14") {
- $itemtype = "Armor Enchantment";
- }
- }
- if($class == "7") {
- if($subclass=="15") {
- $itemtype = "Weapon Enchantment";
- }
- }
- if($class == "8") {
- if($subclass=="0") {
- $itemtype = "Generic";
- }
- }
- if($class == "9") {
- if($subclass=="0") {
- $itemtype = "Book";
- }
- }
- if($class == "9") {
- if($subclass=="1") {
- $itemtype = "Leatherworking";
- }
- }
- if($class == "9") {
- if($subclass=="2") {
- $itemtype = "Tailoring";
- }
- }
- if($class == "9") {
- if($subclass=="3") {
- $itemtype = "Engineering";
- }
- }
- if($class == "9") {
- if($subclass=="4") {
- $itemtype = "Blacksmithing";
- }
- }
- if($class == "9") {
- if($subclass=="5") {
- $itemtype = "Cooking";
- }
- }
- if($class == "9") {
- if($subclass=="6") {
- $itemtype = "Alchemy";
- }
- }
- if($class == "9") {
- if($subclass=="7") {
- $itemtype = "First Aid";
- }
- }
- if($class == "9") {
- if($subclass=="8") {
- $itemtype = "Enchanting";
- }
- }
- if($class == "9") {
- if($subclass=="9") {
- $itemtype = "Fishing";
- }
- }
- if($class == "9") {
- if($subclass=="10") {
- $itemtype = "Jewelcrafting";
- }
- }
- if($class == "10") {
- if($subclass=="0") {
- $itemtype = "Money";
- }
- }
- if($class == "11") {
- if($subclass=="0") {
- $itemtype = "Quiver";
- }
- }
- if($class == "11") {
- if($subclass=="1") {
- $itemtype = "Quiver";
- }
- }
- if($class == "11") {
- if($subclass=="2") {
- $itemtype = "Quiver";
- }
- }
- if($class == "11") {
- if($subclass=="3") {
- $itemtype = "Ammo Pouch";
- }
- }
- if($class == "12") {
- if($subclass=="0") {
- $itemtype = "Quest";
- }
- }
- if($class == "13") {
- if($subclass=="0") {
- $itemtype = "Key";
- }
- }
- if($class == "13") {
- if($subclass=="1") {
- $itemtype = "Lockpick";
- }
- }
- if($class == "14") {
- if($subclass=="0") {
- $itemtype = "Permanent";
- }
- }
- if($class == "15") {
- if($subclass=="0") {
- $itemtype = "Junk";
- }
- }
- if($class == "15") {
- if($subclass=="1") {
- $itemtype = "Reagent";
- }
- }
- if($class == "15") {
- if($subclass=="2") {
- $itemtype = "Pet";
- }
- }
- if($class == "15") {
- if($subclass=="3") {
- $itemtype = "Holiday";
- }
- }
- if($class == "15") {
- if($subclass=="4") {
- $itemtype = "Other";
- }
- }
- if($class == "15") {
- if($subclass=="5") {
- $itemtype = "Mount";
- }
- }
- if($class == "16") {
- if($subclass=="1") {
- $itemtype = "Warrior";
- }
- }
- if($class == "16") {
- if($subclass=="2") {
- $itemtype = "Paladin";
- }
- }
- if($class == "16") {
- if($subclass=="3") {
- $itemtype = "Hunter";
- }
- }
- if($class == "16") {
- if($subclass=="4") {
- $itemtype = "Rogue";
- }
- }
- if($class == "16") {
- if($subclass=="5") {
- $itemtype = "Priest";
- }
- }
- if($class == "16") {
- if($subclass=="6") {
- $itemtype = "Death Knight";
- }
- }
- if($class == "16") {
- if($subclass=="7") {
- $itemtype = "Shaman";
- }
- }
- if($class == "16") {
- if($subclass=="8") {
- $itemtype = "Mage";
- }
- }
- if($class == "16") {
- if($subclass=="9") {
- $itemtype = "Warlock";
- }
- }
- if($class == "16") {
- if($subclass=="11") {
- $itemtype = "Druid";
- }
- }
- if($class == "2") {
- if($invtype=="13") {
- $invtype = "One-Hand";
- }
- }
- if($class == "2") {
- if($invtype=="17") {
- $invtype = "Two-Hand";
- }
- }
- if($class == "2") {
- if($invtype=="21") {
- $invtype = "Main-Hand";
- }
- }
- if($class == "2") {
- if($invtype=="22") {
- $invtype = "Off-Hand";
- }
- }
- ///////////////////////////////////////////////////////////
- if($class == "4") {
- if($invtype=="0") {
- $invtype="Non equipable";
- }
- }
- if($class == "4") {
- if($invtype=="1") {
- $invtype="Head";
- }
- }
- if($class == "4") {
- if($invtype=="2") {
- $invtype="Neck";
- }
- }
- if($class == "4") {
- if($invtype=="3") {
- $invtype="Shoulder";
- }
- }
- if($class == "4") {
- if($invtype=="5") {
- $invtype="Chest";
- }
- }
- if($class == "4") {
- if($invtype=="6") {
- $invtype="Waist";
- }
- }
- if($class == "4") {
- if($invtype=="7") {
- $invtype="Legs";
- }
- }
- if($class == "4") {
- if($invtype=="8") {
- $invtype="Feet";
- }
- }
- if($class == "4") {
- if($invtype=="9") {
- $invtype="Wrists";
- }
- }
- if($class == "4") {
- if($invtype=="10") {
- $invtype="Hands";
- }
- }
- if($class == "4") {
- if($invtype=="11") {
- $invtype="Finger";
- }
- }
- if($class == "4") {
- if($invtype=="12") {
- $invtype="Trinket";
- }
- }
- if($class == "4") {
- if($invtype=="14") {
- $invtype="Shield";
- }
- }
- if($class == "4") {
- if($invtype=="16") {
- $invtype="Back";
- }
- }
- if($class == "1" && $subclass == "0" && $invtype=="18") {
- $invtype="$contslots Slot Bag";
- $itemtype="";
- }
- if($class == "1" && $subclass == "1" && $invtype=="18") {
- $invtype="$contslots Slot Soul Bag";
- $itemtype="";
- }
- if($class == "1" && $subclass == "2" && $invtype=="18") {
- $invtype="$contslots Slot Herb Bag";
- $itemtype="";
- }
- if($class == "1" && $subclass == "3" && $invtype=="18") {
- $invtype="$contslots Slot Enchanting Bag";
- $itemtype="";
- }
- if($class == "1" && $subclass == "4" && $invtype=="18") {
- $invtype="$contslots Slot Engineering Bag";
- $itemtype="";
- }
- if($class == "1" && $subclass == "5" && $invtype=="18") {
- $invtype="$contslots Slot Gem Bag";
- $itemtype="";
- }
- if($class == "1" && $subclass == "6" && $invtype=="18") {
- $invtype="$contslots Slot Mining Bag";
- $itemtype="";
- }
- if($class == "1" && $subclass == "7" && $invtype=="18") {
- $invtype="$contslots Slot Leatherworking Bag";
- $itemtype="";
- }
- if($class == "1" && $subclass == "8" && $invtype=="18") {
- $invtype="$contslots Slot Inscription Bag";
- $itemtype="";
- }
- if($class == "4") {
- if($invtype=="19") {
- $invtype="Tabard";
- }
- }
- if($class == "4") {
- if($invtype=="20") {
- $invtype="Robe";
- }
- }
- if($class == "4") {
- if($invtype=="23") {
- $invtype="Held in Off-Hand";
- }
- }
- if($class == "6") {
- if($invtype=="24") {
- $invtype="Ammo";
- }
- }
- if($class == "11" && $subclass < "3" && $invtype=="18") {
- $invtype="$contslots Slot Quiver";
- $itemtype="";
- }
- if($class == "11" && $subclass == "3" && $invtype=="18") {
- $invtype="$contslots Ammo Pouch";
- $itemtype="";
- }
- if($class == "4") {
- if($invtype=="28") {
- $invtype="Relic";
- }
- }
- ///////////////////////////////////////////////////////////
- switch($quality) {
- case"0":
- $itemname = "<font color='#9d9d9d'>$name</font>";
- break;
- case"1":
- $itemname = "<font color='#FFFFFF'>$name</font>";
- break;
- case"2":
- $itemname = "<font color='#1eff00'>$name</font>";
- break;
- case"3":
- $itemname = "<font color='#0070dd'>$name</font>";
- break;
- case"4":
- $itemname = "<font color='#a335ee'>$name</font>";
- break;
- case"5":
- $itemname = "<font color='#ff8000'>$name</font>";
- break;
- case"6":
- $itemname = "<font color='#e6cc80'>$name</font>";
- break;
- case"7":
- $itemname = "<font color='#e6cc80'>$name</font>";
- break;
- }
- switch($bonding) {
- case"0":
- $bonding = "";
- break;
- case"1":
- $bonding = "Binds when picked up";
- break;
- case"2":
- $bonding = "Binds when equipped";
- break;
- case"3":
- $bonding = "Binds when used";
- break;
- case"4":
- $bonding = "Quest item";
- break;
- case"5":
- $bonding = "Quest item";
- break;
- }
- switch($stat_type11) {
- case"12":
- $stat_type11="Defense Rating";
- break;
- case"13":
- $stat_type11="Dodge Rating";
- break;
- case"14":
- $stat_type11="Parry Rating";
- break;
- case"15":
- $stat_type11="Block Rating";
- break;
- case"16":
- $stat_type11="Melee Hit Rating";
- break;
- case"17":
- $stat_type11="Ranged Hit Rating";
- break;
- case"18":
- $stat_type11="Spell Hit Rating";
- break;
- case"19":
- $stat_type11="Melee Crit Rating";
- break;
- case"20":
- $stat_type11="Ranged Crit Rating";
- break;
- case"21":
- $stat_type11="Spell Crit Rating";
- break;
- case"22":
- $stat_type11="Melee Hit Taken Rating";
- break;
- case"23":
- $stat_type11="Ranged Hit Taken Rating";
- break;
- case"24":
- $stat_type11="Spell Hit Taken Rating";
- break;
- case"25":
- $stat_type11="Melee Crit Taken Rating";
- break;
- case"26":
- $stat_type11="Ranged Crit Taken Rating";
- break;
- case"27":
- $stat_type11="Spell Crit Taken Rating";
- break;
- case"28":
- $stat_type11="Melee Haste Rating";
- break;
- case"29":
- $stat_type11="Ranged Haste Rating";
- break;
- case"30":
- $stat_type11="Spell Haste Rating";
- break;
- case"31":
- $stat_type11="Hit Rating";
- break;
- case"32":
- $stat_type11="Crit Rating";
- break;
- case"33":
- $stat_type11="Hit Taken Rating";
- break;
- case"34":
- $stat_type11="Crit Taken Rating";
- break;
- case"35":
- $stat_type11="Resilience Rating";
- break;
- case"36":
- $stat_type11="Haste Rating";
- break;
- case"37":
- $stat_type11="Expertise Rating";
- break;
- case"38":
- $stat_type11="Attack Power";
- break;
- case"39":
- $stat_type11="Ranged Attack Power";
- break;
- case"41":
- $stat_type11="Spell Healing Rating";
- break;
- case"42":
- $stat_type11="Spell Damage Rating";
- break;
- case"43":
- $stat_type11="Mana Regeneration";
- break;
- case"44":
- $stat_type11="Armor Penetration";
- break;
- case"45":
- $stat_type11="Spell Power";
- break;
- case"46":
- $stat_type11="Health Regeneration";
- break;
- case"47":
- $stat_type11="Spell Penetration";
- break;
- case"48":
- $stat_type11="Block Value";
- break;
- }
- switch($stat_type1) {
- case"0":
- $stat_type1="Mana";
- break;
- case"1":
- $stat_type1="Health";
- break;
- case"3":
- $stat_type1="Agility";
- break;
- case"4":
- $stat_type1="Strength";
- break;
- case"5":
- $stat_type1="Intellect";
- break;
- case"6":
- $stat_type1="Spirit";
- break;
- case"7":
- $stat_type1="Stamina";
- break;
- }
- switch($stat_type22) {
- case"12":
- $stat_type22="Defense Rating";
- break;
- case"13":
- $stat_type22="Dodge Rating";
- break;
- case"14":
- $stat_type22="Parry Rating";
- break;
- case"15":
- $stat_type22="Block Rating";
- break;
- case"16":
- $stat_type22="Melee Hit Rating";
- break;
- case"17":
- $stat_type22="Ranged Hit Rating";
- break;
- case"18":
- $stat_type22="Spell Hit Rating";
- break;
- case"19":
- $stat_type22="Melee Crit Rating";
- break;
- case"20":
- $stat_type22="Ranged Crit Rating";
- break;
- case"21":
- $stat_type22="Spell Crit Rating";
- break;
- case"22":
- $stat_type22="Melee Hit Taken Rating";
- break;
- case"23":
- $stat_type22="Ranged Hit Taken Rating";
- break;
- case"24":
- $stat_type22="Spell Hit Taken Rating";
- break;
- case"25":
- $stat_type22="Melee Crit Taken Rating";
- break;
- case"26":
- $stat_type22="Ranged Crit Taken Rating";
- break;
- case"27":
- $stat_type22="Spell Crit Taken Rating";
- break;
- case"28":
- $stat_type22="Melee Haste Rating";
- break;
- case"29":
- $stat_type22="Ranged Haste Rating";
- break;
- case"30":
- $stat_type22="Spell Haste Rating";
- break;
- case"31":
- $stat_type22="Hit Rating";
- break;
- case"32":
- $stat_type22="Crit Rating";
- break;
- case"33":
- $stat_type22="Hit Taken Rating";
- break;
- case"34":
- $stat_type22="Crit Taken Rating";
- break;
- case"35":
- $stat_type22="Resilience Rating";
- break;
- case"36":
- $stat_type22="Haste Rating";
- break;
- case"37":
- $stat_type22="Expertise Rating";
- break;
- case"38":
- $stat_type22="Attack Power";
- break;
- case"39":
- $stat_type22="Ranged Attack Power";
- break;
- case"41":
- $stat_type22="Spell Healing Rating";
- break;
- case"42":
- $stat_type22="Spell Damage Rating";
- break;
- case"43":
- $stat_type22="Mana Regeneration";
- break;
- case"44":
- $stat_type22="Armor Penetration";
- break;
- case"45":
- $stat_type22="Spell Power";
- break;
- case"46":
- $stat_type22="Health Regeneration";
- break;
- case"47":
- $stat_type22="Spell Penetration";
- break;
- case"48":
- $stat_type22="Block Value";
- break;
- }
- switch($stat_type2) {
- case"0":
- $stat_type2="Mana";
- break;
- case"1":
- $stat_type2="Health";
- break;
- case"3":
- $stat_type2="Agility";
- break;
- case"4":
- $stat_type2="Strength";
- break;
- case"5":
- $stat_type2="Intellect";
- break;
- case"6":
- $stat_type2="Spirit";
- break;
- case"7":
- $stat_type2="Stamina";
- break;
- }
- switch($stat_type33) {
- case"12":
- $stat_type33="Defense Rating";
- break;
- case"13":
- $stat_type33="Dodge Rating";
- break;
- case"14":
- $stat_type33="Parry Rating";
- break;
- case"15":
- $stat_type33="Block Rating";
- break;
- case"16":
- $stat_type33="Melee Hit Rating";
- break;
- case"17":
- $stat_type33="Ranged Hit Rating";
- break;
- case"18":
- $stat_type33="Spell Hit Rating";
- break;
- case"19":
- $stat_type33="Melee Crit Rating";
- break;
- case"20":
- $stat_type33="Ranged Crit Rating";
- break;
- case"21":
- $stat_type33="Spell Crit Rating";
- break;
- case"22":
- $stat_type33="Melee Hit Taken Rating";
- break;
- case"23":
- $stat_type33="Ranged Hit Taken Rating";
- break;
- case"24":
- $stat_type33="Spell Hit Taken Rating";
- break;
- case"25":
- $stat_type33="Melee Crit Taken Rating";
- break;
- case"26":
- $stat_type33="Ranged Crit Taken Rating";
- break;
- case"27":
- $stat_type33="Spell Crit Taken Rating";
- break;
- case"28":
- $stat_type33="Melee Haste Rating";
- break;
- case"29":
- $stat_type33="Ranged Haste Rating";
- break;
- case"30":
- $stat_type33="Spell Haste Rating";
- break;
- case"31":
- $stat_type33="Hit Rating";
- break;
- case"32":
- $stat_type33="Crit Rating";
- break;
- case"33":
- $stat_type33="Hit Taken Rating";
- break;
- case"34":
- $stat_type33="Crit Taken Rating";
- break;
- case"35":
- $stat_type33="Resilience Rating";
- break;
- case"36":
- $stat_type33="Haste Rating";
- break;
- case"37":
- $stat_type33="Expertise Rating";
- break;
- case"38":
- $stat_type33="Attack Power";
- break;
- case"39":
- $stat_type33="Ranged Attack Power";
- break;
- case"41":
- $stat_type33="Spell Healing Rating";
- break;
- case"42":
- $stat_type33="Spell Damage Rating";
- break;
- case"43":
- $stat_type33="Mana Regeneration";
- break;
- case"44":
- $stat_type33="Armor Penetration";
- break;
- case"45":
- $stat_type33="Spell Power";
- break;
- case"46":
- $stat_type33="Health Regeneration";
- break;
- case"47":
- $stat_type33="Spell Penetration";
- break;
- case"48":
- $stat_type33="Block Value";
- break;
- }
- switch($stat_type3) {
- case"0":
- $stat_type3="Mana";
- break;
- case"1":
- $stat_type3="Health";
- break;
- case"3":
- $stat_type3="Agility";
- break;
- case"4":
- $stat_type3="Strength";
- break;
- case"5":
- $stat_type3="Intellect";
- break;
- case"6":
- $stat_type3="Spirit";
- break;
- case"7":
- $stat_type3="Stamina";
- break;
- }
- switch($stat_type44) {
- case"12":
- $stat_type44="Defense Rating";
- break;
- case"13":
- $stat_type44="Dodge Rating";
- break;
- case"14":
- $stat_type44="Parry Rating";
- break;
- case"15":
- $stat_type44="Block Rating";
- break;
- case"16":
- $stat_type44="Melee Hit Rating";
- break;
- case"17":
- $stat_type44="Ranged Hit Rating";
- break;
- case"18":
- $stat_type44="Spell Hit Rating";
- break;
- case"19":
- $stat_type44="Melee Crit Rating";
- break;
- case"20":
- $stat_type44="Ranged Crit Rating";
- break;
- case"21":
- $stat_type44="Spell Crit Rating";
- break;
- case"22":
- $stat_type44="Melee Hit Taken Rating";
- break;
- case"23":
- $stat_type44="Ranged Hit Taken Rating";
- break;
- case"24":
- $stat_type44="Spell Hit Taken Rating";
- break;
- case"25":
- $stat_type44="Melee Crit Taken Rating";
- break;
- case"26":
- $stat_type44="Ranged Crit Taken Rating";
- break;
- case"27":
- $stat_type44="Spell Crit Taken Rating";
- break;
- case"28":
- $stat_type44="Melee Haste Rating";
- break;
- case"29":
- $stat_type44="Ranged Haste Rating";
- break;
- case"30":
- $stat_type44="Spell Haste Rating";
- break;
- case"31":
- $stat_type44="Hit Rating";
- break;
- case"32":
- $stat_type44="Crit Rating";
- break;
- case"33":
- $stat_type44="Hit Taken Rating";
- break;
- case"34":
- $stat_type44="Crit Taken Rating";
- break;
- case"35":
- $stat_type44="Resilience Rating";
- break;
- case"36":
- $stat_type44="Haste Rating";
- break;
- case"37":
- $stat_type44="Expertise Rating";
- break;
- case"38":
- $stat_type44="Attack Power";
- break;
- case"39":
- $stat_type44="Ranged Attack Power";
- break;
- case"41":
- $stat_type44="Spell Healing Rating";
- break;
- case"42":
- $stat_type44="Spell Damage Rating";
- break;
- case"43":
- $stat_type44="Mana Regeneration";
- break;
- case"44":
- $stat_type44="Armor Penetration";
- break;
- case"45":
- $stat_type44="Spell Power";
- break;
- case"46":
- $stat_type44="Health Regeneration";
- break;
- case"47":
- $stat_type44="Spell Penetration";
- break;
- case"48":
- $stat_type44="Block Value";
- break;
- }
- switch($stat_type4) {
- case"0":
- $stat_type4="Mana";
- break;
- case"1":
- $stat_type4="Health";
- break;
- case"3":
- $stat_type4="Agility";
- break;
- case"4":
- $stat_type4="Strength";
- break;
- case"5":
- $stat_type4="Intellect";
- break;
- case"6":
- $stat_type4="Spirit";
- break;
- case"7":
- $stat_type4="Stamina";
- break;
- }
- switch($stat_type55) {
- case"12":
- $stat_type55="Defense Rating";
- break;
- case"13":
- $stat_type55="Dodge Rating";
- break;
- case"14":
- $stat_type55="Parry Rating";
- break;
- case"15":
- $stat_type55="Block Rating";
- break;
- case"16":
- $stat_type55="Melee Hit Rating";
- break;
- case"17":
- $stat_type55="Ranged Hit Rating";
- break;
- case"18":
- $stat_type55="Spell Hit Rating";
- break;
- case"19":
- $stat_type55="Melee Crit Rating";
- break;
- case"20":
- $stat_type55="Ranged Crit Rating";
- break;
- case"21":
- $stat_type55="Spell Crit Rating";
- break;
- case"22":
- $stat_type55="Melee Hit Taken Rating";
- break;
- case"23":
- $stat_type55="Ranged Hit Taken Rating";
- break;
- case"24":
- $stat_type55="Spell Hit Taken Rating";
- break;
- case"25":
- $stat_type55="Melee Crit Taken Rating";
- break;
- case"26":
- $stat_type55="Ranged Crit Taken Rating";
- break;
- case"27":
- $stat_type55="Spell Crit Taken Rating";
- break;
- case"28":
- $stat_type55="Melee Haste Rating";
- break;
- case"29":
- $stat_type55="Ranged Haste Rating";
- break;
- case"30":
- $stat_type55="Spell Haste Rating";
- break;
- case"31":
- $stat_type55="Hit Rating";
- break;
- case"32":
- $stat_type55="Crit Rating";
- break;
- case"33":
- $stat_type55="Hit Taken Rating";
- break;
- case"34":
- $stat_type55="Crit Taken Rating";
- break;
- case"35":
- $stat_type55="Resilience Rating";
- break;
- case"36":
- $stat_type55="Haste Rating";
- break;
- case"37":
- $stat_type55="Expertise Rating";
- break;
- case"38":
- $stat_type55="Attack Power";
- break;
- case"39":
- $stat_type55="Ranged Attack Power";
- break;
- case"41":
- $stat_type55="Spell Healing Rating";
- break;
- case"42":
- $stat_type55="Spell Damage Rating";
- break;
- case"43":
- $stat_type55="Mana Regeneration";
- break;
- case"44":
- $stat_type55="Armor Penetration";
- break;
- case"45":
- $stat_type55="Spell Power";
- break;
- case"46":
- $stat_type55="Health Regeneration";
- break;
- case"47":
- $stat_type55="Spell Penetration";
- break;
- case"48":
- $stat_type55="Block Value";
- break;
- }
- switch($stat_type5) {
- case"0":
- $stat_type5="Mana";
- break;
- case"1":
- $stat_type5="Health";
- break;
- case"3":
- $stat_type5="Agility";
- break;
- case"4":
- $stat_type5="Strength";
- break;
- case"5":
- $stat_type5="Intellect";
- break;
- case"6":
- $stat_type5="Spirit";
- break;
- case"7":
- $stat_type5="Stamina";
- break;
- }
- switch($stat_type66) {
- case"12":
- $stat_type66="Defense Rating";
- break;
- case"13":
- $stat_type66="Dodge Rating";
- break;
- case"14":
- $stat_type66="Parry Rating";
- break;
- case"15":
- $stat_type66="Block Rating";
- break;
- case"16":
- $stat_type66="Melee Hit Rating";
- break;
- case"17":
- $stat_type66="Ranged Hit Rating";
- break;
- case"18":
- $stat_type66="Spell Hit Rating";
- break;
- case"19":
- $stat_type66="Melee Crit Rating";
- break;
- case"20":
- $stat_type66="Ranged Crit Rating";
- break;
- case"21":
- $stat_type66="Spell Crit Rating";
- break;
- case"22":
- $stat_type66="Melee Hit Taken Rating";
- break;
- case"23":
- $stat_type66="Ranged Hit Taken Rating";
- break;
- case"24":
- $stat_type66="Spell Hit Taken Rating";
- break;
- case"25":
- $stat_type66="Melee Crit Taken Rating";
- break;
- case"26":
- $stat_type66="Ranged Crit Taken Rating";
- break;
- case"27":
- $stat_type66="Spell Crit Taken Rating";
- break;
- case"28":
- $stat_type66="Melee Haste Rating";
- break;
- case"29":
- $stat_type66="Ranged Haste Rating";
- break;
- case"30":
- $stat_type66="Spell Haste Rating";
- break;
- case"31":
- $stat_type66="Hit Rating";
- break;
- case"32":
- $stat_type66="Crit Rating";
- break;
- case"33":
- $stat_type66="Hit Taken Rating";
- break;
- case"34":
- $stat_type66="Crit Taken Rating";
- break;
- case"35":
- $stat_type66="Resilience Rating";
- break;
- case"36":
- $stat_type66="Haste Rating";
- break;
- case"37":
- $stat_type66="Expertise Rating";
- break;
- case"38":
- $stat_type66="Attack Power";
- break;
- case"39":
- $stat_type66="Ranged Attack Power";
- break;
- case"41":
- $stat_type66="Spell Healing Rating";
- break;
- case"42":
- $stat_type66="Spell Damage Rating";
- break;
- case"43":
- $stat_type66="Mana Regeneration";
- break;
- case"44":
- $stat_type66="Armor Penetration";
- break;
- case"45":
- $stat_type66="Spell Power";
- break;
- case"46":
- $stat_type66="Health Regeneration";
- break;
- case"47":
- $stat_type66="Spell Penetration";
- break;
- case"48":
- $stat_type66="Block Value";
- break;
- }
- switch($stat_type6) {
- case"0":
- $stat_type6="Mana";
- break;
- case"1":
- $stat_type6="Health";
- break;
- case"3":
- $stat_type6="Agility";
- break;
- case"4":
- $stat_type6="Strength";
- break;
- case"5":
- $stat_type6="Intellect";
- break;
- case"6":
- $stat_type6="Spirit";
- break;
- case"7":
- $stat_type6="Stamina";
- break;
- }
- switch($stat_type77) {
- case"12":
- $stat_type77="Defense Rating";
- break;
- case"13":
- $stat_type77="Dodge Rating";
- break;
- case"14":
- $stat_type77="Parry Rating";
- break;
- case"15":
- $stat_type77="Block Rating";
- break;
- case"16":
- $stat_type77="Melee Hit Rating";
- break;
- case"17":
- $stat_type77="Ranged Hit Rating";
- break;
- case"18":
- $stat_type77="Spell Hit Rating";
- break;
- case"19":
- $stat_type77="Melee Crit Rating";
- break;
- case"20":
- $stat_type77="Ranged Crit Rating";
- break;
- case"21":
- $stat_type77="Spell Crit Rating";
- break;
- case"22":
- $stat_type77="Melee Hit Taken Rating";
- break;
- case"23":
- $stat_type77="Ranged Hit Taken Rating";
- break;
- case"24":
- $stat_type77="Spell Hit Taken Rating";
- break;
- case"25":
- $stat_type77="Melee Crit Taken Rating";
- break;
- case"26":
- $stat_type77="Ranged Crit Taken Rating";
- break;
- case"27":
- $stat_type77="Spell Crit Taken Rating";
- break;
- case"28":
- $stat_type77="Melee Haste Rating";
- break;
- case"29":
- $stat_type77="Ranged Haste Rating";
- break;
- case"30":
- $stat_type77="Spell Haste Rating";
- break;
- case"31":
- $stat_type77="Hit Rating";
- break;
- case"32":
- $stat_type77="Crit Rating";
- break;
- case"33":
- $stat_type77="Hit Taken Rating";
- break;
- case"34":
- $stat_type77="Crit Taken Rating";
- break;
- case"35":
- $stat_type77="Resilience Rating";
- break;
- case"36":
- $stat_type77="Haste Rating";
- break;
- case"37":
- $stat_type77="Expertise Rating";
- break;
- case"38":
- $stat_type77="Attack Power";
- break;
- case"39":
- $stat_type77="Ranged Attack Power";
- break;
- case"41":
- $stat_type77="Spell Healing Rating";
- break;
- case"42":
- $stat_type77="Spell Damage Rating";
- break;
- case"43":
- $stat_type77="Mana Regeneration";
- break;
- case"44":
- $stat_type77="Armor Penetration";
- break;
- case"45":
- $stat_type77="Spell Power";
- break;
- case"46":
- $stat_type77="Health Regeneration";
- break;
- case"47":
- $stat_type77="Spell Penetration";
- break;
- case"48":
- $stat_type77="Block Value";
- break;
- }
- switch($stat_type7) {
- case"0":
- $stat_type7="Mana";
- break;
- case"1":
- $stat_type7="Health";
- break;
- case"3":
- $stat_type7="Agility";
- break;
- case"4":
- $stat_type7="Strength";
- break;
- case"5":
- $stat_type7="Intellect";
- break;
- case"6":
- $stat_type7="Spirit";
- break;
- case"7":
- $stat_type7="Stamina";
- break;
- }
- switch($stat_type88) {
- case"12":
- $stat_type88="Defense Rating";
- break;
- case"13":
- $stat_type88="Dodge Rating";
- break;
- case"14":
- $stat_type88="Parry Rating";
- break;
- case"15":
- $stat_type88="Block Rating";
- break;
- case"16":
- $stat_type88="Melee Hit Rating";
- break;
- case"17":
- $stat_type88="Ranged Hit Rating";
- break;
- case"18":
- $stat_type88="Spell Hit Rating";
- break;
- case"19":
- $stat_type88="Melee Crit Rating";
- break;
- case"20":
- $stat_type88="Ranged Crit Rating";
- break;
- case"21":
- $stat_type88="Spell Crit Rating";
- break;
- case"22":
- $stat_type88="Melee Hit Taken Rating";
- break;
- case"23":
- $stat_type88="Ranged Hit Taken Rating";
- break;
- case"24":
- $stat_type88="Spell Hit Taken Rating";
- break;
- case"25":
- $stat_type88="Melee Crit Taken Rating";
- break;
- case"26":
- $stat_type88="Ranged Crit Taken Rating";
- break;
- case"27":
- $stat_type88="Spell Crit Taken Rating";
- break;
- case"28":
- $stat_type88="Melee Haste Rating";
- break;
- case"29":
- $stat_type88="Ranged Haste Rating";
- break;
- case"30":
- $stat_type88="Spell Haste Rating";
- break;
- case"31":
- $stat_type88="Hit Rating";
- break;
- case"32":
- $stat_type88="Crit Rating";
- break;
- case"33":
- $stat_type88="Hit Taken Rating";
- break;
- case"34":
- $stat_type88="Crit Taken Rating";
- break;
- case"35":
- $stat_type88="Resilience Rating";
- break;
- case"36":
- $stat_type88="Haste Rating";
- break;
- case"37":
- $stat_type88="Expertise Rating";
- break;
- case"38":
- $stat_type88="Attack Power";
- break;
- case"39":
- $stat_type88="Ranged Attack Power";
- break;
- case"41":
- $stat_type88="Spell Healing Rating";
- break;
- case"42":
- $stat_type88="Spell Damage Rating";
- break;
- case"43":
- $stat_type88="Mana Regeneration";
- break;
- case"44":
- $stat_type88="Armor Penetration";
- break;
- case"45":
- $stat_type88="Spell Power";
- break;
- case"46":
- $stat_type88="Health Regeneration";
- break;
- case"47":
- $stat_type88="Spell Penetration";
- break;
- case"48":
- $stat_type88="Block Value";
- break;
- }
- switch($stat_type8) {
- case"0":
- $stat_type8="Mana";
- break;
- case"1":
- $stat_type8="Health";
- break;
- case"3":
- $stat_type8="Agility";
- break;
- case"4":
- $stat_type8="Strength";
- break;
- case"5":
- $stat_type8="Intellect";
- break;
- case"6":
- $stat_type8="Spirit";
- break;
- case"7":
- $stat_type8="Stamina";
- break;
- }
- switch($stat_type99) {
- case"12":
- $stat_type99="Defense Rating";
- break;
- case"13":
- $stat_type99="Dodge Rating";
- break;
- case"14":
- $stat_type99="Parry Rating";
- break;
- case"15":
- $stat_type99="Block Rating";
- break;
- case"16":
- $stat_type99="Melee Hit Rating";
- break;
- case"17":
- $stat_type99="Ranged Hit Rating";
- break;
- case"18":
- $stat_type99="Spell Hit Rating";
- break;
- case"19":
- $stat_type99="Melee Crit Rating";
- break;
- case"20":
- $stat_type99="Ranged Crit Rating";
- break;
- case"21":
- $stat_type99="Spell Crit Rating";
- break;
- case"22":
- $stat_type99="Melee Hit Taken Rating";
- break;
- case"23":
- $stat_type99="Ranged Hit Taken Rating";
- break;
- case"24":
- $stat_type99="Spell Hit Taken Rating";
- break;
- case"25":
- $stat_type99="Melee Crit Taken Rating";
- break;
- case"26":
- $stat_type99="Ranged Crit Taken Rating";
- break;
- case"27":
- $stat_type99="Spell Crit Taken Rating";
- break;
- case"28":
- $stat_type99="Melee Haste Rating";
- break;
- case"29":
- $stat_type99="Ranged Haste Rating";
- break;
- case"30":
- $stat_type99="Spell Haste Rating";
- break;
- case"31":
- $stat_type99="Hit Rating";
- break;
- case"32":
- $stat_type99="Crit Rating";
- break;
- case"33":
- $stat_type99="Hit Taken Rating";
- break;
- case"34":
- $stat_type99="Crit Taken Rating";
- break;
- case"35":
- $stat_type99="Resilience Rating";
- break;
- case"36":
- $stat_type99="Haste Rating";
- break;
- case"37":
- $stat_type99="Expertise Rating";
- break;
- case"38":
- $stat_type99="Attack Power";
- break;
- case"39":
- $stat_type99="Ranged Attack Power";
- break;
- case"41":
- $stat_type99="Spell Healing Rating";
- break;
- case"42":
- $stat_type99="Spell Damage Rating";
- break;
- case"43":
- $stat_type99="Mana Regeneration";
- break;
- case"44":
- $stat_type99="Armor Penetration";
- break;
- case"45":
- $stat_type99="Spell Power";
- break;
- case"46":
- $stat_type99="Health Regeneration";
- break;
- case"47":
- $stat_type99="Spell Penetration";
- break;
- case"48":
- $stat_type99="Block Value";
- break;
- }
- switch($stat_type9) {
- case"0":
- $stat_type9="Mana";
- break;
- case"1":
- $stat_type9="Health";
- break;
- case"3":
- $stat_type9="Agility";
- break;
- case"4":
- $stat_type9="Strength";
- break;
- case"5":
- $stat_type9="Intellect";
- break;
- case"6":
- $stat_type9="Spirit";
- break;
- case"7":
- $stat_type9="Stamina";
- break;
- }
- switch($stat_type10) {
- case"12":
- $stat_type100="Defense Rating";
- break;
- case"13":
- $stat_type100="Dodge Rating";
- break;
- case"14":
- $stat_type100="Parry Rating";
- break;
- case"15":
- $stat_type100="Block Rating";
- break;
- case"16":
- $stat_type100="Melee Hit Rating";
- break;
- case"17":
- $stat_type100="Ranged Hit Rating";
- break;
- case"18":
- $stat_type100="Spell Hit Rating";
- break;
- case"19":
- $stat_type100="Melee Crit Rating";
- break;
- case"20":
- $stat_type100="Ranged Crit Rating";
- break;
- case"21":
- $stat_type100="Spell Crit Rating";
- break;
- case"22":
- $stat_type100="Melee Hit Taken Rating";
- break;
- case"23":
- $stat_type100="Ranged Hit Taken Rating";
- break;
- case"24":
- $stat_type100="Spell Hit Taken Rating";
- break;
- case"25":
- $stat_type100="Melee Crit Taken Rating";
- break;
- case"26":
- $stat_type100="Ranged Crit Taken Rating";
- break;
- case"27":
- $stat_type100="Spell Crit Taken Rating";
- break;
- case"28":
- $stat_type100="Melee Haste Rating";
- break;
- case"29":
- $stat_type100="Ranged Haste Rating";
- break;
- case"30":
- $stat_type100="Spell Haste Rating";
- break;
- case"31":
- $stat_type100="Hit Rating";
- break;
- case"32":
- $stat_type100="Crit Rating";
- break;
- case"33":
- $stat_type100="Hit Taken Rating";
- break;
- case"34":
- $stat_type100="Crit Taken Rating";
- break;
- case"35":
- $stat_type100="Resilience Rating";
- break;
- case"36":
- $stat_type100="Haste Rating";
- break;
- case"37":
- $stat_type100="Expertise Rating";
- break;
- case"38":
- $stat_type100="Attack Power";
- break;
- case"39":
- $stat_type100="Ranged Attack Power";
- break;
- case"41":
- $stat_type100="Spell Healing Rating";
- break;
- case"42":
- $stat_type100="Spell Damage Rating";
- break;
- case"43":
- $stat_type100="Mana Regeneration";
- break;
- case"44":
- $stat_type100="Armor Penetration";
- break;
- case"45":
- $stat_type100="Spell Power";
- break;
- case"46":
- $stat_type100="Health Regeneration";
- break;
- case"47":
- $stat_type100="Spell Penetration";
- break;
- case"48":
- $stat_type100="Block Value";
- break;
- }
- switch($stat_type10) {
- case"0":
- $stat_type10="Mana";
- break;
- case"1":
- $stat_type10="Health";
- break;
- case"3":
- $stat_type10="Agility";
- break;
- case"4":
- $stat_type10="Strength";
- break;
- case"5":
- $stat_type10="Intellect";
- break;
- case"6":
- $stat_type10="Spirit";
- break;
- case"7":
- $stat_type10="Stamina";
- break;
- }
- $sql = "SELECT * FROM dbcs.item_set_names WHERE id = (SELECT itemset FROM world.item_template WHERE entry=$entry)";
- $result = mysqli_query($conn, $sql);
- if (mysqli_num_rows($result) > 0) {
- while($row = mysqli_fetch_assoc($result)) {
- $set = $row['name'];
- }
- } else {
- echo mysqli_error($conn);
- }
- mysqli_close($conn);
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="UTF-8">
- <style>
- body {
- margin:0;
- padding:0;
- color:white;
- }
- #tooltip {
- width:400px;
- min-height:20px;
- background-color:rgba(6,26,42, .8);
- border-radius:7px;
- position:relative;
- margin-left:110px;
- }
- #tooltip:after {
- content:"";
- position:absolute;
- top:0;
- left:-74px;
- width:64px;
- height:64px;
- background-image:url(../images/Icon.png);
- }
- table {
- width:400px;
- }
- table th {
- text-align:left;
- }
- #rightstat {
- text-align:right;
- }
- a:hover > #tooltip {
- display:block;
- color:#fff;
- }
- </style>
- <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
- </head>
- <body>
- <div id="tooltip">
- <table>
- <?php
- echo "<tr>";
- echo "<th colspan='2'>";
- echo $itemname;
- echo "</th>";
- echo "</tr>";
- echo "<tr>";
- echo "<td>";
- echo $bonding;
- echo "</td>";
- echo "</tr>";
- echo "<tr>";
- echo "<td>";
- echo $invtype;
- echo "</td>";
- echo "<td id='rightstat'>";
- echo $itemtype;
- echo "</td>";
- echo "</t4>";
- if($stat_type111 > "11" || $stat_type111 == "0"){
- }else{
- echo "<tr>";
- echo "<td>";
- echo "+" . $stat_value1;
- echo " " . $stat_type1;
- echo "</td>";
- echo "</tr>";
- }
- if($stat_type222 > "11" || $stat_type222 == "0"){
- }else{
- echo "<tr>";
- echo "<td>";
- echo "+" . $stat_value2;
- echo " " . $stat_type2;
- echo "</td>";
- echo "</tr>";
- }
- if($stat_type333 > "11" || $stat_type333 == "0"){
- }else{
- echo "<tr>";
- echo "<td>";
- echo "+" . $stat_value3;
- echo " " . $stat_type3;
- echo "</td>";
- echo "</tr>";
- }
- if($stat_type444 > "11" || $stat_type444 == "0"){
- }else{
- echo "<tr>";
- echo "<td>";
- echo "+" . $stat_value4;
- echo " " . $stat_type4;
- echo "</td>";
- echo "</tr>";
- }
- if($stat_type555 > "11" || $stat_type555 == "0"){
- }else{
- echo "<tr>";
- echo "<td>";
- echo "+" . $stat_value5;
- echo " " . $stat_type5;
- echo "</td>";
- echo "</tr>";
- }
- if($stat_type666 > "11" || $stat_type666 == "0"){
- }else{
- echo "<tr>";
- echo "<td>";
- echo "+" . $stat_value6;
- echo " " . $stat_type6;
- echo "</td>";
- echo "</tr>";
- }
- if($stat_type777 > "11" || $stat_type777 == "0"){
- }else{
- echo "<tr>";
- echo "<td>";
- echo "+" . $stat_value7;
- echo " " . $stat_type7;
- echo "</td>";
- echo "</tr>";
- }
- if($stat_type888 > "11" || $stat_type888 == "0"){
- }else{
- echo "<tr>";
- echo "<td>";
- echo "+" . $stat_value8;
- echo " " . $stat_type8;
- echo "</td>";
- echo "</tr>";
- }
- if($stat_type999 > "11" || $stat_type999 == "0"){
- }else{
- echo "<tr>";
- echo "<td>";
- echo "+" . $stat_value9;
- echo " " . $stat_type9;
- echo "</td>";
- echo "</tr>";
- }
- if($stat_type1000 > "11" || $stat_type1000 == "0"){
- }else{
- echo "<tr>";
- echo "<td>";
- echo "+" . $stat_value10;
- echo " " . $stat_type10;
- echo "</td>";
- echo "</tr>";
- }
- if($durability == "0") {
- }else{
- echo "<tr>";
- echo "<td>";
- echo "Durability " . $durability . "/" . $durability;
- echo "</td>";
- echo "</tr>";
- }
- if($requiredlevel == "0") {
- }else{
- echo "<tr>";
- echo "<td>";
- echo "Requires Level " . $requiredlevel;
- echo "</td>";
- echo "</tr>";
- }
- if($itemlevel == "0") {
- }else{
- echo "<tr>";
- echo "<td>";
- echo "Item Level " . $itemlevel;
- echo "</td>";
- echo "</tr>";
- }
- if($stat_type111 > "7" && $stat_value1 > "0"){
- echo "<tr>";
- echo "<td>";
- echo "<font color='#1eff00'>Equip: Increases $stat_type11 by " . $stat_value1 . "</font>";
- echo "</td>";
- echo "</tr>";
- }else{
- }
- if($stat_type222 > "7" && $stat_value2 > "0"){
- echo "<tr>";
- echo "<td>";
- echo "<font color='#1eff00'>Equip: Increases $stat_type22 by " . $stat_value2 . "</font>";
- echo "</td>";
- echo "</tr>";
- }else{
- }
- if($stat_type333 > "7" && $stat_value3 > "0"){
- echo "<tr>";
- echo "<td>";
- echo "<font color='#1eff00'>Equip: Increases $stat_type33 by " . $stat_value3 . "</font>";
- echo "</td>";
- echo "</tr>";
- }else{
- }
- if($stat_type444 > "7" && $stat_value4 > "0"){
- echo "<tr>";
- echo "<td>";
- echo "<font color='#1eff00'>Equip: Increases $stat_type44 by " . $stat_value4 . "</font>";
- echo "</td>";
- echo "</tr>";
- }else{
- }
- if($stat_type555 > "7" && $stat_value5 > "0"){
- echo "<tr>";
- echo "<td>";
- echo "<font color='#1eff00'>Equip: Increases $stat_type55 by " . $stat_value5 . "</font>";
- echo "</td>";
- echo "</tr>";
- }else{
- }
- if($stat_type666 > "7" && $stat_value6 > "0"){
- echo "<tr>";
- echo "<td>";
- echo "<font color='#1eff00'>Equip: Increases $stat_type66 by " . $stat_value6 . "</font>";
- echo "</td>";
- echo "</tr>";
- }else{
- }
- if($stat_type777 > "7" && $stat_value7 > "0"){
- echo "<tr>";
- echo "<td>";
- echo "<font color='#1eff00'>Equip: Increases $stat_type77 by " . $stat_value7 . "</font>";
- echo "</td>";
- echo "</tr>";
- }else{
- }
- if($stat_type888 > "7" && $stat_value8 > "0"){
- echo "<tr>";
- echo "<td>";
- echo "<font color='#1eff00'>Equip: Increases $stat_type88 by " . $stat_value8 . "</font>";
- echo "</td>";
- echo "</tr>";
- }else{
- }
- if($stat_type999 > "7" && $stat_value9 > "0"){
- echo "<tr>";
- echo "<td>";
- echo "<font color='#1eff00'>Equip: Increases $stat_type99 by " . $stat_value9 . "</font>";
- echo "</td>";
- echo "</tr>";
- }else{
- }
- if($stat_type1000 > "7" && $stat_value10 > "0"){
- echo "<tr>";
- echo "<td>";
- echo "<font color='#1eff00'>Equip: Increases $stat_type100 by " . $stat_value10 . "</font>";
- echo "</td>";
- echo "</tr>";
- }else{
- }
- if(isset($set)){
- echo "<tr>";
- echo "<td>";
- echo "<font color='#ffd100'>" . $set . " (0/5)</font>";
- echo "</td>";
- echo "</tr>";
- }else{
- }
- ?>
- </table>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement