DB/Quest: A Visit With The Ancestors

Closes #23284

(cherry picked from commit a3dec9068bda1a3145e526eaa69c1e38fa3f2fe3)

2 files changed, 34 insertions, 44 deletions

diff --git a/sql/updates/world/master/2021_12_11_29_world_2019_06_20_01_world.sql b/sql/updates/world/master/2021_12_11_29_world_2019_06_20_01_world.sql
new file mode 100644
index 00000000000..8a17c6feb9e
--- /dev/null
+++ b/sql/updates/world/master/2021_12_11_29_world_2019_06_20_01_world.sql
@@ -0,0 +1,34 @@
+-- 
+UPDATE `serverside_spell` SET `DurationIndex`=39 WHERE `id` IN (33122);
+UPDATE `creature_template` SET `flags_extra`= `flags_extra`|128, `ScriptName`="" WHERE `entry` IN (18840, 18841, 18842, 18843);
+DELETE FROM `areatrigger_scripts` WHERE `entry` IN (4368,4369,4372,4371);
+INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES
+(4368,'SmartTrigger'),(4369,'SmartTrigger'),(4372,'SmartTrigger'),(4371,'SmartTrigger');
+UPDATE `creature_template` SET `AIName`="SmartAI",`unit_flags`= `unit_flags`|768 WHERE `entry` IN (18904);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (18904) AND `source_type`=0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (4368,4369,4372,4371) AND `source_type`=2;
+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`, `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
+(18904,0,0,0,54,0,100,0,0,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Vision of the Forgotten - On Just summoned - Say text"),
+(4368,2,0,1,46,0,100,0,4368,0,0,0,85,33122,0,0,0,0,0,7,0,0,0,0,0,0,0,"Area Trigger 4368 - On Trigger - Self cast Serverside - A Vision of the Forgotten"),
+(4368,2,1,0,61,0,100,0,0,0,0,0,33,18843,0,0,0,0,0,7,0,0,0,0,0,0,0,"Area Trigger 4368 - On Trigger - Kill credit"),
+(4369,2,0,1,46,0,100,0,4369,0,0,0,85,33122,0,0,0,0,0,7,0,0,0,0,0,0,0,"Area Trigger 4368 - On Trigger - Self cast Serverside - A Vision of the Forgotten"),
+(4369,2,1,0,61,0,100,0,0,0,0,0,33,18840,0,0,0,0,0,7,0,0,0,0,0,0,0,"Area Trigger 4368 - On Trigger - Kill credit"),
+(4372,2,0,1,46,0,100,0,4372,0,0,0,85,33122,0,0,0,0,0,7,0,0,0,0,0,0,0,"Area Trigger 4368 - On Trigger - Self cast Serverside - A Vision of the Forgotten"),
+(4372,2,1,0,61,0,100,0,0,0,0,0,33,18842,0,0,0,0,0,7,0,0,0,0,0,0,0,"Area Trigger 4368 - On Trigger - Kill credit"),
+(4371,2,0,1,46,0,100,0,4371,0,0,0,85,33122,0,0,0,0,0,7,0,0,0,0,0,0,0,"Area Trigger 4368 - On Trigger - Self cast Serverside - A Vision of the Forgotten"),
+(4371,2,1,0,61,0,100,0,0,0,0,0,33,18841,0,0,0,0,0,7,0,0,0,0,0,0,0,"Area Trigger 4368 - On Trigger - Kill credit");
+
+DELETE FROM `creature_text` WHERE `CreatureID`=18904;
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(18904,0,0,"Turn back, mortal... This is not your battle.",15,0,100,0,0,0,16007,0,"Vision of the Forgotten"),
+(18904,0,1,"You cannot stop them...",15,0,100,0,0,0,16008,0,"Vision of the Forgotten"),
+(18904,0,2,"We are infinite... eternal.",15,0,100,0,0,0,16009,0,"Vision of the Forgotten"),
+(18904,0,3,"They lack control... Oshu'gun calls to them...",15,0,100,0,0,0,16010,0,"Vision of the Forgotten"),
+(18904,0,4,"It is a beacon. A remnant of a forgotten era.",15,0,100,0,0,0,16011,0,"Vision of the Forgotten");
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` IN (4368,4369,4372,4371) AND `SourceId`=2;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(22, 1, 4369, 2, 0, 48, 0, 262445, 0, 0, 0, 0, 0, "", "Run SAI only if quest 10085 objective 1 is not complete"),
+(22, 1, 4371, 2, 0, 48, 0, 262446, 0, 0, 0, 0, 0, "", "Run SAI only if quest 10085 objective 2 is not complete"),
+(22, 1, 4372, 2, 0, 48, 0, 262447, 0, 0, 0, 0, 0, "", "Run SAI only if quest 10085 objective 3 is not complete"),
+(22, 1, 4368, 2, 0, 48, 0, 262448, 0, 0, 0, 0, 0, "", "Run SAI only if quest 10085 objective 4 is not complete");
diff --git a/src/server/scripts/Outland/zone_nagrand.cpp b/src/server/scripts/Outland/zone_nagrand.cpp
index 23f75db8867..159cfaede33 100644
--- a/src/server/scripts/Outland/zone_nagrand.cpp
+++ b/src/server/scripts/Outland/zone_nagrand.cpp
@@ -24,7 +24,6 @@ EndScriptData */
 
 /* ContentData
 npc_maghar_captive
-npc_creditmarker_visit_with_ancestors
 EndContentData */
 
 #include "ScriptMgr.h"
@@ -218,48 +217,6 @@ public:
 };
 
 /*######
-## npc_creditmarker_visist_with_ancestors
-######*/
-
-class npc_creditmarker_visit_with_ancestors : public CreatureScript
-{
-public:
-    npc_creditmarker_visit_with_ancestors() : CreatureScript("npc_creditmarker_visit_with_ancestors") { }
-
-    CreatureAI* GetAI(Creature* creature) const override
-    {
-        return new npc_creditmarker_visit_with_ancestorsAI(creature);
-    }
-
-    struct npc_creditmarker_visit_with_ancestorsAI : public ScriptedAI
-    {
-        npc_creditmarker_visit_with_ancestorsAI(Creature* creature) : ScriptedAI(creature) { }
-
-        void Reset() override { }
-
-        void JustEngagedWith(Unit* /*who*/) override { }
-
-        void MoveInLineOfSight(Unit* who) override
-        {
-            if (!who)
-                return;
-
-            Player* player = who->ToPlayer();
-            if (player && player->GetQuestStatus(10085) == QUEST_STATUS_INCOMPLETE)
-            {
-                uint32 creditMarkerId = me->GetEntry();
-                if (creditMarkerId >= 18840 && creditMarkerId <= 18843)
-                {
-                    // 18840: Sunspring, 18841: Laughing, 18842: Garadar, 18843: Bleeding
-                    if (!player->GetReqKillOrCastCurrentCount(10085, creditMarkerId))
-                        player->KilledMonsterCredit(creditMarkerId, me->GetGUID());
-                }
-            }
-        }
-    };
-};
-
-/*######
 ## go_corkis_prison and npc_corki
 ######*/
 
@@ -923,7 +880,6 @@ public:
 void AddSC_nagrand()
 {
     new npc_maghar_captive();
-    new npc_creditmarker_visit_with_ancestors();
     new npc_corki();
     new go_corkis_prison();
     new npc_kurenai_captive();