Register accounts by using my server files

[Mario 12]

Hello , PKODEV community

 

If any one could help me on this ,

how to banned / edit username

also if I can register account by using my files , and make this account GM 

 

thank you  

[cachaFloja 14]

With Sql server Management you can edit directly the data from AccountServer and GameDB

 

AccountServer > account_login (colum "gm" with value 99 are gm, 0 is normal user)

GameDB > account

 

In Accountserver.dbo.login you have a column called "ban", maybe you can use to block users, i am not sure.

 

To create a new account you must insert new values in account_login(Accountserver) and account(GameDB)

Or you can use a tool to create new accounts,

 

Account Creator TOP/PKO

 

Or You can install this Web and register.

 

[V3ct0r 2,117]

Hello @Mario,

 

 

Execute the following SQL query in MSSQL Management Studio to edit an username:

UPDATE AccountServer.dbo.account_login SET name = '<New name>' WHERE name = '<Old name>';
UPDATE GameDB.dbo.account SET act_name = '<New name>' WHERE act_name = '<Old name>';

 

To ban an account:

UPDATE AccountServer.dbo.account_login SET ban = 1 WHERE name = '<account name>'

To unban an account:

UPDATE AccountServer.dbo.account_login SET ban = 0 WHERE name = '<account name>'

 

To set GM level of an account:

UPDATE GameDB.dbo.account SET gm = <gm level> WHERE act_name = '<account name>'