Kато щракна на някоя страница показва вече други резултатите,но номерацията седи една и съща от 1 до 20 а не пордължава да се увеличава 21,22,23.. с всяка сменена страница.
Код:
<?PHP if(!DEFINED('human')) die('<code>PERMISSION DENIDED!</code>'); ?>
<table cellpadding="0" cellspacing="0" 1px solid;padding-left: 3px;width:100%" class="title">
<?php
$onpage = 20;
$i = 0;
if(is_numeric($_GET[cid])){
$sql = " and `servers`.`cid`='$_GET[cid]'";
}
else {
$sql='';
}
if(is_numeric($_GET['page']) and $_GET['page']>0 ) {$page=$_GET['page'];}else{$page=0;}
$query = "SELECT * from `servers`,`cats` where `servers`.`cid` = `cats`.`cid` and od='1' {$sql}";
$db->zaqvka($query);
$br = $db->broi();
$lm1 = $page * $onpage;
$db->zaqvka("SELECT * from `servers`,`cats` where `servers`.`cid` = `cats`.`cid` and od='1' $sql order by servers.sid desc limit {$lm1},{$onpage}");
if($db->broi()==0){
echo "<tr><td>Няма сървъри</tr><td>";
}
else {
echo "<tr><b><td><td height=\"20\">№ Сървъри</td><td style=\"border: #222222 1px solid;background: $color;\"></td><td style=\"border: #222222 1px solid;background: $color;\"></td><td style=\"border: #222222 1px solid;background: $color;\"></td><td style=\"border: #222222 1px solid;background: $color;\"></td><td><td>Мод</td><td>Играчи</td><td>Карта</td><td>IP адрес</td><td style=\"border: #222222 1px solid;background: $color;\"></td><td>Статус</td></b></tr>";
$m = 1;
while($r=$db->rezultati()){
$i++;
if($m==1){
$color = '#222222';
$tcolor = '#FFFFFF';
$m=2;
}
else{
$color = '#222222';
$tcolor = '#FFFFFF';
$m=1;
}
//$st = query($r[ip],$r[port],'status');
$sinfo = query($r[ip], $r[port], 'info');
if($sinfo){$status = '<font color="green">Online</font>';}else{$status = '<font color="red">Offline</font';}
$ime = $r[ime];
$karta = isset($sinfo[mapname]) ? $sinfo[mapname] : 'N/A';
$sinfo[players] = isset($sinfo[players]) ? $sinfo[players] : 0;
$sinfo[maxplayers] = isset($sinfo[maxplayers]) ? $sinfo[maxplayers] : 0;
$players = $sinfo[players].'/'.$sinfo[maxplayers];
$r[ip]=gethostbyname($r[ip]);
echo "<tr><td style='white-space:nowrap; text-align:left'>
<img alt='' src='images/cstrike.gif' />
</td><td style=\"border: #222222 1px solid;background: $color;\"><a href=\"servers.php?module=server&servid=$r[sid]\"><span style=\"color:$tcolor\">$i. $r[0]</span></a></td><td style=\"border: #222222 1px solid;background: $color;\"></td><td style=\"border: #222222 1px solid;background: $color;\"></td><td style=\"border: #222222 1px solid;background: $color;\"></td><td style=\"border: #222222 1px solid;background: $color;\"></td><td style=\"border: #222222 1px solid;background: $color;\"></td><td style=\"border: #222222 1px solid;background: $color;\"><a href=\"servers.php?module=servers&cid=$r[cid]\"><span style=\"color:$tcolor\">$r[ime]</span></a></td><td style=\"border: #222222 1px solid;background: $color;\">$players</td><td style=\"border: #222222 1px solid;background: $color;\">$karta</td><td style=\"border: #222222 1px solid;background: $color;\">$r[ip]:$r[port]</td><td style=\"border: #222222 1px solid;background: $color;\"></td><td style=\"border: #222222 1px solid;background: $color;\">$status</td></tr>";
}
}
$nav = stranici('servers.php?module=servers&page=', $onpage, 10, $br, $page, '&cid='.$_GET[cid]);
?>
</table>
<br><center><?=$nav?></center>