$lvl"; } } function ShowSkills() { // Need to fix this eventually using the skill/skills.php files. echo "var aSkill = new Array();"; for ($j=0; $j<4; $j++) { if ($j==0){ $class = "Warrior"; $where = "WHERE ko_skill_magic_main_us.tree > 1059 AND ko_skill_magic_main_us.tree < 1070"; } if ($j==1){ $class = "Rogue"; $where = "WHERE ko_skill_magic_main_us.tree > 1079 AND ko_skill_magic_main_us.tree < 1090"; } if ($j==2){ $class = "Magician"; $where = "WHERE ko_skill_magic_main_us.tree > 1099 AND ko_skill_magic_main_us.tree < 1110 AND ko_skill_magic_main_us.id < 120000"; } if ($j==3){ $class = "Priest"; $where = "WHERE ko_skill_magic_main_us.tree > 1119 AND ko_skill_magic_main_us.tree < 1130"; } $result = mysql_query("SELECT ko_skill_magic_main_us.id as 'id', ko_skill_magic_main_us.name as 'name',ko_skill_magic_main_us.descr as 'desc', ko_skill_magic_main_us.conitem as 'consume', ko_skill_magic_main_us.level as 'level', ko_skill_magic_main_us.tree as 'skill', ko_skill_magic_main_us.mana as 'mana', ko_skill_magic_main_us.19 as 'weapon', ko_skill_magic_main_us.reqitem as 'item', ko_skill_magic_main_us.refresh as 'refresh',ko_skill_magic_main_us.icon as 'lc', ko_item_org_us.Name AS 'itemname' FROM ko_skill_magic_main_us LEFT JOIN ko_item_org_us ON ko_skill_magic_main_us.reqitem = ko_item_org_us.ID $where ORDER BY ko_skill_magic_main_us.id"); $num = mysql_numrows($result); if (!$num) ko_error("No Skills found!"); echo "aSkill['$class'] = new Array();"; $last = ""; for ($i=0; $i<$num; $i++) { mysql_data_seek($result, $i); $myrow = mysql_fetch_assoc($result); $name = ucwords($myrow[name]);// Capitalize Each word of the Skill $skill = $myrow[skill]; $description = $myrow[desc]; $level = $myrow[level]; $lc = $myrow[lc]; $id = $myrow[id]; $mana = $myrow[mana]; $refresh = $myrow[refresh] / 10.0; $skilltree = skilltree($class, $id[3]); $reqitem_name = $myrow[itemname]; $conitem = $myrow[consume]; switch ($conitem) { case "0": $conitem_name = ""; break; case "1": $conitem_name = "Stone of Warrior"; break; case "2": $conitem_name = "Stone of Rogue"; break; case "3": $conitem_name = "Stone of Mage"; break; case "4": $conitem_name = "Stone of Priest"; break; default: $conitem_name = ko_item_name($conitem); break; } $reqweapon = $myrow[weapon]; switch ($reqweapon) { // 9 is casting spell requiring nothing case "11": $reqweapon_name = "Staff"; break; case "7": $reqweapon_name = "Bow"; break; case "1": $reqweapon_name = "Dagger"; break; case "0": $reqweapon_name = "Weapon"; break; default: $reqweapon_name = ""; break; } //$subquery = mysql_query("SELECT description FROM correct_skills WHERE `ID` = '$id'"); //$subnum = mysql_numrows($subquery); //if ($subnum > 0) $description = mysql_result($subquery, 0, "description"); // 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"; // Whipping skill skip it! if ($icon == "skillicon_10_1010.png") continue; if (!file_exists("/usr/home/knight/www.kingofknight.com/images/ui/$icon")) continue; if ($skilltree != $last){ $last = $skilltree; echo "aSkill['$class']['$skilltree']=new Array();\n"; $k = 0; } echo << $value) { if (is_numeric($value)) array_push($display, "$key:$value"); else{ $value = addslashes($value); array_push($display, "$key:'$value'"); } } return $display; } function ShowBuffs() { echo "var aBuff = new Array();"; $aSkill = array( 112654,//undying 112675,//2500 500053,//2000 500033,//1500 500067,//350ac 500030,//300ac 500045,//Scroll of Lion 500040,//str scroll 500042,//Dex Scroll 500041,//HP scroll 500043,//Int scroll 500044,//mp scroll 112729,//priest 30 str 510529,//AP scroll 490026,//priest book 112645,//Fresh Mind 110548,//Flame Resist 110648,//Glacier Resist 110748,//Lightning Resist //500049,//weapon enchant 500050,//armor enchant 610095,//Blue Potion - War Map 610096,//Red Potion - War Map 301029,//Pet HP 2 301030);//Pet AC 2 $country = "us"; $smm = tablename($country,"skill_magic_main"); $sm4 = tablename($country,"skill_magic_4"); $where = array(); foreach($aSkill as $key => $value) $where[] = "$smm.ID = '$value'"; $sql = mysql_query ("SELECT $smm.name as 'name', $smm.icon as 'icon', $sm4.id as 'id', $sm4.buffkind as 'buffkind', $sm4.duration as 'duration', $sm4.hppercent as 'hppercent', $sm4.appercent as 'appercent', $sm4.m_appercent as 'm_appercent', $sm4.acbonus as 'def', $sm4.hpbonus as 'health', $sm4.mpbonus as 'mana', $sm4.stat_str as 'str', $sm4.stat_health as 'hp', $sm4.stat_dex as 'dex', $sm4.stat_int as 'int', $sm4.stat_magic as 'mp', $sm4.resist_f as 'fr', $sm4.resist_g as 'gr', $sm4.resist_l as 'lr', $sm4.resist_p as 'pr', $sm4.resist_m as 'mr', $sm4.resist_c as 'cr' FROM $smm, $sm4 WHERE (".implode(" OR ", $where).") AND $smm.ID = $sm4.id"); $aBuff = array(); while ($buff = mysql_fetch_assoc($sql)){ $lc = $buff["icon"]; $buff["icon"] = "skillicon_".substr($lc,4,2)."_".substr($lc,0,4).".png"; $buff[name] = ucwords($buff[name]); $aBuff[$buff[id]] = $buff; } foreach($aSkill as $i => $id) echo "aBuff[$i] = { ".implode(", ", setup_stats($aBuff[$id]))." };"; } function ShowCoefficients() { $result = mysql_query("SELECT * FROM `coefficients`"); if (!mysql_numrows($result)) ko_error("No Coefficients found!"); echo "var aCoeff=new Array();"; while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $id = $row[id]; if ($id > 199) continue; echo "aCoeff['$id']=new Array(); "; foreach ($row as $key => $value) { if ($key == "id") continue; echo "aCoeff['$id']['$key']='$value'; "; } } } function ShowCharacter() { echo "\n"; } function skilltree($class, $skilltree) { switch ($class) { case "Warrior": switch ($skilltree) { case "0": return "Basic"; break; case "5": return "Attack"; break; case "6": return "Defense"; break; case "7": return "Berserk"; break; case "8": return "Master"; break; default: return "Unknown"; break; } break; case "Rogue": switch ($skilltree) { case "0": return "Basic"; break; case "5": return "Archery"; break; case "6": return "Assassin"; break; case "7": return "Explore"; break; case "8": return "Master"; break; default: return "Unknown"; break; } break; case "Magician": switch ($skilltree) { case "0": return "Basic"; break; case "5": return "Fire"; break; case "6": return "Glacier"; break; case "7": return "Lightning"; break; case "8": return "Master"; break; default: return "Unknown"; break; } break; case "Priest": switch ($skilltree) { case "0": return "Basic"; break; case "5": return "Heal"; break; case "6": return "Ecstasy"; break; case "7": return "Holy"; break; case "8": return "Master"; break; default: return "Unknown"; break; } break; default: return "Unknown"; break; } } ?>
LV   1
Slowness in item loading is due to the complicated layout of item ID's and data in tables. Just be patient.
Weight: