From 3fa60cc03b6abbeeb4cd0342df8d6f672b3e2b6d Mon Sep 17 00:00:00 2001 From: sasha Date: Tue, 11 Mar 2008 20:17:42 +0000 Subject: - [DEV-108] GUI git-svn-id: svn://svn.zabbix.com/trunk@5475 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- frontends/php/httpconf.php | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'frontends/php/httpconf.php') 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"; } -- cgit