From f57194822d652d39ca2329f7ff09a04cabcad3db Mon Sep 17 00:00:00 2001 From: hugetoad Date: Tue, 26 Jun 2001 15:14:06 +0000 Subject: Fixed SQL statement in map.html. git-svn-id: svn://svn.zabbix.com/trunk@110 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- frontends/php/map.html | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'frontends/php/map.html') diff --git a/frontends/php/map.html b/frontends/php/map.html index 35354041..c6f8fedf 100644 --- a/frontends/php/map.html +++ b/frontends/php/map.html @@ -101,8 +101,8 @@ } else { - $result1=DBselect("select count(*) from items i,functions f,triggers t where i.hostid=$hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.iistrue=1 and h.status=0"); - $count=DBget_field($result,0,0); + $result1=DBselect("select count(*) from items i,functions f,triggers t,hosts h where h.hostid=i.hostid and i.hostid=$hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and t.istrue=1 and h.status=0"); + $count=DBget_field($result1,0,0); if($count>0) { $color=$red; -- cgit