diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/hotfixes/master/2204_10_09_00_hotfixes.sql | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/master/2204_10_09_00_hotfixes.sql b/sql/updates/hotfixes/master/2204_10_09_00_hotfixes.sql new file mode 100644 index 00000000000..f6cd6cfb83c --- /dev/null +++ b/sql/updates/hotfixes/master/2204_10_09_00_hotfixes.sql @@ -0,0 +1,32 @@ +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=-3, `HealthItemLevelCurveID`=0, `MaxLevel`=-1, `MinLevelType`=1, `MaxLevelType`=3, `TargetLevelDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=2435; +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=10, `HealthItemLevelCurveID`=79585, `DamageItemLevelCurveID`=79586, `MinLevel`=10, `MaxLevel`=80, `MinLevelType`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=2696; +UPDATE `content_tuning` SET `Flags`=0, `MinLevel`=60, `MaxLevel`=0, `MaxLevelType`=2, `TargetLevelDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=3066; +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=10, `HealthItemLevelCurveID`=0, `MinLevel`=77, `MaxLevel`=80, `MinLevelType`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=3065; +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=-3, `HealthItemLevelCurveID`=0, `MaxLevel`=-1, `MinLevelType`=1, `MaxLevelType`=2, `TargetLevelDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=2732; +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=10, `HealthItemLevelCurveID`=77585, `DamageItemLevelCurveID`=77584, `MinLevel`=78, `MaxLevel`=80, `MinLevelType`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=2807; +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=10, `HealthItemLevelCurveID`=77585, `DamageItemLevelCurveID`=77584, `MinLevel`=75, `MaxLevel`=78, `MinLevelType`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=2806; +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=10, `HealthItemLevelCurveID`=77585, `DamageItemLevelCurveID`=77584, `MinLevel`=73, `MaxLevel`=75, `MinLevelType`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=2805; +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=10, `HealthItemLevelCurveID`=77585, `DamageItemLevelCurveID`=77584, `MinLevel`=70, `MaxLevel`=73, `MinLevelType`=0, `TargetLevelDelta`=-2, `TargetLevelMaxDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID` IN (2804, 2797); +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=10, `HealthItemLevelCurveID`=77585, `DamageItemLevelCurveID`=77584, `MinLevel`=75, `MaxLevel`=78, `MinLevelType`=0, `TargetLevelDelta`=-2, `TargetLevelMaxDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=2799; +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=10, `HealthItemLevelCurveID`=77585, `DamageItemLevelCurveID`=77584, `MinLevel`=73, `MaxLevel`=75, `MinLevelType`=0, `TargetLevelDelta`=-2, `TargetLevelMaxDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=2798; +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=10, `HealthItemLevelCurveID`=77585, `DamageItemLevelCurveID`=77584, `MinLevel`=78, `MaxLevel`=80, `MinLevelType`=0, `TargetLevelDelta`=-4, `TargetLevelMaxDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=2762; +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=10, `HealthItemLevelCurveID`=79497, `DamageItemLevelCurveID`=79498, `MinLevel`=70, `MaxLevel`=80, `MinLevelType`=0, `TargetLevelDelta`=-2, `TargetLevelMaxDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=2677; +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=-3, `HealthItemLevelCurveID`=0, `MinLevel`=10, `MaxLevel`=-3, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=3064; +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=-3, `HealthItemLevelCurveID`=0, `MinLevelType`=3, `TargetLevelDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=3062; +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=-3, `HealthItemLevelCurveID`=0, `MinLevelType`=2, `TargetLevelDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=1391; +UPDATE `content_tuning` SET `Flags`=0, `ExpansionID`=-3, `HealthItemLevelCurveID`=0, `MinLevelType`=1, `MaxLevelType`=2, `TargetLevelDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=1279; +UPDATE `content_tuning` SET `Flags`=64, `ExpansionID`=7, `HealthItemLevelCurveID`=0, `MinLevel`=35, `MaxLevel`=1, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `TargetLevelMaxDelta`=255, `TargetLevelMin`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=3060; +UPDATE `content_tuning` SET `Flags`=64, `ExpansionID`=7, `HealthItemLevelCurveID`=0, `MinLevel`=40, `MaxLevel`=1, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID` IN (3059, 3058); +UPDATE `content_tuning` SET `Flags`=64, `ExpansionID`=7, `HealthItemLevelCurveID`=0, `MinLevel`=35, `MaxLevel`=1, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID` IN (3057, 3056); +UPDATE `content_tuning` SET `Flags`=64, `ExpansionID`=7, `HealthItemLevelCurveID`=0, `MinLevel`=10, `MaxLevel`=1, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID` IN (3055, 3054, 3053, 3052, 3051, 3050, 3048); +UPDATE `content_tuning` SET `Flags`=96, `ExpansionID`=7, `HealthItemLevelCurveID`=0, `MinLevel`=10, `MaxLevel`=1, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `TargetLevelMaxDelta`=255, `TargetLevelMin`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=3049; +UPDATE `content_tuning` SET `Flags`=96, `ExpansionID`=7, `HealthItemLevelCurveID`=11753, `DamageItemLevelCurveID`=0, `MinLevel`=10, `MaxLevel`=1, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=3047; +UPDATE `content_tuning` SET `Flags`=64, `ExpansionID`=7, `HealthItemLevelCurveID`=8426, `DamageItemLevelCurveID`=0, `MinLevel`=10, `MaxLevel`=1, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `TargetLevelMaxDelta`=255, `TargetLevelMin`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=3046; +UPDATE `content_tuning` SET `Flags`=64, `ExpansionID`=7, `HealthItemLevelCurveID`=8426, `DamageItemLevelCurveID`=0, `MinLevel`=30, `MaxLevel`=1, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID` IN (3045, 3043); +UPDATE `content_tuning` SET `Flags`=64, `ExpansionID`=7, `HealthItemLevelCurveID`=8426, `DamageItemLevelCurveID`=0, `MinLevel`=10, `MaxLevel`=1, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=3044; +UPDATE `content_tuning` SET `Flags`=64, `ExpansionID`=7, `HealthItemLevelCurveID`=8426, `DamageItemLevelCurveID`=0, `MinLevel`=20, `MaxLevel`=1, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=3042; +UPDATE `content_tuning` SET `Flags`=64, `ExpansionID`=7, `HealthItemLevelCurveID`=8426, `DamageItemLevelCurveID`=0, `MinLevel`=20, `MaxLevel`=1, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `TargetLevelMaxDelta`=255, `TargetLevelMin`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=3041; +UPDATE `content_tuning` SET `Flags`=96, `ExpansionID`=7, `HealthItemLevelCurveID`=0, `MinLevel`=10, `MaxLevel`=1, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `TargetLevelMin`=10, `TargetLevelMax`=61, `MinItemLevel`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID` IN (3040, 3038, 3036, 3035, 3034, 3033); +UPDATE `content_tuning` SET `Flags`=96, `ExpansionID`=7, `HealthItemLevelCurveID`=0, `MinLevel`=10, `MaxLevel`=1, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `TargetLevelMin`=10, `TargetLevelMax`=60, `MinItemLevel`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=3039; +UPDATE `content_tuning` SET `Flags`=96, `ExpansionID`=7, `HealthItemLevelCurveID`=0, `MinLevel`=10, `MaxLevel`=1, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=3037; +UPDATE `content_tuning` SET `Flags`=64, `ExpansionID`=7, `HealthItemLevelCurveID`=0, `MinLevel`=10, `MaxLevel`=1, `MinLevelType`=0, `MaxLevelType`=3, `TargetLevelDelta`=0, `TargetLevelMin`=10, `TargetLevelMax`=61, `MinItemLevel`=0, `QuestXpMultiplier`=1 WHERE `VerifiedBuild`>0 AND `ID`=3032; |