FUDforum: How To » Profile SPAM & profile fields

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

Wed, 11 April 2012 11:33

naudefj

Messages: 3771
Registered: December 2004

Karma:

Senior Member
Administrator
Core Developer

Here is a SQL script to remove users with a URL in the profile, but without any posts:

DELETE FROM fud_users WHERE posted_msg_count = 0 AND LOWER(home_page) LIKE 'http%';

		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:

]

Current Time: Wed Nov 27 19:42:48 GMT 2024

Total time taken to generate the page: 0.03809 seconds