How to create an account
1) Open MSSQL Management Studio. Connect to SQL Server and create a new query by pressing 'New Query' button on tool bar or hotkey CTRL + N.
2) Enter the following SQL Query:
USE AccountServer;
INSERT INTO account_login (name, password) VALUES ('<Login>', '<Password>')
Where:
<Login> - Login for new account;
<Password> - MD5 hash of password for new account in upper case.
You can get MD5 hash for passwords using special services:
http://www.md5.cz/
http://www.md5online.org/md5-encrypt.html
http://onlinemd5.com/
Example: you need to make account 'PKODev' with password '123456', so you have to execute the following SQL Query:
USE AccountServer;
INSERT INTO account_login (name, password) VALUES ('PKODev', 'E10ADC3949BA59ABBE56E057F20F883E')
3) If you need GM-account, you have to exequte one more SQL Query:
USE GameDB;
INSERT INTO account (act_id, act_name, gm) VALUES ((SELECT MAX(act_id) + 1 FROM account), '<Login>', <GM-level>);
Where:
<Login> - Login for new account;
<GM-Level> - GM level of the account.
Example:
USE GameDB;
INSERT INTO account (act_id, act_name, gm) VALUES ((SELECT MAX(act_id) + 1 FROM account), 'PKODev', 99);
As the result, we have created a new account with GM level 99.