Mario 12 Report post Posted June 4, 2022 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 Quote Share this post Link to post Share on other sites
cachaFloja 14 Report post Posted June 4, 2022 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. 1 Quote Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted June 10, 2022 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>' Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites