-
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.
-
Re: GM account tutorial
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
)
-
Re: GM account tutorial
-
Re: GM account tutorial
Has somone fixed this already?? I also dont understand what to input into ass password.
-
Re: GM account tutorial
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..
-
Re: GM account tutorial
why i Gm acount..no funstion=.=