diff options
| author | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-04-01 09:07:31 +0000 |
|---|---|---|
| committer | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-04-01 09:07:31 +0000 |
| commit | 03e678c45527d1f317671a2ea28fc263fd02fd13 (patch) | |
| tree | c345a19603df24ea0661f3d4dced278dd0aabb88 /frontends/php/report3.php | |
| parent | 53988b911a9c89465dce8b694177e090fc737a91 (diff) | |
| download | zabbix-03e678c45527d1f317671a2ea28fc263fd02fd13.tar.gz zabbix-03e678c45527d1f317671a2ea28fc263fd02fd13.tar.xz zabbix-03e678c45527d1f317671a2ea28fc263fd02fd13.zip | |
- fixes to services calculation algorithms (Artem)
git-svn-id: svn://svn.zabbix.com/trunk@5570 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/report3.php')
| -rw-r--r-- | frontends/php/report3.php | 13 |
1 files changed, 8 insertions, 5 deletions
diff --git a/frontends/php/report3.php b/frontends/php/report3.php index 118a6f04..660dfeab 100644 --- a/frontends/php/report3.php +++ b/frontends/php/report3.php @@ -52,11 +52,14 @@ include_once "include/page_header.php"; $denyed_hosts = get_accessible_hosts_by_user($USER_DETAILS,PERM_READ_ONLY,PERM_MODE_LT); - if( !($service = DBfetch(DBselect("select s.* from services s left join triggers t on s.triggerid=t.triggerid ". - " left join functions f on t.triggerid=f.triggerid left join items i on f.itemid=i.itemid ". - " where (i.hostid is NULL or i.hostid not in (".$denyed_hosts.")) ". - ' and '.DBin_node('s.serviceid'). - " and s.serviceid=".$_REQUEST["serviceid"] + if( !($service = DBfetch(DBselect('SELECT s.* '. + ' FROM services s '. + ' LEFT JOIN triggers t on s.triggerid=t.triggerid '. + ' LEFT JOIN functions f on t.triggerid=f.triggerid '. + ' LEFT JOIN items i on f.itemid=i.itemid '. + ' WHERE (i.hostid is NULL or i.hostid not in ('.$denyed_hosts.')) '. + ' AND '.DBin_node('s.serviceid'). + ' AND s.serviceid='.$_REQUEST['serviceid'] )))) { access_deny(); |