Top 10 PvP

[Swarlog]

Código [Seleccionar] Expandir

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