[MSSQL]Make Admin MsSQL query

So, I thought I would share this little query that I've been using to make admins. ;)

Code:

---

USE [CHARACTER_01_DBF]
GO

UPDATE [dbo].[CHARACTER_TBL] SET [m_chAuthority]='P' WHERE [m_szName]='<character name here>'

---

Usage:
Just change the <character name here> to the character name and then execute.

Enjoy. ;)

Awesome =]

i thought admin is "S"

P works just as well. ^^

Any difference between S and P?

From what I know the authority level for normal is 70, admin is 80 and there is one or maybe more between those that have limited access.

Now look at an ascii table and figure the rest :P

Pretty sure P/O Flags have their own limitations.

S is admin, P/O are limited GM, F is normal player, did we not go over this before?

i found a easyer way to make admin an gm's on mssql
k first open the db go in to character_01_DBF
go in to table.. an look for dbo.character.tbl
right click an click open table...
a list of character names comes up..
just slide the slider over till you see m_chauthority which should be in the middle area..
this is where you put the S P/O an F depanding on the name you want gm's or what not... if you have the server running while doin this just do a server restart to make the change's affective... hope this helps alot better then doin scripts