diff options
| author | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-08-20 14:46:11 +0000 |
|---|---|---|
| committer | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-08-20 14:46:11 +0000 |
| commit | 469d17e7d448ec1833abb72add88d1d1f61c4a06 (patch) | |
| tree | 4a21e42405a82385c87981d5f2199e388a964272 /frontends/php/include/screens.inc.php | |
| parent | 155fa1457186f7ffa453ba7bf68ae0c22387746b (diff) | |
| download | zabbix-master.tar.gz zabbix-master.tar.xz zabbix-master.zip | |
- [DEV-137] many small fixes (Artem)
git-svn-id: svn://svn.zabbix.com/trunk@5932 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/include/screens.inc.php')
| -rw-r--r-- | frontends/php/include/screens.inc.php | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/frontends/php/include/screens.inc.php b/frontends/php/include/screens.inc.php index af018a4a..7df7ec0b 100644 --- a/frontends/php/include/screens.inc.php +++ b/frontends/php/include/screens.inc.php @@ -622,10 +622,11 @@ $id=0; if($resourceid > 0){ + $available_groups = get_accessible_groups_by_user($USER_DETAILS,PERM_READ_ONLY); $result=DBselect('SELECT DISTINCT n.name as node_name,g.groupid,g.name '. ' FROM hosts_groups hg,hosts h,groups g '. ' LEFT JOIN nodes n ON n.nodeid='.DBid2nodeid('g.groupid'). - ' WHERE g.groupid IN ('.get_accessible_groups_by_user($USER_DETAILS,PERM_READ_ONLY).')'. + ' WHERE '.DBcondition('g.groupid',$available_groups). ' AND g.groupid=hg.groupid '. ' AND hg.hostid=h.hostid '. ' AND h.status='.HOST_STATUS_MONITORED. @@ -681,11 +682,12 @@ $caption = ''; $id=0; + $available_groups = get_accessible_groups_by_user($USER_DETAILS,PERM_READ_ONLY); if(remove_nodes_from_id($resourceid) > 0){ $result=DBselect('SELECT DISTINCT n.name as node_name,g.groupid,g.name '. ' FROM hosts_groups hg, groups g '. ' LEFT JOIN nodes n ON n.nodeid='.DBid2nodeid('g.groupid'). - ' WHERE g.groupid in ('.get_accessible_groups_by_user($USER_DETAILS,PERM_READ_ONLY).')'. + ' WHERE '.DBcondition('g.groupid',$available_groups). ' AND g.groupid='.$resourceid); while($row=DBfetch($result)){ |