FUDforum: How To » Profile SPAM & profile fields

Home » FUDforum » How To » Profile SPAM & profile fields

Show: Today's Messages :: Polls :: Message Navigator

Re: Profile SPAM & profile fields [message #166976 is a reply to message #166935]

Wed, 11 April 2012 11:48

Nux
Messages: 9
Registered: April 2012

Karma:

Junior Member

Thanks a lot for that, it works.
There's a slight modification I needed to do as the table name is fud30_users in my case.
For anyone else interested, you can automate this via crontab, just add a new job like this:

*/30 * * * * mysql -uDATABASEUSER -pPASSWORD DATABASENAME -e "DELETE FROM fud30_users WHERE posted_msg_count = 0 AND LOWER(home_page) LIKE 'http%';"

The above command will run every 30 minutes, deleting users with a homepage set and no messages; most likely profile spammers.
This may prove useful in the future as many profile spammers are actually human beings so captchas won't work.

Report message to a moderator

[Message index]

		Profile SPAM & profile fields By: Nux on Wed, 04 April 2012 17:22
		Re: Profile SPAM & profile fields By: naudefj on Wed, 04 April 2012 17:29
		Re: Profile SPAM & profile fields By: Nux on Wed, 04 April 2012 17:40
		Re: Profile SPAM & profile fields By: naudefj on Mon, 09 April 2012 07:42
		Re: Profile SPAM & profile fields By: Nux on Mon, 09 April 2012 07:54
		Re: Profile SPAM & profile fields By: naudefj on Mon, 09 April 2012 10:52
		Re: Profile SPAM & profile fields By: Nux on Mon, 09 April 2012 11:51
		Re: Profile SPAM & profile fields By: naudefj on Tue, 10 April 2012 13:07
		Re: Profile SPAM & profile fields By: Nux on Tue, 10 April 2012 16:43
		Re: Profile SPAM & profile fields By: naudefj on Wed, 11 April 2012 11:33
		Re: Profile SPAM & profile fields By: Nux on Wed, 11 April 2012 11:48
		Re: Profile SPAM & profile fields By: naudefj on Thu, 19 April 2012 11:42
		Re: Profile SPAM & profile fields By: Nux on Thu, 19 April 2012 13:12

Previous Topic:	Connecting To Synchronet NNTP Server
Next Topic:	I have a problem logging in to my new forum.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 16:54:24 GMT 2024

Total time taken to generate the page: 0.05376 seconds