Database

These instructions need to be followed in order to setup the database correctly.

1. Install .bak files on SQL Server (Zolian, ZolianAbilities, ZolianMaps, ZolianMonsters, ZolianMundanes, ZolianPlayers)
2. ZolianPlayers will need to be populated; Run: https://github.com/FallenDev/Zolian/blob/master/Server.Configurations/PlayersDatabaseBuild.sql
3. Passwords need to be encrypted at rest, and the column will need to be encrypted with a local key.
   • Open "ZolianPlayers", Open Tables, Right click "dbo.Players", Click Encrypt Columns.
   • Click Column Selection, Click next to dbo.Players, Click Password.
   • Under Encryption Type, Select "Deterministic", Click Next, leave "Master Key Configuration" as-is, Select "Proceed to finish now", Click Next.
   • Click Finished, and wait until the column is encrypted. Click Close.
4. If the above was done successfully, you will now be able to create a character, and login. Encryption is handled within the SQL Server, you will not need to deal with any encrypting and decrypting through the server itself.

-- Note: ZolianPlayers cannot simply be created due to the stored procedures the server is expecting within the .bak file.

If you receive the error in your logs "The parameter "@Pass" does not have the same encryption information" upon login. It will still log you in, however, your encryption is not setup correctly. You'll need to delete your local keys, and try step 3 & 4 again.

• First decrypt the column by following the steps above, but instead choose "Plaintext" under Encryption Type.
  • This is important to prevent locking yourself out of the player table
• Under "Security" Click "Always Encrypted Keys", then delete your Encryption Keys followed by your Master Keys. (You will create new ones)
• Replay steps 3 & 4
• Open a new Query window and run the command: EXEC sp_refresh_parameter_encryption [PasswordSave]; GO`