Search the Community

Database pko 2.4 is not compatible with pko site 1.38? To create accounts?

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.