diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-12-13 17:03:16 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-12-13 17:03:16 +0000 |
| commit | bd12c64ebebe48a35bd6be7ca4371c0fe1380d90 (patch) | |
| tree | 4adcd8115b37b97874ea07be26a9de2cd1aaf921 /frontends/php | |
| parent | 4357e5de4f5a411f4e9adb71f0f6a78d18b47281 (diff) | |
| download | zabbix-bd12c64ebebe48a35bd6be7ca4371c0fe1380d90.tar.gz zabbix-bd12c64ebebe48a35bd6be7ca4371c0fe1380d90.tar.xz zabbix-bd12c64ebebe48a35bd6be7ca4371c0fe1380d90.zip | |
- modified SQL statement in tr_status.html. Thanks to Oliver Siegmar. (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@262 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php')
| -rw-r--r-- | frontends/php/report2.html | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/frontends/php/report2.html b/frontends/php/report2.html index 6582199e..57c247e2 100644 --- a/frontends/php/report2.html +++ b/frontends/php/report2.html @@ -26,7 +26,8 @@ <? - $result=DBselect("select h.hostid,h.host,t.triggerid,t.expression,t.description,t.istrue from triggers t,hosts h,items i,functions f where f.itemid=i.itemid and h.hostid=i.hostid and t.istrue!=2 and t.triggerid=f.triggerid and h.status=0 order by h.host,t.description"); + $result=DBselect("select h.hostid,h.host,t.triggerid,t.expression,t.description,t.istrue from triggers t,hosts h,items i,functions f where f.itemid=i.itemid and h.hostid=i.hostid and t.istrue!=2 and t.triggerid=f.triggerid and h.status=0 and i.status=0 and h.status=0 order by h.host,t.lastchange desc, t.description"); + $lasthost=""; $col=0; for($i=0;$i<DBnum_rows($result);$i++) |