$id = (int) $id;
$q = "SELECT c.id, c.nadpis, c.anotace, LEFT(c.text,5) as cl, a.mail, a.podpis, a.id as id_aut, a.podpis, date_format(c.od_datum, '%e. %c. %Y') as dat, c.poradi, c.poc_kom, c.pristupy FROM $tb_clanecky c, $tb_reg a WHERE c.od_datum <= now() and c.id_vlozil = a.id and c.id and c.id = '$id'";
$r = mysql_query($q) or die(err_query($q));
$z1 = mysql_fetch_assoc($r);
//ulozi cookies
SetCookie("cook_clanek_{$id}", $z1["poc_kom"],(time() + (3600 * 24 * 365 * 10)));
$title = "Příspěvky k: {$z1['nadpis']} - Prdel.cz";
require "levak.php"?>
echo "{$z1['nadpis']}
";
echo "" . textak($z1["anotace"]) . "";
?>
" class="vice">
require "kom_novy.php";
$clanku_max = 20;
$s += 0;
$q = "SELECT k.id, k.vec, k.komentar, k.jmeno, k.mail, date_format(k.datum, '%e. %c. %Y - %k:%i') as dat, r.id as id_autor, r.login as rjmeno, r.mail as rmail FROM $tb_komentare k, $tb_reg r WHERE (k.id_jmeno = r.id) and k.id_clanku = '$id' ORDER BY k.datum DESC LIMIT $s, $clanku_max";
$r = mysql_query($q) or die (err_query($q));
echo '';
while ($z1 = mysql_fetch_assoc($r)) {
echo '';
if ((1 != $z1['id_autor']) and (file_exists("img/lide/{$z1['id_autor']}.gif")))
echo " ";
else
echo " ";
echo ' | ';
echo "";
if (!empty($z1['vec'])) echo "{$z1['vec']} \n";
echo text_koment($z1["komentar"]);
echo " |
\n\n";
} //while
?>
$s += 0;
$res = MySQL_Query("SELECT count(k.id) as count FROM $tb_komentare k, $tb_reg r WHERE (k.id_jmeno = r.id) and k.id_clanku = '$id'");
$z1nam = MySql_Fetch_Array($res);
echo "
» ";
echo ($s+1). " - ";
if (($s+$clanku_max) <= $z1nam['count']) echo ($clanku_max+$s);
else echo $z1nam['count'];
echo " z {$z1nam['count']} příspěvků";
if ($s > ($clanku_max-1)) echo " | předchozích $clanku_max";
if (($s+($clanku_max*2)) <= $z1nam['count']) echo " | dalších $clanku_max";
elseif (($s+($clanku_max*2)) <= ($z1nam['count']+$clanku_max)) echo " | zbylých ". ($z1nam['count']-$s-$clanku_max) ."";
if ($z1nam['count'] <> $z1["poc_kom"]) { //nesouhlasi-li pocet prispevku update...
$query = "UPDATE $tb_clanecky SET poc_kom = {$z1nam['count']} WHERE id = $id";
$res = mysql_query($query);
}
?>