diff options
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. |