$output){ $points = $points + floor($lvl + 300 * pow(2, ($lvl / 7))); $output = floor($points / 4); if($lvl > 98){ return 99; break; } else if($xp < 83){ return 1; break; } else if($output >= $xp){ return $lvl+1; break; } $lvl++; } } $link = mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $totallvl = mysql_query("SELECT * FROM skillsoverall ORDER BY lvl DESC LIMIT 1"); $attacklvl = mysql_query("SELECT * FROM skills ORDER BY Attackxp DESC LIMIT 1"); $defencelvl = mysql_query("SELECT * FROM skills ORDER BY Defencexp DESC LIMIT 1"); $strengthlvl = mysql_query("SELECT * FROM skills ORDER BY Strengthxp DESC LIMIT 1"); $hitpointslvl = mysql_query("SELECT * FROM skills ORDER BY Hitpointsxp DESC LIMIT 1"); $prayerlvl = mysql_query("SELECT * FROM skills ORDER BY Prayerxp DESC LIMIT 1"); $magiclvl = mysql_query("SELECT * FROM skills ORDER BY Magicxp DESC LIMIT 1"); $rangelvl = mysql_query("SELECT * FROM skills ORDER BY Rangexp DESC LIMIT 1"); $total = mysql_fetch_array($totallvl); $attack = mysql_fetch_array($attacklvl); $defence = mysql_fetch_array($defencelvl); $strength = mysql_fetch_array($strengthlvl); $hitpoints = mysql_fetch_array($hitpointslvl); $prayer = mysql_fetch_array($prayerlvl); $magic = mysql_fetch_array($magiclvl); $range = mysql_fetch_array($rangelvl); echo "
Total:
".$total['playerName']."
(".$total['lvl'].")
"; echo "
Attack:
".$attack[playerName]."
(".getLevelForXP($attack['Attackxp']).")
"; echo "
Defence:
".$defence[playerName]."
(".getLevelForXP($defence['Defencexp']).")
"; echo "
Strength:
".$strength['playerName']."
(".getLevelForXP($strength['Strengthxp']).")
"; echo "
Hitpoints:
".$hitpoints['playerName']."
(".getLevelForXP($hitpoints['Hitpointsxp']).")
"; echo "
Prayer:
".$prayer['playerName']."
(".getLevelForXP($prayer['Prayerxp']).")
"; echo "
Magic:
".$magic['playerName']."
(".getLevelForXP($magic['Magicxp']).")
"; ?>