PVP rank? You will need a quest which counts up or you read it from the log table (i would prefer the Quest
)
for a normal Ranking you could use sth like this:
PHP Code:
<?
$e = mysql_query("SELECT name,level,exp from player.player order by level,exp,name desc limit 50");
echo "<table><tr><td>Name</td><td>Level</td><td>EXP</td></tr>";
while($r = mysql_fetch_object($e))
{
echo "<tr><td>".$r->name."</td><td>".$r->level."</td><td>".$r->exp."</td></tr>";
}
echo "</table>";
?>