<?
require('_db_.php');
$spojeni=@mysql_pconnect($host,$name,$pass);
@mysql_select_db($database,$spojeni);

function page_in() {
    global $xtpl;
    require_once ('xtemplate.class.php');
    $xtpl = new XTemplate('xtpl/kingsize.xtpl');
    if(!isset($_GET[pg]))
      $xtpl->parse('main.objednavka');
    }
function page_out($nps) {
    global $xtpl;
    $xtpl->assign('NPS',$nps);
    $xtpl->parse('main');
    $xtpl->out('main');
    }
function bold($text,$on=1) {
    $text=str_replace('[',($on?'<b>':''),$text);
    $text=str_replace(']',($on?'</b>':''),$text);
    return $text;
    }
function italic($text,$on=1) {
    $text=str_replace('{',($on?'<i>':''),$text);
    $text=str_replace('}',($on?'</i>':''),$text);
    return $text;
    }
function detail($detail) {
    $dotaz="select text from detaily where detail='".$detail."';";
    $vysledek=mysql_query($dotaz);
    $radek=mysql_fetch_array($vysledek);
    return $radek['text'];
    }
function size($cesta) {
    $num=filesize($cesta);
    if($num<1000)
      $ret=$num." B";
    elseif($num>=1000000)
      $ret=round($num/1000000,2)." MB";
    else
      $ret=floor($num/1000)." kB";
    return $ret;
    }
$pg=$_GET[pg].$_POST[pg];
if(!$pg)
  $pg='novinky';

switch ($pg) {
//// NOVINKY
    case "novinky":
      page_in();
      $xtpl->assign_file('OBSAH','xtpl/novinky.xtpl');
      $dotaz="select * from novinky order by datum desc limit 10";
      $vysledek=@mysql_query($dotaz,$spojeni);
      while($radek=mysql_fetch_array($vysledek)):
        $xtpl->assign('TEXT',nl2br($radek[text]));
        $xtpl->assign('AUTOR',$radek[autor]);
        $xtpl->parse('main.novinka');
      endwhile;
      page_out(1);
    break;

//// KONCERTY
    case "koncerty":
      page_in();
      $xtpl->assign_file('OBSAH','xtpl/koncerty.xtpl');
      $dotaz="select * from koncerty where datum>=curdate() order by datum desc";
      $vysledek=@mysql_query($dotaz);
      if(!@mysql_num_rows($vysledek))
        $xtpl->assign('PAUZA',detail('pauzicka'));
      while($radek=@mysql_fetch_array($vysledek)):
        $datum=substr($radek[datum],8,2).'-'.(int) substr($radek[datum],5,2).'-'.substr($radek[datum],0,4);
        $xtpl->assign('DATUM',$datum);
        $xtpl->assign('MISTO',$radek['misto']);
        $xtpl->assign('POZNAMKA',$radek['poznamka']);
        $xtpl->parse('main.kon_bud');
      endwhile;
      $dotaz="select * from koncerty where datum<curdate() order by datum desc";
      $vysledek=@mysql_query($dotaz);
      while($radek=@mysql_fetch_array($vysledek)):
        $datum=substr($radek[datum],8,2).'-'.substr($radek[datum],5,2).'-'.substr($radek[datum],0,4);
        $xtpl->assign('DATUM',$datum);
        $xtpl->assign('MISTO',$radek['misto']);
        $xtpl->assign('POZNAMKA',$radek['poznamka']);
        $xtpl->parse('main.kon_min');
      endwhile;
      page_out(2);
    break;

//// KAPELA
    case "kapela":
      page_in();
      $dotaz="select * from kapela ".(isset($_GET['id'])?"where id=".$_GET['id']:"")." order by poradi";
      $vysledek=@mysql_query($dotaz);
      $xtpl->assign_file('OBSAH','xtpl/kapela.xtpl');
      if(isset($_GET[id]))
      {
      $radek=@mysql_fetch_array($vysledek);
      $xtpl->assign('JMENO',$radek['jmeno']);
      $xtpl->assign('POZNAMKA',$radek['poznamka']);
      $xtpl->assign('IMG','img/kapela/'.$radek['img']);
      $xtpl->assign('TEXT',nl2br(bold(italic($radek[text]))));
      $xtpl->parse('main.clen');
      $xtpl->assign('BACK','[<a href="javascript:history.back();" class="poznamka"> zpět </a>]<br />');
      }
      else
      {
      while($radek=@mysql_fetch_array($vysledek)):
        $xtpl->assign('JMENO',$radek['jmeno']);
        $xtpl->assign('POZNAMKA',$radek['poznamka']);
        $xtpl->assign('IMG','img/kapela/'.$radek['img']);
        if($radek['text']) {
          $text=italic(bold(substr($radek[text],0,100),0),0);
          $text.='<br /><a href="?pg='.$pg.'&amp;id='.$radek['id'].'" class="poznamka"> ...více</a>';
          }
        else
          $text='';
        $xtpl->assign('TEXT',$text);
        $xtpl->parse('main.clen');
      endwhile;
      }
      page_out(3);
    break;

//// FORUM
    case "forum":
      page_in();
      $dotaz="select * from forum order by datum desc";
      $vysledek=@mysql_query($dotaz);
      $xtpl->assign_file('OBSAH','xtpl/forum.xtpl');
      session_start();
      if($_SESSION[chyby]) {
        $xtpl->assign('CHYBY',nl2br($_SESSION[chyby]));
        $xtpl->parse('main.pole_chyb');
        $form=$_SESSION['form'];
        $xtpl->assign('FORM_JMENO',$form[jmeno]);
        $xtpl->assign('FORM_MAIL',$form[mail]);
        $xtpl->assign('FORM_TEXT',$form[text]);
        session_destroy();
        }
      $step=8;
      $pocet=@mysql_num_rows($vysledek);
      $list=(int) $_GET['list'];
      $zac=$list*$step;
      $kon=($list+1)*$step;
      if($kon>$pocet) $kon=$pocet;
      if($list && $list!=0)
        $navigace="[<a href='?pg=".$pg."&list=".($list-1)."'> novější </a>]";
      $navigace.='</td><td class="right">';
      if($pocet>$kon)
        $navigace.="[<a href='?pg=".$pg."&list=".($list+1)."'> starší </a>]";
      $xtpl->assign('NAVIGATOR',$navigace);
      while($radek=mysql_fetch_array($vysledek)):
        if($i<$zac || $i>$kon) {$i++; continue;}
        $xtpl->assign('DATUM',(int)substr($radek['datum'],8,2).".".(int)substr($radek['datum'],5,2).".".substr($radek['datum'],0,4).", ".(int)substr($radek['datum'],11,2).":".substr($radek['datum'],14,2));
        $xtpl->assign('JMENO',$radek['jmeno']);
        $xtpl->assign('MAIL',$radek['mail']);
        $xtpl->assign('TEXT',wordwrap(nl2br($radek['text']),44,"<br />",1));
        $xtpl->parse('main.prispevek');
        $i++;
      endwhile;
      page_out(4);
    break;

//// ULOZENI DO FORA
    case 'insert':
      $chyby='';
      $exp="^[0-9a-z~!#$%&_-]([.]?[0-9a-zA-Z~!#$%&_-])*@[0-9a-zA-Z~!#$%&_-]([.]?[0-9a-zA-Z~!#$%&_-])*$";
      if(!$_POST[jmeno])
        $chyby.="chybí jméno\n";
      if(!$_POST[mail])
        $chyby.="chybí mail\n";
      else if(!eregi($exp,$_POST['mail']))
        $chyby.="e-mail není platný\n";
      if(!$_POST[text])
        $chyby.="chybí text vzkazu\n";
      if($_POST[robot]!=9)
        $chyby.="padej robote";
      if($chyby) {
        session_start();
        $_SESSION[chyby]=$chyby;
        $_SESSION[form]=$_POST;
        }
      else
      {
      $jmeno=substr(trim($_POST[jmeno]),0,50);
      $mail=substr(trim($_POST[mail]),0,50);
      $text=substr(trim($_POST[text]),0,1500);
      $dotaz=sprintf("insert into forum(id,datum,jmeno,mail,text) values(0,now(),'%s','%s','%s')",$jmeno,$mail,$text);
      @mysql_query($dotaz);
      }
      header("location: $HTTP_REFERER");
      exit;
    break;

//// FOTOGALERIE
    case "foto":
      page_in();
      $xtpl->assign_file('OBSAH','xtpl/foto.xtpl');
      $dotaz="select foto.*,foto_skupiny.nazev from foto,foto_skupiny where foto.skupina=foto_skupiny.id order by foto_skupiny.poradi";
      $vysledek=@mysql_query($dotaz);
      $pred='';$i=1;
      while($radek=@mysql_fetch_array($vysledek)):
        if($pred && $pred[nazev]!=$radek[nazev]) {
          $xtpl->parse('main.sada');
          $i=1;
          }
        $xtpl->assign('NAZEV',$radek[nazev]);
        $xtpl->assign('NAHLED','foto/'.$radek[skupina].'/maly/'.$radek[nahled]);
        $xtpl->assign('ID',$radek[id]);
        if(!($i%3))
          $xtpl->parse('main.sada.fotka.tr');
        $xtpl->parse('main.sada.fotka');
        $i++;
        $pred=$radek;
      endwhile;
      if(@mysql_num_rows($vysledek)) {
        $xtpl->assign('NAZEV',$pred[nazev]);
        $xtpl->parse('main.sada');
        }
      page_out(5);
    break;

//// GALERIE
    case "galerie":
      require_once ('xtemplate.class.php');
      $xtpl = new XTemplate('xtpl/galerie.xtpl');
      $dotaz=sprintf("select cesta,skupina from foto where id=%d",$_GET[id]);
      $vysledek=@mysql_query($dotaz);
      if(@mysql_num_rows($vysledek))
      {
      $radek=@mysql_fetch_array($vysledek);
      $cesta='foto/'.$radek[skupina].'/'.$radek[cesta];
      $pole=getimagesize($cesta);
      $xtpl->assign('CESTA',$cesta);
      $xtpl->assign('X',$pole[0]);
      $xtpl->assign('Y',$pole[1]);
      $xtpl->parse('main.fotka');
      }
      $xtpl->parse('main');
      $xtpl->out('main');
    break;

//// AUDIO
    case "audio":
      page_in();
      $dotaz="select audio.*,diskografie.nazev as deska,diskografie.nahled from audio,diskografie where diskografie.id=audio.deska_id order by diskografie.poradi,audio.poradi";
      $vysledek=@mysql_query($dotaz);
      $xtpl->assign_file('OBSAH','xtpl/audio.xtpl');
      $xtpl->assign('TEXT',detail('head_audio'));
      $pred='';
      $i=0;
      while($radek=@mysql_fetch_array($vysledek)):
        if($pred && $pred[deska_id]!=$radek[deska_id] && $i) {
          $xtpl->parse('main.sada');
          $i=0;
          }
        $cesta='audio/'.$radek[deska_id].'/'.$radek[cesta];
        if(!file_exists($cesta)) continue;
        $i++;
        $xtpl->assign('SIZE',size($cesta));
        $xtpl->assign('DESKA',$radek[deska]);
        $xtpl->assign('NAZEV',$radek[nazev]);
        $xtpl->assign('NAHLED','img/disco/'.$radek[nahled]);
        $xtpl->assign('CESTA',$cesta);
        $xtpl->parse('main.sada.link');
        $pred=$radek;
      endwhile;
      if(@mysql_num_rows($vysledek) && $i) {
        $xtpl->assign('DESKA',$pred[deska]);
        $xtpl->assign('NAHLED','img/disco/'.$pred[nahled]);
        $xtpl->parse('main.sada');
        }
      page_out(6);
    break;

//// VIDEOKLIPY
    case "video":
      page_in();
      $dotaz="select* from video where img!='' and cesta!='' order by poradi";
      $vysledek=@mysql_query($dotaz);
      $xtpl->assign_file('OBSAH','xtpl/video.xtpl');
      $xtpl->assign('HEAD',detail('head_video'));
      while($radek=@mysql_fetch_array($vysledek)):
        $cesta='video/'.$radek[cesta];
        if(!file_exists($cesta)) continue;
        $xtpl->assign('NAZEV',$radek[nazev]);
        $xtpl->assign('IMG','img/video/'.$radek[img]);
        $xtpl->assign('TEXT',$radek[text]);
        $xtpl->assign('CESTA',$cesta);
        $xtpl->parse('main.klip');
        $pred=$radek;
      endwhile;
      page_out(7);
    break;

//// HISTORIE
    case "historie":
      page_in();
      $text=detail('historie');
      $text=nl2br(bold(italic($text)));
      $xtpl->assign_file('OBSAH','xtpl/text.xtpl');
      $xtpl->assign('TEXT',$text);
      page_out(8);
    break;

//// DISKOGRAFIE
    case "diskografie":
      page_in();
      $dotaz="select * from diskografie order by poradi";
      $vysledek=@mysql_query($dotaz);
      $xtpl->assign_file('OBSAH','xtpl/diskografie.xtpl');
      while($radek=@mysql_fetch_array($vysledek)):
        $xtpl->assign('NAZEV',$radek[nazev]);
        $xtpl->assign('POPIS',$radek[popis]);
        $xtpl->assign('NAHLED','img/disco/'.$radek['nahled']);
        $xtpl->parse('main.deska');
      endwhile;
      page_out(9);
    break;

//// TEXTY
    case "texty":
      page_in();
      if($_GET[id])
      {
      $dotaz=sprintf("select texty.text_%s as words,texty.nazev_%s as nazev,diskografie.nazev as deska from texty,diskografie where diskografie.id=texty.deska_id and texty.id=%d",$_GET[lang],$_GET[lang],$_GET[id]);
      $vysledek=@mysql_query($dotaz);
      $xtpl->assign_file('OBSAH','xtpl/texty.xtpl');
      $radek=@mysql_fetch_array($vysledek);
      $xtpl->assign('DESKA',$radek[deska]);
      $xtpl->assign('NAZEV',$radek[nazev]);
      $xtpl->assign('WORDS',nl2br(bold(italic($radek[words]))));
      $xtpl->parse('main.text');
      }
      else
      {
      $dotaz="select texty.*,diskografie.nazev as deska from texty,diskografie where diskografie.id=texty.deska_id order by diskografie.poradi,texty.poradi";
      $vysledek=@mysql_query($dotaz);
      $xtpl->assign_file('OBSAH','xtpl/texty.xtpl');
      $pred='';
      $i=0;
      while($radek=@mysql_fetch_array($vysledek)):
        if($pred && $pred[deska_id]!=$radek[deska_id] && $i) {
          $xtpl->parse('main.texty.sada');
          $i=0;
          }
        $xtpl->assign('DESKA',$radek[deska]);
        $xtpl->assign('ID',$radek[id]);
        $xtpl->assign('NAZEV_C',$radek[nazev_c]);
        $xtpl->assign('NAZEV_E',$radek[nazev_e]);
        if($radek[nazev_c] && $radek[text_c])
          $xtpl->parse('main.texty.sada.tr.c');
        if($radek[nazev_e] && $radek[text_e])
          $xtpl->parse('main.texty.sada.tr.e');
        if(($radek[nazev_c] && $radek[text_c]) || ($radek[nazev_e] && $radek[text_e])) {
          $xtpl->parse('main.texty.sada.tr');
          $i++;
          }
        $pred=$radek;
      endwhile;
      if(@mysql_num_rows($vysledek) && $i) {
        $xtpl->assign('DESKA',$pred[deska]);
        $xtpl->parse('main.texty.sada');
        }
      $xtpl->parse('main.texty');
      }
      page_out(10);
    break;

//// Z TISKU
      case "ztisku":
      page_in();
      if($_GET[id])
      {
      $xtpl->assign_file('OBSAH','xtpl/ztisku.xtpl');
      $dotaz=sprintf('select nadpis,autor,zdroj,text from ztisku where id=%d',$_GET[id]);
      $vysledek=@mysql_query($dotaz);
      $radek=@mysql_fetch_array($vysledek);
      $xtpl->assign('NADPIS',$radek[nadpis]);
      $xtpl->assign('AUTOR',$radek[autor]);
      $xtpl->assign('ZDROJ',$radek[zdroj]);
      $xtpl->assign('TEXT',nl2br(bold(italic($radek[text]))));
      $xtpl->parse('main.clanek');
      }
      else
      {
      $xtpl->assign_file('OBSAH','xtpl/ztisku.xtpl');
      $dotaz='select id,nadpis,autor,zdroj from ztisku order by poradi';
      $vysledek=@mysql_query($dotaz);
      while($radek=@mysql_fetch_array($vysledek)):
        $xtpl->assign('ID',$radek[id]);
        $xtpl->assign('NADPIS',$radek[nadpis]);
        $xtpl->assign('AUTOR',$radek[autor]);
        $xtpl->assign('ZDROJ',$radek[zdroj]);
        $xtpl->parse('main.odkaz');
      endwhile;
      }
      page_out(11);
      break;

//// ODKAZY
    case "odkazy":
      page_in();
      $xtpl->assign_file('OBSAH','xtpl/odkazy.xtpl');
      $dotaz='select * from odkazy order by poradi';
      $vysledek=@mysql_query($dotaz);
      while($radek=@mysql_fetch_array($vysledek)):
        $xtpl->assign('NAZEV',strtoupper($radek[nazev]));
        $xtpl->assign('LINK','http://'.$radek[link]);
        $xtpl->assign('INFO',$radek[info]);
        $xtpl->parse('main.odkaz');
      endwhile;
      page_out(12);
    break;

//// KONTAKT
    case "kontakt":
      page_in();
      $text=detail('kontakt');
      $text=nl2br(bold(italic($text)));
      $xtpl->assign_file('OBSAH','xtpl/text.xtpl');
      $xtpl->assign('TEXT',$text);
      page_out(13);
    break;
    }
?>