THIS IS CODE ON TOP 20 PK. ONLY ADD SERVER CONNECTION
<?php
$dbserver="";
$dblogin="";
$dbpass="";
$dbname="";
mysql_connect($dbserver, $dblogin, $dbpass);
mysql_select_db($dbname);
mysql_query("SET NAMES 'utf8'");
$vypis = mysql_query("SELECT * FROM characters WHERE (accesslevel < '1') AND (pkkills > '0') order by pkkills desc LIMIT 20");
echo '<table><tr><td><center>Nick</center></td><td></td><td>Kills</td></tr>';
while($row = mysql_fetch_array($vypis))
{
echo '<tr><td><font color="green">';
echo $row["char_name"];
echo '</font></td><td> </td><td><font color="blue">';
echo $row["pkkills"];
echo '</font></td></tr>';
}
echo '</table>';
?>
THIS IS CODE ON TOP 20 PvP. ONLY ADD SERVER CONNECTION
<?php
$dbserver="";
$dblogin="";
$dbpass="";
$dbname="";
mysql_connect($dbserver, $dblogin, $dbpass);
mysql_select_db($dbname);
mysql_query("SET NAMES 'utf8'");
$vypis = mysql_query("SELECT * FROM characters WHERE (accesslevel < '1') AND (pvpkills > '0') order by pvpkills desc LIMIT 20");
echo '<table><tr><td><center>Nick</center></td><td></td><td>Kills</td></tr>';
while($row = mysql_fetch_array($vypis))
{
echo '<tr><td><font color="green">';
echo $row["char_name"];
echo '</font></td><td> </td><td><font color="blue">';
echo $row["pvpkills"];
echo '</font></td></tr>';
}
echo '</table>';
?>