How to create an administrator account?

[arrow5]

sorry for my inconvenience...
I want create a Pserver and these guides were very helpful
http://forum.ragezone.com/f457/v15-depth-setup-guide-w-support-666481/
and
http://forum.ragezone.com/f457/v15-depth-setup-guide-w-support-666481/
But the two guides gave me this querry:
Admin Query.sql

/*******Server Needs to be Down for this*******/

USE [CHARACTER_01_DBF]

UPDATE CHARACTER_TBL SET m_chAuthority='Z'
	WHERE m_szName='YourCharaNameHere' and serverindex='01'


USE [ACCOUNT_DBF]

UPDATE ACCOUNT_TBL_DETAIL SET m_chLoginAuthority='Z'
	WHERE account='YourAccount ID here' and gamecode='A000'

/*******Server Needs to be Down for this*******/


/******* Just Enter the Details inside the quotes account='' and mszName=''*******/

I do not know how to use it.
because i cant see any fild to enter the password.
and when I enter the Neuz, I do not know how to enter as GM.
Because I don't know what to put in the password box...

I already search the forum, and I could not find anything related.
sorry if there was already posted something similar.


Thnx for read, and I wait your answer..

 

[Lykos94]

sorry for my inconvenience...
I want create a Pserver and these guides were very helpful
http://forum.ragezone.com/f457/v15-depth-setup-guide-w-support-666481/
and
http://forum.ragezone.com/f457/v15-depth-setup-guide-w-support-666481/
But the two guides gave me this querry:
Admin Query.sql

/*******Server Needs to be Down for this*******/

USE [CHARACTER_01_DBF]

UPDATE CHARACTER_TBL SET m_chAuthority='Z'
	WHERE m_szName='[COLOR="Red"]YourCharaNameHere[/COLOR]' and serverindex='01'


USE [ACCOUNT_DBF]

UPDATE ACCOUNT_TBL_DETAIL SET m_chLoginAuthority='Z'
	WHERE account='[COLOR="Blue"]YourAccount ID here[/COLOR]' and gamecode='A000'

/*******Server Needs to be Down for this*******/


/******* Just Enter the Details inside the quotes account='' and mszName=''*******/

I do not know how to use it.
because i cant see any fild to enter the password.
and when I enter the Neuz, I do not know how to enter as GM.
Because I don't know what to put in the password box...

I already search the forum, and I could not find anything related.
sorry if there was already posted something similar.


Thnx for read, and I wait your answer..

Just fill as follow:

Name of your character you want to be GM
Name of the account

Then just execute the query in your SQLEXPRESS and you got your gm.

Remember

-The server must be down
-Account name small first character
Ex.
Account: lykos94 not Lykos94
and the name of player with the capital
Name: Lykos94 not lykos94

 

[poledoo]

yes that will make just a single character GM. if you want to make the whole account admin then you need to go into your Account database and open dbo.ACCOUNT_TBL_DETAIL and change the m_chLoginAuthory column to the wanted authority

A- no commands
F- normal player
O- Moderator (limited commands)
P- GameMaster (same commands as admin just called GameMaster)
Z- Admin

 

[arrow5]

Thnx : )

 

[Rentapest]

This makes ZERO sense -.-

Trying to UPGRADE an EXISTING account to be an ADMIN. But a forum search, and google search of course keep returning me to this ******** thread with no information. -.- God damn I hate search algorithms!