<?php
 
 
require_once "../../maincore.php";
require_once THEMES."templates/header.php";
 
opentable('Naudingiausi dalyviai');
$i= 0;
$j= 0;
echo "
<table>";
 
$players = "";
$rez = mysql_query("SELECT * from zaidejai");
 
echo"<table align=\"center\" border=\"1\" ><tr><td width=\"5%\" heigt=\"50%\"><center><font color=\"black\">Vieta</font></center></td>
<td><center><font color=\"black\">Nickas</font></center></td>
<td><center><font color=\"black\">Sužaidė </font></center></td>
<td><center><font color=\"black\">Taškai </font></center></td>
<td><center><font color=\"black\">Atkovoti k. </font></center></td>
<td><center><font color=\"black\">Blokai k.</font></center></td>
<td><center><font color=\"black\">Perimti k.</font></center></td>
<td><center><font color=\"black\">Rezultatyvūs p.</font></center></td><td><center><font color=\"black\">Naudingumas </font></center></td>
</tr>";
while ($a=mysql_fetch_array($rez)){
$j = $j + 1;
$sk = mysql_fetch_array(mysql_query("SELECT * from teams where id=$a[team_id]"));
$pt=$a['Pts'] / $sk['played'];
$rb=$a['Reb'] / $sk['played'];
$bl=$a['Blk'] / $sk['played'];
$st=$a['Stl'] / $sk['played'];
$as=$a['Ass'] / $sk['played'];
 
 
 
 
 
print "
<tr><td width=\"5%\" heigt=\"50%\"><center><font color=\"black\">$j</font></center></td>
<td><center><font color=\"white\">{$a['name']}</font></center</td>
<td><center><font color=\"black\">{$sk['played']} </font></center></td>
<td><center><font color=\"black\">".round($pt, 1)." </font></center></td>
<td><center><font color=\"black\">".round($rb, 1)."</font></center></td>
<td><center><font color=\"black\">".round($bl, 1)."</font></center></td>
<td><center><font color=\"black\">".round($st, 1)."</font></center></td>
<td><center><font color=\"black\">".round($as, 1)."</font></center></td><td><center><font color=\"white\">{$a['Kof']}</font></center></td>
</tr>";
 
}
 
echo "</table>";
closetable();

$rez = mysql_query("SELECT * from zaidejai ORDER BY Kof");

$rez = mysql_query("SELECT * from zaidejai ORDER BY Kof ASC");
 
$rez = mysql_query("SELECT * from zaidejai ORDER BY Kof DESC");