From 2369f5eb8cc2863167f4f3aed99dd0bee2a803a5 Mon Sep 17 00:00:00 2001 From: David Sommerseth Date: Sat, 1 Nov 2008 13:45:46 +0100 Subject: Added eDBget_blacklisted_ip(ctx) functions into db drivers --- database/sqlite/eurephiadb-sqlite.c | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) (limited to 'database/sqlite/eurephiadb-sqlite.c') diff --git a/database/sqlite/eurephiadb-sqlite.c b/database/sqlite/eurephiadb-sqlite.c index 644815f..4bc61f4 100644 --- a/database/sqlite/eurephiadb-sqlite.c +++ b/database/sqlite/eurephiadb-sqlite.c @@ -873,3 +873,25 @@ char *eDBget_firewall_profile(eurephiaCTX *ctx, eurephiaSESSION *session) sqlite_free_results(res); return ret; } + +eurephiaVALUES *eDBget_blacklisted_ip(eurephiaCTX *ctx) { + eurephiaVALUES *ret = NULL; + dbresult *res = NULL; + int i = 0; + + DEBUG(ctx, 20, "Function call: eDBget_blacklisted_ip(ctx)"); + + res = sqlite_query(ctx, "SELECT remoteip FROM openvpn_blacklist"); + if( res == NULL ) { + eurephia_log(ctx, LOG_FATAL, 0, + "Could not retrieve blacklisted IP addresses from the database"); + return NULL; + } + ret = eCreate_value_space(ctx, 21); + for( i = 0; i < sqlite_get_numtuples(res); i++ ) { + eAdd_value(ctx, ret, sqlite_get_value(res, i, 0), NULL); + } + sqlite_free_results(res); + + return ret; +} -- cgit