<?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);?>