From 01900b5829af7970eee2bea2efe6e74a7830a84d Mon Sep 17 00:00:00 2001 From: Shauren Date: Thu, 5 Jan 2012 13:27:17 +0100 Subject: Core/Events * Changed how quests are linked to events (no longer in Quest class) * Added quest validation when loading game_event_seasonal_questrelation * Renamed fields in new table to be consistent with game_event* tables * Corrected db data (some entries had -1 as event id) --- .../world/2012_01_05_12_world_game_event_seasonal_questrelation.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2012_01_05_12_world_game_event_seasonal_questrelation.sql (limited to 'sql') diff --git a/sql/updates/world/2012_01_05_12_world_game_event_seasonal_questrelation.sql b/sql/updates/world/2012_01_05_12_world_game_event_seasonal_questrelation.sql new file mode 100644 index 00000000000..ad6013b0edf --- /dev/null +++ b/sql/updates/world/2012_01_05_12_world_game_event_seasonal_questrelation.sql @@ -0,0 +1,5 @@ +UPDATE `game_event_seasonal_questrelation` SET `event`=8 WHERE `event`=-1; + +ALTER TABLE `game_event_seasonal_questrelation` + CHANGE `quest` `questId` int(10) unsigned NOT NULL COMMENT 'Quest Identifier', + CHANGE `event` `eventEntry` mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 'Entry of the game event'; -- cgit v1.2.3