[Battle for Azeroth]: Missing Engineering Stuff

[Florix]

Title: Missing Engineering Stuff
Bugtracker Link:

https://firestorm-servers.com/en/report/index

Patch Content:

Missing spells/Items added on Patch 8.1.5 and 8.3.0
https://www.wowhead.com/npc=136059/layla-evenkeel
https://www.wowhead.com/npc=131840/shuga-blastcaps
https://www.wowhead.com/npc=138023/zelda-sparkslide
https://www.wowhead.com/spell=305860/uncanny-combatants-stormsteel-destroyer
https://www.wowhead.com/spell=305863/uncanny-combatants-discombobulator
https://www.wowhead.com/item=168025/book-of-schematics-ub3r-spanner

 

 

-- 136059 Layla Evenkeel
DELETE FROM `npc_trainer` WHERE `ID`='136059' AND `SpellID` IN ('305863','305860');
INSERT INTO `npc_trainer` VALUES 
('136059','305863','1000000','202','170','0','0'),
('136059','305860','1200000','202','170','0','0');
-- Shuga Blastcaps
DELETE FROM `npc_trainer` WHERE `ID`='131840' AND `SpellID` IN ('305863','305860');
INSERT INTO `npc_trainer` VALUES 
('131840','305863','1000000','202','170','0','0'),
('131840','305860','1200000','202','170','0','0');
-- Zelda Sparkslide
DELETE FROM `npc_trainer` WHERE `ID`='138023' AND `SpellID` IN ('305863','305860');
INSERT INTO `npc_trainer` VALUES 
('138023','305863','1000000','202','170','0','0'),
('138023','305860','1200000','202','170','0','0');
-- 168025 - Book of Schematics: Ub3r-Spanner
DELETE FROM `npc_vendor` WHERE `item`='168025';
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
(131840, 0, 168025, 0, 0, 1, 0, 0, 29701),
(136059, 0, 168025, 0, 0, 1, 0, 0, 29701),
(150631, 0, 168025, 0, 0, 1, 0, 0, 29701), 
(150630, 0, 168025, 0, 0, 1, 0, 0, 29701);