[flyguye]

Hi,

I need to mass move specific users (a couple of hundred of them) based on their usernames, not based on their id, to be deleted at a later time.

Each user is unique, with differing post counts, join dates, etc.

I've tried to mess around with some SQL queries but no luck.

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

I have the usernames on excel so if I could add them into the query either comma separated, or space separated, or line separated would be great!

I've no knowledge on SQL, so I might be shootin' in the dark here!

[Pandemikk]

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Only problem is you have to make sure the username's are escaped. Feel free to PM me a list of the username's and I'll write up a quick script that'll get the job done.

[flyguye]

Very kind of you sir! However the list isn't finalized yet, will PM you the list once it's finalized!

However, I don't understand what you mean by the usernames being escaped?

--------------- Added 05 Apr 2012 at 11:11 ---------------

Managed to do it!

I used excel to add the 'apostrophes' and appropriate spaces at the end of each username, and pasted it in the following format:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Where X is the target usergroupid

That allowed me to paste the all the usernames at one go!

Thanks again! SOLVED!

[Pandemikk]

By escaped, I mean there are certain characters in usernames that would break the query, most notably an apostrophe itself. But seeing as how everything worked out I'm going to assume none of the username's had an apostrophe in them, anyway.

Glad I could be of assistance.