DB/BlastedLands: Added Vindicator Maraad at Shattered Beachhead

Closes #29231

1 files changed, 32 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_09_18_03_world.sql b/sql/updates/world/master/2023_09_18_03_world.sql
new file mode 100644
index 00000000000..5a003538157
--- /dev/null
+++ b/sql/updates/world/master/2023_09_18_03_world.sql
@@ -0,0 +1,32 @@
+SET @CGUID := 5000090;
+
+DELETE FROM `creature` WHERE `guid` = @CGUID+0;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 82270, 0, 4, 6963, '0', 3971, 0, 1190, 0, 1, -11273.220703125, -3632.451416015625, 9.469362258911132812, 1.459806442260742187, 120, 0, 0, 800000, 1283, 0, NULL, NULL, 50791); -- Vindicator Maraad (Area: The Shattered Front - Difficulty: 0) CreateObject1
+
+DELETE FROM `creature_template_addon` WHERE `entry` = 82270;
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(82270, 0, 0, 0, 0, 0, 1, 0, 483, 0, 0, 0, 0, ''); -- Vindicator Maraad
+
+UPDATE `creature_queststarter` SET `VerifiedBuild`=50791 WHERE (`id`=82270 AND `quest` IN (36307,35463,35462,35460));
+UPDATE `creature_questender` SET `VerifiedBuild`=50791 WHERE (`id`=82270 AND `quest` IN (35463,35460,35462));
+
+UPDATE `quest_poi` SET `VerifiedBuild`=50791 WHERE (`QuestID`=36307 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=36307 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=36307 AND `BlobIndex`=0 AND `Idx1`=0);
+UPDATE `quest_poi_points` SET `VerifiedBuild`=50791 WHERE (`QuestID`=36307 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=36307 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=36307 AND `Idx1`=0 AND `Idx2`=0);
+UPDATE `quest_details` SET `VerifiedBuild`=50791 WHERE `ID` = 36307;
+
+DELETE FROM `quest_template` WHERE `ID`=37677;
+INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestPackageID`, `ContentTuningID`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardXPMultiplier`, `RewardMoneyDifficulty`, `RewardMoneyMultiplier`, `RewardBonusMoney`, `RewardDisplaySpell1`, `RewardDisplaySpell2`, `RewardDisplaySpell3`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `RewardArtifactXPDifficulty`, `RewardArtifactXPMultiplier`, `RewardArtifactCategoryID`, `Flags`, `FlagsEx`, `FlagsEx2`, `RewardItem1`, `RewardAmount1`, `RewardItem2`, `RewardAmount2`, `RewardItem3`, `RewardAmount3`, `RewardItem4`, `RewardAmount4`, `ItemDrop1`, `ItemDropQuantity1`, `ItemDrop2`, `ItemDropQuantity2`, `ItemDrop3`, `ItemDropQuantity3`, `ItemDrop4`, `ItemDropQuantity4`, `RewardChoiceItemID1`, `RewardChoiceItemQuantity1`, `RewardChoiceItemDisplayID1`, `RewardChoiceItemID2`, `RewardChoiceItemQuantity2`, `RewardChoiceItemDisplayID2`, `RewardChoiceItemID3`, `RewardChoiceItemQuantity3`, `RewardChoiceItemDisplayID3`, `RewardChoiceItemID4`, `RewardChoiceItemQuantity4`, `RewardChoiceItemDisplayID4`, `RewardChoiceItemID5`, `RewardChoiceItemQuantity5`, `RewardChoiceItemDisplayID5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity6`, `RewardChoiceItemDisplayID6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardArenaPoints`, `RewardSkillLineID`, `RewardNumSkillUps`, `PortraitGiver`, `PortraitGiverMount`, `PortraitGiverModelSceneID`, `PortraitTurnIn`, `RewardFactionID1`, `RewardFactionValue1`, `RewardFactionOverride1`, `RewardFactionCapIn1`, `RewardFactionID2`, `RewardFactionValue2`, `RewardFactionOverride2`, `RewardFactionCapIn2`, `RewardFactionID3`, `RewardFactionValue3`, `RewardFactionOverride3`, `RewardFactionCapIn3`, `RewardFactionID4`, `RewardFactionValue4`, `RewardFactionOverride4`, `RewardFactionCapIn4`, `RewardFactionID5`, `RewardFactionValue5`, `RewardFactionOverride5`, `RewardFactionCapIn5`, `RewardFactionFlags`, `RewardCurrencyID1`, `RewardCurrencyQty1`, `RewardCurrencyID2`, `RewardCurrencyQty2`, `RewardCurrencyID3`, `RewardCurrencyQty3`, `RewardCurrencyID4`, `RewardCurrencyQty4`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `AreaGroupID`, `TimeAllowed`, `AllowableRaces`, `TreasurePickerID`, `Expansion`, `ManagedWorldStateID`, `QuestSessionBonus`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `QuestCompletionLog`, `VerifiedBuild`) VALUES
+(37677, 2, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, (0x00000400), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Blasted Land 6.0:JP3 - Invasion - Tracking Quest - See Maraad', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
+
+DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`=26 AND `SourceGroup` = 3971 AND `SourceEntry` = 0);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES
+(26, 3971, 0, 0, 0, 47, 0, 37677, 64, 0, 1, 'Apply Phase 3971 if Quest 37677 is not rewarded');
+
+DELETE FROM `phase_name` WHERE `ID`=3971;
+INSERT INTO `phase_name` (`ID`, `Name`) VALUES
+(3971, 'Cosmetic - Vindicator Maraad at Shattered Beachhead');
+
+DELETE FROM `phase_area` WHERE `AreaId`=4 AND `PhaseId` = 3971;
+INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES
+(4, 3971, 'See Vindicator Maraad at Shattered Beachhead');