db_connect(); if (!$Connection) die("Chyba připojení k databázi!!!"); ?> ...::: BENCHREST.CZ :::...
     
  Přihlášen: LoginName)) echo "neznámý"; else echo($brUser->LoginName); ?>
 
Menu
 
Celkové (průběžné) výsledky - db_query($Query); $Row = $Db->db_array($Result); echo $Row["League"]; ?>
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 "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } ?>
Pořadí Jméno Počet
závodů
Dosažený
počet X
()
Dosažený
počet X
(celkový počet)
".($Lines + 1)."".$Order[$Lines]["Name"]."".$Order[$Lines]["Matches"]."".$Order[$Lines]["Xs"]."".$Order[$Lines]["Xs_all"]."