- fixed events.triggerid requests

git-svn-id: svn://svn.zabbix.com/trunk@3896 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 2 insertions, 2 deletions

diff --git a/frontends/php/report5.php b/frontends/php/report5.php
index 75da6155..c27e506a 100644
--- a/frontends/php/report5.php
+++ b/frontends/php/report5.php
@@ -69,8 +69,8 @@ include_once "include/page_header.php";
         $result=DBselect("select h.host, t.triggerid, t.description, t.priority, count(distinct e.eventid) as count ".
 		" from hosts h, triggers t, functions f, items i, events e where ".
 		" h.hostid = i.hostid and i.itemid = f.itemid and t.triggerid=f.triggerid and ".
-		" t.triggerid=e.triggerid and e.clock>".(time()-$time_dif).
-		" and h.hostid in (".$accessible_hosts.") and ".DBid2nodeid("e.triggerid")."=".$ZBX_CURNODEID.
+		' t.triggerid=e.objectid and e.object='.EVENT_OBJECT_TRIGGER.' and e.clock>'.(time()-$time_dif).
+		" and h.hostid in (".$accessible_hosts.") and ".DBid2nodeid("t.triggerid")."=".$ZBX_CURNODEID.
 		" group by h.host,t.triggerid,t.description,t.priority ".
 		" order by count desc, h.host, t.description, t.triggerid", 100);