| Author |
 Topic  |
|
|
muzishun
Senior Member
United States
1079 Posts |
 Posted - 21 January 2008 : 01:00:22
|
I've been thinking about this MOD since someone suggested it awhile back. We all hate spammers, and the ones that get through whatever anti-spam registration policies you have in place can be a pain. This is aimed to help make it a little easier on forum owners.
From the readme:
There are many ways to help keep automated spambots out of your forum. However, manual registrations by spammers can still get through. When you catch these members, you may want to simply lock them and go on with your life. However, these members often populate all (or nearly all) of the fields of their profile with spam links and other information. This MOD, with a single click, clears out all of those fields, turns off email for the user, and locks their profile.
Download from SnitzBitz. |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
Edited by - muzishun on 21 January 2008 01:04:19 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 21 January 2008 : 03:11:10
|
| nice idea muzishun |
 |
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 21 January 2008 : 10:53:40
|
OK got an error in pop_delete.asp after clicking send. I'm using MySql....
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'M_DOB = '', M_HOBBIES = '', M_LNEWS = '', M_QUOTE = '', M_BIO = '', M_MARSTATUS ' at line 1
/pop_lock.asp, line 177
Line 177 is...
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords |
Switch the order of your title tags |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 21 January 2008 : 10:59:31
|
| What does the query look like? (Response.Write the query before its executed) |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 21 January 2008 : 11:14:32
|
Looks like this...
UPDATE FORUM_MEMBERS SET M_STATUS = 0, M_COUNTRY = '', M_HOMEPAGE = '', M_SIG = '', M_AIM = '', M_ICQ = '', M_MSN = '', M_YAHOO = '', M_FIRSTNAME = '', M_LASTNAME = '', M_OCCUPATION = '', M_SEX = '' M_DOB = '', M_HOBBIES = '', M_LNEWS = '', M_QUOTE = '', M_BIO = '', M_MARSTATUS = '' M_LINK1 = '', M_LINK2 = '', M_CITY = '', M_STATE = '', M_PHOTO_URL = '', M_RECEIVE_EMAIL = 0 WHERE MEMBER_ID = 2331
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'M_DOB = '', M_HOBBIES = '', M_LNEWS = '', M_QUOTE = '', M_BIO = '', M_MARSTATUS ' at line 1
/pop_lock.asp, line 177 |
Switch the order of your title tags |
|
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 21 January 2008 : 11:24:31
|
Oops, I see the error. There needs to be a comma between M_MARSTATUS = '' and M_LINK1 = ''. I'm surprised that it worked when I tested it... or it could be that I forgot to update the zip file when I tested it.
As for the deja vu, bobby, that is the exact topic I was referring to. This has been rolling around in my head ever since you suggested it, and I have finally gotten around to putting it together. Props to you for the original suggestion!
Edit: I have updated the zip file at SnitzBitz. Bobby, since you said you are using MySQL, I added that to the list of databases this has been tested with. Version is now 0.6b. Hopefully there won't be any other issues, and I can up that to 1.0  . |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
Edited by - muzishun on 21 January 2008 11:40:59 |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 21 January 2008 : 11:28:06
|
Ahh, we posted at the same time, looks like there's 2 missing.
I changed it to "Nuke member" and used  for an icon. 
Thanks! |
Edited by - bobby131313 on 21 January 2008 11:30:06 |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 21 January 2008 : 11:41:42
|
Its amazing how all the big issues get sorted without too much of a fuss ... only to be undone by a missing comma.
I'll have to add this to my "to-do" list for the Hope Fellowship site. For some odd reason they've been getting hammered with attempts.  |
|
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 21 January 2008 : 11:42:42
|
| Two commas missing! I must be getting old. Zip file updated again. Still version 0.6b. |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 21 January 2008 : 11:44:19
|
| I'm glad you guys like it. Nuke member, zap member, it all works. I chose the "Zap Spammer" title because I found a really nice lightning bolt icon in the famfamfam free icon set. Very nice for those who haven't seen it before. |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
| |
Topic |
|
|
|
Zap Spammer MOD
