DB/Spawns: Added Ambassador Moorgard

closes #27172 by mdx7

1 files changed, 85 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_10_29_02_world.sql b/sql/updates/world/master/2021_10_29_02_world.sql
new file mode 100644
index 00000000000..159e7208761
--- /dev/null
+++ b/sql/updates/world/master/2021_10_29_02_world.sql
@@ -0,0 +1,85 @@
+-- 
+SET @CGUID := 1050138;
+
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=1732, `npcflag`=2, `BaseAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048, `VerifiedBuild`=40593 WHERE `entry`=133362; -- Ambassador Moorgard
+UPDATE `creature_template_model` SET `VerifiedBuild`=40593 WHERE (`CreatureID`=133362 AND `Idx`=0); -- Ambassador Moorgard
+
+DELETE FROM `creature_model_info` WHERE `DisplayID`=82874;
+INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES
+(82874, 0.321299970149993896, 1.574999928474426269, 0, 40593);
+
+DELETE FROM `creature` WHERE `guid`=@CGUID+0;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 133362, 0, 1519, 9171, '0', 10275, 0, 0, 0, -8172.59228515625, 801.0711669921875, 74.05037689208984375, 3.948031902313232421, 120, 0, 0, 47165, 57510, 0, 0, 0, 0, 40593); -- Ambassador Moorgard (Area: Stormwind Embassy - Difficulty: 0) (Auras: 262182 - Tophat)
+
+DELETE FROM `creature_template_addon` WHERE `entry`=133362;
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
+(133362, 0, 0, 0, 1, 0, 0, 0, 0, '262182'); -- 133362 (Ambassador Moorgard) - Tophat
+
+DELETE FROM `creature_questender` WHERE `id`=133362 AND `quest` IN(51486, 49772, 49788, 55142, 58146);
+INSERT INTO `creature_questender` (`id`, `quest`) VALUES
+(133362, 51486), -- Fer the Alliance (Dark Iron Dwarf)
+(133362, 49772), -- For the Alliance (Lightforged Draenei)
+(133362, 49788), -- For the Alliance (Void Elf)
+(133362, 55142), -- For the Alliance (Kul Tiran)
+(133362, 58146); -- For the Alliance (Mechagnome)
+
+DELETE FROM `creature_queststarter` WHERE `id`=133362 AND `quest` IN(50305, 50313, 53500, 55146, 58147);
+INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
+(133362, 50305), -- Stranger in a Strange Land (Void Elf)
+(133362, 50313), -- Stranger in a Strange Land (Lightforged Draenei)
+(133362, 53500), -- Stranger in a Strange Land (Dark Iron Dwarf)
+(133362, 55146), -- Stranger in a Strange Land (Kul Tiran)
+(133362, 58147); -- Stranger in a Strange Land (Mechagnome)
+
+DELETE FROM `quest_template_addon` WHERE `ID` IN(51486,49772,49788,55142,58146,53500,50313,50305,55146,58147);
+INSERT INTO `quest_template_addon` (`ID`, `PrevQuestID`, `NextQuestID`) VALUES
+(51486, 0, 53500), -- Fer the Alliance (Dark Iron Dwarf)
+(49772, 0, 50313), -- For the Alliance (Lightforged Draenei)
+(49788, 0, 50305), -- For the Alliance (Void Elf)
+(55142, 0, 55146), -- For the Alliance (Kul Tiran)
+(58146, 0, 58147), -- For the Alliance (Mechagnome)
+(53500, 51486, 0), -- Stranger in a Strange Land (Dark Iron Dwarf)
+(50313, 49772, 0), -- Stranger in a Strange Land (Lightforged Draenei)
+(50305, 49788, 0), -- Stranger in a Strange Land (Void Elf)
+(55146, 55142, 0), -- Stranger in a Strange Land (Kul Tiran)
+(58147, 58146, 0); -- Stranger in a Strange Land (Mechagnome)
+
+DELETE FROM `phase_area` WHERE `PhaseId`=10275 AND `AreaId` IN(9171, 5316, 5397);
+INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES
+(9171, 10275, 'Cosmetic: Ambassador Moorgard at Stormwind Embassy (Area: Stormwind Embassy)'),
+(5316, 10275, 'Cosmetic: Ambassador Moorgard at Stormwind Embassy (Area: Olivias Pond)'),
+(5397, 10275, 'Cosmetic: Ambassador Moorgard at Stormwind Embassy (Area: The Wollerton Stead)'); 
+
+DELETE FROM `conversation_actors` WHERE (`ConversationId`=6793 AND `Idx`=0);
+INSERT INTO `conversation_actors` (`ConversationId`, `ConversationActorId`, `Idx`, `CreatureId`, `CreatureDisplayInfoId`, `VerifiedBuild`) VALUES
+(6793, 60390, 0, 126306, 82047, 40593);
+
+DELETE FROM `conversation_line_template` WHERE `Id` IN (15489, 15490, 15491, 15492, 15493, 15494, 15495);
+INSERT INTO `conversation_line_template` (`Id`, `UiCameraID`, `ActorIdx`, `Flags`, `VerifiedBuild`) VALUES
+(15489, 82, 0, 0, 40593),
+(15490, 82, 0, 0, 40593), -- Lightforged Draenei
+(15491, 82, 0, 0, 40593), -- Void Elf
+(15492, 82, 0, 0, 40593),
+(15493, 82, 0, 0, 40593),
+(15494, 82, 0, 0, 40593), -- Lightforged Draenei and Dark Iron Dwarf
+(15495, 82, 0, 0, 40593); -- Void Elf
+
+DELETE FROM `conversation_template` WHERE `Id`=6793;
+INSERT INTO `conversation_template` (`Id`, `FirstLineID`, `TextureKitId`, `VerifiedBuild`) VALUES
+(6793, 15489, 5124, 40593);
+
+DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`=26 AND `SourceGroup`=10275 AND `SourceEntry`=0) OR (`SourceTypeOrReferenceId`=29 AND `SourceEntry` IN(15490,15491,15494,15495));
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES
+(26, 10275, 0, 0, 0, 16, 0, 0x800|0x4000|0x10000000|0x20000000|0x80000000, 0, 0, 0, 'Player is race Dark Iron Dwarf/Mechagnome/Void Elf/Lightforged Draenei/Kul Tiran'),
+(29, 0, 15490, 0, 0, 16, 0, 0x20000000, 0, 0, 0, 'Only show conversation line if player is Lightforged Draenei'),
+(29, 0, 15494, 0, 0, 16, 0, 0x800|0x20000000, 0, 0, 0, 'Only show conversation line if player is Dark Iron Dwarf or Lightforged Draenei'),
+(29, 0, 15491, 0, 0, 16, 0, 0x10000000, 0, 0, 0, 'Only show conversation line if player is Void Elf'),
+(29, 0, 15495, 0, 0, 16, 0, 0x10000000, 0, 0, 0, 'Only show conversation line if player is Void Elf');
+
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=133362;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 133362 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`, `event_param_string`, `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
+(133362, 0, 0, 0, 20, 0, 100, 0, 51486, 0, 0, 0, 0, '', 143, 6793, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Ambassador Moorgard - On quest reward 51486 (Dark Iron Dwarf) - Start Conversation 6793 - Invoker'),
+(133362, 0, 1, 0, 20, 0, 100, 0, 49772, 0, 0, 0, 0, '', 143, 6793, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Ambassador Moorgard - On quest reward 49772 (Lightforged Draenei) - Start Conversation 6793 - Invoker'),
+(133362, 0, 2, 0, 20, 0, 100, 0, 49788, 0, 0, 0, 0, '', 143, 6793, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Ambassador Moorgard - On quest reward 49788 (Void Elf) - Start Conversation 6793 - Invoker');