sqlExecute($clanek_query);
$clanek_query = "insert into tmp_clanek
select autor_name,DATE_FORMAT(created,'%d.%m.%Y') as created,komentare,
picture_low,picture,xpx,ypx,xpxb,ypxb,counter,nahled,
clanek_id,nazev,pic_order,sort_order
from clanek
where state=1 and rubrika=$rubrika_id and state=1
and (start_date <= 'now()' or start_date = '0000-00-00') and
(end_date >= 'now()' or end_date = '0000-00-00') and
typ = 1 order by sort_order desc $top";
$no = $db->sqlExecute($clanek_query);
$query = "select * from tmp_clanek order by sort_order desc $top";
$rows = $db->sqlSelectRS($query);
$clanek_line = '';
$clanek_old = '';
$clanek_counter = 0;
if (is_array($rows)) {
$prvni = 0;
while (list ($k,$rs) = each($rows)) {
$clanek_id=$rs[clanek_id];
$autor_name=$rs[autor_name];
if (strlen($autor_name) > 0) {
$autor_name = "$autor_name";
} else {
$autor_name;
}
$nazev=$rs[nazev];
$nahled=$rs[nahled];
$created=$rs[created];
$picture_low=$rs[picture_low];
$picture=$rs[picture];
$xpx=$rs[xpx];
$ypx=$rs[ypx];
$xpxb=$rs[xpxb];
$ypxb=$rs[ypxb];
$counter=$rs[counter];
$picture_order=$rs[pic_order];
$komentare_show = $rs[komentare]+0;
$picture_url = "images/articles/$picture_low";
$picture_url = "images/articles/$picture";
$clanek_counter++;
$nazev_url = "$nazev";
#$clanek_pic=kresli_clanek_img($picture_low,$picture,$xpxb,$ypxb,$picture_order);
if ($komentare_show == 1) {
$komentare_sql = "select count(*) as pocet from komentare where state=1 and clanek=$clanek_id";
$komentare_rows = $db->sqlSelectRS($komentare_sql);
list ($kk,$rsk) = each($komentare_rows);
$komentare_counter = $rsk[pocet] + 0;
$komentare_txt = " | komentáře($komentare_counter)";
#$komentare_txt = " | komentáře($komentare_counter)";
} else {
$komentare_txt = '';
}
if ($clanek_counter == 1 or $clanek_counter == 4 or $clanek_counter == 7) { $clanek_line .= "
";}
}
}
print $clanek_line;
?>
";}
if ($clanek_counter == 3) {
$clanek_line_mobile = " mobile-version-display-none";
$mobile_banner = "
";
} else { $clanek_line_mobile = ''; $mobile_banner='';}
$clanek_line .= <<
$mobile_banner
EOD;
if ($clanek_counter == 3 or $clanek_counter == 6 or $clanek_counter == 9) { $clanek_line .= "