Added eDBget_blacklisted_ip(ctx) functions into db drivers

1 files changed, 22 insertions, 0 deletions

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;
+}