";
echo " Goals";
echo "
| Rank |
Player |
Team |
Total |
";
$indiv_goals = mysql_query("select teams.id as teamid,player.picture,type,playerid,sum(number) as num,player.name,player.team,teams.name as teamname from game_stats inner join player on (game_stats.playerid=player.id) inner join teams on (player.team=teams.id) where approved=1 and type='Goal' group by playerid order by num desc limit 0,10;");
$i = 0;
$rank = 0;
$prev = "";
while ($row=mysql_fetch_assoc($indiv_goals))
{
// setup background colors
if ($i%2==1)
$bg = "bgcolor='#dddddd'";
else
$bg = "";
// setup rank text
if ($prev != $row['num'])
$rank = $i+1;
else
$rank = " ";
$prev = $row['num'];
// setup picture for first place
if ($i < 1)
$picture = "![](".$row[) ";
else
$picture = "";
echo "| $rank | $picture ".$row['name']." | ".$row['teamname']." | ".$row['num']." | ";
$i++;
}
mysql_free_result($indiv_goals);
echo " | ";
echo " Clean Sheets
";
echo "
| Rank |
Player |
Team |
Total |
";
$indiv_clean = mysql_query("select teams.id as teamid,player.picture,type,playerid,count(number) as num,player.name,player.team,teams.name as teamname from game_stats inner join player on (game_stats.playerid=player.id) inner join teams on (player.team=teams.id) where approved=1 and type='Clean Sheet' group by playerid order by num desc limit 0,10;");
$i = 0;
$rank = 0;
$prev = "";
while ($row=mysql_fetch_assoc($indiv_clean))
{
// setup background colors
if ($i%2==1)
$bg = "bgcolor='#dddddd'";
else
$bg = "";
// setup rank text
if ($prev != $row['num'])
$rank = $i+1;
else
$rank = " ";
$prev = $row['num'];
// setup picture for first place
if ($i==0)
$picture = "";
else
$picture = "";
echo "| $rank | $picture ".$row['name']." | ".$row['teamname']." | ".$row['num']." | ";
$i++;
}
mysql_free_result($indiv_clean);
echo " |
";
echo " Yellow Cards
";
echo "
| Rank |
Player |
Team |
Total |
";
$indiv_yellow = mysql_query("select teams.id as teamid,player.picture,type,playerid,sum(number) as num,player.name,player.team,teams.name as teamname from game_stats inner join player on (game_stats.playerid=player.id) inner join teams on (player.team=teams.id) where approved=1 and type='Yellow Card' group by playerid order by num desc limit 0,10;");
$i = 0;
$rank = 0;
$prev = "";
while ($row=mysql_fetch_assoc($indiv_yellow))
{
// setup background colors
if ($i%2==1)
$bg = "bgcolor='#dddddd'";
else
$bg = "";
// setup rank text
if ($prev != $row['num'])
$rank = $i+1;
else
$rank = " ";
$prev = $row['num'];
// setup picture for first place
if ($i==0)
$picture = "";
else
$picture = "";
echo "| $rank | $picture ".$row['name']." | ".$row['teamname']." | ".$row['num']." | ";
$i++;
}
mysql_free_result($indiv_yellow);
echo " |
";
echo " Red Cards
";
echo "
| Rank |
Player |
Team |
Total |
";
$indiv_red = mysql_query("select teams.id as teamid,player.picture,type,playerid,sum(number) as num,player.name,player.team,teams.name as teamname from game_stats inner join player on (game_stats.playerid=player.id) inner join teams on (player.team=teams.id) where approved=1 and type='Red Card' group by playerid order by num desc limit 0,10;");
$i = 0;
$rank = 0;
$prev = "";
while ($row=mysql_fetch_assoc($indiv_red))
{
// setup background colors
if ($i%2==1)
$bg = "bgcolor='#dddddd'";
else
$bg = "";
// setup rank text
if ($prev != $row['num'])
$rank = $i+1;
else
$rank = " ";
$prev = $row['num'];
// setup picture for first place
if ($i==0)
$picture = "";
else
$picture = "";
echo "| $rank | $picture ".$row['name']." | ".$row['teamname']." | ".$row['num']." | ";
$i++;
}
mysql_free_result($indiv_red);
echo " |
";
echo "
";
echo " Shots on Target";
echo "
| Rank |
Team |
Total |
Average | ";
$i = 0;
while ($row=mysql_fetch_assoc($team_ShotsTarget))
{
if ($i%2==1)
$bg = "bgcolor='#dddddd'";
else
$bg = "";
if ($i<1)
$pic = "";
else
$pic = "";
$rank = $i+1;
echo "| $rank | $pic".$row['name']." | ".$row['sum(number)']." | ".number_format($row['a1'],2,'.','')." | ";
$i++;
}
mysql_free_result($team_ShotsTarget);
echo " | ";
$team_Shots = mysql_query("select logo,type,teamid,teams.name,sum(number),avg(number) as a1 from game_stats_team inner join teams on (game_stats_team.teamid=teams.id) where approved=1 and type='Total Shots' group by 'teamid' having avg(number) > 0 order by a1 desc limit 0,10;");
echo " Total Shots ";
echo "
| Rank |
Team |
Total |
Average | ";
$i = 0;
while ($row=mysql_fetch_assoc($team_Shots))
{
if ($i%2==1)
$bg = "bgcolor='#dddddd'";
else
$bg = "";
if ($i<1)
$pic = "";
else
$pic = "";
$rank = $i + 1;
echo "| $rank | $pic".$row['name']." | ".$row['sum(number)']." | ".number_format($row['a1'],2,'.','')." | ";
$i++;
}
mysql_free_result($team_Shots);
echo " |
";
$team_Pos = mysql_query("select logo,type,teamid,teams.name,sum(number),avg(number) as a1 from game_stats_team inner join teams on (game_stats_team.teamid=teams.id) where approved=1 and type='Possession %' group by 'teamid' having avg(number) > 0 order by a1 desc limit 0,10;");
echo "
Possession %";
echo "
| Rank |
Team |
Average | ";
$i = 0;
$prev = "";
while ($row=mysql_fetch_assoc($team_Pos))
{
if ($i%2==1)
$bg = "bgcolor='#dddddd'";
else
$bg = "";
if ($i<1)
$pic = "";
else
$pic = "";
$rank = $i+1;
echo "| $rank | $pic".$row['name']." | ".number_format($row['a1'],2,'.','')." | ";
$i++;
}
mysql_free_result($team_Pos);
//echo "";
include('footer.php');
?>
|