Wags, if you're too proud to ask for access, tap dancing around in this thread isn't going to help ;)

People have different ways of dealing with stress :p .

East Hill

YES! Banning HH AND Donna burning her bra too! I love Women's Libertarianism!
Hey dude, burn your own bra! Do you have any idea how expensive a good one can be?











:p

Wags, if you're too proud to ask for access, tap dancing around in this thread isn't going to help ;)

Aren't you hidden P&R dudes supposed to be playing behind a digital curtain so as not to offend decent folk? :)

Hey dude, burn your own bra! Do you have any idea how expensive a good one can be?


Oddly, I suspect that Chip does.

I am offended by all of this sexual talk ... maybe BF needs a S&M forum too.

http://members.cox.net/urhome/T.JPG

:)

I am offended by all of this sexual talk ... maybe BF needs a S&M forum too.


I could get you that link to the Christian Bondage forum if it would help control those urges :) .

East Hill

I'm in. Thanks!

select * from db_users_that_whine...

We already mentioned that it's a manual process. There is no way to select the users that should have access with an SQL statement.
My SQL is very rusty, but here is the basic mechanism for creating a SQL script that queries based on a list that it's in a file.

It should run on any Unix or Unix-like server (including Linux) that has ksh in /bin. If ksh is not there, but in /usr/bin/ or something, then you'll have to edit the first line accordingly. Just put the following code into a file, chmod 755 it, and run it, specifying a file with the list of users in it on the command line.

You will have to change the SQL at the bottom to do the exact UPDATE or whatever that you want, based on the structure of your database.


#!/bin/ksh
# Assumes list of users to be given access is in file specified on command line
FNAME=$1
FNAME2=$1.commas_added
rm -f $FNAME2 doit.sql

if [[ -z "$FNAME" ]] ; then
echo "Usage: $0 <file-with-list-of-users>" >&2
exit 1
fi

if [[ ! -f $FNAME ]] ; then
echo "$FNAME does not exist" >&2
exit 1
fi

LC=$(wc -l < $FNAME) # Count number lines in file
LCMINUS1=$(expr $LC - 1)

# Put quotes around, and add a comma to then end of, every user in the file,
# except the last one
for username in $(head -$LCMINUS1 $FNAME); do
echo \'$username\', >> $FNAME2
done

# Add quotes, but not a comma, to the last one
echo \'$(tail -1 $FNAME)\' >> $FNAME2

echo "SELECT * from Table where userid in ($(echo $(cat $FNAME2)));" > doit.sql
You can also create a table and populate it with the users that should have access by loading it from a file.
They you can make sql statements with subqueries based on the content of your new table.

Anything but doing it manually. But it's too late now, I guess. For next time you want to do something like this, I suggest you learn how to use these bulk/automation mechanisms. Or not.

MEMBER=SPACE(8)
REPLACE WITH ((@IFF (“Poster_sucks”, IF (“Mod”, SKIP, “dumazz”)), “enroll”))
END

:)

MEMBER=SPACE(8)
REPLACE WITH ((@IFF (“Poster_sucks”, IF (“WAGATHON”, SKIP, “dumazz”)), “enroll”))
END

Fixed your code, Wags ;)

Hey dude, burn your own bra! Do you have any idea how expensive a good one can be?
:p

Oh sweetie I burned mine YEARS ago. Come on and join us - the few, the proud, the bra-less crowd!
:D

Oddly, I suspect that Chip does.

It seemed affordable until the judge tacked on the compensatory damages! :eek:

It seemed affordable until the judge tacked on the compensatory damages! :eek:

It was the Playboy cover that really piled on the insult to injury, Chip :D . How can the rest of the women stack up to that ;) ?

East Hill

It was the Playboy cover that really piled on the insult to injury, Chip :D . How can the rest of the women stack up to that ;) ?

East Hill

Hmm, so you did notice I was bra-less in that! Does Mr. East Hill suspect your lesbian crush on me? :p

Hmm, so you did notice I was bra-less in that! Does Mr. East Hill suspect your lesbian crush on me? :p

I think Mr. East Hill knows I am resisting mightily ;) .

East Hill

I think Mr. East Hill knows I am resisting mightily ;) .

East Hill

^^ The Force is strong in this one.

It was the Playboy cover that really piled on the insult to injury, Chip :D . How can the rest of the women stack up to that ;) ?

East Hill

Hee hee. You said "stack".

Hee hee. You said "stack".

;)

East Hill

Now you see why I had to drop the cover avatar...nobody (guys or gals) took me seriously as a person because they were always staring at my boobies. I'm more than a sex object, dambit!

Now you see why I had to drop the cover avatar...nobody (guys or gals) took me seriously as a person because they were always staring at my boobies. I'm more than a sex object, dambit!

I don't think it was the boobies, I think it was the blonde wig :D .

I will agree that you are more than a sex object--much more.

I see that you have contributed to this (http://www.bikeforums.net/showthread.php?t=380451) thread, but have not stated your qualifications yet ;) .

East Hill