1.9.7.3802

Merge pull request #386 from DigitalBox98/improved
    Adjustment on keep lord auto-heal for low level BG
Add Per-Page-Currency (#384)
    In database this is set in MerchantItem table where slot -1 is designated for setting currency.
    The Price in slot -1 sets the currency ID where:
    1 is Copper
    2 is ItemCurrency (as in Aurulite, Atlantean Glass etc)
    3 is BP
    4 is Mithril
    ItemCurrency item is set in slot -1 ItemTemplateID. MerchantItem.Price overrides ItemTemplate.Price in merchant listing.
    
    This is supposed to be backwards compatible, so Copper is selected by default and if price is zero (which is the default) in MerchantItem the ItemTemplate.Price is selected.
Merge pull request #385 from Lotendan/feature/PascalStringLength
    Add more length restrictions to WritePascalStringIntLE

1.9.7.3801

Merge pull request #382 from NetDwarf/FixTurretFacing
    Fix animist turret when target is running through
    Fix unusable animist turrets on 1.125+
Do not delve the 'weapon' stats of an instrument (#383)
    An instrument does not have DPS or SPD, Effective Damage, etc...

1.9.7.3800

Fix packets for client capped string (#381) from JVirant
    Truncate strings in packets for the following packets:
    - SendCharacterOverview (Name/Location/ClassName/RaceName)
    - SendMerchantWindow (ItemName)
    - SendRegions (ip string)
Add .vscode to .gitignore and clean up .gitignore(s) (#379)
Replace deprecated classes for Net6 (#378)
    Replace RNGCryptoServiceProvider with RandomNumberGenerator
    Replace MD5CryptoServiceProvider with MD5
    Replace SHA256Managed with SHA256
    Replace WebRequest/WebClient with HttpClient
    Add reference to System.Net.Http to DOLScriptCompilers
Add/Fix ShortDescriptions for Masterlevels (#375)
Use prepared database in Docker (#377)
Hotfix: Reset claimed keeps correctly (#376)
Use nameof to target table columns (#374)

1.9.7.3799

Perform checks during cast more often during long casts (#372)
Merge pull request #373 from NetDwarf/Fix1127JumpPoints
    Change byte order for jumpSpotId to LowEndian for 1.126+
    Stop saving ZonePoint to DB when missing and log error instead

1.9.7.3798

Fix WarMap Teleport (#369)
Fix Fall Damage Display (#368)
Replace empty arrays with Array.Empty (CA1825) (#371)
    Remove unused arrays in DisplayMessage
Fix yell angle (#370)
Move to .Net6 (#365)
    Rename occurrences of Net5 to NetCore
    Update packages:
      System.Text.Encodings.CodePages 5.0.0 -> 6.0.0
      System.Resources.Extensions 5.0.0 -> 6.0.0
      System.ServiceProcess.ServiceController 5.0.0 -> 6.0.0
      System.Diagnostics.PerformanceCounter 5.0.1 -> 6.0.0
      Microsoft.CodeAnalysis.CSharp 3.11.0 -> 4.0.1
      Microsoft.NET.Test.Sdk 16.11.0 -> 17.0.0
      Microsoft.Data.Sqlite 5.0.11 -> 5.0.12
      log4net 2.0.12 -> 2.0.13
      MySqlConnector 1.3.14 -> 2.0.0
      NUnit3TestAdapter 4.0.0 -> 4.1.0
Fix Docker Build Actions and add Documentation
Creating a Docker Build and Push Action
    Adding (manual) Docker release workflows for .Net5 and Framework
    Updating create_release workflow for better readability
    Use output variable for version/date in create_release instead of text file
Cleanup .Net5 build output (#362)
    Remove GameServerScripts.dll from build output
    Remove satellite resource languages from build
    Remove ref folder from build output
    Remove unused redundant libraries
Add SQLite Binaries for Linux / OSX to Windows Release (#361)
Github Actions Build with more verbosity (#359)
    Set verbosity of `dotnet build` to normal
Replace MySql.Data with MySqlConnector
Remove MySql.Data from DOLConfig (#355)
    Remove default options from ConnectionString
Hotfix: Workflow failing (#357)
    Builds are now cross-platform
    Remove Linux specific build
Change SQLite driver to Microsoft.Data.Sqlite
    Make builds cross-platform
    Fix Sqlite on ARM
    Change default Journal Mode to memory
Add GetValueOf(string) method to DbConfig (#354)
Hotfix: DOLConfig MySQL test function not working (#353)
    Set SslMode to None for testing connection
    Set SslMode to None on save
Hotfix: DOLConfig silently failing (#352)
Update packages
    Introduce DbConfig
    Update SharpZipLib to 1.3.3
    Update MySql.Data to 8.0.26
    Update System.Data.SQLite.Core to 1.0.115
    Update Microsoft.NET.Test.Sdk to 16.11.0
    Update NUnit3TestAdapter to 4.0.0
    Update Microsoft.CodeAnalysis.CSharp to 3.11.0 (.Net5)
Add GameServer.Version property
Fix ScriptCompiler error display
Migrate building from AppVeyor to GitHub workflow
    Enable NetFramework solution to be build/test by dotnet
    Add AssemblyInfos for Net5 builds
    Add "Create Release" Github workflow
    Move test workflows into one
    Remove test badges from README.md
Fix character creation and realm switching in 1.126+
Add proc description in style tooltips (client 1.110+)
Fix spell/song tooltip level display (for clients 1.110+)
HotFix: Keeps not resetting correctly (#342)
Merge pull request #337 from JVirant/fixEncoding
    Fix text encoding for special characters like "é"
Merge pull request #341 from DigitalBox98/Fix-ServerListUpdate
    Hotfix : only apply URL encode to user and password
Merge pull request #336 from DigitalBox98/Fix-ServerListUpdate
    ServerListUpdate : use standard UrlEncode from library
Merge pull request #338 from JVirant/noSqlPrepare
    remove useless SQL prepare statement
Merge pull request #335 from NetDwarf/FixHoverDescriptions
    Fix hover descriptions for 1.110+ clients
Merge pull request #333 from NetDwarf/FixViewLoot
    Fix bug with /mob viewloot
Merge pull request #317 from JVirant/spell_specific_tooltip_1110
    Add spellhandler's specific TooltipDelve infos for 1.110+
Merge pull request #332 from NetDwarf/FixTrainer
    HotFix for advanced Trainer not promoting base class
Merge pull request #331 from NetDwarf/FixSingleTag
    Fix bug with single tag in serverconfig.xml
Remove Travis CI (#330)
    Travis does not work anymore since PR #301
    Added test status for .Net5 build to README.md
    Fix formatting of Net 4.8 workflow name
Update appveyor.yml (#329)
    Update Appveyor Deploy Token to newest github format.
Merge pull request #314 from NetDwarf/Net5Upgrade
    Introduce .Net5 build
Merge pull request #321 from JVirant/fix_udp
    Fix UDP: refactor CombinePackets and change the UDP send buffer to 512
Merge pull request #324 from Lotendan/feature/EquipLeftHanded
    Automatically equip left-handed items to right hand
Fix Pets following player erratically (#320)
    Fix Pets following player erratically
    Change speed of pets to a similar speed of the player
Merge pull request #323 from JVirant/fix_1127
    Fix 1.127 packet PlayerHeading
    Fix 1.127 packet PlayerPosition
    Add housing deed menu
    Add /cower emote
Merge pull request #322 from JVirant/basic_1127
    Add basic 1.127 client support (from @OntheDOL)
    Add RC4 property 
    Various fixes for 1.124+ clients
Merge pull request #313 from JVirant/fix_1110_spell_level_tooltips
    Fix spell level in delve tooltip/popup on 1.110+ clients. 
Merge pull request #312 from JVirant/fix_udp_and_crypt_1110
    Fix Packet encryption for 1.110+ and UDP handling
Merge pull request #311 from JVirant/fix_position_1124
    fix not updating player XYZ in PlayerPositionUpdateHandler for 1.124+
Fix WeatherManager on Startup (#310)
    Remove regions with no zones from Regions.xml
Merge pull request #309 from NetDwarf/UpdatePackages
    Update NuGet packages
Merge pull request #300 from NetDwarf/DeprecateSelectObjects
    Deprecate explicitly parameterized SelectObject(s) queries
Fix day constant and avoid in-game time glitches (#306)
Disable parallel processing on NuGet restore
Add Github CI badge to README.md
    Change description of AppVeyor and Travis for what they are actually for
Add DOL.Integration to Github CI
    Add DOL.Integration tests instead of testing UnitTests twice (duh!)
    Change workflow name