2013-09-07, 02:00 PM
I think we should share the ban filters we use in our boards in order to keep the ongoing fight against bots posting non-solicited advertisements aka spam.
I will begin with mine. This was a dump from my banfilters table with the query modified not to include the ids, I actually used this to import ban filters I had in one board to another board that I also own.
I have attached the modified dump (in SQL format, compressed with gzip) to this thread.
Regards,
NewEraCracker
PS:
I will begin with mine. This was a dump from my banfilters table with the query modified not to include the ids, I actually used this to import ban filters I had in one board to another board that I also own.
I have attached the modified dump (in SQL format, compressed with gzip) to this thread.
Regards,
NewEraCracker
PS:
Regex: \([0-9]+, ('[^\']+', [0-9]+, [0-9]+, [0-9]+)\)
Replacement: \($1\)
Using Notepad++ and this regex in find & replace allows you to remove the ids from the query.