- Joined
- Sep 9, 2006
- Messages
- 272
- Reaction score
- 346
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 *.
* make sure to use your ip ... in serverinfo.txt
Done .
Now enjoy this and now you can open your server to all.
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 *.
You must be registered to see links
* make sure to use your ip ... in serverinfo.txt
Done .
Now enjoy this and now you can open your server to all.
Last edited: