aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2012-01-05 13:27:17 +0100
committerShauren <shauren.trinity@gmail.com>2012-01-05 13:27:17 +0100
commit01900b5829af7970eee2bea2efe6e74a7830a84d (patch)
treea0110b7e81df404d8f06c2aac821c4a4e92282c9 /sql
parentfc987e9a2f948c7a68e352fe9a3024730e3ed839 (diff)
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)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2012_01_05_12_world_game_event_seasonal_questrelation.sql5
1 files changed, 5 insertions, 0 deletions
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';