I25 FAQ

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

Why is my MapServer displaying popups?

• Most likely your server.cfg is set to -filedebug. Change to this -nopopup to no longer see windows from it.

Why aren't my Architect Missions aren't publishing?

• Most likely you are missing the "missionserver" folder. Create one in the root of your server directory and start MissionServer again. For me this is C:\COH\missionserver.

How do I pimp my ride in game?

• If your character is an admin type /autoenhance, /autoenhanceio, or /autoenhanceset. You can find many of commands in C:\COH\data\server\db\commands.cfg
• You can also type /mmm, scroll down to Design Testing, EnhanceAndInspire, Enhancements, and give yourself whatever you want.