- added support for zabbix[triggers_count] (Alexei)

git-svn-id: svn://svn.zabbix.com/trunk@795 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 26 insertions, 0 deletions

diff --git a/include/db.c b/include/db.c
index 72c6f9ec..e31225f2 100644
--- a/include/db.c
+++ b/include/db.c
@@ -702,6 +702,32 @@ int	DBget_items_count(void)
 	return res;
 }
 
+int	DBget_triggers_count(void)
+{
+	int	res;
+	char	sql[MAX_STRING_LEN+1];
+	DB_RESULT	*result;
+
+	zabbix_log(LOG_LEVEL_DEBUG,"In DBget_triggers_count()");
+
+	sprintf(sql,"select count(*) from triggers");
+
+	result=DBselect(sql);
+
+	if(DBnum_rows(result) == 0)
+	{
+		zabbix_log(LOG_LEVEL_ERR, "Cannot execute query [%s]", sql);
+		DBfree_result(result);
+		return 0;
+	}
+
+	res  = atoi(DBget_field(result,0,0));
+
+	DBfree_result(result);
+
+	return res;
+}
+
 int	DBget_items_unsupported_count(void)
 {
 	int	res;