как да изкарам от този код само сървърите които са онлайн
Код:<?PHP if(!DEFINED('human')) die('<code>PERMISSION DENIDED!</code>'); ?> <table cellpadding="0" cellspacing="0" style="border: #000000 1px solid;padding-left: 3px;width:100%" class="title"> <?php $onpage = 8; 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';} $db->zaqvka("SELECT * FROM `servers`, `cats` where `servers`.`cid`=`cats`.`cid` and od='1' $sql"); $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><td height=\"20\">Сървър</td><td>Тип</td><td>Играчи</td><td>Карта</td><td>Статус</td></tr>"; $m = 1; while($r=$db->rezultati()){ if($m==1){ $color = '#FFFFFF'; $tcolor = '#000000'; $m=2; } else{ $color = '#F3F3F3'; $tcolor = '#000000'; $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=\"border: #cccccc 1px solid;background: $color;\"><a href=\"index.php?module=server&servid=$r[sid]\"><span style=\"color:$tcolor\">$r[0]<br>$r[ip]:$r[port]</span></a></td><td style=\"border: #cccccc 1px solid;background: $color;\"><a href=\"index.php?module=servers&cid=$r[cid]\"><span style=\"color:$tcolor\">$r[ime]</span></a></td><td style=\"border: #cccccc 1px solid;background: $color;\">$players</td><td style=\"border: #cccccc 1px solid;background: $color;\">$karta</td><td style=\"border: #cccccc 1px solid;background: $color;\">$status</td></tr>"; } } $nav = stranici('index.php?module=servers&page=', $onpage, 10, $br, $page, '&cid='.$_GET[cid]); ?> </table> <br><center><?=$nav?></center>