include_once("./_config/App.php");
$Connection = $Db->db_connect();
if (!$Connection)
die("Chyba připojení k databázi!!!");
if (!isset($CID))
$CID = 0;
?>
...::: BENCHREST.CZ :::...
Přihlášen:
if (empty($brUser->LoginName))
echo "neznámý";
else
echo($brUser->LoginName);
?>
$Query = "SELECT A.*, B.RangeAddress FROM br_competitions A LEFT OUTER JOIN br_ranges B ON (A.PlaceID=B.ID) WHERE A.ID=$CID";
$Result = $Db->db_query($Query);
if (!SResult)
die("Chyba při dotazu na data!!!");
$Row = $Db->db_array($Result);
echo $Row["CompName"]." ";
echo $Row["RangeAddress"]." ";
echo "Počet terčů: ".$Row["Targets"]."
$Query = "SELECT FirstName, LastName, MBR_IS_sharing FROM br_match_regs WHERE MBR_IS AND CompetitionID=$CID";
$Result = $Db->db_query($Query);
if (!$Result)
die("Chyba při dotazu na data!!!");
if ($Db->db_numrows($Result) > 0)
{
echo " Třída Rimfire International Sporter";
echo "
";
}
$Query = "SELECT FirstName, LastName, MBR_LV_sharing FROM br_match_regs WHERE MBR_LV AND CompetitionID=$CID";
$Result = $Db->db_query($Query);
if (!$Result)
die("Chyba při dotazu na data!!!");
if ($Db->db_numrows($Result) > 0)
{
echo " Třída Rimfire Light Varmint";
echo "
";
}
$Query = "SELECT FirstName, LastName, MBR_HV_sharing FROM br_match_regs WHERE MBR_HV AND CompetitionID=$CID";
$Result = $Db->db_query($Query);
if (!$Result)
die("Chyba při dotazu na data!!!");
if ($Db->db_numrows($Result) > 0)
{
echo " Třída Rimfire Heavy Varmint";
echo "
";
}
$Query = "SELECT FirstName, LastName, AIR_IS_sharing FROM br_match_regs WHERE AIR_IS AND CompetitionID=$CID";
$Result = $Db->db_query($Query);
if (!$Result)
die("Chyba při dotazu na data!!!");
if ($Db->db_numrows($Result) > 0)
{
echo " Třída Air rifle International Sporter";
echo "
";
}
$Query = "SELECT FirstName, LastName, AIR_LV_sharing FROM br_match_regs WHERE AIR_LV AND CompetitionID=$CID";
$Result = $Db->db_query($Query);
if (!$Result)
die("Chyba při dotazu na data!!!");
if ($Db->db_numrows($Result) > 0)
{
echo " Třída Air rifle Light Varmint";
echo "
";
}
$Query = "SELECT FirstName, LastName, AIR_HVA_sharing FROM br_match_regs WHERE AIR_HVA AND CompetitionID=$CID";
$Result = $Db->db_query($Query);
if (!$Result)
die("Chyba při dotazu na data!!!");
if ($Db->db_numrows($Result) > 0)
{
echo " Třída Air rifle Heavy Varmint A";
echo "
";
}
$Query = "SELECT FirstName, LastName, AIR_HVB_sharing FROM br_match_regs WHERE AIR_HVB AND CompetitionID=$CID";
$Result = $Db->db_query($Query);
if (!$Result)
die("Chyba při dotazu na data!!!");
if ($Db->db_numrows($Result) > 0)
{
echo " Třída Air rifle Heavy Varmint B";
echo "