<?php  
  include 'inc/dbsettings.php';
  $db    = "player";
  mysql_connect($dbhost, $dbuser, $dbpw) OR
  die("ERROR: Connection failed. ".mysql_error());   
  mysql_select_db($db) OR
  die("ERROR: DB allready open. ".mysql_error());
$sql = "SELECT * FROM quest WHERE szName LIKE 'event_%' AND szName NOT LIKE 'event_red' AND szName NOT LIKE 'event_blue' AND szName NOT LIKE 'event_yellow' AND szName NOT LIKE 'events' ORDER BY lValue Desc limit 5";
       $i = "0" ;
  $ergebnis = mysql_query($sql);
while($row = mysql_fetch_object($ergebnis))
    {
    $i = $i + 1 ;
    $name = str_replace("event_","",$row->szName);
    echo "<tr class='ranking_rank'>
    <td class='rank'>$i</td>
    <td width='125'>$name</td>
    <td width='54'>$row->lValue</td>
    </tr>";
}
?>

  
  <div class="sidebox_head">
    <a href="javascript:void(0)" id="requirements4">Топ 5 PvP</a>
     </div>
     <div id="required4"><div class="sidebox_main">
      <table class="top" cellspacing="0" cellpadding="0">
   <tr class="top_top">
     <td class="rank">№</td>
     <td width="125">Ник</td>
     <td width="54">Убийства</td>
   </tr></table>
   <hr class="ranking_hr" />
   <table class="top" cellspacing="0" cellpadding="0">
   <?PHP include 'pages/top10_pvp.php'; ?>
</table>