diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-06-26 15:14:06 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-06-26 15:14:06 +0000 |
| commit | f57194822d652d39ca2329f7ff09a04cabcad3db (patch) | |
| tree | 5126a675c097c8dd9193ece0d7a61a1bc79f9327 /frontends/php | |
| parent | 89f0cbe8d14318c684f08fb125d1f7df4c0ba329 (diff) | |
| download | zabbix-f57194822d652d39ca2329f7ff09a04cabcad3db.tar.gz zabbix-f57194822d652d39ca2329f7ff09a04cabcad3db.tar.xz zabbix-f57194822d652d39ca2329f7ff09a04cabcad3db.zip | |
Fixed SQL statement in map.html.
git-svn-id: svn://svn.zabbix.com/trunk@110 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php')
| -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; |