From 5ec4729e5eeed077b77031ac4e74644d67882d37 Mon Sep 17 00:00:00 2001 From: David Sommerseth Date: Sat, 1 Nov 2008 13:58:58 +0100 Subject: Fixed missing WHERE clause in SQL for extracting blacklisted IP addresses --- database/sqlite/eurephiadb-sqlite.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'database/sqlite/eurephiadb-sqlite.c') diff --git a/database/sqlite/eurephiadb-sqlite.c b/database/sqlite/eurephiadb-sqlite.c index f682a10..65f650d 100644 --- a/database/sqlite/eurephiadb-sqlite.c +++ b/database/sqlite/eurephiadb-sqlite.c @@ -881,7 +881,7 @@ eurephiaVALUES *eDBget_blacklisted_ip(eurephiaCTX *ctx) { DEBUG(ctx, 20, "Function call: eDBget_blacklisted_ip(ctx)"); - res = sqlite_query(ctx, "SELECT remoteip FROM openvpn_blacklist"); + res = sqlite_query(ctx, "SELECT remoteip FROM openvpn_blacklist WHERE remoteip IS NOT NULL"); if( res == NULL ) { eurephia_log(ctx, LOG_FATAL, 0, "Could not retrieve blacklisted IP addresses from the database"); -- cgit