function getThreadHtml($thread_id) { $sql = sprintf("call sp_get_thread(%s)", $thread_id); $db = DB_GetConnection(); if ($db->multi_query($sql)) { $thread = $db->store_result(); if ($db->next_result()) { $posts = $db->store_result(); } } $db->close(); $t = $thread->fetch_assoc(); $skin = new skin("thread.skn"); $skin->token("THREAD_TITLE", $t["thread_title"]); //posts $num_rows = $posts->num_rows; for ($r = 0; $r < $num_rows; $r++) { $p = $posts->fetch_assoc(); $skin->addRow("posts", $p["post_user_id"], $p["post_message"]); } $skin->flushRows("posts"); return $skin->html; }
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();
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; }
//quest.php include "includes/common.php"; if (!empty($_REQUEST["i"])) { $id = $_REQUEST["i"]; } else { die("No quest specified!"); } $sql = sprintf("call sp_getquest(%s);", $id); $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
if (!empty($strtmp)) { $db = DB_GetConnection(); $sql = "select * from vw_item where item_name like '%" . $s . "%' order by item_name"; $items = $db->query($sql); $sql = "select * from quest where quest_name like '%" . $s . "%' order by quest_name"; $quests = $db->query($sql); $db->close(); $skin = new skin("search_result.skn"); $box->token("SEARCH_VALUE", $s); $skin->token("SEARCH_BOX", $box->html); $skin->token("NUM_ITEMS", $items->num_rows); $skin->token("NUM_QUESTS", $quests->num_rows); for ($r = 0; $r < $items->num_rows; $r++) { $d = $items->fetch_assoc(); $icon = getIconPath($d["itemdisplay_icon"]); $skin->addRow("items", buildItemLink($d), $d["item_reqLevel"], $icon); } $skin->flushRows("items"); for ($r = 0; $r < $quests->num_rows; $r++) { $d = $quests->fetch_assoc(); $url = sprintf("quest.php?i=%s", $d["quest_id"]); $skin->addRow("quests", $d["quest_name"], $url); } $skin->flushRows("quests"); $skin->dump(); } else { $box->token("SEARCH_VALUE", ""); $skin = new skin("adv_search.skn"); $skin->token("STUFF", $box->html); $skin->dump(); }
<?php include "includes/common.php"; if (!empty($_REQUEST["i"])) { $id = $_REQUEST["i"]; } else { die("No spell specified!"); } //get item data $spell = DB_GetSpell($id); $d = $spell->fetch_assoc(); $skin = new skin("spell.skn"); $skin->token("SPELL_NAME", $d["spell_name"]); $skin->token("FINAL_TEXT", $d["spell_final_text"]); $p = strrpos($d["spellicon_icon"], "\\"); $icon = substr($d["spellicon_icon"], $p + 1); $skin->token("ICON_SRC", getIconPath($icon)); $skin->addRow("props", "Mana Cost", $d["spell_manacost"]); $skin->addRow("props", "Max Stack", $d["spell_stackamount"]); $skin->flushRows("props"); $skin->dump();
//Yay! File was uploaded and moved successfully $msg = doOkMsg("File upload worked! Thank you for feeding WoW Monkey!"); } else { //could not move the temp file for some reason $msg = doErrMsg("File upload failed! Could not move temp file."); } } else { //file is not with our select list $msg = doErrMsg("File upload failed! Invalid file."); } } else { //could not open the temp file for some reason $msg = doErrMsg("File upload failed! Could not read uploaded file."); } } else { //a file upload error occured $msg = "File upload failed!"; if ($err == 1 || $err == 2) { $msg .= " Maximum file size exceeded."; } $msg = doErrMsg($msg); } } $skin = new skin("upload.skn"); $url = "upload.php"; $skin->token("FORM_ACTION", $url); $skin->token("MAX_FILE_SIZE", $max_size); $skin->token("MAX_MB", $max_size / 1000000); //for display only $skin->token("MESSAGE", $msg); $skin->dump();
$id = $_REQUEST["i"]; } else { die("No itemset specified!"); } $sql = sprintf("call sp_getitemset(%s);", $id); $db = DB_GetConnection(); if ($db->multi_query($sql)) { $itemset = $db->store_result(); if ($db->next_result()) { $items = $db->store_result(); } } $db->close(); $i = $itemset->fetch_assoc(); $skin = new skin("itemset.skn"); $skin->token("SET_NAME", $i["itemset_name"]); //init set stats $setStrength = 0; $setAgility = 0; $setIntellect = 0; $setStamina = 0; $setSpirit = 0; $setArmor = 0; //init set resists $setResHoly = 0; $setResArcane = 0; $setResFire = 0; $setResFrost = 0; $setResNature = 0; $setResShadow = 0; //items in set
if ($t == 0 || $t == 1) { $sql = "select * from vw_item where item_name like '%" . $s . "%' order by item_name"; $items = $db->query($sql); } if ($t == 0 || $t == 2) { $sql = "select * from quest where quest_name like '%" . $s . "%' order by quest_name"; $quests = $db->query($sql); } if ($t == 0 || $t == 3) { $sql = "select * from spell2 where spell_name like '%" . $s . "%' order by spell_name"; $spells = $db->query($sql); } $db->close(); $skin = new skin("search_result.skn"); $box->token("SEARCH_VALUE", $s); $skin->token("SEARCH_BOX", $box->html); $skin->token("NUM_ITEMS", $items->num_rows); $skin->token("NUM_QUESTS", $quests->num_rows); $skin->token("NUM_SPELLS", $spells->num_rows); for ($r = 0; $r < $items->num_rows; $r++) { $d = $items->fetch_assoc(); $icon = getIconPath($d["itemdisplay_icon"]); if ($d["item_setID"] > 0) { $skin->addRow("items", buildItemLink($d), $d["item_reqLevel"], $icon, "<br/>" . buildSetLink($d)); } else { $skin->addRow("items", buildItemLink($d), $d["item_reqLevel"], $icon, ""); } } $skin->flushRows("items"); for ($r = 0; $r < $quests->num_rows; $r++) { $d = $quests->fetch_assoc();
<?php include "includes/common.php"; if (!empty($_REQUEST["i"])) { $id = $_REQUEST["i"]; } else { die("No mob specified!"); } //get item data $db = DB_GetConnection(); $sql = sprintf("select * from mob where mob_id = %s", $id); $mob = $db->query($sql); $db->close(); $d = $mob->fetch_assoc(); $skin = new skin("mob.skn"); $skin->setPageTitle(sprintf("Mob: %s", $d["mob_name"])); $skin->token("MOB_NAME", $d["mob_name"]); $title = $d["mob_description"]; if (strlen($title) > 0) { $title = "<" . $title . ">"; } $skin->token("MOB_TITLE", $title); $skin->dump(); $mob->close();