Navigation

snuff-these-users.sh

Timestamp:

02/07/07 13:21:37 (2 years ago)

Author:

jm3

Message:

refactored perl and shell scripts so they all use the new config mechanism

Files:

r1310	r1325
1	1	#!/bin/sh
2		# TODO: check for minima before building indices
	2	# snuff a list of users passed in on the command line
	3	# FIXME: REMEMBER that this does NOT privatize all their links, tags, etc. -- currently, only snuffing via php does that.
	4
	5	. env.sh # read in environment config vars
3	6
4	7	if [ "$#" -lt 1 ]
…	…
12	15	for user in $USERS
13	16	do
14		mysql -u ~~fml_fml -pfml fml_fml~~ -B -e "update linksUsers set snuffed = 1 where linksUsers.userid = '$user';"
15		mysql -u ~~fml_fml -pfml fml_fml~~ -B -e "update linksUsers set disabled = 1 where linksUsers.userid = '$user';"
	17	mysql -u `get_database_user` -p`get_database_password` `get_database_name` -B -e "update linksUsers set snuffed = 1 where linksUsers.userid = '$user';"
	18	mysql -u `get_database_user` -p`get_database_password` `get_database_name` -B -e "update linksUsers set disabled = 1 where linksUsers.userid = '$user';"
16	19	done
17	20
	21	exit 0
	22