| T O P I C R E V I E W |
| muzishun |
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. |
| 11 L A T E S T R E P L I E S (Newest First) |
| muzishun |
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. |
| muzishun |
Posted - 21 January 2008 : 11:42:42
Two commas missing! I must be getting old. Zip file updated again. Still version 0.6b. |
| AnonJr |
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.  |
| bobby131313 |
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! |
| bobby131313 |
Posted - 21 January 2008 : 11:26:50
OK, I think I got it. The 2 commas in red below weren't there, I added them and now it works.
|
| muzishun |
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  . |
| bobby131313 |
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 |
| AnonJr |
Posted - 21 January 2008 : 10:59:31
What does the query look like? (Response.Write the query before its executed) |
| bobby131313 |
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 |
| bobby131313 |
Posted - 21 January 2008 : 09:15:20
It's like deja vu all over again.
I'll absolutely be giving this one a go. Thanks! |
| HuwR |
Posted - 21 January 2008 : 03:11:10
nice idea muzishun |
|
|
