quest Maelstrom Quest Fix

[Robbies]

There is needed spawn NPC 45005 on Maelstrom next to aggra, this NPC will ask player if they have accepted next quest after that it will take them to deepholme. . After pushing this on live I will continou with quest 27123...

UPDATE creature_template set faction_a=1725, faction_h=1725 where entry=45042;

DELETE FROM quest_template where entry in (27203);

DELETE FROM creature_template where entry in (45005);

insert into `creature_involvedrelation` (`id`, `quest`) values('45042','27203');

insert into `creature_questrelation` (`id`, `quest`) values('45042','27123');

insert into `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) values('45005','0','0','0','0','0','17699','0','0','0','Wyvern','','vehichleCursor','45005','81','81','3','1725','1725','1','1','1','1','0','82','106','0','470','40','2000','0','1','0','2048','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','1','0','0','0','0','0','0','0','0','1','45005','0','0','','12339');

insert into `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClassMask`, `MinLevel`, `MaxLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RepObjectiveFaction2`, `RepObjectiveValue2`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `RewardArenaPoints`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `unk0`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `RewSkillLineId`, `RewSkillPoints`, `RewRepMask`, `QuestGiverPortrait`, `QuestTurnInPortrait`, `RewCurrencyId1`, `RewCurrencyCount1`, `RewCurrencyId2`, `RewCurrencyCount2`, `RewCurrencyId3`, `RewCurrencyCount3`, `RewCurrencyId4`, `RewCurrencyCount4`, `ReqCurrencyId1`, `ReqCurrencyCount1`, `ReqCurrencyId2`, `ReqCurrencyCount2`, `ReqCurrencyId3`, `ReqCurrencyCount3`, `ReqCurrencyId4`, `ReqCurrencyCount4`, `QuestGiverPortraitText`, `QuestGiverPortraitUnk`, `QuestTurnInPortraitText`, `QuestTurnInPortraitUnk`, `SoundAccept`, `SoundTurnIn`, `RequiredSpell`, `StartScript`, `CompleteScript`, `WDBVerified`) values('27203','2','5042','0','82','0','82','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','The Maelstrom','Thank the spirits you\'re here, $N.$B$BWe\'re not sure how much longer we can maintain the rift in the Maelstrom.$B$BOur most powerful members, led by Thrall, are barely preventing the tear.$B$BLast I heard, our only hope was to go through the breach and attempt to stabilize it from the other side.$B$BI will conjure a portal.  Take it and report to Thrall as soon as you can.','Go through the Portal to the Maelstrom and speak to Thrall.','<Thrall\'s muscles strain as primal energy flows through him.  His eyes shift your way, acknowledging your arrival.>$B$BIt is good to see you, $N.',NULL,'','','','','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','45101','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','1135','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','8200','21000','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','','','','','890','878','0','27203','0','1');

insert into `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`) values('45005','0','9','Teleport me down.','1','1','0','0','45005','0','0','If you take a quest Deepholm, Realm of Earth, them click to accept.');

insert into `gossip_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) values('45005','0','6','646','0','0','980.769','519.516','-49.3347','0.164097');

[Hypnos]

Hello,only the gossip is missing but we need:

1- gossip_menu(entry,textid)

2- gossip_menu_option( `menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`)

3- smart_scripts

gossip_scripts doesnt exist.

[MENZ411]

Fixed quest id 28805, 28826, 27203, 27123

-- Hack fix The Eye of the Storm (28805, 28826)
-- Waters of Farseeing SAI
UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI', `ScriptName`='' WHERE `entry` IN (207414, 207416);
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (207414, 207416) AND `source_type`=1;
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 
(207414, 1, 0, 1, 64, 0, 100, 0, 0, 0, 0, 0, 33, 50054, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Waters of Farseeing - On gossip hello - Killcredit'),
(207414, 1, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 28, 94687, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Waters of Farseeing - On link - Remove Waters of Farseeing'),
(207416, 1, 0, 1, 64, 0, 100, 0, 0, 0, 0, 0, 33, 50054, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Waters of Farseeing - On gossip hello - Killcredit'),
(207416, 1, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 28, 94687, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Waters of Farseeing - On link - Remove Waters of Farseeing');


-- Fixed Quest The Maelstrom (27203)
-- Spawn Portals to the Maelstrom
DELETE FROM `gameobject` WHERE `id`=205268;
INSERT INTO `gameobject` 
(`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `state`) VALUES 
(@, 205268, 1, 1, 1, 2048.06, -4377.16, 98.9305, 0, 300, 1), -- Orgrimmar
(@, 205268, 0, 1, 1, -8209.03, 428.774, 118.164, 2.84488, 300, 1); -- Stormwind City

DELETE FROM `spell_target_position` WHERE `id`=84464;
INSERT INTO `spell_target_position` 
(`id`, `effIndex`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES 
(84464, 0, 730, 851.307, 1067.76, -10.0183, 4.50656); -- Teleport to the Maelstrom

DELETE FROM `conditions` WHERE `SourceEntry`=84464 AND `SourceTypeOrReferenceId`=17;
INSERT INTO `conditions` 
(`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(17, 0, 84464, 0, 0, 28, 0, 27203, 0, 0, 0, 0, '', 'Show gossip if complete quest 27203 taken');
-- Trall
UPDATE `creature` SET `modelid`=0 WHERE `id`=45042; -- Remove model id


-- Hack fix Deepholm, Realm of Earth (27123)
-- Wyvern SAI
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='' WHERE `entry`=43713;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=43713;
INSERT INTO `smart_scripts` VALUES
(43713, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 28, 46598, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Wyvern - On just summoned - Remove Ride Vehicle Hardcoded'),
(43713, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 11, 84700, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Wyvern - On link - Cast Teleport to Temple of Earth'),
(43713, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 1000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wyvern - On link - Force despawn');

DELETE FROM `spell_target_position` WHERE `id`=84700;
INSERT INTO `spell_target_position` 
(`id`, `effIndex`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES 
(84700, 0, 646, 1076.78, 537.665, -44.5984, 3.38237); -- Teleport to Temple of Earth

DELETE FROM `conditions` WHERE `SourceGroup`=45005 AND `SourceTypeOrReferenceId`=18;
INSERT INTO `conditions` 
(`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(18, 45005, 81780, 0, 0, 28, 0, 27123, 0, 0, 0, 0, '', 'Show gossip if complete quest 27123 taken');

 

[Hypnos]

-- Hack fix Deepholm, Realm of Earth (27123)
-- Wyvern SAI
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='' WHERE `entry`=43713;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=43713;
INSERT INTO `smart_scripts` VALUES
(43713, 0, 0, 1, 54, 0, 100, 0, 0, 0, 0, 0, 28, 46598, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Wyvern - On just summoned - Remove Ride Vehicle Hardcoded'),
(43713, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 11, 84700, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Wyvern - On link - Cast Teleport to Temple of Earth'),
(43713, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 1000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wyvern - On link - Force despawn');

DELETE FROM `spell_target_position` WHERE `id`=84700;
INSERT INTO `spell_target_position` 
(`id`, `effIndex`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES 
(84700, 0, 646, 1076.78, 537.665, -44.5984, 3.38237); -- Teleport to Temple of Earth

DELETE FROM `conditions` WHERE `SourceGroup`=45005 AND `SourceTypeOrReferenceId`=18;
INSERT INTO `conditions` 
(`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(18, 45005, 81780, 0, 0, 28, 0, 27123, 0, 0, 0, 0, '', 'Show gossip if complete quest 27123 taken');

Do you are using differents npcs for the SAI and the conditions or is it the same? I think that it should to be 45005 in both. By the way i spawned the npc 45005 but he is missing the gossip as i said in the first post. If i have time i will add it but for the moment i cant. You feel free for completing it if you want. The rest of the patch is perfect.

Thanks you for contribuying  .

[MENZ411]

ок  rest of patch

-- Added Quest A Personal Summons to Hero's Call Board
DELETE FROM `gameobject_queststarter` WHERE `id` IN (206111, 206294) AND `quest`=28825;
INSERT INTO `gameobject_queststarter` 
(`id`, `quest`) VALUES 
(206111, 28825),
(206294, 28825);

-- Fixed Quest The Maelstrom (Alliance)
UPDATE `quest_template` SET `NextQuestId`=27203 WHERE `Id` IN (27722, 27727);
UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id`=27203;

-- Portal to the Maelstrom
UPDATE `gameobject_template` SET `AIName`='', `ScriptName`='', `data0`=84464 WHERE `entry`=205268;

-- Correct position
DELETE FROM `spell_target_position` WHERE `id`=84464;
INSERT INTO `spell_target_position` 
(`id`, `effIndex`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES 
(84464, 0, 730, 851.307, 1067.76, -10.0183, 4.50656); -- Portal to the Maelstrom

-- Wyvern
UPDATE `creature_template` SET `AIName`='', `ScriptName`='', `npcflag`=16777216, `IconName`='vehichleCursor' WHERE `entry`=45005;

DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=45005;
INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES 
(45005, 81780, 1, 0); -- Force Cast Summon Wyvern

 

[MENZ411]

29 minutes ago, MENZ411 said:

-- Correct position DELETE FROM `spell_target_position` WHERE `id`=84464; INSERT INTO `spell_target_position` (`id`, `effIndex`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES (84464, 0, 730, 851.307, 1067.76, -10.0183, 4.50656); -- Portal to the Maelstrom

remove duplicate lines