- [DEV-108] GUI

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

1 files changed, 9 insertions, 7 deletions

diff --git a/frontends/php/items.php b/frontends/php/items.php
index 8f76da79..23d2b408 100644
--- a/frontends/php/items.php
+++ b/frontends/php/items.php
@@ -682,16 +682,18 @@ include_once "include/page_header.php";
 
 			if(isset($_REQUEST["groupid"]) && $_REQUEST["groupid"]>0)
 			{
-				$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.hostid in (".$accessible_hosts.") ".
-					" and h.status<>".HOST_STATUS_DELETED." group by h.hostid,h.host order by h.host";
+				$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.') '.
+					' 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.") ".
-					" group by h.hostid,h.host order by h.host";
+				$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';
 			}
 
 			$result=DBselect($sql);