From 8973b4e4717c023fce5b57ae9f2ce314a5762bbb Mon Sep 17 00:00:00 2001 From: runningnak3d Date: Fri, 4 Feb 2011 09:38:39 -0700 Subject: Misc: Renamed some SQL files that were missing DB in name --- sql/updates/world/2011_02_04_0_creature_template.sql | 2 -- sql/updates/world/2011_02_04_0_game_event.sql | 15 --------------- sql/updates/world/2011_02_04_0_item_loot_template.sql | 7 ------- .../world/2011_02_04_0_world_creature_template.sql | 2 ++ sql/updates/world/2011_02_04_0_world_game_event.sql | 15 +++++++++++++++ .../world/2011_02_04_0_world_item_loot_template.sql | 7 +++++++ sql/updates/world/2011_02_04_1_game_event.sql | 2 -- sql/updates/world/2011_02_04_1_world_game_event.sql | 2 ++ 8 files changed, 26 insertions(+), 26 deletions(-) delete mode 100644 sql/updates/world/2011_02_04_0_creature_template.sql delete mode 100644 sql/updates/world/2011_02_04_0_game_event.sql delete mode 100644 sql/updates/world/2011_02_04_0_item_loot_template.sql create mode 100644 sql/updates/world/2011_02_04_0_world_creature_template.sql create mode 100644 sql/updates/world/2011_02_04_0_world_game_event.sql create mode 100644 sql/updates/world/2011_02_04_0_world_item_loot_template.sql delete mode 100644 sql/updates/world/2011_02_04_1_game_event.sql create mode 100644 sql/updates/world/2011_02_04_1_world_game_event.sql (limited to 'sql') diff --git a/sql/updates/world/2011_02_04_0_creature_template.sql b/sql/updates/world/2011_02_04_0_creature_template.sql deleted file mode 100644 index 6a90ac98761..00000000000 --- a/sql/updates/world/2011_02_04_0_creature_template.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Remove XP at kill from Flesh Eating Worm -UPDATE `creature_template` SET `flags_extra`=`flags_extra`|64 WHERE `entry`=2462; diff --git a/sql/updates/world/2011_02_04_0_game_event.sql b/sql/updates/world/2011_02_04_0_game_event.sql deleted file mode 100644 index 1e84cce9883..00000000000 --- a/sql/updates/world/2011_02_04_0_game_event.sql +++ /dev/null @@ -1,15 +0,0 @@ --- Update start date of game event for 2011 --- Based on retail IG calendar -UPDATE `game_event` SET `start_time` = '2011-06-21 00:01:00' WHERE `entry`=1; -- Midsummer Fire Festival -UPDATE `game_event` SET `start_time` = '2011-12-15 06:00:00' WHERE `entry`=2; -- Winter Veil -UPDATE `game_event` SET `start_time` = '2011-02-06 00:01:00' WHERE `entry`=3; -- Darkmoon Faire - Terrokkar Forest -UPDATE `game_event` SET `start_time` = '2011-03-06 00:01:00' WHERE `entry`=4; -- Darkmoon Faire - Elwynn Forest -UPDATE `game_event` SET `start_time` = '2011-01-02 00:01:00' WHERE `entry`=5; -- Darkmoon Faire - Mulgore -UPDATE `game_event` SET `start_time` = '2011-01-23 00:01:00' WHERE `entry`=7; -- Lunar Festival -UPDATE `game_event` SET `start_time` = '2011-02-06 00:01:00' WHERE `entry`=8; -- Love is in the Air -UPDATE `game_event` SET `start_time` = '2011-04-24 00:01:00' WHERE `entry`=9; -- Noblegarden -UPDATE `game_event` SET `start_time` = '2011-05-01 00:01:00' WHERE `entry`=10; -- Childrens Week -UPDATE `game_event` SET `start_time` = '2011-09-06 00:01:00' WHERE `entry`=11; -- Harvest Festival -UPDATE `game_event` SET `start_time` = '2011-10-18 01:00:00' WHERE `entry`=12; -- Hallow's End -UPDATE `game_event` SET `start_time` = '2011-03-03 00:01:00' WHERE `entry`=23; -- Darkmoon Faire Building - Elwynn Forest -UPDATE `game_event` SET `start_time` = '2011-09-19 00:01:00' WHERE `entry`=52; -- Pirates Day diff --git a/sql/updates/world/2011_02_04_0_item_loot_template.sql b/sql/updates/world/2011_02_04_0_item_loot_template.sql deleted file mode 100644 index aac759b58ed..00000000000 --- a/sql/updates/world/2011_02_04_0_item_loot_template.sql +++ /dev/null @@ -1,7 +0,0 @@ --- Derrok's Wand Case -DELETE FROM `item_loot_template` WHERE `entry`=30650; -INSERT INTO `item_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES -(30650,30651,100,1,1,1,1), -- Dertrok's First Wand -(30650,30652,100,1,2,1,1), -- Dertrok's Second Wand -(30650,30653,100,1,3,1,1), -- Dertrok's Third Wand -(30650,30654,100,1,4,1,1); -- Dertrok's Fourth Wand diff --git a/sql/updates/world/2011_02_04_0_world_creature_template.sql b/sql/updates/world/2011_02_04_0_world_creature_template.sql new file mode 100644 index 00000000000..6a90ac98761 --- /dev/null +++ b/sql/updates/world/2011_02_04_0_world_creature_template.sql @@ -0,0 +1,2 @@ +-- Remove XP at kill from Flesh Eating Worm +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|64 WHERE `entry`=2462; diff --git a/sql/updates/world/2011_02_04_0_world_game_event.sql b/sql/updates/world/2011_02_04_0_world_game_event.sql new file mode 100644 index 00000000000..1e84cce9883 --- /dev/null +++ b/sql/updates/world/2011_02_04_0_world_game_event.sql @@ -0,0 +1,15 @@ +-- Update start date of game event for 2011 +-- Based on retail IG calendar +UPDATE `game_event` SET `start_time` = '2011-06-21 00:01:00' WHERE `entry`=1; -- Midsummer Fire Festival +UPDATE `game_event` SET `start_time` = '2011-12-15 06:00:00' WHERE `entry`=2; -- Winter Veil +UPDATE `game_event` SET `start_time` = '2011-02-06 00:01:00' WHERE `entry`=3; -- Darkmoon Faire - Terrokkar Forest +UPDATE `game_event` SET `start_time` = '2011-03-06 00:01:00' WHERE `entry`=4; -- Darkmoon Faire - Elwynn Forest +UPDATE `game_event` SET `start_time` = '2011-01-02 00:01:00' WHERE `entry`=5; -- Darkmoon Faire - Mulgore +UPDATE `game_event` SET `start_time` = '2011-01-23 00:01:00' WHERE `entry`=7; -- Lunar Festival +UPDATE `game_event` SET `start_time` = '2011-02-06 00:01:00' WHERE `entry`=8; -- Love is in the Air +UPDATE `game_event` SET `start_time` = '2011-04-24 00:01:00' WHERE `entry`=9; -- Noblegarden +UPDATE `game_event` SET `start_time` = '2011-05-01 00:01:00' WHERE `entry`=10; -- Childrens Week +UPDATE `game_event` SET `start_time` = '2011-09-06 00:01:00' WHERE `entry`=11; -- Harvest Festival +UPDATE `game_event` SET `start_time` = '2011-10-18 01:00:00' WHERE `entry`=12; -- Hallow's End +UPDATE `game_event` SET `start_time` = '2011-03-03 00:01:00' WHERE `entry`=23; -- Darkmoon Faire Building - Elwynn Forest +UPDATE `game_event` SET `start_time` = '2011-09-19 00:01:00' WHERE `entry`=52; -- Pirates Day diff --git a/sql/updates/world/2011_02_04_0_world_item_loot_template.sql b/sql/updates/world/2011_02_04_0_world_item_loot_template.sql new file mode 100644 index 00000000000..aac759b58ed --- /dev/null +++ b/sql/updates/world/2011_02_04_0_world_item_loot_template.sql @@ -0,0 +1,7 @@ +-- Derrok's Wand Case +DELETE FROM `item_loot_template` WHERE `entry`=30650; +INSERT INTO `item_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(30650,30651,100,1,1,1,1), -- Dertrok's First Wand +(30650,30652,100,1,2,1,1), -- Dertrok's Second Wand +(30650,30653,100,1,3,1,1), -- Dertrok's Third Wand +(30650,30654,100,1,4,1,1); -- Dertrok's Fourth Wand diff --git a/sql/updates/world/2011_02_04_1_game_event.sql b/sql/updates/world/2011_02_04_1_game_event.sql deleted file mode 100644 index 0d668a4e429..00000000000 --- a/sql/updates/world/2011_02_04_1_game_event.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Winter Veil: Gifts had wrong duration. It should be 8 days and 3 hours in minutes (25 Dec -> 2 Jan) -UPDATE `game_event` SET `length`=11700 WHERE `entry`=54; diff --git a/sql/updates/world/2011_02_04_1_world_game_event.sql b/sql/updates/world/2011_02_04_1_world_game_event.sql new file mode 100644 index 00000000000..0d668a4e429 --- /dev/null +++ b/sql/updates/world/2011_02_04_1_world_game_event.sql @@ -0,0 +1,2 @@ +-- Winter Veil: Gifts had wrong duration. It should be 8 days and 3 hours in minutes (25 Dec -> 2 Jan) +UPDATE `game_event` SET `length`=11700 WHERE `entry`=54; -- cgit v1.2.3