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