AlexJ Posted March 28, 2023 Share Posted March 28, 2023 Any query through which i can delete all the IP bans? Thanks Link to comment Share on other sites More sharing options...
Solution Randy Calvert Posted March 28, 2023 Solution Share 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 Link to comment Share on other sites More sharing options...
AlexJ Posted March 30, 2023 Author Share 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'. Link to comment Share on other sites More sharing options...
Recommended Posts