diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2002-06-07 05:32:20 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2002-06-07 05:32:20 +0000 |
| commit | be6ecd4b2eded404857a6362be332c0511f98e84 (patch) | |
| tree | bda2c8d3a825a33e3f0d2b39da72a1b5ea544a14 /frontends/php/map.php | |
| parent | e634892574f442d37c5c6928d013b70d6c05826f (diff) | |
| download | zabbix-be6ecd4b2eded404857a6362be332c0511f98e84.tar.gz zabbix-be6ecd4b2eded404857a6362be332c0511f98e84.tar.xz zabbix-be6ecd4b2eded404857a6362be332c0511f98e84.zip | |
Fixed sysmap.
git-svn-id: svn://svn.zabbix.com/trunk@405 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/map.php')
| -rw-r--r-- | frontends/php/map.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/frontends/php/map.php b/frontends/php/map.php index 87e72fbf..edb41eeb 100644 --- a/frontends/php/map.php +++ b/frontends/php/map.php @@ -111,12 +111,12 @@ } else { - $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 in (0,2) and i.status=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.value=1 and t.status=0 and h.status in (0,2) and i.status=0"); $count=DBget_field($result1,0,0); if($count==1) { $color=$red; - $result1=DBselect("select t.description 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 in (0,2) and i.status=0"); + $result1=DBselect("select t.description 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.value=1 and t.status=0 and h.status in (0,2) and i.status=0"); $label=DBget_field($result1,0,0); } else if($count>1) |
