include '../includes/overall.php'; show_header("Pet Guide"); ?> function GetStats() { $sql = "SELECT * FROM `pets` , `ko_player_experience` WHERE `pets`.`level` = `ko_player_experience`.`level` ORDER BY `pets`.`level` "; $result = mysql_query($sql); $num = mysql_numrows($result); if ($num == 0) ko_error("No pet stats found!", 0); for ($i=0; $i<$num; $i++) { $stat[$i]['hp'] = mysql_result($result, $i, "hp"); $stat[$i]['mp'] = mysql_result($result, $i, "mp"); $stat[$i]['atk'] = mysql_result($result, $i, "attack"); $stat[$i]['def'] = mysql_result($result, $i, "defense"); $stat[$i]['res'] = mysql_result($result, $i, "resist"); $stat[$i]['exps'] = number_format(mysql_result($result, $i, "experience")); } return $stat; } function GetSkills() { $result = mysql_query("SELECT name, descr, level, mana, icon, `30` as 'auto' FROM ko_skill_magic_main_us WHERE tree = 1000 AND level > 0 ORDER BY level"); if (!result || !$num = mysql_numrows($result)) ko_error("No skills found!", 0); for ($i=0; $i<$num; $i++) { $skill[$i]['id'] = "s$i"; $skill[$i]['name'] = mysql_result($result, $i, "name"); $skill[$i]['desc'] = mysql_result($result, $i, "desc"); $skill[$i]['lvl'] = mysql_result($result, $i, "level"); $skill[$i]['mp'] = mysql_result($result, $i, "mana"); $lc = mysql_result($result, $i, "icon"); // Build icon code & skip entry if no icon present $icon = "skillicon_".substr($lc,4,2)."_".substr($lc,0,4).".png"; //$wicon = "http://www.kingofknight.com/images/ui/$icon"; //$icon = "$lc[4]$lc[5]$lc[0]$lc[1]$lc[2]$lc[3].gif"; //if (!file_exists("http://www.kingofknight.com/images/skillicons/$icon")) // ko_error("Skill Icon not found!", 0); $cast = mysql_result($result, $i, "auto"); if ($cast) $cast = "possible"; else $cast = "impossible"; $skill[$i]['cast'] = $cast; //$wicon = "http://www.kingofknight.com/images/skillicons/$icon"; $skill[$i]['icon'] = $icon; // Fill up description for our dear IE if(strlen($skill[$i]['desc']) < 1) $skill[$i]['desc'] = " "; } return $skill; } function WriteJava() { $Skills = GetSkills(); $Stats = GetStats(); echo '"; } WriteJava(); ?>