2013-01-07, 01:22 PM
I have had a big issue with spam users signing up over the last month or so, I now have over 1000 spam accounts, awaiting activation, I have the captha and question and answer installed, but still the spam registration keep coming, does any one know a SQL query to remove all the waiting activation members, or away of doing in acp and what other methods could be used to weed out the spammers at the moment I have registrations to be admin activated but right now I can not be bothered or have the time to go through over 1000 accounts and try and work out which accounts are spam and which are not.