";
//konec banneru 1
//novinky15
$result1 = mysql_query("SELECT id, nadpis, text, idstr, url, druh, soubor, diskuse, descr FROM clanky$lang WHERE kos = '0' AND new = '1' AND lang LIKE '%$lang%' AND datum <=CURRENT_TIMESTAMP AND do >=CURRENT_TIMESTAMP ORDER BY datum DESC LIMIT 5");
if ($pomocne['seznam']==1 and mysql_num_rows($result1) > 1){
echo "
";
while ($row1 = mysql_fetch_assoc($result1)) {
echo"
";
}
///////////konec uvodni stranky//////
//------------vnitřní strany---------
else {
//drobeckovka prvni cast - nacteni hodnot
if ($_GET['idstr']) {$drobeckovkaout = navigace ($_GET['idstr'], $_SESSION['v1598nastshop']['jmeno'], $_SESSION['v1598lang']['l4'], $_SESSION['v1598lang']['l24'], $lang, $cestalang, $headernadpis);}
if ($id or $_GET['id']){
if ($_GET['id']) $id = $_GET['id'];
$result = mysql_query("SELECT * FROM clanky$lang WHERE id = '$id'");
while ($row = mysql_fetch_assoc($result)) {
if (!$_GET['idstr']) $drobeckovkaout = navigace ($row['idstr'], $_SESSION['v1598nastshop']['jmeno'], $_SESSION['v1598lang']['l4'], $_SESSION['v1598lang']['l24'], $lang, $cestalang, $headernadpis);}}
//----konec drobeckovka prvni cast - nacteni hodnot
//--hlavní fotka (místo slideru)--
echo "
";
if ($_GET['kateg'] and ($_GET['druh'] or $_GET['urceni'] or $_GET['typ'] or $_GET['znacka'] or $_GET['velikost'] or $_GET['akceh'] or $_GET['produkt'])){
echo "";}
else {
echo "";
if (($_GET['akce']!="shopnahled" and $id and !$_POST['objednat']) or ($_GET['akce']!="shopnahled" and $ids and !$_POST['objednat']) or ($_GET['akce']!="shopnahled" and $_GET['id'] and !$_POST['objednat']) or ($_GET['akce']!="shopnahled" and ($_GET['kateg'] or $_GET['druh'] or $_GET['urceni'] or $_GET['ty
p'] or $_GET['znacka'] or $_GET['velikost'] or $_GET['vse'] or $_GET['akceh'])) or $shokat){
if (!$id) $id = $_GET['id'];
if ($id) {
if (file_exists ("fota/$id/fotkahl.jpg")) {
$result = mysql_query("SELECT baner FROM clanky$lang WHERE id = '$id'");
while ($row = mysql_fetch_assoc($result)) {
if (strpos($row['baner'], ",cb,")!==false) $cb="cb";
}
echo "
"; }
else if (file_exists ("zdroje/hlavy/hlava".$idstrlv5.".jpg")) { echo "";}
else if (file_exists ("zdroje/hlavy/hlava".$idstrlv4.".jpg")) { echo "";}
else if (file_exists ("zdroje/hlavy/hlava".$idstrlv3.".jpg")) { echo "";}
else if (file_exists ("zdroje/hlavy/hlava".$idstrlv2.".jpg")) { echo "";}
else if (file_exists ("zdroje/hlavy/hlava".$idstrlv1.".jpg")) { echo "";}
else echo "
";}
}
if ($_GET['idstr'] and !$id) {
if (file_exists ("zdroje/hlavy/hlava".$idstrlv5.".jpg")) { echo "";}
else if (file_exists ("zdroje/hlavy/hlava".$idstrlv4.".jpg")) { echo "";}
else if (file_exists ("zdroje/hlavy/hlava".$idstrlv3.".jpg")) { echo "";}
else if (file_exists ("zdroje/hlavy/hlava".$idstrlv2.".jpg")) { echo "";}
else if (file_exists ("zdroje/hlavy/hlava".$idstrlv1.".jpg")) { echo "";}
else echo "
";}
if ($_GET['akce'] and $_GET['akce']!="detail") {
echo "
";}
if ($_GET['kateg'] and !$_GET['druh'] and !$_GET['urceni'] and !$_GET['typ'] and !$_GET['znacka'] and !$_GET['velikost'] and !$_GET['produkt'] and !$_GET['akceh'] and !$_GET['vse']) {
if (file_exists ("fota/kateg/$idkateg.jpg")) echo "";
}
}
echo "
";
//konec hlavní fotky
//drobeckovka druha cast - vypis hodnot hodnot
echo $drobeckovkaout;
if (!$id and !$_GET['id'] and !$_GET['idstr']){
echo "
";
unset ($_SESSION['v1598hlaska']);
}
if ($_SESSION['v1598upruser']){
unset ($_SESSION['v1598upruser']);
}
//zpracovani jednotlive polozky je v hlavicce kvuli pouziti headeru pri nahledu polozky soub
if ($_GET['idstr']) {
$result = mysql_query("SELECT nazev$lang, archiv, level FROM struktura WHERE id = '".$_GET['idstr']."'");
while ($row = mysql_fetch_assoc($result)) {
$nazevkapit = $row['nazev'.$lang];
$archiv = $row['archiv'];
$level = $row['level'];
}
$vysledek = mysql_query("SELECT id, nadpis, url, druh, datum, DATE_FORMAT(datum, '%d. %m. %Y') AS 'datumformat', text, soubor, textnews, diskuse FROM clanky$lang WHERE idstr = '".$_GET['idstr']."' AND kos = '0' AND lang LIKE '%$lang%' AND datum <=CURRENT_TIMESTAMP AND do >=CURRENT_TIMESTAMP ORDER BY datum DESC");
if (mysql_num_rows($vysledek) < 1){
echo "
$nazevkapit
";
$sql = "SELECT * FROM struktura WHERE level like '$level"."__.' order by level asc";
$result = mysql_query($sql);
echo "
";
while ($row = mysql_fetch_assoc($result)) {
if (!preg_match("/$lang/", $row['lang']) or $custprava < $row['prava2'] ) $struktzakaz2 = $row['level'];
if (!preg_match("/^($struktzakaz2)/", $row['level']) or $struktzakaz2=='' ){
echo "
";
}
}
if (($_GET['akce']!="shopnahled" and $id and !$_POST['objednat']) or ($_GET['akce']!="shopnahled" and $ids and !$_POST['objednat']) or ($_GET['akce']!="shopnahled" and $_GET['id'] and !$_POST['objednat']) or ($_GET['akce']!="shopnahled" and ($_GET['kateg'] or $_GET['druh'] or $_GET['urceni'] or $_GET['typ'] or $_GET['znacka'] or $_GET['velikost'] or $_GET['vse'] or $_GET['akceh'])) or $shokat){
if ($_GET['id']) $id = $_GET['id'];
$result = mysql_query("SELECT * FROM clanky$lang WHERE id = '$id' AND kos = '0' AND lang LIKE '%$lang%'");
while ($row = mysql_fetch_assoc($result)) {
if ($row['druh'] == "txto" or $row['druh'] == "news" or $row['druh'] == "fgt" or $row['druh'] == "tiskat" ){
echo "
";
//blocek podmenu
if ($row['podmenu'] == "1"){
$sql1 = "SELECT level FROM struktura WHERE id = '$row[idstr]'";
$result1 = mysql_query($sql1);
$row1 = mysql_fetch_assoc($result1);
$sqlstr = "SELECT * FROM struktura WHERE level like '$row1[level]"."__.' order by level asc";
$resultstr = mysql_query($sqlstr);
echo "
";
while ($rowstr = mysql_fetch_assoc($resultstr)) {
if (!preg_match("/$lang/", $rowstr['lang']) or $custprava < $rowstr['prava2'] ) $struktzakaz2 = $rowstr['level'];
if (!preg_match("/^($struktzakaz2)/", $rowstr['level']) or $struktzakaz2=='' ){
echo "
";
if ($row[$popis]) echo "".$row[$popis]."";
echo "
";
}}
echo"
";
echo "
";
}
}
//katalog položek
if ($row[druh] == "kat" and ($_GET[akce] != "nahled" and $_GET[akce] != "detail" )){
if ($_GET[akce] != "nahled"){
echo "
";
echo "
$row[nadpis]
";
$druh = $row[druh]; //promenna druh pro volbu v pravem sloupci
echo "
$row[text]
";
$kostrajqpop = $kostrajqpop."";
if (file_exists ("fota/$row[id]/kostra.svg")){
$resultkat = mysql_query("SELECT * FROM katalog WHERE idclanky = '$id' ORDER BY poradi ASC");
while ($rowkat = mysql_fetch_assoc($resultkat)) {
$kostrajqpop = $kostrajqpop."
";
}
}
/*
else if (file_exists ("fota/$row[id]/kostra$lang.swf")){
echo"
";
}*/
//test je li nejaky obr
$resultest = mysql_query("SELECT cislo FROM katalog WHERE idclanky = '$id'");
while ($rowkatt = mysql_fetch_assoc($resultest)) {
$idcislot = str_replace("/", "-", $rowkatt[cislo]);
if (file_exists ("$cesta"."fota/peram/$idcislot.jpg") or file_exists ("$cesta"."fota/fotvar/$idcislot.jpg")) $jenahled=1;
}
//konec testu
//dekory
$resultest = mysql_query("SELECT * FROM dekory WHERE idcl='".$id."' order by poradi asc");
if (mysql_num_rows($resultest)>0) {
echo"
";
while ($rowkatt = mysql_fetch_assoc($resultest)) {
echo"".$rowkatt[jmeno]."
";
}
echo"
";
}
//konecdekoru
$resultkat = mysql_query("SELECT id, cislo, nazev$lang, prumerm, prumeri, objemm, objemo, vyskam, vyskai, sirkam, sirkai, druhvyr, novinka FROM katalog WHERE idclanky = '$id' ORDER BY poradi ASC");
while ($rowkat = mysql_fetch_assoc($resultkat)) {
$idcislo = $rowkat["cislo"];
$idcislo = str_replace("/", "-", $idcislo);
echo "
";
}
}
//konec katalogu detail
//kontaktni formular
if ($row['form'] == "1") {require "kontform.php";}
if ($row['diskuse'] == "1") echo "".$_SESSION['v1598lang']['l39']."";
//if ($row['diskuse'] == "1") echo "$ldiskvstup";
}
//sekce shopu - hlavní strana
if (file_exists ("shop.php") and (!$_GET['kateg'] and !$_GET['druh'] and !$_GET['urceni'] and !$_GET['typ'] and !$_GET['znacka'] and !$_GET['velikost'] and !$_GET['produkt'] and !$_GET['akceh'] and !$_GET['vse']) and $shokat) {
require "leva.php";
if ($shokat==1){
if ($pomocne["nadpish".$lang] !="") echo "
";
require "slidermalysh1.php";
require "slidermalysh2.php";
}
}
//sekce shopu
if (file_exists ("shop.php") and ($_GET['kateg'] or $_GET['druh'] or $_GET['urceni'] or $_GET['typ'] or $_GET['znacka'] or $_GET['velikost'] or $_GET['produkt'] or $_GET['akceh'] or $_GET['vse'])) {
// $nadpshop a $prikazakl je v hlavičce
if ($shokat == 1) $prikaz = "SELECT * FROM shop WHERE kos = '0' $sklad1 AND shop='1' AND langsh$lang = '1' ".$prikazakl;
if ($shokat == 2) $prikaz = "SELECT * FROM shop WHERE kos = '0' AND katalog='1' AND langsh$lang = '1' ".$prikazakl;
if (!$_GET['produkt']){
if (file_exists ("fota/kateg/$idkateg.jpg") and !$_GET['druh'] and !$_GET['urceni'] and !$_GET['typ'] and !$_GET['znacka'] and !$_GET['velikost'] and !$_GET['akceh']) echo "";
echo "
";
if ($druhtexth and $kategtexth and !$_GET['urceni'] and !$_GET['typ'] and !$_GET['znacka'] and !$_GET['velikost'] and !$_GET['akceh']) echo "
$druhtexth
";
if ($kategtexth and !$_GET['druh'] and !$_GET['urceni'] and !$_GET['typ'] and !$_GET['znacka'] and !$_GET['velikost'] and !$_GET['akceh']) echo "
$kategtexth
";
//menu razeni shopu
if (($_GET['kateg'] or $_GET['druh'] or $_GET['urceni'] or $_GET['typ'] or $_GET['znacka'] or $_GET['velikost'] or $_GET['akceh']) and !$_GET['produkt'] ){
if (!$_SESSION['v1598polozek']) $_SESSION['v1598polozek']=24;
if (!$_SESSION['v1598razeni']) $_SESSION['v1598razeni']="kus";
if (!$_SESSION['v1598razeniad']) $_SESSION['v1598razeniad']="desc";
echo "
";
}
//pokud nechci strankovat s promennou $_GET['strana'] je nutne vzhodit nasledujici radek a o dva radky dal nahradit promennou strana cislem 1 a zaktivnit if. Nasledne je treba upravit shopzprac.php ale to neni nutne. Pozor na parametr ['QSA,L'] v .htaccess.
if (!$_GET['strana']) {$strana = 1; unset ($_SESSION['v1598shoplimit']);} else $strana = $_GET['strana'];
if ($_SESSION['v1598shoplimit']['cesta'] != $nadpshopd) unset ($_SESSION['v1598shoplimit']);
//if (!$_SESSION['v1598shoplimit'])
$_SESSION['v1598shoplimit']= array ("limit" => $strana,
"cesta" => $nadpshopd);
if ($_SESSION['v1598polozek'] !="vse" ) $limit = "LIMIT ".(($_SESSION['v1598shoplimit']['limit']-1)*$_SESSION['v1598polozek']).", ".$_SESSION['v1598polozek'];
$prikaz1 = "SELECT * FROM shop WHERE kos = '0' $sklad AND langsh$lang = '1' ".$prikazakl;
$result1 = mysql_query($prikaz1);
$ppol = mysql_num_rows($result1);
if ($_SESSION['v1598razeni']=="kus") $prikaz = "SELECT shop.*, objzbozi.idshop, sum(objzbozi.kus) as kuscelk from shop left join objzbozi on shop.id=objzbozi.idshop WHERE shop.kos = '0' $sklad2".$prikazakl." group by objzbozi.idshop, shop.id order by kuscelk ".$_SESSION['v1598razeniad']." $limit";
else $prikaz = $prikaz." ORDER BY ".$_SESSION['v1598razeni']." ".$_SESSION['v1598razeniad']." $limit";
$result = mysql_query($prikaz);
if (mysql_num_rows($result) < 1) echo "
Nenalezena žádná položka. Začněte s výběrem znovu v horním menu.
![".$row["text"] ."](".$cesta."slider/fota/$row[id]-$lang.jpg?".url($row[datum]).")
";
if ($row["text"] !="") echo "
";
if ($row["odkaz"] !="") echo "";
echo "
";
}
echo "![]($cesta"."zdroje/loader.jpg)
";
// slider
echo "![]($cesta"."zdroje/vseobecnahp.jpg)
";
echo "";
echo"![newsletter]($cesta"."zdroje/newsletter.png)
";
echo "![]($cesta"."zdroje/loader.gif)
";
if (($_GET['akce']!="shopnahled" and $id and !$_POST['objednat']) or ($_GET['akce']!="shopnahled" and $ids and !$_POST['objednat']) or ($_GET['akce']!="shopnahled" and $_GET['id'] and !$_POST['objednat']) or ($_GET['akce']!="shopnahled" and ($_GET['kateg'] or $_GET['druh'] or $_GET['urceni'] or $_GET['ty
p'] or $_GET['znacka'] or $_GET['velikost'] or $_GET['vse'] or $_GET['akceh'])) or $shokat){
if (!$id) $id = $_GET['id'];
if ($id) {
if (file_exists ("fota/$id/fotkahl.jpg")) {
$result = mysql_query("SELECT baner FROM clanky$lang WHERE id = '$id'");
while ($row = mysql_fetch_assoc($result)) {
if (strpos($row['baner'], ",cb,")!==false) $cb="cb";
}
echo "![]($cesta"."fota/$id/fotkahl$cb.jpg)
"; }
else if (file_exists ("zdroje/hlavy/hlava".$idstrlv5.".jpg")) { echo "![]($cesta"."zdroje/hlavy/hlava".$idstrlv5.".jpg)
";}
else if (file_exists ("zdroje/hlavy/hlava".$idstrlv4.".jpg")) { echo "![]($cesta"."zdroje/hlavy/hlava".$idstrlv4.".jpg)
";}
else if (file_exists ("zdroje/hlavy/hlava".$idstrlv3.".jpg")) { echo "![]($cesta"."zdroje/hlavy/hlava".$idstrlv3.".jpg)
";}
else if (file_exists ("zdroje/hlavy/hlava".$idstrlv2.".jpg")) { echo "![]($cesta"."zdroje/hlavy/hlava".$idstrlv2.".jpg)
";}
else if (file_exists ("zdroje/hlavy/hlava".$idstrlv1.".jpg")) { echo "![]($cesta"."zdroje/hlavy/hlava".$idstrlv1.".jpg)
";}
else echo "![]($cesta"."zdroje/vseobecna.jpg)
";}
}
if ($_GET['idstr'] and !$id) {
if (file_exists ("zdroje/hlavy/hlava".$idstrlv5.".jpg")) { echo "![]($cesta"."fota/kateg/$idkateg.jpg)
";
}
}
echo "![kosik]($cesta"."zdroje/kosik.jpg)
";
} else echo "
".$_SESSION['v1598lang']['l167']."
![".$radek[]($cesta"."zdroje/vseobecnamala.jpg)
";
echo "".$radek['nadpis']."
";
echo"
".$radek['datumformat']." ".strip_tags($radek['text'])."
".$_SESSION['v1598lang']['l234']."
";
//konec banneru
}
echo"
![$rowkat[cislo]](";
if (file_exists ("fota/fotvar/$idcislo.jpg")) echo $cesta."fota/fotvar/$idcislo.jpg";
else echo $cesta."zdroje/nophoto.jpg";
echo ")
";
echo "";
}
echo "![]($cesta"."zdroje/new.gif)
![]($cesta"."fota/fotvar/$idcislo.jpg)
"; else echo "![]($cesta"."zdroje/nophoto.jpg)
";
echo "![]($cesta"."zdroje/ascw.gif)
"; else echo "![]($cesta"."zdroje/ascg.gif)
"; echo"
"; if ($_SESSION['v1598razeniad']=="desc") echo "![]($cesta"."zdroje/descw.gif)
"; else echo "![]($cesta"."zdroje/descg.gif)
"; echo"
![]($cesta"."zdroje/makce1l.jpg)
".$_SESSION['v1598lang']['l164']."
![]($cesta"."zdroje/makce1pr.jpg)
![".$rowkatt[jmeno]."](".$cesta."fota/".$rowkatt[idcl]."/vdek-".$rowkatt[jmeno].".jpg)