Count of triggers is wrong

[cristhiano]

In Repports->Status of Zabbix, the number of triggers is wrong. This is a patch.

--- include/config.inc.php.orig 2008-01-16 11:44:17.452486507 -0200
+++ include/config.inc.php 2008-01-16 11:44:38.713815258 -0200
@@ -1101,7 +1101,7 @@
$row=DBfetch(DBselect("select count(alertid) as cnt from alerts"));
$status["alerts_count"]=$row["cnt"];
// triggers
- $sql = "select count(t.triggerid) as cnt from triggers t, functions f, items i, hosts h".
+ $sql = "select count(distinct t.triggerid) as cnt from triggers t, functions f, items i, hosts h".
" where t.triggerid=f.triggerid and f.itemid=i.itemid and i.status=0 and i.hostid=h.hostid and h.status=".HOST_STATUS_MONITORED;
$row=DBfetch(DBselect($sql));
$status["triggers_count"]=$row["cnt"];