';
$ret .= '
';
// obrazky
$sql = 'SELECT
'.DB_PREFIX.'obrazek.id_obrazek,
'.DB_PREFIX.'obrazek.link AS obrazek_src,
REGEXP_REPLACE('.DB_PREFIX.'obrazek.popisek,\'^bez popisku ([0-9]*)\',\'\') AS obrazek_alt
FROM '.DB_PREFIX.'obrazek
WHERE '.DB_PREFIX.'obrazek.active_state = 1
AND '.DB_PREFIX.'obrazek.typ = 1
AND '.DB_PREFIX.'obrazek.polozka_id LIKE \''.$katalog_polozka->unikatni_id.'\'
ORDER BY '.DB_PREFIX.'obrazek.priorita DESC';
if($pictures = $db->get_results($sql))
{
$celkem = count($pictures);
foreach($pictures as $key => $picture)
{
if($thumb = get_thumbs($picture->obrazek_src, 595, 395))
{
$keyS = $key+1;
if(strlen($key+1) == 1) $keyS = '0'.($key+1);
$ret .= '
'."\n";
$ret .= '
'."\n";
}
};
};
$ret .= '
';
$ret .= '
'."\n";
$ret .= ''.get_nahled($katalog_polozka->text, 350, false, $katalog_polozka->url.'?showTab=popis').''."\n";
$ret .= '
'."\n";
$ret .= $tools;
// obrazky
$sql = 'SELECT
'.DB_PREFIX.'obrazek.id_obrazek,
'.DB_PREFIX.'obrazek.link AS obrazek_src,
REGEXP_REPLACE('.DB_PREFIX.'obrazek.popisek,\'^bez popisku ([0-9]*)\',\'\') AS obrazek_alt
FROM '.DB_PREFIX.'obrazek
WHERE '.DB_PREFIX.'obrazek.active_state = 1
AND '.DB_PREFIX.'obrazek.typ = 1
AND '.DB_PREFIX.'obrazek.polozka_id LIKE \''.$katalog_polozka->unikatni_id.'\'
ORDER BY '.DB_PREFIX.'obrazek.priorita DESC';
if($res = $db->get_results($sql))
{
$ret .= 'Diskuze k tomuto článku je zablokována.
'."\n";
};
}
// katalog_polozka
else
{
/*
// galerie horizontalni
$sql = 'SELECT
'.DB_PREFIX.'obrazek.id_obrazek,
'.DB_PREFIX.'obrazek.link AS obrazek_src,
REGEXP_REPLACE('.DB_PREFIX.'obrazek.popisek,\'^bez popisku ([0-9]*)\',\'\') AS obrazek_alt
FROM '.DB_PREFIX.'obrazek
WHERE '.DB_PREFIX.'obrazek.active_state = 1
AND '.DB_PREFIX.'obrazek.typ = 1
AND '.DB_PREFIX.'obrazek.polozka_id LIKE \''.$katalog_polozka->unikatni_id.'\'
ORDER BY '.DB_PREFIX.'obrazek.priorita DESC';
$retGal = '';
if($res = $db->get_results($sql))
{
$retGal .= ''."\n";
$ret .= '
'.$katalog_polozka->nazev.'
'."\n";
$ret .= '
'."\n";
// hlavni obrazek
if($obrazek = get_image($katalog_polozka->unikatni_id))
{
if($thumb = get_thumbs($obrazek['obrazek_src'], 20000, 2000, true, true))
{
$ret .= '
'."\n";
//$ret .= ''."\n";
$ret .= '!['.$obrazek['obrazek_alt'].'](/obrazek/'.$thumb.' "'.$obrazek['obrazek_alt'].'")
'."\n";
//$ret .= ''."\n";
$ret .= '
'."\n";
}
}
$ret .= '
'."\n";
$ret .= ''.$katalog_polozka->nazev.'
'."\n";
$ret .= ''.$katalog_polozka->katalog_ulice.'
'."\n";
$ret .= ''.$katalog_polozka->katalog_psc.' '.$katalog_polozka->katalog_mesto.''."\n";
$ret .= '
'."\n";
$ret .= '
'."\n";
if($katalog_polozka->katalog_kontakt_prijmeni)$ret .= 'Kontaktní osoba:
'."\n";
if($katalog_polozka->katalog_kontakt_prijmeni) $ret .= ''.$katalog_polozka->katalog_kontakt_titul.' '.$katalog_polozka->katalog_kontakt_jmeno.' '.$katalog_polozka->katalog_kontakt_prijmeni.'
'."\n";
if($katalog_polozka->katalog_kontakt_telefon) $ret .= 'Tel.: '.$katalog_polozka->katalog_kontakt_telefon.'
'."\n";
if($katalog_polozka->katalog_kontakt_mobil) $ret .= 'Mob.: '.$katalog_polozka->katalog_kontakt_mobil.''."\n";
$ret .= '
'."\n";
if($katalog_polozka->katalog_web) $ret .= '
'.$katalog_polozka->katalog_web.'
'."\n";
if($katalog_polozka->katalog_kategorie)
{
$ret .= '
'."\n";
$ret .= 'Kategorie:
'."\n";
$ret .= ''.$ciselnik['katalog_kategorie'][$katalog_polozka->katalog_kategorie].''."\n";
$ret .= '
'."\n";
}
$ret .= '
'."\n";
$ret .= '
'."\n";
// zobrazeni tela clanku
$ret .= '
'."\n";
$ret .= ''.$katalog_polozka->text.''."\n";
$ret .= '
'."\n";
// galerie horizontalni
$sql = 'SELECT
'.DB_PREFIX.'obrazek.id_obrazek,
'.DB_PREFIX.'obrazek.link AS obrazek_src,
REGEXP_REPLACE('.DB_PREFIX.'obrazek.popisek,\'^bez popisku ([0-9]*)\',\'\') AS obrazek_alt
FROM '.DB_PREFIX.'obrazek
WHERE '.DB_PREFIX.'obrazek.active_state = 1
AND '.DB_PREFIX.'obrazek.typ = 1
AND '.DB_PREFIX.'obrazek.polozka_id LIKE \''.$katalog_polozka->unikatni_id.'\'
ORDER BY '.DB_PREFIX.'obrazek.priorita DESC';
$retGal = '';
if($res = $db->get_results($sql))
{
$retGal .= '
';
};
$ret .= $retGal.'
'."\n";
$ret .= '
'."\n";
$ret .= '
Mohlo by vás zajímat
'."\n";
foreach($res as $itemKey => $related)
{
$ret .= '
'."\n";
$ret .= '
'."\n";
$ret .= '
'."\n";
}
$ret .= '