- [DEV-108] GUI

git-svn-id: svn://svn.zabbix.com/trunk@5475 97f52cf1-0a1b-0410-bd0e-c28be96e8082

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";
 		}