Code:
update `accounts`
set banned = 0
where id = 1;
delete from `ipbans`
where ip = '/127.0.0.1';
delete from `macbans`
where mac = '00-00-00-00-00-00';
Replace the /127.0.0.1 with their ip address, keep the / or it will not work. Replace the 00's with their mac address.
Oh, and replace the id with the id in the accounts table.
Credits to me
Code:
update `accounts`
set gm = 1
where id = 1;
update `characters`
set gm = 1
where accountid = 1;
Just get the id that you want and change the 1 to anything.
Let me know if you need a SQL script made, i'd be happy to help.