aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2011_04_22_04_world_conditions.sql (renamed from sql/updates/world/2011_04_23_04_world_conditions.sql)0
-rw-r--r--sql/updates/world/2011_04_22_05_world_gossips.sql (renamed from sql/updates/world/2011_04_23_05_world_gossips.sql)0
-rw-r--r--sql/updates/world/2011_04_22_06_world_creatures.sql (renamed from sql/updates/world/2011_04_23_06_world_creatures.sql)0
-rw-r--r--sql/updates/world/2011_04_22_07_world_script_texts.sql (renamed from sql/updates/world/2011_04_23_07_world_script_texts.sql)0
-rw-r--r--sql/updates/world/2011_04_22_07_world_scriptname.sql (renamed from sql/updates/world/2011_04_23_07_world_scriptname.sql)0
-rw-r--r--sql/updates/world/2011_04_22_07_world_smart_scripts.sql (renamed from sql/updates/world/2011_04_23_07_world_smart_scripts.sql)0
-rw-r--r--sql/updates/world/2011_04_23_00_world_misc.sql35
7 files changed, 35 insertions, 0 deletions
diff --git a/sql/updates/world/2011_04_23_04_world_conditions.sql b/sql/updates/world/2011_04_22_04_world_conditions.sql
index 60c98c44ef6..60c98c44ef6 100644
--- a/sql/updates/world/2011_04_23_04_world_conditions.sql
+++ b/sql/updates/world/2011_04_22_04_world_conditions.sql
diff --git a/sql/updates/world/2011_04_23_05_world_gossips.sql b/sql/updates/world/2011_04_22_05_world_gossips.sql
index db86ec8942e..db86ec8942e 100644
--- a/sql/updates/world/2011_04_23_05_world_gossips.sql
+++ b/sql/updates/world/2011_04_22_05_world_gossips.sql
diff --git a/sql/updates/world/2011_04_23_06_world_creatures.sql b/sql/updates/world/2011_04_22_06_world_creatures.sql
index 91df3492336..91df3492336 100644
--- a/sql/updates/world/2011_04_23_06_world_creatures.sql
+++ b/sql/updates/world/2011_04_22_06_world_creatures.sql
diff --git a/sql/updates/world/2011_04_23_07_world_script_texts.sql b/sql/updates/world/2011_04_22_07_world_script_texts.sql
index 6b2ac8db2d4..6b2ac8db2d4 100644
--- a/sql/updates/world/2011_04_23_07_world_script_texts.sql
+++ b/sql/updates/world/2011_04_22_07_world_script_texts.sql
diff --git a/sql/updates/world/2011_04_23_07_world_scriptname.sql b/sql/updates/world/2011_04_22_07_world_scriptname.sql
index 656d2bb8d44..656d2bb8d44 100644
--- a/sql/updates/world/2011_04_23_07_world_scriptname.sql
+++ b/sql/updates/world/2011_04_22_07_world_scriptname.sql
diff --git a/sql/updates/world/2011_04_23_07_world_smart_scripts.sql b/sql/updates/world/2011_04_22_07_world_smart_scripts.sql
index fa7ebba48ad..fa7ebba48ad 100644
--- a/sql/updates/world/2011_04_23_07_world_smart_scripts.sql
+++ b/sql/updates/world/2011_04_22_07_world_smart_scripts.sql
diff --git a/sql/updates/world/2011_04_23_00_world_misc.sql b/sql/updates/world/2011_04_23_00_world_misc.sql
new file mode 100644
index 00000000000..2aacfab9920
--- /dev/null
+++ b/sql/updates/world/2011_04_23_00_world_misc.sql
@@ -0,0 +1,35 @@
+-- Egg Rush! should only be castable in Azure Watch, Dolannar, Goldshire, haranos, Bloodhoof Village, Brill, Falconwing Square, Razor Hill
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=61810;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`Comment`) VALUES
+(17,0,61810,1,23,3576, 'Egg Rush! - Requires Azure Watch'), -- OR
+(17,0,61810,2,23,186, 'Egg Rush! - Requires Dolanaar'), -- OR
+(17,0,61810,3,23,87, 'Egg Rush! - Requires Goldshire'), -- OR
+(17,0,61810,4,23,131, 'Egg Rush! - Requires Kharanos'), -- OR
+(17,0,61810,5,23,222, 'Egg Rush! - Requires Bloodhoof Village'), -- OR
+(17,0,61810,6,23,159, 'Egg Rush! - Requires Brill'), -- OR
+(17,0,61810,7,23,2118, 'Egg Rush! - Requires Brill Town Hall'), -- OR
+(17,0,61810,8,23,3665, 'Egg Rush! - Requires Falconwing Square'), -- OR
+(17,0,61810,9,23,362, 'Egg Rush! - Requires Razor Hill'), -- OR
+(17,0,61810,10,23,2337, 'Egg Rush! - Requires Razor Hill Barracks');
+
+-- Template updates for gameobject Brightly Colored Egg
+UPDATE `gameobject_template` SET `faction`=35 WHERE `entry` BETWEEN 113768 AND 113772; -- Brightly Colored Egg's
+UPDATE `gameobject_template` SET `data1`=26884,`data7`=194047 WHERE `entry`=113772 AND `WDBVerified`=1; -- Brightly Colored Egg, made up GOB, no reason to be different from others
+
+-- Loot
+DELETE FROM `gameobject_loot_template` WHERE `entry`=4984;
+DELETE FROM `item_loot_template` WHERE `entry`=45072;
+INSERT INTO `item_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES
+(45072,44791,95,1,1,1,1), -- Noblegarden Chocolate
+(45072,19028,0.2,1,1,1,1), -- Elegant Dress reminder of group 1
+(45072,6833,0.9,1,1,1,1), -- White Tuxedo Shirt
+(45072,6835,0.9,1,1,1,1), -- Black Tuxedo Pants
+(45072,45073,0.6,1,1,1,1), -- Spring Flowers
+(45072,44800,0.6,1,1,1,1), -- Spring Robes
+(45072,44794,0.4,1,1,1,1), -- Spring Rabbit's Foot
+(45072,44803,0.5,1,1,1,1), -- Spring Circlet
+(45072,44792,0.9,1,1,1,1), -- Blossoming Branch
+(45072,44806,-100,1,0,1,1); -- Brightly Colored Shell Fragment
+
+-- Creature template
+UPDATE `creature_template` SET `equipment_id`=10102 WHERE `entry` =32836;