$mobname"; if ($j>0) $task .= " or "; $task .= $moblink; } } $result .= "Task$task"; } } } else { $item = ko_item($row["taski".$i]); if (!$item) $item = "{".$row["taski".$i]."}"; return "TaskDeliver ".$row["taskc".$i]." ". $item; } } return $result; } function reward($row,$i) { if ($row["rewi".$i]) { $ch = ""; if ($row["kind"] >= 11 && $row["kind"] <= 12) $ch = " (Choice)"; elseif ($row["kind"] == 30 && $i == 0) $ch = " (Non-premium)"; elseif ($row["kind"] == 30 && $i == 3) $ch = " (Premium)"; $item = ko_item($row["rewi".$i]); if (!$item) $item = "{".$row["rewi".$i]."}"; return "Reward$ch".$row["rewc".$i]." ". $item;; } return ""; } $version = secure($_GET["version"]); $id = secure($_GET["id"]); if (!is_ko_version($version) || !is_numeric($id)) { show_header($sitetext["questinfo"]); ko_error("Unknown request"); } if ($version == "kr") $suf = ""; else $suf = "_".$version; if ($version == "us") $pre = ""; else $pre = $version; $enc = country_enc($version); $qh = tablename($version,"quest_helper"); $qie = tablename($version,"item_exchange"); $qiex = tablename($version,"item_exchange_exp"); $qg = tablename($version,"quest_guide"); $npct = tablename($version,"npc"); $mobt = tablename($version,"mob"); $qme = tablename($version,"quest_monster_exchange"); $query = "SELECT DISTINCT quest_id, minlvl, maxlvl, name, description, info, npc_id, class_type, nation, kind2, kind, exchange_id "; for ($i=0; $i<5; ++$i) $query .= ",taski$i,taskc$i,rewi$i,rewc$i "; $query .= " FROM $qh INNER JOIN $qg ON $qg.id=$qh.guide_id INNER JOIN $qie ON $qh.exchange_id=$qie.id WHERE quest_id>0 AND kind<=100 AND quest_id=$id ORDER BY minlvl"; //echo $query; /*Meaning of "kind": 0: normal quest 1: chaotic generator exchange 2,3: same as above (or appendix) 10: hunt quest 11: normal quest with choice for reward 12: hunt quest with choice for reward 13: same as 0 (?) 30: hunt quest with premium exp reward 101,102: exchange through talk; chests, abyss gem etc. */ $sql = mysql_query($query); if (!mysql_num_rows($sql)) { show_header("Quest Details"); ko_error("No quests!"); } $name = ""; while ($row = mysql_fetch_assoc($sql)) { if ($enc) { $row["name"] = iconv($enc,"utf-8",$row["name"]); if ($name == "") { $name = $row["name"]; show_header($name); } $row["description"] = iconv($enc,"utf-8",$row["description"]); $row["info"] = iconv($enc,"utf-8",$row["info"]); } ?> "; echo "$row[name]"; echo "Minimum Level$row[minlvl]"; echo "Maximum Level$row[maxlvl]"; echo "Class"; switch($row["class_type"]) { case 1:echo "Warrior"; break; case 2:echo "Rogue"; break; case 3:echo "Mage"; break; case 4:echo "Priest"; break; case 5:echo "All classes"; break; } echo "Nation"; switch($row["nation"]) { case 1:echo "Karus"; break; case 2:echo "El Morad"; break; case 3:echo "All nations"; break; } echo ""; $npcsql = mysql_query("SELECT name FROM $npct WHERE id=$row[npc_id]"); $npcname = iconv($enc,"utf-8",mysql_result($npcsql,0,"name")); echo "NPC$npcname"; echo "Description$row[description]"; echo "Info$row[info]"; $expsql = mysql_query("SELECT * FROM $qiex WHERE id=$row[exchange_id]"); $rowx = mysql_fetch_assoc($expsql); if ($row["kind2"] == 0) { for ($i=0; $i<5; ++$i) echo task($row,$i); for ($i=0; $i<5; ++$i) echo reward($row,$i); for ($i=0; $i<5; ++$i) echo reward($rowx,$i); } elseif ($row["kind2"] == 17970176) { for ($i=0; $i<5; ++$i) { $atask = task($row,$i); if ($atask) { if ($i > 0) echo "OR"; else echo "Quest"; echo $atask; echo reward($row,$i); echo reward($rowx,$i); } } } else { echo "Task/RewardUnknown!!!"; } echo ""; } if ($version == "us") { if ($name == "") $name = "Quest #$id"; $link = ko_comments(10, $name, $id); echo ""; } show_footer(); ?>