1.9.7.3710

Update netframework workflow to 22.04
Update extensive_test_runner.yml
Update dependencies
    SharpZipLib 1.3.1->1.4.1
    log4net 2.0.14->2.0.15
    System.Text.Encoding.CodePages 6.0.0->7.0.0
    Microsoft.Data.Sqlite 5.0.17->7.0.1
    MySqlConnector 2.1.10->2.2.4
    System.ServiceProcess.ServiceController 6.0.0->7.0.0
    Microsoft.CodeAnalysis.CSharp 4.2.0->4.4.0
    Microsoft.Diagnostics.Runtime 2.1.327703->2.2.343001
    System.Diagnostics.PerformanceCounter 6.0.1->7.0.0
    Microsoft.NET.Test.Sdk 17.2.0->17.4.1
    NUnit3TestAdapter 4.2.1->4.3.1
Fix MySql database not being able to connect (#430)
    Remove SslMode=None from ConnectionString
PlayerStatistics translated / new language file created. (#429)
KeepSkin : use new keep skin by default
KeepDoor : transversal keep door need a larger size
Fix Net Framework build
Fix Net Framework build
moved almost every text from playercommands into language file. Added zone translation into /who command.
Update Github Actions
    Replace deprecated set-output with GITHUB_ENV
moved hard coded text from playercommands into language file.
Replace expired Discord link
typo fixed.
Fix /keepguard path command
    Patrol guards wouldn't use the created path previously
Add /jump to target command
Remove duplicate warnings from Champion styles
Set initial aggro of 'added' mobs to 1
Fix aggro switch on stun/mezz
    Only check for enemies when there is no current aggro
Display MythicalStatCap correctly
Make release creation manual
    Make only NetCore Linux test on PR
Fix weapons with 0 DPS doing infinite style damage
    Weapons below 1.5 DPS do zero style damage instead
Remove pet buffing from BuffMerchant
Fix casting GamePets
    Make spells available to GamePet
    Fix Bonedancer hybrid subpets when commander is a caster
Remove BP cap
Remove extra comma in money unit translations
Add GameNPC.Spawn()
    Fix MissionMaster respawn at spawnpoint instead of last location
    Make RespawnTimerCallback() use Spawn()
Force respawn MissionMaster on Tower/Keep take
Fix Market Search
Get djinn teleport realm based on current region
Set Respawn Time of MissionMaster to 2 min
Merge pull request #399 from DigitalBox98/realm_enhancement_merchant
    Add SpellTokenMerchant
    SpellTokenMerchant accepts all items from its MerchantItemList and casts the spell with the same ID of ItemTemplate.Effect
    To do multiple spells at once use SpellXCustomValues
Remove obsolete GetAngle/GetHeading methods from GameObject
Remove obsolete Point2D.HEADING_CONST
Remove unused LanguageMgr.SetLangPath
Remove obsolete Heretic LostOnPulse SpellHandlers
Remove obsolete WorldMgr distance methods
Remove obsolete FelxibleSkillBuff (typo)
Remove obsolete SingleStatAbilityBuff
Remove obsolete ObjectDatabase methods
    Remove parameterless Select methods
    Remove QueryParameter Select methods
Fix /code on startup in NetCore
Fix /object fastcreate <name> <model_id>
Fix InterceptEffect.InterceptChance (null check)
Deprecate NetFramework build and replace with NetCore
    Remove DOLConfig (is a separate solution/repository)
    Add DOLConfig binaries in release workflow
    Switch NetFramework and NetCore build
    Move NetFramework files to old folder
    Several updates to workflows
Add PerformanceStatistics for Linux
    Remove warnings from build

1.9.7.3709

fixup
refactor
Update actions versions
fixup
fixup
Update Actions
    Replace deprecated set-output with GITHUB_ENV
Replace expired Discord link
typo fixed.
Fix /keepguard path command
    Patrol guards wouldn't use the created path previously
Add /jump to target command
Remove duplicate warnings from Champion styles
Set initial aggro of 'added' mobs to 1
Fix aggro switch on stun/mezz
    Only check for enemies when there is no current aggro
Display MythicalStatCap correctly
Make release creation manual
    Make only NetCore Linux test on PR
Fix weapons with 0 DPS doing infinite style damage
    Weapons below 1.5 DPS do zero style damage instead
Remove pet buffing from BuffMerchant
Fix casting GamePets
    Make spells available to GamePet
    Fix Bonedancer hybrid subpets when commander is a caster
Remove BP cap
Remove extra comma in money unit translations
Add GameNPC.Spawn()
    Fix MissionMaster respawn at spawnpoint instead of last location
    Make RespawnTimerCallback() use Spawn()
Force respawn MissionMaster on Tower/Keep take
Fix Market Search
Get djinn teleport realm based on current region
Set Respawn Time of MissionMaster to 2 min
Merge pull request #399 from DigitalBox98/realm_enhancement_merchant
    Add SpellTokenMerchant
    SpellTokenMerchant accepts all items from its MerchantItemList and casts the spell with the same ID of ItemTemplate.Effect
    To do multiple spells at once use SpellXCustomValues
Remove obsolete GetAngle/GetHeading methods from GameObject
Remove obsolete Point2D.HEADING_CONST
Remove unused LanguageMgr.SetLangPath
Remove obsolete Heretic LostOnPulse SpellHandlers
Remove obsolete WorldMgr distance methods
Remove obsolete FelxibleSkillBuff (typo)
Remove obsolete SingleStatAbilityBuff
Remove obsolete ObjectDatabase methods
    Remove parameterless Select methods
    Remove QueryParameter Select methods
Fix /code on startup in NetCore
Fix /object fastcreate <name> <model_id>
Fix InterceptEffect.InterceptChance (null check)
Deprecate NetFramework build and replace with NetCore
    Remove DOLConfig (is a separate solution/repository)
    Add DOLConfig binaries in release workflow
    Switch NetFramework and NetCore build
    Move NetFramework files to old folder
    Several updates to workflows
Add PerformanceStatistics for Linux
    Remove warnings from build

1.9.7.3708

Update actions versions
fixup
fixup
Update Actions
    Replace deprecated set-output with GITHUB_ENV
Replace expired Discord link
typo fixed.
Fix /keepguard path command
    Patrol guards wouldn't use the created path previously
Add /jump to target command
Remove duplicate warnings from Champion styles
Set initial aggro of 'added' mobs to 1
Fix aggro switch on stun/mezz
    Only check for enemies when there is no current aggro
Display MythicalStatCap correctly
Make release creation manual
    Make only NetCore Linux test on PR
Fix weapons with 0 DPS doing infinite style damage
    Weapons below 1.5 DPS do zero style damage instead
Remove pet buffing from BuffMerchant
Fix casting GamePets
    Make spells available to GamePet
    Fix Bonedancer hybrid subpets when commander is a caster
Remove BP cap
Remove extra comma in money unit translations
Add GameNPC.Spawn()
    Fix MissionMaster respawn at spawnpoint instead of last location
    Make RespawnTimerCallback() use Spawn()
Force respawn MissionMaster on Tower/Keep take
Fix Market Search
Get djinn teleport realm based on current region
Set Respawn Time of MissionMaster to 2 min
Merge pull request #399 from DigitalBox98/realm_enhancement_merchant
    Add SpellTokenMerchant
    SpellTokenMerchant accepts all items from its MerchantItemList and casts the spell with the same ID of ItemTemplate.Effect
    To do multiple spells at once use SpellXCustomValues
Remove obsolete GetAngle/GetHeading methods from GameObject
Remove obsolete Point2D.HEADING_CONST
Remove unused LanguageMgr.SetLangPath
Remove obsolete Heretic LostOnPulse SpellHandlers
Remove obsolete WorldMgr distance methods
Remove obsolete FelxibleSkillBuff (typo)
Remove obsolete SingleStatAbilityBuff
Remove obsolete ObjectDatabase methods
    Remove parameterless Select methods
    Remove QueryParameter Select methods
Fix /code on startup in NetCore
Fix /object fastcreate <name> <model_id>
Fix InterceptEffect.InterceptChance (null check)
Deprecate NetFramework build and replace with NetCore
    Remove DOLConfig (is a separate solution/repository)
    Add DOLConfig binaries in release workflow
    Switch NetFramework and NetCore build
    Move NetFramework files to old folder
    Several updates to workflows
Add PerformanceStatistics for Linux
    Remove warnings from build

1.9.7.3707

fixup
fixup
Update Actions
    Replace deprecated set-output with GITHUB_ENV
Replace expired Discord link
typo fixed.
Fix /keepguard path command
    Patrol guards wouldn't use the created path previously
Add /jump to target command
Remove duplicate warnings from Champion styles
Set initial aggro of 'added' mobs to 1
Fix aggro switch on stun/mezz
    Only check for enemies when there is no current aggro
Display MythicalStatCap correctly
Make release creation manual
    Make only NetCore Linux test on PR
Fix weapons with 0 DPS doing infinite style damage
    Weapons below 1.5 DPS do zero style damage instead
Remove pet buffing from BuffMerchant
Fix casting GamePets
    Make spells available to GamePet
    Fix Bonedancer hybrid subpets when commander is a caster
Remove BP cap
Remove extra comma in money unit translations
Add GameNPC.Spawn()
    Fix MissionMaster respawn at spawnpoint instead of last location
    Make RespawnTimerCallback() use Spawn()
Force respawn MissionMaster on Tower/Keep take
Fix Market Search
Get djinn teleport realm based on current region
Set Respawn Time of MissionMaster to 2 min
Merge pull request #399 from DigitalBox98/realm_enhancement_merchant
    Add SpellTokenMerchant
    SpellTokenMerchant accepts all items from its MerchantItemList and casts the spell with the same ID of ItemTemplate.Effect
    To do multiple spells at once use SpellXCustomValues
Remove obsolete GetAngle/GetHeading methods from GameObject
Remove obsolete Point2D.HEADING_CONST
Remove unused LanguageMgr.SetLangPath
Remove obsolete Heretic LostOnPulse SpellHandlers
Remove obsolete WorldMgr distance methods
Remove obsolete FelxibleSkillBuff (typo)
Remove obsolete SingleStatAbilityBuff
Remove obsolete ObjectDatabase methods
    Remove parameterless Select methods
    Remove QueryParameter Select methods
Fix /code on startup in NetCore
Fix /object fastcreate <name> <model_id>
Fix InterceptEffect.InterceptChance (null check)
Deprecate NetFramework build and replace with NetCore
    Remove DOLConfig (is a separate solution/repository)
    Add DOLConfig binaries in release workflow
    Switch NetFramework and NetCore build
    Move NetFramework files to old folder
    Several updates to workflows
Add PerformanceStatistics for Linux
    Remove warnings from build

1.9.7.3706

Reduce Github workflow spam
    Only use Debug test runner
    Remove push trigger from test runner
Update setup-dotnet and checkout Github action
    Update setup-dotnet to v2
    Update checkout action to v3
Move release workflow to Linux
Add DOLConfig to release
Switch NetCore and NetFramework builds
    Change Docker to use NetCore release build
Remove DOLConfig
    DOLConfig is now an independent solution/repository
Fix /code command
New InventoryItem subclasses to create catapult, ballista and trebuchet on battlegrounds (#395)
    This PR will be linked to another PR on the db-public repo to have the corresponding 3 new ItemTemplates to complete this enhancement
    
    Co-authored-by: DigitalBox98 <digitalbox098@gmail.com>
SiegeRam : new InventoryItem class to have the possibility to create a SiegeRam by using the item (#394)
    This new class will require 4 new itemtemplates in the DB corresponding to each kind of siege ram and must be linked to DOL.GS.GameInventorySiegeRam via the ClassType field
    This PR will be linked to another PR on the db-public repo
    
    Co-authored-by: DigitalBox98 <digitalbox098@gmail.com>
Revert "Update Microsoft.Data.Sqlite to 6.0.5" (#392)
    This reverts commit 93a3d8ba766983d5f8d7e765f4601413cacb8afe.
    This fixes startup on Windows with SQLite DB
Update dependencies
Add option to have ItemCurrency with multiple Items
Merge pull request #391 from DigitalBox98/keep-bg-fix
    Fix: Banners in battlegrounds now show up correctly
Merge pull request #389 from Lotendan/bugfix/LoginLocks
    Fix locking in LoginRequestHandler
Merge pull request #386 from DigitalBox98/improved
    Adjustment on keep lord auto-heal for low level BG

1.9.7.3705

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
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...
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)

1.9.7.3704

Hotfix: Reset claimed keeps correctly (#376)
Use nameof to target table columns (#374)

1.9.7.3703

Fix Font hover descriptions (client 1.110+)
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
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

1.9.7.3702

Setup Dotnet for .Net6 create workflow
Adjust naming to NetCore and .Net6 accordingly
Rename Net5 to NetCore folder
Add references in DOLScriptCompiler by default
    Add System.Security.Cryptography.Algorithms and .Primitives to .Net5 ScriptCompiler
Replace Hash constructor with static factory
    Constructors have been deprecated
Remove unused methods in Util
Update to .Net6
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

1.9.7.3701

Adjust naming to NetCore and .Net6 accordingly
Rename Net5 to NetCore folder
Add references in DOLScriptCompiler by default
    Add System.Security.Cryptography.Algorithms and .Primitives to .Net5 ScriptCompiler
Replace Hash constructor with static factory
    Constructors have been deprecated
Remove unused methods in Util
Update to .Net6
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