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/items.php | 16 +++++++++------- 1 file changed, 9 insertions(+), 7 deletions(-) (limited to 'frontends/php/items.php') 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); -- cgit