$id = $_POST[id]?$_POST[id]:$_GET[id];
$pid = $_POST[pid]?$_POST[pid]:$_GET[pid];
$skid = $_POST[skid]?$_POST[skid]:$_GET[skid];
$lang= substr($_POST[lang]?$_POST[lang]:$_GET[lang],0,2);
$page= $_POST[page]?$_POST[page]:$_GET[page];
$blog_per = 3;
$novinky_per = 3;
$komentare_per = 5;
session_start();
//
if($pid=='tojsemjatvujeda')
$_SESSION[guest]='jein';
if(!$pid) $pid='home';
if(!$lang) $lang = 'cz';
//
require('_db_.php');
require('functions.php');
switch ($pid) {
// ZVETSENY NAHLED
case 'nahled':
include('xtemplate.class.php');
include_once('popisky.php');
$xtpl = new XTemplate('xtpl/nahled.html');
$pole = @getimagesize($_GET[cesta]);
$xtpl->assign('X',$pole[0]);
$xtpl->assign('Y',$pole[1]);
$xtpl->assign('CESTA',$_GET[cesta]);
$xtpl->parse('main');
$xtpl->out('main');
break;
// DOWNLOAD
case 'download':
header('Content-type: image/jpeg');
$id=fopen($_GET['file'],r);
fpassthru($id);
exit;
break;
// HOME
case 'home':
page_in("");
$balkon = 0;
// NOVINKY
$dotaz=sprintf("
SELECT *,DATE_FORMAT(datum,'%s') AS dat
FROM %s_novinky
WHERE text!='' AND lang='%s' AND stav='on'
ORDER BY datum DESC LIMIT 1", '%d | %m | %Y',$SITE_ID,$lang);
$vysledek = @mysql_query($dotaz);
$pocet = @mysql_num_rows($vysledek);
if($pocet) {
$radek = @mysql_fetch_array($vysledek);
$limit = 460;
$text = strip_tags($radek[text]);
$titulek = strip_tags($radek[titulek]);
$text = ((strlen($text)+strlen($titulek)>$limit)?substr($text,0,$limit-3-strlen($titulek)):$text);
$text = "$titulek $text";
$xtpl->assign('NOVINKY_TEXT',$text);
$xtpl->parse("main.home.novinky");
$balkon++;
}
// PREDSTAVENI
$text = nl2br(bold(detail("predstaveni_infotext")));
if($text) {
$limit = 380;
$text = strip_tags($text);
$text = ((strlen($text)>$limit)?substr($text,0,$limit-3):$text);
$xtpl->assign('PREDSTAVENI_TEXT',$text);
$xtpl->parse("main.home.predstaveni");
$balkon++;
}
// FOTKY
$dotaz=sprintf("SELECT ico,img,f.skid
FROM %s_foto f, %s_foto_sk s
WHERE f.skid=s.id AND f.ico!='' AND f.img!='' AND s.stav_%s='on' AND f.stav_%s='on'
ORDER BY s.poradi
",$SITE_ID,$SITE_ID,$lang,$lang);
$vysledek=@mysql_query($dotaz);
$pocet=@mysql_num_rows($vysledek);
if($pocet) {
srand((double)microtime()*1000000);
$cislo = array();
$kolik = 3;
for($i=1;$i<=$kolik;$i++):
do {
$rnd = rand(1,$pocet);
}
while(in_array($rnd,$cislo));
$cislo[$i]=$rnd;
endfor;
sort($cislo);
$i=0;
while($radek=@mysql_fetch_array($vysledek)):
$i++;
if(!in_array($i,$cislo))
continue;
$ico="img/foto/ico/".$radek[ico];
$img="img/foto/".$radek[img];
if(!$radek[ico] || !file_exists($ico) || !$radek[img] || !file_exists($img)) {
$pocet--;
continue;
}
$xtpl->assign('SKID',$radek[skid]);
$xtpl->assign("ICO",$ico);
$xtpl->parse("main.home.foto.jeden");
endwhile;
$xtpl->parse("main.home.foto");
$balkon++;
}
if($balkon)
$xtpl->parse("main.home");
page_out();
break;
// NOVINKY
case 'novinky':
page_in("xtpl/novinky.html");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
// NOVINKY
$dotaz=sprintf("
SELECT *,DATE_FORMAT(datum,'%s') AS dat
FROM %s_novinky
WHERE text!='' AND lang='%s' AND stav='on'
ORDER BY datum DESC", '%d.%m.%Y',$SITE_ID,$lang);
$vysledek=@mysql_query($dotaz);
$pocet=@mysql_num_rows($vysledek);
$per=$novinky_per;
if(!$page)
$page=0;
$k=$i=0;
$zac=$per*$page+1;
$kon=$per*($page+1);
while($radek=@mysql_fetch_array($vysledek)):
$k++;
if(!(($k-1)%$per)) {
$xtpl->assign('CISLO',($k-1)/$per+1);
$xtpl->assign('PAGE',($k-1)/$per);
if($k-1) $xtpl->assign("NAV_ODDEL","|");
else $xtpl->assign("NAV_ODDEL","");
$xtpl->parse('main.obsah.aktunavigace.jeden');
}
if($k<$zac || $k>$kon)
continue;
$xtpl->assign('DATUM',$radek[dat]);
$xtpl->assign('TEXT',nl2br(bold($radek[text])));
$xtpl->assign('TITULEK',$radek[titulek]);
$xtpl->parse('main.obsah.jeden');
$i++;
endwhile;
if(!$pocet)
$xtpl->assign("EMPTY_NEWS",$popiska[$lang][soon]);
if($page) {
$xtpl->assign("PAGE",$page-1);
$xtpl->parse('main.obsah.novejsi');
}
if($kon<$pocet) {
$xtpl->assign("PAGE",$page+1);
$xtpl->parse('main.obsah.starsi');
}
$xtpl->parse('main.obsah');
page_out();
break;
// O PROJEKTU - O PROJEKTU
case 'oprojektu':
page_in("xtpl/text.html");
$xtpl->assign("MENU_PROJEKTU_STAV","o");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$text = detail("oprojektu_infotext");
$text = (($text == "")?$popiska[$lang][soon]:$text);
$text = nl2br(bold($text));
$xtpl->assign("TEXT",$text);
$xtpl->parse('main.obsah');
page_out();
break;
// O PROJEKTU - OBSAZENI
case 'obsazeni':
page_in("xtpl/obsazeni.html");
$xtpl->assign("MENU_PROJEKTU_STAV","o");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$tbl_sk=$SITE_ID."_obsazeni_sk";
$tbl_data=$SITE_ID."_obsazeni";
$dotaz=sprintf("SELECT
m.*,s.*,m.nazev_%s as mnazev,s.nazev_%s as snazev,s.id AS sid
FROM
%s m,%s s
WHERE
s.id=m.skid AND s.stav_%s='on' AND m.stav_%s='on'
ORDER BY
s.poradi,m.poradi",
$lang,$lang,$tbl_data,$tbl_sk,$lang,$lang);
$vysledek=@mysql_query($dotaz);
$pred='';
$i=0;
function balik1() {
global $xtpl,$pred,$i;
$xtpl->assign('SNAZEV',$pred[snazev]);
$xtpl->assign('ID',$pred[skid]);
$xtpl->parse('main.obsah.obsazeni');
$i=0;
}
while($radek=@mysql_fetch_array($vysledek)):
$ico='img/obsazeni/'.$radek[ico];
if($pred[skid]!=$radek[skid] && $pred)
balik1();
$xtpl->assign('MNAZEV',$radek[mnazev]);
$xtpl->assign('POZNAMKA',$radek["poznamka_$lang"]);
$xtpl->assign('INFO',nl2br(bold($radek["info_$lang"])));
$xtpl->assign('ICO',$ico);
if(file_exists($ico) && $radek[ico])
$xtpl->parse("main.obsah.obsazeni.jeden.ico");
if($radek["poznamka_$lang"])
$xtpl->parse('main.obsah.obsazeni.jeden.poznamka');
$xtpl->parse('main.obsah.obsazeni.jeden');
$pred=$radek;
$i++;
endwhile;
if(@mysql_num_rows($vysledek))
balik1();
else
$xtpl->assign("EMPTY",$popiska[$lang][soon]);
$xtpl->parse('main.obsah');
page_out();
break;
// O PROJEKTU - AUTORI
case 'autori':
page_in("xtpl/autori.html");
$xtpl->assign("MENU_PROJEKTU_STAV","o");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$dotaz=sprintf("SELECT
*
FROM
%s_autori
WHERE
stav_%s='on'
ORDER BY
poradi",
$SITE_ID,$lang);
$vysledek=@mysql_query($dotaz);
while($radek=@mysql_fetch_array($vysledek)):
$ico='img/autori/'.$radek[ico];
$xtpl->assign('NAZEV',$radek["nazev_$lang"]);
$xtpl->assign('POZNAMKA',$radek["poznamka_$lang"]);
$xtpl->assign('INFO',nl2br(bold($radek["info_$lang"])));
$xtpl->assign('ICO',$ico);
if(file_exists($ico) && $radek[ico])
$xtpl->parse("main.obsah.jeden.ico");
if($radek["poznamka_$lang"])
$xtpl->parse('main.obsah.jeden.poznamka');
$xtpl->parse('main.obsah.jeden');
endwhile;
if(!@mysql_num_rows($vysledek))
$xtpl->assign("EMPTY",$popiska[$lang][soon]);
$xtpl->parse('main.obsah');
page_out();
break;
// O PROJEKTU - VYPRAVA - SCENA
case 'scena':
if($id)
{
require("xtemplate.class.php");
$xtpl = new XTemplate('xtpl/nahled.html');
popisky();
$xtpl->assign('PID',$pid);
$xtpl->assign('SKID',$skid);
$xtpl->assign('JAZYK',$lang);
$dotaz=sprintf("SELECT * FROM %s_vyprava WHERE skid=%d AND stav_%s='on' ORDER BY poradi",$SITE_ID,$skid,$lang);
$vysledek=@mysql_query($dotaz);
$pocet=@mysql_num_rows($vysledek);
$i=1;
while($radek=@mysql_fetch_array($vysledek)):
$ico="img/vyprava/ico/".$radek[ico];
$img="img/vyprava/".$radek[img];
if(!$radek[ico] || !file_exists($ico) || !$radek[img] || !file_exists($img)) {
$pocet--;
continue;
}
$xtpl->assign('ID',$i);
if($id==$i) {
$plus=0;
if($radek['poznamka_'.$lang])
$plus=14;
$info=@getimagesize($img);
$xtpl->assign('X',$info[0]);
$xtpl->assign('Y',$info[1]+30);
$xtpl->assign('CESTA',$img);
$xtpl->parse('main.img');
$xtpl->assign('PREV_ID',$i-1);
$xtpl->assign('NEXT_ID',$i+1);
$xtpl->assign('POZNAMKA',$radek['poznamka_'.$lang]);
$xtpl->assign('PG_TITLE',($radek['poznamka_'.$lang]?" | ".$radek['poznamka_'.$lang]:''));
}
$i++;
endwhile;
if($id!=1)
$xtpl->parse('main.dir.prev');
if($id!=$pocet)
$xtpl->parse('main.dir.next');
$xtpl->assign('POZICE',$id."/".$pocet);
$xtpl->parse("main.dir");
$xtpl->parse('main');
$xtpl->out('main');
}
else if ($skid)
{
page_in("xtpl/foto.html");
$xtpl->assign("MENU_PROJEKTU_STAV","o");
$xtpl->assign("MENU_VYPRAVA_STAV","o");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$xtpl->assign('PID',$pid);
$xtpl->assign('JAZYK',$lang);
$dotaz=sprintf("SELECT *
FROM %s_vyprava_sk
WHERE id=%d
LIMIT 1
",$SITE_ID,$skid);
$vysledek=@mysql_query($dotaz);
$radek=@mysql_fetch_array($vysledek);
$xtpl->assign("NAZEV",$radek["nazev_$lang"]);
$xtpl->assign('TIT_NAVIC',$menu[$lang][$pid]." | ".$radek["nazev_$lang"]);
$xtpl->assign("POZNAMKA",$radek["poznamka_$lang"]);
$xtpl->assign("INFO",$radek["info_$lang"]);
//if($radek["poznamka_$lang"]) $xtpl->parse("main.obsah.sada.poznamka");
if($radek["info_$lang"]) $xtpl->parse("main.obsah.sada.info");
$dotaz=sprintf("SELECT *
FROM %s_vyprava
WHERE skid=%d AND stav_%s='on'
ORDER BY poradi
",$SITE_ID,$skid,$lang);
$vysledek=@mysql_query($dotaz);
$i=1;
while($radek=@mysql_fetch_array($vysledek)):
$ico="img/vyprava/ico/".$radek[ico];
$img="img/vyprava/".$radek[img];
if(!$radek[ico] || !$radek[img] || !file_exists($ico) || !file_exists($img))
continue;
$xtpl->assign("ICO",$ico);
$xtpl->assign("IMG",$img);
$xtpl->assign("ID",$i);
$xtpl->assign('SKID',$skid);
$xtpl->parse("main.obsah.sada.jeden");
$i++;
endwhile;
if(@mysql_num_rows($vysledek))
$xtpl->parse("main.obsah.sada");
else
$xtpl->assign("EMPTY",$popiska[$lang][soon]);
$xtpl->parse("main.obsah");
page_out();
}
else
{
page_in("xtpl/foto.html");
$xtpl->assign("MENU_PROJEKTU_STAV","o");
$xtpl->assign("MENU_VYPRAVA_STAV","o");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$dotaz=sprintf("SELECT s.*, COUNT(*) AS pocet
FROM %s_vyprava f, %s_vyprava_sk s
WHERE f.skid=s.id AND f.ico!='' AND f.img!='' AND s.stav_%s='on' AND f.stav_%s='on'
GROUP BY s.id
ORDER BY s.poradi
",$SITE_ID,$SITE_ID,$lang,$lang);
$vysledek=@mysql_query($dotaz);
while($radek=@mysql_fetch_array($vysledek)):
if(!$skid)
$skid=$radek[id];
$xtpl->assign("NAZEV",$radek["nazev_$lang"]);
$xtpl->assign("SKID",$radek[id]);
$xtpl->assign("AUTOR",$radek[autor]);
$xtpl->assign("POCET",$radek[pocet]);
$xtpl->assign("POZNAMKA",$radek["poznamka_$lang"]);
if($radek[autor]) $xtpl->parse("main.obsah.sady.jeden.autor");
if($radek["poznamka_$lang"]) $xtpl->parse("main.obsah.sady.jeden.poznamka");
$xtpl->parse("main.obsah.sady.jeden");
endwhile;
if(@mysql_num_rows($vysledek))
$xtpl->parse("main.obsah.sady");
else
$xtpl->assign("EMPTY",$popiska[$lang][soon]);
$xtpl->parse("main.obsah");
page_out();
}
break;
// O PROJEKTU - VYPRAVA - KOSTYMY
case 'kostymy':
page_in("xtpl/text.html");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$xtpl->assign("MENU_PROJEKTU_STAV","o");
$xtpl->assign("MENU_VYPRAVA_STAV","o");
$text = $popiska[$lang][soon];
$xtpl->assign("TEXT",$text);
$xtpl->parse('main.obsah');
page_out();
break;
// O PROJEKTU - NAPSALI O NAS
case 'press':
page_in("xtpl/press.html");
$xtpl->assign("MENU_PROJEKTU_STAV","o");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$dotaz = sprintf("SELECT * FROM %s_press WHERE stav_%s='on' AND text_%s!='' AND nazev_%s!='' ORDER BY poradi",$SITE_ID,$lang,$lang,$lang);
$vysledek = @mysql_query($dotaz);
if(@mysql_num_rows($vysledek)) {
while($radek = @mysql_fetch_array($vysledek)):
$xtpl->assign("NAZEV",$radek["nazev_$lang"]);
$xtpl->assign("POZNAMKA",$radek["poznamka_$lang"]);
$xtpl->assign("TEXT",nl2br(bold($radek["text_$lang"])));
$xtpl->assign("ID",$radek[id]);
if($radek["poznamka_$lang"])
$xtpl->parse("main.obsah.jeden.poznamka");
$xtpl->parse("main.obsah.jeden");
endwhile;
}
else
$xtpl->assign("EMPTY",$popiska[$lang][soon]);
$xtpl->parse('main.obsah');
page_out();
break;
// PREDSTAVENI
case 'predstaveni':
page_in("xtpl/predstaveni.html");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$text = nl2br(bold(detail("predstaveni_infotext")));
$xtpl->assign("INFOTEXT",$text);
$dotaz1 = sprintf("
SELECT *,DATE_FORMAT(datum,'%s') AS dat
FROM %s_predstaveni
WHERE datum>=NOW()
ORDER BY datum ASC", '%d.%m.%Y',$SITE_ID);
$dotaz2 = sprintf("
SELECT *,DATE_FORMAT(datum,'%s') AS dat
FROM %s_predstaveni
WHERE datumassign('DATUM',$radek[dat]);
$xtpl->assign('TITULEK',$radek["titulek_$lang"]);
$xtpl->assign('POZNAMKA',$radek["poznamka_$lang"]);
$xtpl->assign('INFO',nl2br(bold($radek["info_$lang"])));
$xtpl->assign("IMG",$img="img/predstaveni/".$radek[img]);
if($radek["info_$lang"])
$xtpl->parse("main.obsah.predstaveni.jeden.info");
if($radek[img] && file_exists($img))
$xtpl->parse("main.obsah.predstaveni.jeden.img");
$xtpl->parse("main.obsah.predstaveni.jeden");
$xtpl->parse('main.obsah.predstaveni');
endwhile;
$xtpl->parse("main.obsah.predstaveni.oddel");
$xtpl->parse("main.obsah.predstaveni");
$vysledek2 = @mysql_query($dotaz2);
while($radek = @mysql_fetch_array($vysledek2)):
$xtpl->assign('DATUM',$radek[dat]);
$xtpl->assign('TITULEK',$radek["titulek_$lang"]);
$xtpl->assign('POZNAMKA',$radek["poznamka_$lang"]);
$xtpl->parse("main.obsah.predstaveni.jeden");
$xtpl->parse('main.obsah.predstaveni');
endwhile;
if(!@mysql_num_rows($vysledek1))
$xtpl->assign("EMPTY",$popiska[$lang][soon]);
$xtpl->parse('main.obsah');
page_out();
break;
// DOWNLOAD - FOTO
case 'foto':
if($id)
{
require("xtemplate.class.php");
$xtpl = new XTemplate('xtpl/nahled.html');
popisky();
$xtpl->assign('PID',$pid);
$xtpl->assign('SKID',$skid);
$xtpl->assign('JAZYK',$lang);
$dotaz=sprintf("SELECT * FROM %s_foto WHERE skid=%d AND stav_%s='on' ORDER BY poradi",$SITE_ID,$skid,$lang);
$vysledek=@mysql_query($dotaz);
$pocet=@mysql_num_rows($vysledek);
$i=1;
while($radek=@mysql_fetch_array($vysledek)):
$ico="img/foto/ico/".$radek[ico];
$img="img/foto/".$radek[img];
if(!$radek[ico] || !file_exists($ico) || !$radek[img] || !file_exists($img)) {
$pocet--;
continue;
}
$xtpl->assign('ID',$i);
if($id==$i) {
$plus=0;
if($radek['poznamka_'.$lang])
$plus=14;
$info=@getimagesize($img);
$xtpl->assign('X',$info[0]);
$xtpl->assign('Y',$info[1]+30);
$xtpl->assign('CESTA',$img);
$xtpl->parse('main.img');
$xtpl->assign('PREV_ID',$i-1);
$xtpl->assign('NEXT_ID',$i+1);
$xtpl->assign('POZNAMKA',$radek['poznamka_'.$lang]);
$xtpl->assign('PG_TITLE',($radek['poznamka_'.$lang]?" | ".$radek['poznamka_'.$lang]:''));
}
$i++;
endwhile;
if($id!=1)
$xtpl->parse('main.dir.prev');
if($id!=$pocet)
$xtpl->parse('main.dir.next');
$xtpl->assign('POZICE',$id."/".$pocet);
$xtpl->parse("main.dir");
$xtpl->parse('main');
$xtpl->out('main');
}
else if ($skid)
{
page_in("xtpl/foto.html");
$xtpl->assign("MENU_DOWN_STAV","o");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$xtpl->assign('PID',$pid);
$xtpl->assign('JAZYK',$lang);
$dotaz=sprintf("SELECT *
FROM %s_foto_sk
WHERE id=%d
LIMIT 1
",$SITE_ID,$skid);
$vysledek=@mysql_query($dotaz);
$radek=@mysql_fetch_array($vysledek);
$xtpl->assign("NAZEV",$radek["nazev_$lang"]);
$xtpl->assign('TIT_NAVIC',$menu[$lang][$pid]." | ".$radek["nazev_$lang"]);
$xtpl->assign("AUTOR",$radek[autor]);
$xtpl->assign("POZNAMKA",$radek["poznamka_$lang"]);
$xtpl->assign("INFO",$radek["info_$lang"]);
if($radek[autor]) $xtpl->parse("main.obsah.sada.autor");
//if($radek["poznamka_$lang"]) $xtpl->parse("main.obsah.sada.poznamka");
if($radek["info_$lang"]) $xtpl->parse("main.obsah.sada.info");
$dotaz=sprintf("SELECT *
FROM %s_foto
WHERE skid=%d AND stav_%s='on'
ORDER BY poradi
",$SITE_ID,$skid,$lang);
$vysledek=@mysql_query($dotaz);
$i=1;
while($radek=@mysql_fetch_array($vysledek)):
$ico="img/foto/ico/".$radek[ico];
$img="img/foto/".$radek[img];
if(!$radek[ico] || !$radek[img] || !file_exists($ico) || !file_exists($img))
continue;
$xtpl->assign("ICO",$ico);
$xtpl->assign("IMG",$img);
$xtpl->assign("ID",$i);
$xtpl->assign('SKID',$skid);
$xtpl->parse("main.obsah.sada.jeden");
$i++;
endwhile;
if(@mysql_num_rows($vysledek))
$xtpl->parse("main.obsah.sada");
else
$xtpl->assign("EMPTY",$popiska[$lang][soon]);
$xtpl->parse("main.obsah");
page_out();
}
else
{
page_in("xtpl/foto.html");
$xtpl->assign("MENU_DOWN_STAV","o");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$dotaz=sprintf("SELECT s.*, COUNT(*) AS pocet
FROM %s_foto f, %s_foto_sk s
WHERE f.skid=s.id AND f.ico!='' AND f.img!='' AND s.stav_%s='on' AND f.stav_%s='on'
GROUP BY s.id
ORDER BY s.poradi
",$SITE_ID,$SITE_ID,$lang,$lang);
$vysledek=@mysql_query($dotaz);
while($radek=@mysql_fetch_array($vysledek)):
if(!$skid)
$skid=$radek[id];
$xtpl->assign("NAZEV",$radek["nazev_$lang"]);
$xtpl->assign("SKID",$radek[id]);
$xtpl->assign("AUTOR",$radek[autor]);
$xtpl->assign("POCET",$radek[pocet]);
$xtpl->assign("POZNAMKA",$radek["poznamka_$lang"]);
if($radek[autor]) $xtpl->parse("main.obsah.sady.jeden.autor");
if($radek["poznamka_$lang"]) $xtpl->parse("main.obsah.sady.jeden.poznamka");
$xtpl->parse("main.obsah.sady.jeden");
endwhile;
if(@mysql_num_rows($vysledek))
$xtpl->parse("main.obsah.sady");
else
$xtpl->assign("EMPTY",$popiska[$lang][soon]);
$xtpl->parse("main.obsah");
page_out();
}
break;
// DOWNLOAD - AUDIO,VIDEO
case 'video':
case 'audio':
page_in("xtpl/audio.html");
$xtpl->assign("MENU_DOWN_STAV","o");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$tbl_sk=$SITE_ID."_".$pid."_sk";
$tbl_data=$SITE_ID."_".$pid;
$dotaz=sprintf("SELECT
m.*,s.*,m.nazev_%s as mtitle,s.nazev_%s as stitle,m.id as mid, m.info_%s as minfo, s.poznamka_%s as spoznamka
FROM
%s m,%s s
WHERE
s.id=m.skid AND s.stav_%s='on' AND m.stav_%s='on'
ORDER BY
s.poradi,m.poradi",
$lang,$lang,$lang,$lang,$tbl_data,$tbl_sk,$lang,$lang);
$vysledek=@mysql_query($dotaz);
$pred='';
$i=1;
function balik2() {
global $xtpl,$pred,$lang,$i,$pid;
$xtpl->assign('ICO',$ico='img/'.$pid.'/'.$pred[ico]);
$xtpl->assign('SNAZEV',$pred[stitle]);
$xtpl->assign('SPOZNAMKA',$pred[spoznamka]);
if($pred[ico] && file_exists($ico))
$xtpl->parse('main.obsah.medio.img');
if($pred[spoznamka])
$xtpl->parse('main.obsah.medio.poznamka');
$xtpl->parse('main.obsah.medio');
$i=1;
}
while($radek=@mysql_fetch_array($vysledek)):
if($pred[skid]!=$radek[skid] && $pred)
balik2();
$cesta='down/'.$pid.'/'.$radek[down];
$xtpl->assign('MNAZEV',$radek[mtitle]);
$xtpl->assign('INFO',nl2br($radek[minfo]));
$xtpl->assign('CESTA',$cesta);
$xtpl->assign('VELIKOST',size($cesta));
if(file_exists($cesta) && $radek[down])
$xtpl->parse('main.obsah.medio.jeden.download');
else
$xtpl->parse('main.obsah.medio.jeden.nazev');
if($radek[minfo])
$xtpl->parse("main.obsah.medio.jeden.info");
$xtpl->parse('main.obsah.medio.jeden');
$pred=$radek;
$i++;
endwhile;
if(@mysql_num_rows($vysledek))
balik2();
else
$xtpl->assign("EMPTY",$popiska[$lang][soon]);
$xtpl->parse('main.obsah');
page_out();
break;
// DOWNLOAD - TEXTY
case 'texty':
page_in("xtpl/texty.html");
$xtpl->assign("MENU_DOWN_STAV","o");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$dotaz = sprintf("SELECT * FROM %s_texty WHERE stav_%s='on' AND text_%s!='' AND nazev_%s!='' ORDER BY poradi",$SITE_ID,$lang,$lang,$lang);
$vysledek = @mysql_query($dotaz);
if(@mysql_num_rows($vysledek)) {
while($radek = @mysql_fetch_array($vysledek)):
$xtpl->assign("NAZEV",$radek["nazev_$lang"]);
$xtpl->assign("POZNAMKA",$radek["poznamka_$lang"]);
$xtpl->assign("TEXT",nl2br(bold($radek["text_$lang"])));
$xtpl->assign("ID",$radek[id]);
if($radek["poznamka_$lang"])
$xtpl->parse("main.obsah.jeden.poznamka");
$xtpl->parse("main.obsah.jeden");
endwhile;
}
else
$xtpl->assign("EMPTY",$popiska[$lang][soon]);
$xtpl->parse('main.obsah');
page_out();
break;
// DOWNLOAD - MEDIA
case 'media':
page_in("xtpl/pro-media.html");
$xtpl->assign("MENU_DOWN_STAV","o");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$tbl_data=$SITE_ID."_media";
$dotaz=sprintf("SELECT * FROM %s
WHERE stav_%s='on'
ORDER BY poradi",
$tbl_data,$lang);
$vysledek=@mysql_query($dotaz);
while($radek=@mysql_fetch_array($vysledek)):
$cesta='down/media/'.$radek[down];
if(!file_exists($cesta) || !$radek["down"])
continue;
$xtpl->assign('NAZEV',$radek["nazev_$lang"]);
$xtpl->assign('CESTA',$cesta);
$xtpl->assign('VELIKOST',size($cesta));
$xtpl->parse('main.obsah.jeden');
endwhile;
$xtpl->parse('main.obsah');
page_out();
break;
/*
case 'media':
page_in("xtpl/text.html");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$xtpl->assign("MENU_DOWN_STAV","o");
$text = $popiska[$lang][soon];
$xtpl->assign("TEXT",$text);
$xtpl->parse('main.obsah');
page_out();
break;*/
// OBCHOD
// case 'obchod':
// page_in("xtpl/text.html");
// $text = $popiska[$lang][soon];
// $xtpl->assign("TEXT",$text);
// $xtpl->parse('main.obsah');
// page_out();
// break;
// OBCHOD
case 'obchod':
//
// PRIDANI DO KOSIKU
//
if($_POST[id]) {
$dotaz=sprintf("SELECT * FROM %s_obchod WHERE stav_%s='on' AND id=%d LIMIT 1",$SITE_ID,$lang,$id);
$vysledek=@mysql_query($dotaz);
if(@mysql_num_rows($vysledek)) {
$radek=@mysql_fetch_array($vysledek);
if($_POST[varianta]) {
$pole = explode(",",$radek[varianty]);
if(in_array($_POST[varianta],$pole))
$_SESSION[_AG_][kosik][$id][$_POST[varianta]]++;
}
else if(!$radek[varianty])
$_SESSION[_AG_][kosik][$id]++;
}
header("location: ".$_SERVER[HTTP_REFERER]);
exit;
}
//
// OBCHOD
//
else {
page_in("xtpl/obchod.html");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
//
// REGALY
//
$dotaz=sprintf("SELECT * FROM %s_obchod_sk WHERE stav_%s='on' ORDER BY poradi",$SITE_ID,$lang);
$vysledek=@mysql_query($dotaz);
$i=1;
while($radek=@mysql_fetch_array($vysledek)):
if(!$skid)
$skid = $radek[id];
$xtpl->assign('OBCHOD_SK_NAZEV',$radek["nazev_$lang"]);
$xtpl->assign('SKID',$radek[id]);
if($skid == $radek[id]) {
$xtpl->assign("OBCHOD_SK_CLASS","active");
$xtpl->assign("TIT_NAVIC",$radek["nazev_$lang"]." | ".$menu[$lang][$pid]);
}
else
$xtpl->assign("OBCHOD_SK_CLASS","");
$xtpl->parse('main.obsah.obchod_sk');
$i++;
endwhile;
if($kosik_items = kosik()) {
$xtpl->assign("KOSIK_ITEMS",$kosik_items);
$xtpl->parse("main.obsah.kosik_items");
}
if($skid=="podminky") {
$xtpl->assign("TIT_NAVIC",$menu[$lang][$pid].", ".$popiska[$lang][obchodni_podminky]);
$xtpl->assign("CLASS_PODMINKY","active");
$text = nl2br(bold(detail("obchodni_podminky")));
$xtpl->assign("TEXT",$text);
}
//
// POLICKY
//
else if($skid) {
$dotaz=sprintf("SELECT * FROM %s_obchod WHERE stav_%s='on' AND nazev_%s!='' AND cena_%s!='' AND skid=%d ORDER BY poradi",$SITE_ID,$lang,$lang,$lang,$skid);
$vysledek=@mysql_query($dotaz);
$i=1;
while($radek=@mysql_fetch_array($vysledek)):
$xtpl->assign("ICO", $ico = "img/obchod/ico/".$radek[ico]);
$xtpl->assign("IMG", $img = "img/obchod/".$radek[img]);
$xtpl->assign('NAZEV',$radek["nazev_$lang"]);
$xtpl->assign('INFO',nl2br(bold($radek["info_$lang"])));
$xtpl->assign('CENA',$radek["cena_$lang"]);
$xtpl->assign('ID',$radek[id]);
$pole = @getimagesize($ico);
$xtpl->assign("X",$pole[0]);
$xtpl->assign("Y",$pole[1]);
if($radek[varianty]) {
$pole = explode("," , $radek[varianty]);
$v = 0;
foreach($pole as $var) {
if(!trim($var))
continue;
$xtpl->assign("VAR",trim($var));
$xtpl->parse("main.obsah.obchod.vars.var");
$v++;
}
if($v)
$xtpl->parse("main.obsah.obchod.vars");
}
if($radek[ico] && file_exists($ico) && $radek[img] && file_exists($img))
$xtpl->parse('main.obsah.obchod.img');
else if($radek[ico] && file_exists($ico))
$xtpl->parse('main.obsah.obchod.ico');
if($radek["info_$lang"])
$xtpl->parse('main.obsah.obchod.info');
$xtpl->parse('main.obsah.obchod');
$i++;
endwhile;
if(!@mysql_num_rows($vysledek))
$xtpl->assign("EMPTY",$popiska[$lang][policka_empty]);
$xtpl->assign("CLASS_INFO_".strtoupper($pid),"active");
}
else
$xtpl->assign("EMPTY",$popiska[$lang][soon]);
$xtpl->parse("main.obsah");
page_out();
}
break;
// OBCHOD - OBJEDNAVKA
case 'objednavka':
//
// PRIDANI DO KOSIKU
//
if($_POST[id]) {
$dotaz=sprintf("SELECT * FROM %s_obchod WHERE stav_%s='on' AND id=%d LIMIT 1",$SITE_ID,$lang,$id);
$vysledek=@mysql_query($dotaz);
if(@mysql_num_rows($vysledek)) {
$radek=@mysql_fetch_array($vysledek);
if($_POST[varianta]) {
$pole = explode(",",$radek[varianty]);
if(in_array($_POST[varianta],$pole))
$_SESSION[_AG_][kosik][$id][$_POST[varianta]]++;
}
else if(!$radek[varianty])
$_SESSION[_AG_][kosik][$id]++;
}
header("location: ".$_SERVER[HTTP_REFERER]);
}
//
// ZPRACOVANI OBJEDNAVKY
//
else if($_POST && kosik()) {
$_POST=pole_conv($_POST);
$chyby=array();
$mail_exp="^[0-9a-z~!#$%&_-]([.]?[0-9a-zA-Z~!#$%&_-])*@[0-9a-zA-Z~!#$%&_-]([.]?[0-9a-zA-Z~!#$%&_-])*$";
$jmeno = trim($_POST[jmeno]);
$mail = trim($_POST[mail]);
$adresa = trim($_POST[adresa]);
$poznamka = trim($_POST[poznamka]);
if(!$jmeno)
$chyby[jmeno]=1;
if(!eregi($mail_exp,$mail))
$chyby[mail]=1;
if(!$adresa)
$chyby[adresa]=1;
if(count($chyby) || !$_SESSION[_AG_][realform] || $_POST[submit]) {
$_SESSION[_AG_][chyby]=$chyby;
$_SESSION[_AG_][form_data]=$_POST;
}
// GENEROVANI OBJEDNAVKY
else {
popisky();
$dotaz=sprintf("SELECT * FROM %s_obchod WHERE stav_%s='on' ORDER BY poradi",$SITE_ID,$lang);
$vysledek=@mysql_query($dotaz);
$i=1;
while($radek=@mysql_fetch_array($vysledek)):
$pole[$radek[id]] = $radek;
endwhile;
$num = 0;
$cena = 0;
$zbozi = "";
foreach($_SESSION[_AG_][kosik] as $ind => $item) {
if(is_array($item)) {
foreach($item as $ex => $_item) {
if(is_integer($_item)) {
$zbozi .= $_item." x ".$pole[$ind]["cena_$lang"].$popiska[$lang][mena]." - ".$pole[$ind]["nazev_$lang"]."\n- - - -\n";
$num += $_item;
$cena += $_item*$pole[$ind]["cena_$lang"];
}
}
}
else if(is_integer($item)) {
$zbozi .= $item." x ".$pole[$ind]["cena_$lang"].$popiska[$lang][mena]." - ".$pole[$ind]["nazev_$lang"]."\n- - - -\n";
$num += $item;
$cena += $item*$pole[$ind]["cena_$lang"];
}
}
$objednavka = str_replace("[ZBOZI_DOPLN]",$zbozi,$popiska[$lang][objednavka]);
$objednavka = str_replace("[CENA_DOPLN]",($cena.$popiska[$lang][mena]),$objednavka);
$objednavka = str_replace("[JMENO_DOPLN]",$jmeno,$objednavka);
$objednavka = str_replace("[MAIL_DOPLN]",$mail,$objednavka);
$objednavka = str_replace("[ADRESA_DOPLN]",$adresa,$objednavka);
$objednavka = str_replace("[POZNAMKA_DOPLN]",$poznamka,$objednavka);
$sendto=detail('obchodni_mail');
$mess_head.="Content-Type: text/html; charset=utf-8\n";
$mess_head.="From: $jmeno $prijmeni <$mail>\n";
$mess_predmet="objedn?vka z antigona-rockopera.com ".mktime();
$mess_text=nl2br($objednavka);
@mail('jooka@jooka.net',$mess_predmet,$mess_text,$mess_head);
if(!@mail($sendto,$mess_predmet,$mess_text,$mess_head)) {
$_SESSION[_AG_][mess]='obchod_nosend';
$_SESSION[_AG_][form_data]=$_POST;
}
else {
$_SESSION[_AG_][mess]='obchod_send';
$_SESSION[_AG_][kosik]="";
}
}
$_SESSION[_AG_][realform]="";
header("location: ".$_SERVER[HTTP_REFERER]);
exit;
}
//
// OBCHOD
//
else {
$ppid = $pid; $pid = "obchod";
page_in("xtpl/obchod.html");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$xtpl->assign("TIT_NAVIC",$menu[$lang][$pid]);
$pid = $ppid;
$xtpl->assign("CLASS_SHOP_FINISH","active");
//
// REGALY
//
$dotaz=sprintf("SELECT * FROM %s_obchod_sk WHERE stav_%s='on' ORDER BY poradi",$SITE_ID,$lang);
$vysledek=@mysql_query($dotaz);
$i=1;
while($radek=@mysql_fetch_array($vysledek)):
$xtpl->assign('OBCHOD_SK_NAZEV',$radek["nazev_$lang"]);
$xtpl->assign('SKID',$radek[id]);
$xtpl->parse('main.obsah.obchod_sk');
$i++;
endwhile;
if($kosik_items = kosik()) {
$xtpl->assign("KOSIK_ITEMS",$kosik_items);
$xtpl->parse("main.obsah.kosik_items");
}
if(kosik()) {
$dotaz=sprintf("SELECT * FROM %s_obchod WHERE stav_%s='on' ORDER BY poradi",$SITE_ID,$lang);
$vysledek=@mysql_query($dotaz);
$i=1;
while($radek=@mysql_fetch_array($vysledek)):
$pole[$radek[id]] = $radek;
endwhile;
//
// VYPIS OBJEDNAVKY
//
$num = 0;
$cena = 0;
foreach($_SESSION[_AG_][kosik] as $ind => $item) {
if(is_array($item)) {
foreach($item as $ex => $_item) {
if(is_integer($_item)) {
$xtpl->assign("POCET",$_item);
$xtpl->assign("NAZEV",$pole[$ind]["nazev_$lang"]);
$xtpl->assign("INFO",$pole[$ind]["info_$lang"]);
$xtpl->assign("CENA",($pole[$ind]["cena_$lang"]));
$xtpl->assign("VELIKOST",$ex);
if($pole[$ind]["info_$lang"])
$xtpl->parse("main.obsah.objednavka.jeden.info");
$xtpl->parse("main.obsah.objednavka.jeden");
$num += $_item;
$cena += $_item*$pole[$ind]["cena_$lang"];
}
}
}
else if(is_integer($item)) {
$xtpl->assign("POCET",$item);
$xtpl->assign("NAZEV",$pole[$ind]["nazev_$lang"]);
$xtpl->assign("INFO",$pole[$ind]["info_$lang"]);
$xtpl->assign("CENA",($pole[$ind]["cena_$lang"]));
$xtpl->assign("VELIKOST","");
if($pole[$ind]["info_$lang"])
$xtpl->parse("main.obsah.objednavka.jeden.info");
$xtpl->parse("main.obsah.objednavka.jeden");
$num += $item;
$cena += $item*$pole[$ind]["cena_$lang"];
}
}
$xtpl->assign("CENA_CELKEM",$cena);
if($_SESSION[_AG_][mess])
$xtpl->assign('MESS',$popiska[$lang][$_SESSION[_AG_][mess]]);
else if($_SESSION[_AG_][chyby])
$xtpl->assign('MESS',$popiska[$lang][form_mist]);
if($_SESSION[_AG_][chyby][jmeno])
$xtpl->assign('CLASS_JMENO','warn');
if($_SESSION[_AG_][chyby][mail])
$xtpl->assign('CLASS_MAIL','warn');
if($_SESSION[_AG_][chyby][adresa])
$xtpl->assign('CLASS_ADRESA','warn');
if($_SESSION[_AG_][chyby][poznamka])
$xtpl->assign('CLASS_POZNAMKA','warn');
if(!$_SESSION[_AG_][form_data][mail])
$_SESSION[_AG_][form_data][mail]="@";
$xtpl->assign('FORM_JMENO',$_SESSION[_AG_][form_data][jmeno]);
$xtpl->assign('FORM_MAIL',$_SESSION[_AG_][form_data][mail]);
$xtpl->assign('FORM_ADRESA',$_SESSION[_AG_][form_data][adresa]);
$xtpl->assign('FORM_POZNAMKA',$_SESSION[_AG_][form_data][poznamka]);
$xtpl->parse("main.obsah.objednavka.form");
$xtpl->parse("main.obsah.objednavka");
}
else {
if($_SESSION[_AG_][mess])
$xtpl->assign('EMPTY',$popiska[$lang][$_SESSION[_AG_][mess]]);
else
$xtpl->assign("EMPTY",$popiska[$lang][kosik_empty]);
}
}
$_SESSION[_AG_][chyby] = "";
$_SESSION[_AG_][form_data] = "";
$_SESSION[_AG_][mess] = "";
$_SESSION[_AG_][realform] = 1;
$xtpl->parse("main.obsah");
page_out();
break;
//
// VYSYPAT KOSIK
//
case "vysypatkosik":
$_SESSION[_AG_][kosik] = "";
header("location: ".$_SERVER[HTTP_REFERER]);
break;
// BLOGUJEM
case "blogujem":
// KONTROLA / ULOZENI DO BLOGU
if($_POST)
{
$_POST=pole_conv($_POST);
$chyby=array();
$mail_exp="^[0-9a-z~!#$%&_-]([.]?[0-9a-zA-Z~!#$%&_-])*@[0-9a-zA-Z~!#$%&_-]([.]?[0-9a-zA-Z~!#$%&_-])*$";
$jmeno=trim($_POST[jmeno]);
$mail=trim($_POST[mail]);
$text=trim($_POST[text]);
$mail = ($mail=="@")?"":$mail;
if(!$jmeno)
$chyby[jmeno]=1;
if($mail && !eregi($mail_exp,$mail))
$chyby[mail]=1;
if(!$text)
$chyby[text]=1;
if($_POST[robot]!=9)
$chyby[robot]=1;
if(count($chyby)) {
$_SESSION[_AG_][chyby]=$chyby;
$_SESSION[_AG_][form_data]=$_POST;
$header=$_SERVER[HTTP_REFERER];
}
else {
$dotaz=sprintf("INSERT INTO %s_komentare SET jmeno='%s',mail='%s',folder='b',text='%s',datum=NOW(),skid=%d",
$SITE_ID,
addslashes($jmeno),
addslashes($mail),
addslashes($text),
$skid
);
@mysql_query($dotaz);
}
header("location: ".$_SERVER[HTTP_REFERER]);
exit;
}
// KOMENTARE K TEMATU
else if($skid)
{
page_in("xtpl/blogujem.html");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$xtpl->assign("SKID",$skid);
// VYPSANI TEMATU
$dotaz=sprintf("
SELECT *,DATE_FORMAT(datum,'%s') AS dat
FROM %s_blog
WHERE id=%d
LIMIT 1",
'%d.%m.%Y',$SITE_ID,$skid);
$vysledek=@mysql_query($dotaz);
$radek=@mysql_fetch_array($vysledek);
$xtpl->assign('DATUM',$radek[dat]);
$xtpl->assign('TEXT',nl2br(bold($radek[text])));
$xtpl->assign('TITULEK',$radek[titulek]);
$xtpl->parse('main.obsah.tema');
// VYPIS KOMENTARU
$dotaz=sprintf("SELECT *,DATE_FORMAT(datum,'%s') AS dat FROM %s_komentare WHERE skid=%d ORDER BY datum DESC",'%d.%m.%Y %h:%i',$SITE_ID,$skid);
$vysledek=@mysql_query($dotaz);
$pocet=@mysql_num_rows($vysledek);
$per = $komentare_per;
if(!$page)
$page = 0;
$k=$i=0;
$zac = $per*$page+1;
$kon = $per*($page+1);
if($kon>$pocet)
$kon = $pocet;
while($radek=@mysql_fetch_array($vysledek)):
$k++;
if($k<$zac || $k>$kon)
continue;
if($k!=$kon)
$xtpl->parse("main.obsah.komentare.jeden.oddel");
$xtpl->assign('ID',$radek[id]);
$xtpl->assign('JMENO',$radek[jmeno]);
$xtpl->assign('MAIL',$radek[mail]);
$xtpl->assign('LINK',$radek[link]);
$xtpl->assign('DATUM',$radek[dat]);
if($radek[html])
$xtpl->assign('TEXT',wordwrap(nl2br($radek[text]),50,"\n",1));
else
$xtpl->assign('TEXT',wordwrap(nl2br(htmlspecialchars($radek[text])),50,"\n",1));
if($radek[mail])
$xtpl->parse('main.obsah.komentare.jeden.mail');
if($radek[link])
$xtpl->parse('main.obsah.komentare.jeden.link');
$xtpl->parse('main.obsah.komentare.jeden');
endwhile;
if($page) {
$xtpl->assign("PAGE",$page-1);
$xtpl->parse('main.obsah.komentare.novejsi');
}
if($kon<$pocet) {
$xtpl->assign("PAGE",$page+1);
$xtpl->parse('main.obsah.komentare.starsi');
}
$xtpl->parse('main.obsah.komentare');
// FORMULAR
if($_SESSION[_AG_][chyby])
$xtpl->assign('MESS',$popiska[$lang][form_mist]);
$xtpl->assign("STYLE_STAV1",($_SESSION[_AG_][chyby]?"block":"none"));
$xtpl->assign("STYLE_STAV2",(!$_SESSION[_AG_][chyby]?"block":"none"));
if($_SESSION[_AG_][chyby][jmeno])
$xtpl->assign('CLASS_JMENO','warn');
if($_SESSION[_AG_][chyby][mail])
$xtpl->assign('CLASS_MAIL','warn');
if($_SESSION[_AG_][chyby][link])
$xtpl->assign('CLASS_LINK','warn');
if($_SESSION[_AG_][chyby][text])
$xtpl->assign('CLASS_TEXT','warn');
if(!$_SESSION[form_data][mail])
$_SESSION[form_data][mail]="@";
$xtpl->assign('FORM_JMENO',htmlspecialchars($_SESSION[_AG_][form_data][jmeno]));
$xtpl->assign('FORM_MAIL',htmlspecialchars($_SESSION[_AG_][form_data][mail]));
$xtpl->assign('FORM_TEXT',htmlspecialchars($_SESSION[_AG_][form_data][text]));
$xtpl->assign('FORM_SKID',$id);
$xtpl->parse("main.obsah.form");
$xtpl->parse('main.obsah');
page_out();
$_SESSION[_AG_][chyby] = "";
$_SESSION[_AG_][form_data] = "";
$_SESSION[_AG_][mess] = "";
}
// VYPIS TEMAT
else
{
page_in("xtpl/blogujem.html");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
// TEMATA
$dotaz=sprintf("
SELECT b.*,COUNT(*) AS pocet, k.id AS kid,DATE_FORMAT(b.datum,'%s') AS dat
FROM %s_blog b
LEFT JOIN %s_komentare k
ON
(k.skid=b.id AND k.folder='b')
WHERE b.stav='on' AND b.lang='%s'
GROUP BY b.id
ORDER BY b.datum DESC",
'%d.%m.%Y',$SITE_ID,$SITE_ID,$lang);
$vysledek=@mysql_query($dotaz);
$pocet=@mysql_num_rows($vysledek);
$per=$blog_per;
if(!$page)
$page=0;
$k=$i=0;
$zac=$per*$page+1;
$kon=$per*($page+1);
while($radek=@mysql_fetch_array($vysledek)):
$k++;
if($k<$zac || $k>$kon)
continue;
$xtpl->assign('SKID',$radek[id]);
$xtpl->assign('DATUM',$radek[dat]);
$xtpl->assign("POCET",($radek[kid]?$radek[pocet]:"0"));
$xtpl->assign('TEXT',nl2br(bold($radek[text])));
$xtpl->assign('TITULEK',$radek[titulek]);
$xtpl->parse('main.obsah.temata.jeden');
$i++;
endwhile;
if($page) {
$xtpl->assign("PAGE",$page-1);
$xtpl->parse('main.obsah.temata.novejsi');
}
if($kon<$pocet) {
$xtpl->assign("PAGE",$page+1);
$xtpl->parse('main.obsah.temata.starsi');
}
if(!$pocet)
$xtpl->assign("EMPTY_NEWS",$popiska[$lang][soon]);
else
$xtpl->parse('main.obsah.temata');
$xtpl->parse('main.obsah');
page_out();
}
break;
// PARTNERI
case 'partneri':
page_in("xtpl/partneri.html");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$dotaz = sprintf("SELECT * FROM %s_partneri WHERE stav_%s='on' AND ico!='' AND folder='sekce' ORDER BY poradi",$SITE_ID,"cz");
$vysledek = @mysql_query($dotaz);
$i = 0;
while($radek = @mysql_fetch_array($vysledek)):
$xtpl->assign("ICO",$ico="img/partneri/".$radek[ico]);
if(!$radek[ico] || !file_exists($ico))
continue;
$xtpl->assign("NAZEV",$radek["nazev_".$lang]);
$xtpl->assign("LINK",$radek[link]);
if($radek[link])
$xtpl->parse("main.obsah.jeden.link");
else
$xtpl->parse("main.obsah.jeden.ico");
$xtpl->parse("main.obsah.jeden");
$i++;
endwhile;
if(!$i)
$xtpl->assign("EMPTY",$popiska[$lang][soon]);
$xtpl->parse('main.obsah');
page_out();
break;
// KONTAKT
case 'kontakt':
page_in("xtpl/text.html");
$xtpl->assign("H2_TITLE",$menu[$lang][$pid]);
$text = detail("kontakt_infotext");
$text = (($text == "")?$popiska[$lang][soon]:$text);
$text = nl2br(bold($text));
$xtpl->assign("TEXT",$text);
$xtpl->parse('main.obsah');
page_out();
break;
// KONTAKT - ODKAZY
case 'odkazy':
page_in("xtpl/kontakt.html");
$xtpl->assign("ONLOAD","submenu();");
$xtpl->assign("CLASS_KONTAKT_".strtoupper($pid),"active");
$dotaz=sprintf("SELECT o.nazev AS onazev, s.nazev AS snazev, link
FROM %s_odkazy o,%s_odkazy_sk s
WHERE o.skid=s.id AND s.lang='%s' ORDER BY s.poradi,o.poradi"
,$SITE_ID,$SITE_ID,$lang
);
$vysledek=@mysql_query($dotaz);
$pocet=@mysql_num_rows($vysledek);
$s=0;
$pred="";
while($radek=@mysql_fetch_array($vysledek)):
if($pred && $pred[snazev]!=$radek[snazev]) {
$xtpl->assign("SNAZEV",$pred[snazev]);
$xtpl->parse("main.odkazy_sada");
}
$xtpl->assign('ONAZEV',$radek[onazev]);
$xtpl->assign('LINK','http://'.$radek[link]);
$xtpl->parse('main.odkazy_sada.jeden');
$pred=$radek;
endwhile;
if($pred) {
$xtpl->assign("SNAZEV",$pred[snazev]);
$xtpl->parse("main.odkazy_sada");
}
$xtpl->parse('main.obsah');
page_out();
break;
}
?>