From 4a1370de6f5550d68eb4cded71f143f0e66ffdb9 Mon Sep 17 00:00:00 2001 From: Shauren Date: Wed, 23 Oct 2024 14:13:43 +0200 Subject: SQL: Fix names --- .../hotfixes/master/2024_10_07_00_hotfixes.sql | 10 +++++++ .../hotfixes/master/2024_10_09_00_hotfixes.sql | 32 ++++++++++++++++++++++ .../hotfixes/master/2204_10_07_00_hotfixes.sql | 10 ------- .../hotfixes/master/2204_10_09_00_hotfixes.sql | 32 ---------------------- 4 files changed, 42 insertions(+), 42 deletions(-) create mode 100644 sql/updates/hotfixes/master/2024_10_07_00_hotfixes.sql create mode 100644 sql/updates/hotfixes/master/2024_10_09_00_hotfixes.sql delete mode 100644 sql/updates/hotfixes/master/2204_10_07_00_hotfixes.sql delete mode 100644 sql/updates/hotfixes/master/2204_10_09_00_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/master/2024_10_07_00_hotfixes.sql b/sql/updates/hotfixes/master/2024_10_07_00_hotfixes.sql new file mode 100644 index 00000000000..174d3d09e4c --- /dev/null +++ b/sql/updates/hotfixes/master/2024_10_07_00_hotfixes.sql @@ -0,0 +1,10 @@ +DELETE FROM `broadcast_text` WHERE `ID` IN (256584, 256583, 256581, 256930, 256580, 256562, 256546, 257387); +INSERT INTO `broadcast_text` (`Text`, `Text1`, `ID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `ChatBubbleDurationMs`, `VoiceOverPriorityID`, `SoundKitID1`, `SoundKitID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`) VALUES +('', 'Ulgrax, feed.', 256584, 0, 0, 0, 0, 0, 4, 0, 249814, 0, 0, 0, 0, 0, 0, 56819), +('', 'I appreciate you making the extermination of your futile resistance all the easier.', 256583, 0, 0, 0, 0, 0, 4, 0, 249813, 0, 0, 0, 0, 0, 0, 56819), +('', 'The pathetic conspirators have finally crawled from their holes to attack my palace?', 256581, 0, 0, 0, 0, 0, 4, 0, 249812, 0, 0, 0, 0, 0, 0, 56819), +('Invaders! Sound the alarm.', 'Invaders! Sound the alarm.', 256930, 0, 0, 0, 0, 0, 4, 246765, 253836, 0, 0, 0, 0, 0, 0, 56819), +('Otherwise you will be encumbered with additional forces.', '', 256580, 0, 0, 0, 0, 0, 4, 249811, 0, 0, 0, 0, 0, 0, 0, 56819), +('Dispatch these guards before they can raise an alarm.', '', 256562, 0, 0, 0, 0, 0, 4, 249810, 0, 0, 0, 0, 0, 0, 0, 56819), +('I have redirected forces loyal to me away from the entrance.', '', 256546, 0, 0, 0, 0, 0, 4, 249808, 0, 0, 0, 0, 0, 0, 0, 56819), +('', 'I told you that you were destined for great things. Rejoice, for you have aided the end of all things.', 257387, 0, 0, 0, 0, 0, 4, 0, 251930, 0, 0, 0, 0, 0, 0, 56819); diff --git a/sql/updates/hotfixes/master/2024_10_09_00_hotfixes.sql b/sql/updates/hotfixes/master/2024_10_09_00_hotfixes.sql new file mode 100644 index 00000000000..f6cd6cfb83c --- /dev/null +++ b/sql/updates/hotfixes/master/2024_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; diff --git a/sql/updates/hotfixes/master/2204_10_07_00_hotfixes.sql b/sql/updates/hotfixes/master/2204_10_07_00_hotfixes.sql deleted file mode 100644 index 174d3d09e4c..00000000000 --- a/sql/updates/hotfixes/master/2204_10_07_00_hotfixes.sql +++ /dev/null @@ -1,10 +0,0 @@ -DELETE FROM `broadcast_text` WHERE `ID` IN (256584, 256583, 256581, 256930, 256580, 256562, 256546, 257387); -INSERT INTO `broadcast_text` (`Text`, `Text1`, `ID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `ChatBubbleDurationMs`, `VoiceOverPriorityID`, `SoundKitID1`, `SoundKitID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`) VALUES -('', 'Ulgrax, feed.', 256584, 0, 0, 0, 0, 0, 4, 0, 249814, 0, 0, 0, 0, 0, 0, 56819), -('', 'I appreciate you making the extermination of your futile resistance all the easier.', 256583, 0, 0, 0, 0, 0, 4, 0, 249813, 0, 0, 0, 0, 0, 0, 56819), -('', 'The pathetic conspirators have finally crawled from their holes to attack my palace?', 256581, 0, 0, 0, 0, 0, 4, 0, 249812, 0, 0, 0, 0, 0, 0, 56819), -('Invaders! Sound the alarm.', 'Invaders! Sound the alarm.', 256930, 0, 0, 0, 0, 0, 4, 246765, 253836, 0, 0, 0, 0, 0, 0, 56819), -('Otherwise you will be encumbered with additional forces.', '', 256580, 0, 0, 0, 0, 0, 4, 249811, 0, 0, 0, 0, 0, 0, 0, 56819), -('Dispatch these guards before they can raise an alarm.', '', 256562, 0, 0, 0, 0, 0, 4, 249810, 0, 0, 0, 0, 0, 0, 0, 56819), -('I have redirected forces loyal to me away from the entrance.', '', 256546, 0, 0, 0, 0, 0, 4, 249808, 0, 0, 0, 0, 0, 0, 0, 56819), -('', 'I told you that you were destined for great things. Rejoice, for you have aided the end of all things.', 257387, 0, 0, 0, 0, 0, 4, 0, 251930, 0, 0, 0, 0, 0, 0, 56819); diff --git a/sql/updates/hotfixes/master/2204_10_09_00_hotfixes.sql b/sql/updates/hotfixes/master/2204_10_09_00_hotfixes.sql deleted file mode 100644 index f6cd6cfb83c..00000000000 --- a/sql/updates/hotfixes/master/2204_10_09_00_hotfixes.sql +++ /dev/null @@ -1,32 +0,0 @@ -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; -- cgit v1.2.3