[can t open wow]

50 minutes ago, Alan said:

This is most likely because you are launching it for the first time or using the minimal launcher, please allow it to download the data it requires to launch after selecting region. It can take up to minutes or sometimes longer however, if the game has not opened after the amount of time as lapsed I would recommend ending all wow processes and relaunching the game,

 

 

[Unable to launch the game]

Check your Task Manager. It runs a big download before loading. Mine took quite a while.

 

Edit: I should note that I use the full client and I can load the login screen fine.

[Buy and Sell Characters on Sethraliss Realm]

I'd like to be able to buy a character too. Due to bugs I can't progress the quest line to unlock Lightforged Draenei. Honestly I'd pay £20 to skip the grind and just unlock them on my account. So annoying.

[Flight Path Bug?]

I get it too but it always flies me to a single point then drops me off. It's really annoying when I was out in the middle of nowhere.

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

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');

 

 

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

Updated for other missing recipes. In order: Outland Mining, Smelt Fel Iron, Earth Shatter, Fire Sunder, Smelt Adamantite, Smelt Eternium, Smelt Felsteel, Smelt Khorium, Smelt Hardened Adamantite.

Hurnak Grimmord

DELETE FROM `npc_trainer` WHERE `ID`='18779' AND `SpellID`='29354';
DELETE FROM `npc_trainer` WHERE `ID`='18779' AND `SpellID`='29356';
DELETE FROM `npc_trainer` WHERE `ID`='18779' AND `SpellID`='34750';
DELETE FROM `npc_trainer` WHERE `ID`='18779' AND `SpellID`='35751';
DELETE FROM `npc_trainer` WHERE `ID`='18779' AND `SpellID`='29358';
DELETE FROM `npc_trainer` WHERE `ID`='18779' AND `SpellID`='29359';
DELETE FROM `npc_trainer` WHERE `ID`='18779' AND `SpellID`='29360';
DELETE FROM `npc_trainer` WHERE `ID`='18779' AND `SpellID`='29361';
DELETE FROM `npc_trainer` WHERE `ID`='18779' AND `SpellID`='29686';
INSERT INTO `npc_trainer` (`ID`, `SpellID`, `MoneyCost`, `ReqSkillLine`, `ReqSkillRank`, `ReqLevel`) VALUES ('18779', '29354', '100000', 'Mining', '275', '58'),
('18779', '29356', '40000', 'Mining', '275', '58'),
('18779', '34750', '10000', 'Mining', '300', '58'),
('18779', '35751', '10000', 'Mining', '300', '58'),
('18779', '29358', '40000', 'Mining', '325', '58'),
('18779', '29359', '40000', 'Mining', '350', '58'),
('18779', '29360', '40000', 'Mining', '350', '58'),
('18779', '29361', '100000', 'Mining', '375', '58'),
('18779', '29686', '100000', 'Mining', '375', '58');

 

Also for Krugosh for Horde:

DELETE FROM `npc_trainer` WHERE `ID`='18747' AND `SpellID`='29354';
DELETE FROM `npc_trainer` WHERE `ID`='18747' AND `SpellID`='29356';
DELETE FROM `npc_trainer` WHERE `ID`='18747' AND `SpellID`='34750';
DELETE FROM `npc_trainer` WHERE `ID`='18747' AND `SpellID`='35751';
DELETE FROM `npc_trainer` WHERE `ID`='18747' AND `SpellID`='29358';
DELETE FROM `npc_trainer` WHERE `ID`='18747' AND `SpellID`='29359';
DELETE FROM `npc_trainer` WHERE `ID`='18747' AND `SpellID`='29360';
DELETE FROM `npc_trainer` WHERE `ID`='18747' AND `SpellID`='29361';
DELETE FROM `npc_trainer` WHERE `ID`='18747' AND `SpellID`='29686';
INSERT INTO `npc_trainer` (`ID`, `SpellID`, `MoneyCost`, `ReqSkillLine`, `ReqSkillRank`, `ReqLevel`) VALUES ('18747', '29354', '100000', 'Mining', '275', '58'),
('18747', '29356', '40000', 'Mining', '275', '58'),
('18747', '34750', '10000', 'Mining', '300', '58'),
('18747', '35751', '10000', 'Mining', '300', '58'),
('18747', '29358', '40000', 'Mining', '325', '58'),
('18747', '29359', '40000', 'Mining', '350', '58'),
('18747', '29360', '40000', 'Mining', '350', '58'),
('18747', '29361', '100000', 'Mining', '375', '58'),
('18747', '29686', '100000', 'Mining', '375', '58');

 

Wasn't sure if the DELETE command could be put into an array or not so kept it simple. Same for mixing both trainers into one statement.

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

Title: Outland Mining Trainers
Bugtracker Link:

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

Patch Content:

Hurnak Grimmord - Outland Mining - 10G - Mining - mining 275 req - lvl 58 req

INSERT INTO 'npc_trainer' ('ID', 'SpellID', 'MoneyCost', 'ReqSkillLine', 'ReqSkillRank', 'ReqLevel') VALUES ('18779', '29354', '100000', 'Mining', '275', '58')

Sorry if this is poorly written or plain incorrect. First time submitting a patch. Once/If this gets confirmed I'll look into adding the entry level Outland recipes to the various trainers in Hellfire Peninsula.