<?php
$server_ip = "localhost";
$mysql_user = "root";
$mysql_pass = "root123";
$database = "l2jdb";
$connect = mysql_connect("$server_ip", "$mysql_user", "$mysql_pass");
if(!$connect){
die('Negaliu prisijungti:'. mysql_error());
}
$db_select = mysql_select_db("$database", $connect);
if(!$db_select){
die('Nerasta Duomenu baze:'. mysql_error());
}
$top = mysql_query("SELECT char_name, pvpkills, online FROM characters ORDER BY pvpkills DESC LIMIT 10");
$pos = 0;
echo"<table cellspacing='5' border='0'>";
echo"<tr><td>Nr.</td><td>Nick</td><td>PvP</td><td>Status</td></tr>";
while($row=mysql_fetch_array($top)){
$pvpkill = $row['pvpkills'];
$nick = $row['char_name'];
$online = $row['online'];
if($online ==1){
$online = 'Online';
}
else{
$online = 'Offline';
}
$pos++;
echo"<tr><td>$pos.</td><td>$nick</td><td>$pvpkill</td><td>($online)</td></tr>";
}
echo"</table>";
mysql_close($connect);
?>