Jump to content

Featured Replies

Posted

Any query through which i can delete all the IP bans? Thanks

 

Could contain: Page, Text, File

Solved by Randy Calvert

Go to solution
  • Solution
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 by Randy Calvert

  • Author

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'. 

Recently Browsing 0

  • No registered users viewing this page.