<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<?php
//---------CONFIGS---------//
$title="creat by Drogata"; // Page Title Here
$type="1"; //Type 1
$server="localhost"; // MySQL IP
$user="root"; //MySQL Username
$password="your password heree"; //MySQL Password
$database="your db here"; //MySQL Database
$top="100";
//-----END OF CONFIGS-----//
if ($title) {
print("<head><title>$title</title></head>");
}
else {
print("<head><title>No Page Title</title></head>");
}
mysql_connect("$server", "$user", "$password") or die(mysql_error());
mysql_select_db("$database") or die(mysql_error());
if($type == '1'){
$result = mysql_query("SELECT char_name,pkkills FROM characters where pkkills>0 and accesslevel=0 order by pkkills desc")
or die(mysql_error());
echo "<center><h3>Top $top Pk Players</h3></center><table border=10 align=center><tr> <th>Character</th> <th>Top Kills</th> </tr>";
$sum1=0;
while($row = mysql_fetch_array( $result )) {
$name = $row['char_name'];
$pkkills = $row['pkkills'];
if ($sum1<$top) {
echo "<tr><td align=center>$name</td><td align=center>$pkkills</td></tr>";
$sum1++;
}
}
}
else {
echo "<center>Please config the variable $type. Make it <b>1</b> for Top Status</center>";
}
?>
</body>
</html>
read this a lil and you can change it for whatever you want.