-- Fix kill credit for Felblade Assassin (101100) in quest Demons Among Them (40983)
UPDATE `creature_template` SET `KillCredit1` = 101105 WHERE `entry` = 101100;

Some Queststarter and ender which i found during questing.
 

DELETE FROM `creature_questenter` WHERE `id`='42936' AND `quest`='26383';
DELETE FROM `creature_questenter` WHERE `id`='11401' AND `quest`='=27268';
DELETE FROM `creature_questenter` WHERE `id`='11401' AND `quest`='27269';
DELETE FROM `creature_questenter` WHERE `id`='1212' AND `quest`='270';
DELETE FROM `creature_queststarter` WHERE `id`='164949' AND `quest`='27268';
INSERT INTO `creature_queststarter` (`id`,`quest`) VALUES 
('164949','27268');

**Everything from this report was done using this as an example

**

Title: the Astral Walker
Reported Link: https://support.firestorm-servers.com/tickets.php?id=5585
 

Description:
Initially the title (165) was bound to achievement ID (3037) "Observed (25 player)" https://www.wowhead.com/achievement=3037/observed-25-player
In later patches (7.3.5) the 10-man and 25-man versions were removed and the achievement (12399) bacame only "Observed" https://www.wowhead.com/achievement=12399/observed

The new achievement (12399) is obtainable, however it does not grant the title (165) https://imgur.com/a/eVl2FaE
The achievement sub-text confirms it should grant the title (seen in the screenshots)

Patch Content:
https://www.wowhead.com/achievement=12399/observed
https://www.wowhead.com/title/the-astral-walker-165#

Proposal:

DELETE FROM `achievement_reward` WHERE `entry`='12399';
INSERT INTO `achievement_reward` (`entry`,`title_A`,`title_H`) VALUES
('12399','165','165');

This is a skinning quest but currently, it can be accepted without having skinning.
https://www.wowhead.com/quest=40138/trial-of-the-crusader-hides-of-legend
 

UPDATE `quest_template_addon` SET `RequiredSkillID`='393',`RequiredSkillPoints`='1' WHERE `ID`='40138';

Quest https://www.wowhead.com/quest=29582/greks-crazy-night should be turned in by https://www.wowhead.com/npc=54692/artificer-morphalius but can just turned in by https://www.wowhead.com/npc=19606/grek which is not correct. The player have to enter the dungeon to turn it in.

Checked if the correct NPC also have the questender, yes it does.

DELETE FROM `creature_questender` WHERE `id`='19606' AND `quest`='29582';

Quest https://www.wowhead.com/quest=29595/everything-will-be-alright should be turned in by https://www.wowhead.com/npc=54725/draenei-spirit but can just turned in by https://www.wowhead.com/npc=19698/greatfather-aldrimus which is not correct. The player have to enter the dungeon to turn it in.

Checked if the correct NPC also have the questender, yes it does.

 

DELETE FROM `creature_questender` WHERE `id`='19698' AND `quest`='29595';

https://www.wowhead.com/quest=264/until-death-do-us-part
https://www.wowhead.com/npc=5543/clarice-foster
https://www.wowhead.com/object=24776/yurivs-tombstone

 

DELETE FROM `creature_questender` WHERE `id`='5543' AND `quest`='264';

Tried to farm a pet and noticed, that some mobs got no loot.

Patch Content:

https://www.wowhead.com/npc=78674/ironmarch-scorcher
https://www.wowhead.com/npc=76556/ironmarch-grunt
https://www.wowhead.com/npc=78670/ironmarch-warcaster
https://www.wowhead.com/npc=78667/ironmarch-legionnaire

https://www.wowhead.com/item=118675/time-locked-box
https://www.wowhead.com/item=112684/damaged-weaponry
https://www.wowhead.com/item=112463/battered-armor-fragments
https://www.wowhead.com/item=44754/severed-boar-tusk

DELETE FROM `creature_loot_template` WHERE `entry` IN ('78674','76556','78670','78667');
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `shared`) VALUES 
(78674, 118675, 0.02, 0, 0, 1, 1, 0),
(78674, 112463, 100, 0, 0, 1, 1, 0),
(78674, 112684, 37, 0, 0, 1, 1, 0),
(78674, 44754, 0.03, 0, 0, 1, 1, 0),
(76556, 118675, 0.04, 0, 0, 1, 1, 0),
(76556, 112463, 78, 0, 0, 1, 1, 0),
(76556, 112684, 32, 0, 0, 1, 1, 0),
(78670, 118675, 0.2, 0, 0, 1, 1, 0),
(78670, 112463, 100, 0, 0, 1, 1, 0),
(78670, 112684, 38, 0, 0, 1, 1, 0),
(78667, 118675, 0.06, 0, 0, 1, 1, 0),
(78667, 112463, 100, 0, 0, 1, 1, 0),
(78667, 112684, 37, 0, 0, 1, 1, 0),
(78667, 2295, 0.02, 0, 0, 1, 1, 0);

UPDATE `creature_template` SET `lootid`='78674' WHERE `entry`='78674';
UPDATE `creature_template` SET `lootid`='76556' WHERE `entry`='76556';
UPDATE `creature_template` SET `lootid`='78670' WHERE `entry`='78670';
UPDATE `creature_template` SET `lootid`='78667' WHERE `entry`='78667';

Empty object without any loot. Data1 might have a different ID
https://www.wowhead.com/object=278403/slimy-mackerel-school

https://www.wowhead.com/item=152544/slimy-mackerel

-- Slimy Mackerel School                     -278403
UPDATE `gameobject_template` SET `Data1`='278403' WHERE  `entry`=278403;

DELETE FROM `gameobject_loot_template` WHERE `Entry` = 278403;
INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(278403, 152544, 0, 100, 0, 1, 1, 1, 1, 'Slimy Mackerel');

So, i did the achievement https://www.wowhead.com/achievement=12588/eat-your-greens in Nazmir and noticed, that all the buffs stack. I watched some retail videos where this was not the case.
Note: each buff gives 10% stat, like crit, mastery and so on
Note2: the ID 5001 is custom

Patch Content:
https://www.wowhead.com/spell=273779
https://www.wowhead.com/spell=273797
https://www.wowhead.com/spell=275054
https://www.wowhead.com/spell=273781
https://www.wowhead.com/spell=275032
https://www.wowhead.com/spell=275059

DELETE FROM `spell_group` WHERE `id`='5001';
INSERT INTO `spell_group` (`id`,`spell_id`) VALUES 
('5001','273779'),
('5001','273797'),
('5001','275054'),
('5001','273781'),
('5001','275032'),
('5001','275059');
DELETE FROM `spell_group_stack_rules` WHERE `group_id`='5001';
INSERT INTO `spell_group_stack_rules` (`group_id`,`stack_rule`) VALUES 
('5001','1');

Empty object without any loot. Data1 might have a different ID

Patch Content:
https://www.wowhead.com/item=152547/great-sea-catfish

https://www.wowhead.com/object=278399/great-sea-catfish-school

-- Great Sea Catfish School                       -278399
UPDATE `gameobject_template` SET `Data1`='278399' WHERE  `entry`=278399;

DELETE FROM `gameobject_loot_template` WHERE `Entry` = 278399;
INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(278399, 152547, 0, 100, 0, 1, 1, 1, 1, 'Great Sea Catfish');

The Bonus Quest https://www.wowhead.com/quest=57591/spirit-drinker does not provide any reputation, which was odd for me. I checked on Youtube and several videos, showing how players got reputation from this quest. And of course, there are more quest with this ID but only 57591 is available on Firestorm.
I'm not really used to quest_template_addon so bear with me for any mistakes.

Fix:
 

UPDATE `quest_template_addon` SET `RequiredMinRepFaction`='2417',`RequiredMaxRepFaction`='2417',`RequiredMinRepValue`='15',`RequiredMaxRepValue`='15'  WHERE `ID`='57591';

Well, i guess this got correctly implemented, so i think the npcflag for questgivers is not given. Should also be a Blackmarket auctionhouse but i doubt you guys gonna implement it anyway.

Patch Content:
https://www.wowhead.com/npc=160081/taxera

Fix:
 

UPDATE `creature_template` SET `npcflags`='3' WHERE `entry`='160081';

Confirmed Bug Report => Questender missing.

Patch Content:
https://www.wowhead.com/quest=62259/anima-laden-dreamcatcher
https://www.wowhead.com/npc=165341/droman-dawnblossom

Fix:
 

-- #62259/Quest - Anima-Laden Dreamcatcher - Add missing questender
UPDATE `creature_template` SET `npcflag`='2' WHERE `entry`='165341';
DELETE FROM `creature_questender` WHERE `id`='165341' AND `quest`='62259';
INSERT INTO `creature_questender` (`id`,`quest`) VALUES 
('165341','62259');

The item https://www.wowhead.com/item=156833/katys-stampwhistle can be obtained on the Legion realm, but the NPC itself does not work.

I do not have access to any sniffs to get the Blizzlike gossip ID or the correct Broadcast ID, so i added a custom ID and leave the broadcast ID empty.

Patch Content:
https://www.wowhead.com/item=156833/katys-stampwhistle
https://www.wowhead.com/npc=132969/katy-stampwhistle

Fix:
 

-- #132969/NPC - Katy Stampwhistle - Fix Toy #156833
UPDATE `creature_template` SET `gossip_menu_id`='132969' WHERE `entry`='132969';
DELETE FROM `gossip_menu` WHERE `MenuId`='132969';
INSERT INTO `gossip_menu` (`MenuId`,`TextId`,`VerifiedBuild`) VALUES 
('132969','132969','25632');
DELETE FROM `gossip_menu_option` WHERE `MenuId`='132969';
INSERT INTO `gossip_menu_option` (`MenuId`,`OptionIndex`,`OptionIcon`,`OptionText`,`OptionBroadcastTextId`,`OptionType`,`OptionNpcFlag`,`VerifiedBuild`) VALUES 
('132969','1','11','I\'d like to check my mail.','0','1','67108864','25632');
DELETE FROM `npc_text` WHERE `ID`='132969';
INSERT INTO `npc_text` (`ID`,`text0_1`,`BroadcastTextID0`,`Probability0`,`VerifiedBuild`) VALUES 
('132969','Salutions! How can i help you?','0','1','25632');

Soulwell spawned by https://www.wowhead.com/spell=29893/create-soulwell and collected into sniff data and later spawned as permanent spawn.

Patch Content:
Gameobject = 303148
https://www.wowhead.com/spell=29893/create-soulwell

Fix:
 

DELETE FROM `gameobject` WHERE `id`='303148' AND `ZoneID`='6134';

Hunter pet is spawned there from sniffs.

Patch Content:
https://www.wowhead.com/npc=42710/young-dragonhawk

https://www.wowhead.com/krasarang-wilds


Fix:
 

DELETE FROM `creature` WHERE `id`='42710' AND `ZoneID`='6134';

Vendor sells no items.
It's not a sniff, just the infos from wowhead. There are no infos about intem context and support bonus on Trinity Wiki.

Patch Content:
https://www.wowhead.com/npc=174493/nava
https://www.wowhead.com/item=173859/ethereal-pomegranate
https://www.wowhead.com/item=174284/empyrean-fruit-salad
https://www.wowhead.com/item=174281/purified-skyspring-water
https://www.wowhead.com/item=174282/airy-ciabatta
https://www.wowhead.com/item=174285/candied-walnuts

Fix:
 

DELETE FROM `npc_vendor` WHERE `entry`=174493;
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
(174493, 1, 173859, 0, 0, 1, 0, 0, 36228),
(174493, 2, 174284, 0, 0, 1, 0, 0, 36228),
(174493, 3, 174281, 0, 0, 1, 0, 0, 36228),
(174493, 4, 174282, 0, 0, 1, 0, 0, 36228),
(174493, 5, 174285, 0, 0, 1, 0, 0, 36228);

The Required Level to learn this spell is still set to Lv 110. Should be level 5.

https://www.wowhead.com/spell=264630/kul-tiran-tailoring

 

UPDATE `npc_trainer` SET `ReqLevel`='5' WHERE `ID`='153817' AND `SpellID`='264630';

According to the Bugtracker report, the creature https://www.wowhead.com/npc=157466/anh-de-the-loyal cannot be tamed
Type 1 = Beast
Type_flags 1 = CREATURE_TYPEFLAGS_TAMEABLE

Note: Probably also bugged on the Shadowlands realm.

UPDATE `creature_template` SET `type`='1',`type_flags`='1' WHERE `entry`='157466';

So, this Fix got accepted some months ago, but i guess, not applied? the creatures still cannot be target/selected.
 

The NPC https://www.wowhead.com/npc=11665/lava-annihilator doesn't give the reputation https://www.wowhead.com/faction=749/hydraxian-waterlords

DELETE FROM `creature_onkill_reputation` WHERE `creature_id`='11665';
INSERT INTO `creature_onkill_reputation` (`creature_id`,`RewOnKillRepFaction1`,`MaxStanding1`,`RewOnKillRepValue1`) VALUES
('11665','749','5','20');

Creature https://www.wowhead.com/npc=37088/elder-zhevra is not selectable cause by the unit_flags 33554432 UNIT_FLAG_NOT_SELECTABLE

UPDATE `creature_template` SET `unit_flags`='0' WHERE `entry`='37088';

Removing some old https://www.wowhead.com/item=118436 from https://www.wowhead.com/npc=87022/bob

DELETE FROM `npc_vendor` WHERE `entry`='87022' AND `item` IN ('118456','118441','118446','118431','118436');

Patch Content:

While questing in Silithus, i've encountered a few bugs on Quests.

https://www.wowhead.com/quest=9415/report-to-marshal-bluewall can be accepted and turned in by the same Quest giver.
https://www.wowhead.com/quest=28867/nethergarde-needs-you can also be accepted and turned in by the same Quest giver.
https://www.wowhead.com/quest=9419/scouring-the-desert is bugged and by reading the Wowhead comments. a few people wrote that it got removed in Legion, around 7.2.5.

DELETE FROM `creature_questender` WHERE `id` IN ('50588','5393') AND `quest`='28867';
DELETE FROM `creature_questender` WHERE `id` IN ('17082','17080') AND `quest`='9415';
INSERT INTO `creature_questender` (`id`,`quest`) VALUES 
('5393','28867'),
('17080','9415');
-- Quest 9422 & 9419 got removed with Legion (comments say around 7.2.5
UPDATE `quest_template` SET `QuestType`='1' WHERE `id`='9419';
UPDATE `quest_template` SET `QuestType`='1' WHERE `id`='9422';