diff options
| -rw-r--r-- | sql/updates/world/master/2021_12_21_31_world_2020_02_21_01_world.sql | 139 |
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"); |