MsSql querys

[Alexsh]

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

[MentaL]

[jemelm]

thank you for sharing.

[damian9000z]

Good for people who need a quicker way of modifying content rather then in MSSQL Studio Express (I find it to be the slowest program in the world idk it might just be me.)

[flyffxtra]

Good for people who need a quicker way of modifying content rather then in MSSQL Studio Express (I find it to be the slowest program in the world idk it might just be me.)

I use MSSQL Studio Express but what i hate is that there's no search/find function o.o or not that i've found yet. So I find queries to be quite helpful.