There is php code for TOP 50 PVP, PK
<?
$ip = "your database ip or name";
$user = "user";
$pass = "password";
$db = "lin2world";
if($_GET['orderby']) $orderby = (int)$_GET['orderby']; // Forced to int to prevent SQL injection
else $orderby = 2; // Default order
$query = " SELECT TOP 50 char_name,duel,pk FROM user_data WHERE builder = 0 AND account_id > 0 ORDER BY $orderby DESC ";
$dbh = connect($ip,$user,$pass,$db);
$PVPlist = do_query($dbh,$query);
echo "
<table border='0' width='500'>
<tr class='tr0'>
<td align='center' width='50'><b>Rank</b></td>
<td align='center' width='150'><b>Player Name</b></td>
<td align='center' width='90'><b><a href='?orderby=2'>PVP Points</a></b></td>
<td align='center' width='90'><b><a href='?orderby=3'>PK Points</a></b></td>
</tr>
";
$i=1;
foreach($PVPlist as $p)
{
echo "
<tr class='tr".($i%2)."'>
<td align='center'>".$i."</td>
<td align='center'>".$p['char_name']."</td>
<td align='center'>".$p['duel']."</td>
<td align='center'>".$p['pk']."</td>
</tr>
";
$i++;
}
echo "</tr></table>";
function do_query($dbh=NULL,$query)
{
$arr = array();
$result = @mssql_query($query,$dbh);
for ($x=0; $arr[$x] = @mssql_fetch_assoc($result); $x++);
unset($arr[count($arr)-1]);
return $arr;
}
function connect($ip,$user,$pass,$db)
{
$dbh = mssql_connect($ip,$user,$pass);
mssql_select_db($db,$dbh);
return $dbh;
}
?>