function buildItemBox($d) { //fill skin file with item data $skin = new skin("item_box.skn"); $skin->token("QUALITY_ID", $d["item_qualityID"]); $skin->token("NAME", $d["item_name"]); $skin->flag("bond", $d["item_bondID"] > 0); $skin->token("BOND_TYPE", Text_BondType($d["item_bondID"])); $skin->flag("unique", $d["item_isUnique"] == 1); $skin->flag("slot", $d["item_slotID"] > 0); $skin->token("SLOT_TYPE", Text_SlotType($d["item_slotID"])); $skin->token("SUB_CLASS", $d["itemsubclass_name"]); $skin->flag("armor", $d["item_armor"] > 0); $skin->token("ARMOR", $d["item_armor"]); $skin->flag("dmg1", $d["item_dmg1min"] > 0); if ($d["item_dmg1min"] > 0) { $speed = $d["item_weaponDelay"] / 1000; $dps = ($d["item_dmg1min"] + $d["item_dmg1max"]) / 2 / $speed; $skin->token("DMG1_RANGE", sprintf("%s - %s", $d["item_dmg1min"], $d["item_dmg1max"])); $skin->token("WEAPON_SPEED", number_format($speed, 2)); $skin->token("WEAPON_DPS", number_format($dps, 1)); } if ($d["item_statStr"] > 0) { $skin->addRow("stats", sprintf("+%s Strength", $d["item_statStr"])); } if ($d["item_statAgi"] > 0) { $skin->addRow("stats", sprintf("+%s Agility", $d["item_statAgi"])); } if ($d["item_statSta"] > 0) { $skin->addRow("stats", sprintf("+%s Stamina", $d["item_statSta"])); } if ($d["item_statInt"] > 0) { $skin->addRow("stats", sprintf("+%s Intellect", $d["item_statInt"])); } if ($d["item_statSpr"] > 0) { $skin->addRow("stats", sprintf("+%s Spirit", $d["item_statSpr"])); } if ($d["item_resistHoly"] > 0) { $skin->addRow("stats", sprintf("+%s Holy Resistance", $d["item_statHoly"])); } if ($d["item_resistFire"] > 0) { $skin->addRow("stats", sprintf("+%s Fire Resistance", $d["item_resistFire"])); } if ($d["item_resistNature"] > 0) { $skin->addRow("stats", sprintf("+%s Nature Resistance", $d["item_resistNature"])); } if ($d["item_resistFrost"] > 0) { $skin->addRow("stats", sprintf("+%s Frost Resistance", $d["item_resistFrost"])); } if ($d["item_resistShadow"] > 0) { $skin->addRow("stats", sprintf("+%s Shadow Resistance", $d["item_resistShadow"])); } if ($d["item_resistArcane"] > 0) { $skin->addRow("stats", sprintf("+%s Arcane Resistance", $d["item_resistArcane"])); } $skin->flushRows("stats"); if ($d["item_spell1ID"] > 0) { $skin->addRow("spells", Text_SpellTrigger($d["item_spell1TriggerID"]) . ": " . $d["spell1text"], "spell.php?i=" . $d["item_spell1ID"]); } if ($d["item_spell2ID"] > 0) { $skin->addRow("spells", Text_SpellTrigger($d["item_spell2TriggerID"]) . ": " . $d["spell2text"], "spell.php?i=" . $d["item_spell2ID"]); } if ($d["item_spell3ID"] > 0) { $skin->addRow("spells", Text_SpellTrigger($d["item_spell3TriggerID"]) . ": " . $d["spell3text"], "spell.php?i=" . $d["item_spell3ID"]); } $skin->flushRows("spells"); $skin->flag("reqlvl", $d["item_reqLevel"] > 1); $skin->token("REQ_LEVEL", $d["item_reqLevel"]); $skin->flag("quest", $d["item_beginQuestID"] > 0); $skin->token("QUEST_URL", sprintf("quest.php?i=%s", $d["item_beginQuestID"])); $skin->flag("descrip", $d["item_description"] != null); $skin->token("DESCRIPTION", "\"" . $d["item_description"] . "\""); $skin->flag("set", $d["item_setID"] > 0); $skin->token("SET_NAME", $d["itemset_name"]); $skin->token("ITEMSET_URL", sprintf("itemset.php?i=%s", $d["item_setID"])); return $skin->html; }
$db = DB_GetConnection(); if ($db->multi_query($sql)) { $result = $db->store_result(); } $db->close(); $d = $result->fetch_assoc(); $skin = new skin("quest.skn"); $skin->token("QUEST_NAME", $d["quest_name"]); $skin->token("QUEST_DESCRIPTION", $d["quest_description"]); $skin->token("LEVEL", $d["quest_level"]); $text = $d["quest_details"]; $text = str_replace('$B', "<br/>", $text); $text = str_replace('$b', "<br/>", $text); $skin->token("DETAILS", $text); //objective section $skin->flag("obj", !empty($d["quest_objective1"])); for ($i = 1; $i < 5; $i++) { if (!empty($d["quest_objective" . $i])) { $skin->addRow("obj", $d["quest_objective" . $i]); } } $skin->flushRows("obj"); //collect item section $skin->flag("collect", $d["quest_collectItem1ID"] > 0); for ($i = 1; $i < 5; $i++) { if ($d["quest_collectItem" . $i . "ID"] > 0) { $url = sprintf("item2.php?i=%s", $d["quest_collectItem" . $i . "ID"]); $item_name = !empty($d["c_name" . $i]) ? $d["c_name" . $i] : "Unknown Item"; $skin->addRow("collect", $url, $item_name, $d["quest_collectItem" . $i . "Amount"]); } }