<?
$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 = "<strong>$titulek</strong> $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 datum<NOW()
          ORDER BY datum DESC", '%d.%m.%Y',$SITE_ID);

      $vysledek1 = @mysql_query($dotaz1);
      while($radek = @mysql_fetch_array($vysledek1)):
        $xtpl->assign('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;
  }
?>