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
darkice(1)						    DarkIce live audio streamer 						darkice(1)

NAME
darkice - an icecast / shoutcast live audio streamer SYNOPSIS
darkice [options] -c config.file DESCRIPTION
DarkIce as a live audio streamer. It records audio from an audio interface (e.g. sound card), encodes it and sends it to a streaming server. DarkIce can record from: * OSS audio devices * ALSA audio devices * Solaris audio interface * Jack sources DarkIce can encode in the following formats: * mp3 - using the lame library * mp2 - using the twolame library * Ogg Vorbis * AAC - using the faac library * AAC HEv2 - using the libaacplus (3GPP reference code) DarkIce can send the encoded stream to the following streaming servers: * ShoutCast * IceCast 1.3.x and 2.x * Darwin Streaming Server Darkice runs on the following operating systems: * FreeBSD * Linux on intel and PowerPC * MacOS X * NetBSD / OpenBSD * SUN Solaris DarkIce uses POSIX real-time scheduling to keep up with sound card input. POSIX real-time scheduling is only available if the program is run as root. Therefore it is recommended that DarkIce is run as root. OPTIONS
-c config.file Specifies what configuration file to use. If not specified, /etc/darkice.cfg will be used. -v n Sets the verbosity level, between 0 and 10. 0 is silent, 10 is loud. Defaults to 1. -h Prints the help page and exits. BUGS
Lots of bugs. SEE ALSO
darkice.cfg(5) AUTHOR
Akos Maroy <darkeye@tyrell.hu> ACKNOWLEDGEMENTS
Developed with contributions by Jim Crilly, <JCrilly@MSA.com> aNa|0Gue, <analogue@glop.org> Robin P. Blanchard, <Robin_Blanchard@gactr.uga.edu> Tom Gray, <tomg@future-i.com> Michael Smith, <msmith@labyrinth.net.au> Julius O. Smith, <jos@ccrma.stanford.edu> the OSALP team, http://osalp.sourceforge.net Kristjan G. Bjarnason <kgb@gangverk.is> Nicu Pavel <npavel@ituner.com> Kai Krakow <kai@kaishome.de> Atsuhiko Yamanaka <ymnk@jcraft.com> Ricardo Galli <gallir@uib.es> John Hay <jhay@icomtek.csir.co.za> Christian Forster <forster@like.e-technik.uni-erlangen.de> John Deeny <taqueso@dilapidated.org> Robert Lunnon <bobl@optushome.com.au> Enrico Ardizzoni <craken@users.sourceforge.net> Deti Fliegl <deti@fliegl.de> Nicholas J. Humfrey <njh@ecs.soton.ac.uk> Joel Ebel <jbebel@ncsu.edu> <jochen2@users.sourceforge.net> Alexander Vlasov <zulu@galaradio.com> Mariusz Mazur <mmazur@kernel.pl> dsk <derrick@csociety.org> Clyde Stubbs <clyde@htsoft.com> Jens Maurer <Jens.Maurer@gmx.net> Elod Horvath <elod@itfais.com> Pierre Souchay <pierre@souchay.net> Daniel Hazelbaker <daniel@highdesertchurch.com> Alessandro Beretta <alessandro.baretta@radiomaria.org> Roland Hermans <roland.hermans@omroepvenray.nl> Rafael Diniz <rafael@riseup.net> LINKS
Project homepage: http://code.google.com/p/darkice/ IceCast homepage: http://www.icecast.org/ ShoutCast homepage: http://www.shoutcast.com/ Darwin Streaming Server homepage: http://developer.apple.com/darwin/projects/streaming/ Lame homepage: http://www.mp3dev.org/mp3/ TwoLame homepage: http://www.twolame.org/ Ogg Vorbis homepage: http://www.xiph.org/ogg/vorbis/ faac homepage: http://www.audiocoding.com/ libaacplus homepage: http://tipok.org.ua/node/17 DarkSnow GTK front-end: http://darksnow.radiolivre.org/index.en.html written by Rafael Diniz DarkIce November 20, 2007 darkice(1)
All times are GMT -4. The time now is 01:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy