DB/Event: Day of the Dead spawn addon fixes

Spirit's & Celebrant's should be invisible, only visible with  [Orange Marigold] and  [Bouquet of Orange Marigolds]

(cherry picked from commit eddc759cbe49d8a1170660ca825eb4af8b02caa3)

1 files changed, 27 insertions, 0 deletions

diff --git a/sql/updates/world/2015_11_06_28_world_2015_11_01_04.sql b/sql/updates/world/2015_11_06_28_world_2015_11_01_04.sql
new file mode 100644
index 00000000000..90efdecdf4f
--- /dev/null
+++ b/sql/updates/world/2015_11_06_28_world_2015_11_01_04.sql
@@ -0,0 +1,27 @@
+DELETE FROM `creature_template_addon` WHERE `entry` IN (35254, 35253, 35252, 35251, 35250, 35249, 35248, 35247, 35246, 35256, 34484, 34483, 34482, 34481, 34480, 34479, 34478, 34477, 34476, 34435, 35258, 35244, 35259, 35260, 35261);
+INSERT INTO `creature_template_addon` (`entry`, `emote`, `auras`) VALUES
+(35254, 10, "33900 30628"),
+(35253, 10, "33900 30628"),
+(35252, 10, "33900 30628"),
+(35251, 10, "33900 30628"),
+(35250, 10, "33900 30628"),
+(35249, 10, "33900 30628"),
+(35248, 10, "33900 30628"),
+(35247, 10, "33900 30628"),
+(35246, 10, "33900 30628"),
+(35256, 0, "33900 30628"),
+(34484, 0, "33900 30628"),
+(34483, 0, "33900 30628"),
+(34482, 0, "33900 30628"),
+(34481, 0, "33900 30628"),
+(34480, 0, "33900 30628"),
+(34479, 0, "33900 30628"),
+(34478, 0, "33900 30628"),
+(34477, 0, "33900 30628"),
+(34476, 0, "33900 30628"),
+(34435, 0, "33900 30628"),
+(35258, 0, "33900 30628"),
+(35244, 0, "33900 30628"),
+(35259, 0, "33900 30628"),
+(35260, 0, "33900 30628"),
+(35261, 0, "33900 30628");