I am not doubting you at all and never would. :D

But you got to admit that is a scary looking query, with all it can do especially in the wrong hands, with wrong numbers entered... A fella could really screw alot of things up with that one!

I know its something am sure you and others have never seen on here before thats why i asked you to backup first i always do even if i know 100% it will work but i had to put in the warnings in my other post it just covers me in many ways. I did run tests on this query after i posted that so will edit that first warning and if you can do the same to post 7

The warnings aren't the scary part. The scary part is if I enter wrong number, etc. People who use that better be damn sure what they're doing.

Thanks again!

Wrong number do you mean ip?

Yeah...

I've run that query now many times, with different first three IP numbers, works great. Herding them all into a usergroup where I can examine them individually, decide if it's legit, or not. Then when done with the examination, purge what's left in that group.

Just exactly what i needed for the task.

Good to hear, and use that mod I gave you, it will delete there posts in all places then them will save you errors

I installed that one and set up its parameters. Will come in handy for that board's owner and staff. Nice hack.

Happy to help its my own I only give to a few

I pruned over 12,000 spammers, 54,000 of their threads.... 1000s of blog entries, many thousands of their posts that weren't OP... all their private messages and visitor messages.... Using the query posted here and that tool. Excellent.

Nice