diff options
Diffstat (limited to 'frontends/php/map.html')
| -rw-r--r-- | frontends/php/map.html | 4 |
1 files changed, 2 insertions, 2 deletions
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; |