I just wanted to first say thank you to all devs that have contributed to this project.
I noticed a few people were looking to adjust taming rates, and it has been mentioned how to blanket adjust all rates, but for those who wanted to change the rates by tiers I provide my query below.
This is my first SQL query so if it could be done better, faster, cleaner, whatever... I make no claims to know anything about this stuff, only that I have been reading the forums and thought I'd contribute. If this is the wrong spot to place this, you can put it wherever. --Enjoy!
--Tier 6
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.5000 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%dragon%'
GO
--Tier 5
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.6700 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%jini%' OR model LIKE '%keberos%'
GO
--Tier 4
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.7500 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%angel%' OR model LIKE '%horseman%' OR model LIKE '%tafari%' or model LIKE '%eimus%'
GO
--Tier 3
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.8200 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%hawkman%' OR model LIKE '%salamander%' OR model LIKE '%windsong%' OR model LIKE '%unicorn%'
GO
--Tier 2
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=0.9000 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%pixi%' OR model LIKE '%seiren%' OR model LIKE '%skelfighter%' OR model LIKE '%orc%' OR model LIKE '%wolf%' OR model LIKE '%octopus%'
GO
--Tier 1
UPDATE [Arcadia].[dbo].[MonsterResource]
SET [taming_percentage]=1.0000 --<<<<<<<< Adjust this to change tame success%
WHERE model LIKE '%chichen%' OR model LIKE 'beast_hen%' or model LIKE '%turtle%' OR model LIKE '%panthera%'
GO
--View Results
SELECT model, taming_id, taming_percentage, taming_exp_mod
FROM MonsterResource
WHERE (taming_percentage > 0.0000)
ORDER BY taming_percentage, taming_id