<?php
//server connfigure
$server = "localhost";
$dbusername = "root";
$dbpassword = "";
$db_name = "csweссb";
$table_name = "servers";
//server connfigure
//колко резултата на страница
$pp = "700";
//колко резултата на страница
$page=$_GET['page']; //присвояваме стойността на page
if(!$_GET['page']) //ако не е взета page да върне 1-ца
{
$page="1";
}
$limit = ($pp*$page)-$pp; //определяме лимитирането
mysql_connect($server, $dbusername, $dbpassword)or die("1111");
@mysql_select_db($db_name) 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($db_name) or die("4444");
$query="SELECT * FROM $table_name ORDER BY `id` DESC LIMIT $limit,$pp";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while($row = mysql_fetch_array($result)) {
$id = $row['id'];
$name = $row['name'];
$ip = $row['ip'];
$port = $row['port'];
$cheat = $row['cheat'];
$type = $row['type'];
$author = $row['author'];
echo "<div id='hoverman'><table width='580px' height='25px' border='0'>
<tr>
<td>
<img src='cstrike.gif' width='16' height='16' /> $name <br />$ip:$port
</td>
<td>
<a href='info.php?id=$id'><img src='info-icon.png' width='421' height='38' /></a>
</td>
</tr>
</table><center></div>";
$i++;
}
echo "";
?>
