Sponsored Content
The Lounge What is on Your Mind? Purge of Inactive Users with Zero Posts and Other Anti-spam Measures Post 303023537 by Neo on Wednesday 19th of September 2018 03:23:05 AM
Old 09-19-2018
And just deleted any "homepage" links from all users with zero posts who have not been active since 1 September 2018:

Code:
mysql> update user set homepage=''  where homepage!='' and posts=0 and lastactivity < 1535760000;
Query OK, 153 rows affected (0.21 sec)
Rows matched: 153  Changed: 153  Warnings: 0

So, that should get rid of most of the prior "register and just add a link" spammers.
 

4 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to logout inactive users????

I would like to automatically logout from the system inactive users depending on their functions. For example there are users that I would like to logout after 15 minutes of inactivity, but there are others that I would like to logout after 30 minutes of inactivity. It's possible to do this??? (6 Replies)
Discussion started by: rrivas
6 Replies

2. UNIX for Dummies Questions & Answers

List all inactive users who has not logged on since last 90 days

Hi, Can I get a script to list out all the users, who has not logged on since last 90 days. Last command in not working due due to /var/adm/wtmpx is more than 2 GB. Thanks in advance. Regards, Roni (10 Replies)
Discussion started by: manasranjanpand
10 Replies

3. Solaris

List all inactive users who has not logged on since last 90 days

I need actuall script which List all inactive users who has not logged on since last 90 days Thanks in advance. Di! (17 Replies)
Discussion started by: haridham
17 Replies

4. Shell Programming and Scripting

Deleting Inactive Solaris users

Hello, I want to do a search for users on my solaris boxes that have been inactive for a defined number of days and then delete them. Any ideas how to determine or calculate the number of days (possibly using the /var/adm/wtmpx file) from the user's last login to the current date of search. ... (0 Replies)
Discussion started by: prince2010
0 Replies
Mail::Message::Wrapper::SpamAssassin(3pm)		User Contributed Perl Documentation		 Mail::Message::Wrapper::SpamAssassin(3pm)

NAME
Mail::Message::Wrapper::SpamAssassin - Connect a Mail::Message with Mail::SpamAssassin INHERITANCE
Mail::Message::Wrapper::SpamAssassin is a Mail::SpamAssassin::Message SYNOPSIS
# WARNING: requires OLD SpamAssassion 2.x, not the new 3.x # See Mail::Box::Search::SpamAssassin for the preferred interface # However, it is possible to do: my $msg = ...; # some Mail::Message object my $sa = Mail::Message::Wrapper::SpamAssassin->new($msg); my $spam = Mail::SpamAssassin->new; my $status = $spam->check($sa); $msg->label(spam => 1) if $status->is_spam; $status->rewrite_mail; # Adds spam lines to header DESCRIPTION
WARNING: This module only works with the old version of SpamAssassin: version 2.x. The newer 3.x releases have changed the way that messages are kept. Please contribute improved code. The "Mail::Message::Wrapper::SpamAssassin" class --sorry for the long package name-- is a wrapper around Mail::SpamAssassin::Message, which is an interface to the spam checking software of Mail::SpamAssassin. METHODS
Mail::Message::Wrapper::SpamAssassin->new(MESSAGE, OPTIONS) Creates a wrapper around the MESSAGE. The already present fields from a previous run of Spam::Assassin (or probably fake lines) are removed first. SEE ALSO
This module is part of Mail-Box distribution version 2.105, built on May 07, 2012. Website: http://perl.overmeer.net/mailbox/ LICENSE
Copyrights 2001-2012 by [Mark Overmeer]. For other contributors see ChangeLog. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See http://www.perl.com/perl/misc/Artistic.html perl v5.14.2 2012-05-07 Mail::Message::Wrapper::SpamAssassin(3pm)
All times are GMT -4. The time now is 01:27 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy