<?
$thispage = $PHP_SELF;
$showeachside = 5; // Колко страници да се показват отляво и отдясно на текущата страница
// Колко реда на страница
$rowsPerPage = 15;
// Подразбираме показване на първа страница
$pageNum = 1;
// ако $_GET['page'] е дифинирано използваме тази страница
if(isset($_GET['page']) and is_numeric($_GET['page']))
{
$pageNum = $_GET['page'];
}
if(!preg_match("/^(?i)[0-9_]*$/", $_GET['page'])) { $pageNum = '1'; }
// пресмятаме отместването
$offset = ($pageNum - 1) * $rowsPerPage;
// тук трябва да напишеш своята заявка
$chars="set character set latin1";
mysql_query($chars);
{
$broq = 10;
$query = mysql_query("SELECT * FROM servers WHERE ok='1' ORDER BY id DESC LIMIT $broq");
echo "<b><font color='green' size='3'>Последните 10 сървъри добавени от потребителите:<br><br></font></b>";
while ($row = mysql_fetch_array($query))
{
$ip1 = $row['ip'];
$port1 = $row['port'];
$output = @fsockopen("udp://$ip1", $port1, $errno, $errstr, 0.25);
@socket_set_timeout($output, 1);
@socket_set_blocking($output, 1);
@fwrite($output, "\xFF\xFF\xFF\xFF\x54\x53\x6F\x75\x72\x63\x65\x20\x45\x6E\x67\x69\x6E\x65\x20\x51\x75\x65\x72\x79\x00");
$buffer = @fread($output, 4096);
if (!$buffer) {
$on = "<font color=\"red\">offline</font>";
} else {
$on = "<font color=\"green\">online</font>";
}
echo '№: <b> '.$row['id'].' </b>';
echo '<table border="1" width="500" align="center"><tr><td width="40">';
echo 'Име:</td><td align="center"><b> '.$row['name'].' </b></td><td width="40">Инф:</td><td align="center"><b> '.$on.' </b></td><tr><td width="40">';
echo 'Ип:</td><td align="center"> <b> '.$row['ip'].':'.$row['port'].' </b></td><td width="40">';
echo 'От:<td align="center"> <b> <a href="index.php?p=profile&username='.$row['author'].'">'.$row['author'].' </b></td></table>';
}
}
// колко реда общо имаме ?
$query1 = "SELECT COUNT(id) AS numrows FROM servers";
$result = mysql_query($query1) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$num = $row['numrows']; // броя на редовете
$start = ($pageNum -1) * $rowsPerPage;
if(empty($start))$start=0; // текуща стартова позиция
$max_pages = ceil($num/$rowsPerPage); // брой на страниците
$cur = ceil($start/$rowsPerPage)+1; // текуща страница
?>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="middle">
<?php
if(($start-$rowsPerPage) >= 0)
{
$next = $cur - 1;
?>
<a class="page" href="<?php print("$thispage?m=softwares&page=1");?>">Първа</a>
<a class="page" href="<?php print("$thispage".($next>0?("?m=softwares&page=").$next:""));?>">Назад</a>
<?php
}
?>
</td>
<td align="center" valign="middle">
<table>
<tr>
<td colspan="3" align="center" valign="middle">
<?php
$eitherside = ($showeachside * $rowsPerPage);
if($start+1 > $eitherside)print (" .... ");
$pg=1;
for($y=0;$y<$num;$y+=$rowsPerPage)
{
$class=(($y==$start)?"active":"")."page";
if(($y > ($start - $eitherside)) && ($y < ($start + $eitherside)))
{
if ($y <> $start) {
?>
<a class="<?php print($class);?>" href="<?php print("$thispage"."?m=softwares&page=".(($y/$rowsPerPage)+1));?>"><?php print($pg);?></a>
<?php
} else {
?>
<a class="<?php print($class);?>"><?php print($pg);?></a>
<?php
}
}
$pg++;
}
if(($start+$eitherside)<$num)print (" .... ");
?>
</td>
</tr>
</table>
</td>
<td align="center" valign="middle">
<?php
if (($start+$rowsPerPage) < $num)
{
$next = $cur + 1;
?>
<a class="page" href="<?php print("$thispage?m=softwares&page=".$next);?>">Напред</a>
<a class="page" href="<?php print("$thispage?m=softwares&page=$max_pages");?>">Последна</a>
<?php
}
?>
</td>
