From 9f55edf4613c17e879f31a2953954dd4db4d97d1 Mon Sep 17 00:00:00 2001 From: hugetoad Date: Fri, 10 Jun 2005 07:36:21 +0000 Subject: Minor changes. git-svn-id: svn://svn.zabbix.com/trunk@1856 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- src/zabbix_server/functions.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/zabbix_server/functions.c') 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); -- cgit