diff options
| author | Savetheinternet <savetheinternet@n0v4.com> | 2011-03-31 00:15:26 +1100 |
|---|---|---|
| committer | Savetheinternet <savetheinternet@n0v4.com> | 2011-03-31 00:15:26 +1100 |
| commit | 5b841d1e5366892e3203f60c22c12db45d4375e0 (patch) | |
| tree | a5e06395303981b70795aba3db36196759c97230 /inc/functions.php | |
| parent | b4aa39ca2def14eb1f6521eeb9e6f0a76b3720f5 (diff) | |
Remove expired IP range bans properly
Diffstat (limited to 'inc/functions.php')
| -rw-r--r-- | inc/functions.php | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/inc/functions.php b/inc/functions.php index e2a2454b..c8239785 100644 --- a/inc/functions.php +++ b/inc/functions.php @@ -211,6 +211,13 @@ $query->bindValue(':ip', $_SERVER['REMOTE_ADDR']); $query->bindValue(':expires', $ban['expires'], PDO::PARAM_INT); $query->execute() or error(db_error($query)); + + if($config['ban_range']) { + $query = prepare("DELETE FROM `bans` WHERE :ip REGEXP CONCAT('^', REPLACE(REPLACE(`ip`, '.', '\\.'), '*', '[0-9]*'), '$') AND `expires` = :expires LIMIT 1"); + $query->bindValue(':ip', $_SERVER['REMOTE_ADDR']); + $query->bindValue(':expires', $ban['expires'], PDO::PARAM_INT); + $query->execute() or error(db_error($query)); + } return; } $body = '<div class="ban"> |