GM account tutorial

I will explain you how to seting up a GM account in SQL. This will make all user who use GM_Client on your server cannot use the GM_CMD without this check on DB .

Let's start :

First of all the registration account script is bad. I will give you the new :

OLD :

INSERT INTO TB_MEMBER

(
REGISTER_DATE,
LAST_DATE,
LOGINID,
PASSWORD,
LAST_SERVER_NUM,
LAST_CHANNEL_NUM,
SLEVEL
)

VALUES

(
GETDATE(),
GETDATE(),
'test1',
PWDENCRYPT(CONVERT(varbinary(100), UPPER('1111'))),
1,
1,
1
)

NEW :

INSERT INTO TB_MEMBER

(
REGISTER_DATE,
LAST_DATE,
LOGINID,
PASSWORD,
LAST_SERVER_NUM,
LAST_CHANNEL_NUM,
SLEVEL
)

VALUES

(
GETDATE(),
GETDATE(),
'test1',
PWDENCRYPT(CONVERT(varbinary(100), UPPER('1111'))),
1,
1,
0
)

You need register your account users with SLEVEL 0 ( SLEVEL 0 mean normal player , SLEVEL 1 mean GM_ACCOUNT , SLEVEL 2 mean Banned account ).

After this if you connect with an account SLEVEL 0 directly u will have error notice :

User is under investigation.

For enable SLEVEL 0 ( player account ) to connect just start the serverTooL and click on userIN *.

http://fce-games.com/acc.jpg

* make sure to use your ip ... in serverinfo.txt




Done .

Now enjoy this and now you can open your server to all.

all cool but i have 1 question
how im creath new account ? im try put into
PASSWORD 1111 or somting like you say but its not working
here is an pictere
http://img408.imageshack.us/img408/3226/problem1l.png

Uploaded with ImageShack.us
Yfrog Photo : yfrog.com/bcproblem1lp

NEW :

INSERT INTO TB_MEMBER

(
REGISTER_DATE,
LAST_DATE,
LOGINID,
PASSWORD,
LAST_SERVER_NUM,
LAST_CHANNEL_NUM,
SLEVEL
)

VALUES

(
GETDATE(),
GETDATE(),
'test1',
PWDENCRYPT(CONVERT(varbinary(100), UPPER('1111'))), HERE IS THE PROBLEM IDK WHAT TO PUT INTO PASSWORD -.-
1,
1,
0
)

Anyone please help naty13_13@hotmail.com

Has somone fixed this already?? I also dont understand what to input into ass password.

We use the provided "new" script to add in the account to our DB server and your password should be in binary data not in number..

why i Gm acount..no funstion=.=