Sign in to follow this  
Followers 0
takasi689

[Declined][Battle for Azeroth]: Murder Was The Case That They Gave Me

2 posts in this topic

Title: Murder Was The Case That They Gave Me
Bugtracker Link:


Patch Content:

 

 

 

Quote

-- Creature_template

-- https://www.wowhead.com/npc=42384/homeless-stormwind-citizen
DELETE FROM `creature_template` WHERE `entry`=42384;
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `femaleName`, `subname`, `TitleAlt`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `HealthScalingExpansion`, `RequiredExpansion`, `VignetteID`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `family`, `trainer_type`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `type_flags2`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `HealthModifier`, `HealthModifierExtra`, `ManaModifier`, `ManaModifierExtra`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES (42384, 0, 0, 0, 42625, 0, 32817, 32818, 32819, 32820, 'Homeless Stormwind Citizen', '', '', NULL, '', 0, 10, 60, 0, 0, 0, 7, 1, 1, 1.14286, 1, 0, 0, 2000, 2000, 0, 0, 1, 33024, 2048, 0, 4, 0, 0, 0, 0, 7, 0, 0, 42384, 0, 0, 0, 0, 0, 0, 0, 0, 80383, 0, 0, 0, 0, 0, 0, 0, 0, 5, 5, 'SmartAI', 0, 3, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, 'npc_westplains_drifter', 26124);
-- https://www.wowhead.com/npc=42391/west-plains-drifter
DELETE FROM `creature_template` WHERE `entry`=42391;
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `femaleName`, `subname`, `TitleAlt`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `HealthScalingExpansion`, `RequiredExpansion`, `VignetteID`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `unit_flags3`, `dynamicflags`, `family`, `trainer_type`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `type_flags2`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `HealthModifier`, `HealthModifierExtra`, `ManaModifier`, `ManaModifierExtra`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES (42391, 0, 0, 0, 42625, 0, 32837, 32838, 32839, 32840, 'West Plains Drifter', '', '', NULL, '', 0, 10, 60, 0, 0, 0, 7, 1, 1, 1.14286, 1, 0, 0, 2000, 2000, 0, 0, 1, 33024, 2048, 0, 4, 0, 0, 0, 0, 7, 0, 0, 42391, 0, 0, 0, 0, 0, 0, 0, 0, 80384, 0, 0, 0, 0, 0, 0, 0, 0, 5, 5, 'SmartAI', 0, 3, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, '', 26124);


-- Smart_Scripts for 

-- https://www.wowhead.com/npc=42384/homeless-stormwind-citizen
DELETE FROM `smart_scripts` WHERE `entryorguid`=42384 AND `source_type`=0 AND `id`=0 AND `link`=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_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 (42384, 0, 0, 0, 62, 0, 100, 512, 11635, 0, 0, 0, '', 85, 79181, 2, 18, 35, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, '');
-- https://www.wowhead.com/npc=42384/homeless-stormwind-citizen
DELETE FROM `smart_scripts` WHERE `entryorguid`=42384 AND `source_type`=0 AND `id`=1 AND `link`=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_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 (42384, 0, 1, 0, 62, 0, 100, 0, 11635, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '');
-- https://www.wowhead.com/npc=42384/homeless-stormwind-citizen
DELETE FROM `smart_scripts` WHERE `entryorguid`=42384 AND `source_type`=0 AND `id`=2 AND `link`=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_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 (42384, 0, 2, 0, 62, 0, 100, 512, 11635, 1, 0, 0, '', 85, 79184, 2, 18, 35, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, '');
-- https://www.wowhead.com/npc=42384/homeless-stormwind-citizen
DELETE FROM `smart_scripts` WHERE `entryorguid`=42384 AND `source_type`=0 AND `id`=3 AND `link`=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_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 (42384, 0, 3, 0, 62, 0, 100, 0, 11635, 1, 0, 0, '', 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '');
-- https://www.wowhead.com/npc=42391/west-plains-drifter
DELETE FROM `smart_scripts` WHERE `entryorguid`=42391 AND `source_type`=0 AND `id`=0 AND `link`=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_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 (42391, 0, 0, 0, 62, 0, 100, 512, 11635, 0, 0, 0, '', 85, 79182, 2, 18, 35, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, '');
-- https://www.wowhead.com/npc=42391/west-plains-drifter
DELETE FROM `smart_scripts` WHERE `entryorguid`=42391 AND `source_type`=0 AND `id`=1 AND `link`=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_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 (42391, 0, 1, 0, 62, 0, 100, 0, 11635, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '');
-- https://www.wowhead.com/npc=42391/west-plains-drifter
DELETE FROM `smart_scripts` WHERE `entryorguid`=42391 AND `source_type`=0 AND `id`=2 AND `link`=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_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 (42391, 0, 2, 0, 62, 0, 100, 512, 11635, 1, 0, 0, '', 85, 79183, 2, 18, 35, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, '');
-- https://www.wowhead.com/npc=42391/west-plains-drifter
DELETE FROM `smart_scripts` WHERE `entryorguid`=42391 AND `source_type`=0 AND `id`=3 AND `link`=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_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 (42391, 0, 3, 0, 62, 0, 100, 0, 11635, 1, 0, 0, '', 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '');

-- Gossip_menu

DELETE FROM `gossip_menu` WHERE `MenuId`=11635 AND `TextId`=16250;
INSERT INTO `gossip_menu` (`MenuId`, `TextId`, `VerifiedBuild`) VALUES (11635, 16250, 25881);

-- Gossip_menu_option

DELETE FROM `gossip_menu_option` WHERE `MenuId`=11635 AND `OptionIndex`=0;
INSERT INTO `gossip_menu_option` (`MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcFlag`, `VerifiedBuild`) VALUES (11635, 0, 0, 'Did you see who killed the Furlbrows?', 42370, 1, 1, 25881);

DELETE FROM `gossip_menu_option` WHERE `MenuId`=11635 AND `OptionIndex`=1;
INSERT INTO `gossip_menu_option` (`MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcFlag`, `VerifiedBuild`) VALUES (11635, 1, 0, 'Maybe a couple copper will loosen your tongue. Now tell me, did you see who killed the Furlbrows?', 42371, 1, 1, 25881);

-- npc_text I don't know if this is needed.

DELETE FROM `npc_text` WHERE `ID`=16250;
INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextID0`, `BroadcastTextID1`, `BroadcastTextID2`, `BroadcastTextID3`, `BroadcastTextID4`, `BroadcastTextID5`, `BroadcastTextID6`, `BroadcastTextID7`, `VerifiedBuild`) VALUES (16250, 1, 1, 1, 1, 1, 0, 0, 0, 42365, 42366, 42367, 42368, 42369, 0, 0, 0, 25881);

Greetings, I've started to play in Westfall (Battle For Azeroth Realm) and came on this quest where Murder Was The Case That They Gave where NPC's don't have gossip and whether you talk to them or kill them they don't give kill credit for quest so I wanted to submit this patch.
I saw some bug reports for this quest where people can't find only #4 clue and some said it's behind some farm, I did not spend more than 3 minutes farming other three since there were no clues at all for me at least. In this video you can see that player gets all clues in one place.
Best Regards,
takasi689

 

Share this post


Link to post
Share on other sites

Greetings @takasi689,

Your patch is declined, the fix is already on Sethraliss. Thank you for contributing to Firestorm.

Regards, Thyvene.

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  
Followers 0