Pořadí |
Jméno |
Počet závodů |
Dosažený
počet X
( if ($ID == 2) echo "6 nejlepších výsledků"; else echo "4 nejlepší výsledky"; ?>) |
Dosažený
počet X
(celkový počet) |
$Line = true;
$Query = "SELECT DISTINCT A.FirstName, A.LastName, A.ID FROM br_clubs_persons A, br_comp_results B, br_competitions C WHERE A.ID=B.UserID AND C.LeagueID=$ID AND B.CompID=C.ID";
$Result = $Db->db_query($Query);
if (!$Result)
die("Chyba při dotazu na data !!!");
$Lines = 0;
while ($Row = $Db->db_array($Result))
{
$QueryMatches = "SELECT COUNT(A.ID) as Matches FROM br_competitions A, br_comp_results B WHERE A.LeagueID=$ID AND B.CompID=A.ID AND UserID=".$Row["ID"];
$ResultMatches = $Db->db_query($QueryMatches);
$RowMatches = $Db->db_array($ResultMatches);
$Results[$Lines]["ID"] = $Row["ID"];
$Results[$Lines]["Name"] = $Row["LastName"]." ".$Row["FirstName"];
$QueryShooter = "SELECT Xs FROM br_competitions A, br_comp_results B WHERE A.LeagueID=$ID AND B.CompID=A.ID AND UserID=".$Row["ID"]." ORDER BY B.Xs DESC";
$ResultShooter = $Db->db_query($QueryShooter);
$Xs = 0;
$Xs_all = 0;
$Step = 0;
while ($RowShooter = $Db->db_array($ResultShooter))
{
if ($ID == 2)
{
if ($Step < 6)
$Xs = $Xs + $RowShooter["Xs"];
$Xs_all = $Xs_all + $RowShooter["Xs"];
$Step++;
}
else
{
if ($Step < 4)
$Xs = $Xs + $RowShooter["Xs"];
$Xs_all = $Xs_all + $RowShooter["Xs"];
$Step++;
}
}
$Results[$Lines]["Xs_all"] = $Xs_all;
$Results[$Lines]["Xs"] = $Xs;
$Results[$Lines]["Matches"] = $RowMatches["Matches"];
$Lines++;
}
// seradit vysledky podle poctu X
for ($Lines = 0; $Lines < count($Results); $Lines++)
{
$Sequence = 0;
for ($i = 0; $i < count($Results); $i++)
{
if ($Lines != $i)
{
if ($Results[$Lines]["Xs"] < $Results[$i]["Xs"])
{
$Sequence++;
}
else
{
if ($Results[$Lines]["Xs"] == $Results[$i]["Xs"])
{
if ($Results[$Lines]["Xs_all"] < $Results[$i]["Xs_all"])
{
$Sequence++;
}
}
}
}
}
while (!empty($Order[$Sequence]))
$Sequence++;
$Order[$Sequence] = $Results[$Lines];
}
for ($Lines=0; $Lines < count($Results); $Lines++)
{
if ($Line == true)
$Color = "#FFFFCC";
else
$Color = "#EEEEBB";
$Line = !$Line;
echo "".($Lines + 1)." | \n";
echo "".$Order[$Lines]["Name"]." | \n";
echo "".$Order[$Lines]["Matches"]." | \n";
echo "".$Order[$Lines]["Xs"]." | \n";
echo "".$Order[$Lines]["Xs_all"]." | \n";
echo "
\n";
}
?>