+ 2 REP, Need a simple Mysql Querie

[mafiaboy]

Hey guys,

I just need a query that would delete everybody with GM priviliges in my logon2 table.

All GM's priviliges are set to the following:

qshvtrcegi


Thanks,
Mafiaboy

+ 2 rep to whoever gives me a working query!

[Hellgawd]

Mafiaboy, I will do this for you right now, but what GM privileges? lol

[Hellgawd]

DELETE FROM accounts WHERE gm = 'qshvtrcegi';

That would work for all gms with "a" privileges.
If you have gms with other privileges, edit the "a" to whatever their current flags are.

EDIT: You edited your thread! Oh well, I edited my query. Try this one!
Edit2: Here you go, I didnt quite understand what you wanted, but i edited it again!
Edit3: Oh no, after I edited, I saw TheKingOfBeasts Post >.<
Oh well, I guess I lost this one. /sigh

[mafiaboy]

I wanted one that deletes the accounts,not changes priviliges

[The Kingofbeast]

Here's you're query

delete from accounts where gm = 'qshvtrcegi';

[mafiaboy]

+rep to both of u

[The Kingofbeast]

=D Yayyy thanks =D

[Tkreder123]

Umm, I'm a GM on your server with that permission string, what would happen to me? (Acct: GMKreder)