diff options
| -rw-r--r-- | sql/updates/world/master/2022_01_19_07_world_2020_06_29_00_world.sql | 66 |
1 files changed, 66 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_19_07_world_2020_06_29_00_world.sql b/sql/updates/world/master/2022_01_19_07_world_2020_06_29_00_world.sql new file mode 100644 index 00000000000..12624a9f09f --- /dev/null +++ b/sql/updates/world/master/2022_01_19_07_world_2020_06_29_00_world.sql @@ -0,0 +1,66 @@ +-- +DELETE FROM `creature_text` WHERE `CreatureID`=17109; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(17109, 0, 0, 'Hahaha! That fool will never find out what I\'m up to! Or, if he does, it\'ll be too late for the draenei!', 12, 0, 100, 11, 0, 0, 14094, 0, 'Cersei Dusksinger'), +(17109, 0, 1, 'These orcs are fools! So much power nearby just waiting to be taken, and all they do is sit on their hands and watch while others plunder the riches!', 12, 0, 100, 5, 0, 0, 14095, 0, 'Cersei Dusksinger'), +(17109, 0, 2, 'I cannot wait to see the results of this latest batch!', 12, 0, 100, 1, 0, 0, 14096, 0, 'Cersei Dusksinger'), +(17109, 0, 3, 'Avuun dares to oppose me?! I will crush him! When I am done with the draenei, they\'ll wish that they were Lost Ones!', 12, 0, 100, 15, 0, 0, 14097, 0, 'Cersei Dusksinger'), +(17109, 0, 4, 'Oh, would you please stop checking your nails and spanking yourself, for one moment? Really, no one cares!', 12, 0, 100, 6, 0, 0, 14098, 0, 'Cersei Dusksinger'), +(17109, 0, 5, 'Are you hungry? I\'m hungry. I just can\'t stand the thought of cured ham steak from Thultash again. If only we could get some of that succulent roasted quail!', 12, 0, 100, 6, 0, 0, 14099, 0, 'Cersei Dusksinger'), +(17109, 1, 0, 'You have something to say to my face?', 12, 0, 100, 6, 0, 0, 14106, 0, 'Cersei Dusksinger'), +(17109, 2, 0, 'I thought not!', 12, 0, 100, 11, 0, 0, 14107, 0, 'Cersei Dusksinger'), +(17109, 3, 0, 'I need some fresh air, not that there\'s any to be had in this swamp! I\'m going out for a bit. Tidy up a bit while I\'m gone, would you?', 12, 0, 100, 1, 0, 0, 14101, 0, 'Cersei Dusksinger'), +(17109, 4, 0, 'Must you follow me everywhere? <sigh>', 12, 0, 100, 6, 0, 0, 14102, 0, 'Cersei Dusksinger'); + +DELETE FROM `smart_scripts` WHERE `entryorguid`=17109 AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN 1710900 AND 1710907 AND `source_type`=9; +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_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(17109, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Spawn - Set Event Phase 1"), +(17109, 0, 1, 0, 25, 0, 100, 0, 0, 0, 0, 0, 0, 11, 8722, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Reset - Cast Summon Succubus"), +(17109, 0, 2, 0, 1, 1, 100, 0, 5000, 5000, 100000, 100000, 0, 80, 1710900, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - Out of Combat - Run Script 1 (Phase 1)"), +(17109, 0, 3, 0, 1, 2, 100, 0, 100000, 100000, 100000, 100000, 0, 80, 1710901, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - Out of Combat - Run Script 2 (Phase 2)"), +(17109, 0, 4, 0, 40, 0, 100, 0, 2, 1710900, 0, 0, 0, 80, 1710902, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Waypoint 2 Reached (Path 1) - Run Script 3"), +(17109, 0, 5, 0, 40, 0, 100, 0, 4, 1710900, 0, 0, 0, 80, 1710903, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Waypoint 4 Reached (Path 1) - Run Script 4"), +(17109, 0, 6, 0, 1, 4, 100, 0, 100000, 100000, 100000, 100000, 0, 80, 1710904, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - Out of Combat - Run Script 5 (Phase 3)"), +(17109, 0, 7, 0, 1, 8, 100, 0, 100000, 100000, 100000, 100000, 0, 80, 1710905, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - Out of Combat - Run Script 6 (Phase 4)"), +(17109, 0, 8, 0, 40, 0, 100, 0, 4, 1710901, 0, 0, 0, 80, 1710906, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Waypoint 4 Reached (Path 2) - Run Script 7"), +(17109, 0, 9, 0, 40, 0, 100, 0, 8, 1710901, 0, 0, 0, 80, 1710907, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Waypoint 8 Reached (Path 2) - Run Script 8"), +(1710900, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 1 - Set Event Phase 0"), +(1710900, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 1 - Say Line 0"), +(1710900, 9, 2, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 27705, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 1 - Say Line 0 (Lorrin Foxfire)"), +(1710900, 9, 3, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 19, 1386, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 1 - Say Line 1 (Rogvar)"), +(1710900, 9, 4, 0, 0, 0, 100, 0, 55000, 55000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 1 - Say Line 0"), +(1710900, 9, 5, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 27705, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 1 - Say Line 0 (Lorrin Foxfire)"), +(1710900, 9, 6, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 19, 1386, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 1 - Say Line 1 (Rogvar)"), +(1710900, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 1 - Set Event Phase 2"), +(1710901, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 2 - Set Event Phase 0"), +(1710901, 9, 1, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 12807, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 2 - Say Line 0 (Greshka)"), +(1710901, 9, 2, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 988, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 2 - Say Line 0 (Kartosh)"), +(1710901, 9, 3, 0, 0, 0, 100, 0, 9000, 9000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 1386, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 2 - Say Line 0 (Rogvar)"), +(1710901, 9, 4, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 53, 0, 1710900, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 2 - Start Waypoint 1"), +(1710902, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 54, 18000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 3 - Pause Waypoint"), +(1710902, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 3 - Say Line 1"), +(1710902, 9, 2, 0, 0, 0, 100, 0, 14000, 14000, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 3 - Say Line 2"), +(1710902, 9, 3, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 5, 14, 0, 0, 0, 0, 0, 19, 12807, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 3 - Play Emote Rude (Greshka)"), +(1710902, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 5, 14, 0, 0, 0, 0, 0, 19, 988, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 3 - Play Emote Rude (Kartosh)"), +(1710902, 9, 5, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 5, 14, 0, 0, 0, 0, 0, 19, 1386, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 3 - Play Emote Rude (Rogvar)"), +(1710903, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0.952855, "Cersei Dusksinger - On Script 4 - Set Orientation"), +(1710903, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 4 - Set Event Phase 3"), +(1710904, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 5 - Set Event Phase 0"), +(1710904, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 5 - Say Line 0"), +(1710904, 9, 2, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 27705, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 5 - Say Line 0 (Lorrin Foxfire)"), +(1710904, 9, 3, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 19, 1386, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 5 - Say Line 1 (Rogvar)"), +(1710904, 9, 4, 0, 0, 0, 100, 0, 55000, 55000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 5 - Say Line 0"), +(1710904, 9, 5, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 27705, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 5 - Say Line 0 (Lorrin Foxfire)"), +(1710904, 9, 6, 0, 0, 0, 100, 0, 15000, 15000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 19, 1386, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 5 - Say Line 1 (Rogvar)"), +(1710904, 9, 7, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 5 - Set Event Phase 4"), +(1710905, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 6 - Set Event Phase 0"), +(1710905, 9, 1, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 27705, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 6 - Set Orientation"), +(1710905, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 6 - Say Line 3"), +(1710905, 9, 3, 0, 0, 0, 100, 0, 8000, 8000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 19, 27705, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 6 - Say Line 1 (Lorrin Foxfire)"), +(1710905, 9, 4, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 53, 0, 1710901, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 6 - Start Waypoint 2"), +(1710906, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 54, 8000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 7 - Pause Waypoint"), +(1710906, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 10928, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 7 - Set Orientation"), +(1710906, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 7 - Say Line 4"), +(1710907, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0.952855, "Cersei Dusksinger - On Script 8 - Set Orientation"), +(1710907, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Cersei Dusksinger - On Script 8 - Set Event Phase 1"); |