mysql_server,$classpage->mysql_login,$classpage->mysql_pass);
@ $vyberdb = mysql_select_db($classpage->mysql_db);
if( ($id = $_GET["aktid"]) && ($id > 0) ) { // mam ID akce - zobrazim detaily akce
$title = "Aktualita";
$db_ok = 0;
$query_akce = "SELECT dpmz_aktuality.id as aktid,
DATE_FORMAT(dpmz_aktuality.datum, '%e.%c.%Y') as kdy,
DATE_FORMAT(dpmz_aktuality.datum, '%e') as kdy_den,
DATE_FORMAT(dpmz_aktuality.datum, '%c') as kdy_mesic,
DATE_FORMAT(dpmz_aktuality.datum, '%Y') as kdy_rok,
dpmz_aktuality.nazev as nazev,
dpmz_aktuality.zprava as zprava,
dpmz_aktuality.galerieid as galerieid,
dpmz_organizace.uname as uname
FROM dpmz_aktuality, dpmz_organizace
WHERE dpmz_aktuality.orgid = dpmz_organizace.id
AND dpmz_aktuality.aktivni < 2
AND dpmz_aktuality.id = ".$id;
if($get_akce = mysql_query($query_akce)) {
if( ($number_akce = mysql_num_rows($get_akce)) && ($number_akce > 0) ) {
$db_ok++;
$row = mysql_fetch_array($get_akce);
$aktid = $row["aktid"];
$akce_kdy = $row["kdy"];
$akce_kdy_den = $row["kdy_den"];
$akce_kdy_mesic = $row["kdy_mesic"];
$akce_kdy_rok = $row["kdy_rok"];
if($akce_kdy_den < 1) $akce_kdy = $classpage->mesice[($akce_kdy_mesic - 1)]." ".$akce_kdy_rok;
$nazev = stripslashes($row["nazev"]);
$zprava = stripslashes($row["zprava"]);
$galerieid = $row["galerieid"];
$orguname = stripslashes($row["uname"]);
$title = $nazev;
} // end number
else echo "Momentálně nemohu zobrazit aktualitu. [db num]
\n";
} // end res
else echo "Momentálně nemohu zobrazit aktualitu. [db res]
\n";
$classpage->displayTop(88,0,"",$title);
echo "\n";
if($db_ok < 1) echo "Momentálně nemohu zobrazit aktualitu. [db]
\n";
else {
// echo "Kalendář akcí > ".$title."
\n";
// echo "".$nazev."
";
if(!($nazev == "")) echo "".stripslashes($nazev)."
\n";
echo "\n";
echo "
".$akce_kdy."
\n";
if(!($zprava == "")) echo "
".stripslashes($zprava)."
\n";
echo "
\n";
// fotogalerie
if($galerieid > 0) {
$query_fotog = "SELECT dpmz_fotogalerie_seznam.id as id,
dpmz_fotogalerie_seznam.adresar as adresar,
DATE_FORMAT(dpmz_fotogalerie_seznam.datum, '%e.%c.%Y') as kdy,
dpmz_fotogalerie_seznam.nazev as nazev,
dpmz_fotogalerie_seznam.thumbname as thumbname,
dpmz_organizace.uname as uname
FROM dpmz_fotogalerie_seznam, dpmz_organizace
WHERE dpmz_fotogalerie_seznam.orgid = dpmz_organizace.id
AND dpmz_fotogalerie_seznam.id = ".$galerieid;
if($get_fotog = mysql_query($query_fotog)) {
if( ($number_fotog = mysql_num_rows($get_fotog)) && ($number_fotog > 0) ) {
echo "
\n";
echo "
Fotogalerie
\n";
for($i = 0; $i < $number_fotog; $i++) {
$row_fotog = mysql_fetch_array($get_fotog);
$fotog_id = $row_fotog["id"];
$adresar = $row_fotog["adresar"];
$kdy = $row_fotog["kdy"];
$nazev = $row_fotog["nazev"];
$thumbname = $row_fotog["thumbname"];
$uname = $row_fotog["uname"];
echo "
\n";
} // end for
echo "
\n";
} // end akce num
} // end akce res
} // end galerieid
echo "
\n";
for($d = 0; $d < $number_foto; $d++) {
$row_foto = mysql_fetch_array($get_foto);
$imgname = $row_foto["imgname"];
$width = $row_foto["width"];
$height = $row_foto["height"];
$popis = $row_foto["popis"];
echo "
![\"\"](\"/images/organizace/".$orguname."/aktuality/".$aktid."/".$imgname.".jpg\")
\n";
} // end for
echo "
";
if( ($uname = $_GET["uname"]) && (!($uname == "")) ) echo "".$classpage->pages_organizace[$uname][0]." / ";
echo "Aktuality";
echo "
\n";
$kolik = 20; // kolik aktualit na 1 strance
@ $limit = $_GET["limit"]; // od ktere aktuality se bude zacinat
if(!isset($limit)) $limit = 0;
// celkovy pocet aktualit
if($uname == "") $query_pocet_celkem = "SELECT COUNT(id) FROM dpmz_aktuality WHERE aktivni < 2";
else {
$query_pocet_celkem = "SELECT COUNT(dpmz_aktuality.id)
FROM dpmz_aktuality, dpmz_organizace
WHERE dpmz_aktuality.aktivni < 2
AND dpmz_aktuality.orgid = dpmz_organizace.id
AND dpmz_organizace.uname = \"".$uname."\"";
}
if($get_pocet_celkem = mysql_query($query_pocet_celkem)) {
$row_pocet = mysql_fetch_row($get_pocet_celkem);
$pocet_celkem = $row_pocet[0];
} // end get pocet
// aktuality
if(!($uname == "")) {
$query_aktuality = "SELECT dpmz_aktuality.id as id,
dpmz_aktuality.nazev as nazev,
DATE_FORMAT(dpmz_aktuality.datum, '%e.%c.%Y') as kdy,
DATE_FORMAT(dpmz_aktuality.datum, '%e') as kdy_den,
DATE_FORMAT(dpmz_aktuality.datum, '%c') as kdy_mesic,
DATE_FORMAT(dpmz_aktuality.datum, '%Y') as kdy_rok,
dpmz_aktuality.thumbname as thumbname,
dpmz_organizace.uname as orguname,
dpmz_organizace.nazev as nazevorg
FROM dpmz_aktuality, dpmz_organizace
WHERE dpmz_aktuality.aktivni < 2
AND dpmz_aktuality.orgid = dpmz_organizace.id
AND dpmz_organizace.uname = \"".$uname."\"
ORDER BY dpmz_aktuality.datum DESC
LIMIT ".$limit.",".$kolik;
}
else {
$query_aktuality = "SELECT dpmz_aktuality.id as id,
dpmz_aktuality.nazev as nazev,
DATE_FORMAT(dpmz_aktuality.datum, '%e.%c.%Y') as kdy,
DATE_FORMAT(dpmz_aktuality.datum, '%e') as kdy_den,
DATE_FORMAT(dpmz_aktuality.datum, '%c') as kdy_mesic,
DATE_FORMAT(dpmz_aktuality.datum, '%Y') as kdy_rok,
dpmz_aktuality.thumbname as thumbname,
dpmz_organizace.uname as orguname,
dpmz_organizace.nazev as nazevorg
FROM dpmz_aktuality, dpmz_organizace
WHERE dpmz_aktuality.aktivni < 2
AND dpmz_aktuality.orgid = dpmz_organizace.id
ORDER BY dpmz_aktuality.datum DESC
LIMIT ".$limit.",".$kolik;
}
// echo "".$query_aktuality."
\n";
if($get_aktuality = mysql_query($query_aktuality)) {
if( ($number_aktuality = mysql_num_rows($get_aktuality)) && ($number_aktuality > 0) ) {
for($i = 0; $i < $number_aktuality; $i++) {
$row_akce = mysql_fetch_array($get_aktuality);
$akce_id = $row_akce["id"];
$nazev = $row_akce["nazev"];
$akce_kdy = $row_akce["kdy"];
$akce_kdy_den = $row_akce["kdy_den"];
$akce_kdy_mesic = $row_akce["kdy_mesic"];
$akce_kdy_rok = $row_akce["kdy_rok"];
if($akce_kdy_den < 1) $akce_kdy = $classpage->mesice[($akce_kdy_mesic - 1)]." ".$akce_kdy_rok;
$akce_kdy_rok = $row_akce["kdy_rok"];
$thumbname = $row_akce["thumbname"];
$orguname = $row_akce["orguname"];
$nazevorg = $row_akce["nazevorg"];
echo "\n";
} // end for
// =================================== strankovani ========================================
$kmax = $pocet_celkem;
if($kmax > $kolik) { // resim strankovani, jen pokud celkovy pocet inzeratu je vetsi nez max. zobrazovane mnozstvi
echo "Zobrazené aktuality:
";
for($i = 0; $i < $kmax; $i = $i + $kolik) {
$citac = $i + 1;
$od = $citac;
$do = $i + $kolik;
if($kmax < $do) $do = $kmax;
if($limit == $i) echo "
".$od." - ".$do."";
else {
echo "
".$od." - ".$do."";
}
// if($do < $kmax) echo " | ";
} // end for
echo "
Momentálně nemohu zobrazit přehled aktualit. [DB res]
\n";
} // end else - neni ID akce
@ mysql_query($query_log);
$classpage -> displayBottom(); ?> ![\"\"](\"/images/organizace/".$uname."/".$adresar."/".$thumbname."\")
";
echo stripslashes($nazev);
echo "\n";
echo "![\"\"](\"/images/organizace/".$orguname."/aktuality/".$akce_id."/".$thumbname."\")
";
echo stripslashes($nazev);
echo "