diff options
Diffstat (limited to 'frontends/php/include/maps.inc.php')
| -rw-r--r-- | frontends/php/include/maps.inc.php | 15 |
1 files changed, 8 insertions, 7 deletions
diff --git a/frontends/php/include/maps.inc.php b/frontends/php/include/maps.inc.php index 8b57a225..4c65dfa2 100644 --- a/frontends/php/include/maps.inc.php +++ b/frontends/php/include/maps.inc.php @@ -105,18 +105,19 @@ break; case SYSMAP_ELEMENT_TYPE_TRIGGER: if( DBfetch(DBselect('select triggerid from triggers where triggerid='.$se_data['elementid'])) && - !DBfetch(DBselect("select distinct t.*". - " from triggers t,items i,functions f". - " where f.itemid=i.itemid and t.triggerid=f.triggerid". - " and i.hostid not in (".$denyed_hosts.") and t.triggerid=".$se_data['elementid']))) + !DBfetch(DBselect('SELECT DISTINCT t.*'. + ' FROM triggers t,items i,functions f'. + ' WHERE f.itemid=i.itemid '. + ' AND t.triggerid=f.triggerid'. + ' AND i.hostid NOT IN ('.$denyed_hosts.') '. + ' AND t.triggerid='.$se_data['elementid']))) { $result = false; } break; case SYSMAP_ELEMENT_TYPE_HOST_GROUP: - if( DBfetch(DBselect('select groupid from groups where groupid='.$se_data['elementid'])) && - uint_in_array($se_data['elementid'], - get_accessible_groups_by_user($USER_DETAILS,PERM_READ_ONLY, PERM_MODE_LT, PERM_RES_IDS_ARRAY))) + if( DBfetch(DBselect('SELECT groupid FROM groups WHERE groupid='.$se_data['elementid'])) && + uint_in_array($se_data['elementid'],get_accessible_groups_by_user($USER_DETAILS,PERM_READ_ONLY, PERM_MODE_LT, PERM_RES_IDS_ARRAY))) { $result = false; } |