From b3a502ddb9f08a1cc3ef082263567898c7b0a3eb Mon Sep 17 00:00:00 2001 From: Meji Date: Sat, 14 Sep 2024 13:06:03 +0200 Subject: Core/Characters: Added missing Earthen creation data (#30220) --- sql/updates/world/master/2024_09_14_01_world.sql | 30 ++++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 sql/updates/world/master/2024_09_14_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2024_09_14_01_world.sql b/sql/updates/world/master/2024_09_14_01_world.sql new file mode 100644 index 00000000000..3d5421a852e --- /dev/null +++ b/sql/updates/world/master/2024_09_14_01_world.sql @@ -0,0 +1,30 @@ +DELETE FROM `class_expansion_requirement` WHERE `RaceID` IN (84, 85) AND `ClassID` IN (1, 2, 3, 4, 5, 7, 8, 9, 10); +INSERT INTO `class_expansion_requirement` (`ClassID`, `RaceID`, `ActiveExpansionLevel`, `AccountExpansionLevel`) VALUES +(1, 84, 10, 10), +(2, 84, 10, 10), +(3, 84, 10, 10), +(4, 84, 10, 10), +(5, 84, 10, 10), +(7, 84, 10, 10), +(8, 84, 10, 10), +(9, 84, 10, 10), +(10, 84, 10, 10), +(1, 85, 10, 10), +(2, 85, 10, 10), +(3, 85, 10, 10), +(4, 85, 10, 10), +(5, 85, 10, 10), +(7, 85, 10, 10), +(8, 85, 10, 10), +(9, 85, 10, 10), +(10, 85, 10, 10); + +DELETE FROM `player_racestats` WHERE `race` IN (84, 85); +INSERT INTO `player_racestats` (`race`, `str`, `agi`, `sta`, `inte`) VALUES +(84, 0, 0, 0, 0), +(85, 0, 0, 0, 0); + +DELETE FROM `race_unlock_requirement` WHERE `raceID` IN (84, 85); +INSERT INTO `race_unlock_requirement` (`raceID`, `expansion`, `achievementId`) VALUES +(84, 10, 40307), +(85, 10, 40307); -- cgit v1.2.3