From c244e9d27f34ec314090dc14befca5eba3911ba0 Mon Sep 17 00:00:00 2001
From: artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082>
Date: Wed, 23 Apr 2008 16:11:28 +0000
Subject:  - [DEV-137] minor fix (Artem)

git-svn-id: svn://svn.zabbix.com/trunk@5651 97f52cf1-0a1b-0410-bd0e-c28be96e8082
---
 frontends/php/chart5.php | 26 +++++---------------------
 1 file changed, 5 insertions(+), 21 deletions(-)

(limited to 'frontends/php/chart5.php')

diff --git a/frontends/php/chart5.php b/frontends/php/chart5.php
index 490eeadc..26d21eab 100644
--- a/frontends/php/chart5.php
+++ b/frontends/php/chart5.php
@@ -42,30 +42,14 @@ include_once "include/page_header.php";
 		fatal_error(S_NO_IT_SERVICE_DEFINED);
 	}
 
-	$available_hosts = get_accessible_hosts_by_user($USER_DETAILS, PERM_READ_ONLY);
+	$available_triggers = get_accessible_triggers(PERM_READ_ONLY, PERM_RES_IDS_ARRAY);
 	
 	$sql = 'SELECT s.serviceid '.
-			' FROM services s, triggers t, functions f, items i '.
-			' WHERE s.serviceid='.$_REQUEST['serviceid'].
-				' AND t.triggerid=s.triggerid '.
-				' AND f.triggerid=t.triggerid '.
-				' AND i.itemid=f.itemid	'.
-				' AND i.hostid NOT IN ('.$available_hosts.')';
-
-	if(DBfetch(DBselect($sql,1))){
-		access_deny();
-	}
+				' FROM services s '.
+				' WHERE (s.triggerid is NULL OR '.DBcondition('s.triggerid',$available_triggers).') '.
+					' AND s.serviceid='.$_REQUEST['serviceid'];
 
-	
-	$sql = '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 s.serviceid='.$_REQUEST['serviceid'].
-				' AND i.hostid IN ('.$available_hosts.')';
-		
-	if(!$service = DBfetch(DBselect($sql))){
+	if(!$service = DBfetch(DBselect($sql,1))){
 		access_deny();
 	}
 ?>
-- 
cgit