
// Copyright (c) Martin Šebela (hadl), 2008 - 2009
require_once ('admin/mysql/mysql.php');
$dotaz_rubriky = "SELECT * FROM krumlov_nastaveni";
$vysledek_rubriky = mysql_query ($dotaz_rubriky);
while ($vypis_rubriky = mysql_fetch_array ($vysledek_rubriky, MYSQL_ASSOC)) {
echo "{$vypis_rubriky['rubriky']}";
}
$date = StrFTime("%d. %m. %Y - %H:%M", Time());
$date = str_replace(". 0", ". ", $date);
$num = strlen($date);
if(substr($date, 0, 1) == "0") $date = substr($date, 1, $num);
echo "
Dnes je $date.";?>
Zajímavé články
if (!isset($_GET['id_zajimave_aktuality'])||(!is_numeric($_GET['id_zajimave_aktuality']))){
$dotaz3 = "SELECT * FROM krumlov_inter_news WHERE id_zajimave_aktuality ORDER BY id_zajimave_aktuality";
$vysledek3 = mysql_query ($dotaz3);
while ($radek3 = mysql_fetch_array ($vysledek3, MYSQL_ASSOC)) {
echo "
{$radek3['nazev_zajimave_aktuality']}
{$radek3['podnadpis']}

";
}
}
if (is_numeric($_GET['id_zajimave_aktuality'])) {
$dotaz4 = "SELECT * FROM krumlov_inter_news WHERE id_zajimave_aktuality = {$_GET['id_zajimave_aktuality']}";
$vysledek4 = mysql_query ($dotaz4);
$vypis3 = mysql_fetch_array ($vysledek4, MYSQL_ASSOC);
echo "
Zajímavé Články - {$vypis3['nazev_zajimave_aktuality']}
";
echo "
• {$vypis3['nazev_zajimave_aktuality']}
{$vypis3['obsah']}
< Zpět";
}
echo "
";
if (!isset($_GET['id_aktuality'])||(!is_numeric($_GET['id_aktuality']))){
$dotaz = "SELECT * FROM krumlov_news WHERE id_aktuality ORDER BY id_aktuality DESC";
echo '
Aktuality
';
$vysledek = mysql_query ($dotaz);
while ($radek = mysql_fetch_array ($vysledek, MYSQL_ASSOC)) {
echo "
|
";
?>
";' style='cursor:pointer;'>
echo "
• {$radek['nazev_aktuality']}
{$radek['podnadpis']} |
";
}
}
if (is_numeric($_GET['id_aktuality'])) {
$dotaz1 = "SELECT * FROM krumlov_news WHERE id_aktuality = {$_GET['id_aktuality']}";
$vysledek1 = mysql_query ($dotaz1);
$vypis = mysql_fetch_array ($vysledek1, MYSQL_ASSOC);
echo "
Aktuality - {$vypis['nazev_aktuality']}
";
echo "
• {$vypis['nazev_aktuality']}
{$vypis['obsah']}
< Zpět";
}
echo "
";
$dotaz2 = "SELECT * FROM krumlov_nastaveni";
$vysledek2 = mysql_query ($dotaz2);
while ($radek1 = mysql_fetch_array ($vysledek2, MYSQL_ASSOC)) {
echo "{$radek1['copyright']}";
}
mysql_close();
?>