From 469d17e7d448ec1833abb72add88d1d1f61c4a06 Mon Sep 17 00:00:00 2001 From: artem Date: Wed, 20 Aug 2008 14:46:11 +0000 Subject: - [DEV-199] performance improvements of js scripts in hosts screen (Artem) - [DEV-137] many small fixes (Artem) git-svn-id: svn://svn.zabbix.com/trunk@5932 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- frontends/php/overview.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'frontends/php/overview.php') diff --git a/frontends/php/overview.php b/frontends/php/overview.php index 0ff603cb..c3d8f2a2 100644 --- a/frontends/php/overview.php +++ b/frontends/php/overview.php @@ -97,9 +97,11 @@ if(isset($_REQUEST['select']) && ($_REQUEST['select']!='')){ $where = $from = ''; } + $available_groups = get_accessible_groups_by_user($USER_DETAILS,PERM_READ_LIST); + $result=DBselect('SELECT DISTINCT g.groupid,g.name '. ' FROM groups g, hosts_groups hg, hosts h, items i'.$from. - ' WHERE g.groupid IN ('.get_accessible_groups_by_user($USER_DETAILS,PERM_READ_LIST).') '. + ' WHERE '.DBcondition('g.groupid',$available_groups). ' AND hg.groupid=g.groupid '. ' AND h.status='.HOST_STATUS_MONITORED. ' AND h.hostid=i.hostid '. -- cgit