summaryrefslogtreecommitdiffstats
path: root/src/zabbix_server/functions.c
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2005-06-10 07:36:21 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2005-06-10 07:36:21 +0000
commit9f55edf4613c17e879f31a2953954dd4db4d97d1 (patch)
treedf918bc88e71f19329a9de863124151c3f9e7a4a /src/zabbix_server/functions.c
parent19db79e2c994fb300ac80352f7b93a1733c44d23 (diff)
downloadzabbix-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.c2
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);