Sponsored Content
The Lounge What is on Your Mind? Purge of Inactive Users with Zero Posts and Other Anti-spam Measures Post 303023535 by Neo on Wednesday 19th of September 2018 03:13:29 AM
Old 09-19-2018
Also, just removed "homepage" urls from all users with zero posts who have not been active on the site since 1 March 2018:

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

 

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
WWW::Finger(3pm)					User Contributed Perl Documentation					  WWW::Finger(3pm)

NAME
WWW::Finger - get useful data from e-mail addresses SYNOPSIS
use WWW::Finger; my $finger = WWW::Finger->new("joe@example.com"); if (defined $finger) { print $finger->name . " "; } DESCRIPTION
This module is not an implementation of the finger protocol (RFC 1288). Use Net::Finger for that. Instead it is a set of implementations of other methods for getting information from an e-mail address, or e-mail like identifier. This package includes four such implementations, and it's pretty easy to create your own additional implementations: o WebFinger o Fingerpoint o MetaCPAN API for cpan.org addresses o Unnamed finger protocol described on bitworking.org Constructor o "new" $finger = WWW::Finger->new($identifier); Creates a WWW::Finger object for a particular identifier. Will return undef if no implemetation is able to handle the identifier Object Methods Any of these methods can return undef if the appropriate information is not available. The "name", "mbox", "homepage", "weblog", "image" and "key" methods work in both scalar and list context. Depending on which implementation was used by "WWW::Finger->new", the object may also have additional methods. Consult the documentation of the various implementations for details. "name" The person's name (or handle/nickname). "mbox" The person's e-mail address (including "mailto:"). "homepage" The person's personal homepage. "weblog" The person's blog. (There may be some overlap with "homepage".) "image" An avatar, photo or other image depicting the person. "key" The URL of the person's GPG/PGP public key. "webid" A URI uniquely identifying the person. See <http://esw.w3.org/topic/WebID>. "endpoint" A SPARQL Protocol endpoint which may provide additional data about the person. (See RDF::Query::Client.) "graph" An RDF::Trine::Model object holding data about the person. (See RDF::Trine.) SEE ALSO
Net::Finger. <http://code.google.com/p/webfinger/>. <http://buzzword.org.uk/2009/fingerpoint/spec>. <http://www.perlrdf.org/>. fingerw. AUTHOR
Toby Inkster, <tobyink@cpan.org> COPYRIGHT AND LICENCE
Copyright (C) 2009-2012 by Toby Inkster This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. DISCLAIMER OF WARRANTIES
THIS PACKAGE IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF MERCHANTIBILITY AND FITNESS FOR A PARTICULAR PURPOSE. perl v5.14.2 2012-02-23 WWW::Finger(3pm)
All times are GMT -4. The time now is 12:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy