DB/Creature: Midsummer Celebrant

(cherry picked from commit ae7929f7524792897de4ad453685e8f9d7d0d610)

1 files changed, 139 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_12_21_31_world_2020_02_21_01_world.sql b/sql/updates/world/master/2021_12_21_31_world_2020_02_21_01_world.sql
new file mode 100644
index 00000000000..0c81c9ace32
--- /dev/null
+++ b/sql/updates/world/master/2021_12_21_31_world_2020_02_21_01_world.sql
@@ -0,0 +1,139 @@
+-- 
+UPDATE `creature_model_info` SET `DisplayID_Other_Gender`=29243 WHERE `DisplayID` IN (16431);
+DELETE FROM `serverside_spell_effect` WHERE `SpellID` IN (46248,46249,46250,46252,46253,46254,46255,46256,46257,46258,46259);
+INSERT INTO `serverside_spell_effect` (`SpellID`, `Effect`, `EffectAura`, `EffectMiscValue1`, `ImplicitTarget1`, `ImplicitTarget2`) VALUES
+(46248, 6, 56, 25868, 1, 0),
+(46249, 6, 56, 25869, 1, 0),
+(46250, 6, 56, 25870, 1, 0),
+(46252, 6, 56, 25871, 1, 0),
+(46253, 6, 56, 25872, 1, 0),
+(46254, 6, 56, 25873, 1, 0),
+(46255, 6, 56, 25874, 1, 0),
+(46256, 6, 56, 25875, 1, 0),
+(46257, 6, 56, 25876, 1, 0),
+(46258, 6, 56, 25877, 1, 0),
+(46259, 6, 56, 25878, 1, 0);
+
+UPDATE `creature` SET `modelid`=0 WHERE `id` IN (16781);
+-- Human
+DELETE FROM `creature_addon` WHERE `guid` IN (213796,212850,213103,213801,212599,213097,152407,212291,213814,78651,213731,213791,85193,85195,213100,94614,213808,212601,213794);
+INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES
+(213796,4097,"46254"),(212850,4097,"46254"),/*(94697, 4097,"46254"),*/
+(213103,4097,"46254"),/*(94645, 4097,"46254"),*/(213801,4097,"46254"),(212599,4097,"46254"),
+(213097,4097,"46254"),/*(94661, 4097,"46254"),*/(152407,4097,"46254"),(212291,4097,"46254"),
+/*(94590, 4097,"46254"),(94563, 4097,"46254"),*/(213814,4097,"46254"),/*(212041,4097,"46254"),*/
+(78651, 4097,"46254"),/*(94617, 4097,"46254"),*/(213731,4097,"46254"),/*(211793,4097,"46254"),*/
+(213791,4097,"46254"),/*(94646, 4097,"46254"),(94584, 4097,"46254"),*/(85193, 4097,"46254"),
+/*(94741, 4097,"46254"),(94743, 4097,"46254"),*/(85195, 4097,"46254"),/*(165585,4097,"46254"),*/
+(213100,4097,"46254"),/*(94591, 4097,"46254"),(212538,4097,"46254"),(94699, 4097,"46254"),*/
+(94614, 4097,"46254"),/*(94637, 4097,"46254"),(94638, 4097,"46254"),*/(213808,4097,"46254"),
+/*(94604, 4097,"46254"),*/(212601,4097,"46254"),/*(94544, 4097,"46254"),*/(213794,4097,"46254")/*,
+(165586,4097,"46254")*/;
+-- Dwarf
+DELETE FROM `creature_addon` WHERE `guid` IN (94633,213732,213105,212598,213797,213802,213807,213738,213813,94713,213728,213115,212290,78650,213098,85192);
+INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES
+(94633,4097,'46254'),(213732,4097,'46254'),(213105,4097,'46254'),
+(212598,4097,'46254'),(213797,4097,'46254'),(213802,4097,'46254'),
+(213807,4097,'46254'),(213738,4097,'46254'),(213813,4097,'46254'),
+(94713,4097,'46254'),(213728,4097,'46254'),(213115,4097,'46254'),
+(212290,4097,'46254'),(78650,4097,'46254'),(213098,4097,'46254'),
+(85192,4097,'46254');
+-- Night Elf
+DELETE FROM `creature_addon` WHERE `guid` IN (94613,85194,213729,213803,213737,213747,212848,213748,213793,212289,213815);
+INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES
+(94613,4097,"46254"),(85194,4097,"46254"),(213729,4097,"46254"),
+(213803,4097,"46254"),(213737,4097,"46254"),(213747,4097,"46254"),
+(212848,4097,"46254"),(213748,4097,"46254"),(213793,4097,"46254"),
+(212289,4097,"46254"),(213815,4097,"46254");
+-- Orc
+DELETE FROM `creature_addon` WHERE `guid` IN (94656,210984,211543,211544,211520,211541,210685,210411,94573,210414,94736,202748,209929,210426,94667,211259,209669,211256,210946);
+INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES
+(94656,4097,"46254"),(210984,4097,"46254"),(211543,4097,"46254"),
+(211544,4097,"46254"),(211520,4097,"46254"),(211541,4097,"46254"),
+(210685,4097,"46254"),(210411,4097,"46254"),(94573,4097,"46254"),
+(210414,4097,"46254"),(94736,4097,"46254"),(202748,4097,"46254"),
+(209929,4097,"46254"),(210426,4097,"46254"),(94667,4097,"46254"),
+(211259,4097,"46254"),(209669,4097,"46254"),(211256,4097,"46254"),
+(210946,4097,"46254");
+-- Tauren
+DELETE FROM `creature_addon` WHERE `guid` IN (210427,94721,11001,210413,94625,209926,202742,210683,211521,94665,210947,211257,209928,209667,202754);
+INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES
+(210427,4097,"46254"),(94721,4097,"46254"),(11001,4097,"46254"),
+(210413,4097,"46254"),(94625,4097,"46254"),(209926,4097,"46254"),
+(202742,4097,"46254"),(210683,4097,"46254"),(211521,4097,"46254"),
+(94665,4097,"46254"),(210947,4097,"46254"),(211257,4097,"46254"),
+(209928,4097,"46254"),(209667,4097,"46254"),(202754,4097,"46254");
+-- Undead
+DELETE FROM `creature_addon` WHERE `guid` IN (209666,202743,94572,202747,210415,211260,94631,94694,202753,211542,210949,210428,210412);
+INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES
+(209666,4097,"46254"),(202743,4097,"46254"),(94572,4097,"46254"),
+(202747,4097,"46254"),(210415,4097,"46254"),(211260,4097,"46254"),
+(94631,4097,"46254"),(94694,4097,"46254"),(202753,4097,"46254"),
+(211542,4097,"46254"),(210949,4097,"46254"),(210428,4097,"46254"),
+(210412,4097,"46254");
+-- Troll
+DELETE FROM `creature_addon` WHERE `guid` IN (94666,211540,94720,210983,94626,94668,94719,211523,210684,211258,94632,202755,202741,94718);
+INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES
+(94666,4097,"46254"),(211540,4097,"46254"),(94720,4097,"46254"),
+(210983,4097,"46254"),(94626,4097,"46254"),(94668,4097,"46254"),
+(94719,4097,"46254"),(211523,4097,"46254"),(210684,4097,"46254"),
+(211258,4097,"46254"),(94632,4097,"46254"),(202755,4097,"46254"),
+(202741,4097,"46254"),(94718,4097,"46254");
+-- Gnome
+DELETE FROM `creature_addon` WHERE `guid` IN (202764,213099,78649,213806,212602,213792,213116,94714,213816,213104,212849);
+INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES
+(202764,4097,"46254"),(213099,4097,"46254"),(78649,4097,"46254"),
+(213806,4097,"46254"),(212602,4097,"46254"),(213792,4097,"46254"),
+(213116,4097,"46254"),(94714,4097,"46254"),(213816,4097,"46254"),
+(213104,4097,"46254"),(212849,4097,"46254");
+-- Draenei
+DELETE FROM `creature_addon` WHERE `guid` IN (213790,213746,213739,212292,94712,213809,213800,212600,212847,213733,202765,213114,152406,213795);
+INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES
+(213790,4097,"46254"),(213746,4097,"46254"),(213739,4097,"46254"),
+(212292,4097,"46254"),(94712,4097,"46254"),(213809,4097,"46254"),
+(213800,4097,"46254"),(212600,4097,"46254"),(212847,4097,"46254"),
+(213733,4097,"46254"),(202765,4097,"46254"),(213114,4097,"46254"),
+(152406,4097,"46254"),(213795,4097,"46254");
+-- Blood Elf
+DELETE FROM `creature_addon` WHERE `guid` IN (94624,209668,202746,94518,211522,210950,210682,209670,202752,202749,202744,94737,94722);
+INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES
+(94624,4097,"46254"),(209668,4097,"46254"),(202746,4097,"46254"),
+(94518,4097,"46254"),(211522,4097,"46254"),(210950,4097,"46254"),
+(210682,4097,"46254"),(209670,4097,"46254"),(202752,4097,"46254"),
+(202749,4097,"46254"),(202744,4097,"46254"),(94737,4097,"46254"),
+(94722,4097,"46254");
+-- Goblin
+DELETE FROM `creature_addon` WHERE `guid` IN (210948,209927,213106,213113);
+INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES
+(210948,4097,"46254"),(209927,4097,"46254"),(213106,4097,"46254"),
+(213113,4097,"46254");
+
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE  `entry`=16781;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=16781 AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`,  `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(16781, 0, 0, 0, 1, 0, 100, 0, 240000, 480000, 240000, 480000, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,  0, 'Midsummer Celebrant- OOC - Say text Horde'),
+(16781, 0, 1, 0, 1, 0, 100, 0, 240000, 480000, 240000, 480000, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,  0, 'Midsummer Celebrant- OOC - Say text Alliance'),
+(16781, 0, 2, 0, 1, 0, 100, 0, 240000, 480000, 240000, 480000, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0,  0, 'Midsummer Celebrant- OOC - Say text Gnome');
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` IN (16781);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
+(22, 1, 16781, 0, 0, 1, 1, 46256, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46256'),
+(22, 1, 16781, 0, 1, 1, 1, 46257, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46257'),
+(22, 1, 16781, 0, 2, 1, 1, 46259, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46259'),
+(22, 1, 16781, 0, 3, 1, 1, 46258, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46258'),
+(22, 1, 16781, 0, 4, 1, 1, 46248, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46248'),
+(22, 2, 16781, 0, 0, 1, 1, 46254, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46254'),
+(22, 2, 16781, 0, 1, 1, 1, 46250, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46250'),
+(22, 2, 16781, 0, 2, 1, 1, 46255, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46255'),
+(22, 2, 16781, 0, 3, 1, 1, 46252, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46252'),
+(22, 2, 16781, 0, 4, 1, 1, 46249, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46249'),
+(22, 3, 16781, 0, 0, 1, 1, 46253, 0, 0, 0, 0, 0, '', 'Celebrant - Only run SAI if Has the aura 46253');
+
+DELETE FROM `creature_text` WHERE `CreatureID` IN (16781);
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES 
+(16781, 0, 0, "The Horde fires will never be extinguished!", 12, 1, 100, 4, 0, 0, 24534, 0, "Midsummer Celebrant Horde"),
+(16781, 0, 1, "I'd like to see the Alliance try to steal our flame.", 12, 1, 100, 1, 0, 0, 24533, 0, "Midsummer Celebrant Horde"),
+(16781, 1, 0, "The Horde have tried to steal our flames.  I hope we return the favor.", 12, 7, 100, 1, 0, 0, 24531, 0, "Midsummer Celebrant Alliance"),
+(16781, 1, 1, "The Alliance fires burn strong and true!", 12, 7, 100, 4, 0, 0, 24532, 0, "Midsummer Celebrant Alliance"),
+(16781, 2, 0, "Midsummer Fire Festival is a great time to celebrate the summer!", 12, 0, 100, 4, 0, 0, 24535, 0, "Midsummer Celebrant  Goblin"),
+(16781, 2, 1, "I love the firework show at the end of Midsummer Firefestival.", 12, 0, 100, 1, 0, 0, 24536, 0, "Midsummer Celebrant  Goblin");