<?
error_reporting(E_ALL);
require("db.php");
$who = $_GET['killer'];
echo "<h4 style=\" color: #ffffff\"> Personal stats of &nbsp&nbsp ><big><i>".$who."</i></big> <</h3>";
if ($who == 'RESTART'){
?><embed src="readme.swf" height="500" width="500" type="application/x-shockwave-flash" >
<br><strong>^,...,^</strong>
<?
}
else{
echo "<h5>MVP Counter</h5>";

$query5 = "SELECT * FROM uzivatel WHERE  `nick` = '".$who."' ";
$vysledek = MySQL_query($query5, $connection) or die ($query5);
while ($zaznam = mysql_fetch_array($vysledek))
{
echo "<small>total count <b>".$zaznam['pocetmvp']."</b></small><br><br>";
}


echo "<table frame=\"box\" rules=\"rows\" cellpadding=\"5px\" bgcolor=\"#161c2e\">";
$query66 = "SELECT mvp_id, count(*) AS total FROM mvp_stat WHERE `kiler` = '".$who."' GROUP BY mvp_id ORDER BY total DESC";
$vysledek3 = MySQL_query($query66, $connection) or die ($query66);
while ($zaznam = mysql_fetch_array($vysledek3))
{
  $query2 = "SELECT * FROM mvp WHERE id= ".$zaznam['mvp_id']."";
  $vysledek2 = MySQL_query($query2, $connection) or die ($query2);
  while ($data = mysql_fetch_array($vysledek2))
  {
  echo "<tr><td valign=\"center\" align=\"center\"><a href=\"".$data['link']."\" target=\"_blank\"><img src=\"".$data['obr']."\" border=\"0\"  height=\"70px\"></a></td>";
  echo "<td align=\"center\"><b style=\"color : #ffffff\"><a href=\"?mvps&id=".$data['id']."\">".$data['nick']."</a></b></td>";
  echo "<td> &nbsp&nbsp&nbsp&nbsp&nbsp <i>count:</i>&nbsp&nbsp <b>".$zaznam['total']."</b></td></tr>";
}
}
echo "</table>";
echo "<h5>Last MVP's</h5>";



echo "<table frame=\"box\" rules=\"rows\" cellpadding=\"5px\" bgcolor=\"#161c2e\">";
$query3 = "SELECT * FROM mvp_stat WHERE  `kiler` = '".$who."' ORDER BY timekill DESC";
$vysledek3 = MySQL_query($query3, $connection) or die ($query3);

while ($zaznam = mysql_fetch_array($vysledek3))
{
$query2 = "SELECT * FROM mvp WHERE id= ".$zaznam['mvp_id']."";
$vysledek2 = MySQL_query($query2, $connection) or die ($query2);
while ($data = mysql_fetch_array($vysledek2))
{
echo "<tr><td valign=\"center\" align=\"center\"><a href=\"".$data['link']."\" target=\"_blank\"><img src=\"".$data['obr']."\" border=\"0\"  height=\"70px\"></a></td>";
echo "<td align=\"center\"><b style=\"color : #ffffff\"><a href=\"?mvps&id=".$data['id']."\">".$data['nick']."</a></b></td><td cellpadding=\"1px\"><img src=\"".$data['map']."\"></td>";
echo "<td><b style=\"color:#ffffff\" align=\"center\">".date("j.n - G:i",$zaznam['timekill'])."</b></td></tr>";
}
}
echo "</table>";
}
?>