[Declined][Battle for Azeroth]: Northrend Mining Trainers

[Ragethreat]

Title: Northrend Mining Trainers
Bugtracker Link:

https://firestorm-servers.com/en/report/see_report/84212

Patch Content:

 

In Order: Northrend Mining, Smelt Cobalt, Smelt Saronite, Smelt Titansteel, Smelt Titanium.

 

Fendrig Redbeard:

DELETE FROM `npc_trainer` WHERE `ID`='26999' AND `SpellID`='50310';
DELETE FROM `npc_trainer` WHERE `ID`='26999' AND `SpellID`='49252';
DELETE FROM `npc_trainer` WHERE `ID`='26999' AND `SpellID`='49258';
DELETE FROM `npc_trainer` WHERE `ID`='26999' AND `SpellID`='55208';
DELETE FROM `npc_trainer` WHERE `ID`='26999' AND `SpellID`='55211';
INSERT INTO `npc_trainer` (`ID`, `SpellID`, `MoneyCost`, `ReqSkillLine`, `ReqSkillRank`, `ReqLevel`) VALUES ('26999', '50310', '350000', 'Mining', '350', '58'),
('26999', '49252', '100000', 'Mining', '350', '58'),
('26999', '49258', '150000', 'Mining', '400', '58'),
('26999', '55208', '200000', 'Mining', '450', '58'),
('26999', '55211', '200000', 'Mining', '450', '58');

Grumbol Stoutpick:

DELETE FROM `npc_trainer` WHERE `ID`='26912' AND `SpellID`='50310';
DELETE FROM `npc_trainer` WHERE `ID`='26912' AND `SpellID`='49252';
DELETE FROM `npc_trainer` WHERE `ID`='26912' AND `SpellID`='49258';
DELETE FROM `npc_trainer` WHERE `ID`='26912' AND `SpellID`='55208';
DELETE FROM `npc_trainer` WHERE `ID`='26912' AND `SpellID`='55211';
INSERT INTO `npc_trainer` (`ID`, `SpellID`, `MoneyCost`, `ReqSkillLine`, `ReqSkillRank`, `ReqLevel`) VALUES ('26912', '50310', '350000', 'Mining', '350', '58'),
('26912', '49252', '100000', 'Mining', '350', '58'),
('26912', '49258', '150000', 'Mining', '400', '58'),
('26912', '55208', '200000', 'Mining', '450', '58'),
('26912', '55211', '200000', 'Mining', '450', '58');

 

 

Edited September 15, 2019 by Ragethreat
Set SQL in code section

[Thyvene]

Greetings @Ragethreat,

Your patch is declined, as the same as 

we can't accept custom fixes or handmade fixes on that table, it need to come from sniff.

Regards, Thyvene.