HanWik -- pvp top 10

<?php
$hostname = "localhost"; // your database location
$database = "l2jdb"; // your l2j database
$user = "root"; // your database user
$pass = ""; // your database password

$connect = @mysql_connect($hostname, $user, $pass);
@mysql_select_db($database, $connect);

$i = 1;

$query = mysql_query("SELECT char_name FROM characters ORDER BY pvpkills DESC LIMIT 10");
while(list($result) = mysql_fetch_row($query)) {
echo $i.'.'.$result.'<br>';
$i++;
}
?>