<?
echo "<center>\n";
echo "<a href=\"?page=Highscore\" style=\"text-decoration:none;\"> Level </a>\n";
echo "<a href=\"?page=Highscore&skill=Fist\" style=\"text-decoration:none;\"> Fist </a>\n";
echo "<a href=\"?page=Highscore&skill=Club\" style=\"text-decoration:none;\"> Club </a>\n";
echo "<a href=\"?page=Highscore&skill=Sword\" style=\"text-decoration:none;\"> Sword </a>\n";
echo "<a href=\"?page=Highscore&skill=Axe\" style=\"text-decoration:none;\"> Axe </a>\n";
echo "<a href=\"?page=Highscore&skill=Distance\" style=\"text-decoration:none;\"> Distance </a>\n";
echo "<a href=\"?page=Highscore&skill=Fishing\" style=\"text-decoration:none;\"> Fishing </a>\n";
echo "</center>\n";
echo "<table border=\"0\" style=\"width:100%;\">\n";
echo "<tr>\n";
echo "<td style=\"width: 10%;\">Pos: </td>\n";
echo "<td style=\"width: 50%;\">Name: </td>\n";
echo "<td style=\"width: 40%;\">Value: </td>\n";
echo "</tr>\n";
switch($_GET["skill"]){
default:
$player_highscore = mysql_query("SELECT * FROM `players` ORDER BY `level` DESC LIMIT 0,1000") or die(mysql_error());
$loop = 1;
while($data = mysql_fetch_array( $player_highscore)){
if($loop <= $max_highscore){
echo "<tr>\n";
echo "<td>".$loop."</td>\n";
echo "<td><a href=\"?page=Search&name=".preg_replace("/".chr(32)."/", "_", $data['name'])."\">".$data['name']."</a></td>\n";
echo "<td>".$data['level']."</td>\n";
echo "</tr>\n";
$loop++;
}
}
break;
case Fist:
$player_highscore = mysql_query("SELECT * FROM `player_skills` WHERE skillid='0' ORDER BY `value` DESC LIMIT 0,1000") or die(mysql_error());
$loop = 1;
while($data = mysql_fetch_array($player_highscore)){
echo "<tr>\n";
echo "<td>".$loop."</td>\n";
$name = $data['player_id'];
$player_name = mysql_query("SELECT * FROM `players` WHERE id='$name'") or die(mysql_error());
$data_name = mysql_fetch_array($player_name);
echo "<td><a href=\"?page=Search&name=".preg_replace("/".chr(32)."/", "_", $data_name['name'])."\">".$data_name['name']."</a></td>\n";
echo "<td>".$data['value']."</td>\n";
echo "</tr>\n";
$loop++;
}
break;
case Club:
$player_highscore = mysql_query("SELECT * FROM `player_skills` WHERE skillid='1' ORDER BY `value` DESC LIMIT 0,1000") or die(mysql_error());
$loop = 1;
while($data = mysql_fetch_array($player_highscore)){
echo "<tr>\n";
echo "<td>".$loop."</td>\n";
$name = $data['player_id'];
$player_name = mysql_query("SELECT * FROM `players` WHERE id='$name'") or die(mysql_error());
$data_name = mysql_fetch_array($player_name);
echo "<td><a href=\"?page=Search&name=".preg_replace("/".chr(32)."/", "_", $data_name['name'])."\">".$data_name['name']."</a></td>\n";
echo "<td>".$data['value']."</td>\n";
echo "</tr>\n";
$loop++;
}
break;
case Sword:
$player_highscore = mysql_query("SELECT * FROM `player_skills` WHERE skillid='2' ORDER BY `value` DESC LIMIT 0,1000") or die(mysql_error());
$loop = 1;
while($data = mysql_fetch_array($player_highscore)){
echo "<tr>\n";
echo "<td>".$loop."</td>\n";
$name = $data['player_id'];
$player_name = mysql_query("SELECT * FROM `players` WHERE id='$name'") or die(mysql_error());
$data_name = mysql_fetch_array($player_name);
echo "<td><a href=\"?page=Search&name=".preg_replace("/".chr(32)."/", "_", $data_name['name'])."\">".$data_name['name']."</a></td>\n";
echo "<td>".$data['value']."</td>\n";
echo "</tr>\n";
$loop++;
}
break;
case Axe:
$player_highscore = mysql_query("SELECT * FROM `player_skills` WHERE skillid='3' ORDER BY `value` DESC LIMIT 0,1000") or die(mysql_error());
$loop = 1;
while($data = mysql_fetch_array($player_highscore)){
echo "<tr>\n";
echo "<td>".$loop."</td>\n";
$name = $data['player_id'];
$player_name = mysql_query("SELECT * FROM `players` WHERE id='$name'") or die(mysql_error());
$data_name = mysql_fetch_array($player_name);
echo "<td><a href=\"?page=Search&name=".preg_replace("/".chr(32)."/", "_", $data_name['name'])."\">".$data_name['name']."</a></td>\n";
echo "<td>".$data['value']."</td>\n";
echo "</tr>\n";
$loop++;
}
break;
case Distance:
$player_highscore = mysql_query("SELECT * FROM `player_skills` WHERE skillid='4' ORDER BY `value` DESC LIMIT 0,1000") or die(mysql_error());
$loop = 1;
while($data = mysql_fetch_array($player_highscore)){
echo "<tr>\n";
echo "<td>".$loop."</td>\n";
$name = $data['player_id'];
$player_name = mysql_query("SELECT * FROM `players` WHERE id='$name'") or die(mysql_error());
$data_name = mysql_fetch_array($player_name);
echo "<td><a href=\"?page=Search&name=".preg_replace("/".chr(32)."/", "_", $data_name['name'])."\">".$data_name['name']."</a></td>\n";
echo "<td>".$data['value']."</td>\n";
echo "</tr>\n";
$loop++;
}
break;
case Fishing:
$player_highscore = mysql_query("SELECT * FROM `player_skills` WHERE skillid='5' ORDER BY `value` DESC LIMIT 0,1000") or die(mysql_error());
$loop = 1;
while($data = mysql_fetch_array($player_highscore)){
echo "<tr>\n";
echo "<td>".$loop."</td>\n";
$name = $data['player_id'];
$player_name = mysql_query("SELECT * FROM `players` WHERE id='$name'") or die(mysql_error());
$data_name = mysql_fetch_array($player_name);
echo "<td><a href=\"?page=Search&name=".preg_replace("/".chr(32)."/", "_", $data_name['name'])."\">".$data_name['name']."</a></td>\n";
echo "<td>".$data['value']."</td>\n";
echo "</tr>\n";
$loop++;
}
break;
}
echo "</table>\n";
?>