Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
AlexJ Posted March 28, 2023 Posted March 28, 2023 Any query through which i can delete all the IP bans? Thanks
Solution Randy Calvert Posted March 28, 2023 Solution Posted March 28, 2023 (edited) This post was recognized by Marc! Randy Calvert was awarded the badge 'Helpful' and 5 points. IPB does not have a default way of mass deleting IP bans. Manually editing the database is not supported and it is highly recommended not to touch directly unless you know exactly what you're doing and understand the potential repercussions. If you ignore this advice, I would HIGHLY recommend taking a backup just to be safe before hand. You make any changes at your own risk. I will not be held liable for anything that does not work as expected or if a suggested solution blows up your site. Copyright 2023 Randy Calvert. All rights reserved. (Is that enough of a disclaimer!?) Look in the core_banfilters table. You'll find all of the ban records there. Edited March 28, 2023 by Randy Calvert AlexJ 1
AlexJ Posted March 30, 2023 Author Posted March 30, 2023 Thanks for the table info. Will come handy. Wrote the macro, to delete it in 100 batches. I wish, their was multi-select option based on 'search'.
Recommended Posts