function BuildItemStats($item, $show_name_icon, $TableClass = '') { global $dbitypes, $dam2h, $dbbagtypes, $dbskills, $icons_url, $icons_dir, $tbspells, $dbiaugrestrict, $dbiracenames, $root_url; $TableProperties = " border='0' cellpadding='0' cellspacing='0' "; if ($TableClass) { $TableClass = " class='" . $TableClass . "'"; } $html_string = ""; $html_string .= "<table border='0' style='width:500px' " . $TableClass . "><tr><td>"; if ($show_name_icon) { $html_string .= "<h4 style='margin-top:0' class='page-title'>" . $item["Name"] . "</h4><hr style='margin: 0px 0; margin-bottom:10px'></td><td>"; if (file_exists("cust_assets/icons/item_" . $item["icon"] . ".png")) { $html_string .= "<img src='cust_assets/icons/item_" . $item["icon"] . ".png' align='right' valign='top' class='btn btn-default'/>"; } else { $html_string .= "<img src='cust_assets/icons/item_0.png' align='right' valign='top' class='btn btn-default'/>"; } $html_string .= "</td></tr><tr><td colspan='2'>"; } $html_string .= "<table border='0' width='100%'" . $TableClass . ">"; // lore, nodrop, norent, magic $html_string .= "<tr>"; $html_string .= "<td colspan='2' nowrap='1'><b style='display:inline'>"; $v = ""; if ($item["itemtype"] == 54) { $html_string .= "{$v} AUGMENTATION"; $v = " "; } if ($item["magic"] == 1) { $html_string .= "{$v} MAGIC ITEM"; $v = " "; } if ($item["loreflag"] == 1) { $html_string .= "{$v} LORE ITEM"; $v = " "; } if ($item["nodrop"] == 0) { $html_string .= "{$v} NO DROP"; $v = " "; } if ($item["norent"] == 0) { $html_string .= "{$v} NO RENT"; $v = " "; } $html_string .= " </b><br></td>"; $html_string .= " </tr>"; // Classes if ($item["classes"] > 0) { $html_string .= "<tr><td colspan='2'><b>Classes </b> " . getclasses($item["classes"]) . "</td></tr>"; } else { $html_string .= "<tr><td colspan='2' nowrap='1'><b>Classes </b> <b class='btn btn-default btn-xs' style='display:inline'>All classes</b></td></tr>"; } // Races if ($item["races"] > 0) { $html_string .= "<tr><td colspan='2'><b>Races </b> " . getraces($item["races"]) . "</td></tr>"; } else { $html_string .= "<tr><td colspan='2' nowrap='1'><b>Races</b> <b class='btn btn-default btn-xs' style='display:inline'>All races</b> </td></tr>"; } // Deity if ($item["deity"] > 0) { $html_string .= "<tr><td colspan='2' nowrap='1'><b>Deity </b> <b class='btn btn-default btn-xs' style='display:inline'>" . gedeities($item["deity"]) . "</b></td></tr>"; } // Slots if ($item["slots"] > 0) { $html_string .= "<tr><td colspan='2'><b>Slot </b> <b class='btn btn-default btn-xs' style='display:inline'>" . strtoupper(getslots($item["slots"])) . "</b></td></tr>"; } if ($item["slots"] == 0) { $html_string .= "<tr><td colspan='2' ><b>Slot </b> <b class='btn btn-default btn-xs' style='display:inline'>NONE</b></td></tr>"; } $TypeString = ""; switch ($item["itemtype"]) { case 0: // 1HS // 1HS case 2: // 1HP // 1HP case 3: // 1HB // 1HB case 42: // H2H // H2H case 1: // 2hs // 2hs case 4: // 2hb // 2hb case 35: // 2hp $TypeString = "Skill"; break; default: $TypeString = "Item Type"; break; } // Item type or Skill // Bags show as 1HS if ($dbitypes[$item["itemtype"]] != "" && $item["bagslots"] == 0) { if ($item["slots"] == 0) { $html_string .= "<tr><td width='0%' nowrap='1' colspan='2'><b> " . $TypeString . " </b>Inventory"; } else { $html_string .= "<tr><td width='0%' nowrap='1' colspan='2'><b>" . $TypeString . " </b> <b class='btn btn-default btn-xs' style='display:inline'>" . $dbitypes[$item["itemtype"]] . "</b>"; } if ($item["stackable"] > 0) { $html_string .= " (stackable)"; } $html_string .= "<hr style='margin: 0px 0;margin-top:10px'></td></tr>"; } // Bag-specific information if ($item["bagslots"] > 0) { $html_string .= "<tr><td width='0%' nowrap='1'><b>Item Type </b> <b class='btn btn-default btn-xs' style='display:inline'>Container</b></td></tr>"; $html_string .= "<tr><td width='0%' nowrap='1'><b>Number of Slots </b><b class='btn btn-default btn-xs' style='display:inline'>" . $item["bagslots"] . "</b></td></tr>"; if ($item["bagtype"] > 0) { $html_string .= "<tr><td width='0%' nowrap='1'><b>Trade Skill Container </b> <b class='btn btn-default btn-xs' style='display:inline'>" . $dbbagtypes[$item["bagtype"]] . "</b></td></tr>"; } if ($item["bagwr"] > 0) { $html_string .= "<tr><td width='0%' nowrap='1'><b>Weight Reduction </b> <b class='btn btn-default btn-xs' style='display:inline'>" . $item["bagwr"] . "%</b></td></tr>"; } $html_string .= "<tr><td width='0%' nowrap='1' colspan='2'>This can hold " . strtoupper(getsize($item["bagsize"])) . " and smaller items.</td></tr>"; } $html_string .= "</table>"; $html_string .= "</td></tr><tr><td colspan='2'>"; $html_string .= "<table border='0' width='0%'" . $TableClass . ">"; // Weight, Size, Rec/Req Level, skill $html_string .= "<tr valign='top'><td>"; $html_string .= "<table width='100%'" . $TableProperties . $TableClass . ">"; $html_string .= "<tr><td><b>Size</b></td><td align='right'><b class='btn btn-default btn-xs' style='display:inline'>" . strtoupper(getsize($item["size"])) . "</b></td></tr>"; $html_string .= GetItemStatsString("Weight", "<b class='btn btn-default btn-xs' style='display:inline'>" . $item["weight"] / 10 . '</b>'); $html_string .= GetItemStatsString("Rec Level", "<b class='btn btn-default btn-xs' style='display:inline'>" . $item["reclevel"] . '</b>'); $html_string .= GetItemStatsString("Req Level", "<b class='btn btn-default btn-xs' style='display:inline'>" . $item["reqlevel"] . '</b>'); $html_string .= "</table>"; $html_string .= "</td><td>"; // AC, HP, Mana, End, Haste $html_string .= "<table width='100%'" . $TableProperties . $TableClass . ">"; $html_string .= GetItemStatsString("AC", "<b class='btn btn-default btn-xs' style='display:inline'>+ " . $item["ac"] . '</b>'); $html_string .= GetItemStatsString("HP", "<b class='btn btn-default btn-xs' style='display:inline'>+ " . $item["hp"] . '</b>'); $html_string .= GetItemStatsString("Mana", "<b class='btn btn-default btn-xs' style='display:inline'>+ " . $item["mana"] . '</b>'); $html_string .= GetItemStatsString("Endur", "<b class='btn btn-default btn-xs' style='display:inline'>+ " . $item["endur"] . '</b>'); $html_string .= GetItemStatsString("Haste", "<b class='btn btn-default btn-xs' style='display:inline'>+ " . $item["haste" . "%"] . '</b>'); $html_string .= "</table>"; $html_string .= "</td><td>"; // Base Damage, Ele/Bane/BodyType Damage, BS Damage, Delay, Range, Damage Bonus, Range $html_string .= "<table width='100%'" . $TableProperties . $TableClass . ">"; $html_string .= GetItemStatsString("Base Damage", "<b class='btn btn-default btn-xs' style='display:inline'>+ " . $item["damage"] . "</b>"); $html_string .= GetItemStatsString(ucfirstwords($dbelements[$item["elemdmgtype"]]) . " Damage", $item["elemdmgamt"]); if ($item["banedmgrace"] > 0 && $item["banedmgamt"] != 0) { $html_string .= "<tr><td><b>Bane Damage ("; $html_string .= $dbiracenames[$item["banedmgrace"]]; $html_string .= ") </b></td><td align='right'>" . sign($item["banedmgamt"]) . "</td></tr>"; } $html_string .= GetItemStatsString(ucfirstwords($dbbodytypes[$item["banedmgbody"]]), $item["banedmgamt"]); $html_string .= GetItemStatsString("Backstab Damage", $item["backstabdmg"]); $html_string .= GetItemStatsString("Delay", $item["delay"]); if ($item["damage"] > 0) { switch ($item["itemtype"]) { case 0: // 1HS // 1HS case 2: // 1HP // 1HP case 3: // 1HB // 1HB case 42: // H2H $dmgbonus = 13; // floor((65-25)/3) main hand $html_string .= "<tr><td><b>Damage Bonus: </b></td><td align='right'>{$dmgbonus}</td></tr>"; break; case 1: // 2hs // 2hs case 4: // 2hb // 2hb case 35: // 2hp $dmgbonus = $dam2h[$item["delay"]]; $html_string .= "<tr><td><b>Damage Bonus: </b></td><td align='right'>{$dmgbonus}</td></tr>"; break; } } $html_string .= GetItemStatsString("Range", $item["range"]); $html_string .= "</table>"; $html_string .= "</td></tr>"; $html_string .= "<tr valign='top'><td>"; // Normal Stats $html_string .= "<hr style='margin: 0px 0;'><table width='100%'" . $TableProperties . $TableClass . ">"; $html_string .= GetItemStatsString("Strength", $item["astr"], $item["heroic_str"], "orange"); $html_string .= GetItemStatsString("Stamina", $item["asta"], $item["heroic_sta"], "orange"); $html_string .= GetItemStatsString("Intelligence", $item["aint"], $item["heroic_int"], "orange"); $html_string .= GetItemStatsString("Wisdom", $item["awis"], $item["heroic_wis"], "orange"); $html_string .= GetItemStatsString("Agility", $item["aagi"], $item["heroic_agi"], "orange"); $html_string .= GetItemStatsString("Dexterity", $item["adex"], $item["heroic_dex"], "orange"); $html_string .= GetItemStatsString("Charisma", $item["acha"], $item["heroic_cha"], "orange"); $html_string .= "</table>"; $html_string .= "</td><td>"; // Resists $html_string .= "<hr style='margin: 0px 0;'><table width='100%'" . $TableProperties . $TableClass . ">"; $html_string .= GetItemStatsString("Magic Resist", $item["mr"], $item["heroic_mr"], "orange"); $html_string .= GetItemStatsString("Fire Resist", $item["fr"], $item["heroic_fr"], "orange"); $html_string .= GetItemStatsString("Cold Resist", $item["cr"], $item["heroic_cr"], "orange"); $html_string .= GetItemStatsString("Disease Resist", $item["dr"], $item["heroic_dr"], "orange"); $html_string .= GetItemStatsString("Poison Resist", $item["pr"], $item["heroic_pr"], "orange"); $html_string .= "</table>"; $html_string .= "</td><td>"; // Modifiers $html_string .= "<hr style='margin: 0px 0;'><table width='100%'" . $TableProperties . $TableClass . ">"; $html_string .= GetItemStatsString("Attack", $item["attack"]); $html_string .= GetItemStatsString("HP Regen", $item["regen"]); $html_string .= GetItemStatsString("Mana Regen", $item["manaregen"]); $html_string .= GetItemStatsString("Endurance Regen", $item["enduranceregen"]); $html_string .= GetItemStatsString("Spell Shielding", $item["spellshield"]); $html_string .= GetItemStatsString("Combat Effects", $item["combateffects"]); $html_string .= GetItemStatsString("Shielding", $item["shielding"]); $html_string .= GetItemStatsString("DoT Shielding", $item["dotshielding"]); $html_string .= GetItemStatsString("Avoidance", $item["avoidance"]); $html_string .= GetItemStatsString("Accuracy", $item["accuracy"]); $html_string .= GetItemStatsString("Stun Resist", $item["stunresist"]); $html_string .= GetItemStatsString("Strikethrough", $item["strikethrough"]); $html_string .= GetItemStatsString("Damage Shield", $item["damageshield"]); $html_string .= "</table>"; $html_string .= "</td></tr></table><hr style='margin: 0px 0;margin-top:10px'>"; // Extras if ($item["extradmgamt"] > 0) { $html_string .= "<tr><td><b>" . ucfirstwords($dbskills[$item["extradmgskill"]]) . " Damage</b>" . sign($item["extradmgamt"]) . "</td></tr>"; } // Skill Mods if ($item["skillmodtype"] > 0 && $item["skillmodvalue"] != 0) { $html_string .= "<tr><td colspan='2' nowrap='1'><b>Skill Mod" . ucfirstwords($dbskills[$item["skillmodtype"]]) . "</b>" . sign($item["skillmodvalue"]) . "%</td></tr>"; } // Augmentations for ($i = 1; $i <= 5; $i++) { if ($item["augslot" . $i . "type"] > 0) { $html_string .= "<tr><td width='0%' nowrap='1' colspan='2'><b>Slot " . $i . "</b> <b style='btn btn-default btn-xs'>Type " . $item["augslot" . $i . "type"] . "</b> </td></tr>"; } } //item proc if ($item["proceffect"] > 0 && $item["proceffect"] < 65535) { $html_string .= "<tr><td colspan='2' nowrap='1'><b>Combat Effect </b><a href='" . $root_url . "spell.php?id=" . $item["proceffect"] . "' target='" . $item["proceffect"] . "'>" . GetFieldByQuery("name", "SELECT name FROM spells_new WHERE id=" . $item["proceffect"]) . "</a>"; if ($item["proclevel2"] > 0) { $html_string .= "<br><b>Level for effect </b>" . $item["proclevel2"]; } $html_string .= "</td></tr>"; } // worn effect if ($item["worneffect"] > 0 && $item["worneffect"] < 65535) { $html_string .= "<tr><td colspan='2' nowrap='1'><b>Worn Effect </b><a href='" . $root_url . "spell.php?id=" . $item["worneffect"] . "' target='" . $item["worneffect"] . "'>" . GetFieldByQuery("name", "SELECT name FROM spells_new WHERE id=" . $item["worneffect"]) . "</a>"; if ($item["wornlevel"] > 0) { $html_string .= "<br><b>Level for effect </b>" . $item["wornlevel"]; } $html_string .= "</td></tr>"; } // focus effect if ($item["focuseffect"] > 0 && $item["focuseffect"] < 65535) { $html_string .= "<tr><td colspan='2' nowrap='1'><b>Focus Effect </b><a href='" . $root_url . "spell.php?id=" . $item["focuseffect"] . "' target='" . $item["focuseffect"] . "'>" . GetFieldByQuery("name", "SELECT name FROM spells_new WHERE id=" . $item["focuseffect"]) . "</a>"; if ($item["focuslevel"] > 0) { $html_string .= "<br/><b>Level for effect</b>" . $item["focuslevel"]; } $html_string .= "</td></tr>"; } // clicky effect if ($item["clickeffect"] > 0 && $item["clickeffect"] < 65535) { $html_string .= "<tr><td colspan='2' nowrap='1'><b>Click Effect </b><a href='" . $root_url . "spell.php?id=" . $item["clickeffect"] . "' target='" . $item["clickeffect"] . "'>" . GetFieldByQuery("name", "SELECT name FROM spells_new WHERE id=" . $item["clickeffect"]) . "</a> ("; if ($item["clicktype"] == 4) { $html_string .= "Must Equip. "; } if ($item["casttime"] > 0) { $html_string .= "<b>Casting time </b>" . $item["casttime"] / 1000 . " sec"; } else { $html_string .= "<b>Casting time </b>Instant"; } $html_string .= ")"; if ($item["clicklevel"] > 0) { $html_string .= "<br/><b>Level for effect </b>" . $item["clicklevel"]; } if ($item["maxcharges"] > 0) { $html_string .= "<br/><b>Charges </b>" . $item["maxcharges"]; } elseif ($item["maxcharges"] < 0) { $html_string .= "<br/><b>Charges </b>Unlimited"; } else { $html_string .= "<br/><b>Charges </b>None"; } $html_string .= "</td></tr>"; } // scroll if ($item["scrolleffect"] > 0 && $item["scrolleffect"] < 65535) { $html_string .= "<tr><td colspan='2' nowrap='1'><b>Spell Scroll Effect </b><a href='" . $root_url . "spell.php?id=" . $item["scrolleffect"] . "' target='" . $item["scrolleffect"] . "'>" . GetFieldByQuery("name", "SELECT name FROM spells_new WHERE id=" . $item["scrolleffect"]) . "</a>"; $html_string .= "</td></tr>"; } // bard item ? if ($item["bardtype"] > 22 && $item["bardtype"] < 65535) { $html_string .= "<tr><td width='0%' nowrap='1' colspan='2'><b>Bard skill </b> " . $dbbardskills[$item["bardtype"]]; if ($dbbardskills[$item["bardtype"]] == "") { $html_string .= "Unknown" . $item["bardtype"]; } $val = $item["bardvalue"] * 10 - 100; if ($val > 0) { $html_string .= " (" . sign($val) . "%)</td></tr>"; } } // Augmentation type if ($item["itemtype"] == 54) { if ($item["augtype"] > 0) { $Comma = ""; $AugSlots = ""; $AugType = $item["augtype"]; $Bit = 1; for ($i = 1; $i < 25; $i++) { if ($Bit <= $AugType && $Bit & $AugType) { $AugSlots .= $Comma . $i; $Comma = ", "; } $Bit *= 2; } $html_string .= "<tr><td colspan='2' nowrap='1'><b>Augmentation Slot Type </b>" . $AugSlots . "</td></tr>"; } else { $html_string .= "<tr><td colspan='2' nowrap='1'><b>Augmentation Slot Type </b>All Slots</td></tr>"; } if ($item["augrestrict"] > 0) { if ($item["augrestrict"] > 12) { $html_string .= "<tr><td colspan='2' nowrap='1'><b>Augmentation Restriction </b>Unknown Type</td></tr>"; } else { $Restriction = $dbiaugrestrict[$item["augrestrict"]]; $html_string .= "<tr><td colspan='2' nowrap='1'><b>Augmentation Restriction </b>{$Restriction}</td></tr>"; } } } $ItemPrice = $item["price"]; $ItemValue = ""; $Platinum = 0; $Gold = 0; $Silver = 0; $Copper = 0; if ($ItemPrice > 1000) { $Platinum = (int) ($ItemPrice / 1000); } if ($ItemPrice - $Platinum * 1000 > 100) { $Gold = (int) (($ItemPrice - $Platinum * 1000) / 100); } if ($ItemPrice - $Platinum * 1000 - $Gold * 100 > 10) { $Silver = (int) (($ItemPrice - $Platinum * 1000 - $Gold * 100) / 10); } if ($ItemPrice - $Platinum * 1000 - $Gold * 100 - $Silver * 10 > 0) { $Copper = $ItemPrice - $Platinum * 1000 - $Gold * 100 - $Silver * 10; } $ItemValue .= "<tr><td colspan='2' nowrap='1'><b>Value </b>"; $ItemValue .= $Platinum . " <img src='cust_assets/icons/item_644.png' width='14' height='14'/> " . $Gold . " <img src='cust_assets/icons/item_645.png' width='14' height='14'/> " . $Silver . " <img src='cust_assets/icons/item_646.png' width='14' height='14'/> " . $Copper . " <img src='cust_assets/icons/item_647.png' width='14' height='14'/>"; $ItemValue .= "</td></tr>"; $html_string .= $ItemValue; $html_string .= "</td></tr></table>"; return $html_string; }
/** Returns an items stats formatted for display. */ function GetItem($item) { global $dbelements; global $dbskills; global $dam2h; global $dbitypes; global $tbspells; global $tbraces; global $dbbodytypes; global $dbbardskills; //return buffer, build item here $Output = ""; $tab = " "; // LORE AUGMENT NODROP NORENT MAGIC $spaceswitch = ""; if ($item["itemtype"] == 54) { $Output .= "{$spaceswitch} AUGMENTATION"; $spaceswitch = " "; } if ($item["magic"] == 1) { $Output .= "{$spaceswitch} MAGIC ITEM"; $spaceswitch = " "; } if ($item["loregroup"] == -1) { $Output .= "{$spaceswitch} LORE ITEM"; $spaceswitch = " "; } if ($item["nodrop"] == 0) { $Output .= "{$spaceswitch} NO TRADE"; $spaceswitch = " "; } if ($item["norent"] == 0) { $Output .= "{$spaceswitch} NO RENT"; $spaceswitch = " "; } $Output .= "<br>\n"; //EXPENDABLE, Charges if ($item["clicktype"] == 3) { $Output .= $tab . "EXPENDABLE "; } //if($item["clicktype"]>0 && $item["maxcharges"]>0) { $Output .= "Charges: ".$item["maxcharges"]."<br>\n"; } //replaced maxcharges logic 2/25/2014 if ($item["clicktype"] > 0 && $item["maxcharges"] != 0) { $Output .= "Charges: " . ($item["maxcharges"] > 0 ? $item["maxcharges"] : "Infinite") . "<br>\n"; } // Augmentation type if ($item["itemtype"] == 54) { //if($item["augtype"] > 0) { $Output .= $tab."Augmentation type: ".$item["augtype"]."<br>\n"; } //removed 2/25/2014 if ($item["augtype"] > 0) { $Output .= $tab . "Augmentation type: " . getaugtype($item["augtype"]) . "<br>\n"; } else { $Output .= $tab . "Augmentation type: for all slots<br>\n"; } } // Slots if ($item["slots"] > 0) { $Output .= $tab . "Slot: " . strtoupper(getslots($item["slots"])) . "<br>\n"; } // Bag-specific information if ($item["bagslots"] > 0) { $Output .= $tab . "Item type: Container<br>\n"; $Output .= $tab . "Number of slots: " . $item["bagslots"] . "<br>\n"; if ($item["bagtype"] > 0) { $Output .= $tab . "Trade skill container: " . $dbbagtypes[$item["bagtype"]] . "<br>\n"; } if ($item["bagwr"] > 0) { $Output .= $tab . "Weight reduction: " . $item["bagwr"] . "%<br>\n"; } $Output .= $tab . "This can hold " . strtoupper(getsize($item["bagsize"])) . " and smaller items.<br>\n"; } // Damage/Delay if ($item["damage"] > 0) { $WepSkill = $dbitypes[$item["itemtype"]]; if ($item["itemtype"] == 27) { $WepSkill = "Archery"; } $Output .= $tab . "Skill: " . $WepSkill . " "; $Output .= "Atk Delay: " . $item["delay"] . "<br>\n" . $tab . "DMG: " . $item["damage"] . ""; switch ($item["itemtype"]) { case 0: // 1HS // 1HS case 2: // 1HP // 1HP case 3: // 1HB // 1HB case 45: // H2H // H2H case 27: //Arrow $dmgbonus = 13; // floor((65-25)/3) main hand $Output .= $tab . "Dmg bonus:{$dmgbonus} <i>(lvl 65)</i>"; if ($item["ac"] == 0) { $Output .= "<br>\n"; } break; case 5: //archery //archery case 1: // 2hs // 2hs case 4: // 2hb // 2hb case 35: // 2hp $dmgbonus = $dam2h[$item["delay"]]; $Output .= $tab . "Dmg bonus: {$dmgbonus} <i>(lvl 65)</i>"; if ($item["ac"] == 0) { $Output .= "<br>\n"; } break; } } //backstab dmg, added 2/24/2014 if ($item["backstabdmg"] > 0) { $Output .= "Backstab Damage: " . $item["backstabdmg"] . "<br>\n"; } //AC if ($item["ac"] != 0) { $Output .= $tab . " AC: " . $item["ac"] . "<br>\n"; } // Elemental DMG if ($item["elemdmgtype"] > 0 and $item["elemdmgamt"] != 0) { $Output .= $tab . strtolower_ucfirst($dbelements[$item["elemdmgtype"]]) . " DMG: " . sign($item["elemdmgamt"]) . "<br>\n"; } //Bane DMG if ($item["banedmgrace"] > 0 and $item["banedmgraceamt"] != 0) { $Output .= $tab . "Bane DMG: "; $Output .= GetFieldByQuery("name", "SELECT name FROM {$tbraces} WHERE id=" . $item["banedmgrace"]); $Output .= " " . sign($item["banedmgraceamt"]) . "<br>\n"; } if ($item["banedmgbody"] > 0 and $item["banedmgamt"] != 0) { $Output .= $tab . "Bane DMG: " . $dbbodytypes[$item["banedmgbody"]]; $Output .= " " . sign($item["banedmgamt"]) . "<br>\n"; } // Skill Mods if ($item["skillmodtype"] > 0 and $item["skillmodvalue"] != 0) { $Output .= $tab . "Skill Mod: " . strtolower_ucfirst($dbskills[$item["skillmodtype"]]) . " " . sign($item["skillmodvalue"]) . "%<br>\n"; } //item proc if ($item["proceffect"] > 0 and $item["proceffect"] < 65535) { $Output .= $tab . "Effect: <a href='http://mqemulator.net/spell.php?id=" . $item["proceffect"] . "'>" . GetFieldByQuery("name", "SELECT name FROM {$tbspells} WHERE id=" . $item["proceffect"]) . "</a>"; $Output .= " (Combat)"; $Output .= " <i>(Level " . $item["proclevel2"] . ")</i>"; $Output .= "<br>\n"; } // worn effect if ($item["worneffect"] > 0 and $item["worneffect"] < 65535) { $Output .= $tab . "Effect: <a href='http://mqemulator.net/spell.php?id=" . $item["worneffect"] . "'>" . GetFieldByQuery("name", "SELECT name FROM {$tbspells} WHERE id=" . $item["worneffect"]) . "</a>"; $Output .= " (Worn)"; $Output .= " <i>(Level " . $item["wornlevel"] . ")</i>"; $Output .= "<br>\n"; } // focus effect if ($item["focuseffect"] > 0 and $item["focuseffect"] < 65535) { $Output .= $tab . "Focus: <a href='http://mqemulator.net/spell.php?id=" . $item["focuseffect"] . "'>" . GetFieldByQuery("name", "SELECT name FROM {$tbspells} WHERE id=" . $item["focuseffect"]) . "</a>"; if ($item["focuslevel"] > 0) { $Output .= " <i>(Level " . $item["focuslevel"] . ")</i>"; } $Output .= "<br>\n"; } // clicky effect if ($item["clickeffect"] > 0 and $item["clickeffect"] < 65535) { $Output .= $tab . "Effect: <a href='http://mqemulator.net/spell.php?id=" . $item["clickeffect"] . "'>" . GetFieldByQuery("name", "SELECT name FROM {$tbspells} WHERE id=" . $item["clickeffect"]) . "</a>"; $Output .= " ("; if ($item["clicktype"] == 1) { $Output .= "Any Slot, "; } if ($item["clicktype"] == 4) { $Output .= "Must Equip, "; } if ($item["clicktype"] == 5) { $Output .= "Any Slot/Can Equip, "; } $Output .= "Casting Time: "; if ($item["casttime"] > 0) { $casttime = sprintf("%.1f", $item["casttime"] / 1000); $Output .= $casttime; } else { $Output .= "Instant"; } $Output .= ")"; $Output .= " <i>(Level " . $item["clicklevel"] . ")</i>"; $Output .= "<br>\n"; } // Stats / HP / Mana / Endurance $Stats = ""; //replaced block BEGIN 2/25/2014 /*if($item[ "astr"] != 0) $Stats .= " STR: " .sign($item ["astr"]); if($item[ "asta"] != 0) $Stats .= " STA: " .sign($item ["asta"]); if($item[ "aagi"] != 0) $Stats .= " AGI: " .sign($item ["aagi"]); if($item[ "adex"] != 0) $Stats .= " DEX: " .sign($item ["adex"]); if($item[ "awis"] != 0) $Stats .= " WIS: " .sign($item ["awis"]); if($item[ "aint"] != 0) $Stats .= " INT: " .sign($item ["aint"]); if($item[ "acha"] != 0) $Stats .= " CHA: " .sign($item ["acha"]); if($item[ "hp"] != 0) $Stats .= " HP: " .sign($item ["hp"]); if($item[ "mana"] != 0) $Stats .= " MANA: " .sign($item ["mana"]); if($item["endur"] != 0) $Stats .= " Endurance: " .sign($item["endur"]);*/ if ($item["astr"] != 0) { $Stats .= " STR: " . $item["astr"]; } if ($item["heroic_str"] != 0) { $Stats .= " " . $item["heroic_str"]; } if ($item["asta"] != 0) { $Stats .= " STA: " . $item["asta"]; } if ($item["heroic_sta"] != 0) { $Stats .= " " . $item["heroic_sta"]; } if ($item["aagi"] != 0) { $Stats .= " AGI: " . $item["aagi"]; } if ($item["heroic_agi"] != 0) { $Stats .= " " . $item["heroic_agi"]; } if ($item["adex"] != 0) { $Stats .= " DEX: " . $item["adex"]; } if ($item["heroic_dex"] != 0) { $Stats .= " " . $item["heroic_dex"]; } if ($item["awis"] != 0) { $Stats .= " WIS: " . $item["awis"]; } if ($item["heroic_wis"] != 0) { $Stats .= " " . $item["heroic_wis"]; } if ($item["aint"] != 0) { $Stats .= " INT: " . $item["aint"]; } if ($item["heroic_int"] != 0) { $Stats .= " " . $item["heroic_int"]; } if ($item["acha"] != 0) { $Stats .= " CHA: " . $item["acha"]; } if ($item["heroic_cha"] != 0) { $Stats .= " " . $item["heroic_cha"]; } //replace block END 2/25/2014 if ($Stats != "") { $Output .= $tab . $Stats . "<br>\n"; } //resists $Stats = ""; //replaced block BEGIN 2/25/2014 /*if($item[ "fr"] != 0) $Stats .= " SV FIRE: " .sign($item ["fr"]); if($item[ "dr"] != 0) $Stats .= " SV DISEASE: ".sign($item ["dr"]); if($item[ "cr"] != 0) $Stats .= " SV COLD: " .sign($item ["cr"]); if($item[ "mr"] != 0) $Stats .= " SV MAGIC: " .sign($item ["mr"]); if($item[ "pr"] != 0) $Stats .= " SV POISON: " .sign($item ["pr"]);*/ if ($item["fr"] != 0) { $Stats .= " Fire: " . $item["fr"]; } if ($item["heroic_fr"] != 0) { $Stats .= " " . $item["heroic_fr"]; } if ($item["dr"] != 0) { $Stats .= " Disease: " . $item["dr"]; } if ($item["heroic_dr"] != 0) { $Stats .= " " . $item["heroic_dr"]; } if ($item["cr"] != 0) { $Stats .= " Cold: " . $item["cr"]; } if ($item["heroic_cr"] != 0) { $Stats .= " " . $item["heroic_cr"]; } if ($item["mr"] != 0) { $Stats .= " Magic: " . $item["mr"]; } if ($item["heroic_mr"] != 0) { $Stats .= " " . $item["heroic_mr"]; } if ($item["pr"] != 0) { $Stats .= " Poison: " . $item["pr"]; } if ($item["heroic_pr"] != 0) { $Stats .= " " . $item["heroic_pr"]; } if ($item["hp"] != 0) { $Stats .= " HP: " . sign($item["hp"]); } if ($item["mana"] != 0) { $Stats .= " MANA: " . sign($item["mana"]); } if ($item["endur"] != 0) { $Stats .= " Endurance: " . sign($item["endur"]); } //replaced block END 2/25/2014 if ($Stats != "") { $Output .= $tab . $Stats . "<br>\n"; } // bonuses if ($item["haste"] > 0) { $Output .= $tab . "Haste: " . $item["haste"] . "%<br>\n"; } if ($item["avoidance"] > 0) { $Output .= $tab . "Avoidance: " . sign($item["avoidance"]) . "<br>\n"; } if ($item["attack"] > 0) { $Output .= $tab . "Attack: " . sign($item["attack"]) . "<br>\n"; } if ($item["extradmgamt"] > 0) { $Output .= $tab . strtolower_ucfirst($dbskills[$item["extradmgskill"]]) . " DMG: " . sign($item["extradmgamt"]) . "<br>\n"; } if ($item["damageshield"] > 0) { $Output .= $tab . "Damage Shield: " . sign($item["damageshield"]) . "<br>\n"; } if ($item["dotshielding"] > 0) { $Output .= $tab . "Dot Shielding: " . sign($item["dotshielding"]) . "%<br>\n"; } if ($item["manaregen"] > 0) { $Output .= $tab . "Mana Regeneration: " . sign($item["manaregen"]) . "<br>\n"; } if ($item["shielding"] > 0) { $Output .= $tab . "Shielding: " . sign($item["shielding"]) . "%<br>\n"; } if ($item["hpregen"] > 0) { $Output .= $tab . "Regeneration: " . sign($item["hpregen"]) . "<br>\n"; } if ($item["combateffects"] > 0) { $Output .= $tab . "Combat Effects: " . sign($item["combateffects"]) . "<br>\n"; } if ($item["accuracy"] > 0) { $Output .= $tab . "Accuracy: " . sign($item["accuracy"]) . "<br>\n"; } if ($item["combatskill"] > 0) { $Output .= $tab . strtolower_ucfirst($dbskills[$item["combatskill"]]) . " DMG: " . sign($item["combatskilldmg"]) . "<br>\n"; } if ($item["spellshield"] > 0) { $Output .= $tab . "Spell Shielding: " . sign($item["spellshield"]) . "%<br>\n"; } if ($item["strikethrough"] > 0) { $Output .= $tab . "Strikethrough: " . sign($item["strikethrough"]) . "%<br>\n"; } if ($item["stunresist"] > 0) { $Output .= $tab . "Stun Resist: " . sign($item["stunresist"]) . "%<br>\n"; } // bard item ? if ($item["bardtype"] > 0) { $Output .= $tab . $dbbardskills[$item["bardtype"]] . ": " . $item["bardvalue"]; $val = $item["bardvalue"] * 10 - 100; if ($val > 0) { $Output .= "<i> (" . sign($val) . "%)</i>"; } $Output .= "<br>\n"; } //required level if ($item["reqlevel"] > 0) { $Output .= $tab . "Required level of " . $item["reqlevel"] . ".<br>\n"; } //recomended level if ($item["reclevel"] > 0) { $Output .= $tab . "Recommended level of " . $item["reclevel"] . ".<br>\n"; } // Weight $weight = sprintf("%.1f", $item["weight"] / 10); $Output .= $tab . "WT: " . $weight . " "; // Item range if ($item["range"] > 0) { $Output .= $tab . "Range: " . $item["range"] . " "; } //size $Output .= $tab . "Size: " . strtoupper(getsize($item["size"])) . "<br>\n"; //classes $Output .= $tab . "Class: " . getclasses($item["classes"]) . "<br>\n"; //races $Output .= $tab . "Race: " . getraces($item["races"]) . "<br>\n"; // Deity if ($item["deity"] > 0) { $Output .= $tab . "Deity: " . getdeities($item["deity"]) . "<br>\n"; } // Augmentations for ($i = 1; $i <= 5; $i++) { if ($item["augslot" . $i . "type"] > 0) { $Output .= $tab . "Slot " . $i . ": Type " . $item["augslot" . $i . "type"] . "<br>\n"; } } // scroll if ($item["scrolleffect"] > 0 and $item["scrolleffect"] < 65535) { $Output .= $tab . "Effect: <a href='http://mqemulator.net/spell.php?id=" . $item["scrolleffect"] . "'>" . GetFieldByQuery("name", "SELECT name FROM {$tbspells} WHERE id=" . $item["scrolleffect"]) . "</a>"; $Output .= "<br>\n"; } return $Output; }