<?php
include ("config.php");
$id = $_GET['id'];
if (!is_numeric($id)) { die ("Непозволени символи!"); }
$pp = "18";
$page= (int)$_GET['page'];
if(!isset($_GET['page']))
{
$page="1";
}
$limit = ($pp*$page)-$pp;
mysql_connect($server, $dbusername, $dbpassword)or die("1111");
mysql_select_db($dbname) or die("2222");
$redove=mysql_query("SELECT * FROM $table_name");
$max=mysql_numrows($redove);
$total=ceil($max/$pp);
mysql_connect($server, $dbusername, $dbpassword)or die("3333");
@mysql_select_db($dbname) or die("4444");
$query=mysql_query("SELECT `id`,`name`,`type`,`size`,`size1`,`date`,`img` , `downloaded` FROM $table_name ORDER BY id DESC LIMIT $limit,$pp") or die(mysql_error());
if (mysql_num_rows($query) == 0) { die("Няма записи в таблицата"); }
while(list($id , $name , $type , $size , $size1 , $date , $img ,$downloaded) = mysql_fetch_array($query))
{
include ("all.php");
}
$result=mysql_query($query);
$num=mysql_numrows($query);
mysql_close();
$i=0;
while ($i < $num) {
$data=@mysql_result($result,$i,"data");
echo $data."";
$i++;
}
echo"<center>";
if ($page > 1) {
$prev = ($page - 1);
echo "<a href="?page=$prev"><img style='border: none;' src='images/icons/previous.gif'></a> ";
}
else echo "";
if (!$page or ($page > $total)) {
$page="1";
}
if ($total < 10) {
for($i=1 ; $i<=$total ; $i++) {
if ( ($page)==$i ) {
echo "<b>[$i]</b> ";
}
else {
echo "<a href="?page=".$i."" >".$i."</a> ";
}
}
}
else {
for($i=1 ; $i<=3 ; $i++) {
if ( ($page)==$i ) {
echo "<b>$i</b> ";
}
else {
echo "<a href="?page=".$i."" >".$i."</a> ";
}
}
if ($page <= 3) {
if ($page == 3) echo "<a href="?page=4">4</a> ";
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a href="?page=".$i."">".$i."</a> ";
}
if ($page == 5) $parva.= "<a href="?page=4">4</a> ";
if ( ($page == 4) or ($page == 5) ) {
for ($i=$page; $i<=$page+1; $i++) {
if ($page == $i) echo "<b>$i</b> ";
else echo "<a href="?page=".$i."">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a href="?page=".$i."">".$i."</a> ";
}
if ( ($page > 5) and ($page < ($total - 4)) ) {
echo "... ";
for ($i=$page-1; $i<=$page+1; $i++) {
if ($page == $i) echo "<b>$i</b> ";
else echo "<a href="?page=".$i."">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a href="?page=".$i."" >".$i."</a> ";
}
if ( $page > ($total - 5) ) {
echo "... ";
for ($i=$total-5; $i<=$total; $i++) {
if ($page == $i) echo "<b>$i</b> ";
else echo "<a href="?page=".$i."">".$i."</a> ";
}
}
}
if ($page < $total) {
$next = ($page + 1);
echo "<a href="?page=$next"><img style='border: none;' src='images/icons/next.gif'></a> ";
}
else echo "";
echo"</center>";
?>