diff options
| -rw-r--r-- | sql/updates/world/master/2016_11_28_00_world.sql | 465 |
1 files changed, 465 insertions, 0 deletions
diff --git a/sql/updates/world/master/2016_11_28_00_world.sql b/sql/updates/world/master/2016_11_28_00_world.sql new file mode 100644 index 00000000000..7d355b7037e --- /dev/null +++ b/sql/updates/world/master/2016_11_28_00_world.sql @@ -0,0 +1,465 @@ +-- 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 + +-- 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 +-- Spells +(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, 40000, 129, 325, 50), -- Heavy Netherweave Bandage +(202007, 45542, 150000, 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, 80000, 129, 475, 75), -- Heavy Embersilk Bandage +(202007, 74558, 15000, 129, 500, 75), -- Field Bandage: Dense Embersilk +(202007, 74559, 250000, 129, 425, 0), -- First Aid, rank 7 +(202007, 88893, 80000, 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, 300000, 129, 0, 0); -- First Aid, rank 8 + +-- 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, 600000, 186, 500, 0); -- Zen Master Miner |