Author |
Topic  |
|
phy1729
Average Member
  
USA
589 Posts |
Posted - 15 June 2008 : 21:53:39
|
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
[CREATE]
DEAD_EMAILS
email#varchar(128)##
[END]
anything I should change?< |
|
Carefree
Advanced Member
    
Philippines
4217 Posts |
Posted - 16 June 2008 : 02:45:47
|
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.< |
 |
|
phy1729
Average Member
  
USA
589 Posts |
Posted - 16 June 2008 : 07:00:26
|
Not activating the member because it's obviously a bot. Would you still include all the info?< |
 |
|
Carefree
Advanced Member
    
Philippines
4217 Posts |
Posted - 16 June 2008 : 07:18:26
|
You cannot pick & choose, either include the information for the occasions when it's a human ... or not and face repeat sign-ups.< |
 |
|
AnonJr
Moderator
    
United States
5768 Posts |
Posted - 16 June 2008 : 08:53:48
|
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...< |
 |
|
Carefree
Advanced Member
    
Philippines
4217 Posts |
Posted - 16 June 2008 : 10:59:06
|
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.< |
Edited by - Carefree on 16 June 2008 10:59:27 |
 |
|
AnonJr
Moderator
    
United States
5768 Posts |
Posted - 16 June 2008 : 13:29:10
|
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. < |
 |
|
phy1729
Average Member
  
USA
589 Posts |
Posted - 16 June 2008 : 21:25:18
|
I think I'll go with the add to the normal members table
quote: 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. < |
 |
|
phy1729
Average Member
  
USA
589 Posts |
Posted - 23 June 2008 : 20:44:07
|
Ok go the db side to work and modded members.asp to solve this issue namely quote:
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.< |
 |
|
|
Topic  |
|