diff options
| author | David Sommerseth <dazo@users.sourceforge.net> | 2008-11-01 13:58:58 +0100 |
|---|---|---|
| committer | David Sommerseth <dazo@users.sourceforge.net> | 2008-11-01 13:58:58 +0100 |
| commit | 5ec4729e5eeed077b77031ac4e74644d67882d37 (patch) | |
| tree | f5c5ac29a6ea1ba3620e66d75d973941380ebecd /database/sqlite/eurephiadb-sqlite.c | |
| parent | 56418ca7e6c3e47257c1299cafa0ddabdd732bc0 (diff) | |
| download | eurephia-5ec4729e5eeed077b77031ac4e74644d67882d37.tar.gz eurephia-5ec4729e5eeed077b77031ac4e74644d67882d37.tar.xz eurephia-5ec4729e5eeed077b77031ac4e74644d67882d37.zip | |
Fixed missing WHERE clause in SQL for extracting blacklisted IP addresses
Diffstat (limited to 'database/sqlite/eurephiadb-sqlite.c')
| -rw-r--r-- | database/sqlite/eurephiadb-sqlite.c | 2 |
1 files changed, 1 insertions, 1 deletions
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"); |