DB/SAI: Cersei Dusksinger

Closes #24830

1 files changed, 53 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_06_29_00_world.sql b/sql/updates/world/3.3.5/2020_06_29_00_world.sql
new file mode 100644
index 00000000000..8be85d2d2ee
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_06_29_00_world.sql
@@ -0,0 +1,53 @@
+-- 
+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");