diff options
Diffstat (limited to 'frontends/php/httpconf.php')
| -rw-r--r-- | frontends/php/httpconf.php | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/frontends/php/httpconf.php b/frontends/php/httpconf.php index b116ba65..da39a8a3 100644 --- a/frontends/php/httpconf.php +++ b/frontends/php/httpconf.php @@ -377,13 +377,15 @@ include_once "include/page_header.php"; { $sql="select distinct h.hostid,h.host from hosts h,hosts_groups hg". " where hg.groupid=".$_REQUEST["groupid"]." and hg.hostid=h.hostid ". + ' and h.status in ('.HOST_STATUS_MONITORED.','.HOST_STATUS_NOT_MONITORED.','.HOST_STATUS_TEMPLATE.')'. " and h.hostid in (".$accessible_hosts.") ". - " and h.status<>".HOST_STATUS_DELETED." group by h.hostid,h.host order by h.host"; + " group by h.hostid,h.host order by h.host"; } else { - $sql="select distinct h.hostid,h.host from hosts h where h.status<>".HOST_STATUS_DELETED. - " and h.hostid in (".$accessible_hosts.") ". + $sql="select distinct h.hostid,h.host from hosts h". + ' where h.status in ('.HOST_STATUS_MONITORED.','.HOST_STATUS_NOT_MONITORED.','.HOST_STATUS_TEMPLATE.')'. + " and h.hostid in (".$accessible_hosts.")". " group by h.hostid,h.host order by h.host"; } |