Sponsored Content
The Lounge What is on Your Mind? Purge of Inactive Users with Zero Posts and Other Anti-spam Measures Post 303023536 by Neo on Wednesday 19th of September 2018 03:17:12 AM
Old 09-19-2018
And on top of that, just deleted all "homepage" links from profile pages of member who have not been active on the site since 1 Sept 2017 (over a year ago) regardless of the number of posts they had:

Code:
mysql> update user set homepage=''  where homepage!=''  and lastactivity < 1504224000;
Query OK, 6337 rows affected (0.24 sec)
Rows matched: 6337  Changed: 6337  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
ikiwiki-calendar(1)					      General Commands Manual					       ikiwiki-calendar(1)

NAME
ikiwiki-calendar - create calendar archive pages SYNOPSIS
ikiwiki-calendar [-f] your.setup [pagespec] [startyear [endyear]] DESCRIPTION
ikiwiki-calendar creates pages that use the ikiwiki/directive/calendar directive, allowing the archives to be browsed one month at a time, with calendar-based navigation. You must specify the setup file for your wiki. The pages will be created inside its srcdir, beneath the archivebase directory used by the calendar plugin (default "archives"). To control which pages are included on the calendars, a ikiwiki/PageSpec can be specified. The default is all pages, or the pages specified by the comments_pagespec setting in the config file. A pagespec can also be specified on the command line. To limit it to only posts in a blog, use something like "posts/* and !*/Discussion". It defaults to creating calendar pages for the current year. If you specify a year, it will create pages for that year. Specify a second year to create pages for a span of years. Existing pages will not be overwritten by this command by default. Use the -f switch to force it to overwrite any existing pages. CRONTAB
While this command only needs to be run once a year to update the archive pages for each new year, you are recommended to set up a cron job to run it daily, at midnight. Then it will also update the calendars to highlight the current day. An example crontab: 0 0 * * * ikiwiki-calendar ~/ikiwiki.setup 'posts/* and !*/Discussion' TEMPLATES
This command uses two templates to generate the pages, calendarmonth.tmpl and calendaryear.tmpl. AUTHOR
Joey Hess <joey@ikiwiki.info> ikiwiki-calendar(1)
All times are GMT -4. The time now is 01:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy