/* E-mail: Web (i s http://): */ echo "

Novinky

"; if (isset($_SESSION['login_nick'])) echo "
   
"; include "database.php"; $link = mysql_connect($server, $name, $heslo) or die("Nelze se pipojit"); mysql_query("SET NAMES utf8"); mysql_select_db($db) or die("Nelze vybrat databzi"); if (!$page) $page=0; $query = "SELECT * FROM news"; $result = mysql_query($query) or die("Dotaz nelze provst"); $pocet = mysql_num_rows($result); if (!$order) $order = "id"; $query = "SELECT * FROM news WHERE YEAR(`datum`) = YEAR(NOW()) ORDER BY $order DESC LIMIT " . $page * 20 . " , 20"; $result = mysql_query($query) or die("Dotaz nelze provst"); while ($row = mysql_fetch_array($result)) { $jmeno = $row['jmeno']; $row['text'] = ereg_replace("\*([0-9]+)\*","\"\\0\"",$row['text']); // Hvezdicky = hodnoceni * 25px echo " "; if (isset($_SESSION["login_login"])) echo " "; echo "
" . date("j.n.y H:i",strtotime($row['datum'])) . " - $jmenoX
{$row['text']}
"; } if ($pocet > 20 ) { $predchozi = $page-1; $dalsi = $page+1; for($r = 0; $r < ceil($pocet/20); $r++) { if($r==$page){ $stranky .= " " . $r . "\n"; } else { $stranky .= " " . $r . "\n"; } } echo "
"; if ($page+1 < $pocet/20 AND $page > 0) { echo " << Novější\n{$stranky} Starší >>\n"; } elseif ($page == 0 AND $pocet > 20) { echo " \n{$stranky} Starší >>\n"; } elseif ($page == 0 AND $pocet <= 20) { echo ""; } elseif ($page+1 >= $pocet/20) { echo " << Novější\n{$stranky}\n"; } echo "
"; } @mysql_free_result($result); @mysql_close($link); include "end.php"; ?>