id; $title=$radek_stranka->nazev; if($_GET[novinka]) { $query = "SELECT a.blok AS id, a.obsah_ret AS nazev, b.obsah_int AS datum, c.obsah_text AS text, d.obsah_int AS aktivni, e.obsah_int AS galerie FROM obsah_tlacitek AS a, obsah_tlacitek AS b, obsah_tlacitek AS c, obsah_tlacitek AS d, obsah_tlacitek AS e WHERE a.tlacitko = 222 AND b.tlacitko = 223 AND c.tlacitko = 229 AND d.tlacitko = 230 AND e.tlacitko = 224 AND a.blok = b.blok AND a.blok = c.blok AND a.blok = d.blok AND a.blok = e.blok AND d.obsah_int='50' AND a.blok='".intval($_GET[novinka])."'"; $da_novinka=MySQL_Query($query); $radek_novinka = MySQL_Fetch_Object($da_novinka); $title=$radek_novinka->nazev; } else { $keywords=$radek_stranka->keywords; $description=$radek_stranka->description; } include "header.php"; ?>
id) { ?>

nazev; ?>

datum); ?>
perex) { ?>
perex; ?>
text; if($radek_novinka->galerie) { ?>

Archiv novinek

nazev; ?>

pocet; $query = "SELECT count(a.blok) AS pocet FROM obsah_tlacitek AS a, obsah_tlacitek AS d WHERE a.tlacitko = 15 AND d.tlacitko = 75 AND a.blok = d.blok AND d.obsah_int=22"; $da_pocet=MySQL_Query($query); $radek_pocet = MySQL_Fetch_Object($da_pocet); $pocet+=$radek_pocet->pocet; $akce_do=Time()+7*24*60*60; $query = "SELECT a.blok AS id, a.obsah_ret AS nazev, b.obsah_int AS datum, c.obsah_text AS perex, d.obsah_int AS aktivni, 1 as druh FROM obsah_tlacitek AS a, obsah_tlacitek AS b, obsah_tlacitek AS c, obsah_tlacitek AS d WHERE a.tlacitko = 222 AND b.tlacitko = 223 AND c.tlacitko = 228 AND d.tlacitko = 230 AND a.blok = b.blok AND a.blok = c.blok AND a.blok = d.blok AND d.obsah_int=50 UNION SELECT a.blok AS id, a.obsah_ret AS nazev, b.obsah_int AS datum, c.obsah_text AS perex, d.obsah_int AS aktivni, 2 as druh FROM obsah_tlacitek AS a, obsah_tlacitek AS b, obsah_tlacitek AS c, obsah_tlacitek AS d WHERE a.tlacitko = 15 AND b.tlacitko = 16 AND c.tlacitko = 17 AND d.tlacitko = 75 AND a.blok = b.blok AND a.blok = c.blok AND a.blok = d.blok AND d.obsah_int=22 AND b.obsah_int<'".intval($akce_do)."' order by datum desc, id desc limit $min, $posun"; } else { $query = "SELECT count(a.blok) AS pocet FROM obsah_tlacitek AS a, obsah_tlacitek AS d WHERE a.tlacitko = 222 AND d.tlacitko = 230 AND a.blok = d.blok AND d.obsah_int=50"; $da_pocet=MySQL_Query($query); $radek_pocet = MySQL_Fetch_Object($da_pocet); $pocet=$radek_pocet->pocet; $query = "SELECT a.blok AS id, a.obsah_ret AS nazev, b.obsah_int AS datum, c.obsah_text AS perex, d.obsah_int AS aktivni FROM obsah_tlacitek AS a, obsah_tlacitek AS b, obsah_tlacitek AS c, obsah_tlacitek AS d WHERE a.tlacitko = 222 AND b.tlacitko = 223 AND c.tlacitko = 228 AND d.tlacitko = 230 AND a.blok = b.blok AND a.blok = c.blok AND a.blok = d.blok AND d.obsah_int=50 order by datum desc, id desc limit $min, $posun"; } $da__novinky=MySQL_Query($query); $i=0; while($radek__novinky = MySQL_Fetch_Object($da__novinky)) { $odkaz="novinka"; if($radek__novinky->druh==2) { $odkaz="akce"; } ?>
datum) ?>. datum)); echo " ".date("y",$radek__novinky->datum) ?>
$posun) { $pulka=5; ?>
=0) { ?> " class="prev">Předchozí =$rozsah_od && $i<$rozsah_do) || ($i+1)%10==0 || $i==0) { ?> class="aktual"> =25) { break; } } } if(($min+$posun)<$pocet) { ?>