diff options
| author | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-05-19 07:35:06 +0000 |
|---|---|---|
| committer | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-05-19 07:35:06 +0000 |
| commit | 5ea1687a67685fe34875967075bbd422b2d0137a (patch) | |
| tree | 155b8770576ed940325eaee49a9d8373406020b3 /frontends/php/include/triggers.inc.php | |
| parent | 50e982514eb5eb2b27af48658ad4375dbd443b84 (diff) | |
| download | zabbix-5ea1687a67685fe34875967075bbd422b2d0137a.tar.gz zabbix-5ea1687a67685fe34875967075bbd422b2d0137a.tar.xz zabbix-5ea1687a67685fe34875967075bbd422b2d0137a.zip | |
-[DEV-137] fixes for oracle (Artem)
-[HAN-4] selects first host-group in overview screen (Artem)
git-svn-id: svn://svn.zabbix.com/trunk@5707 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/include/triggers.inc.php')
| -rw-r--r-- | frontends/php/include/triggers.inc.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/frontends/php/include/triggers.inc.php b/frontends/php/include/triggers.inc.php index fc6933e4..ca83022e 100644 --- a/frontends/php/include/triggers.inc.php +++ b/frontends/php/include/triggers.inc.php @@ -203,7 +203,7 @@ $available_graphs = array(); $sql = 'SELECT DISTINCT t.triggerid '. - ' FROM triggers t, functions f, items as i '. + ' FROM triggers t, functions f, items i '. ' WHERE t.triggerid=f.triggerid '. ' AND f.itemid=i.itemid'. (!empty($hostid)?' AND i.hostid='.$hostid:''). @@ -215,7 +215,7 @@ } $sql = 'SELECT DISTINCT t.triggerid '. - ' FROM triggers t, functions f, items as i '. + ' FROM triggers t, functions f, items i '. ' WHERE t.triggerid=f.triggerid '. ' AND f.itemid=i.itemid'. ' AND i.status='.ITEM_STATUS_ACTIVE. |