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-d...upport-666481/
and
http://forum.ragezone.com/f457/v15-d...upport-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..

[MentaL]

[Lykos94]

sorry for my inconvenience...
I want create a Pserver and these guides were very helpful
http://forum.ragezone.com/f457/v15-d...upport-666481/
and
http://forum.ragezone.com/f457/v15-d...upport-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..

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 : )