I25 FAQ

Common Questions

How do I create an account?

• You can use the PowerShell script in downloads or execute a query against the database manually.
• Create NEW USER: test / password
  • INSERT INTO cohauth.dbo.user_account (account, uid, forum_id, pay_stat) VALUES ('test', 1, 1, 1014);
  • INSERT INTO cohauth.dbo.user_auth (account, password, salt, hash_type) VALUES ('test', CONVERT(BINARY(128),'46ffce3efcfe83bfa205b076d7c2084b9dcf04cdb26f9019103cde29779d26a85216b2c0f43ba1a8fb9b7fa22f05a949bf4edc314af27629e8fc23014e77a24d'), 0, 1);
  • INSERT INTO cohauth.dbo.user_data (uid, user_data) VALUES (1, 0x0080C2E000D00B0C000000000CB40058);
  • INSERT INTO cohauth.dbo.user_server_group (uid, server_group_id) VALUES (1, 1);
• Crust First's web-based tool for generating SQL queries to create new accounts

How do I make a GM Character?

• UPDATE [cohdb].[dbo].[Ents] SET [AccessLevel] = 10 WHERE [Name] = 'charnamehere'
• You can also set DefaultAccessLevel to 10 in servers.cfg, but this will only work for characters made after you make this change. You'll also need to restart DBServer after this change.
• Login to the game and type /mmm to bring up an admin menu. All commands are also listed in Commands.cfg

Why does my server show offline?

• First make sure you've added your server into the database. You can do so with the code below.
  • INSERT INTO cohauth.dbo.server (id, name, ip, inner_ip, ageLimit, pk_flag, server_group_id) VALUES (1, 'Bree', '127.0.0.1', '127.0.0.1', 0, 0, 1);

Why does my AuthServer say "Non-registered world server X.X.X.X"?

• Make sure the server is in the cohauth
  • INSERT INTO cohauth.dbo.server (id, name, ip, inner_ip, ageLimit, pk_flag, server_group_id) VALUES (1, 'Bree', '127.0.0.1', '127.0.0.1', 0, 0, 1);
  • INSERT INTO cohauth.dbo.worldstatus (idx, status) VALUES (1, 1);

Why does my DBServer say "login failed for user sa" when starting?

• Most likely you've entered the string wrong in account_server.cfg or another file.
• It could be that the sa account is still disabled as well. Double check SMSS to verify.
• If you've entered it correctly make sure restarted the service after the changes from the guide.

My AuctionServer is running but why players can't list items?

1. Most likely your auction_server.cfg is incorrect.
   • ShardIp 127.0.0.1
   • SqlDbName cohauc
   • SqlLogin "DRIVER={SQL Server Native Client 11.0};Server=localhost\SQLEXPRESS;Uid=sa;Pwd=YOURL33TPASS;"
2. Start AuctionServer64.exe