I'm think of making a mod where in admin accounts pending there would be another link / option to lock the user. But instead of adding the user to the members table and auto locking him it would put the email in a dead email table and on each registration that table would be checked and if the email is in there the user would get an error.
Two questions:
Is there any interest?
Should the table store anything in addition to the email address? Currently for the dbs I have
anything I should change?<

Depending on WHY you're not activating the member, you may want to include more information on him/her; so if the (IP or name) is the same & the EMail changes, you'd still find the user. So if I were writing it, I would include first, last, & user names; email & ip.<

Not activating the member because it's obviously a bot. Would you still include all the info?<

You cannot pick & choose, either include the information for the occasions when it's a human ... or not and face repeat sign-ups.<

I understand the impetus behind the idea, but it might be a better idea to use a new M_STATUS (Probably 2 since: 0 - Members' account is locked; 1 - Members' account is open) and exclude it from the members list. It would also be worth while to add a link that will pull up a list of just those spammer accounts.
That way you still have the IP info as well as the e-mail address. I'm not sure if you'll want to allow those usernames to be used or not. Some could be legit, some I wouldn't repeat to my little sister...<

It'd only take a couple of minutes to modify one of the admin search pages (EM or IP) to include a search by status, the icons are already depicted and actionable; would have to title the column for sorting and put in a filter condition.<

The only thing I forgot to mention is that if the base code ever includes that status code for something else it will cause some problems for your forum... just a warning worth heeding. <

I think I'll go with the add to the normal members table

Originally posted by AnonJr
The only thing I forgot to mention is that if the base code ever includes that status code for something else it will cause some problems for your forum... just a warning worth heeding.

As for that, I'll probably use something like 34. If we get up there I'll be worried. <

Ok go the db side to work and modded members.asp to solve this issue namely

I'm tired of seeing more spambots than actual members on my member's list in a couple of sites I maintain.

My question is what should raise the red flag? name and e-mail? either? only e-mail? etc.<