DB/Quest: Convert & update support for 'The Caverns of Time' to SAI

2 files changed, 116 insertions, 139 deletions

diff --git a/sql/updates/world/3.3.5/2020_09_12_06_world.sql b/sql/updates/world/3.3.5/2020_09_12_06_world.sql
new file mode 100644
index 00000000000..f9061c2d673
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_09_12_06_world.sql
@@ -0,0 +1,115 @@
+-- Spell 34877 is used by player after 34878
+UPDATE `quest_template_addon` SET `SourceSpellID` = 0 WHERE `ID` = 10277;
+
+-- Andormu SAI
+SET @ID := 20130;
+UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` = @ID;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID 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_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@ID,0,0,0,19,0,100,0,10277,0,0,0,0,11,34878,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Andormu - On Quest 'The Caverns of Time' Taken - Cast 'Custodian of Time'");
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceEntry` = 20130 AND `SourceId` = 0;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(22,1,20130,0,0,1,0,34877,1,0,1,0,0,"","Group 0: Execute SAI (Action 0) if player does not have aura 'Custodian of Time'");
+
+-- Custodian of Time SAI (Sniffed)
+SET @ID := 20129;
+UPDATE `creature_template` SET `AIName` = "SmartAI", `ScriptName` = "" WHERE `entry` = @ID;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN @ID*100+0 AND @ID*100+6 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
+(@ID,0,0,0,54,0,100,0,0,0,0,0,0,80,@ID*100+0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Just Summoned - Run Script"),
+(@ID,0,1,0,40,0,100,0,4,0,0,0,0,80,@ID*100+1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Waypoint 4 Reached - Run Script"),
+(@ID,0,2,0,40,0,100,0,11,0,0,0,0,80,@ID*100+2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Waypoint 11 Reached - Run Script"),
+(@ID,0,3,0,40,0,100,0,13,0,0,0,0,80,@ID*100+3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Waypoint 13 Reached - Run Script"),
+(@ID,0,4,0,40,0,100,0,17,0,0,0,0,80,@ID*100+4,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Waypoint 17 Reached - Run Script"),
+(@ID,0,5,0,40,0,100,0,23,0,0,0,0,80,@ID*100+5,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Waypoint 23 Reached - Run Script"),
+(@ID,0,6,0,40,0,100,0,26,0,0,0,0,80,@ID*100+6,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Waypoint 26 Reached - Run Script"),
+
+(@ID*100+0,9,0,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Set Orientation Owner"),
+(@ID*100+0,9,1,0,0,0,100,0,0,0,0,0,0,11,17321,0,0,0,0,0,11,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Cast 'Spirit Spawn-in'"),
+(@ID*100+0,9,2,0,0,0,100,0,2000,2000,0,0,0,1,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 0"),
+(@ID*100+0,9,3,0,0,0,100,0,10000,10000,0,0,0,1,1,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 1"),
+(@ID*100+0,9,4,0,0,0,100,0,15000,15000,0,0,0,1,2,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 2"),
+(@ID*100+0,9,5,0,0,0,100,0,11000,11000,0,0,0,1,3,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 3"),
+(@ID*100+0,9,6,0,0,0,100,0,2000,2000,0,0,0,53,0,20129,0,0,0,2,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Start Waypoint"),
+
+(@ID*100+1,9,0,0,0,0,100,0,0,0,0,0,0,54,120000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Pause Waypoint"),
+(@ID*100+1,9,1,0,0,0,100,0,2000,2000,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Set Orientation Owner"),
+(@ID*100+1,9,2,0,0,0,100,0,1000,1000,0,0,0,1,4,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 4"),
+(@ID*100+1,9,3,0,0,0,100,0,10000,10000,0,0,0,1,5,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 5"),
+(@ID*100+1,9,4,0,0,0,100,0,15000,15000,0,0,0,1,6,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 6"),
+(@ID*100+1,9,5,0,0,0,100,0,10000,10000,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0,1.46607,"Custodian of Time - On Script - Set Orientation"),
+(@ID*100+1,9,6,0,0,0,100,0,1000,1000,0,0,0,1,7,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 7"),
+(@ID*100+1,9,7,0,0,0,100,0,6000,6000,0,0,0,5,25,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Play Emote 25"),
+(@ID*100+1,9,8,0,0,0,100,0,12000,12000,0,0,0,1,8,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 8"),
+(@ID*100+1,9,9,0,0,0,100,0,7000,7000,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Set Orientation Owner"),
+(@ID*100+1,9,10,0,0,0,100,0,1000,1000,0,0,0,5,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Play Emote 1"),
+(@ID*100+1,9,11,0,0,0,100,0,14000,14000,0,0,0,1,3,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 3"),
+(@ID*100+1,9,12,0,0,0,100,0,6000,6000,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Resume Waypoint"),
+
+(@ID*100+2,9,0,0,0,0,100,0,0,0,0,0,0,54,120000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Pause Waypoint"),
+(@ID*100+2,9,1,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,2.58308,"Custodian of Time - On Script - Set Orientation"),
+(@ID*100+2,9,2,0,0,0,100,0,2000,2000,0,0,0,5,25,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Play Emote 25"),
+(@ID*100+2,9,3,0,0,0,100,0,2000,2000,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Set Orientation Owner"),
+(@ID*100+2,9,4,0,0,0,100,0,1000,1000,0,0,0,1,9,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 9"),
+(@ID*100+2,9,5,0,0,0,100,0,10000,10000,0,0,0,1,3,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 3"),
+(@ID*100+2,9,6,0,0,0,100,0,6000,6000,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Resume Waypoint"),
+
+(@ID*100+3,9,0,0,0,0,100,0,0,0,0,0,0,54,120000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Pause Waypoint"),
+(@ID*100+3,9,1,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,3.92699,"Custodian of Time - On Script - Set Orientation"),
+(@ID*100+3,9,2,0,0,0,100,0,1000,1000,0,0,0,1,10,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 10"),
+(@ID*100+3,9,3,0,0,0,100,0,3000,3000,0,0,0,5,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Play Emote 1"),
+(@ID*100+3,9,4,0,0,0,100,0,6000,6000,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Resume Waypoint"),
+
+(@ID*100+4,9,0,0,0,0,100,0,0,0,0,0,0,54,120000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Pause Waypoint"),
+(@ID*100+4,9,1,0,0,0,100,0,1000,1000,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Set Orientation Owner"),
+(@ID*100+4,9,2,0,0,0,100,0,2000,2000,0,0,0,1,11,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 11"),
+(@ID*100+4,9,3,0,0,0,100,0,20000,20000,0,0,0,1,3,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 3"),
+(@ID*100+4,9,4,0,0,0,100,0,6000,6000,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Resume Waypoint"),
+
+(@ID*100+5,9,0,0,0,0,100,0,0,0,0,0,0,54,120000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Pause Waypoint"),
+(@ID*100+5,9,1,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.19198,"Custodian of Time - On Script - Set Orientation"),
+(@ID*100+5,9,2,0,0,0,100,0,1000,1000,0,0,0,1,12,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 12"),
+(@ID*100+5,9,3,0,0,0,100,0,10000,10000,0,0,0,1,3,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 3"),
+(@ID*100+5,9,4,0,0,0,100,0,6000,6000,0,0,0,65,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Resume Waypoint"),
+
+(@ID*100+6,9,0,0,0,0,100,0,1000,1000,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Set Orientation Owner"),
+(@ID*100+6,9,1,0,0,0,100,0,1000,1000,0,0,0,1,13,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Say Line 13"),
+(@ID*100+6,9,2,0,0,0,100,0,0,0,0,0,0,11,34883,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Cast 'QID 10277'"),
+(@ID*100+6,9,3,0,0,0,100,0,6000,6000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Custodian of Time - On Script - Despawn Instant");
+
+UPDATE `creature_text` SET `comment` = "Custodian of Time" WHERE `CreatureID` = @ID;
+UPDATE `creature_text` SET `Emote` = 1 WHERE `CreatureID` = @ID AND `GroupID` IN (0,1,2,4,5,6,7,9,11,13);
+UPDATE `creature_text` SET `Emote` = 273 WHERE `CreatureID` = @ID AND `GroupID` = 3;
+UPDATE `creature_text` SET `Emote` = 25 WHERE `CreatureID` = @ID AND `GroupID` IN (8,10,12);
+
+DELETE FROM `script_waypoint` WHERE `entry` = 20129;
+DELETE FROM `waypoints` WHERE `entry` = 20129;
+INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES
+(20129,1,-8383.195,-4244.2246,-206.63582,"Custodian of Time"),
+(20129,2,-8401.535,-4229.1826,-206.77563,"Custodian of Time"),
+(20129,3,-8431.324,-4205.2417,-209.29944,"Custodian of Time"),
+(20129,4,-8446.195,-4199.217,-211.19778,"Custodian of Time"), --
+(20129,5,-8458.105,-4211.28,-213.03964,"Custodian of Time"),
+(20129,6,-8474.044,-4211.068,-214.48344,"Custodian of Time"),
+(20129,7,-8496.167,-4213.949,-214.46599,"Custodian of Time"),
+(20129,8,-8535.091,-4218.9146,-213.08104,"Custodian of Time"),
+(20129,9,-8570.049,-4231.135,-211.34303,"Custodian of Time"),
+(20129,10,-8598.164,-4247.1714,-210.84158,"Custodian of Time"),
+(20129,11,-8627.352,-4268.6313,-210.40045,"Custodian of Time"), --
+(20129,12,-8621.29,-4292.2915,-210.65274,"Custodian of Time"),
+(20129,13,-8607.385,-4337.514,-211.93082,"Custodian of Time"), --
+(20129,14,-8577.146,-4359.431,-214.54268,"Custodian of Time"),
+(20129,15,-8561.278,-4380.342,-215.37544,"Custodian of Time"),
+(20129,16,-8540.864,-4399.46,-216.24318,"Custodian of Time"),
+(20129,17,-8523.853,-4407.744,-216.44739,"Custodian of Time"), --
+(20129,18,-8488.358,-4429.706,-215.93779,"Custodian of Time"),
+(20129,19,-8443.823,-4427.043,-213.41385,"Custodian of Time"),
+(20129,20,-8409.723,-4412.882,-211.28308,"Custodian of Time"),
+(20129,21,-8379.641,-4393.748,-208.27452,"Custodian of Time"),
+(20129,22,-8359.075,-4369.809,-208.16708,"Custodian of Time"),
+(20129,23,-8358.578,-4360.8413,-208.14444,"Custodian of Time"), --
+(20129,24,-8363.002,-4342.101,-208.54948,"Custodian of Time"),
+(20129,25,-8367.569,-4306.7544,-209.5187,"Custodian of Time"),
+(20129,26,-8374.003,-4286.1333,-208.72986,"Custodian of Time"); --
diff --git a/src/server/scripts/Kalimdor/zone_tanaris.cpp b/src/server/scripts/Kalimdor/zone_tanaris.cpp
index 144bc19932a..16d433ea284 100644
--- a/src/server/scripts/Kalimdor/zone_tanaris.cpp
+++ b/src/server/scripts/Kalimdor/zone_tanaris.cpp
@@ -18,12 +18,11 @@
 /* ScriptData
 SDName: Tanaris
 SD%Complete: 80
-SDComment: Quest support: 1560, 4005, 10277
+SDComment: Quest support: 1560
 SDCategory: Tanaris
 EndScriptData */
 
 /* ContentData
-npc_custodian_of_time
 npc_tooga
 EndContentData */
 
@@ -36,142 +35,6 @@ EndContentData */
 #include "ScriptedGossip.h"
 #include "WorldSession.h"
 
-/*######
-## npc_custodian_of_time
-######*/
-
-enum CustodianOfTime
-{
-    WHISPER_CUSTODIAN_1     = 0,
-    WHISPER_CUSTODIAN_2     = 1,
-    WHISPER_CUSTODIAN_3     = 2,
-    WHISPER_CUSTODIAN_4     = 3,
-    WHISPER_CUSTODIAN_5     = 4,
-    WHISPER_CUSTODIAN_6     = 5,
-    WHISPER_CUSTODIAN_7     = 6,
-    WHISPER_CUSTODIAN_8     = 7,
-    WHISPER_CUSTODIAN_9     = 8,
-    WHISPER_CUSTODIAN_10    = 9,
-    WHISPER_CUSTODIAN_11    = 10,
-    WHISPER_CUSTODIAN_12    = 11,
-    WHISPER_CUSTODIAN_13    = 12,
-    WHISPER_CUSTODIAN_14    = 13,
-
-    QUEST_CAVERNS_OF_TIME   = 10277,
-    SPELL_QID_10277         = 34883
-};
-
-class npc_custodian_of_time : public CreatureScript
-{
-public:
-    npc_custodian_of_time() : CreatureScript("npc_custodian_of_time") { }
-
-    CreatureAI* GetAI(Creature* creature) const override
-    {
-        return new npc_custodian_of_timeAI(creature);
-    }
-
-    struct npc_custodian_of_timeAI : public EscortAI
-    {
-        npc_custodian_of_timeAI(Creature* creature) : EscortAI(creature) { }
-
-        void WaypointReached(uint32 waypointId, uint32 /*pathId*/) override
-        {
-            if (Player* player = GetPlayerForEscort())
-            {
-                switch (waypointId)
-                {
-                    case 0:
-                        Talk(WHISPER_CUSTODIAN_1, player);
-                        break;
-                    case 1:
-                        Talk(WHISPER_CUSTODIAN_2, player);
-                        break;
-                    case 2:
-                        Talk(WHISPER_CUSTODIAN_3, player);
-                        break;
-                    case 3:
-                        Talk(WHISPER_CUSTODIAN_4, player);
-                        break;
-                    case 5:
-                        Talk(WHISPER_CUSTODIAN_5, player);
-                        break;
-                    case 6:
-                        Talk(WHISPER_CUSTODIAN_6, player);
-                        break;
-                    case 7:
-                        Talk(WHISPER_CUSTODIAN_7, player);
-                        break;
-                    case 8:
-                        Talk(WHISPER_CUSTODIAN_8, player);
-                        break;
-                    case 9:
-                        Talk(WHISPER_CUSTODIAN_9, player);
-                        break;
-                    case 10:
-                        Talk(WHISPER_CUSTODIAN_4, player);
-                        break;
-                    case 13:
-                        Talk(WHISPER_CUSTODIAN_10, player);
-                        break;
-                    case 14:
-                        Talk(WHISPER_CUSTODIAN_4, player);
-                        break;
-                    case 16:
-                        Talk(WHISPER_CUSTODIAN_11, player);
-                        break;
-                    case 17:
-                        Talk(WHISPER_CUSTODIAN_12, player);
-                        break;
-                    case 18:
-                        Talk(WHISPER_CUSTODIAN_4, player);
-                        break;
-                    case 22:
-                        Talk(WHISPER_CUSTODIAN_13, player);
-                        break;
-                    case 23:
-                        Talk(WHISPER_CUSTODIAN_4, player);
-                        break;
-                    case 24:
-                        Talk(WHISPER_CUSTODIAN_14, player);
-                        DoCast(player, SPELL_QID_10277);
-                        // below here is temporary workaround, to be removed when spell works properly
-                        player->AreaExploredOrEventHappens(QUEST_CAVERNS_OF_TIME);
-                        break;
-                }
-            }
-        }
-
-        void MoveInLineOfSight(Unit* who) override
-
-        {
-            if (HasEscortState(STATE_ESCORT_ESCORTING))
-                return;
-
-            if (Player* player = who->ToPlayer())
-            {
-                if (who->HasAura(34877) && player->GetQuestStatus(10277) == QUEST_STATUS_INCOMPLETE)
-                {
-                    float Radius = 10.0f;
-                    if (me->IsWithinDistInMap(who, Radius))
-                    {
-                        Start(false, false, who->GetGUID());
-                    }
-                }
-            }
-        }
-
-        void JustEngagedWith(Unit* /*who*/) override { }
-        void Reset() override { }
-
-        void UpdateAI(uint32 diff) override
-        {
-            EscortAI::UpdateAI(diff);
-        }
-    };
-
-};
-
 /*####
 # npc_tooga
 ####*/
@@ -335,6 +198,5 @@ public:
 
 void AddSC_tanaris()
 {
-    new npc_custodian_of_time();
     new npc_tooga();
 }