aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorOvahlord <dreadkiller@gmx.de>2020-07-07 13:56:16 +0200
committerPeter Keresztes Schmidt <carbenium@outlook.com>2020-07-07 17:07:09 +0200
commit8a82403400ef49415e14530f4b55d55ef38bc74e (patch)
treef91721e1b0e91b18d8fcfe7341dc855f7483aee7 /sql
parent7987ec103e3b611daf9528be5859befa2be402cf (diff)
Core/Events: refactored battleground holiday assignments.
Instead of going with shitty bitmasks we now accept plain battleground ids instead
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2020_07_07_01_world.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_07_07_01_world.sql b/sql/updates/world/3.3.5/2020_07_07_01_world.sql
new file mode 100644
index 00000000000..080e1421c97
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_07_07_01_world.sql
@@ -0,0 +1,12 @@
+ALTER TABLE `game_event_battleground_holiday`
+ CHANGE `eventEntry` `EventEntry` TINYINT(3) UNSIGNED NOT NULL COMMENT 'game_event EventEntry identifier',
+ CHANGE `bgflag` `BattlegroundID` INT(3) UNSIGNED DEFAULT 0 NOT NULL;
+
+TRUNCATE TABLE `game_event_battleground_holiday`;
+INSERT INTO `game_event_battleground_holiday` (`EventEntry`, `BattlegroundID`) VALUES
+(18, 1),
+(19, 2),
+(20, 3),
+(21, 7),
+(53, 9),
+(54, 30);