//// -------- pripojeni databaze
include("./_pripoj.php");
if(!isset($_GET["lang"])) $_GET["lang"] = '';
echo "
";
if(IsSet($_GET["act"])):
if($_GET["act"]==1):
echo $uvodni_txt;
elseif($_GET["act"]==2):
$dtz_g = MySQL_Query("SELECT year(d_od) as rocnik FROM podniky WHERE typn = '".$_GET["typ"]."' and foto != '' and uziti=3 group by year(d_od) ORDER BY year(d_od) DESC");
while($zn_g = MySQL_Fetch_Array($dtz_g)):
if($_GET["rok"]==$zn_g["rocnik"]):
echo "";
else:
echo "";
endif;
echo "[".$zn_g["rocnik"]."] ";
echo "";
endwhile;
echo "";
echo "
";
if(IsSEt($_GET["rok"])):
$dtz_g_r = MySQL_Query("SELECT * FROM podniky WHERE typn = '".$_GET["typ"]."' and foto != '' and year(d_od) = '".$_GET["rok"]."' and uziti=3 ORDER BY d_od DESC");
echo "
";
while($zn_g_r = MySQL_Fetch_Array($dtz_g_r)):
$sub_d_od_d = SubStr($zn_g_r["d_od"], 8, 2);
$sub_d_od_m = SubStr($zn_g_r["d_od"], 5, 2);
$sub_d_do_d = SubStr($zn_g_r["d_do"], 8, 2);
$sub_d_do_m = SubStr($zn_g_r["d_do"], 5, 2);
echo "".$sub_d_od_d.".".$sub_d_od_m." | ";
if($zn_g_r["d_od"]!=$zn_g_r["d_do"]):
echo "- ".$sub_d_do_d.".".$sub_d_do_m." | ";
else:
echo " | ";
endif;
if(substr($zn_g_r["foto"],0,4)=="http"):
$pp_foto=$zn_g_r["foto"];
else:
if(substr($zn_g_r["foto"],0,4)=="data"):
$pp_foto="images.php?&adresar=".$zn_g_r["foto"];
else:
$pp_foto="http://www.casomeric.cz/images.php?&adresar=".$zn_g_r["foto"];
endif;
endif;
echo "".$zn_g_r["naz_zav"]." | - ".$zn_g_r["misto"]." |
";
endwhile;
echo "
";
endif;
elseif($_GET["act"]==3):
$dtz_g = MySQL_Query("SELECT year(d_od) as rocnik FROM podniky WHERE typn = '".$_GET["typ"]."' and vysledky != '' group by year(d_od) ORDER BY year(d_od) DESC");
while($zn_g = MySQL_Fetch_Array($dtz_g)):
if($_GET["rok"]==$zn_g["rocnik"]):
echo "
";
else:
echo "";
endif;
echo "[".$zn_g["rocnik"]."] ";
echo "";
endwhile;
echo "";
echo "
";
if(IsSEt($_GET["rok"])):
$dtz_g_r = MySQL_Query("SELECT * FROM podniky WHERE typn = '".$_GET["typ"]."' and vysledky != '' and year(d_od) = '".$_GET["rok"]."' ORDER BY d_od DESC");
echo "";
while($zn_g_r = MySQL_Fetch_Array($dtz_g_r)):
$sub_d_od_d = SubStr($zn_g_r["d_od"], 8, 2);
$sub_d_od_m = SubStr($zn_g_r["d_od"], 5, 2);
$sub_d_do_d = SubStr($zn_g_r["d_do"], 8, 2);
$sub_d_do_m = SubStr($zn_g_r["d_do"], 5, 2);
echo "".$sub_d_od_d.".".$sub_d_od_m." | ";
if($zn_g_r["d_od"]!=$zn_g_r["d_do"]):
echo "- ".$sub_d_do_d.".".$sub_d_do_m." | ";
else:
echo " | ";
endif;
echo "".$zn_g_r["naz_zav"]." | - ".$zn_g_r["misto"]." |
";
endwhile;
echo "
";
endif;
endif;
endif;
?>