Zap Spammer MOD - Posted (2052 Views)
muzishun
Senior Member
muzishun
Posts: 1079
1079
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)
Last edited by muzishun on 21 January 2008, 01:04
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
HuwR
Forum Admin
HuwR
Posts: 20611
20611
nice idea muzishun
Posted
bobby131313
Senior Member
bobby131313
Posts: 1163
1163
It's like deja vu all over again.
I'll absolutely be giving this one a go. Thanks!
Switch the order of your title tags
Posted
bobby131313
Senior Member
bobby131313
Posts: 1163
1163
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
Posted
AnonJr
Forum Moderator
AnonJr
Posts: 5768
5768
What does the query look like? (Response.Write the query before its executed)
Posted
bobby131313
Senior Member
bobby131313
Posts: 1163
1163
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
Posted
muzishun
Senior Member
muzishun
Posts: 1079
1079
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 smile.
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com)
Last edited by muzishun on 21 January 2008, 11:40
Posted
bobby131313
Senior Member
bobby131313
Posts: 1163
1163
OK, I think I got it. The 2 commas in red below weren't there, I added them and now it works.
Code:
strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
				strSql = strSql & " SET M_STATUS = 0, M_COUNTRY = '', M_HOMEPAGE = '', M_SIG = '', M_AIM = '', M_ICQ = '', "
				strSql = strSql & " M_MSN = '', M_YAHOO = '', M_FIRSTNAME = '', M_LASTNAME = '', M_OCCUPATION = '', M_SEX = '', "
				strSql = strSql & " M_DOB = '', M_HOBBIES = '', M_LNEWS = '', M_QUOTE = '', M_BIO = '', M_MARSTATUS = '', "
				strSql = strSql & " M_LINK1 = '', M_LINK2 = '', M_CITY = '', M_STATE = '', M_PHOTO_URL = '', M_RECEIVE_EMAIL = 0 "
				strSql = strSql & " WHERE MEMBER_ID = " & Member_ID
Switch the order of your title tags
Posted
bobby131313
Senior Member
bobby131313
Posts: 1163
1163
Ahh, we posted at the same time, looks like there's 2 missing.
I changed it to "Nuke member" and used for an icon. tongue
Thanks!
Last edited by bobby131313 on 21 January 2008, 11:30
Posted
AnonJr
Forum Moderator
AnonJr
Posts: 5768
5768
Its amazing how all the big issues get sorted without too much of a fuss ... only to be undone by a missing comma. tongue
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. angry
Posted
muzishun
Senior Member
muzishun
Posts: 1079
1079
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)
You Must enter a message