While managing my server I had to make a few queries in order to make managing the database easier. So I thought i'd release them for anyone else who wants them.
//Changes character authority (Make them a GM...etc)
update [CHARACTER_TBL] set m_chAuthority = 'F/P/S' where m_szName = 'CHARACTERNAME'
//Sets Ban Start Time
update [ACCOUNT_TBL_DETAIL] set BlockTime = '20090210' where account = 'ACCOUNTNAME'
//Sets Ban End Time
update [ACCOUNT_TBL_DETAIL] set EndTime = '' where account = 'ACCOUNTNAME'
//Removes the guild wait time on a certain character
update [CHARACTER_TBL] set m_tGuildMember = '' where m_szName = 'CHARACTERNAME'
//Gets a character's account ID
select account from [CHARACTER_TBL] where m_szName = 'CHARACTER NAME'
//Displays all the characters on an account
select m_szName from [CHARACTER_TBL] where account = 'ACCOUNTNAME'
//Sets an IP address on a certain account
update [ACCOUNT_TBL_DETAIL] set ip = 'IP ADDRESS' where account = 'ACCOUNTNAME'
//Gets the MD5 Password from an account
select password from [ACCOUNT_TBL] where account = 'ACCOUNTNAME'
//Sets an account's password to what you want it as.
update [ACCOUNT_TBL] set password = 'md5 pw' where account = 'ACCOUNTNAME'
//Changes the account a character is on (you may need the next query if you use this query)
update [CHARACTER_TBL] set account = 'ACCOUNTNAME' where m_szName = 'CHARACTERNAME'
//Changes the slot that the player is in in the character selection
update [CHARACTER_TBL] set playerslot = 'slot' where m_szName = 'CHARACTERNAME'
Credits to me for putting the queries together. I will update it frequently. I'm currently working on a GM/Admin Panel for simplicity. Thank me if this helped? :D
