...::: BENCHREST.CZ :::...

db_connect(); if (!$Connection) echo "Chyba připojení k databázi"; $ResRating = $Db->db_query("SELECT * FROM br_rating WHERE LeagueID='11' ORDER BY Sequence"); if (!$ResRating) die ("Chyba při dotazu na data !!! (3001)"); $Poradi = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); while ($RowRating = $Db->db_array($ResRating)) $Poradi[$RowRating["Sequence"]] = $RowRating["Points"]; $ResComps = $Db->db_query("SELECT * FROM br_competitions WHERE LeagueID IN (9,10,11) AND ShowComp ='1' ORDER BY CompMonth, CompDay"); if (!$ResComps) die ("Chyba při dotazu na data !!! (3002)"); $i = 1; while ($RowComps = $Db->db_array($ResComps)) { //vypocet prumeru bodu zavodu $ResAvgB = $Db->db_query("SELECT Points FROM br_comp_results WHERE CompID='".$RowComps["ID"]."' ORDER BY Position"); if (!$ResAvgB) die ("Chyba při dotazu na data !!! (3003)"); $Numrows = $Db->db_numrows($ResAvgB); $Pocet = round($Numrows/2, 0); $SumAvgB = 0; for ($j=0; $j<$Pocet;$j++) { $RowAvgB = $Db->db_array($ResAvgB); $SumAvgB += $RowAvgB["Points"]; } $AvgB[$i] = round($SumAvgB / $Pocet, 1); //vypocet prumeru X zavodu $ResAvgX = $Db->db_query("SELECT Xs FROM br_comp_results WHERE CompID='".$RowComps["ID"]."' ORDER BY Xs DESC"); if (!$ResAvgX) die ("Chyba při dotazu na data !!! (3004)"); $SumAvgX = 0; for ($j=0;$j<$Pocet;$j++) { $RowAvgX = $Db->db_array($ResAvgX); $SumAvgX += $RowAvgX["Xs"]; } $AvgX[$i] = round($SumAvgX / $Pocet, 1); $i++; } // nalezeni strelcu s ucasti v mistrovstvi benchrest.cz $ResultShooter = $Db->db_query("SELECT FirstName, LastName FROM br_clubs_persons WHERE ID=$Shooter"); if (!$ResultShooter) die ("Chyba při dotazu na data !!! (3005)"); $Ranges = array(1, 2, 3, 6, 7); $RowShooter = $Db->db_array($ResultShooter); $ResultComps = $Db->db_query("SELECT A.Pool, B.Points, B.Xs, B.Position, C.PlaceID FROM br_league_spec A LEFT OUTER JOIN br_comp_results B ON (A.CompID=B.CompID AND B.UserID=$Shooter) LEFT OUTER JOIN br_competitions C ON (B.CompID=C.ID) ORDER BY Pool"); if (!$ResultComps) die ("Chyba při dotazu na data !!! (3006)"); $Competition = array(); $Pool = 0; while ($RowComps = $Db->db_array($ResultComps)) { if ($RowComps["Position"] > 20 || $RowComps["Position"] == "") $BonusP = 0; else $BonusP = $Poradi[$RowComps["Position"]]; // $Comps[$Index][$RowComps["Pool"]]["BonusP"] = $BonusP; if ($RowComps["Points"] > $AvgB[$RowComps["Pool"]]) $BonusB = $RowComps["Points"] * 10 - $AvgB[$RowComps["Pool"]] * 10; else $BonusB = 0; // $Comps[$Index][$RowComps["Pool"]]["BonusB"] = $BonusB; if ($RowComps["Xs"] > $AvgX[$RowComps["Pool"]]) $BonusX = ceil($RowComps["Xs"] - $AvgX[$RowComps["Pool"]]); else $BonusX = 0; // $Comps[$Index][$RowComps["Pool"]]["BonusX"] = $BonusX; $Competition[$Pool]["BonusP"] = $BonusP; $Competition[$Pool]["BonusB"] = $BonusB; $Competition[$Pool]["BonusX"] = $BonusX; $Competition[$Pool]["PlaceID"] = $RowComps["PlaceID"]; $Competition[$Pool]["Position"] = $RowComps["Position"]; $Competition[$Pool]["Points"] = $RowComps["Points"]; $Competition[$Pool]["Xs"] = $RowComps["Xs"]; $Pool++; } $Index++; ?> ...::: BENCHREST.CZ :::...

Přehled dosažených výsledků Mistrovství benchrest.cz

"; echo ""; echo ""; echo ""; echo ""; } ?>

Soutěž		Malý Újezd	Josefův Důl	Halda Vinařice	Mladá Boleslav	Velvary
$Round. kolo	umístění nástřel body za pořadí body za průměr body za X body celkem	"; if ($Competition[$i]["PlaceID"] == 1) echo " ".$Competition[$i]["Position"].". místo ".$Competition[$i]["Points"]."/".$Competition[$i]["Xs"]." ".$Competition[$i]["BonusP"]." B ".$Competition[$i]["BonusB"]." B ".$Competition[$i]["BonusX"]." B ".$BodyAll." B "; else echo " "; echo "	"; if ($Competition[$i]["PlaceID"] == 2) echo " ".$Competition[$i]["Position"].". místo ".$Competition[$i]["Points"]."/".$Competition[$i]["Xs"]." ".$Competition[$i]["BonusP"]." B ".$Competition[$i]["BonusB"]." B ".$Competition[$i]["BonusX"]." B ".$BodyAll." B "; else echo " "; echo "	"; if ($Competition[$i]["PlaceID"] == 3) echo " ".$Competition[$i]["Position"].". místo ".$Competition[$i]["Points"]."/".$Competition[$i]["Xs"]." ".$Competition[$i]["BonusP"]." B ".$Competition[$i]["BonusB"]." B ".$Competition[$i]["BonusX"]." B ".$BodyAll." B "; else echo " "; echo "	"; if ($Competition[$i]["PlaceID"] == 6) echo " ".$Competition[$i]["Position"].". místo ".$Competition[$i]["Points"]."/".$Competition[$i]["Xs"]." ".$Competition[$i]["BonusP"]." B ".$Competition[$i]["BonusB"]." B ".$Competition[$i]["BonusX"]." B ".$BodyAll." B "; else echo " "; echo "	"; if ($Competition[$i]["PlaceID"] == 7) echo " ".$Competition[$i]["Position"].". místo ".$Competition[$i]["Points"]."/".$Competition[$i]["Xs"]." ".$Competition[$i]["BonusP"]." B ".$Competition[$i]["BonusB"]." B ".$Competition[$i]["BonusX"]." B ".$BodyAll." B "; else echo " "; echo "