Trinitycore: [WIP] [master] Trainer spells missing
rev 9d4c568596fbfe911f0edb0a92d75b175ad900af
the trainer still can not learn spells
Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.
deadmanevil
All 61 comments
Well I went to put a bounty on this, paid it but its not updating.
Keldo
on 21 Sep 2015
This can probably be dumped from wowhead.
Killyana
on 16 Oct 2015
Any news About the trainer NPC
haykan
on 19 Feb 2016
No.
Aokromes
on 19 Feb 2016
Is this a simple matter of populating the database with info from Wowhead referencing the proper ID of the trainers? If so, I'd be happy to give it a shot as to help out a bit.
Cache42
on 4 May 2016
Afaik, yes.
DDuarte
on 4 May 2016
A lot of trainers are fixed, plz supply a list of missing trainers.
Aokromes
on 6 Jun 2016
TrinityCore rev. 22d29ce0494c 2016-07-10 11:27:38 +0200 (6.x branch) (Win64, Release, Static)
TDB 6.04 plus updates up to and including 2016_07_05_02_world.sql
Thrallmar:
18751 Kalaen <Jewelcrafting Trainer> - working as intended
18988 Baxter <Cooking Trainer> - vendor window available, training option inactive
18749 Dalinna <Tailoring Trainer> - gossip window with text only, no options
18755 Moorutu <Skinning Trainer> - no gossip available, no interaction
18754 Barim Spilthoof <Leatherworking Trainer> - vendor window opens, training not available
18747 Krugosh <Mining Trainer> - no gossip available, no interaction
18752 Zebig <Engineering Trainer> - vendor window opens, training option not available
16583 Rohok <Blacksmithing Trainer> - gossip window with text only, no options
16588 Apothecary Antonivich <Alchemy Trainer> - vendor option ok, training option inactive
18748 Ruak Stronghorn <Herbalism Trainer> - no gossip available, no interaction
30722 Neferatti <Inscription Trainer> - no gossip available, no interaction
18753 Felannia <Enchanting Trainer> - working as intended
Falcon Watch:
18991 Arsella <First Aid Trainer> - vendor window opens, training option not available
Silvermoon City & Eversong Woods:
15501 Aleina <Jewelcrafting Trainer> - trainer spell list only (working as intended?)
All the other trainers are either not responding (skinning/leatherworking) or only vendor option works
ghost
on 10 Jul 2016
I vote aliance sniffs fucked horde trainers.
Aokromes
on 10 Jul 2016
I've done the first aid trainers and they are working now. Just don't know how to get them on github. Looked thru all the howto's but it's Chinese to me. I will attach the SQL file and perhaps somebody can tell me step by step how I work this to get it on github?
first aid.zip
clintskie
on 19 Nov 2016
@clintskie : content from your .zip file sorted by ID & SpellID :
-- First Aid trainers
DELETE FROM `npc_trainer` WHERE `ID` = 202007 OR `SpellID` = -202007;
INSERT INTO `npc_trainer` (`ID`,`SpellID`,`MoneyCost`,`ReqSkillLine`,`ReqSkillRank`,`ReqLevel`) VALUES
(2326, -202007, 0, 0, 0, 0), -- Thamner Pol
(2329, -202007, 0, 0, 0, 0), -- Michelle Belle
(3181, -202007, 0, 0, 0, 0), -- Fremal Doohickey
(4211, -202007, 0, 0, 0, 0), -- Dannelor
(4591, -202007, 0, 0, 0, 0), -- Mary Edras
(5150, -202007, 0, 0, 0, 0), -- Nissa Firestone
(5759, -202007, 0, 0, 0, 0), -- Nurse Neela
(5939, -202007, 0, 0, 0, 0), -- Vira Younghoof
(5943, -202007, 0, 0, 0, 0), -- Rawrk
(6094, -202007, 0, 0, 0, 0), -- Byancie
(16272, -202007, 0, 0, 0, 0), -- Kanaria
(16662, -202007, 0, 0, 0, 0), -- Alestus
(17214, -202007, 0, 0, 0, 0), -- Anchorite Fateema
(18990, -202007, 0, 0, 0, 0), -- Burko
(22477, -202007, 0, 0, 0, 0), -- Anchorite Ensham
(26992, -202007, 0, 0, 0, 0), -- Brynna Wilson
(28706, -202007, 0, 0, 0, 0), -- Olisarra the Kind
(29233, -202007, 0, 0, 0, 0), -- Nurse Applewood
(33621, -202007, 0, 0, 0, 0), -- First Aid (bookshelf trainer library, The Scryers)
(36615, -202007, 0, 0, 0, 0), -- Doc Zapnozzle
(45286, -202007, 0, 0, 0, 0), -- KTC Train-a-Tron Deluxe
(45540, -202007, 0, 0, 0, 0), -- Krenk Choplimb
(49879, -202007, 0, 0, 0, 0), -- Doc Zapnozzle
(54614, -202007, 0, 0, 0, 0), -- Mishka
(56227, -202007, 0, 0, 0, 0), -- Mishka
(56796, -202007, 0, 0, 0, 0), -- Angela Leifeld
(59077, -202007, 0, 0, 0, 0), -- Apothecary Cheng
(64482, -202007, 0, 0, 0, 0), -- Healer Nan
(65983, -202007, 0, 0, 0, 0), -- Soraka
(66222, -202007, 0, 0, 0, 0), -- Elder Muur
(85930, -202007, 0, 0, 0, 0), -- Telys Vinemender
(86034, -202007, 0, 0, 0, 0), -- Wei Suremend
(92931, -202007, 0, 0, 0, 0), -- Mishka
(93529, -202007, 0, 0, 0, 0), -- Olisarra the Kind
(202007, 3276, 100, 129, 40, 0), -- Heavy Linen Bandage
(202007, 3277, 250, 129, 80, 0), -- Wool Bandage
(202007, 3278, 1000, 129, 115, 0), -- Heavy Wool Bandage
(202007, 3279, 100, 0, 0, 0), -- Apprentice First Aid, rank 1
(202007, 3280, 500, 129, 50, 0), -- Journeyman First Aid, rank 2
(202007, 7928, 5000, 129, 150, 0), -- Silk Bandage
(202007, 7929, 5000, 129, 180, 0), -- Heavy Silk Bandage
(202007, 7934, 250, 129, 80, 0), -- Anti-Venom
(202007, 10840, 10000, 129, 210, 0), -- Mageweave Bandage
(202007, 10841, 10000, 129, 240, 0), -- Heavy Mageweave Bandage
(202007, 10847, 25000, 129, 200, 35), -- Artisan First Aid, rank 4
(202007, 18629, 20000, 129, 260, 0), -- Runecloth Bandage
(202007, 18630, 20000, 129, 290, 0), -- Heavy Runecloth Bandage
(202007, 27032, 20000, 129, 300, 35), -- Netherweave Bandage
(202007, 27033, 12900, 129, 325, 50), -- Heavy Netherweave Bandage
(202007, 45542, 10, 129, 350, 0), -- First Aid, rank 6
(202007, 45545, 40000, 129, 350, 50), -- Frostweave Bandage
(202007, 45546, 60000, 129, 129, 65), -- Heavy Frostweave Bandage
(202007, 54254, 1000, 129, 125, 0), -- Expert First Aid, rank 3
(202007, 74556, 60000, 129, 425, 65), -- Embersilk Bandage
(202007, 74557, 000, 129, 475, 75), -- Heavy Embersilk Bandage
(202007, 74558, 100, 129, 500, 75), -- Field Bandage: Dense Embersilk
(202007, 74559, 10, 129, 425, 0), -- First Aid, rank 7
(202007, 88893, 000, 129, 500, 75), -- Dense Embersilk Bandage
(202007, 102697, 90000, 129, 500, 85), -- Windwool Bandage
(202007, 102698, 110000, 129, 550, 85), -- Heavy Windwool Bandage
(202007, 110406, 10, 129, 0, 0); -- First Aid, rank 8
(I have not looked into the functionality of this query, so I can't vouch for its validity.)
[edit] Now includes comment info for all value rows.
ghost
on 19 Nov 2016
Ran this Query and confirmed to be working on Aletsus in Silvermoon
http://www.wowhead.com/npc=16662/alestus
Keldo
on 19 Nov 2016
I will do some more trainers, only one question shall i repeat and post them here?
Shall i make a complete npc_trainer Query or post them one by one ?
If you want the complete Query i will add the DELETE FROM statement cause then it is necesery.
Last question, where do i post the Query's ( need a lesson in github) :-)
Sorry for the errors in the spelling, i'm not english.
clintskie
on 19 Nov 2016
alway use '''sql for SQL and make sure your DELETE FROM before your INSERT INTO..... it's TC Standards
Keldo
on 20 Nov 2016
Yes, like Keldo already said, put ```sql on a line above your SQL query comment insert. If you need to write more text below the SQL code, use only the 3 back ticks without the sql part on a blank line, then continue writing normal text below it. (This is known as Markdown code.) See also https://guides.github.com/features/mastering-markdown/ or
https://github.com/adam-p/markdown-here/wiki/Markdown-Cheatsheet
ghost
on 20 Nov 2016
-- Mining trainers
DELETE FROM `npc_trainer` WHERE `ID` = 201035 OR `SpellID` = -201035;
INSERT INTO `npc_trainer` (`ID`,`SpellID`,`MoneyCost`,`ReqSkillLine`,`ReqSkillRank`,`ReqLevel`) VALUES
( 1681, -201035, 0, 0, 0, 0), -- Brock Stoneseeker
( 1701, -201035, 0, 0, 0, 0), -- Dank Drizzlecut
( 3001, -201035, 0, 0, 0, 0), -- Brek Stonehoof
( 3137, -201035, 0, 0, 0, 0), -- Matt Johnson
( 3175, -201035, 0, 0, 0, 0), -- Krunn
( 3357, -201035, 0, 0, 0, 0), -- Makaru
( 3555, -201035, 0, 0, 0, 0), -- Johan Focht
( 4254, -201035, 0, 0, 0, 0), -- Geofram Bouldertoe
( 4598, -201035, 0, 0, 0, 0), -- Brom Killian
( 5392, -201035, 0, 0, 0, 0), -- Yarr Hammerstone
( 5513, -201035, 0, 0, 0, 0), -- Gelman Stonehand
( 6297, -201035, 0, 0, 0, 0), -- Kurdram Stonehammer
( 8128, -201035, 0, 0, 0, 0), -- Pikkle
(16663, -201035, 0, 0, 0, 0), -- Belil
(16752, -201035, 0, 0, 0, 0), -- Muaat
(17488, -201035, 0, 0, 0, 0), -- Dulvi
(18747, -201035, 0, 0, 0, 0), -- Krugosh
(18779, -201035, 0, 0, 0, 0), -- Hurnak Grimmord
(18804, -201035, 0, 0, 0, 0), -- Prospector Nachlan
(26912, -201035, 0, 0, 0, 0), -- Grumbol Stoutpick
(26962, -201035, 0, 0, 0, 0), -- Jonathan Lewis
(26976, -201035, 0, 0, 0, 0), -- Brunna Ironaxe
(26999, -201035, 0, 0, 0, 0), -- Fendrig Redbeard
(28698, -201035, 0, 0, 0, 0), -- Jedidiah Handers
(33617, -201035, 0, 0, 0, 0), -- Mining (bookshelf trainer library, The Scryers)
(33640, -201035, 0, 0, 0, 0), -- Hanlir
(33682, -201035, 0, 0, 0, 0), -- Fono
(45286, -201035, 0, 0, 0, 0), -- KTC Train-a-Tron Deluxe
(46357, -201035, 0, 0, 0, 0), -- Gonto
(47384, -201035, 0, 0, 0, 0), -- Lien Farner
(47396, -201035, 0, 0, 0, 0), -- Wembil Taskwidget
(47400, -201035, 0, 0, 0, 0), -- Nedric Sallow
(47420, -201035, 0, 0, 0, 0), -- Iranis Shadebloom
(47431, -201035, 0, 0, 0, 0), -- Valn
(50247, -201035, 0, 0, 0, 0), -- Jack "All-Trades" Derrington
(52170, -201035, 0, 0, 0, 0), -- Gizzik Oregrab
(52642, -201035, 0, 0, 0, 0), -- Foreman Pernic
(57620, -201035, 0, 0, 0, 0), -- Whittler Dewei
(65043, -201035, 0, 0, 0, 0), -- Elder Oakpaw
(65092, -201035, 0, 0, 0, 0), -- Smeltmaster Ashpaw
(66979, -201035, 0, 0, 0, 0), -- Stonebreaker Ruian
(67024, -201035, 0, 0, 0, 0), -- Rockseeker Guo
(85919, -201035, 0, 0, 0, 0), -- Jonath Chainfist
(86014, -201035, 0, 0, 0, 0), -- Murg Stonecrack
-- Spells
(201035, 2657, 0, 186, 0, 0), -- Smelt Copper
(201035, 2658, 200, 186, 75, 0), -- Smelt Silver
(201035, 2659, 200, 186, 65, 0), -- Smelt Bronze
(201035, 2581, 10, 186, 0, 5), -- Apprentice Miner
(201035, 2582, 500, 186, 50, 10), -- Journeyman Miner
(201035, 3304, 50, 186, 65, 0), -- Smelt Tin
(201035, 3307, 500, 186, 125, 0), -- Smelt Iron
(201035, 3308, 2500, 186, 155, 0), -- Smelt Gold
(201035, 3568, 5000, 186, 125, 10), -- Expert Miner
(201035, 3569, 2500, 186, 165, 0), -- Smelt Steel
(201035, 10097, 5000, 186, 175, 0), -- Smelt Mithril
(201035, 10098, 10000, 186, 230, 0), -- Smelt Truesilver
(201035, 10249, 50000, 186, 200, 25), -- Artisan Miner
(201035, 16153, 20000, 186, 250, 0), -- Smelt Thorium
(201035, 29355, 100000, 186, 275, 0), -- Master Miner
(201035, 29356, 40000, 186, 300, 0), -- Smelt Fel Iron
(201035, 29358, 40000, 186, 325, 0), -- Smelt Adamantite
(201035, 29359, 40000, 186, 350, 0), -- Smelt Eternium
(201035, 29360, 40000, 186, 350, 0), -- Smelt Felsteel
(201035, 29361, 100000, 186, 350, 0), -- Smelt Khorium
(201035, 29686, 100000, 186, 375, 0), -- Smelt Hardened Adamantite
(201035, 35750, 10000, 186, 300, 0), -- Earth Shatter
(201035, 35751, 10000, 186, 300, 0), -- Fire Sunder
(201035, 49252, 100000, 186, 350, 0), -- Smelt Cobalt
(201035, 49258, 150000, 186, 400, 0), -- Smelt Saronite
(201035, 50309, 350000, 186, 350, 0), -- Grand Master Miner
(201035, 55211, 200000, 186, 450, 0), -- Smelt Titanium
(201035, 55208, 200000, 186, 450, 0), -- Smelt Titansteel
(201035, 70524, 10000, 186, 250, 0), -- Enchanted Thorium Bar
(201035, 74518, 50000, 186, 425, 0), -- Illustrious Grand Master Miner
(201035, 74529, 50000, 186, 525, 0), -- Smelt Pyrite
(201035, 74530, 50000, 186, 475, 0), -- Smelt Elementium
(201035, 74537, 50000, 186, 500, 0), -- Smelt Hardened Elementium
(201035, 84038, 50000, 186, 425, 0), -- Smelt Obsidium
(201035, 102167, 60000, 186, 600, 0), -- Smelt Trillium
(201035, 102168, 0, 186, 500, 0); -- Zen Master Miner
This the mining stuff, i hope this is what you need :-)
clintskie
on 20 Nov 2016
Hmmmm blacksmithing now give me some time plz.... looks like a lot of work.
clintskie
on 20 Nov 2016
and guys, please comment on the item/quest/npc using standard SQL commenting by using ---
so we know which NPC, Item or Quest your are fixing or implemeting
An example
DELETE FROM `npc_trainer` WHERE `ID` = 16688; --- Lynalis (Silvermoon Leatherworking Trainer)
I Will do that.
Learning a lot from you all, i could nor figure why the first line did not work.
I had to use OR not AND.
Thanks.
clintskie
on 20 Nov 2016
Deleted one line from mining trainers (unused spell).
clintskie
on 21 Nov 2016
Done blacksmithing, i hope this is how it's should be done.
Just tell me what to do to make it better.
-- Blacksmithing trainers
DELETE FROM `npc_trainer` WHERE `ID` = 201004 OR `SpellID` = -201004;
INSERT INTO `npc_trainer` (`ID`,`SpellID`,`MoneyCost`,`ReqSkillLine`,`ReqSkillRank`,`ReqLevel`) VALUES
( 514, -201004, 0, 0, 0, 0), -- Smith Argus
( 1241, -201004, 0, 0, 0, 0), -- Tognus Flintfire
( 2836, -201004, 0, 0, 0, 0), -- Brikk Keencraft
( 2998, -201004, 0, 0, 0, 0), -- Karn Stonehoof
( 3136, -201004, 0, 0, 0, 0), -- Clarise Gnarltree
( 3174, -201004, 0, 0, 0, 0), -- Dwukk
( 3355, -201004, 0, 0, 0, 0), -- Saru Steelfury
( 3478, -201004, 0, 0, 0, 0), -- Traugh
( 3557, -201004, 0, 0, 0, 0), -- Guillaume Sorouy
( 4258, -201004, 0, 0, 0, 0), -- Bengus Deepforge
( 4596, -201004, 0, 0, 0, 0), -- James Van Brunt
( 4888, -201004, 0, 0, 0, 0), -- Marie Holdston
( 5164, -201004, 0, 0, 0, 0), -- Grumnus Steelshaper
( 5511, -201004, 0, 0, 0, 0), -- Therum Deepforge
( 6299, -201004, 0, 0, 0, 0), -- Delfrum Flintbeard
( 7231, -201004, 0, 0, 0, 0), -- Kelgruk Bloodaxe
( 7232, -201004, 0, 0, 0, 0), -- Borgus Steelhand
( 11146, -201004, 0, 0, 0, 0), -- Ironus Coldsteel
( 11177, -201004, 0, 0, 0, 0), -- Okothos Ironrager
( 11178, -201004, 0, 0, 0, 0), -- Borgosh Corebender
( 15400, -201004, 0, 0, 0, 0), -- Arathel Sunforge
( 16583, -201004, 0, 0, 0, 0), -- Rohok
( 16669, -201004, 0, 0, 0, 0), -- Bemarrin
( 16724, -201004, 0, 0, 0, 0), -- Miall
( 17245, -201004, 0, 0, 0, 0), -- Blacksmith Calypso
( 16823, -201004, 0, 0, 0, 0), -- Humphry
( 19341, -201004, 0, 0, 0, 0), -- Grutah
( 20125, -201004, 0, 0, 0, 0), -- Zula Slagfury
( 20214, -201004, 0, 0, 0, 0), -- Kradu Grimblade
( 21209, -201004, 0, 0, 0, 0), -- Dumphry
( 26564, -201004, 0, 0, 0, 0), -- Borus Ironbender
( 26904, -201004, 0, 0, 0, 0), -- Rosina Rivet
( 26952, -201004, 0, 0, 0, 0), -- Kristen Smythe
( 26981, -201004, 0, 0, 0, 0), -- Crog Steelspine
( 26988, -201004, 0, 0, 0, 0), -- Argo Strongstout
( 27034, -201004, 0, 0, 0, 0), -- Josric Fame
( 28694, -201004, 0, 0, 0, 0), -- Alard Schmied
( 29505, -201004, 0, 0, 0, 0), -- Imindril Spearsong
( 29506, -201004, 0, 0, 0, 0), -- Orland Schaeffer
( 29924, -201004, 0, 0, 0, 0), -- Brandig
( 33591, -201004, 0, 0, 0, 0), -- Rekka the Hammer
( 33609, -201004, 0, 0, 0, 0), -- Blacksmithing
( 33631, -201004, 0, 0, 0, 0), -- Barien
( 33675, -201004, 0, 0, 0, 0), -- Onodo
( 37072, -201004, 0, 0, 0, 0), -- Rogg
( 43429, -201004, 0, 0, 0, 0), -- Taryel Firestrike
( 44781, -201004, 0, 0, 0, 0), -- Opuno Ironhorn
( 45548, -201004, 0, 0, 0, 0), -- Kark Helmbreaker
( 47396, -201004, 0, 0, 0, 0), -- Wembil Taskwidget
( 47384, -201004, 0, 0, 0, 0), -- Lien Farner
( 52640, -201004, 0, 0, 0, 0), -- Rolf Karner
( 55684, -201004, 0, 0, 0, 0), -- Jordan Smith
( 65114, -201004, 0, 0, 0, 0), -- Len the Hammer
( 65129, -201004, 0, 0, 0, 0), -- Zen Master Lao
( 85917, -201004, 0, 0, 0, 0), -- Aimee Goldforge
( 86048, -201004, 0, 0, 0, 0), -- Mazdon Bizratchet
( 92183, -201004, 0, 0, 0, 0), -- Alard Schmied
( 92242, -201004, 0, 0, 0, 0), -- Barm Stonebreaker
( 92243, -201004, 0, 0, 0, 0), -- Muirn Ironhorn
( 92264, -201004, 0, 0, 0, 0), -- Felsmith Nal ryssa
( 92265, -201004, 0, 0, 0, 0), -- Urael
( 97261, -201004, 0, 0, 0, 0), -- Alard Schmied
( 99121, -201004, 0, 0, 0, 0), -- Alard Schmied
( 99118, -201004, 0, 0, 0, 0), -- Orland Schaeffer
( 99954, -201004, 0, 0, 0, 0), -- Tognus Flintfire
(104664, -201004, 0, 0, 0, 0), -- Traugh
(106655, -201004, 0, 0, 0, 0), -- Arcanomancer Vridiel
(107890, -201004, 0, 0, 0, 0), -- Clarise Gnarltree
-- Spells
(201004, 2020, 10, 0, 0, 5), -- Apprentice Blacksmith
(201004, 2021, 500, 164, 50, 10), -- Journeyman Blacksmith
(201004, 2661, 100, 164, 35, 0), -- Copper Chain Belt
(201004, 2662, 50, 164, 1, 0), -- Copper Chain Pants
(201004, 2664, 500, 164, 90, 0), -- Runed Copper Bracers
(201004, 2665, 100, 164, 65, 0), -- Coarse Sharpening Stone
(201004, 2666, 200, 164, 70, 0), -- Runed Copper Belt
(201004, 2667, 300, 164, 105, 0), -- Runed Copper Breastplate
(201004, 2668, 300, 164, 105, 0), -- Rough Bronze Leggings
(201004, 2670, 500, 164, 105, 0), -- Rough Bronze Cuirass
(201004, 2672, 500, 164, 120, 0), -- Patterned Bronze Bracers
(201004, 2674, 1000, 164, 125, 0), -- Heavy Sharpening Stone
(201004, 2675, 1000, 164, 145, 0), -- Shining Silver Breastplate
(201004, 2737, 50, 164, 15, 0), -- Copper Mace
(201004, 2738, 50, 164, 20, 0), -- Copper Axe
(201004, 2739, 50, 164, 25, 0), -- Copper Shortsword
(201004, 2740, 200, 164, 110, 0), -- Bronze Mace
(201004, 2741, 200, 164, 115, 0), -- Bronze Axe
(201004, 2742, 200, 164, 120, 0), -- Bronze Shortsword
(201004, 3116, 100, 164, 65, 0), -- Coarse Weightstone
(201004, 3117, 1000, 164, 125, 0), -- Heavy Weightstone
(201004, 3292, 500, 164, 95, 0), -- Heavy Copper Broadsword
(201004, 3293, 250, 164, 35, 0), -- Copper Battle Axe
(201004, 3294, 500, 164, 70, 0), -- Thick War Axe
(201004, 3296, 1000, 164, 130, 0), -- Heavy Bronze Mace
(201004, 3319, 50, 164, 20, 0), -- Copper Chain Boots
(201004, 3320, 100, 164, 25, 0), -- Rough Grinding Stone
(201004, 3323, 100, 164, 40, 0), -- Runed Copper Gauntlets
(201004, 3324, 200, 164, 45, 0), -- Runed Copper Pants
(201004, 3326, 250, 164, 75, 0), -- Coarse Grinding Stone
(201004, 3328, 500, 164, 110, 0), -- Rough Bronze Shoulders
(201004, 3331, 500, 164, 130, 0), -- Silvered Bronze Boots
(201004, 3333, 1000, 164, 135, 0), -- Silvered Bronze Gauntlets
(201004, 3337, 1000, 164, 125, 0), -- Heavy Grinding Stone
(201004, 3491, 600, 164, 105, 0), -- Big Bronze Knife
(201004, 3501, 1000, 164, 165, 0), -- Green Iron Bracers
(201004, 3502, 1250, 164, 170, 0), -- Green Iron Helm
(201004, 3506, 5000, 164, 155, 0), -- Green Iron Leggings
(201004, 3508, 7500, 164, 180, 0), -- Green Iron Hauberk
(201004, 3539, 5000, 164, 125, 20), -- Expert Blacksmith
(201004, 6517, 800, 164, 110, 0), -- Pearl-handled Dagger
(201004, 7223, 1000, 164, 185, 0), -- Golden Scale Bracers
(201004, 7408, 300, 164, 65, 0), -- Heavy Copper Maul
(201004, 7817, 200, 164, 95, 0), -- Rough Bronze Boots
(201004, 8768, 250, 164, 150, 0), -- Iron Buckle
(201004, 8880, 100, 164, 30, 0), -- Copper Dagger
(201004, 9786, 50000, 164, 200, 35), -- Artisan Blacksmith
(201004, 9916, 2500, 164, 200, 0), -- Steel Breastplate
(201004, 9918, 2500, 164, 200, 0), -- Solid Sharpening Stone
(201004, 9920, 2500, 164, 200, 0), -- Solid Grinding Stone
(201004, 9921, 2500, 164, 200, 0), -- Solid Weightstone
(201004, 9926, 5000, 164, 205, 0), -- Heavy Mithril Shoulder
(201004, 9928, 5000, 164, 205, 0), -- Heavy Mithril Gauntlet
(201004, 9931, 5000, 164, 210, 0), -- Mithril Scale Pants
(201004, 9935, 5000, 164, 215, 0), -- Steel Plate Helm
(201004, 9959, 15000, 164, 230, 0), -- Heavy Mithril Breastplate
(201004, 9961, 15000, 164, 230, 0), -- Mithril Coif
(201004, 9968, 20000, 164, 235, 0), -- Heavy Mithril Boots
(201004, 9983, 100, 164, 30, 0), -- Copper Claymore
(201004, 9985, 250, 164, 125, 0), -- Bronze Warhammer
(201004, 9986, 500, 164, 130, 0), -- Bronze Greatsword
(201004, 9987, 500, 164, 135, 0), -- Bronze Battle Axe
(201004, 9993, 10000, 164, 210, 0), -- Heavy Mithril Axe
(201004, 10001, 15000, 164, 230, 0), -- Big Black Mace
(201004, 15972, 7500, 164, 180, 0), -- Glinting Steel Dagger
(201004, 16639, 10000, 164, 250, 0), -- Dense Grinding Stone
(201004, 16640, 10000, 164, 250, 0), -- Dense Weightstone
(201004, 16641, 10000, 164, 250, 0), -- Dense Sharpening Stone
(201004, 16642, 10000, 164, 250, 0), -- Thorium Armor
(201004, 16643, 10000, 164, 250, 0), -- Thorium Belt
(201004, 16644, 10000, 164, 255, 0), -- Thorium Bracers
(201004, 16652, 10000, 164, 280, 0), -- Thorium Boots
(201004, 16653, 10000, 164, 280, 0), -- Thorium Helm
(201004, 16662, 12000, 164, 300, 0), -- Thorium Leggings
(201004, 16969, 15000, 164, 275, 0), -- Ornate Thorium Handaxe
(201004, 16971, 15000, 164, 280, 0), -- Huge Thorium Battleaxe
(201004, 19666, 100, 164, 100, 0), -- Silver Skeleton Key
(201004, 19667, 250, 164, 150, 0), -- Golden Skeleton Key
(201004, 19668, 2500, 164, 200, 0), -- Truesilver Skeleton Key
(201004, 19669, 10000, 164, 275, 0), -- Arcanite Skeleton Key
(201004, 29545, 15000, 164, 300, 0), -- Fel Iron Plate Gloves
(201004, 29547, 15000, 164, 305, 0), -- Fel Iron Plate Belt
(201004, 29548, 20000, 164, 315, 0), -- Fel Iron Plate Boots
(201004, 29549, 20000, 164, 315, 0), -- Fel Iron Plate Pants
(201004, 29550, 25000, 164, 325, 0), -- Fel Iron Breastplate
(201004, 29551, 15000, 164, 300, 0), -- Fel Iron Chain Coif
(201004, 29552, 18000, 164, 310, 0), -- Fel Iron Chain Gloves
(201004, 29553, 20000, 164, 315, 0), -- Fel Iron Chain Bracers
(201004, 29556, 22000, 164, 320, 0), -- Fel Iron Chain Tunic
(201004, 29557, 18000, 164, 310, 0), -- Fel Iron Hatchet
(201004, 29558, 20000, 164, 315, 0), -- Fel Iron Hammer
(201004, 29565, 22000, 164, 320, 0), -- Fel Iron Greatsword
(201004, 29654, 15000, 164, 300, 0), -- Fel Sharpening Stone
(201004, 29845, 10000, 164, 275, 50), -- Master Blacksmith
(201004, 32284, 25000, 164, 325, 0), -- Lesser Rune of Warding
(201004, 34607, 15000, 164, 300, 0), -- Fel Weightstone
(201004, 51298, 35000, 164, 350, 60), -- Grand Master Blacksmith
(201004, 52567, 30000, 164, 370, 0), -- Cobalt Legplates
(201004, 52568, 30000, 164, 350, 0), -- Cobalt Belt
(201004, 52569, 30000, 164, 350, 0), -- Cobalt Boots
(201004, 52570, 30000, 164, 375, 0), -- Cobalt Chestpiece
(201004, 52571, 30000, 164, 370, 0), -- Cobalt Helm
(201004, 52572, 30000, 164, 360, 0), -- Cobalt Shoulders
(201004, 54550, 30000, 164, 360, 0), -- Cobalt Triangle Shield
(201004, 54551, 40000, 164, 395, 0), -- Tempered Saronite Belt
(201004, 54552, 40000, 164, 400, 0), -- Tempered Saronite Boots
(201004, 54553, 40000, 164, 400, 0), -- Tempered Saronite
(201004, 54554, 40000, 164, 395, 0), -- Tempered Saronite Legplates
(201004, 54555, 40000, 164, 405, 0), -- Tempered Saronite Helm
(201004, 54556, 40000, 164, 405, 0), -- Tempered Saronite Shoulders
(201004, 54557, 40000, 164, 390, 0), -- Saronite Defender
(201004, 54917, 30000, 164, 375, 0), -- Spiked Cobalt Helm
(201004, 54918, 30000, 164, 380, 0), -- Spiked Cobalt Boots
(201004, 54941, 30000, 164, 385, 0), -- Spiked Cobalt Shoulders
(201004, 54944, 30000, 164, 385, 0), -- Spiked Cobalt Chestpiece
(201004, 54945, 35000, 164, 390, 0), -- Spiked Cobalt Gauntlets
(201004, 54946, 30000, 164, 395, 0), -- Spiked Cobalt Belt
(201004, 54947, 35000, 164, 395, 0), -- Spiked Cobalt Legplates
(201004, 54948, 30000, 164, 400, 0), -- Spiked Cobalt Bracers
(201004, 54949, 30000, 164, 400, 0), -- Horned Cobalt Helm
(201004, 55013, 40000, 164, 390, 0), -- Saronite Protector
(201004, 55014, 35000, 164, 410, 0), -- Saronite Bulwark
(201004, 55015, 40000, 164, 415, 0), -- Tempered Saronite Gauntlets
(201004, 55017, 40000, 164, 410, 0), -- Tempered Saronite Bracers
(201004, 55055, 40000, 164, 395, 0), -- Brilliant Saronite Legplates
(201004, 55056, 40000, 164, 400, 0), -- Brilliant Saronite Gauntlets
(201004, 55057, 40000, 164, 405, 0), -- Brilliant Saronite Boots
(201004, 55058, 45000, 164, 415, 0), -- Brilliant Saronite Breastplate
(201004, 55174, 50000, 164, 390, 0), -- Honed Cobalt Cleaver
(201004, 55177, 50000, 164, 395, 0), -- Savage Cobalt Slicer
(201004, 55179, 50000, 164, 400, 0), -- Saronite Ambusher
(201004, 55181, 50000, 164, 405, 0), -- Saronite Shiv
(201004, 55182, 40000, 164, 410, 0), -- Furious Saronite Beatstick
(201004, 55200, 35000, 164, 380, 0), -- Sturdy Cobalt Quickblade
(201004, 55201, 35000, 164, 380, 0), -- Cobalt Tenderizer
(201004, 55203, 35000, 164, 385, 0), -- Forged Cobalt Claymore
(201004, 55204, 35000, 164, 390, 0), -- Notched Cobalt War Axe
(201004, 55206, 40000, 164, 405, 0), -- Deadly Saronite Dirk
(201004, 55298, 45000, 164, 420, 0), -- Vengeance Bindings
(201004, 55300, 45000, 164, 420, 0), -- Righteous Gauntlets
(201004, 55301, 45000, 164, 420, 0), -- Daunting Handguards
(201004, 55302, 45000, 164, 425, 0), -- Helm of Command
(201004, 55303, 45000, 164, 425, 0), -- Daunting Legplates
(201004, 55304, 45000, 164, 425, 0), -- Righteous Greaves
(201004, 55305, 45000, 164, 420, 0), -- Savage Saronite Bracers
(201004, 55306, 45000, 164, 420, 0), -- Savage Saronite Pauldrons
(201004, 55307, 45000, 164, 420, 0), -- Savage Saronite Waistguard
(201004, 55308, 45000, 164, 420, 0), -- Savage Saronite Walkers
(201004, 55309, 45000, 164, 420, 0), -- Savage Saronite Gauntlets
(201004, 55310, 45000, 164, 425, 0), -- Savage Saronite Legplates
(201004, 55311, 45000, 164, 425, 0), -- Savage Saronite Hauberk
(201004, 55312, 45000, 164, 425, 0), -- Savage Saronite Skullshield
(201004, 55369, 180000, 164, 440, 0), -- Titansteel Destroyer
(201004, 55370, 15000, 164, 440, 0), -- Titansteel Bonecrusher
(201004, 55371, 15000, 164, 440, 0), -- Titansteel Guardian
(201004, 55372, 12000, 164, 440, 0), -- Spiked Titansteel Helm
(201004, 55373, 12000, 164, 440, 0), -- Tempered Titansteel Helm
(201004, 55374, 12000, 164, 440, 0), -- Brilliant Titansteel Helm
(201004, 55375, 12000, 164, 440, 0), -- Spiked Titansteel Treads
(201004, 55376, 12000, 164, 440, 0), -- Tempered Titansteel Treads
(201004, 55377, 12000, 164, 440, 0), -- Brilliant Titansteel Treads
(201004, 55656, 50000, 164, 415, 0), -- Eternal Belt Buckle
(201004, 55834, 30000, 164, 360, 0), -- Cobalt Bracers
(201004, 55835, 30000, 164, 370, 0), -- Cobalt Gauntlets
(201004, 55839, 42000, 164, 420, 0), -- Titanium Weapon Chain
(201004, 56234, 15000, 164, 440, 0), -- Titansteel Shanker
(201004, 56280, 40000, 164, 410, 0), -- Cudgel of Saronite Justice
(201004, 56357, 42000, 164, 420, 0), -- Titanium Shield Spike
(201004, 56400, 15000, 164, 440, 0), -- Titansteel Shield Wall
(201004, 56549, 45000, 164, 420, 0), -- Ornate Saronite Bracers
(201004, 56550, 45000, 164, 420, 0), -- Ornate Saronite Pauldrons
(201004, 56551, 45000, 164, 420, 0), -- Ornate Saronite Waistguard
(201004, 56552, 45000, 164, 420, 0), -- Ornate Saronite Walkers
(201004, 56553, 45000, 164, 420, 0), -- Ornate Saronite Gauntlets
(201004, 56554, 45000, 164, 425, 0), -- Ornate Saronite Legplates
(201004, 56555, 45000, 164, 425, 0), -- Ornate Saronite Hauberk
(201004, 56556, 45000, 164, 425, 0), -- Ornate Saronite Skullshield
(201004, 59405, 30000, 164, 350, 0), -- Cobalt Skeleton Key
(201004, 59406, 45000, 164, 430, 0), -- Titanium Skeleton Key
(201004, 59436, 40000, 164, 395, 0), -- Brilliant Saronite Belt
(201004, 59438, 40000, 164, 400, 0), -- Brilliant Saronite Bracers
(201004, 59440, 40000, 164, 405, 0), -- Brilliant Saronite Pauldrons
(201004, 59441, 45000, 164, 415, 0), -- Brilliant Saronite Helm
(201004, 59442, 40000, 164, 410, 0), -- Saronite Spellblade
(201004, 61008, 12000, 164, 425, 0), -- Icebane Chestguard
(201004, 61009, 12000, 164, 420, 0), -- Icebane Girdle
(201004, 61010, 12000, 164, 420, 0), -- Icebane Treads
(201004, 63182, 15000, 164, 440, 0), -- Titansteel Spellblade
(201004, 76178, 15000, 164, 425, 0), -- Folded Obsidium
(201004, 76180, 50000, 164, 450, 0), -- Hardened Obsidium Gauntlets
(201004, 76181, 55000, 164, 460, 0), -- Hardened Obsidium Belt
(201004, 76258, 65000, 164, 480, 0), -- Hardened Obsidium Shoulders
(201004, 76259, 65000, 164, 490, 0), -- Hardened Obsidium Legguards
(201004, 76260, 65000, 164, 490, 0), -- Hardened Obsidium Helm
(201004, 76261, 75000, 164, 440, 0), -- Hardened Obsidium Breastplate
(201004, 76262, 40000, 164, 440, 0), -- Redsteel Bracers
(201004, 76263, 50000, 164, 450, 0), -- Redsteel Gauntlets
(201004, 76264, 55000, 164, 460, 0), -- Redsteel Belt
(201004, 76265, 60000, 164, 470, 0), -- Redsteel Boots
(201004, 76266, 65000, 164, 480, 0), -- Redsteel Shoulders
(201004, 76267, 65000, 164, 440, 0), -- Redsteel Legguards
(201004, 76269, 75000, 164, 500, 0), -- Redsteel Helm
(201004, 76270, 75000, 164, 500, 0), -- Redsteel Breastplate
(201004, 76281, 50000, 164, 450, 0), -- Stormforged Gauntlets
(201004, 76283, 55000, 164, 460, 0), -- Stormforged Belt
(201004, 76286, 65000, 164, 480, 0), -- Stormforged Shoulders
(201004, 76287, 65000, 164, 480, 0), -- Stormforged Legguards
(201004, 76288, 65000, 164, 490, 0), -- Stormforged Helm
(201004, 76289, 75000, 164, 500, 0), -- Stormforged Breastplate
(201004, 76291, 50000, 164, 450, 0), -- Hardened Obsidium Shield
(201004, 76433, 50000, 164, 460, 0), -- Decapitator's Razor
(201004, 76434, 60000, 164, 470, 0), -- Cold-Forged Shank
(201004, 76435, 65000, 164, 480, 0), -- Fire-Etched Dagger
(201004, 76436, 65000, 164, 480, 0), -- Lifeforce Hammer
(201004, 76437, 65000, 164, 480, 0), -- Obsidium Executioner
(201004, 76438, 60000, 164, 475, 0), -- Obsidium Skeleton Key
(201004, 76441, 65000, 164, 490, 0), -- Elementium Shield Spike
(201004, 76474, 60000, 164, 470, 0), -- Obsidium Bladespear
(201004, 76667, 40000, 164, 425, 0), -- Illustrious Grand Master
(201004, 110398, 60000, 164, 500, 0), -- Zen Master Blacksmith
(201004, 122576, 60000, 164, 550, 0), -- Ghost-Forged Helm
(201004, 122577, 80000, 164, 540, 0), -- Ghost-Forged Shoulders
(201004, 122578, 80000, 164, 550, 0), -- Ghost-Forged Breastplate
(201004, 122579, 80000, 164, 525, 0), -- Ghost-Forged Gauntlets
(201004, 122580, 80000, 164, 530, 0), -- Ghost-Forged Legplates
(201004, 122581, 80000, 164, 500, 0), -- Ghost-Forged Bracers
(201004, 122582, 80000, 164, 530, 0), -- Ghost-Forged Boots
(201004, 122583, 80000, 164, 525, 0), -- Ghost-Forged Belt
(201004, 122633, 80000, 164, 500, 0), -- Ghostly Skeleton Key
(201004, 122635, 80000, 164, 540, 0), -- Lightsteel Shield
(201004, 122636, 90000, 164, 545, 0), -- Spiritguard Shield
(201004, 122638, 80000, 164, 545, 0), -- Ghost-Forged Blade
(201004, 122639, 80000, 164, 560, 0), -- Phantasmal Hammer
(201004, 122640, 80000, 164, 565, 0), -- Spiritblade Decimator
(201004, 122641, 80000, 164, 565, 0), -- Ghost Shard
(201004, 122642, 80000, 164, 565, 0), -- Masterwork Lightsteel Shield
(201004, 122643, 80000, 164, 565, 0), -- Masterwork Spiritguard Shield
(201004, 122644, 80000, 164, 565, 0), -- Masterwork Forgewire Axe
(201004, 122645, 80000, 164, 565, 0), -- Masterwork Ghost-Forged Blade
(201004, 122646, 80000, 164, 565, 0), -- Masterwork Phantasmal Hammer
(201004, 122647, 80000, 164, 565, 0), -- Masterwork Spiritblade Decimator
(201004, 122648, 80000, 164, 565, 0); -- Masterwork Ghost Shard
What trainer do you want next ?
Can i have some feedback plz "?
clintskie
on 25 Nov 2016
Engineering and Tailoring next?
madcatmk2
on 28 Nov 2016
Okidoki tailoring it is then.
After that engineering.
Will all of this be comited to github ?
clintskie
on 28 Nov 2016
tkrokli already committed your work so far, so just keep it coming :+1: thanks
DDuarte
on 28 Nov 2016
Skinning and Leatherworking needs help too...
Keldo
on 28 Nov 2016
@clintskie : Like DDuarte said above, please see commit https://github.com/TrinityCore/TrinityCore/commit/6a3d5bb9fe5be68424a5677ebde697e9444c90d6 to read the details of your work submitted to the master branch. I made some corrections to a couple of the First Aid costs (checked on wowhead).
ghost
on 29 Nov 2016
Very nice that my work is appreciated. Here's tailoring, will do engineering next.
-- Tailoring trainers
DELETE FROM `npc_trainer` WHERE `ID`= 201039 OR `SpellID`= -201039;
INSERT INTO `npc_trainer` (`ID`,`SpellID`,`MoneyCost`,`ReqSkillLine`,`ReqSkillRank`,`ReqLevel`) VALUES
( 1103, -201039, 0, 0, 0, 0), -- Eldrin
( 1346, -201039, 0, 0, 0, 0), -- Georgio Bolero
( 2399, -201039, 0, 0, 0, 0), -- Daryl Stack
( 2627, -201039, 0, 0, 0, 0), -- Grarnik Goodstitch
( 3004, -201039, 0, 0, 0, 0), -- Tepa
( 3363, -201039, 0, 0, 0, 0), -- Magar
( 3484, -201039, 0, 0, 0, 0), -- Kil'hala
( 3523, -201039, 0, 0, 0, 0), -- Bowen Brisboise
( 3704, -201039, 0, 0, 0, 0), -- Mahani
( 4159, -201039, 0, 0, 0, 0), -- Me'lynn
( 4193, -201039, 0, 0, 0, 0), -- Grondal Moonbreeze
( 4576, -201039, 0, 0, 0, 0), -- Josef Gregorian
( 4578, -201039, 0, 0, 0, 0), -- Josephine Lister
( 5153, -201039, 0, 0, 0, 0), -- Jormund Stonebrow
( 9584, -201039, 0, 0, 0, 0), -- Jalane Ayrole
(11052, -201039, 0, 0, 0, 0), -- Timothy Worthington
(11557, -201039, 0, 0, 0, 0), -- Meilosh
(16366, -201039, 0, 0, 0, 0), -- Sempstress Ambershine
(16640, -201039, 0, 0, 0, 0), -- Keelen Sheets
(16729, -201039, 0, 0, 0, 0), -- Refik
(17487, -201039, 0, 0, 0, 0), -- Erin Kelly
(18749, -201039, 0, 0, 0, 0), -- Dalinna
(18772, -201039, 0, 0, 0, 0), -- Hama
(26914, -201039, 0, 0, 0, 0), -- Benjamin Clegg
(26964, -201039, 0, 0, 0, 0), -- Alexandra McQueen
(26969, -201039, 0, 0, 0, 0), -- Raenah
(27001, -201039, 0, 0, 0, 0), -- Darin Goodstitch
(28699, -201039, 0, 0, 0, 0), -- Charles Worth
(33580, -201039, 0, 0, 0, 0), -- Dustin Vail
(33613, -201039, 0, 0, 0, 0), -- Tailoring book shelf
(33636, -201039, 0, 0, 0, 0), -- Miralisse
(33684, -201039, 0, 0, 0, 0), -- Weaver Aoa
(43428, -201039, 0, 0, 0, 0), -- Faeyrin Willowmoon
(44783, -201039, 0, 0, 0, 0), -- Hiwahi Three-Feathers
(45559, -201039, 0, 0, 0, 0), -- Nivi Weavewell
(84619, -201039, 0, 0, 0, 0), -- Daryl Stack
(85910, -201039, 0, 0, 0, 0), -- Joshua Fuesting
(86004, -201039, 0, 0, 0, 0), -- Saesha Silverblood
(93525, -201039, 0, 0, 0, 0), -- Ainderu Summerleaf
(93542, -201039, 0, 0, 0, 0), -- Tanithria
(95794, -201039, 0, 0, 0, 0), -- Kil'hala
(98908, -201039, 0, 0, 0, 0), -- Ainderu Summerleaf
(98912, -201039, 0, 0, 0, 0), -- Charles Worth
-- Tailoring spells
(201039, 2385, 50, 197, 10, 0), -- Brown Linen Vest
(201039, 2386, 200, 197, 65, 0), -- Linen Boots
(201039, 2392, 50, 197, 40, 0), -- Red Linen Shirt
(201039, 2393, 25, 197, 1, 0), -- White Linen Shirt
(201039, 2394, 50, 197, 40, 0), -- Blue Linen Shirt
(201039, 2395, 300, 197, 70, 0), -- Barbaric Linen Vest
(201039, 2396, 200, 197, 70, 0), -- Green Linen Shirt
(201039, 2397, 200, 197, 60, 0), -- Reinforced Linen Cape
(201039, 2399, 300, 197, 85, 0), -- Green Woolen Vest
(201039, 2401, 300, 197, 95, 0), -- Woolen Boots
(201039, 2402, 250, 197, 75, 0), -- Woolen Cape
(201039, 2406, 200, 197, 100, 0), -- Gray Woolen Shirt
(201039, 2964, 100, 197, 75, 0), -- Bolt of Woolen Cloth
(201039, 3755, 100, 197, 45, 0), -- Linen Bag
(201039, 3757, 200, 197, 80, 0), -- Woolen Bag
(201039, 3813, 800, 197, 150, 0), -- Small Silk Pack
(201039, 3839, 500, 197, 125, 0), -- Bolt of Silk Cloth
(201039, 3840, 100, 197, 35, 0), -- Heavy Linen Gloves
(201039, 3841, 200, 197, 60, 0), -- Green Linen Bracers
(201039, 3842, 300, 197, 70, 0), -- Handstitched Linen Britches
(201039, 3843, 400, 197, 85, 0), -- Heavy Woolen Gloves
(201039, 3845, 300, 197, 80, 0), -- Soft-soled Linen Boots
(201039, 3848, 500, 197, 110, 0), -- Double-stitched Woolen Shoulders
(201039, 3850, 500, 197, 110, 0), -- Heavy Woolen Pants
(201039, 3852, 750, 197, 130, 0), -- Gloves of Meditation
(201039, 3855, 750, 197, 125, 0), -- Spidersilk Boots
(201039, 3859, 750, 197, 150, 0), -- Azure Silk Vest
(201039, 3861, 1000, 197, 185, 0), -- Long Silken Cloak
(201039, 3865, 1000, 197, 175, 0), -- Bolt of Mageweave
(201039, 3866, 250, 197, 110, 0), -- Stylish Red Shirt
(201039, 3871, 500, 197, 170, 0), -- Formal White Shirt
(201039, 3911, 10, 0, 0, 5), -- Apprentice Tailor
(201039, 3912, 500, 197, 50, 10), -- Journeyman Tailor
(201039, 3913, 5000, 197, 125, 20), -- Expert Tailor
(201039, 3914, 50, 197, 30, 0), -- Brown Linen Pants
(201039, 3915, 25, 197, 1, 0), -- Brown Linen Shirt
(201039, 6521, 400, 197, 90, 0), -- Pearl-clasped Cloak
(201039, 6690, 1000, 197, 135, 0), -- Lesser Wizard's Robe
(201039, 7623, 50, 197, 30, 0), -- Brown Linen Robe
(201039, 7624, 50, 197, 30, 0), -- White Linen Robe
(201039, 8465, 50, 197, 40, 0), -- Simple Dress
(201039, 8467, 250, 197, 110, 0), -- White Woolen Dress
(201039, 8483, 500, 197, 160, 0), -- White Swashbuckler's Shirt
(201039, 8489, 750, 197, 175, 0), -- Red Swashbuckler's Shirt
(201039, 8758, 600, 197, 140, 0), -- Azure Silk Pants
(201039, 8760, 600, 197, 145, 0), -- Azure Silk Hood
(201039, 8762, 750, 197, 160, 0), -- Silk Headband
(201039, 8764, 900, 197, 170, 0), -- Earthen Vest
(201039, 8766, 1000, 197, 175, 0), -- Azure Silk Belt
(201039, 8770, 1000, 197, 190, 0), -- Robe of Power
(201039, 8772, 1000, 197, 175, 0), -- Crimson Silk Belt
(201039, 8774, 1000, 197, 180, 0), -- Green Silken Shoulders
(201039, 8776, 50, 197, 15, 0), -- Linen Belt
(201039, 8791, 2500, 197, 185, 0), -- Crimson Silk Vest
(201039, 8799, 3000, 197, 195, 0), -- Crimson Silk Pantaloons
(201039, 8804, 5000, 197, 210, 0), -- Crimson Silk Gloves
(201039, 12045, 50, 197, 20, 0), -- Simple Linen Boots
(201039, 12046, 300, 197, 75, 0), -- Simple Kilt
(201039, 12048, 4000, 197, 205, 0), -- Black Mageweave Vest
(201039, 12049, 4000, 197, 205, 0), -- Black Mageweave Leggings
(201039, 12050, 4000, 197, 210, 0), -- Black Mageweave Robe
(201039, 12052, 5000, 197, 210, 0), -- Shadoweave Pants
(201039, 12053, 5000, 197, 215, 0), -- Black Mageweave Gloves
(201039, 12055, 5500, 197, 215, 0), -- Shadoweave Robe
(201039, 12061, 2500, 197, 215, 0), -- Orange Mageweave Shirt
(201039, 12065, 5000, 197, 225, 0), -- Mageweave Bag
(201039, 12067, 5000, 197, 225, 0), -- Dreamweave Gloves
(201039, 12069, 5000, 197, 225, 0), -- Cindercloth Robe
(201039, 12070, 5000, 197, 225, 0), -- Dreamweave Vest
(201039, 12071, 6000, 197, 225, 0), -- Shadoweave Gloves
(201039, 12072, 6000, 197, 230, 0), -- Black Mageweave Headband
(201039, 12073, 6000, 197, 230, 0), -- Black Mageweave Boots
(201039, 12074, 6000, 197, 230, 0), -- Black Mageweave Shoulders
(201039, 12076, 6500, 197, 235, 0), -- Shadoweave Shoulders
(201039, 12077, 5000, 197, 235, 0), -- Simple Black Dress
(201039, 12079, 6500, 197, 235, 0), -- Red Mageweave Bag
(201039, 12082, 7000, 197, 240, 0), -- Shadoweave Boots
(201039, 12088, 7500, 197, 245, 0), -- Cindercloth Boots
(201039, 12092, 7500, 197, 250, 0), -- Dreamweave Circlet
(201039, 12181, 50000, 197, 200, 35), -- Artisan Tailor
(201039, 18401, 10000, 197, 250, 0), -- Bolt of Runecloth
(201039, 18402, 10000, 197, 255, 0), -- Runecloth Belt
(201039, 18403, 10000, 197, 255, 0), -- Frostweave Tunic
(201039, 18406, 10000, 197, 260, 0), -- Runecloth Robe
(201039, 18407, 10000, 197, 260, 0), -- Runecloth Tunic
(201039, 18409, 10000, 197, 265, 0), -- Runecloth Cloak
(201039, 18410, 10000, 197, 265, 0), -- Ghostweave Belt
(201039, 18411, 10000, 197, 265, 0), -- Frostweave Gloves
(201039, 18413, 10000, 197, 270, 0), -- Ghostweave Gloves
(201039, 18414, 10000, 197, 270, 0), -- Brightcloth Robe
(201039, 18415, 10000, 197, 270, 0), -- Brightcloth Gloves
(201039, 18416, 12500, 197, 275, 0), -- Ghostweave Vest
(201039, 18417, 12500, 197, 275, 0), -- Runecloth Gloves
(201039, 18420, 12500, 197, 275, 0), -- Brightcloth Cloak
(201039, 18421, 12500, 197, 275, 0), -- Wizardweave Leggings
(201039, 18423, 15000, 197, 280, 0), -- Runecloth Boots
(201039, 18424, 15000, 197, 280, 0), -- Frostweave Pants
(201039, 18437, 15000, 197, 285, 0), -- Felcloth Boots
(201039, 18438, 15000, 197, 285, 0), -- Runecloth Pants
(201039, 18441, 15000, 197, 290, 0), -- Ghostweave Pants
(201039, 18442, 15000, 197, 290, 0), -- Felcloth Hood
(201039, 18444, 15000, 197, 295, 0), -- Runecloth Headband
(201039, 18446, 15000, 197, 300, 0), -- Wizardweave Robe
(201039, 18449, 15000, 197, 300, 0), -- Runecloth Shoulders
(201039, 18450, 15000, 197, 300, 0), -- Wizardweave Turban
(201039, 18451, 15000, 197, 300, 0), -- Felcloth Robe
(201039, 18453, 15000, 197, 300, 0), -- Felcloth Shoulders
(201039, 26745, 20000, 197, 300, 0), -- Bolt of Netherweave
(201039, 26746, 15000, 197, 315, 0), -- Netherweave Bag
(201039, 26764, 15000, 197, 310, 0), -- Netherweave Bracers
(201039, 26765, 15000, 197, 310, 0), -- Netherweave Belt
(201039, 26770, 20000, 197, 320, 0), -- Netherweave Gloves
(201039, 26771, 20000, 197, 325, 0), -- Netherweave Pants
(201039, 26772, 20000, 197, 335, 0), -- Netherweave Boots
(201039, 26791, 100000, 197, 275, 50), -- Master Tailor
(201039, 31460, 20000, 197, 300, 0), -- Netherweave Net
(201039, 51308, 350000, 197, 350, 65), -- Grand Master Tailor
(201039, 55898, 50000, 197, 360, 0), -- Frostweave Net
(201039, 55899, 50000, 197, 350, 0), -- Bolt of Frostweave
(201039, 55900, 125000, 197, 400, 0), -- Bolt of Imbued Frostweave
(201039, 55901, 50000, 197, 395, 0), -- Duskweave Leggings
(201039, 55902, 50000, 197, 350, 0), -- Frostwoven Shoulders
(201039, 55903, 50000, 197, 360, 0), -- Frostwoven Robe
(201039, 55904, 50000, 197, 360, 0), -- Frostwoven Gloves
(201039, 55906, 50000, 197, 375, 0), -- Frostwoven Boots
(201039, 55907, 50000, 197, 380, 0), -- Frostwoven Cowl
(201039, 55908, 50000, 197, 370, 0), -- Frostwoven Belt
(201039, 55910, 80000, 197, 385, 0), -- Mystic Frostwoven Shoulders
(201039, 55911, 80000, 197, 390, 0), -- Mystic Frostwoven Robe
(201039, 55913, 80000, 197, 385, 0), -- Mystic Frostwoven Wristwraps
(201039, 55914, 50000, 197, 395, 0), -- Duskweave Belt
(201039, 55919, 100000, 197, 395, 0), -- Duskweave Cowl
(201039, 55920, 50000, 197, 400, 0), -- Duskweave Wristwraps
(201039, 55921, 100000, 197, 405, 0), -- Duskweave Robe
(201039, 55922, 100000, 197, 405, 0), -- Duskweave Gloves
(201039, 55923, 100000, 197, 410, 0), -- Duskweave Shoulders
(201039, 55924, 125000, 197, 410, 0), -- Duskweave Boots
(201039, 55925, 125000, 197, 415, 0), -- Black Duskweave Leggings
(201039, 55941, 125000, 197, 420, 0), -- Black Duskweave Robe
(201039, 55943, 125000, 197, 415, 0), -- Black Duskweave Wristwraps
(201039, 55995, 50000, 197, 400, 0), -- Yellow Lumberjack Shirt
(201039, 56000, 50000, 197, 400, 0), -- Green Workman's Shirt
(201039, 56001, 100000, 197, 415, 0), -- Moonshroud
(201039, 56002, 100000, 197, 415, 0), -- Ebonweave
(201039, 56003, 100000, 197, 415, 0), -- Spellweave
(201039, 56007, 80000, 197, 410, 0), -- Frostweave Bag
(201039, 56008, 100000, 197, 400, 0), -- Shining Spellthread
(201039, 56010, 100000, 197, 400, 0), -- Azure Spellthread
(201039, 56014, 100000, 197, 390, 0), -- Cloak of the Moon
(201039, 56015, 100000, 197, 395, 0), -- Cloak of Frozen Spirits
(201039, 56018, 100000, 197, 425, 0), -- Hat of Wintry Doom
(201039, 56019, 100000, 197, 420, 0), -- Silky Iceshard Boots
(201039, 56020, 100000, 197, 420, 0), -- Deep Frozen Cord
(201039, 56021, 100000, 197, 425, 0), -- Frostmoon Pants
(201039, 56022, 100000, 197, 420, 0), -- Light Blessed Mittens
(201039, 56023, 100000, 197, 420, 0), -- Aurora Slippers
(201039, 56024, 200000, 197, 440, 0), -- Moonshroud Robe
(201039, 56025, 200000, 197, 435, 0), -- Moonshroud Gloves
(201039, 56026, 200000, 197, 440, 0), -- Ebonweave Robe
(201039, 56027, 200000, 197, 435, 0), -- Ebonweave Gloves
(201039, 56028, 200000, 197, 440, 0), -- Spellweave Robe
(201039, 56029, 200000, 197, 435, 0), -- Spellweave Gloves
(201039, 56030, 50000, 197, 380, 0), -- Frostwoven Leggings
(201039, 56031, 50000, 197, 350, 0), -- Frostwoven Wristwraps
(201039, 56034, 100000, 197, 405, 0), -- Master's Spellthread
(201039, 56039, 100000, 197, 405, 0), -- Sanctified Spellthread
(201039, 59582, 100000, 197, 415, 0), -- Frostsavage Belt
(201039, 59583, 100000, 197, 415, 0), -- Frostsavage Bracers
(201039, 59584, 100000, 197, 420, 0), -- Frostsavage Shoulders
(201039, 59585, 100000, 197, 420, 0), -- Frostsavage Boots
(201039, 59586, 100000, 197, 420, 0), -- Frostsavage Gloves
(201039, 59587, 100000, 197, 420, 0), -- Frostsavage Robe
(201039, 59588, 120000, 197, 420, 0), -- Frostsavage Leggings
(201039, 59589, 120000, 197, 420, 0), -- Frostsavage Cowl
(201039, 60969, 105000, 197, 300, 0), -- Flying Carpet
(201039, 60971, 150000, 197, 425, 0), -- Magnificent Flying Carpet
(201039, 60990, 180000, 197, 420, 0), -- Glacial Waistband
(201039, 60993, 180000, 197, 425, 0), -- Glacial Robe
(201039, 60994, 180000, 197, 420, 0), -- Glacial Slippers
(201039, 63742, 750, 197, 125, 0), -- Spidersilk Drape
(201039, 64729, 100000, 197, 400, 0), -- Frostguard Drape
(201039, 64730, 100000, 197, 405, 0), -- Cloak of Crimson Snow
(201039, 74964, 100000, 197, 425, 0), -- Bolt of Embersilk Cloth
(201039, 75141, 150000, 197, 515, 0), -- Dream of Skywall
(201039, 75142, 150000, 197, 505, 0), -- Dream of Deepholm
(201039, 75144, 150000, 197, 500, 0), -- Dream of Hyjal
(201039, 75145, 150000, 197, 510, 0), -- Dream of Ragnaros
(201039, 75146, 150000, 197, 500, 0), -- Dream of Azshara
(201039, 75157, 500000, 197, 425, 80), -- Illustrious Grand Master Tailor
(201039, 75247, 100000, 197, 425, 0), -- Embersilk Net
(201039, 75248, 120000, 197, 445, 0), -- Deathsilk Belt
(201039, 75249, 120000, 197, 445, 0), -- Deathsilk Bracers
(201039, 75250, 120000, 197, 450, 0), -- Enchanted Spellthread
(201039, 75251, 120000, 197, 455, 0), -- Deathsilk Shoulders
(201039, 75252, 120000, 197, 455, 0), -- Deathsilk Boots
(201039, 75253, 120000, 197, 460, 0), -- Deathsilk Gloves
(201039, 75254, 120000, 197, 460, 0), -- Deathsilk Leggings
(201039, 75255, 120000, 197, 460, 0), -- Ghostly Spellthread
(201039, 75256, 120000, 197, 465, 0), -- Deathsilk Cowl
(201039, 75257, 120000, 197, 465, 0), -- Deathsilk Robe
(201039, 75258, 120000, 197, 470, 0), -- Spiritmend Belt
(201039, 75259, 120000, 197, 470, 0), -- Spiritmend Bracers
(201039, 75260, 120000, 197, 475, 0), -- Spiritmend Shoulders
(201039, 75261, 120000, 197, 475, 0), -- Spiritmend Boots
(201039, 75262, 150000, 197, 480, 0), -- Spiritmend Gloves
(201039, 75263, 150000, 197, 480, 0), -- Spiritmend Leggings
(201039, 75264, 150000, 197, 480, 0), -- Embersilk Bag
(201039, 75265, 150000, 197, 480, 0), -- Otherworldly Bag
(201039, 75266, 150000, 197, 485, 0), -- Spiritmend Cowl
(201039, 75267, 150000, 197, 485, 0), -- Spiritmend Robe
(201039, 75268, 150000, 197, 490, 0), -- Hyjal Expedition Bag
(201039, 75269, 180000, 197, 510, 0), -- Vicious Fireweave Belt
(201039, 75270, 150000, 197, 500, 0), -- Vicious Embersilk Bracers
(201039, 75290, 150000, 197, 500, 0), -- Vicious Fireweave Bracers
(201039, 75291, 190000, 197, 505, 0), -- Vicious Embersilk Shoulders
(201039, 75292, 180000, 197, 510, 0), -- Vicious Fireweave Shoulders
(201039, 75293, 180000, 197, 510, 0), -- Vicious Embersilk Belt
(201039, 75294, 180000, 197, 515, 0), -- Vicious Fireweave Boots
(201039, 75295, 180000, 515, 480, 0), -- Vicious Embersilk Gloves
(201039, 75296, 180000, 197, 520, 0), -- Vicious Fireweave Gloves
(201039, 75297, 180000, 197, 520, 0), -- Vicious Embersilk Boots
(201039, 94743, 240000, 197, 525, 0), -- Dream of Destruction
(201039, 99537, 150000, 197, 490, 0), -- Vicious Embersilk Cape
(201039, 110427, 600000, 197, 500, 85), -- Zen Master Tailor
(201039, 125523, 24000, 197, 555, 0), -- Windwool Hood
(201039, 125524, 24000, 197, 535, 0), -- Windwool Shoulders
(201039, 125525, 24000, 197, 555, 0), -- Windwool Tunic
(201039, 125526, 24000, 197, 535, 0), -- Windwool Gloves
(201039, 125527, 24000, 197, 545, 0), -- Windwool Pants
(201039, 125528, 24000, 197, 525, 0), -- Windwool Bracers
(201039, 125529, 24000, 197, 545, 0), -- Windwool Boots
(201039, 125530, 24000, 197, 535, 0), -- Windwool Belt
(201039, 125551, 24000, 197, 500, 0), -- Bolt of Windwool Cloth
(201039, 125552, 24000, 197, 530, 0), -- Pearlescent Spellthread
(201039, 125553, 24000, 197, 550, 0), -- Cerulean Spellthread
(201039, 125557, 240000, 197, 550, 0), -- Imperial Silk
(201039, 130325, 240000, 197, 560, 0), -- Song of Harmony
(201039, 134585, 180000, 197, 515, 0), -- Bipsi's Gloves
(201039, 186091, 2000000, 197, 1, 0), -- Silkweave Shade
(201039, 186094, 2000000, 197, 1, 0), -- Silkweave Flourish
(201039, 186097, 2000000, 197, 1, 0), -- Silkweave Cover
(201039, 186100, 2000000, 197, 1, 0); -- Silkweave Drape
Found one small error the commit at blacksmitting.
At line 278: (201004, 76289, 75000, 164, 500, 0), --Stormforged Breastplate
should be (201004, 76289, 75000, 164, 500, 0), -- Stormforged Breastplate
Very strange i test everything before i post. I hope it helps.
clintskie
on 1 Dec 2016
it was fixed after commit. Windows allows --comment, linux needs to be -- comment
Aokromes
on 1 Dec 2016
I have edited https://github.com/TrinityCore/TrinityCore/issues/14682#issuecomment-262847457 and added the missing <space> just in case anyone would copy that content instead of the actual commit. Wish I had noticed it earlier, but like Aokromes said, it does not error out on Windows builds like it does on Linux.
ghost
on 1 Dec 2016
@clintskie : I have edited your tailoring list by aligning the columns for readability. 2 suggestions for you:
- Keep your column values aligned for easier detection of irregularities when you create your lists.
- If a spell is listed with no cost, check the triggered spell (Effect # 1) to find the actual cost.
- Example: http://www.wowhead.com/spell=110427/zen-master-tailor (no cost)
- see http://www.wowhead.com/spell=110426/tailoring (Tailoring, rank 8) (cost: 60 g)
ghost
on 1 Dec 2016
Hehe Linux is unforgivable:-)
@tkrokli understood , will do that.
clintskie
on 2 Dec 2016
As of commit e0fb444, the fishing profession does not work. Trainer is unresponsive and player character just raises both arms. Manually adding the fishing skill (Spell 7620) yields a BIZARRE value in the fishing skill. See photo.
http://i.imgur.com/YoG9M9d.jpg
Fishing vendor responds well like any other vendor.
Should Archaeology profession bugs be added in another ticket, or continue with this one?
BahDumbBugs
on 4 Dec 2016
@BahDumbBugs :
Give it some time, I'm very busy with engineering now.
Ofc I will look at fishing too.
clintskie
on 7 Dec 2016
fishing issue is totally unrelated to this bug.
Aokromes
on 7 Dec 2016
Why fishing trainers are unrelated?
Fishing trainers from Wowhead: http://pastebin.com/8sza0b2B
Wowhead has wrong info for ReqLevel. http://wowwiki.wikia.com/wiki/Fishing#Proficiencies_and_training
For example in Starter Edition you need level 5 for Apprentice Fishing http://i.imgur.com/3OqLZOn.jpg
Maibenrai
on 8 Dec 2016
@clintskie - No worries. Just mentioning for the record. Thanks for all you are working on. @Aokromes - I think I see what you mean. If this thread is purely only for the primary professions, I'll gladly open a secondary professions ticket. I just figured that if secondary professions are exhibiting the same issues as primary, then the issues should be kept together. Here to work with you......
BahDumbBugs
on 13 Dec 2016
I need some time (busy busy) but i will do al professions also secondary.
First aid is already done as i see it as important.
clintskie
on 16 Dec 2016
To all - the best wishes. Here is engineering.
``sql
DELETE FROMnpc_trainerWHEREIDIN (201012,201015,201016) ORSpellIDIN (-201012,-201015,-201016);
INSERT INTOnpc_trainer(ID,SpellID,MoneyCost,ReqSkillLine,ReqSkillRank,ReqLevel`) VALUES
-- Engineering trainers
(1676, -201012, 0, 0, 0, 0), -- Finbus Geargrind
(1702, -201012, 0, 0, 0, 0), -- Bronk Guzzlegear
(3290, -201012, 0, 0, 0, 0), -- Deek Fizzlebizz
(3494, -201012, 0, 0, 0, 0), -- Tinkerwiz
(4941, -201012, 0, 0, 0, 0), -- Caz Twosprocket
(5174, -201012, 0, 0, 0, 0), -- Springspindle Fizzlegear
(5518, -201012, 0, 0, 0, 0), -- Lilliam Sparkspindle
(8736, -201012, 0, 0, 0, 0), -- Buzzek Bracketswing
(8738, -201012, 0, 0, 0, 0), -- Vazario Linkgrease
(10993, -201012, 0, 0, 0, 0), -- Twizwick Sprocketgrind
(11017, -201012, 0, 0, 0, 0), -- Roxxik
(11025, -201012, 0, 0, 0, 0), -- Mukdrak
(11031, -201012, 0, 0, 0, 0), -- Franklin Lloyd
(11037, -201012, 0, 0, 0, 0), -- Jenna Lemkenilli
(16667, -201012, 0, 0, 0, 0), -- Danwe
(16726, -201012, 0, 0, 0, 0), -- Ockil
(17222, -201012, 0, 0, 0, 0), -- Artificer Daelo
(17634, -201012, 0, 0, 0, 0), -- K. Lee Smallfry
(17637, -201012, 0, 0, 0, 0), -- Mack Diver
(18752, -201012, 0, 0, 0, 0), -- Zebig
(18775, -201012, 0, 0, 0, 0), -- Lebowski
(19576, -201012, 0, 0, 0, 0), -- Xyrol
(24868, -201012, 0, 0, 0, 0), -- Niobe Whizzlespark
(25099, -201012, 0, 0, 0, 0), -- Jonathan Garrett
(25277, -201012, 0, 0, 0, 0), -- Chief Engineer Leveny
(26907, -201012, 0, 0, 0, 0), -- Tisha Longbridge
(26955, -201012, 0, 0, 0, 0), -- Jamesina Watterly
(26991, -201012, 0, 0, 0, 0), -- Sock Brightbolt
(28697, -201012, 0, 0, 0, 0), -- Timofey Oshenko
(33586, -201012, 0, 0, 0, 0), -- Binkie Brightgear
(33611, -201012, 0, 0, 0, 0), -- Engineering
(33634, -201012, 0, 0, 0, 0), -- Engineer Sinbei
(33677, -201012, 0, 0, 0, 0), -- Technician Mihila
(45545, -201012, 0, 0, 0, 0), -- jack-pisarek-slamfix
(52636, -201012, 0, 0, 0, 0), -- Tana Lentner
(52651, -201012, 0, 0, 0, 0), -- Engineer Palehoof
(55143, -201012, 0, 0, 0, 0), -- Sally Fizzlefury
(72407, -201012, 0, 0, 0, 0), -- Roxxik
(85918, -201012, 0, 0, 0, 0), -- Hilda Copperfuze
(86012, -201012, 0, 0, 0, 0), -- Han Leaprocket
(92194, -201012, 0, 0, 0, 0), -- Timofey Oshenko
(95634, -201012, 0, 0, 0, 0), -- Tinkerwiz
(95907, -201012, 0, 0, 0, 0), -- Fixxia Geartweak
(98872, -201012, 0, 0, 0, 0), -- Buzzek Bracketswing
(99098, -201012, 0, 0, 0, 0), -- Timofey Oshenko
(107898, -201012, 0, 0, 0, 0), -- Finbus Geargrind
-- Goblin Engineering trainers
(8126, -201015, 0, 0, 0, 0), -- Nixx Sprocketspring
(8738, -201015, 0, 0, 0, 0), -- Vazario Linkgrease
(29513 , -201015, 0, 0, 0, 0), -- Didi the Wrench
(95634, -201015, 0, 0, 0, 0), -- Nixx Sprocketspring
(102961, -201015, 0, 0, 0, 0), -- Didi the Wrench
-- Gnomish Engineering Trainers
(7406, -201016, 0, 0, 0, 0), -- Oglethorpe Obnoticus
(7944, -201016, 0, 0, 0, 0), -- Tinkmaster Overspark
(29514, -201016, 0, 0, 0, 0), -- Findle Whistlesteam
(93519, -201016, 0, 0, 0, 0), -- Findle Whistlesteam
(99078, -201016, 0, 0, 0, 0), -- Findle Whistlesteam
(113926, -201016, 0, 0, 0, 0), -- Findle Whistlesteam
-- Engineering spells
(201012, 3922, 115, 202, 30, 0), -- Handful of Copper Bolts
(201012, 3923, 130, 202, 30, 0), -- Rough Copper Bomb
(201012, 3924, 150, 202, 50, 0), -- Copper Tube
(201012, 3925, 150, 202, 50, 0), -- Rough Boomstick
(201012, 3929, 250, 202, 75, 0), -- Coarse Blasting Powder
(201012, 3931, 250, 202, 75, 0), -- Coarse Dynamite
(201012, 3932, 300, 202, 85, 0), -- Target Dummy
(201012, 3934, 400, 202, 100, 0), -- Flying Tiger Goggles
(201012, 3936, 420, 202, 105, 0), -- Deadly Blunderbuss
(201012, 3937, 450, 202, 105, 0), -- Large Copper Bomb
(201012, 3938, 450, 202, 105, 0), -- Bronze Tube
(201012, 3939, 500, 202, 120, 19), -- Lovingly Crafted Boomstick
(201012, 3941, 500, 202, 120, 0), -- Small Bronze Bomb
(201012, 3942, 500, 202, 125, 0), -- Whirring Bronze Gizmo
(201012, 3945, 500, 202, 125, 0), -- Heavy Blasting Powder
(201012, 3946, 500, 202, 125, 0), -- Heavy Dynamite
(201012, 3949, 550, 202, 130, 0), -- Silver-plated Shotgun
(201012, 3950, 600, 202, 140, 0), -- Big Bronze Bomb
(201012, 3953, 600, 202, 145, 0), -- Bronze Framework
(201012, 3955, 750, 202, 150, 0), -- Explosive Sheep
(201012, 3956, 450, 202, 150, 0), -- Green Tinted Goggles
(201012, 3958, 800, 202, 160, 0), -- Iron Strut
(201012, 3961, 900, 202, 170, 0), -- Gyrochronatom
(201012, 3962, 1000, 202, 175, 0), -- Iron Grenade
(201012, 3963, 1000, 202, 175, 0), -- Compact Harvest Reaper Kit
(201012, 3965, 1200, 202, 185, 0), -- Advanced Target Dummy
(201012, 3967, 1400, 202, 190, 0), -- Big Iron Bomb
(201012, 3973, 300, 202, 90, 0), -- Silver Contact
(201012, 3977, 200, 202, 60, 0), -- Crude Scope
(201012, 3978, 475, 202, 110, 0), -- Standard Scope
(201012, 3979, 1200, 202, 180, 20), -- Accurate Scope
(201012, 4039, 10, 0, 0, 5), -- Apprentice Engineer
(201012, 4040, 500, 202, 50, 10), -- Journeyman Engineer
(201012, 4041, 5000, 202, 125, 20), -- Expert Engineer
(201012, 6458, 400, 202, 135, 0), -- Ornate Spyglass
(201012, 7430, 150, 202, 50, 0), -- Arclight Spanner
(201012, 8334, 300, 202, 100, 0), -- Clockwork Box
(201012, 9271, 500, 202, 150, 0), -- Aquadynamic Fish Attractor
(201012, 12584, 1000, 202, 150, 0), -- Gold Power Core
(201012, 12585, 1000, 202, 175, 0), -- Solid Blasting Powder
(201012, 12586, 1000, 202, 175, 0), -- Solid Dynamite
(201012, 12589, 1300, 202, 195, 0), -- Mithril Tube
(201012, 12590, 1000, 202, 175, 0), -- Gyromatic Micro-Adjustor
(201012, 12591, 1500, 202, 200, 0), -- Unstable Trigger
(201012, 12594, 1600, 202, 205, 0), -- Fire Goggles
(201012, 12595, 1600, 202, 205, 0), -- Mithril Blunderbuss
(201012, 12599, 1800, 202, 215, 0), -- Mithril Casing
(201012, 12603, 1800, 202, 215, 0), -- Mithril Frag Bomb
(201012, 12615, 2500, 202, 225, 0), -- Spellpower Goggles Xtreme
(201012, 12617, 2200, 202, 230, 0), -- Deepdive Helmet
(201012, 12618, 2200, 202, 230, 0), -- Rose Colored Goggles
(201012, 12619, 2400, 202, 235, 0), -- Hi-Explosive Bomb
(201012, 12622, 2800, 202, 245, 0), -- Green Lens
(201012, 12657, 50000, 202, 200, 35), -- Artisan Engineer
(201012, 12754, 2250, 202, 235, 0), -- The Big One
(201012, 12759, 2800, 202, 240, 0), -- Gnomish Death Ray
(201012, 12895, 1500, 202, 205, 0), -- Inlaid Mithril Cylinder Plans
(201012, 15255, 1500, 202, 200, 0), -- Mechanical Repair Kit
(201012, 19788, 4000, 202, 250, 0), -- Dense Blasting Powder
(201012, 19790, 10000, 202, 260, 0), -- Thorium Grenade
(201012, 19791, 5000, 202, 260, 0), -- Thorium Widget
(201012, 19792, 10000, 202, 260, 0), -- Thorium Rifle
(201012, 19794, 20000, 202, 270, 0), -- Spellpower Goggles Xtreme Plus
(201012, 19795, 10000, 202, 275, 0), -- Thorium Tube
(201012, 19825, 20000, 202, 290, 0), -- Master Engineer's Goggles
(201012, 23070, 5000, 202, 250, 0), -- Dense Dynamite
(201012, 23071, 5000, 202, 260, 0), -- Truesilver Transformer
(201012, 30303, 10000, 202, 300, 0), -- Elemental Blasting Powder
(201012, 30304, 10000, 202, 300, 0), -- Fel Iron Casing
(201012, 30305, 10000, 202, 300, 0), -- Handful of Fel Iron Bolts
(201012, 30306, 20000, 202, 325, 0), -- Adamantite Frame
(201012, 30307, 50000, 202, 340, 0), -- Hardened Adamantite Tube
(201012, 30308, 50000, 202, 340, 0), -- Khorium Power Core
(201012, 30309, 50000, 202, 340, 0), -- Felsteel Stabilizer
(201012, 30310, 15000, 202, 300, 0), -- Fel Iron Bomb
(201012, 30311, 25000, 202, 325, 0), -- Adamantite Grenade
(201012, 30312, 20000, 202, 320, 0), -- Fel Iron Musket
(201012, 30351, 100000, 202, 275, 50), -- Master Engineer
(201012, 30558, 25000, 202, 325, 65), -- The Bigger One
(201012, 30560, 35000, 202, 340, 0), -- Super Sapper Charge
(201012, 30565, 100000, 202, 375, 70), -- Foreman's Enchanted Helmet
(201012, 30570, 50000, 202, 350, 0), -- Nigh-Invulnerability Belt
(201012, 39895, 10000, 202, 275, 0), -- Fused Wiring
(201012, 39971, 20000, 202, 335, 0), -- Icy Blasting Primers
(201012, 40274, 50000, 202, 350, 0), -- Furious Gizmatic Goggles
(201012, 41307, 50000, 202, 375, 0), -- Gyro-balanced Khorium Destroyer
(201012, 41311, 50000, 202, 350, 0), -- Justicebringer 2000 Specs
(201012, 41312, 50000, 202, 350, 0), -- Tankatronic Goggles
(201012, 41314, 50000, 202, 350, 0), -- Surestrike Goggles v2.0
(201012, 41315, 50000, 202, 350, 0), -- Gadgetstorm Goggles
(201012, 41316, 50000, 202, 350, 0), -- Living Replicator Specs
(201012, 41317, 50000, 202, 350, 0), -- Deathblow X11 Goggles
(201012, 41318, 50000, 202, 350, 0), -- Wonderheal XT40 Shades
(201012, 41319, 50000, 202, 350, 0), -- Magnified Moon Specs
(201012, 41320, 50000, 202, 350, 0), -- Destruction Holo-gogs
(201012, 41321, 50000, 202, 350, 0), -- Powerheal 4000 Lens
(201012, 44155, 50000, 202, 300, 60), -- Flying Machine
(201012, 44157, 180000, 202, 375, 60), -- Turbo-Charged Flying Machine
(201012, 51305, 350000, 202, 350, 0), -- Grand Master Engineer
(201012, 53281, 50000, 202, 350, 0), -- Volatile Blasting Trigger
(201012, 54353, 125000, 202, 400, 0), -- Mark "S" Boomstick
(201012, 54736, 100000, 202, 390, 0), -- EMP Generator
(201012, 54793, 100000, 202, 380, 0), -- Frag Belt
(201012, 55002, 100000, 202, 380, 0), -- Flexweave Underlay
(201012, 55016, 125000, 202, 405, 0), -- Nitro Boosts
(201012, 56349, 50000, 202, 350, 0), -- Handful of Cobalt Bolts
(201012, 56459, 100000, 202, 375, 0), -- Hammer Pick
(201012, 56460, 50000, 202, 350, 0), -- Cobalt Frag Bomb
(201012, 56461, 100000, 202, 375, 0), -- Bladed Pickaxe
(201012, 56462, 150000, 202, 435, 0), -- Gnomish Army Knife
(201012, 56463, 100000, 202, 375, 0), -- Explosive Decoy
(201012, 56464, 100000, 202, 375, 0), -- Overcharged Capacitor
(201012, 56465, 125000, 202, 420, 0), -- Mechanized Snow Goggles
(201012, 56466, 125000, 202, 420, 0), -- Sonic Booster
(201012, 56467, 125000, 202, 420, 0), -- Noise Machine
(201012, 56468, 125000, 202, 405, 0), -- Box of Bombs
(201012, 56469, 150000, 202, 425, 0), -- Gnomish Lightning Generator
(201012, 56470, 150000, 202, 425, 0), -- Sun Scope
(201012, 56471, 100000, 202, 390, 0), -- Froststeel Tube
(201012, 56472, 150000, 202, 425, 0), -- MOLL-E
(201012, 56474, 125000, 202, 410, 0), -- Truesight Ice Blinders
(201012, 56476, 125000, 202, 410, 0), -- Healing Injector Kit
(201012, 56477, 125000, 202, 415, 0), -- Mana Injector Kit
(201012, 56478, 200000, 202, 430, 0), -- Heartseeker Scope
(201012, 56479, 200000, 202, 450, 0), -- Armor Plated Combat Shotgun
(201012, 56480, 150000, 202, 440, 0), -- Armored Titanium Goggles
(201012, 56481, 150000, 202, 440, 0), -- Weakness Spectralizers
(201012, 56483, 150000, 202, 440, 0), -- Charged Titanium Specs
(201012, 56484, 150000, 202, 440, 0), -- Visage Liquification Goggles
(201012, 56486, 150000, 202, 440, 0), -- Greensight Gogs
(201012, 56487, 150000, 202, 440, 0), -- Electroflux Sight Enhancers
(201012, 56574, 150000, 202, 440, 0), -- Truesight Ice Blinders
(201012, 60874, 200000, 202, 450, 0), -- Nesingwary 4000
(201012, 61471, 100000, 202, 390, 0), -- Diamond-cut Refractor Scope
(201012, 61481, 125000, 202, 420, 0), -- Mechanized Snow Goggles
(201012, 61482, 125000, 202, 420, 0), -- Mechanized Snow Goggles
(201012, 61483, 125000, 202, 420, 0), -- Mechanized Snow Goggles
(201012, 62271, 150000, 202, 440, 0), -- Unbreakable Healing Amplifiers
(201012, 63750, 5000, 202, 250, 0), -- High-powered Flashlight
(201012, 67326, 100000, 202, 410, 0), -- Goblin Beam Welder
(201012, 67839, 100000, 202, 410, 0), -- Mind Amplification Dish
(201012, 67920, 150000, 202, 435, 0), -- Wormhole Generator: Northrend
(201012, 81714, 240000, 202, 525, 0), -- Reinforced Bio-Optic Killshades
(201012, 81715, 240000, 202, 525, 0), -- Specialized Bio-Optic Killshades
(201012, 81716, 240000, 202, 525, 0), -- Deadly Bio-Optic Killshades
(201012, 81720, 240000, 202, 525, 0), -- Energized Bio-Optic Killshades
(201012, 81722, 240000, 202, 525, 0), -- Agile Bio-Optic Killshades
(201012, 81724, 240000, 202, 525, 0), -- Camouflage Bio-Optic Killshades
(201012, 81725, 240000, 202, 525, 0), -- Lightweight Bio-Optic Killshades
(201012, 82775, 500000, 202, 425, 0), -- Illustrious Grand Master Engineer
(201012, 84403, 150000, 202, 425, 0), -- Handful of Obsidium Bolts
(201012, 84406, 150000, 202, 440, 0), -- Authentic Jr. Engineer Goggles
(201012, 84408, 150000, 202, 450, 80), -- R19 Threatfinder
(201012, 84409, 160000, 202, 455, 0), -- Volatile Seaforium Blastpack
(201012, 84410, 150000, 202, 450, 80), -- Safety Catch Removal Kit
(201012, 84411, 160000, 202, 450, 0), -- High-Powered Bolt Gun
(201012, 84412, 160000, 202, 475, 0), -- Personal World Destroyer
(201012, 84413, 160000, 202, 475, 0), -- De-Weaponized Mechanical Companion
(201012, 84415, 170000, 202, 475, 0), -- Lure Master Tackle Box
(201012, 84416, 170000, 202, 475, 0), -- Elementium Toolbox
(201012, 84417, 170000, 202, 495, 83), -- Volatile Thunderstick
(201012, 84418, 170000, 202, 475, 80), -- Elementium Dragonling
(201012, 84420, 170000, 202, 475, 83), -- Finely-Tuned Throat Needler
(201012, 84421, 170000, 202, 490, 0), -- Loot-a-Rang
(201012, 84429, 200000, 202, 505, 0), -- Goblin Barbecue
(201012, 84430, 200000, 202, 510, 0), -- Heat-Treated Spinning Lure
(201012, 84431, 240000, 202, 525, 85), -- Overpowered Chicken Splitter
(201012, 84432, 240000, 202, 525, 85), -- Kickback 5000
(201012, 94748, 150000, 202, 445, 0), -- Electrified Ether
(201012, 95703, 150000, 202, 440, 0), -- Electrostatic Condenser
(201012, 95705, 200000, 202, 500, 0), -- Gnomish Gravity Well
(201012, 109099, 150000, 202, 550, 0), -- Watergliding Jets
(201012, 110404, 600000, 202, 500, 0), -- Zen Master Engineer
(201012, 126392, 150000, 202, 550, 0), -- Goblin Glider
(201012, 127008, 150000, 202, 600, 0), -- Blingtron 4000
(201012, 127113, 50000, 202, 500, 0), -- Ghost Iron Bolts
(201012, 127114, 50000, 202, 500, 0), -- High-Explosive Gunpowder
(201012, 127115, 50000, 202, 560, 85), -- Lord Blastington's Scope of Doom
(201012, 127116, 50000, 202, 525, 85), -- Mirror Scope
(201012, 127117, 150000, 202, 600, 0), -- Lightweight Retinal Armor
(201012, 127118, 50000, 202, 600, 0), -- Agile Retinal Armor
(201012, 127119, 150000, 202, 600, 0), -- Camouflage Retinal Armor
(201012, 127120, 150000, 202, 600, 0), -- Deadly Retinal Armor
(201012, 127121, 150000, 202, 600, 0), -- Energized Retinal Armor
(201012, 127122, 150000, 202, 600, 0), -- Specialized Retinal Armor
(201012, 127123, 50000, 202, 600, 87), -- Reinforced Retinal Armor
(201012, 127124, 50000, 202, 500, 0), -- Locksmith's Powderkeg
(201012, 127127, 50000, 202, 525, 85), -- G91 Landshark
(201012, 127128, 50000, 202, 550, 85), -- Goblin Dragon Gun, Mark II
(201012, 127129, 50000, 202, 525, 85), -- Blingtron 4000
(201012, 127130, 50000, 202, 525, 0), -- Mist-Piercing Goggles
(201012, 127131, 50000, 202, 550, 0), -- Thermal Anvil
(201012, 127132, 50000, 202, 570, 0), -- Wormhole Generator: Pandaria
(201012, 127134, 50000, 202, 550, 0), -- Ghost Iron Dragonling
(201012, 127135, 50000, 202, 575, 0), -- Mechanical Pandaren Dragonling
(201012, 127136, 150000, 202, 525, 0), -- Big Game Hunter
(201012, 127137, 50000, 202, 450, 90), -- Long-Range Trillium Sniper
(201012, 127138, 160000, 202, 600, 0), -- Depleted-Kyparium Rocket
(201012, 127139, 160000, 202, 600, 0), -- Geosynchronous World Spinner
(201012, 131211, 50000, 202, 550, 0), -- Flashing Tinker's Gear
(201012, 131212, 50000, 202, 550, 0), -- Fractured Tinker's Gear
(201012, 131213, 50000, 202, 550, 0), -- Precise Tinker's Gear
(201012, 131214, 50000, 202, 550, 0), -- Quick Tinker's Gear
(201012, 131215, 50000, 202, 550, 0), -- Rigid Tinker's Gear
(201012, 131216, 50000, 202, 550, 0), -- Smooth Tinker's Gear
(201012, 131217, 50000, 202, 550, 0), -- Sparkling Tinker's Gear
(201012, 131218, 50000, 202, 550, 0), -- Subtle Tinker's Gear
(201012, 131353, 50000, 202, 500, 0), -- Pandaria Fireworks
(201012, 131563, 50000, 202, 550, 0), -- Tinker's Kit
-- Goblin Engineering Spells
(201015, 8895, 2200, 202, 225, 0), -- Goblin Rocket Boots
(201015, 12715, 1500, 202, 205, 0), -- Goblin Rocket Fuel Recipe
(201015, 12716, 1500, 202, 205, 0), -- Goblin Mortar
(201015, 12717, 1500, 202, 205, 0), -- Goblin Mining Helmet
(201015, 12718, 1500, 202, 205, 0), -- Goblin Construction Helmet
(201015, 12754, 2250, 202, 235, 0), -- The Big One
(201015, 12755, 2400, 202, 230, 0), -- Goblin Bomb Dispenser
(201015, 12758, 2600, 202, 245, 0), -- Goblin Rocket Helmet
(201015, 12760, 1500, 202, 205, 0), -- Goblin Sapper Charge
(201015, 12908, 2800, 202, 240, 0), -- Goblin Dragon Gun
(201015, 30558, 25000, 202, 325, 65), -- The Bigger One
(201015, 30563, 50000, 202, 350, 0), -- Goblin Rocket Launcher
(201015, 30565, 100000, 202, 375, 0), -- Foreman's Enchanted Helmet
(201015, 30560, 35000, 202, 340, 0), -- Super Sapper Charge
(201015, 30566, 100000, 202, 375, 0), -- Foreman's Reinforced Helmet
(201015, 56514, 150000, 202, 425, 70), -- Global Thermal Sapper Charge
(201015, 84412, 160000, 202, 475, 0), -- Personal World Destroyer
(201012, 95707, 200000, 202, 500, 0), -- Big Daddy
(201015, 127138, 160000, 202, 600, 0), -- Depleted-Kyparium Rocket
-- Gnomish Engineering Spells
(201016, 12895, 1500, 202, 200, 0), -- Inlaid Mithril Cylinder Plans
(201016, 12897, 1500, 202, 210, 0), -- Gnomish Goggles
(201016, 12899, 1500, 202, 205, 0), -- Gnomish Shrink Ray
(201016, 12902, 1800, 202, 210, 0), -- Gnomish Net-o-Matic Projector
(201016, 12903, 2000, 202, 215, 0), -- Gnomish Harm Prevention Belt
(201016, 12905, 1500, 202, 210, 0), -- Gnomish Rocket Boots
(201016, 12906, 2400, 202, 230, 0), -- Gnomish Battle Chicken
(201016, 12907, 2600, 202, 235, 0), -- Gnomish Mind Control Cap
(201016, 30568, 25000, 202, 325, 0), -- Gnomish Flame Turret
(201016, 30569, 35000, 202, 340, 0), -- Gnomish Poultryizer
(201016, 30570, 50000, 202, 350, 0), -- Nigh-Invulnerability Belt
(201016, 30574, 100000, 202, 375, 0), -- Gnomish Power Goggles
(201016, 30575, 100000, 202, 375, 0), -- Gnomish Battle Goggles
(201016, 56473, 150000, 202, 425, 0), -- Gnomish X-Ray Specs
(201016, 95705, 200000, 202, 500, 0); -- Gnomish Gravity Well
clintskie
on 31 Dec 2016
馃憤 Thanks for the addition, @clintskie. It is now part of the master branch. Happy new year!
ghost
on 10 Jan 2017
Hello,
I am new to this whole emulator thing and I am trying to get a 4.3.4 up and running. I have been able to use your scripts to fix my trainers and I would love to help out if I can. I am not exactly sure what to look for on WoWhead or how to make the SQL scripts like you are but I would be willing to help create them if someone could teach me how. I really appreciate what you are doing here.
Thanks!
I still need Alchemy, Herbalism, Enchanting, Inscription, Jewelcrafting and Leatherworking fixed.
I would be willing to create them and post them here, I just need a little direction.
candrews920
on 14 Jan 2017
@candrews920 : Your question would be better placed in the TrinityCore Forum pages, because these github issue tracker pages are about solving issues and discussing solutions and fixes to valid source code issues.
Feel free to create an account on https://community.trinitycore.org/ and read the TrinityCore wiki guides on http://trinitycore.info/ . If you have got questions you can't seem to find on any of those pages (although most of it can be found be there), you can also visit the IRC channel #trinity @ irc.rizon.net : https://trinitycore.atlassian.net/wiki/display/tc/IRC
Please keep the issue tracker pages free from questions that belong in the forums or the IRC channel.
ghost
on 14 Jan 2017
Here's fishing.
Done the trainers, they work now but the fishing spell itself don't do didley.
That is beyond me so if somebody else can take a look at that ?
DELETE FROM `npc_trainer` WHERE `ID` = 202001 OR `SpellID` = -202001;
INSERT INTO `npc_trainer` (`ID`,`SpellID`,`MoneyCost`,`ReqSkillLine`,`ReqSkillRank`,`ReqLevel`) VALUES
-- Fishing trainers
(1651, -202001, 0, 0, 0, 0), -- Lee Brown
(1680, -202001, 0, 0, 0, 0), -- Matthew Hooper
(1683, -202001, 0, 0, 0, 0), -- Warg Deepwater
(1700, -202001, 0, 0, 0, 0), -- Paxton Ganter
(2367, -202001, 0, 0, 0, 0), -- Donald Rabonne
(2834, -202001, 0, 0, 0, 0), -- Myizz Luckycatch
(3028, -202001, 0, 0, 0, 0), -- Kah Mistrunner
(3179, -202001, 0, 0, 0, 0), -- Harold Riggs
(3332, -202001, 0, 0, 0, 0), -- Lumak
(3607, -202001, 0, 0, 0, 0), -- Androl Oakhand
(4156, -202001, 0, 0, 0, 0), -- Astaia
(4573, -202001, 0, 0, 0, 0), -- Armand Cromwell
(5161, -202001, 0, 0, 0, 0), -- Grimnur Stonebrand
(5493, -202001, 0, 0, 0, 0), -- Arnold Leland
(5690, -202001, 0, 0, 0, 0), -- Clyde Kellen
(5938, -202001, 0, 0, 0, 0), -- Uthan Stillwater
(5941, -202001, 0, 0, 0, 0), -- Lau'Tiki
(7946, -202001, 0, 0, 0, 0), -- Brannock
(12032, -202001, 0, 0, 0, 0), -- Lui'Mala
(12961, -202001, 0, 0, 0, 0), -- Kil'Hiwana
(14740, -202001, 0, 0, 0, 0), -- Katoom the Angler
(16774, -202001, 0, 0, 0, 0), -- Erett
(16780, -202001, 0, 0, 0, 0), -- Drathen
(17101, -202001, 0, 0, 0, 0), -- Diktynna
(18018, -202001, 0, 0, 0, 0), -- Zurjaya
(18911, -202001, 0, 0, 0, 0), -- Juno Dufrain
(23896, -202001, 0, 0, 0, 0), -- "Dirty" Michael Crowe
(26909, -202001, 0, 0, 0, 0), -- Byron Welwick
(26957, -202001, 0, 0, 0, 0), -- Angelina Soren
(26993, -202001, 0, 0, 0, 0), -- Old Man Robert
(28742, -202001, 0, 0, 0, 0), -- Marcia Chase
(32474, -202001, 0, 0, 0, 0), -- Fishy Ser'ji
(33623, -202001, 0, 0, 0, 0), -- Fishing
(44975, -202001, 0, 0, 0, 0), -- Old Umbehto
(50570, -202001, 0, 0, 0, 0), -- Whilsey Bottomtooth
(56068, -202001, 0, 0, 0, 0), -- Steven Stagnaro
(70398, -202001, 0, 0, 0, 0), -- Ben of the Booming Voice
(77733, -202001, 0, 0, 0, 0), -- Ron Ashton
(79892, -202001, 0, 0, 0, 0), -- Mak'jin
(85825, -202001, 0, 0, 0, 0), -- Nuraa
(85926, -202001, 0, 0, 0, 0), -- Austin Windmill
(86628, -202001, 0, 0, 0, 0), -- Brix Rocketcast
(94311, -202001, 0, 0, 0, 0), -- Lester Scaleworth
(95844, -202001, 0, 0, 0, 0), -- Marcia Chase
(96097, -202001, 0, 0, 0, 0), -- Sverre
(108825, -202001, 0, 0, 0, 0), -- Conjurer Margoss
-- Fishing spells
(202001, 7733, 100, 0, 0, 5), -- Apprentice Fishing
(202001, 7734, 500, 356, 50, 10), -- Journeyman Fishing
(202001, 18249, 25000, 356, 200, 10), -- Artisan Fishing
(202001, 54083, 10000, 356, 125, 10), -- Expert Fishing
(202001, 54084, 100000, 356, 275, 10), -- Master Fishing
(202001, 51293, 150000, 356, 350, 10), -- Grand Master Fishing
(202001, 88869, 250000, 356, 425, 10), -- Illustrious Grand Master Fishing
(202001, 110412, 300000, 356, 500, 10); -- Zen Master Fishing
Good point about the fishing (ability) spell, it will be even more relevant after adding this list to the trainers.
ghost
on 19 Jan 2017
Fixed spell http://www.wowhead.com/spell=110412/zen-master-fishing from previous commit.
Also updated the SQL in @clintskie's post above.
ghost
on 19 Jan 2017
Oops, a typo.
Thanks for correcting this.
clintskie
on 20 Jan 2017
here is multi profesion trainers https://github.com/TrinityCore/TrinityCore/commit/21f4ee8a9ae7ec108f87729a17c6fccc2847c040
msoky
on 18 Mar 2017
... and commit https://github.com/TrinityCore/TrinityCore/commit/a66a8e721f9843a05a2ab362f76ad889c24455e1 .
ghost
on 19 Mar 2017
Here are all cooking spells from Wowhead
-- Cooking trainers
DELETE FROM `npc_trainer` WHERE `ID`= 202004 OR `SpellID`= -202004;
INSERT INTO `npc_trainer` (`ID`,`SpellID`,`MoneyCost`,`ReqSkillLine`,`ReqSkillRank`,`ReqLevel`) VALUES
( 1355, -202004, 0, 0, 0, 0), -- Cook Ghilm
( 1382, -202004, 0, 0, 0, 0), -- Mudduk
( 1430, -202004, 0, 0, 0, 0), -- Tomas
( 1699, -202004, 0, 0, 0, 0), -- Gremlock Pilsnor
( 3026, -202004, 0, 0, 0, 0), -- Aska Mistrunner
( 3067, -202004, 0, 0, 0, 0), -- Pyall Silentstride
( 3087, -202004, 0, 0, 0, 0), -- Crystal Boughman
( 3399, -202004, 0, 0, 0, 0), -- Zamja
( 3966, -202004, 0, 0, 0, 0), -- Kaleem
( 4210, -202004, 0, 0, 0, 0), -- Alegorn
( 4552, -202004, 0, 0, 0, 0), -- Eunice Burch
( 4894, -202004, 0, 0, 0, 0), -- Craig Nollward
( 5036, -202004, 0, 0, 0, 0), -- World Cooking Trainer
( 5159, -202004, 0, 0, 0, 0), -- Daryl Riknussun
( 5482, -202004, 0, 0, 0, 0), -- Stephen Ryback
( 6286, -202004, 0, 0, 0, 0), -- Zarrin
( 8306, -202004, 0, 0, 0, 0), -- Duhng
(16277, -202004, 0, 0, 0, 0), -- Quarelestra
(16676, -202004, 0, 0, 0, 0), -- Sylann
(16719, -202004, 0, 0, 0, 0), -- Mumman
(18987, -202004, 0, 0, 0, 0), -- Gaston
(18988, -202004, 0, 0, 0, 0), -- Baxter
(19185, -202004, 0, 0, 0, 0), -- Jack Trapper
(19369, -202004, 0, 0, 0, 0), -- Celie Steelwing
(26905, -202004, 0, 0, 0, 0), -- Brom Brewbaster
(26953, -202004, 0, 0, 0, 0), -- Thomas Kolichio
(26972, -202004, 0, 0, 0, 0), -- Orn Tenderhoof
(26989, -202004, 0, 0, 0, 0), -- Rollick MacKreel
(28705, -202004, 0, 0, 0, 0), -- Katherine Lee
(29631, -202004, 0, 0, 0, 0), -- Awilo Lon'gomba
(33587, -202004, 0, 0, 0, 0), -- Bethany Cromwell
(34708, -202004, 0, 0, 0, 0), -- Caitrin Ironkettle
(34710, -202004, 0, 0, 0, 0), -- Ellen Moore
(34711, -202004, 0, 0, 0, 0), -- Mary Allerton
(34712, -202004, 0, 0, 0, 0), -- Roberta Carter
(34713, -202004, 0, 0, 0, 0), -- Ondani Greatmill
(34714, -202004, 0, 0, 0, 0), -- Mahara Goldwheat
(34785, -202004, 0, 0, 0, 0), -- Alnar Whitebough
(34786, -202004, 0, 0, 0, 0), -- Alice Rigsdale
(45550, -202004, 0, 0, 0, 0), -- Zarbo Porkpatty
(46709, -202004, 0, 0, 0, 0), -- Arugi
(47405, -202004, 0, 0, 0, 0), -- The Chef
(49789, -202004, 0, 0, 0, 0), -- Allison
(50567, -202004, 0, 0, 0, 0), -- Fielding Chesterhill
(85925, -202004, 0, 0, 0, 0), -- Elton Black
(86029, -202004, 0, 0, 0, 0), -- Guy Fireeye
(93534, -202004, 0, 0, 0, 0), -- Katherine Lee
(95981, -202004, 0, 0, 0, 0), -- Duhng
(98527, -202004, 0, 0, 0, 0), -- Pyall Silentstride
(99330, -202004, 0, 0, 0, 0), -- Katherine Lee
(99843, -202004, 0, 0, 0, 0), -- Cook Ghilm
(99991, -202004, 0, 0, 0, 0), -- Gremlock Pilsnor
-- Cooking spells
(202004, 2539, 50, 185, 10, 5), -- Spiced Wolf Meat
(202004, 2541, 100, 185, 50, 5), -- Coyote Steak
(202004, 2544, 200, 185, 75, 5), -- Crab Cake
(202004, 2546, 150, 185, 80, 10), -- Dry Pork Ribs
(202004, 2550, 10, 0, 0, 5), -- Apprentice Cooking
(202004, 3102, 500, 185, 50, 10), -- Journeyman Cooking
(202004, 3399, 450, 185, 150, 10), -- Tasty Lion Steak
(202004, 3400, 500, 185, 175, 20), -- Soothing Turtle Bisque
(202004, 3413, 5000, 185, 125, 20), -- Expert Cooking
(202004, 4094, 500, 185, 175, 20), -- Barbecued Buzzard Wing
(202004, 6412, 50, 185, 10, 5), -- Kaldorei Spider Kabob
(202004, 6415, 100, 185, 50, 5), -- Fillet of Frenzy
(202004, 6499, 100, 185, 50, 5), -- Boiled Clams
(202004, 6500, 300, 185, 125, 10), -- Goblin Deviled Clams
(202004, 18238, 5000, 185, 225, 20), -- Spotted Yellowtail
(202004, 18240, 6000, 185, 240, 35), -- Grilled Squid
(202004, 18243, 6500, 185, 250, 35), -- Nightfin Soup
(202004, 18244, 6500, 185, 250, 35), -- Poached Sunscale Salmon
(202004, 18260, 50000, 185, 200, 35), -- Artisan Cooking
(202004, 21175, 4000, 185, 200, 20), -- Spider Sausage
(202004, 33359, 100000, 185, 275, 50), -- Master Cooking
(202004, 37836, 10, 185, 1, 5), -- Spice Bread
(202004, 42296, 15000, 185, 320, 50), -- Stewed Trout
(202004, 42302, 20000, 185, 350, 50), -- Fisherman's Feast
(202004, 42305, 20000, 185, 350, 50), -- Hot Buttered Trout
(202004, 45549, 20000, 185, 350, 50), -- Mammoth Meal
(202004, 45550, 20000, 185, 350, 50), -- Shoveltusk Steak
(202004, 45551, 20000, 185, 350, 50), -- Worm Delight
(202004, 45552, 20000, 185, 350, 50), -- Roasted Worg
(202004, 45553, 20000, 185, 350, 50), -- Rhino Dogs
(202004, 45554, 50000, 185, 375, 50), -- Great Feast
(202004, 45560, 10000, 185, 350, 50), -- Smoked Rockfin
(202004, 45561, 10000, 185, 350, 50), -- Grilled Bonescale
(202004, 45562, 10000, 185, 350, 50), -- Sauteed Goby
(202004, 45563, 20000, 185, 350, 50), -- Grilled Sculpin
(202004, 45564, 20000, 185, 350, 50), -- Smoked Salmon
(202004, 45565, 20000, 185, 350, 50), -- Poached Nettlefish
(202004, 45566, 20000, 185, 350, 50), -- Pickled Fangtooth
(202004, 45569, 20000, 185, 350, 50), -- Baked Manta Ray
(202004, 46684, 6500, 185, 250, 35), -- Charred Bear Kabobs
(202004, 46688, 6500, 185, 250, 35), -- Juicy Bear Burger
(202004, 51296, 350000, 185, 350, 65), -- Grand Master Cooking
(202004, 58065, 20000, 185, 350, 50), -- Dalaran Clam Chowder
(202004, 64358, 50000, 185, 400, 65), -- Black Jelly
(202004, 88006, 35000, 185, 425, 65), -- Blackened Surprise
(202004, 88015, 30000, 185, 415, 65), -- Darkbrew Lager
(202004, 88053, 500000, 185, 425, 80), -- Illustrious Grand Master Cooking
(202004, 93741, 80, 185, 40, 5), -- Venison Jerky
(202004, 104237, 40000, 185, 270, 35), -- Golden Carp Consomme
(202004, 104297, 40000, 185, 300, 35), -- Fish Cake
(202004, 104298, 38000, 185, 525, 85), -- Charbroiled Tiger Steak
(202004, 104299, 38000, 185, 550, 85), -- Eternal Blossom Fish
(202004, 104300, 38000, 185, 600, 85), -- Black Pepper Ribs and Shrimp
(202004, 104301, 38000, 185, 525, 85), -- Sauteed Carrots
(202004, 104302, 38000, 185, 550, 85), -- Valley Stir Fry
(202004, 104303, 38000, 185, 600, 85), -- Sea Mist Rice Noodles
(202004, 104304, 38000, 185, 525, 85), -- Swirling Mist Soup
(202004, 104305, 38000, 185, 550, 85), -- Braised Turtle
(202004, 104306, 38000, 185, 600, 85), -- Mogu Fish Stew
(202004, 104307, 38000, 185, 525, 85), -- Shrimp Dumplings
(202004, 104308, 38000, 185, 550, 85), -- Fire Spirit Salmon
(202004, 104309, 38000, 185, 600, 85), -- Steamed Crab Surprise
(202004, 104310, 38000, 185, 525, 85), -- Wildfowl Roast
(202004, 104311, 38000, 185, 550, 85), -- Twin Fish Platter
(202004, 104312, 38000, 185, 600, 85), -- Chun Tian Spring Rolls
(202004, 104381, 600000, 185, 500, 85), -- Zen Master Cooking
(202004, 124052, 38000, 185, 525, 85), -- Ginseng Tea
(202004, 124053, 38000, 185, 550, 85), -- Jade Witch Brew
(202004, 124054, 38000, 185, 600, 85), -- Mad Brewer's Breakfast
(202004, 124223, 3600, 185, 550, 85), -- Pounded Rice Cake
(202004, 124224, 4000, 185, 550, 85), -- Yak Cheese Curds
(202004, 124225, 3600, 185, 550, 85), -- Toasted Fish Jerky
(202004, 124226, 4000, 185, 550, 85), -- Dried Peaches
(202004, 124227, 3600, 185, 550, 85), -- Dried Needle Mushrooms
(202004, 124228, 4000, 185, 550, 85), -- Boiled Silkworm Pupa
(202004, 124229, 5000, 185, 360, 50), -- Red Bean Bun
(202004, 124230, 21300, 185, 480, 85), -- Tangy Yogurt
(202004, 124231, 21300, 185, 420, 65), -- Green Curry Fish
(202004, 124232, 21300, 185, 425, 65), -- Peach Pie
(202004, 124233, 5000, 185, 330, 50), -- Blanched Needle Mushrooms
(202004, 124234, 21300, 185, 390, 65), -- Skewered Peanut Chicken
(202004, 125067, 3600, 185, 550, 85), -- Perfectly Cooked Instant Noodles
(202004, 125078, 4000, 185, 240, 35), -- Roasted Barley Tea
(202004, 125080, 32500, 185, 550, 85), -- Pearl Milk Tea
(202004, 125117, 100, 185, 550, 85), -- Sliced Peaches
(202004, 125121, 32500, 185, 550, 85), -- Wildfowl Ginseng Soup
(202004, 125122, 32500, 185, 520, 85), -- Rice Pudding
(202004, 125141, 38000, 185, 575, 85), -- Banquet of the Grill
(202004, 125595, 38000, 185, 575, 85), -- Great Banquet of the Wok
(202004, 125596, 38000, 185, 575, 85), -- Banquet of the Pot
(202004, 125598, 38000, 185, 575, 85), -- Banquet of the Steamer
(202004, 125600, 38000, 185, 575, 85), -- Banquet of the Oven
(202004, 125602, 38000, 185, 575, 85); -- Banquet of the Brew
AussieGlenn
on 28 Mar 2017
Here is Skinning
``sql
-- Skinning trainers
DELETE FROMnpc_trainerWHEREID= 201036 ORSpellID= -201036;
INSERT INTOnpc_trainer(ID,SpellID,MoneyCost,ReqSkillLine,ReqSkillRank,ReqLevel`) VALUES
( 1292, -201036, 0, 0, 0, 0), -- Maris Granger
( 6242, -201036, 0, 0, 0, 0), -- World Skinning Trainer
( 6287, -201036, 0, 0, 0, 0), -- Radnaal Maneweaver
( 6288, -201036, 0, 0, 0, 0), -- Jayla
( 6289, -201036, 0, 0, 0, 0), -- Rand Rhobart
( 6290, -201036, 0, 0, 0, 0), -- Yonn Deepcut
( 6291, -201036, 0, 0, 0, 0), -- Balthus Stoneflayer
( 6292, -201036, 0, 0, 0, 0), -- Eladriel
( 6295, -201036, 0, 0, 0, 0), -- Wilma Ranthal
( 6306, -201036, 0, 0, 0, 0), -- Helene Peltskinner
( 6387, -201036, 0, 0, 0, 0), -- Dranh
( 7087, -201036, 0, 0, 0, 0), -- Killian Hagey
( 7088, -201036, 0, 0, 0, 0), -- Thuwd
( 7089, -201036, 0, 0, 0, 0), -- Mooranta
( 8144, -201036, 0, 0, 0, 0), -- Kulleg Stonehorn
( 8777, -201036, 0, 0, 0, 0), -- Seinrick Coulthane
( 12030, -201036, 0, 0, 0, 0), -- Malux
( 16273, -201036, 0, 0, 0, 0), -- Mathreyn
( 16692, -201036, 0, 0, 0, 0), -- Tyn
( 16763, -201036, 0, 0, 0, 0), -- Remere
( 17441, -201036, 0, 0, 0, 0), -- Gurf
( 18755, -201036, 0, 0, 0, 0), -- Moorutu
( 18777, -201036, 0, 0, 0, 0), -- Jelena Nightsky
( 19180, -201036, 0, 0, 0, 0), -- Seymour
( 26913, -201036, 0, 0, 0, 0), -- Frederic Burrhus
( 26963, -201036, 0, 0, 0, 0), -- Roberta Jacks
( 26986, -201036, 0, 0, 0, 0), -- Tiponi Stormwhisper
( 27000, -201036, 0, 0, 0, 0), -- Trapper Jack
( 28696, -201036, 0, 0, 0, 0), -- Derik Marks
( 33641, -201036, 0, 0, 0, 0), -- Irduil
( 33683, -201036, 0, 0, 0, 0), -- Dremm
( 44782, -201036, 0, 0, 0, 0), -- Rento
( 53437, -201036, 0, 0, 0, 0), -- Humbert Tanwell
( 65144, -201036, 0, 0, 0, 0), -- Tapin Wildbeard
( 66981, -201036, 0, 0, 0, 0), -- Trapper Ri
( 67026, -201036, 0, 0, 0, 0), -- Hao of the Stag's Horns
( 85923, -201036, 0, 0, 0, 0), -- Rangari Laandon
( 86028, -201036, 0, 0, 0, 0), -- Kondal Huntsworn
( 93541, -201036, 0, 0, 0, 0), -- Kondal Huntsworn
( 98720, -201036, 0, 0, 0, 0), -- Ske'rit
( 98721, -201036, 0, 0, 0, 0), -- Seymour
( 98722, -201036, 0, 0, 0, 0), -- Agnes
( 98791, -201036, 0, 0, 0, 0), -- Glielle
( 98936, -201036, 0, 0, 0, 0), -- Derik Marks
-- Skinning spells
(201036, 8613, 10, 0, 0, 5), -- Apprentice Skinning
(201036, 8617, 500, 393, 50, 10), -- Journeyman Skinning
(201036, 8618, 5000, 393, 125, 20), -- Expert Skinning
(201036, 10768, 50000, 393, 200, 35), -- Artisan Skinning
(201036, 32678, 100000, 393, 275, 50), -- Master Skinning
(201036, 50305, 350000, 393, 350, 65), -- Grand Master Skinning
(201036, 74522, 500000, 393, 425, 80), -- Illustrious Grand Master Skinning
(201036, 102216, 600000, 393, 500, 85); -- Zen Master Skinning
AussieGlenn
on 28 Mar 2017
Here is Herbalism
-- Herbalism trainers
DELETE FROM `npc_trainer` WHERE `ID`= 201018 OR `SpellID`= -201018;
INSERT INTO `npc_trainer` (`ID`,`SpellID`,`MoneyCost`,`ReqSkillLine`,`ReqSkillRank`,`ReqLevel`) VALUES
( 812, -201018, 0, 0, 0, 0), -- Alma Jainrose
( 908, -201018, 0, 0, 0, 0), -- Flora Silverwind
( 1218, -201018, 0, 0, 0, 0), -- Herbalist Pomeroy
( 1458, -201018, 0, 0, 0, 0), -- Telurinon Moonshadow
( 1473, -201018, 0, 0, 0, 0), -- Kali Healtouch
( 2114, -201018, 0, 0, 0, 0), -- Faruza
( 2390, -201018, 0, 0, 0, 0), -- Aranae Venomblood
( 2856, -201018, 0, 0, 0, 0), -- Angrun
( 3013, -201018, 0, 0, 0, 0), -- Komin Winterhoof
( 3185, -201018, 0, 0, 0, 0), -- Mishiki
( 3404, -201018, 0, 0, 0, 0), -- Jandi
( 3604, -201018, 0, 0, 0, 0), -- Malorne Bladeleaf
( 3965, -201018, 0, 0, 0, 0), -- Cylania Rootstalker
( 4204, -201018, 0, 0, 0, 0), -- Firodren Mooncaller
( 4614, -201018, 0, 0, 0, 0), -- Martha Alliestar
( 4898, -201018, 0, 0, 0, 0), -- Brant Jasperbloom
( 4998, -201018, 0, 0, 0, 0), -- World Herbalism Trainer
( 5137, -201018, 0, 0, 0, 0), -- Shylamiir
( 5566, -201018, 0, 0, 0, 0), -- Tannysa
( 8146, -201018, 0, 0, 0, 0), -- Ruw
( 16527, -201018, 0, 0, 0, 0), -- Outland Herbalism Trainer
( 16644, -201018, 0, 0, 0, 0), -- Botanist Nathera
( 16736, -201018, 0, 0, 0, 0), -- Cemmorhan
( 17434, -201018, 0, 0, 0, 0), -- Morae
( 17983, -201018, 0, 0, 0, 0), -- Heur
( 18748, -201018, 0, 0, 0, 0), -- Ruak Stronghorn
( 18776, -201018, 0, 0, 0, 0), -- Rorelien
( 26910, -201018, 0, 0, 0, 0), -- Fayin Whisperleaf
( 26958, -201018, 0, 0, 0, 0), -- Marjory Kains
( 26974, -201018, 0, 0, 0, 0), -- Tansy Wildmane
( 26994, -201018, 0, 0, 0, 0), -- Kirea Moondancer
( 28704, -201018, 0, 0, 0, 0), -- Dorothy Egan
( 33639, -201018, 0, 0, 0, 0), -- Botanist Alaenra
( 33678, -201018, 0, 0, 0, 0), -- Jijia
( 46741, -201018, 0, 0, 0, 0), -- Muraga
( 65141, -201018, 0, 0, 0, 0), -- Survivalist Tylania
( 65877, -201018, 0, 0, 0, 0), -- Han Flowerbloom
( 66980, -201018, 0, 0, 0, 0), -- Grower Miao
( 67025, -201018, 0, 0, 0, 0), -- Orchard Keeper Li Mei
( 84620, -201018, 0, 0, 0, 0), -- Aranae Venomblood
( 85921, -201018, 0, 0, 0, 0), -- Jie Wildblossom
( 86006, -201018, 0, 0, 0, 0), -- Anthony Allain
( 92459, -201018, 0, 0, 0, 0), -- Dorothy Egan
( 92464, -201018, 0, 0, 0, 0), -- Kuhuine Tenderstride
( 98135, -201018, 0, 0, 0, 0), -- Wildcrafter Osme
( 99167, -201018, 0, 0, 0, 0), -- Dorothy Egan
( 99903, -201018, 0, 0, 0, 0), -- Sprig Hashhoof
(110345, -201018, 0, 0, 0, 0), -- Aranae Venomblood
-- Herbalism spells
(201018, 2366, 100, 0, 0, 5), -- Apprentice Herbalism
(201018, 2368, 500, 182, 50, 10), -- Journeyman Herbalism
(201018, 3570, 25000, 182, 200, 20), -- Artisan Herbalism
(201018, 11993, 10000, 182, 125, 35), -- Expert Herbalism
(201018, 28695, 100000, 182, 275, 50), -- Master Herbalism
(201018, 50300, 150000, 182, 350, 65), -- Grand Master Herbalism
(201018, 74519, 250000, 182, 425, 80), -- Illustrious Grand Master Herbalism
(201018, 110413, 300000, 182, 500, 85); -- Zen Master Herbalism
Leatherworking finally done
-- Leatherworking trainers
DELETE FROM `npc_trainer` WHERE `ID`= 201027 OR `SpellID`= -201027;
INSERT INTO `npc_trainer` (`ID`,`SpellID`,`MoneyCost`,`ReqSkillLine`,`ReqSkillRank`,`ReqLevel`) VALUES
( 1385, -201027, 0, 0, 0, 0), -- Brawn
( 1632, -201027, 0, 0, 0, 0), -- Adele Fielder
( 3007, -201027, 0, 0, 0, 0), -- Una
( 3069, -201027, 0, 0, 0, 0), -- Chaw Stronghide
( 3365, -201027, 0, 0, 0, 0), -- Karolek
( 3549, -201027, 0, 0, 0, 0), -- Shelene Rhobart
( 3605, -201027, 0, 0, 0, 0), -- Nadyia Maneweaver
( 3703, -201027, 0, 0, 0, 0), -- Krulmoo Fullmoon
( 3967, -201027, 0, 0, 0, 0), -- Aayndia Floralwind
( 4212, -201027, 0, 0, 0, 0), -- Telonis
( 4588, -201027, 0, 0, 0, 0), -- Arthur Moore
( 5040, -201027, 0, 0, 0, 0), -- World Leatherworking Trainer
( 5127, -201027, 0, 0, 0, 0), -- Fimble Finespindle
( 5564, -201027, 0, 0, 0, 0), -- Simon Tanner
( 5784, -201027, 0, 0, 0, 0), -- Waldor
( 7866, -201027, 0, 0, 0, 0), -- Peter Galen
( 7867, -201027, 0, 0, 0, 0), -- Thorkaf Dragoneye
( 7868, -201027, 0, 0, 0, 0), -- Sarah Tanner
( 7869, -201027, 0, 0, 0, 0), -- Brumn Winterhoof
( 7870, -201027, 0, 0, 0, 0), -- Caryssia Moonhunter
( 7871, -201027, 0, 0, 0, 0), -- Se'Jib
( 8153, -201027, 0, 0, 0, 0), -- Narv Hidecrafter
(11097, -201027, 0, 0, 0, 0), -- Drakk Stonehand
(11098, -201027, 0, 0, 0, 0), -- Hahrana Ironhide
(16278, -201027, 0, 0, 0, 0), -- Sathein
(16688, -201027, 0, 0, 0, 0), -- Lynalis
(16728, -201027, 0, 0, 0, 0), -- Akham
(17442, -201027, 0, 0, 0, 0), -- Moordo
(18754, -201027, 0, 0, 0, 0), -- Barim Spilthoof
(18771, -201027, 0, 0, 0, 0), -- Brumman
(19187, -201027, 0, 0, 0, 0), -- Darmari
(21087, -201027, 0, 0, 0, 0), -- Grikka
(26911, -201027, 0, 0, 0, 0), -- Bernadette Dexter
(26961, -201027, 0, 0, 0, 0), -- Gunter Hansen
(26996, -201027, 0, 0, 0, 0), -- Awan Iceborn
(26998, -201027, 0, 0, 0, 0), -- Rosemary Bovard
(28400, -201027, 0, 0, 0, 0), -- Northrend Leatherworking Trainer
(28700, -201027, 0, 0, 0, 0), -- Diane Cannings
(29507, -201027, 0, 0, 0, 0), -- Manfred Staller
(29508, -201027, 0, 0, 0, 0), -- Andellion
(29509, -201027, 0, 0, 0, 0), -- Namha Moonwater
(33581, -201027, 0, 0, 0, 0), -- Kul'de
(33635, -201027, 0, 0, 0, 0), -- Daenril
(33681, -201027, 0, 0, 0, 0), -- Korim
(65121, -201027, 0, 0, 0, 0), -- Clean Pelt
(85920, -201027, 0, 0, 0, 0), -- Jistun Sharpfeather
(86032, -201027, 0, 0, 0, 0), -- Burga Stronghide
(93523, -201027, 0, 0, 0, 0), -- Namha Moonwater
(98948, -201027, 0, 0, 0, 0), -- Hrul Sharphoof
(98950, -201027, 0, 0, 0, 0), -- Namha Moonwater
(98958, -201027, 0, 0, 0, 0), -- Andellion
(98964, -201027, 0, 0, 0, 0), -- Celea
(98969, -201027, 0, 0, 0, 0), -- Stalriss Dawnrunner
(99073, -201027, 0, 0, 0, 0), -- Manfred Staller
-- Leatherworking spells
(201027, 2108, 10, 165, 0, 5), -- Apprentice Leatherworking
(201027, 2153, 50, 165, 15, 5), -- Handstitched Leather Pants
(201027, 3753, 75, 165, 25, 5), -- Handstitched Leather Belt
(201027, 3816, 50, 165, 35, 5), -- Cured Light Hide
(201027, 2160, 100, 165, 40, 5), -- Embossed Leather Vest
(201027, 3104, 500, 165, 50, 10), -- Journeyman Leatherworking
(201027, 2161, 100, 165, 55, 5), -- Embossed Leather Boots
(201027, 3756, 150, 165, 55, 5), -- Embossed Leather Gloves
(201027, 226105, 100, 165, 55, 5), -- Light Scale Gloves
(201027, 2162, 100, 165, 60, 5), -- Embossed Leather Cloak
(201027, 9065, 150, 165, 70, 5), -- Light Leather Bracers
(201027, 226106, 150, 165, 70, 5), -- Light Scale Bracers
(201027, 226107, 150, 165, 70, 5), -- Light Scale Belt
(201027, 3759, 200, 165, 75, 5), -- Embossed Leather Pants
(201027, 3763, 300, 165, 80, 10), -- Fine Leather Belt
(201027, 2159, 250, 165, 85, 10), -- Fine Leather Cloak
(201027, 3761, 350, 165, 85, 10), -- Fine Leather Tunic
(201027, 226108, 350, 165, 85, 10), -- Light Scale Jerkin
(201027, 226114, 350, 165, 85, 10), -- Crackling Scale Breastplate
(201027, 226109, 350, 165, 90, 10), -- Light Scale Boots
(201027, 226110, 350, 165, 90, 10), -- Shamanic Treads
(201027, 9068, 400, 165, 95, 10), -- Light Leather Pants
(201027, 226112, 400, 165, 95, 10), -- Chain Hauberk
(201027, 226113, 400, 165, 95, 10), -- Chain Boots
(201027, 2165, 250, 165, 100, 20), -- Medium Armor Kit
(201027, 2167, 350, 165, 100, 20), -- Dark Leather Boots
(201027, 3817, 200, 165, 100, 20), -- Cured Medium Hide
(201027, 20648, 500, 165, 100, 20), -- Medium Leather
(201027, 226115, 350, 165, 100, 20), -- Blue Chain Leggings
(201027, 226111, 350, 165, 105, 20), -- Light Scale Pants
(201027, 226116, 350, 165, 105, 20), -- Chain Bracers
(201027, 2168, 350, 165, 110, 20), -- Dark Leather Cloak
(201027, 226117, 350, 165, 110, 20), -- Chain Leggings
(201027, 7135, 400, 165, 115, 20), -- Dark Leather Pants
(201027, 226118, 400, 165, 115, 20), -- Chain Gauntlets
(201027, 2166, 450, 165, 120, 20), -- Toughened Leather Armor
(201027, 9074, 500, 165, 120, 20), -- Nimble Leather Gloves
(201027, 226119, 500, 165, 120, 20), -- Chain Belt
(201027, 3766, 400, 165, 125, 20), -- Dark Leather Belt
(201027, 3811, 5000, 165, 125, 20), -- Expert Leatherworking
(201027, 9145, 500, 165, 125, 20), -- Fletcher's Gloves
(201027, 226120, 500, 165, 125, 20), -- Spritescale Epaulets
(201027, 3768, 500, 165, 130, 20), -- Hillman's Shoulders
(201027, 226121, 500, 165, 130, 20), -- Chain Pauldrons
(201027, 3770, 500, 165, 135, 20), -- Toughened Leather Gloves
(201027, 226122, 500, 165, 135, 20), -- Element Grips
(201027, 226123, 500, 165, 140, 20), -- Heavy Scale Gauntlets
(201027, 3764, 500, 165, 145, 20), -- Hillman's Leather Gloves
(201027, 3760, 600, 165, 150, 20), -- Hillman's Cloak
(201027, 3780, 750, 165, 150, 20), -- Heavy Armor Kit
(201027, 3818, 500, 165, 150, 20), -- Cured Heavy Hide
(201027, 20649, 1000, 165, 150, 20), -- Heavy Leather
(201027, 226124, 700, 165, 150, 20), -- Heavy Scale Wraps
(201027, 3774, 1000, 165, 160, 25), -- Green Leather Belt
(201027, 7147, 1000, 165, 160, 25), -- Guardian Pants
(201027, 226127, 1100, 165, 160, 25), -- Spritescale Cinch
(201027, 226128, 1100, 165, 165, 25), -- Heavy Scale Shirt
(201027, 226129, 1100, 165, 165, 25), -- Heavy Scale Pauldrons
(201027, 226130, 1100, 165, 165, 25), -- Spritescale Jerkin
(201027, 7151, 1200, 165, 175, 25), -- Barbaric Shoulders
(201027, 9196, 1500, 165, 175, 25), -- Dusky Leather Armor
(201027, 3776, 1200, 165, 180, 25), -- Green Leather Bracers
(201027, 9198, 2000, 165, 180, 25), -- Frost Leather Cloak
(201027, 226131, 1500, 165, 180, 25), -- Spritescale Gloves
(201027, 9201, 2000, 165, 185, 25), -- Dusky Bracers
(201027, 226132, 1500, 165, 185, 25), -- Heavy Scale Belt
(201027, 226133, 1500, 165, 185, 25), -- Spritescale Wraps
(201027, 6661, 2000, 165, 190, 25), -- Barbaric Harness
(201027, 7156, 2400, 165, 190, 25), -- Guardian Gloves
(201027, 226134, 2400, 165, 190, 25), -- Heavy Scale Boots
(201027, 226135, 2400, 165, 190, 25), -- Heavy Scale Hood
(201027, 226136, 2400, 165, 190, 25), -- Spritescale Circlet
(201027, 226137, 2400, 165, 190, 25), -- Spritescale Boots
(201027, 9206, 2500, 165, 195, 25), -- Dusky Belt
(201027, 10482, 2000, 165, 200, 35), -- Cured Thick Hide
(201027, 10487, 2000, 165, 200, 35), -- Thick Armor Kit
(201027, 10662, 50000, 165, 200, 35), -- Artisan Leatherworking
(201027, 20650, 4000, 165, 200, 35), -- Thick Leather
(201027, 10499, 3000, 165, 205, 35), -- Nightscape Tunic
(201027, 10507, 3000, 165, 205, 35), -- Nightscape Headband
(201027, 10511, 3000, 165, 210, 35), -- Turtle Scale Breastplate
(201027, 10518, 3500, 165, 210, 35), -- Turtle Scale Bracers
(201027, 10548, 4000, 165, 230, 35), -- Nightscape Pants
(201027, 10552, 4000, 165, 230, 35), -- Turtle Scale Helm
(201027, 10630, 10000, 165, 230, 35), -- Gauntlets of the Sea
(201027, 10556, 4500, 165, 235, 35), -- Turtle Scale Leggings
(201027, 10558, 4500, 165, 235, 35), -- Nightscape Boots
(201027, 10632, 10000, 165, 250, 35), -- Helm of Fire
(201027, 10647, 10000, 165, 250, 35), -- Feathered Breastplate
(201027, 10650, 10000, 165, 250, 35), -- Dragonscale Breastplate
(201027, 19047, 5000, 165, 250, 35), -- Cured Rugged Hide
(201027, 19058, 5000, 165, 250, 35), -- Rugged Armor Kit
(201027, 22331, 5000, 165, 250, 35), -- Rugged Leather
(201027, 36074, 10000, 165, 260, 35), -- Blackstorm Leggings
(201027, 36075, 10000, 165, 260, 35), -- Wildfeather Leggings
(201027, 36076, 10000, 165, 260, 35), -- Dragonstrike Leggings
(201027, 19052, 10000, 165, 265, 35), -- Wicked Leather Bracers
(201027, 19055, 100000, 165, 275, 50), -- Master Leatherworking
(201027, 32549, 10000, 165, 275, 50), -- Runic Leather Bracers
(201027, 19071, 10000, 165, 280, 50), -- Wicked Leather Headband
(201027, 19072, 10000, 165, 280, 50), -- Runic Leather Belt
(201027, 24655, 30000, 165, 280, 50), -- Green Dragonscale Gauntlets
(201027, 19082, 15000, 165, 290, 50), -- Runic Leather Headband
(201027, 19083, 15000, 165, 290, 50), -- Wicked Leather Pants
(201027, 19091, 15000, 165, 300, 50), -- Runic Leather Pants
(201027, 19092, 15000, 165, 300, 50), -- Wicked Leather Belt
(201027, 19098, 15000, 165, 300, 50), -- Wicked Leather Armor
(201027, 19102, 15000, 165, 300, 50), -- Runic Leather Armor
(201027, 19103, 15000, 165, 300, 50), -- Runic Leather Shoulders
(201027, 24654, 50000, 165, 300, 50), -- Blue Dragonscale Leggings
(201027, 32454, 10000, 165, 300, 50), -- Knothide Leather
(201027, 32456, 15000, 165, 300, 50), -- Knothide Armor Kit
(201027, 32462, 15000, 165, 300, 50), -- Felscale Gloves
(201027, 32466, 15000, 165, 300, 50), -- Scaled Draenic Pants
(201027, 32470, 15000, 165, 300, 50), -- Thick Draenic Gloves
(201027, 32478, 15000, 165, 300, 50), -- Wild Draenish Boots
(201027, 45100, 15000, 165, 300, 50), -- Leatherworker's Satchel
(201027, 163225, 10000, 165, 300, 50), -- Thick Clefthoof Leather
(201027, 163226, 10000, 165, 300, 50), -- Crystal Infused Leather
(201027, 163228, 10000, 165, 300, 50), -- Fel Scales
(201027, 163229, 10000, 165, 300, 50), -- Fel Hide
(201027, 163230, 10000, 165, 300, 50), -- Nether Dragonscales
(201027, 163231, 10000, 165, 300, 50), -- Cobra Scales
(201027, 163232, 10000, 165, 300, 50), -- Wind Scales
(201027, 32463, 18000, 165, 310, 50), -- Felscale Boots
(201027, 32467, 18000, 165, 310, 50), -- Scaled Draenic Gloves
(201027, 32479, 18000, 165, 310, 50), -- Wild Draenish Gloves
(201027, 32471, 18000, 165, 315, 50), -- Thick Draenic Pants
(201027, 32464, 20000, 165, 320, 50), -- Felscale Pants
(201027, 32472, 20000, 165, 320, 50), -- Thick Draenic Boots
(201027, 32480, 20000, 165, 320, 50), -- Wild Draenish Leggings
(201027, 32455, 20000, 165, 325, 50), -- Heavy Knothide Leather
(201027, 32468, 20000, 165, 325, 50), -- Scaled Draenic Vest
(201027, 32473, 25000, 165, 330, 50), -- Thick Draenic Vest
(201027, 32481, 25000, 165, 330, 50), -- Wild Draenish Vest
(201027, 36077, 40000, 165, 330, 50), -- Primalstorm Breastplate
(201027, 36078, 40000, 165, 330, 50), -- Living Crystal Breastplate
(201027, 36079, 40000, 165, 330, 50), -- Golden Dragonstrike Breastplate
(201027, 32465, 25000, 165, 335, 50), -- Felscale Breastplate
(201027, 32469, 25000, 165, 335, 50), -- Scaled Draenic Boots
(201027, 35540, 20000, 165, 340, 50), -- Drums of War
(201027, 44770, 50000, 165, 350, 65), -- Glove Reinforcements
(201027, 44970, 50000, 165, 350, 65), -- Heavy Knothide Armor Kit
(201027, 50962, 50000, 165, 350, 65), -- Borean Armor Kit
(201027, 51302, 350000, 165, 350, 65), -- Grand Master Leatherworking
(201027, 64661, 50000, 165, 350, 65), -- Borean Leather
(201027, 163222, 50000, 165, 350, 65), -- Icy Dragonscale
(201027, 163223, 50000, 165, 350, 65), -- Nerubian Chitin
(201027, 163224, 50000, 165, 350, 65), -- Jormungar Scale
(201027, 50939, 30000, 165, 370, 65), -- Iceborne Leggings
(201027, 50941, 30000, 165, 370, 65), -- Iceborne Gloves
(201027, 50944, 30000, 165, 370, 65), -- Arctic Chestpiece
(201027, 50948, 30000, 165, 370, 65), -- Arctic Boots
(201027, 50951, 30000, 165, 370, 65), -- Frostscale Leggings
(201027, 50955, 30000, 165, 370, 65), -- Frostscale Belt
(201027, 50957, 30000, 165, 370, 65), -- Nerubian Legguards
(201027, 50959, 30000, 165, 370, 65), -- Nerubian Gloves
(201027, 50938, 30000, 165, 375, 65), -- Iceborne Chestguard
(201027, 50942, 30000, 165, 375, 65), -- Iceborne Boots
(201027, 50945, 30000, 165, 375, 65), -- Arctic Leggings
(201027, 50947, 30000, 165, 375, 65), -- Arctic Gloves
(201027, 50950, 30000, 165, 375, 65), -- Frostscale Chestguard
(201027, 50952, 30000, 165, 375, 65), -- Frostscale Shoulders
(201027, 50956, 30000, 165, 375, 65), -- Nerubian Chestguard
(201027, 50961, 30000, 165, 375, 65), -- Nerubian Belt
(201027, 50940, 30000, 165, 380, 65), -- Iceborne Shoulderpads
(201027, 50943, 30000, 165, 380, 65), -- Iceborne Belt
(201027, 50946, 30000, 165, 380, 65), -- Arctic Shoulderpads
(201027, 50949, 30000, 165, 380, 65), -- Arctic Belt
(201027, 50953, 30000, 165, 380, 65), -- Frostscale Gloves
(201027, 50954, 30000, 165, 380, 65), -- Frostscale Boots
(201027, 50958, 30000, 165, 380, 65), -- Nerubian Shoulders
(201027, 50960, 30000, 165, 380, 65), -- Nerubian Boots
(201027, 60631, 80000, 165, 380, 65), -- Cloak of Harsh Winds
(201027, 51571, 30000, 165, 385, 65), -- Arctic Wristguards
(201027, 51572, 30000, 165, 385, 65), -- Arctic Helm
(201027, 60599, 30000, 165, 385, 65), -- Frostscale Bracers
(201027, 60600, 30000, 165, 385, 65), -- Frostscale Helm
(201027, 60607, 30000, 165, 385, 65), -- Iceborne Wristguards
(201027, 60608, 30000, 165, 385, 65), -- Iceborne Helm
(201027, 60622, 30000, 165, 385, 65), -- Nerubian Bracers
(201027, 60624, 30000, 165, 385, 65), -- Nerubian Helm
(201027, 50936, 80000, 165, 390, 65), -- Heavy Borean Leather
(201027, 50963, 80000, 165, 395, 65), -- Heavy Borean Armor Kit
(201027, 51569, 80000, 165, 395, 65), -- Dark Arctic Leggings
(201027, 51570, 80000, 165, 395, 65), -- Dark Arctic Chestpiece
(201027, 55199, 80000, 165, 395, 65), -- Cloak of Tormented Skies
(201027, 60601, 80000, 165, 395, 65), -- Dark Frostscale Leggings
(201027, 60604, 80000, 165, 395, 65), -- Dark Frostscale Breastplate
(201027, 60611, 80000, 165, 395, 65), -- Dark Iceborne Leggings
(201027, 60613, 80000, 165, 395, 65), -- Dark Iceborne Chestguard
(201027, 60627, 80000, 165, 395, 65), -- Dark Nerubian Leggings
(201027, 60629, 80000, 165, 395, 65), -- Dark Nerubian Chestpiece
(201027, 50966, 50000, 165, 400, 65), -- Nerubian Leg Armor
(201027, 51568, 100000, 165, 400, 65), -- Black Chitinguard Boots
(201027, 60605, 100000, 165, 400, 65), -- Dragonstompers
(201027, 60620, 100000, 165, 400, 65), -- Bugsquashers
(201027, 60630, 80000, 165, 400, 65), -- Scaled Icewalkers
(201027, 50964, 50000, 165, 405, 65), -- Jormungar Leg Armor
(201027, 60643, 50000, 165, 415, 65), -- Pack of Endless Pockets
(201027, 60651, 100000, 165, 420, 65), -- Virulent Spaulders
(201027, 60652, 100000, 165, 420, 65), -- Eaglebane Bracers
(201027, 60658, 200000, 165, 420, 65), -- Nightshock Girdle
(201027, 60665, 100000, 165, 420, 65), -- Seafoam Gauntlets
(201027, 60666, 80000, 165, 420, 65), -- Jormscale Footpads
(201027, 60671, 100000, 165, 420, 65), -- Purehorn Spaulders
(201027, 50965, 80000, 165, 425, 80), -- Frosthide Leg Armor
(201027, 50967, 80000, 165, 425, 80), -- Icescale Leg Armor
(201027, 60649, 100000, 165, 425, 80), -- Razorstrike Breastplate
(201027, 60655, 200000, 165, 425, 80), -- Nightshock Hood
(201027, 60660, 100000, 165, 425, 80), -- Leggings of Visceral Strikes
(201027, 60669, 100000, 165, 425, 80), -- Wildscale Breastplate
(201027, 62448, 80000, 165, 425, 80), -- Earthen Leg Armor
(201027, 78379, 75000, 165, 425, 80), -- Savage Armor Kit
(201027, 81199, 500000, 165, 425, 80), -- Illustrious Grand Master Leatherworking
(201027, 84950, 75000, 165, 425, 80), -- Savage Leather
(201027, 163216, 75000, 165, 425, 80), -- Blackened Dragonscale
(201027, 163218, 75000, 165, 425, 80), -- Deepsea Scale
(201027, 60637, 200000, 165, 440, 80), -- Ice Striker's Cloak
(201027, 60640, 200000, 165, 440, 80), -- Durable Nerubhide Cape
(201027, 69386, 200000, 165, 450, 80), -- Drums of Forgotten Kings
(201027, 69388, 200000, 165, 450, 80), -- Drums of the Wild
(201027, 78398, 75000, 165, 450, 80), -- Darkbrand Bracers
(201027, 78410, 75000, 165, 450, 80), -- Tsunami Boots
(201027, 78415, 75000, 165, 455, 80), -- Tsunami Shoulders
(201027, 78416, 75000, 165, 455, 80), -- Darkbrand Belt
(201027, 78380, 75000, 165, 460, 80), -- Savage Cloak
(201027, 78388, 75000, 165, 460, 80), -- Tsunami Bracers
(201027, 78399, 75000, 165, 465, 80), -- Darkbrand Gloves
(201027, 78407, 75000, 165, 465, 80), -- Darkbrand Boots
(201027, 78396, 75000, 165, 470, 80), -- Tsunami Belt
(201027, 78405, 75000, 165, 470, 80), -- Hardened Scale Cloak
(201027, 78406, 85000, 165, 475, 80), -- Tsunami Gloves
(201027, 78411, 85000, 165, 475, 80), -- Darkbrand Shoulders
(201027, 78419, 85000, 165, 475, 80), -- Scorched Leg Armor
(201027, 78420, 85000, 165, 480, 80), -- Twilight Leg Armor
(201027, 78427, 85000, 165, 480, 80), -- Tsunami Leggings
(201027, 78428, 85000, 165, 480, 80), -- Darkbrand Chestguard
(201027, 78432, 85000, 165, 485, 80), -- Tsunami Helm
(201027, 78433, 85000, 165, 485, 80), -- Darkbrand Leggings
(201027, 78436, 85000, 165, 485, 80), -- Heavy Savage Leather
(201027, 78437, 85000, 165, 485, 80), -- Heavy Savage Armor Kit
(201027, 78423, 85000, 165, 490, 80), -- Tsunami Chestguard
(201027, 78424, 85000, 165, 490, 80), -- Darkbrand Helm
(201027, 78438, 85000, 165, 495, 80), -- Cloak of Beasts
(201027, 78439, 85000, 165, 495, 80), -- Cloak of War
(201027, 99535, 100000, 165, 500, 85), -- Vicious Hide Cloak
(201027, 99536, 100000, 165, 500, 85), -- Vicious Fur Cloak
(201027, 110423, 600000, 165, 500, 85), -- Zen Master Leatherworking
(201027, 124627, 50000, 165, 500, 85), -- Exotic Leather
(201027, 163220, 50000, 165, 500, 85), -- Prismatic Scale
(201027, 124577, 50000, 165, 525, 85), -- Misthide Boots
(201027, 124584, 50000, 165, 525, 85), -- Stormscale Bracers
(201027, 124628, 50000, 165, 525, 85), -- Sha Armor Kit
(201027, 124576, 50000, 165, 530, 85), -- Misthide Bracers
(201027, 124586, 50000, 165, 530, 85), -- Stormscale Belt
(201027, 124126, 50000, 165, 535, 85), -- Brutal Leg Armor
(201027, 124578, 50000, 165, 535, 85), -- Misthide Belt
(201027, 124585, 50000, 165, 535, 85), -- Stormscale Boots
(201027, 124572, 50000, 165, 540, 85), -- Misthide Shoulders
(201027, 124574, 50000, 165, 540, 85), -- Misthide Gloves
(201027, 124582, 50000, 165, 540, 85), -- Stormscale Gloves
(201027, 124124, 50000, 165, 545, 85), -- Sha-Touched Leg Armor
(201027, 124580, 50000, 165, 545, 85), -- Stormscale Shoulders
(201027, 124575, 50000, 165, 550, 85), -- Misthide Leggings
(201027, 124579, 50000, 165, 550, 85), -- Stormscale Helm
(201027, 124636, 50000, 165, 550, 85), -- Stormscale Drape
(201027, 131865, 50000, 165, 550, 85), -- Magnificent Hide
(201027, 124125, 50000, 165, 555, 85), -- Toughened Leg Armor
(201027, 124571, 50000, 165, 555, 85), -- Misthide Helm
(201027, 124581, 50000, 165, 555, 85), -- Stormscale Chestguard
(201027, 124635, 50000, 165, 555, 85), -- Misthide Drape
(201027, 124573, 50000, 165, 560, 85), -- Misthide Chestguard
(201027, 124583, 50000, 165, 560, 85), -- Stormscale Leggings
(201027, 124637, 50000, 165, 560, 85); -- Quick Strike Cloak
@tkrokli could you merge to master cooking, skinning, herbalism, leatherworking above? thx
msoky
on 7 Apr 2017
I would like to, but I also have to test them first. I would also like to see someone else test and confirm that the SQL works as intended on their own computer, to make sure there isn't any hidden errors in the queries.
ghost
on 7 Apr 2017
Hi tkrokli,
I am a MySQL certified developer (and being paid as such) :)
I am confident of my SQL, and have extensively tested the above in a pure TrinityCore self compiled core.
I would ask that you hold off until I finish off Alchemy, Inscription and Archaeology.
That way we can close this ticket.
This should be done by the end of the Easter break.
Thanks,
Glenn
AussieGlenn
on 7 Apr 2017
Here is Alchemy
-- Alchemy trainers
DELETE FROM `npc_trainer` WHERE `ID`= 201001 OR `SpellID`= -201001;
INSERT INTO `npc_trainer` (`ID`,`SpellID`,`MoneyCost`,`ReqSkillLine`,`ReqSkillRank`,`ReqLevel`) VALUES
( 1215, -201001, 0, 0, 0, 0), -- Alchemist Mallory
( 1386, -201001, 0, 0, 0, 0), -- Rogvar
( 1470, -201001, 0, 0, 0, 0), -- Ghak Healtouch
( 2132, -201001, 0, 0, 0, 0), -- Carolai Anise
( 2391, -201001, 0, 0, 0, 0), -- Serge Hinott
( 3009, -201001, 0, 0, 0, 0), -- Jaxin Chong
( 1632, -201001, 0, 0, 0, 0), -- Bena Winterhoof
( 3184, -201001, 0, 0, 0, 0), -- Miao'zan
( 3347, -201001, 0, 0, 0, 0), -- Yelmak
( 3603, -201001, 0, 0, 0, 0), -- Cyndra Kindwhisper
( 3964, -201001, 0, 0, 0, 0), -- Kylanna
( 4160, -201001, 0, 0, 0, 0), -- Ainethil
( 4611, -201001, 0, 0, 0, 0), -- Doctor Herbert Halsey
( 4900, -201001, 0, 0, 0, 0), -- Alchemist Narett
( 5032, -201001, 0, 0, 0, 0), -- World Alchemy Trainer
( 5177, -201001, 0, 0, 0, 0), -- Tally Berryfizz
( 5499, -201001, 0, 0, 0, 0), -- Lilyssia Nightbreeze
( 7948, -201001, 0, 0, 0, 0), -- Kylanna Windwhisper
( 12020, -201001, 0, 0, 0, 0), -- Moonglade Alchemy Trainer
( 16161, -201001, 0, 0, 0, 0), -- Arcanist Sheynathren
( 16487, -201001, 0, 0, 0, 0), -- Master Alchemist
( 16588, -201001, 0, 0, 0, 0), -- Apothecary Antonivich
( 16642, -201001, 0, 0, 0, 0), -- Camberon
( 16723, -201001, 0, 0, 0, 0), -- Lucc
( 17215, -201001, 0, 0, 0, 0), -- Daedal
( 18802, -201001, 0, 0, 0, 0), -- Alchemist Gribble
( 19052, -201001, 0, 0, 0, 0), -- Lorokeem
( 26903, -201001, 0, 0, 0, 0), -- Lanolis Dewdrop
( 26951, -201001, 0, 0, 0, 0), -- Wilhelmina Renel
( 26975, -201001, 0, 0, 0, 0), -- Arthur Henslowe
( 26987, -201001, 0, 0, 0, 0), -- Falorn Nightwhisper
( 27023, -201001, 0, 0, 0, 0), -- Apothecary Bressa
( 27029, -201001, 0, 0, 0, 0), -- Apothecary Wormwick
( 28703, -201001, 0, 0, 0, 0), -- Linzy Blackbolt
( 33588, -201001, 0, 0, 0, 0), -- Crystal Brightspark
( 33630, -201001, 0, 0, 0, 0), -- Aelthin
( 33674, -201001, 0, 0, 0, 0), -- Alchemist Kanhu
( 65186, -201001, 0, 0, 0, 0), -- Poisoncrafter Kil'zit
( 84615, -201001, 0, 0, 0, 0), -- Serge Hinott
( 85905, -201001, 0, 0, 0, 0), -- Jaiden Trask
( 86009, -201001, 0, 0, 0, 0), -- Kristoph Cossey
( 92456, -201001, 0, 0, 0, 0), -- Linzy Blackbolt
( 92458, -201001, 0, 0, 0, 0), -- Deucus Valdera
( 95782, -201001, 0, 0, 0, 0), -- Deucus Valdera
( 97609, -201001, 0, 0, 0, 0), -- Serge Hinott
( 99157, -201001, 0, 0, 0, 0), -- Linzy Blackbolt
( 113372, -201001, 0, 0, 0, 0), -- Deucus Valdera
(201001, 2259, 10, 171, 0, 5), -- Apprentice Alchemy
(201001, 3170, 50, 171, 15, 5), -- Weak Troll's Blood Elixir
(201001, 2331, 100, 171, 20, 5), -- Minor Mana Potion
(201001, 2332, 150, 171, 40, 5), -- Minor Rejuvenation Potion
(201001, 3101, 500, 171, 50, 5), -- Journeyman Alchemy
(201001, 2334, 250, 171, 50, 5), -- Elixir of Minor Fortitude
(201001, 2337, 1000, 171, 55, 5), -- Lesser Healing Potion
(201001, 7836, 250, 171, 80, 10), -- Blackmouth Oil
(201001, 7179, 450, 171, 90, 10), -- Elixir of Water Breathing
(201001, 3171, 500, 171, 90, 10), -- Elixir of Wisdom
(201001, 7841, 1000, 171, 100, 10), -- Swim Speed Potion
(201001, 3173, 1500, 171, 120, 10), -- Healing Potion
(201001, 3447, 4000, 171, 110, 10), -- Lesser Mana Potion
(201001, 3464, 5000, 171, 125, 20), -- Expert Alchemy
(201001, 3176, 1500, 171, 125, 20), -- Strong Troll's Blood Elixir
(201001, 7837, 1000, 171, 130, 20), -- Fire Oil
(201001, 3177, 2000, 171, 130, 20), -- Elixir of Defense
(201001, 63732, 2000, 171, 135, 20), -- Elixir of Minor Accuracy
(201001, 7845, 3000, 171, 140, 20), -- Elixir of Firepower
(201001, 7181, 5000, 171, 155, 20), -- Greater Healing Potion
(201001, 3452, 5000, 171, 160, 20), -- Mana Potion
(201001, 3448, 5000, 171, 165, 20), -- Lesser Invisibility Potion
(201001, 3449, 5000, 171, 165, 20), -- Shadow Oil
(201001, 3450, 6000, 171, 175, 20), -- Elixir of Fortitude
(201001, 11449, 6500, 171, 185, 20), -- Elixir of Agility
(201001, 11450, 7500, 171, 195, 20), -- Elixir of Greater Defense
(201001, 11611, 50000, 171, 200, 35), -- Artisan Alchemy
(201001, 12609, 8000, 171, 200, 35), -- Catseye Elixir
(201001, 11448, 9000, 171, 205, 35), -- Greater Mana Potion
(201001, 11451, 8000, 171, 205, 35), -- Oil of Immolation
(201001, 22808, 10000, 171, 215, 35), -- Elixir of Greater Water Breathing
(201001, 11457, 10000, 171, 215, 35), -- Superior Healing Potion
(201001, 15833, 10000, 171, 230, 35), -- Dreamless Sleep Potion
(201001, 11460, 5000, 171, 230, 35), -- Elixir of Detect Undead
(201001, 11461, 10000, 171, 235, 35), -- Arcane Elixir
(201001, 11465, 12000, 171, 235, 35), -- Elixir of Greater Intellect
(201001, 11467, 12000, 171, 240, 35), -- Elixir of Greater Agility
(201001, 17551, 15000, 171, 250, 35), -- Stonescale Oil
(201001, 11478, 14000, 171, 250, 35), -- Elixir of Detect Demon
(201001, 17552, 15000, 171, 255, 35), -- Mighty Rage Potion
(201001, 17553, 15000, 171, 260, 35), -- Superior Mana Potion
(201001, 17555, 15000, 171, 270, 35), -- Elixir of the Sages
(201001, 28596, 100000, 171, 275, 50), -- Master Alchemy
(201001, 17557, 20000, 171, 275, 50), -- Elixir of Brute Force
(201001, 17556, 20000, 171, 275, 50), -- Major Healing Potion
(201001, 17573, 20000, 171, 285, 50), -- Greater Arcane Elixir
(201001, 17572, 20000, 171, 285, 50), -- Purification Potion
(201001, 114786, 20000, 171, 300, 50), -- Alchemist's Flask
(201001, 33740, 20000, 171, 300, 50), -- Adept's Elixir
(201001, 33738, 20000, 171, 300, 50), -- Onslaught Elixir
(201001, 33732, 20000, 171, 300, 50), -- Volatile Healing Potion
(201001, 28544, 25000, 171, 305, 50), -- Elixir of Major Strength
(201001, 28545, 25000, 171, 310, 50), -- Elixir of Healing Power
(201001, 39636, 25000, 171, 310, 50), -- Elixir of Major Fortitude
(201001, 33733, 25000, 171, 310, 50), -- Unstable Mana Potion
(201001, 33741, 30000, 171, 315, 50), -- Elixir of Mastery
(201001, 39638, 30000, 171, 320, 50), -- Elixir of Draenic Wisdom
(201001, 45061, 35000, 171, 325, 50), -- Mad Alchemist's Potion
(201001, 38070, 20000, 171, 325, 50), -- Mercurial Stone
(201001, 28551, 50000, 171, 325, 50), -- Super Healing Potion
(201001, 51304, 350000, 171, 350, 65), -- Grand Master Alchemy
(201001, 53838, 40000, 171, 350, 65), -- Resurgent Healing Potion
(201001, 53841, 40000, 171, 355, 65), -- Wrath Elixir
(201001, 53839, 40000, 171, 360, 65), -- Icy Mana Potion
(201001, 53842, 40000, 171, 365, 65), -- Spellpower Elixir
(201001, 62409, 60000, 171, 375, 65), -- Ethereal Oil
(201001, 53848, 60000, 171, 375, 65), -- Guru's Elixir
(201001, 53899, 60000, 171, 375, 65), -- Lesser Flask of Toughness
(201001, 53812, 60000, 171, 375, 65), -- Pygmy Oil
(201001, 53900, 120000, 171, 380, 65), -- Potion of Nightmares
(201001, 54218, 120000, 171, 385, 65), -- Elixir of Mighty Strength
(201001, 53847, 65000, 171, 385, 65), -- Elixir of Spirit
(201001, 53898, 120000, 171, 390, 65), -- Elixir of Mighty Fortitude
(201001, 53840, 120000, 171, 395, 65), -- Elixir of Mighty Agility
(201001, 60367, 120000, 171, 395, 65), -- Elixir of Mighty Thoughts
(201001, 53905, 120000, 171, 395, 65), -- Indestructible Potion
(201001, 60350, 150000, 171, 395, 65), -- Transmute: Titanium
(201001, 60893, 200000, 171, 400, 65), -- Northrend Alchemy Research
(201001, 60403, 200000, 171, 400, 65), -- Indestructible Alchemist Stone
(201001, 60396, 200000, 171, 400, 65), -- Mercurial Alchemist Stone
(201001, 60405, 200000, 171, 400, 65), -- Mighty Alchemist Stone
(201001, 53836, 150000, 171, 405, 65), -- Runic Healing Potion
(201001, 58871, 150000, 171, 410, 65), -- Endless Healing Potion
(201001, 58868, 150000, 171, 410, 65), -- Endless Mana Potion
(201001, 53837, 150000, 171, 410, 65), -- Runic Mana Potion
(201001, 80731, 500000, 171, 425, 80), -- Illustrious Grand Master Alchemy
(201001, 57427, 150000, 171, 425, 80), -- Transmute: Earthsiege Diamond
(201001, 93935, 150000, 171, 425, 80), -- Draught of War
(201001, 57425, 150000, 171, 430, 80), -- Transmute: Skyflare Diamond
(201001, 53903, 180000, 171, 435, 80), -- Flask of Endless Rage
(201001, 54213, 150000, 171, 435, 80), -- Flask of Pure Mojo
(201001, 53902, 150000, 171, 435, 80), -- Flask of Stoneblood
(201001, 53901, 180000, 171, 435, 80), -- Flask of the Frost Wyrm
(201001, 66658, 200000, 171, 450, 80), -- Transmute: Ametrine
(201001, 66662, 200000, 171, 450, 80), -- Transmute: Dreadstone
(201001, 66664, 200000, 171, 450, 80), -- Transmute: Eye of Zul
(201001, 66660, 200000, 171, 450, 80), -- Transmute: King's Amber
(201001, 66663, 200000, 171, 450, 80), -- Transmute: Majestic Zircon
(201001, 80478, 150000, 171, 450, 80), -- Earthen Potion
(201001, 80477, 150000, 171, 450, 80), -- Ghost Elixir
(201001, 80479, 150000, 171, 455, 80), -- Deathblood Venom
(201001, 80480, 150000, 171, 455, 80), -- Elixir of the Naga
(201001, 80481, 160000, 171, 460, 80), -- Volcanic Potion
(201001, 80269, 160000, 171, 460, 80), -- Potion of Illusion
(201001, 80484, 160000, 171, 465, 80), -- Elixir of the Cobra
(201001, 80482, 160000, 171, 465, 80), -- Potion of Concentration
(201001, 80486, 160000, 171, 470, 80), -- Deepstone Oil
(201001, 80487, 160000, 171, 470, 80), -- Mysterious Potion
(201001, 80488, 160000, 171, 475, 80), -- Elixir of Deep Earth
(201001, 80490, 160000, 171, 475, 80), -- Mighty Rejuvenation Potion
(201001, 80491, 175000, 171, 480, 80), -- Elixir of Impossible Accuracy
(201001, 80492, 175000, 171, 480, 80), -- Prismatic Elixir
(201001, 80494, 175000, 171, 485, 80), -- Mythical Mana Potion
(201001, 80495, 175000, 171, 485, 80), -- Potion of the Tol'vir
(201001, 78866, 175000, 171, 485, 80), -- Transmute: Living Elements
(201001, 80493, 175000, 171, 490, 80), -- Elixir of Mighty Speed
(201001, 80496, 175000, 171, 490, 80), -- Golemblood Potion
(201001, 80497, 175000, 171, 495, 80), -- Elixir of the Master
(201001, 80498, 175000, 171, 495, 80), -- Mythical Healing Potion
(201001, 105206, 600000, 171, 500, 85), -- Zen Master Alchemy
(201001, 94162, 200000, 171, 500, 85), -- Flask of Flowing Water
(201001, 80719, 200000, 171, 500, 85), -- Flask of Steelskin
(201001, 80508, 100000, 171, 500, 85), -- Lifebound Alchemist Stone
(201001, 96253, 100000, 171, 500, 85), -- Quicksilver Alchemist Stone
(201001, 96254, 100000, 171, 500, 85), -- Vibrant Alchemist Stone
(201001, 96252, 100000, 171, 500, 85), -- Volatile Alchemist Stone
(201001, 136197, 100000, 171, 500, 85), -- Zen Alchemist Stone
(201001, 114751, 200000, 171, 500, 85), -- Alchemist's Rejuvenation
(201001, 114752, 200000, 171, 500, 85), -- Master Healing Potion
(201001, 80251, 200000, 171, 505, 85), -- Transmute: Dream Emerald
(201001, 80720, 200000, 171, 505, 85), -- Flask of the Draconic Mind
(201001, 80250, 200000, 171, 510, 85), -- Transmute: Ember Topaz
(201001, 80721, 200000, 171, 510, 85), -- Flask of the Winds
(201001, 80723, 200000, 171, 510, 85), -- Flask of Titanic Strength
(201001, 80248, 200000, 171, 515, 85), -- Transmute: Demonseye
(201001, 80246, 200000, 171, 515, 85), -- Transmute: Ocean Sapphire
(201001, 80247, 200000, 171, 520, 85), -- Transmute: Amberjewel
(201001, 80244, 200000, 171, 520, 85), -- Transmute: Pyrium Bar
(201001, 80245, 250000, 171, 525, 85), -- Transmute: Inferno Ruby
(201001, 80237, 250000, 171, 525, 85), -- Transmute: Shadowspirit Diamond
(201001, 80243, 250000, 171, 525, 85), -- Transmute: Truegold
(201001, 80725, 250000, 171, 525, 85), -- Potion of Deepholm
(201001, 80726, 250000, 171, 525, 85); -- Potion of Treasure Finding
Here is inscription
-- Inscription trainers
DELETE FROM `npc_trainer` WHERE `ID`= 201021 OR `SpellID`= -201021;
INSERT INTO `npc_trainer` (`ID`,`SpellID`,`MoneyCost`,`ReqSkillLine`,`ReqSkillRank`,`ReqLevel`) VALUES
( 25263, -201021, 0, 0, 0, 0), -- World Inscription Trainer
( 26916, -201021, 0, 0, 0, 0), -- Mindri Dinkles
( 26959, -201021, 0, 0, 0, 0), -- Booker Kells
( 26977, -201021, 0, 0, 0, 0), -- Adelene Sunlance
( 26995, -201021, 0, 0, 0, 0), -- Tink Brightbolt
( 28702, -201021, 0, 0, 0, 0), -- Professor Pallin
( 30706, -201021, 0, 0, 0, 0), -- Jo'mah
( 30709, -201021, 0, 0, 0, 0), -- Poshken Hardbinder
( 30710, -201021, 0, 0, 0, 0), -- Zantasia
( 30711, -201021, 0, 0, 0, 0), -- Margaux Parchley
( 30713, -201021, 0, 0, 0, 0), -- Catarina Stanford
( 30715, -201021, 0, 0, 0, 0), -- Feyden Darkin
( 30716, -201021, 0, 0, 0, 0), -- Thoth
( 30717, -201021, 0, 0, 0, 0), -- Elise Brightletter
( 30721, -201021, 0, 0, 0, 0), -- Michael Schwan
( 30722, -201021, 0, 0, 0, 0), -- Neferatti
( 33603, -201021, 0, 0, 0, 0), -- Arthur Denny
( 33638, -201021, 0, 0, 0, 0), -- Scribe Lanloer
( 33679, -201021, 0, 0, 0, 0), -- Recorder Lidio
( 46716, -201021, 0, 0, 0, 0), -- Nerog
( 56065, -201021, 0, 0, 0, 0), -- Inkmaster Wei
( 62327, -201021, 0, 0, 0, 0), -- Scribe Rinji
( 64691, -201021, 0, 0, 0, 0), -- Lorewalker Huynh
( 85911, -201021, 0, 0, 0, 0), -- Scribe Chi-Yuan
( 86015, -201021, 0, 0, 0, 0), -- Joro'man
( 92195, -201021, 0, 0, 0, 0), -- Professor Pallin
( 99169, -201021, 0, 0, 0, 0), -- Professor Pallin
(201021, 45357, 10, 773, 0, 5), -- Apprentice Inscription
(201021, 52843, 50, 773, 1, 5), -- Moonglow Ink
(201021, 58472, 50, 773, 15, 5), -- Scroll of Agility
(201021, 58484, 50, 773, 15, 5), -- Scroll of Strength
(201021, 48248, 50, 773, 35, 5), -- Scroll of Recall
(201021, 52739, 150, 773, 35, 5), -- Enchanting Vellum
(201021, 45358, 500, 773, 50, 5), -- Journeyman Inscription
(201021, 53462, 300, 773, 75, 10), -- Midnight Ink
(201021, 50598, 400, 773, 75, 10), -- Scroll of Intellect II
(201021, 50612, 400, 773, 75, 10), -- Scroll of Stamina II
(201021, 50605, 400, 773, 75, 10), -- Scroll of Versatility II
(201021, 92026, 400, 773, 75, 10), -- Vanishing Powder
(201021, 58485, 400, 773, 80, 10), -- Scroll of Strength II
(201021, 57703, 400, 773, 85, 10), -- Hunter's Ink
(201021, 58473, 400, 773, 85, 10), -- Scroll of Agility II
(201021, 58565, 500, 773, 85, 10), -- Mystic Tome
(201021, 48247, 500, 773, 85, 10), -- Mysterious Tarot
(201021, 57704, 400, 773, 100, 10), -- Lion's Ink
(201021, 45359, 500, 773, 125, 20), -- Expert Inscription
(201021, 57706, 750, 773, 125, 20), -- Dawnstar Ink
(201021, 59478, 750, 773, 125, 20), -- Book of Survival
(201021, 59475, 750, 773, 125, 20), -- Tome of the Dawn
(201021, 59480, 750, 773, 125, 20), -- Strange Tarot
(201021, 57707, 750, 773, 150, 20), -- Jadefire Ink
(201021, 50614, 750, 773, 155, 20), -- Scroll of Stamina III
(201021, 50606, 750, 773, 155, 20), -- Scroll of Versatility III
(201021, 50599, 750, 773, 165, 20), -- Scroll of Intellect III
(201021, 58486, 750, 773, 170, 20), -- Scroll of Strength III
(201021, 57708, 750, 773, 175, 20), -- Royal Ink
(201021, 58476, 750, 773, 175, 20), -- Scroll of Agility III
(201021, 59486, 750, 773, 175, 20), -- Royal Guide of Escape Routes
(201021, 59484, 750, 773, 175, 20), -- Tome of Kings
(201021, 59487, 750, 773, 175, 20), -- Arcane Tarot
(201021, 45360, 50000, 773, 200, 35), -- Artisan Inscription
(201021, 57709, 3000, 773, 200, 35), -- Celestial Ink
(201021, 59387, 3000, 773, 200, 35), -- Certificate of Ownership
(201021, 60336, 3000, 773, 200, 35), -- Scroll of Recall II
(201021, 50616, 4500, 773, 205, 35), -- Scroll of Stamina IV
(201021, 50607, 4500, 773, 210, 35), -- Scroll of Versatility IV
(201021, 50600, 4500, 773, 215, 35), -- Scroll of Intellect IV
(201021, 58487, 4500, 773, 220, 35), -- Scroll of Strength IV
(201021, 57710, 6000, 773, 225, 35), -- Fiery Ink
(201021, 58478, 4500, 773, 225, 35), -- Scroll of Agility IV
(201021, 59490, 6000, 773, 225, 35), -- Book of Stars
(201021, 59489, 6000, 773, 225, 35), -- Fire Eater's Guide
(201021, 59491, 6000, 773, 225, 35), -- Shadowy Tarot
(201021, 57711, 10000, 773, 250, 35), -- Shimmering Ink
(201021, 50617, 10000, 773, 250, 35), -- Scroll of Stamina V
(201021, 50608, 10000, 773, 255, 35), -- Scroll of Versatility V
(201021, 50601, 10000, 773, 260, 35), -- Scroll of Intellect V
(201021, 58488, 10000, 773, 270, 35), -- Scroll of Strength V
(201021, 58480, 10000, 773, 250, 35), -- Scroll of Agility V
(201021, 45361, 100000, 773, 275, 50), -- Master Inscription
(201021, 59502, 10000, 773, 275, 50), -- Darkmoon Card
(201021, 59494, 10000, 773, 275, 50), -- Manual of Clouds
(201021, 59493, 10000, 773, 275, 50), -- Stormbound Tome
(201021, 57712, 10000, 773, 275, 50), -- Ink of the Sky
(201021, 57713, 20000, 773, 290, 50), -- Ethereal Ink
(201021, 50618, 20000, 773, 290, 50), -- Scroll of Stamina VI
(201021, 50609, 20000, 773, 295, 50), -- Scroll of Versatility VI
(201021, 50602, 20000, 773, 300, 50), -- Scroll of Intellect VI
(201021, 58489, 20000, 773, 305, 50), -- Scroll of Strength VI
(201021, 58481, 20000, 773, 310, 50), -- Scroll of Agility VI
(201021, 57714, 20000, 773, 325, 50), -- Darkflame Ink
(201021, 59496, 20000, 773, 325, 50), -- Book of Clever Tricks
(201021, 59495, 20000, 773, 325, 50), -- Hellfire Tome
(201021, 59503, 20000, 773, 325, 50), -- Greater Darkmoon Card
(201021, 45363, 350000, 773, 350, 65), -- Grand Master Inscription
(201021, 57715, 50000, 773, 350, 65), -- Ink of the Sea
(201021, 60337, 50000, 773, 350, 65), -- Scroll of Recall III
(201021, 50619, 50000, 773, 350, 65), -- Scroll of Stamina VII
(201021, 64053, 50000, 773, 350, 65), -- Twilight Tome
(201021, 50610, 50000, 773, 355, 65), -- Scroll of Versatility VII
(201021, 50603, 50000, 773, 360, 65), -- Scroll of Intellect VII
(201021, 58490, 50000, 773, 365, 65), -- Scroll of Strength VII
(201021, 58482, 50000, 773, 370, 65), -- Scroll of Agility VII
(201021, 57716, 50000, 773, 375, 65), -- Snowfall Ink
(201021, 61117, 75000, 773, 400, 65), -- Master's Inscription of the Axe
(201021, 61118, 75000, 773, 400, 65), -- Master's Inscription of the Crag
(201021, 61119, 75000, 773, 400, 65), -- Master's Inscription of the Pinnacle
(201021, 61120, 75000, 773, 400, 65), -- Master's Inscription of the Storm
(201021, 50620, 60000, 773, 400, 65), -- Scroll of Stamina VIII
(201021, 59498, 60000, 773, 400, 65), -- Faces of Doom
(201021, 59497, 60000, 773, 400, 65), -- Iron-bound Tome
(201021, 59504, 60000, 773, 400, 65), -- Darkmoon Card of the North
(201021, 50611, 60000, 773, 405, 65), -- Scroll of Versatility VIII
(201021, 50604, 60000, 773, 410, 65), -- Scroll of Intellect VIII
(201021, 58491, 60000, 773, 415, 65), -- Scroll of Strength VIII
(201021, 58483, 60000, 773, 420, 65), -- Scroll of Agility VIII
(201021, 86008, 500000, 773, 425, 80), -- Illustrious Grand Master Inscription
(201021, 86004, 80000, 773, 425, 80), -- Blackfallow Ink
(201021, 69385, 120000, 773, 440, 80), -- Runescroll of Fortitude
(201021, 89368, 80000, 773, 445, 80), -- Scroll of Intellect IX
(201021, 89373, 80000, 773, 450, 80), -- Scroll of Protection IX
(201021, 86609, 80000, 773, 450, 80), -- Mysterious Fortune Card
(201021, 89371, 80000, 773, 455, 80), -- Scroll of Versatility IX
(201021, 89372, 80000, 773, 460, 80), -- Scroll of Stamina IX
(201021, 89369, 80000, 773, 465, 80), -- Scroll of Strength IX
(201021, 86005, 90000, 773, 475, 80), -- Inferno Ink
(201021, 86616, 90000, 773, 475, 80), -- Book of Blood
(201021, 86640, 90000, 773, 475, 80), -- Lord Rottington's Pressed Wisp Book
(201021, 86648, 90000, 773, 480, 80), -- Key to the Planes
(201021, 105206, 600000, 773, 500, 85), -- Zen Master Inscription
(201021, 86403, 75000, 773, 500, 85), -- Felfire Inscription
(201021, 86402, 75000, 773, 500, 85), -- Inscription of the Earth Prince
(201021, 86401, 75000, 773, 500, 85), -- Lionsmane Inscription
(201021, 86375, 75000, 773, 500, 85), -- Swiftsteel Inscription
(201021, 85785, 120000, 773, 500, 85), -- Runescroll of Fortitude II
(201021, 86654, 100000, 773, 500, 85), -- Forged Documents
(201021, 89244, 100000, 773, 500, 85), -- Forged Documents
(201021, 111646, 200000, 773, 500, 85), -- Starlight Ink
(201021, 111645, 200000, 773, 500, 85), -- Ink of Dreams
(201021, 86649, 120000, 773, 505, 85), -- Runed Staff
(201021, 86643, 120000, 773, 510, 85), -- Battle Tome
(201021, 86642, 120000, 773, 510, 85), -- Divine Companion
(201021, 86641, 120000, 773, 510, 85), -- Dungeoneering Guide
(201021, 86652, 150000, 773, 515, 85), -- Rosethorn Staff
(201021, 86653, 150000, 773, 515, 85), -- Silver Inlaid Staff
(201021, 86615, 200000, 773, 525, 85), -- Darkmoon Card of Destruction
(201021, 112996, 500000, 773, 525, 85), -- Scroll of Wisdom
(201021, 127018, 200000, 773, 540, 85), -- Crane Wing Inscription
(201021, 127019, 200000, 773, 540, 85), -- Ox Horn Inscription
(201021, 127017, 200000, 773, 540, 85), -- Tiger Claw Inscription
(201021, 127016, 200000, 773, 540, 85), -- Tiger Fang Inscription
(201021, 111920, 200000, 773, 560, 85), -- Ghost Iron Staff
(201021, 111908, 200000, 773, 560, 85), -- Inscribed Fan
(201021, 111917, 200000, 773, 560, 85), -- Rain Poppy Staff
(201021, 111909, 200000, 773, 560, 85), -- Inscribed Jade Fan
(201021, 111910, 200000, 773, 560, 85), -- Inscribed Red Fan
(201021, 111918, 200000, 773, 560, 85), -- Inscribed Crane Staff
(201021, 111919, 200000, 773, 560, 85), -- Inscribed Serpent Staff
(201021, 111921, 200000, 773, 560, 85), -- Inscribed Tiger Staff
(201021, 126995, 200000, 773, 570, 85), -- Greater Crane Wing Inscription
(201021, 126994, 200000, 773, 570, 85), -- Greater Ox Horn Inscription
(201021, 126996, 200000, 773, 570, 85), -- Greater Tiger Claw Inscription
(201021, 126997, 200000, 773, 570, 85), -- Greater Tiger Fang Inscription
(201021, 127023, 200000, 773, 575, 85), -- Secret Crane Wing Inscription
(201021, 127024, 200000, 773, 575, 85), -- Secret Ox Horn Inscription
(201021, 127021, 200000, 773, 575, 85), -- Secret Tiger Claw Inscription
(201021, 127020, 200000, 773, 575, 85), -- Secret Tiger Fang Inscription
(201021, 112045, 200000, 773, 580, 85), -- Runescroll of Fortitude III
(201021, 111830, 200000, 773, 600, 85), -- Darkmoon Card of Mists
(201021, 127009, 50000, 773, 600, 85), -- Chi-ji Kite
(201021, 126988, 50000, 773, 600, 85), -- Origami Crane
(201021, 126989, 50000, 773, 600, 85), -- Origami Frog
(201021, 127007, 50000, 773, 600, 85); -- Yu'lon Kite
Here is the last one, Archaeology
-- Archaeology trainers
DELETE FROM `npc_trainer` WHERE `ID` = 202013 OR `SpellID` = -202013;
INSERT INTO `npc_trainer` (`ID`,`SpellID`,`MoneyCost`,`ReqSkillLine`,`ReqSkillRank`,`ReqLevel`) VALUES
(39718, -202013, 0, 0, 0, 0), -- Doktor Professor Ironpants
(44238, -202013, 0, 0, 0, 0), -- Harrison Jones
(47346, -202013, 0, 0, 0, 0), -- Elynara
(47382, -202013, 0, 0, 0, 0), -- Adam Hossack
(47568, -202013, 0, 0, 0, 0), -- Ian Thomas Wall
(47569, -202013, 0, 0, 0, 0), -- Hammon the Jaded
(47570, -202013, 0, 0, 0, 0), -- Diya
(47571, -202013, 0, 0, 0, 0), -- Belloc Brightblade
(47572, -202013, 0, 0, 0, 0), -- Otoh Greyhide
(47573, -202013, 0, 0, 0, 0), -- Sirabel
(47574, -202013, 0, 0, 0, 0), -- Gerdra Fardelve
(47575, -202013, 0, 0, 0, 0), -- Boduro the Seeker
(47576, -202013, 0, 0, 0, 0), -- Falda Fardelve
(47577, -202013, 0, 0, 0, 0), -- Lindarel
(47578, -202013, 0, 0, 0, 0), -- Hugen Goldwise
(47579, -202013, 0, 0, 0, 0), -- Dariness the Learned
(47683, -202013, 0, 0, 0, 0), -- Lady Ironpants
(51997, -202013, 0, 0, 0, 0), -- Stephanie Krutsick
(53421, -202013, 0, 0, 0, 0), -- Faena Woolybush
(64922, -202013, 0, 0, 0, 0), -- Brann Bronzebeard
(67586, -202013, 0, 0, 0, 0), -- Elynara
(67837, -202013, 0, 0, 0, 0), -- Elynara
(85927, -202013, 0, 0, 0, 0), -- Manda Darlowe
(86033, -202013, 0, 0, 0, 0), -- Reena Cogscrap
(93538, -202013, 0, 0, 0, 0), -- Dariness the Learned
-- Archaeology spells
(202013, 78670, 100, 0, 0, 5), -- Apprentice Archaeology
(202013, 88961, 500, 794, 50, 10), -- Journeyman Archaeology
(202013, 89718, 5000, 794, 200, 20), -- Artisan Archaeology
(202013, 89719, 25000, 794, 125, 35), -- Expert Archaeology
(202013, 89720, 100000, 794, 275, 50), -- Master Archaeology
(202013, 89721, 150000, 794, 350, 65), -- Grand Master Archaeology
(202013, 89722, 250000, 794, 425, 80), -- Illustrious Grand Master Fishing
(202013, 110393, 600000, 794, 500, 85); -- Zen Master Archaeology
Hi All,
These changes have been tested, and are working as intended.
I believe this ticket is ready to commit all changes, and close.
Could this be actioned please?
Thanks,
Glenn
AussieGlenn
on 14 Apr 2017
Related issues
funjoker
路
3Comments
Tatara902
路
3Comments
DDuarte
路
3Comments
cbcs
路
3Comments
Rushor
路
3Comments
Most helpful comment
I vote aliance sniffs fucked horde trainers.