diff options
| -rw-r--r-- | sql/updates/world/2012_01_23_00_world_game_event_seasonal_questrelation.sql | 7 | ||||
| -rw-r--r-- | sql/updates/world/2012_01_29_00_world_conditions.sql | 2 |
2 files changed, 7 insertions, 2 deletions
diff --git a/sql/updates/world/2012_01_23_00_world_game_event_seasonal_questrelation.sql b/sql/updates/world/2012_01_23_00_world_game_event_seasonal_questrelation.sql index 0bf0b4bb1e5..40bf28a1ead 100644 --- a/sql/updates/world/2012_01_23_00_world_game_event_seasonal_questrelation.sql +++ b/sql/updates/world/2012_01_23_00_world_game_event_seasonal_questrelation.sql @@ -1,4 +1,9 @@ -DELETE FROM `game_event_seasonal_questrelation` WHERE `questId` IN (8619,8635,8636,8642,8643,8644,8645,8646,8647,8648,8649,8650,8651,8652,8653,8654,8670,8671,8672,8673,8674,8675,8676,8677,8678,8679,8680,8681,8682,8683,8684,8685,8686,8688,8713,8714,8715,8716,8717,8718,8719,8720,8721,8722,8723,8724,8725,8726,8727,8862,8863,8864,8865,8866,8867,8870,8871,8872,8873,8874,8875,8876,8877,8878,8879,8880,8881,8882,8883,13012,13013,13014,13015,13016,13017,13018,13019,13020,13021,13022,13023,13024,13025,13026,13027,13028,13029,13030,13031,13032,13033,13065,13066,13067,11120,11431,11442,11409,11318,11117,11400,11419,11118,11122,11293,11294,11321,11407,11408,11412,11413,11441,11446,11454,11486,11487,12020,12022,12318,12193,12062,12491,11447,12191,12492,12194,12192,12278,12306,12420,12421,13932,13649,13931,11127,11320,11347,11437,11438,11444,11445,9319,9322,9323,9324,9325,9326,9330,9331,9332,9339,9365,9367,9368,9386,9388,9389,11657,11691,11731,11882,11883,11886,11891,11915,11917,11921,11922,11923,11924,11925,11926,11933,11935,11947,11948,11952,11953,11954,11955,11964,11966,11970,11971,11972,12012,14488,24597,24609,24656,24657,24745,24848,24849,24666,24792,24804,24611,24536,24612,24635,24636,24655,24610,24629,24614,24576,24613,24615,24638,24645,24647,24648,24649,24650,24651,24652,24658,24659,24660,24662,24663,24664,24665,24793,24805,24850,24851,24541,14483,24661); +DELETE FROM `game_event_seasonal_questrelation` WHERE `questId` IN (9319,9322,9323,9324,9325,9326,9330,9331,9332,9339,9365,9367,9368,9386,9388,9389,11657,11691,11731,11882,11883,11886,11891,11915,11917,11921,11922,11923,11924,11925,11926,11933,11935,11947,11948,11952,11953,11954,11955,11964,11966,11970,11971,11972,12012) AND `eventEntry`=1; +DELETE FROM `game_event_seasonal_questrelation` WHERE `questId` IN (8619,8635,8636,8642,8643,8644,8645,8646,8647,8648,8649,8650,8651,8652,8653,8654,8670,8671,8672,8673,8674,8675,8676,8677,8678,8679,8680,8681,8682,8683,8684,8685,8686,8688,8713,8714,8715,8716,8717,8718,8719,8720,8721,8722,8723,8724,8725,8726,8727,8862,8863,8864,8865,8866,8867,8870,8871,8872,8873,8874,8875,8876,8877,8878,8879,8880,8881,8882,8883,13012,13013,13014,13015,13016,13017,13018,13019,13020,13021,13022,13023,13024,13025,13026,13027,13028,13029,13030,13031,13032,13033,13065,13066,13067) AND `eventEntry`=7; +DELETE FROM `game_event_seasonal_questrelation` WHERE `questId` IN (14488,24597,24609,24656,24657,24745,24848,24849,24666,24792,24804,24611,24536,24612,24635,24636,24655,24610,24629,24614,24576,24613,24615,24638,24645,24647,24648,24649,24650,24651,24652,24658,24659,24660,24662,24663,24664,24665,24793,24805,24850,24851,24541,14483,24661) AND `eventEntry`=8; +DELETE FROM `game_event_seasonal_questrelation` WHERE `questId` IN (13479,13480,13483,13484,13502,13503) AND `eventEntry`=9; +DELETE FROM `game_event_seasonal_questrelation` WHERE `questId` IN (11120,11431,11442,11409,11318,11117,11400,11419,11118,11122,11293,11294,11321,11407,11408,11412,11413,11441,11446,11454,11486,11487,12020,12022,12318,12193,12062,12491,11447,12191,12492,12194,12192,12278,12306,12420,12421,13932,13649,13931,11127,11320,11347,11437,11438,11444,11445) AND `eventEntry`=24; + INSERT INTO `game_event_seasonal_questrelation` (`questId`,`eventEntry`) VALUES (8619,7), (8635,7), diff --git a/sql/updates/world/2012_01_29_00_world_conditions.sql b/sql/updates/world/2012_01_29_00_world_conditions.sql index a5a0cec6fd3..8e8c5b4734d 100644 --- a/sql/updates/world/2012_01_29_00_world_conditions.sql +++ b/sql/updates/world/2012_01_29_00_world_conditions.sql @@ -1 +1 @@ -ALTER TABLE conditions ADD COLUMN `SourceId` INT(10) NOT NULL AFTER SourceEntry
\ No newline at end of file +ALTER TABLE conditions ADD COLUMN `SourceId` INT(10) NOT NULL AFTER SourceEntry; |