diff options
author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-06-10 07:36:21 +0000 |
---|---|---|
committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-06-10 07:36:21 +0000 |
commit | 9f55edf4613c17e879f31a2953954dd4db4d97d1 (patch) | |
tree | df918bc88e71f19329a9de863124151c3f9e7a4a /src/zabbix_server/functions.c | |
parent | 19db79e2c994fb300ac80352f7b93a1733c44d23 (diff) | |
download | zabbix-9f55edf4613c17e879f31a2953954dd4db4d97d1.tar.gz zabbix-9f55edf4613c17e879f31a2953954dd4db4d97d1.tar.xz zabbix-9f55edf4613c17e879f31a2953954dd4db4d97d1.zip |
Minor changes.
git-svn-id: svn://svn.zabbix.com/trunk@1856 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'src/zabbix_server/functions.c')
-rw-r--r-- | src/zabbix_server/functions.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/zabbix_server/functions.c b/src/zabbix_server/functions.c index fa6862a9..2b202896 100644 --- a/src/zabbix_server/functions.c +++ b/src/zabbix_server/functions.c @@ -745,7 +745,7 @@ void update_triggers(int itemid) zabbix_log( LOG_LEVEL_DEBUG, "In update_triggers [%d]", itemid); /* Does not work for PostgreSQL */ -/* sprintf(sql,"select t.triggerid,t.expression,t.status,t.dep_level,t.priority,t.value from triggers t,functions f,items i where i.status<>3 and i.itemid=f.itemid and t.status=%d and f.triggerid=t.triggerid and f.itemid=%d group by t.triggerid,t.expression,t.dep_level",TRIGGER_STATUS_ENABLED,sucker_num);*/ +/* sprintf(sql,"select t.triggerid,t.expression,t.status,t.dep_level,t.priority,t.value from triggers t,functions f,items i where i.status<>3 and i.itemid=f.itemid and t.status=%d and f.triggerid=t.triggerid and f.itemid=%d group by t.triggerid,t.expression,t.dep_level",TRIGGER_STATUS_ENABLED,server_num);*/ /* Is it correct SQL? */ snprintf(sql,sizeof(sql)-1,"select distinct t.triggerid,t.expression,t.status,t.dep_level,t.priority,t.value,t.description from triggers t,functions f,items i where i.status<>%d and i.itemid=f.itemid and t.status=%d and f.triggerid=t.triggerid and f.itemid=%d",ITEM_STATUS_NOTSUPPORTED, TRIGGER_STATUS_ENABLED, itemid); |