diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2004-03-01 20:06:33 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2004-03-01 20:06:33 +0000 |
| commit | 6a62afc6086c67289800a630db39641055f6ec18 (patch) | |
| tree | c8c065f2b1d9ed45fc81ee0409f70749167cbb6f /frontends/php/include | |
| parent | d615d860953ae5441efd8292c9b8c6520ab87f5a (diff) | |
| download | zabbix-6a62afc6086c67289800a630db39641055f6ec18.tar.gz zabbix-6a62afc6086c67289800a630db39641055f6ec18.tar.xz zabbix-6a62afc6086c67289800a630db39641055f6ec18.zip | |
- fixed sql statement in trigger definition form (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@1280 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/include')
| -rw-r--r-- | frontends/php/include/config.inc.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/frontends/php/include/config.inc.php b/frontends/php/include/config.inc.php index 84e6b3d2..cee691d6 100644 --- a/frontends/php/include/config.inc.php +++ b/frontends/php/include/config.inc.php @@ -196,7 +196,7 @@ $result=DBselect($sql); while($row=DBfetch($result)) { - $sql="select count(*) as cnt from actions a,hosts h,items i,triggers t,functions f where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and a.triggerid=".$row["hostid"]." and a.scope=1 and t.triggerid"; + $sql="select count(*) as cnt from actions a,hosts h,items i,triggers t,functions f where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and a.triggerid=".$row["hostid"]." and a.scope=1"; $result2=DBselect($sql); $row2=DBfetch($result2); $cnt=$cnt+$row2["cnt"]; |