It would be cool to have expired IP-Bans being deleted from the bans list

[DarkTexas 🦄]

💡Describe your Feature request

Right now IP Bans do not get removed from the IP-Bans list when they expire. When yet having this user posting lawful content again and you're trying to ban the user again, you're receiving a message "IP already banned" even if the ban has expired.

As I also like to use the ip_bans db for banning them from my other sites as well, I'd be cool if such a ban has expired they're also deleted from the Ip_bans table.

 

[DeCysos]

Is the question not actually whether it is still worthwhile to put on IP locks worth?
There are certainly sources where it can be worthwhile to set up an IP block, but when it comes to human users, most users get a new IP address assigned by their provider daily or depending on the dial-up.

For myself it is not so with the IPv4, but only once a year at most. But the IPv6 changes constantly.

 

[DarkTexas 🦄]

Is the question not actually whether it is still worthwhile to put on IP locks worth?
There are certainly sources where it can be worthwhile to set up an IP block, but when it comes to human users, most users get a new IP address assigned by their provider daily or depending on the dial-up.

For myself it is not so with the IPv4, but only once a year at most. But the IPv6 changes constantly.

I get your point. But as per law in Germany you at least have to "try to do something" against those users. So the original issue stands.

 

[armory]

Is the question not actually whether it is still worthwhile to put on IP locks worth?
There are certainly sources where it can be worthwhile to set up an IP block, but when it comes to human users, most users get a new IP address assigned by their provider daily or depending on the dial-up.

For myself it is not so with the IPv4, but only once a year at most. But the IPv6 changes constantly.

Something is better than nothing, it is enough to increase the cost of crime.
And for some network issue, I don't use IPv6 on my sites, IPv4 is still cooool!

 

[Rodolfo]

DELETE FROM chv_ip_bans
WHERE ip_ban_expires_gmt < UTC_TIMESTAMP()

 

[DarkTexas 🦄]

DELETE FROM chv_ip_bans
WHERE ip_ban_expires_gmt > UTC_TIMESTAMP()

returns

SQL query:
DELETE FROM chv_ip_bans WHERE ip_ban_expires_gmt > UTC_TIMESTAMP()
Matched rows: 0

for me. The bans on the table (expired ones) are still there though. 🙁

 

[Rodolfo]

Change the sign.

 

[DarkTexas 🦄]

muchas gracias