if (!empty($_REQUEST["i"])) { $id = $_REQUEST["i"]; } else { die("No item specified!"); } //get item data $item = DB_GetItem($id); $d = $item->fetch_assoc(); /* $thread_id = $d["item_thread_id"]; if($thread_id == 0) { $thread_id = saveThread(0, "User Comments"); $sql = sprintf("UPDATE item SET item_thread_id = %s WHERE item_id = %s", $thread_id, $id); $db = DB_GetConnection(); $db->query($sql); $db->close(); } */ $item = buildItemBox($d); $skin = new skin("item2.skn"); $skin->token("ITEM_NAME", $d["item_name"]); $skin->token("ITEM_BOX", $item); $skin->token("ICON_SRC", getIconPath($d["itemdisplay_icon"])); $skin->addRow("props", "Item ID", $id); $skin->addRow("props", "Item Level", $d["item_level"]); $skin->flushRows("props"); //User comments section //$skin->token("USER_COMMENTS", getThreadHtml($thread_id)); //$skin->token("ADD_COMMENT", getQuickReplyHtml($thread_id)); $skin->dump();
$setStamina = 0; $setSpirit = 0; $setArmor = 0; //init set resists $setResHoly = 0; $setResArcane = 0; $setResFire = 0; $setResFrost = 0; $setResNature = 0; $setResShadow = 0; //items in set $num_rows = $items->num_rows; for ($r = 0; $r < $num_rows; $r += 2) { for ($r2 = 0; $r2 < 2; $r2++) { if ($d = $items->fetch_assoc()) { $h[$r2] = buildItemBox($d); if (isset($d["item_armor"])) { $setArmor = $setArmor + $d["item_armor"]; } if (isset($d["item_statStr"])) { $setStrength = $setStrength + $d["item_statStr"]; } if (isset($d["item_statAgi"])) { $setAgility = $setAgility + $d["item_statAgi"]; } if (isset($d["item_statSta"])) { $setStamina = $setStamina + $d["item_statSta"]; } if (isset($d["item_statInt"])) { $setIntellect = $setIntellect + $d["item_statInt"]; }