diff options
| -rw-r--r-- | sql/updates/world/master/2017_03_18_05_world.sql | 471 |
1 files changed, 471 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_03_18_05_world.sql b/sql/updates/world/master/2017_03_18_05_world.sql new file mode 100644 index 00000000000..4ad1845378e --- /dev/null +++ b/sql/updates/world/master/2017_03_18_05_world.sql @@ -0,0 +1,471 @@ +-- Gossip Fix for The following 10 Multi Profession Trainers. C++ Scripting will be required for training to work. + +-- 47384 Lien Farner +-- 47396 Wembil Taskwidget +-- 47400 Nedric Sallow +-- 47418 Runda +-- 47419 Lalum Darkmane +-- 47420 Iranis Shadebloom +-- 47421 Saren +-- 47431 Valn +-- 48619 Therisa Sallow +-- 50247 Jack "All-Trades" Derrington + +-- Fix Gossip For 3 of the Multi Profession Trainers +UPDATE `creature_template` SET `gossip_menu_id`=12180 WHERE `entry` IN (47384,47396,47419); + +-- Multi Profession Trainer Gossip +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (12180,12185,12186,12188,12189,12190,12191,12192,12193,12195,12196,12197,12198,12199); +INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +-- Top Menu +(12180,0,3, 'Train me in Alchemy.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12180,1,3, 'Train me in Blacksmithing.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12180,2,3, 'Train me in Enchanting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12180,3,3, 'Train me in Engineering.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12180,4,3, 'Train me in Herbalism.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12180,5,3, 'Train me in Inscription.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12180,6,3, 'Train me in Jewelcrafting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12180,7,3, 'Train me in Leatherworking.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12180,8,3, 'Train me in Mining.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12180,9,3, 'Train me in Skinning.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12180,10,3, 'Train me in Tailoring.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12180,11,0, 'Tell me about gathering professions.',0,1,1,12185,0,0,0, '',0,23420), +(12180,12,0, 'Tell me about production professions.',0,1,1,12186,0,0,0, '',0,23420), +-- Gathering Menu +(12185,0,3, 'Train me in Alchemy.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12185,1,3, 'Train me in Blacksmithing.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12185,2,3, 'Train me in Enchanting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12185,3,3, 'Train me in Engineering.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12185,4,3, 'Train me in Herbalism.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12185,5,3, 'Train me in Inscription.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12185,6,3, 'Train me in Jewelcrafting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12185,7,3, 'Train me in Leatherworking.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12185,8,3, 'Train me in Mining.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12185,9,3, 'Train me in Skinning.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12185,10,3, 'Train me in Tailoring.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12185,11,0, 'Tell me about Herbalism.',0,1,1,12188,0,0,0, '',0,23420), +(12185,12,0, 'Tell me about Mining.',0,1,1,12189,0,0,0, '',0,23420), +(12185,13,0, 'Tell me about Skinning.',0,1,1,12190,0,0,0, '',0,23420), +(12185,14,0, 'Tell me about production professions.',0,1,1,12186,0,0,0, '',0,23420), +-- Production Menu +(12186,0,3, 'Train me in Alchemy.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12186,1,3, 'Train me in Blacksmithing.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12186,2,3, 'Train me in Enchanting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12186,3,3, 'Train me in Engineering.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12186,4,3, 'Train me in Herbalism.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12186,5,3, 'Train me in Inscription.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12186,6,3, 'Train me in Jewelcrafting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12186,7,3, 'Train me in Leatherworking.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12186,8,3, 'Train me in Mining.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12186,9,3, 'Train me in Skinning.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12186,10,3, 'Train me in Tailoring.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12186,11,0, 'Tell me about Alchemy.',0,1,1,12191,0,0,0, '',0,23420), +(12186,12,0, 'Tell me about Blacksmithing.',0,1,1,12192,0,0,0, '',0,23420), +(12186,13,0, 'Tell me about Enchanting.',0,1,1,12193,0,0,0, '',0,23420), +(12186,14,0, 'Tell me about Engineering.',0,1,1,0,0,0,0, '',0,23420), +(12186,15,0, 'Tell me about Inscription.',0,1,1,12196,0,0,0, '',0,23420), +(12186,16,0, 'Tell me about Jewelcrafting.',0,1,1,12197,0,0,0, '',0,23420), +(12186,17,0, 'Tell me about Leatherworking.',0,1,1,12198,0,0,0, '',0,23420), +(12186,18,0, 'Tell me about Tailoring.',0,1,1,12199,0,0,0, '',0,23420), +(12186,19,0, 'Tell me about gathering professions.',0,1,1,12185,0,0,0, '',0,23420), +-- Herbalism +(12188,0,3, 'Train me in Alchemy.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12188,1,3, 'Train me in Blacksmithing.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12188,2,3, 'Train me in Enchanting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12188,3,3, 'Train me in Engineering.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12188,4,3, 'Train me in Herbalism.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12188,5,3, 'Train me in Inscription.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12188,6,3, 'Train me in Jewelcrafting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12188,7,3, 'Train me in Leatherworking.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12188,8,3, 'Train me in Mining.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12188,9,3, 'Train me in Skinning.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12188,10,3, 'Train me in Tailoring.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12188,11,3, 'Train me in Herbalism.',0,1,1,0,0,0,0, '',0,23420), -- Don't show if player has profession +(12188,12,0, 'Tell me about Alchemy.',0,1,1,12191,0,0,0, '',0,23420), +(12188,13,0, 'Tell me about Inscription.',0,1,1,12196,0,0,0, '',0,23420), +(12188,14,0, 'Tell me about gathering professions.',0,1,1,12185,0,0,0, '',0,23420), +(12188,15,0, 'Tell me about production professions.',0,1,1,12186,0,0,0, '',0,23420), +-- Mining +(12189,0,3, 'Train me in Alchemy.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12189,1,3, 'Train me in Blacksmithing.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12189,2,3, 'Train me in Enchanting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12189,3,3, 'Train me in Engineering.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12189,4,3, 'Train me in Herbalism.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12189,5,3, 'Train me in Inscription.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12189,6,3, 'Train me in Jewelcrafting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12189,7,3, 'Train me in Leatherworking.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12189,8,3, 'Train me in Mining.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12189,9,3, 'Train me in Skinning.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12189,10,3, 'Train me in Tailoring.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12189,11,3, 'Train me in Mining.',0,1,1,0,0,0,0, '',0,23420), -- Don't show if player has profession +(12189,12,0, 'Tell me about Blacksmithing.',0,1,1,12192,0,0,0, '',0,23420), +(12189,13,0, 'Tell me about Engineering.',0,1,1,0,0,0,0, '',0,23420), +(12189,14,0, 'Tell me about Jewelcrafting.',0,1,1,12197,0,0,0, '',0,23420), +(12189,15,0, 'Tell me about gathering professions.',0,1,1,12185,0,0,0, '',0,23420), +(12189,16,0, 'Tell me about production professions.',0,1,1,12186,0,0,0, '',0,23420), +-- Skinning +(12190,0,3, 'Train me in Alchemy.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12190,1,3, 'Train me in Blacksmithing.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12190,2,3, 'Train me in Enchanting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12190,3,3, 'Train me in Engineering.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12190,4,3, 'Train me in Herbalism.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12190,5,3, 'Train me in Inscription.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12190,6,3, 'Train me in Jewelcrafting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12190,7,3, 'Train me in Leatherworking.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12190,8,3, 'Train me in Mining.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12190,9,3, 'Train me in Skinning.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12190,10,3, 'Train me in Tailoring.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12190,11,3, 'Train me in Skinning.',0,1,1,0,0,0,0, '',0,23420), -- Don't show if player has profession +(12190,12,0, 'Tell me about Leatherworking.',0,1,1,12198,0,0,0, '',0,23420), +(12190,13,0, 'Tell me about gathering professions.',0,1,1,12185,0,0,0, '',0,23420), +(12190,14,0, 'Tell me about production professions.',0,1,1,12186,0,0,0, '',0,23420), +-- Alchemy +(12191,0,3, 'Train me in Alchemy.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12191,1,3, 'Train me in Blacksmithing.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12191,2,3, 'Train me in Enchanting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12191,3,3, 'Train me in Engineering.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12191,4,3, 'Train me in Herbalism.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12191,5,3, 'Train me in Inscription.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12191,6,3, 'Train me in Jewelcrafting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12191,7,3, 'Train me in Leatherworking.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12191,8,3, 'Train me in Mining.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12191,9,3, 'Train me in Skinning.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12191,10,3, 'Train me in Tailoring.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12191,11,3, 'Train me in Alchemy.',0,1,1,0,0,0,0, '',0,23420), -- Don't show if player has profession +(12191,12,0, 'Tell me about Herbalism.',0,1,1,12188,0,0,0, '',0,23420), +(12191,13,0, 'Tell me about Inscription.',0,1,1,12196,0,0,0, '',0,23420), +(12191,14,0, 'Tell me about gathering professions.',0,1,1,12185,0,0,0, '',0,23420), +(12191,15,0, 'Tell me about production professions.',0,1,1,12186,0,0,0, '',0,23420), +-- Blacksmithing +(12192,0,3, 'Train me in Alchemy.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12192,1,3, 'Train me in Blacksmithing.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12192,2,3, 'Train me in Enchanting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12192,3,3, 'Train me in Engineering.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12192,4,3, 'Train me in Herbalism.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12192,5,3, 'Train me in Inscription.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12192,6,3, 'Train me in Jewelcrafting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12192,7,3, 'Train me in Leatherworking.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12192,8,3, 'Train me in Mining.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12192,9,3, 'Train me in Skinning.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12192,10,3, 'Train me in Tailoring.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12192,11,3, 'Train me in Blacksmithing.',0,1,1,0,0,0,0, '',0,23420), -- Don't show if player has profession +(12192,12,0, 'Tell me about Mining.',0,1,1,12189,0,0,0, '',0,23420), +(12192,13,0, 'Tell me about gathering professions.',0,1,1,12185,0,0,0, '',0,23420), +(12192,14,0, 'Tell me about production professions.',0,1,1,12186,0,0,0, '',0,23420), +-- Enchanting +(12193,0,3, 'Train me in Alchemy.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12193,1,3, 'Train me in Blacksmithing.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12193,2,3, 'Train me in Enchanting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12193,3,3, 'Train me in Engineering.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12193,4,3, 'Train me in Herbalism.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12193,5,3, 'Train me in Inscription.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12193,6,3, 'Train me in Jewelcrafting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12193,7,3, 'Train me in Leatherworking.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12193,8,3, 'Train me in Mining.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12193,9,3, 'Train me in Skinning.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12193,10,3, 'Train me in Tailoring.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12193,11,3, 'Train me in Enchanting.',0,1,1,0,0,0,0, '',0,23420), -- Don't show if player has profession +(12193,12,0, 'Tell me about Tailoring.',0,1,1,12199,0,0,0, '',0,23420), +(12193,13,0, 'Tell me about gathering professions.',0,1,1,12185,0,0,0, '',0,23420), +(12193,14,0, 'Tell me about production professions.',0,1,1,12186,0,0,0, '',0,23420), +-- Engineering +(12195,0,3, 'Train me in Alchemy.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12195,1,3, 'Train me in Blacksmithing.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12195,2,3, 'Train me in Enchanting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12195,3,3, 'Train me in Engineering.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12195,4,3, 'Train me in Herbalism.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12195,5,3, 'Train me in Inscription.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12195,6,3, 'Train me in Jewelcrafting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12195,7,3, 'Train me in Leatherworking.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12195,8,3, 'Train me in Mining.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12195,9,3, 'Train me in Skinning.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12195,10,3, 'Train me in Tailoring.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12195,11,3, 'Train me in Engineering.',0,1,1,0,0,0,0, '',0,23420), -- Don't show if player has profession +(12195,12,0, 'Tell me about Mining.',0,1,1,12189,0,0,0, '',0,23420), +(12195,13,0, 'Tell me about gathering professions.',0,1,1,12185,0,0,0, '',0,23420), +(12195,14,0, 'Tell me about production professions.',0,1,1,12186,0,0,0, '',0,23420), +-- Inscription +(12196,0,3, 'Train me in Alchemy.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12196,1,3, 'Train me in Blacksmithing.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12196,2,3, 'Train me in Enchanting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12196,3,3, 'Train me in Engineering.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12196,4,3, 'Train me in Herbalism.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12196,5,3, 'Train me in Inscription.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12196,6,3, 'Train me in Jewelcrafting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12196,7,3, 'Train me in Leatherworking.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12196,8,3, 'Train me in Mining.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12196,9,3, 'Train me in Skinning.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12196,10,3, 'Train me in Tailoring.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12196,11,3, 'Train me in Inscription.',0,1,1,0,0,0,0, '',0,23420), -- Don't show if player has profession +(12196,12,0, 'Tell me about Herbalism.',0,1,1,12188,0,0,0, '',0,23420), +(12196,13,0, 'Tell me about gathering professions.',0,1,1,12185,0,0,0, '',0,23420), +(12196,14,0, 'Tell me about production professions.',0,1,1,12186,0,0,0, '',0,23420), +-- Jewelcrafting +(12197,0,3, 'Train me in Alchemy.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12197,1,3, 'Train me in Blacksmithing.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12197,2,3, 'Train me in Enchanting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12197,3,3, 'Train me in Engineering.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12197,4,3, 'Train me in Herbalism.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12197,5,3, 'Train me in Inscription.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12197,6,3, 'Train me in Jewelcrafting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12197,7,3, 'Train me in Leatherworking.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12197,8,3, 'Train me in Mining.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12197,9,3, 'Train me in Skinning.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12197,10,3, 'Train me in Tailoring.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12197,11,3, 'Train me in Jewelcrafting.',0,1,1,0,0,0,0, '',0,23420), -- Don't show if player has profession +(12197,12,0, 'Tell me about Mining.',0,1,1,12189,0,0,0, '',0,23420), +(12197,13,0, 'Tell me about gathering professions.',0,1,1,12185,0,0,0, '',0,23420), +(12197,14,0, 'Tell me about production professions.',0,1,1,12186,0,0,0, '',0,23420), +-- Leatherworking +(12198,0,3, 'Train me in Alchemy.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12198,1,3, 'Train me in Blacksmithing.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12198,2,3, 'Train me in Enchanting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12198,3,3, 'Train me in Engineering.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12198,4,3, 'Train me in Herbalism.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12198,5,3, 'Train me in Inscription.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12198,6,3, 'Train me in Jewelcrafting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12198,7,3, 'Train me in Leatherworking.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12198,8,3, 'Train me in Mining.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12198,9,3, 'Train me in Skinning.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12198,10,3, 'Train me in Tailoring.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12198,11,3, 'Train me in Leatherworking.',0,1,1,0,0,0,0, '',0,23420), -- Don't show if player has profession +(12198,12,0, 'Tell me about Skinning.',0,1,1,12190,0,0,0, '',0,23420), +(12198,13,0, 'Tell me about gathering professions.',0,1,1,12185,0,0,0, '',0,23420), +(12198,14,0, 'Tell me about production professions.',0,1,1,12186,0,0,0, '',0,23420), +-- Tailoring +(12199,0,3, 'Train me in Alchemy.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12199,1,3, 'Train me in Blacksmithing.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12199,2,3, 'Train me in Enchanting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12199,3,3, 'Train me in Engineering.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12199,4,3, 'Train me in Herbalism.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12199,5,3, 'Train me in Inscription.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12199,6,3, 'Train me in Jewelcrafting.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12199,7,3, 'Train me in Leatherworking.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12199,8,3, 'Train me in Mining.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12199,9,3, 'Train me in Skinning.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12199,10,3, 'Train me in Tailoring.',0,5,16,0,0,0,0, '',0,23420), -- Show if player has profession +(12199,11,3, 'Train me in Tailoring.',0,1,1,0,0,0,0, '',0,23420), -- Don't show if player has profession +(12199,12,0, 'Tell me about Enchanting.',0,1,1,12193,0,0,0, '',0,23420), +(12199,13,0, 'Tell me about gathering professions.',0,1,1,12185,0,0,0, '',0,23420), +(12199,14,0, 'Tell me about production professions.',0,1,1,12186,0,0,0, '',0,23420); + +-- Condition for source Gossip menu option condition type Skill Top Menu +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12180 AND `SourceEntry` BETWEEN 0 AND 10; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 12180, 0, 0, 0, 7, 0, 171, 1, 0, 0, 0, 0, '', 'Show gossip menu 12180 option id 0 if player has reached 1 on skill Alchemy.'), +(15, 12180, 1, 0, 0, 7, 0, 164, 1, 0, 0, 0, 0, '', 'Show gossip menu 12180 option id 1 if player has reached 1 on skill Blacksmithing.'), +(15, 12180, 2, 0, 0, 7, 0, 333, 1, 0, 0, 0, 0, '', 'Show gossip menu 12180 option id 2 if player has reached 1 on skill Enchanting.'), +(15, 12180, 3, 0, 0, 7, 0, 202, 1, 0, 0, 0, 0, '', 'Show gossip menu 12180 option id 3 if player has reached 1 on skill Engineering.'), +(15, 12180, 4, 0, 0, 7, 0, 182, 1, 0, 0, 0, 0, '', 'Show gossip menu 12180 option id 4 if player has reached 1 on skill Herbalism.'), +(15, 12180, 5, 0, 0, 7, 0, 773, 1, 0, 0, 0, 0, '', 'Show gossip menu 12180 option id 5 if player has reached 1 on skill Inscription.'), +(15, 12180, 6, 0, 0, 7, 0, 755, 1, 0, 0, 0, 0, '', 'Show gossip menu 12180 option id 6 if player has reached 1 on skill Jewelcrafting.'), +(15, 12180, 7, 0, 0, 7, 0, 165, 1, 0, 0, 0, 0, '', 'Show gossip menu 12180 option id 7 if player has reached 1 on skill Leatherworking.'), +(15, 12180, 8, 0, 0, 7, 0, 186, 1, 0, 0, 0, 0, '', 'Show gossip menu 12180 option id 8 if player has reached 1 on skill Mining.'), +(15, 12180, 9, 0, 0, 7, 0, 393, 1, 0, 0, 0, 0, '', 'Show gossip menu 12180 option id 9 if player has reached 1 on skill Skinning.'), +(15, 12180, 10, 0, 0, 7, 0, 197, 1, 0, 0, 0, 0, '', 'Show gossip menu 12180 option id 10 if player has reached 1 on skill Tailoring.'); + +-- Condition for source Gossip menu option condition type Skill Gathering Menu +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12185 AND `SourceEntry` BETWEEN 0 AND 10; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 12185, 0, 0, 0, 7, 0, 171, 1, 0, 0, 0, 0, '', 'Show gossip menu 12185 option id 0 if player has reached 1 on skill Alchemy.'), +(15, 12185, 1, 0, 0, 7, 0, 164, 1, 0, 0, 0, 0, '', 'Show gossip menu 12185 option id 1 if player has reached 1 on skill Blacksmithing.'), +(15, 12185, 2, 0, 0, 7, 0, 333, 1, 0, 0, 0, 0, '', 'Show gossip menu 12185 option id 2 if player has reached 1 on skill Enchanting.'), +(15, 12185, 3, 0, 0, 7, 0, 202, 1, 0, 0, 0, 0, '', 'Show gossip menu 12185 option id 3 if player has reached 1 on skill Engineering.'), +(15, 12185, 4, 0, 0, 7, 0, 182, 1, 0, 0, 0, 0, '', 'Show gossip menu 12185 option id 4 if player has reached 1 on skill Herbalism.'), +(15, 12185, 5, 0, 0, 7, 0, 773, 1, 0, 0, 0, 0, '', 'Show gossip menu 12185 option id 5 if player has reached 1 on skill Inscription.'), +(15, 12185, 6, 0, 0, 7, 0, 755, 1, 0, 0, 0, 0, '', 'Show gossip menu 12185 option id 6 if player has reached 1 on skill Jewelcrafting.'), +(15, 12185, 7, 0, 0, 7, 0, 165, 1, 0, 0, 0, 0, '', 'Show gossip menu 12185 option id 7 if player has reached 1 on skill Leatherworking.'), +(15, 12185, 8, 0, 0, 7, 0, 186, 1, 0, 0, 0, 0, '', 'Show gossip menu 12185 option id 8 if player has reached 1 on skill Mining.'), +(15, 12185, 9, 0, 0, 7, 0, 393, 1, 0, 0, 0, 0, '', 'Show gossip menu 12185 option id 9 if player has reached 1 on skill Skinning.'), +(15, 12185, 10, 0, 0, 7, 0, 197, 1, 0, 0, 0, 0, '', 'Show gossip menu 12185 option id 10 if player has reached 1 on skill Tailoring.'); + +-- Condition for source Gossip menu option condition type Skill Production Menu +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12186 AND `SourceEntry` BETWEEN 0 AND 10; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 12186, 0, 0, 0, 7, 0, 171, 1, 0, 0, 0, 0, '', 'Show gossip menu 12186 option id 0 if player has reached 1 on skill Alchemy.'), +(15, 12186, 1, 0, 0, 7, 0, 164, 1, 0, 0, 0, 0, '', 'Show gossip menu 12186 option id 1 if player has reached 1 on skill Blacksmithing.'), +(15, 12186, 2, 0, 0, 7, 0, 333, 1, 0, 0, 0, 0, '', 'Show gossip menu 12186 option id 2 if player has reached 1 on skill Enchanting.'), +(15, 12186, 3, 0, 0, 7, 0, 202, 1, 0, 0, 0, 0, '', 'Show gossip menu 12186 option id 3 if player has reached 1 on skill Engineering.'), +(15, 12186, 4, 0, 0, 7, 0, 182, 1, 0, 0, 0, 0, '', 'Show gossip menu 12186 option id 4 if player has reached 1 on skill Herbalism.'), +(15, 12186, 5, 0, 0, 7, 0, 773, 1, 0, 0, 0, 0, '', 'Show gossip menu 12186 option id 5 if player has reached 1 on skill Inscription.'), +(15, 12186, 6, 0, 0, 7, 0, 755, 1, 0, 0, 0, 0, '', 'Show gossip menu 12186 option id 6 if player has reached 1 on skill Jewelcrafting.'), +(15, 12186, 7, 0, 0, 7, 0, 165, 1, 0, 0, 0, 0, '', 'Show gossip menu 12186 option id 7 if player has reached 1 on skill Leatherworking.'), +(15, 12186, 8, 0, 0, 7, 0, 186, 1, 0, 0, 0, 0, '', 'Show gossip menu 12186 option id 8 if player has reached 1 on skill Mining.'), +(15, 12186, 9, 0, 0, 7, 0, 393, 1, 0, 0, 0, 0, '', 'Show gossip menu 12186 option id 9 if player has reached 1 on skill Skinning.'), +(15, 12186, 10, 0, 0, 7, 0, 197, 1, 0, 0, 0, 0, '', 'Show gossip menu 12186 option id 10 if player has reached 1 on skill Tailoring.'); + +-- Condition for source Gossip menu option condition type Skill Herbalism +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12188 AND `SourceEntry` BETWEEN 0 AND 11; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 12188, 0, 0, 0, 7, 0, 171, 1, 0, 0, 0, 0, '', 'Show gossip menu 12188 option id 0 if player has reached 1 on skill Alchemy.'), +(15, 12188, 1, 0, 0, 7, 0, 164, 1, 0, 0, 0, 0, '', 'Show gossip menu 12188 option id 1 if player has reached 1 on skill Blacksmithing.'), +(15, 12188, 2, 0, 0, 7, 0, 333, 1, 0, 0, 0, 0, '', 'Show gossip menu 12188 option id 2 if player has reached 1 on skill Enchanting.'), +(15, 12188, 3, 0, 0, 7, 0, 202, 1, 0, 0, 0, 0, '', 'Show gossip menu 12188 option id 3 if player has reached 1 on skill Engineering.'), +(15, 12188, 4, 0, 0, 7, 0, 182, 1, 0, 0, 0, 0, '', 'Show gossip menu 12188 option id 4 if player has reached 1 on skill Herbalism.'), +(15, 12188, 5, 0, 0, 7, 0, 773, 1, 0, 0, 0, 0, '', 'Show gossip menu 12188 option id 5 if player has reached 1 on skill Inscription.'), +(15, 12188, 6, 0, 0, 7, 0, 755, 1, 0, 0, 0, 0, '', 'Show gossip menu 12188 option id 6 if player has reached 1 on skill Jewelcrafting.'), +(15, 12188, 7, 0, 0, 7, 0, 165, 1, 0, 0, 0, 0, '', 'Show gossip menu 12188 option id 7 if player has reached 1 on skill Leatherworking.'), +(15, 12188, 8, 0, 0, 7, 0, 186, 1, 0, 0, 0, 0, '', 'Show gossip menu 12188 option id 8 if player has reached 1 on skill Mining.'), +(15, 12188, 9, 0, 0, 7, 0, 393, 1, 0, 0, 0, 0, '', 'Show gossip menu 12188 option id 9 if player has reached 1 on skill Skinning.'), +(15, 12188, 10, 0, 0, 7, 0, 197, 1, 0, 0, 0, 0, '', 'Show gossip menu 12188 option id 10 if player has reached 1 on skill Tailoring.'), +(15, 12188, 11, 0, 0, 7, 0, 182, 1, 0, 1, 0, 0, '', 'Do not show gossip menu 12188 option id 11 if player has reached 1 on skill Herbalism.'); + +-- Condition for source Gossip menu option condition type Skill Mining +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12189 AND `SourceEntry` BETWEEN 0 AND 11; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 12189, 0, 0, 0, 7, 0, 171, 1, 0, 0, 0, 0, '', 'Show gossip menu 12189 option id 0 if player has reached 1 on skill Alchemy.'), +(15, 12189, 1, 0, 0, 7, 0, 164, 1, 0, 0, 0, 0, '', 'Show gossip menu 12189 option id 1 if player has reached 1 on skill Blacksmithing.'), +(15, 12189, 2, 0, 0, 7, 0, 333, 1, 0, 0, 0, 0, '', 'Show gossip menu 12189 option id 2 if player has reached 1 on skill Enchanting.'), +(15, 12189, 3, 0, 0, 7, 0, 202, 1, 0, 0, 0, 0, '', 'Show gossip menu 12189 option id 3 if player has reached 1 on skill Engineering.'), +(15, 12189, 4, 0, 0, 7, 0, 182, 1, 0, 0, 0, 0, '', 'Show gossip menu 12189 option id 4 if player has reached 1 on skill Herbalism.'), +(15, 12189, 5, 0, 0, 7, 0, 773, 1, 0, 0, 0, 0, '', 'Show gossip menu 12189 option id 5 if player has reached 1 on skill Inscription.'), +(15, 12189, 6, 0, 0, 7, 0, 755, 1, 0, 0, 0, 0, '', 'Show gossip menu 12189 option id 6 if player has reached 1 on skill Jewelcrafting.'), +(15, 12189, 7, 0, 0, 7, 0, 165, 1, 0, 0, 0, 0, '', 'Show gossip menu 12189 option id 7 if player has reached 1 on skill Leatherworking.'), +(15, 12189, 8, 0, 0, 7, 0, 186, 1, 0, 0, 0, 0, '', 'Show gossip menu 12189 option id 8 if player has reached 1 on skill Mining.'), +(15, 12189, 9, 0, 0, 7, 0, 393, 1, 0, 0, 0, 0, '', 'Show gossip menu 12189 option id 9 if player has reached 1 on skill Skinning.'), +(15, 12189, 10, 0, 0, 7, 0, 197, 1, 0, 0, 0, 0, '', 'Show gossip menu 12189 option id 10 if player has reached 1 on skill Tailoring.'), +(15, 12189, 11, 0, 0, 7, 0, 186, 1, 0, 1, 0, 0, '', 'Do not show gossip menu 12189 option id 11 if player has reached 1 on skill Mining.'); + +-- Condition for source Gossip menu option condition type Skill Skinning +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12190 AND `SourceEntry` BETWEEN 0 AND 11; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 12190, 0, 0, 0, 7, 0, 171, 1, 0, 0, 0, 0, '', 'Show gossip menu 12190 option id 0 if player has reached 1 on skill Alchemy.'), +(15, 12190, 1, 0, 0, 7, 0, 164, 1, 0, 0, 0, 0, '', 'Show gossip menu 12190 option id 1 if player has reached 1 on skill Blacksmithing.'), +(15, 12190, 2, 0, 0, 7, 0, 333, 1, 0, 0, 0, 0, '', 'Show gossip menu 12190 option id 2 if player has reached 1 on skill Enchanting.'), +(15, 12190, 3, 0, 0, 7, 0, 202, 1, 0, 0, 0, 0, '', 'Show gossip menu 12190 option id 3 if player has reached 1 on skill Engineering.'), +(15, 12190, 4, 0, 0, 7, 0, 182, 1, 0, 0, 0, 0, '', 'Show gossip menu 12190 option id 4 if player has reached 1 on skill Herbalism.'), +(15, 12190, 5, 0, 0, 7, 0, 773, 1, 0, 0, 0, 0, '', 'Show gossip menu 12190 option id 5 if player has reached 1 on skill Inscription.'), +(15, 12190, 6, 0, 0, 7, 0, 755, 1, 0, 0, 0, 0, '', 'Show gossip menu 12190 option id 6 if player has reached 1 on skill Jewelcrafting.'), +(15, 12190, 7, 0, 0, 7, 0, 165, 1, 0, 0, 0, 0, '', 'Show gossip menu 12190 option id 7 if player has reached 1 on skill Leatherworking.'), +(15, 12190, 8, 0, 0, 7, 0, 186, 1, 0, 0, 0, 0, '', 'Show gossip menu 12190 option id 8 if player has reached 1 on skill Mining.'), +(15, 12190, 9, 0, 0, 7, 0, 393, 1, 0, 0, 0, 0, '', 'Show gossip menu 12190 option id 9 if player has reached 1 on skill Skinning.'), +(15, 12190, 10, 0, 0, 7, 0, 197, 1, 0, 0, 0, 0, '', 'Show gossip menu 12190 option id 10 if player has reached 1 on skill Tailoring.'), +(15, 12190, 11, 0, 0, 7, 0, 393, 1, 0, 1, 0, 0, '', 'Do not show gossip menu 12190 option id 11 if player has reached 1 on skill Skinning.'); + +-- Condition for source Gossip menu option condition type Skill Alchemy +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12191 AND `SourceEntry` BETWEEN 0 AND 11; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 12191, 0, 0, 0, 7, 0, 171, 1, 0, 0, 0, 0, '', 'Show gossip menu 12191 option id 0 if player has reached 1 on skill Alchemy.'), +(15, 12191, 1, 0, 0, 7, 0, 164, 1, 0, 0, 0, 0, '', 'Show gossip menu 12191 option id 1 if player has reached 1 on skill Blacksmithing.'), +(15, 12191, 2, 0, 0, 7, 0, 333, 1, 0, 0, 0, 0, '', 'Show gossip menu 12191 option id 2 if player has reached 1 on skill Enchanting.'), +(15, 12191, 3, 0, 0, 7, 0, 202, 1, 0, 0, 0, 0, '', 'Show gossip menu 12191 option id 3 if player has reached 1 on skill Engineering.'), +(15, 12191, 4, 0, 0, 7, 0, 182, 1, 0, 0, 0, 0, '', 'Show gossip menu 12191 option id 4 if player has reached 1 on skill Herbalism.'), +(15, 12191, 5, 0, 0, 7, 0, 773, 1, 0, 0, 0, 0, '', 'Show gossip menu 12191 option id 5 if player has reached 1 on skill Inscription.'), +(15, 12191, 6, 0, 0, 7, 0, 755, 1, 0, 0, 0, 0, '', 'Show gossip menu 12191 option id 6 if player has reached 1 on skill Jewelcrafting.'), +(15, 12191, 7, 0, 0, 7, 0, 165, 1, 0, 0, 0, 0, '', 'Show gossip menu 12191 option id 7 if player has reached 1 on skill Leatherworking.'), +(15, 12191, 8, 0, 0, 7, 0, 186, 1, 0, 0, 0, 0, '', 'Show gossip menu 12191 option id 8 if player has reached 1 on skill Mining.'), +(15, 12191, 9, 0, 0, 7, 0, 393, 1, 0, 0, 0, 0, '', 'Show gossip menu 12191 option id 9 if player has reached 1 on skill Skinning.'), +(15, 12191, 10, 0, 0, 7, 0, 197, 1, 0, 0, 0, 0, '', 'Show gossip menu 12191 option id 10 if player has reached 1 on skill Tailoring.'), +(15, 12191, 11, 0, 0, 7, 0, 171, 1, 0, 1, 0, 0, '', 'Do not show gossip menu 12191 option id 11 if player has reached 1 on skill Alchemy.'); + +-- Condition for source Gossip menu option condition type Skill Blacksmithing +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12192 AND `SourceEntry` BETWEEN 0 AND 11; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 12192, 0, 0, 0, 7, 0, 171, 1, 0, 0, 0, 0, '', 'Show gossip menu 12192 option id 0 if player has reached 1 on skill Alchemy.'), +(15, 12192, 1, 0, 0, 7, 0, 164, 1, 0, 0, 0, 0, '', 'Show gossip menu 12192 option id 1 if player has reached 1 on skill Blacksmithing.'), +(15, 12192, 2, 0, 0, 7, 0, 333, 1, 0, 0, 0, 0, '', 'Show gossip menu 12192 option id 2 if player has reached 1 on skill Enchanting.'), +(15, 12192, 3, 0, 0, 7, 0, 202, 1, 0, 0, 0, 0, '', 'Show gossip menu 12192 option id 3 if player has reached 1 on skill Engineering.'), +(15, 12192, 4, 0, 0, 7, 0, 182, 1, 0, 0, 0, 0, '', 'Show gossip menu 12192 option id 4 if player has reached 1 on skill Herbalism.'), +(15, 12192, 5, 0, 0, 7, 0, 773, 1, 0, 0, 0, 0, '', 'Show gossip menu 12192 option id 5 if player has reached 1 on skill Inscription.'), +(15, 12192, 6, 0, 0, 7, 0, 755, 1, 0, 0, 0, 0, '', 'Show gossip menu 12192 option id 6 if player has reached 1 on skill Jewelcrafting.'), +(15, 12192, 7, 0, 0, 7, 0, 165, 1, 0, 0, 0, 0, '', 'Show gossip menu 12192 option id 7 if player has reached 1 on skill Leatherworking.'), +(15, 12192, 8, 0, 0, 7, 0, 186, 1, 0, 0, 0, 0, '', 'Show gossip menu 12192 option id 8 if player has reached 1 on skill Mining.'), +(15, 12192, 9, 0, 0, 7, 0, 393, 1, 0, 0, 0, 0, '', 'Show gossip menu 12192 option id 9 if player has reached 1 on skill Skinning.'), +(15, 12192, 10, 0, 0, 7, 0, 197, 1, 0, 0, 0, 0, '', 'Show gossip menu 12192 option id 10 if player has reached 1 on skill Tailoring.'), +(15, 12192, 11, 0, 0, 7, 0, 164, 1, 0, 1, 0, 0, '', 'Do not show gossip menu 12192 option id 11 if player has reached 1 on skill Blacksmithing.'); + +-- Condition for source Gossip menu option condition type Skill Enchanting +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12193 AND `SourceEntry` BETWEEN 0 AND 11; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 12193, 0, 0, 0, 7, 0, 171, 1, 0, 0, 0, 0, '', 'Show gossip menu 12193 option id 0 if player has reached 1 on skill Alchemy.'), +(15, 12193, 1, 0, 0, 7, 0, 164, 1, 0, 0, 0, 0, '', 'Show gossip menu 12193 option id 1 if player has reached 1 on skill Blacksmithing.'), +(15, 12193, 2, 0, 0, 7, 0, 333, 1, 0, 0, 0, 0, '', 'Show gossip menu 12193 option id 2 if player has reached 1 on skill Enchanting.'), +(15, 12193, 3, 0, 0, 7, 0, 202, 1, 0, 0, 0, 0, '', 'Show gossip menu 12193 option id 3 if player has reached 1 on skill Engineering.'), +(15, 12193, 4, 0, 0, 7, 0, 182, 1, 0, 0, 0, 0, '', 'Show gossip menu 12193 option id 4 if player has reached 1 on skill Herbalism.'), +(15, 12193, 5, 0, 0, 7, 0, 773, 1, 0, 0, 0, 0, '', 'Show gossip menu 12193 option id 5 if player has reached 1 on skill Inscription.'), +(15, 12193, 6, 0, 0, 7, 0, 755, 1, 0, 0, 0, 0, '', 'Show gossip menu 12193 option id 6 if player has reached 1 on skill Jewelcrafting.'), +(15, 12193, 7, 0, 0, 7, 0, 165, 1, 0, 0, 0, 0, '', 'Show gossip menu 12193 option id 7 if player has reached 1 on skill Leatherworking.'), +(15, 12193, 8, 0, 0, 7, 0, 186, 1, 0, 0, 0, 0, '', 'Show gossip menu 12193 option id 8 if player has reached 1 on skill Mining.'), +(15, 12193, 9, 0, 0, 7, 0, 393, 1, 0, 0, 0, 0, '', 'Show gossip menu 12193 option id 9 if player has reached 1 on skill Skinning.'), +(15, 12193, 10, 0, 0, 7, 0, 197, 1, 0, 0, 0, 0, '', 'Show gossip menu 12193 option id 10 if player has reached 1 on skill Tailoring.'), +(15, 12193, 11, 0, 0, 7, 0, 333, 1, 0, 1, 0, 0, '', 'Do not show gossip menu 12193 option id 11 if player has reached 1 on skill Enchanting.'); + +-- Condition for source Gossip menu option condition type Skill Engineering +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12195 AND `SourceEntry` BETWEEN 0 AND 11; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 12195, 0, 0, 0, 7, 0, 171, 1, 0, 0, 0, 0, '', 'Show gossip menu 12195 option id 0 if player has reached 1 on skill Alchemy.'), +(15, 12195, 1, 0, 0, 7, 0, 164, 1, 0, 0, 0, 0, '', 'Show gossip menu 12195 option id 1 if player has reached 1 on skill Blacksmithing.'), +(15, 12195, 2, 0, 0, 7, 0, 333, 1, 0, 0, 0, 0, '', 'Show gossip menu 12195 option id 2 if player has reached 1 on skill Enchanting.'), +(15, 12195, 3, 0, 0, 7, 0, 202, 1, 0, 0, 0, 0, '', 'Show gossip menu 12195 option id 3 if player has reached 1 on skill Engineering.'), +(15, 12195, 4, 0, 0, 7, 0, 182, 1, 0, 0, 0, 0, '', 'Show gossip menu 12195 option id 4 if player has reached 1 on skill Herbalism.'), +(15, 12195, 5, 0, 0, 7, 0, 773, 1, 0, 0, 0, 0, '', 'Show gossip menu 12195 option id 5 if player has reached 1 on skill Inscription.'), +(15, 12195, 6, 0, 0, 7, 0, 755, 1, 0, 0, 0, 0, '', 'Show gossip menu 12195 option id 6 if player has reached 1 on skill Jewelcrafting.'), +(15, 12195, 7, 0, 0, 7, 0, 165, 1, 0, 0, 0, 0, '', 'Show gossip menu 12195 option id 7 if player has reached 1 on skill Leatherworking.'), +(15, 12195, 8, 0, 0, 7, 0, 186, 1, 0, 0, 0, 0, '', 'Show gossip menu 12195 option id 8 if player has reached 1 on skill Mining.'), +(15, 12195, 9, 0, 0, 7, 0, 393, 1, 0, 0, 0, 0, '', 'Show gossip menu 12195 option id 9 if player has reached 1 on skill Skinning.'), +(15, 12195, 10, 0, 0, 7, 0, 197, 1, 0, 0, 0, 0, '', 'Show gossip menu 12195 option id 10 if player has reached 1 on skill Tailoring.'), +(15, 12195, 11, 0, 0, 7, 0, 202, 1, 0, 1, 0, 0, '', 'Do not show gossip menu 12195 option id 11 if player has reached 1 on skill Engineering.'); + +-- Condition for source Gossip menu option condition type Skill Inscription +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12196 AND `SourceEntry` BETWEEN 0 AND 11; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 12196, 0, 0, 0, 7, 0, 171, 1, 0, 0, 0, 0, '', 'Show gossip menu 12196 option id 0 if player has reached 1 on skill Alchemy.'), +(15, 12196, 1, 0, 0, 7, 0, 164, 1, 0, 0, 0, 0, '', 'Show gossip menu 12196 option id 1 if player has reached 1 on skill Blacksmithing.'), +(15, 12196, 2, 0, 0, 7, 0, 333, 1, 0, 0, 0, 0, '', 'Show gossip menu 12196 option id 2 if player has reached 1 on skill Enchanting.'), +(15, 12196, 3, 0, 0, 7, 0, 202, 1, 0, 0, 0, 0, '', 'Show gossip menu 12196 option id 3 if player has reached 1 on skill Engineering.'), +(15, 12196, 4, 0, 0, 7, 0, 182, 1, 0, 0, 0, 0, '', 'Show gossip menu 12196 option id 4 if player has reached 1 on skill Herbalism.'), +(15, 12196, 5, 0, 0, 7, 0, 773, 1, 0, 0, 0, 0, '', 'Show gossip menu 12196 option id 5 if player has reached 1 on skill Inscription.'), +(15, 12196, 6, 0, 0, 7, 0, 755, 1, 0, 0, 0, 0, '', 'Show gossip menu 12196 option id 6 if player has reached 1 on skill Jewelcrafting.'), +(15, 12196, 7, 0, 0, 7, 0, 165, 1, 0, 0, 0, 0, '', 'Show gossip menu 12196 option id 7 if player has reached 1 on skill Leatherworking.'), +(15, 12196, 8, 0, 0, 7, 0, 186, 1, 0, 0, 0, 0, '', 'Show gossip menu 12196 option id 8 if player has reached 1 on skill Mining.'), +(15, 12196, 9, 0, 0, 7, 0, 393, 1, 0, 0, 0, 0, '', 'Show gossip menu 12196 option id 9 if player has reached 1 on skill Skinning.'), +(15, 12196, 10, 0, 0, 7, 0, 197, 1, 0, 0, 0, 0, '', 'Show gossip menu 12196 option id 10 if player has reached 1 on skill Tailoring.'), +(15, 12196, 11, 0, 0, 7, 0, 773, 1, 0, 1, 0, 0, '', 'Do not show gossip menu 12196 option id 11 if player has reached 1 on skill Inscription.'); + +-- Condition for source Gossip menu option condition type Skill Jewelcrafting +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12197 AND `SourceEntry` BETWEEN 0 AND 11; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 12197, 0, 0, 0, 7, 0, 171, 1, 0, 0, 0, 0, '', 'Show gossip menu 12197 option id 0 if player has reached 1 on skill Alchemy.'), +(15, 12197, 1, 0, 0, 7, 0, 164, 1, 0, 0, 0, 0, '', 'Show gossip menu 12197 option id 1 if player has reached 1 on skill Blacksmithing.'), +(15, 12197, 2, 0, 0, 7, 0, 333, 1, 0, 0, 0, 0, '', 'Show gossip menu 12197 option id 2 if player has reached 1 on skill Enchanting.'), +(15, 12197, 3, 0, 0, 7, 0, 202, 1, 0, 0, 0, 0, '', 'Show gossip menu 12197 option id 3 if player has reached 1 on skill Engineering.'), +(15, 12197, 4, 0, 0, 7, 0, 182, 1, 0, 0, 0, 0, '', 'Show gossip menu 12197 option id 4 if player has reached 1 on skill Herbalism.'), +(15, 12197, 5, 0, 0, 7, 0, 773, 1, 0, 0, 0, 0, '', 'Show gossip menu 12197 option id 5 if player has reached 1 on skill Inscription.'), +(15, 12197, 6, 0, 0, 7, 0, 755, 1, 0, 0, 0, 0, '', 'Show gossip menu 12197 option id 6 if player has reached 1 on skill Jewelcrafting.'), +(15, 12197, 7, 0, 0, 7, 0, 165, 1, 0, 0, 0, 0, '', 'Show gossip menu 12197 option id 7 if player has reached 1 on skill Leatherworking.'), +(15, 12197, 8, 0, 0, 7, 0, 186, 1, 0, 0, 0, 0, '', 'Show gossip menu 12197 option id 8 if player has reached 1 on skill Mining.'), +(15, 12197, 9, 0, 0, 7, 0, 393, 1, 0, 0, 0, 0, '', 'Show gossip menu 12197 option id 9 if player has reached 1 on skill Skinning.'), +(15, 12197, 10, 0, 0, 7, 0, 197, 1, 0, 0, 0, 0, '', 'Show gossip menu 12197 option id 10 if player has reached 1 on skill Tailoring.'), +(15, 12197, 11, 0, 0, 7, 0, 755, 1, 0, 1, 0, 0, '', 'Do not show gossip menu 12197 option id 11 if player has reached 1 on skill Jewelcrafting.'); + +-- Condition for source Gossip menu option condition type Skill Leatherworking +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12198 AND `SourceEntry` BETWEEN 0 AND 11; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 12198, 0, 0, 0, 7, 0, 171, 1, 0, 0, 0, 0, '', 'Show gossip menu 12198 option id 0 if player has reached 1 on skill Alchemy.'), +(15, 12198, 1, 0, 0, 7, 0, 164, 1, 0, 0, 0, 0, '', 'Show gossip menu 12198 option id 1 if player has reached 1 on skill Blacksmithing.'), +(15, 12198, 2, 0, 0, 7, 0, 333, 1, 0, 0, 0, 0, '', 'Show gossip menu 12198 option id 2 if player has reached 1 on skill Enchanting.'), +(15, 12198, 3, 0, 0, 7, 0, 202, 1, 0, 0, 0, 0, '', 'Show gossip menu 12198 option id 3 if player has reached 1 on skill Engineering.'), +(15, 12198, 4, 0, 0, 7, 0, 182, 1, 0, 0, 0, 0, '', 'Show gossip menu 12198 option id 4 if player has reached 1 on skill Herbalism.'), +(15, 12198, 5, 0, 0, 7, 0, 773, 1, 0, 0, 0, 0, '', 'Show gossip menu 12198 option id 5 if player has reached 1 on skill Inscription.'), +(15, 12198, 6, 0, 0, 7, 0, 755, 1, 0, 0, 0, 0, '', 'Show gossip menu 12198 option id 6 if player has reached 1 on skill Jewelcrafting.'), +(15, 12198, 7, 0, 0, 7, 0, 165, 1, 0, 0, 0, 0, '', 'Show gossip menu 12198 option id 7 if player has reached 1 on skill Leatherworking.'), +(15, 12198, 8, 0, 0, 7, 0, 186, 1, 0, 0, 0, 0, '', 'Show gossip menu 12198 option id 8 if player has reached 1 on skill Mining.'), +(15, 12198, 9, 0, 0, 7, 0, 393, 1, 0, 0, 0, 0, '', 'Show gossip menu 12198 option id 9 if player has reached 1 on skill Skinning.'), +(15, 12198, 10, 0, 0, 7, 0, 197, 1, 0, 0, 0, 0, '', 'Show gossip menu 12198 option id 10 if player has reached 1 on skill Tailoring.'), +(15, 12198, 11, 0, 0, 7, 0, 165, 1, 0, 1, 0, 0, '', 'Do not show gossip menu 12198 option id 11 if player has reached 1 on skill Leatherworking.'); + +-- Condition for source Gossip menu option condition type Skill Tailoring +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=12199 AND `SourceEntry` BETWEEN 0 AND 11; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 12199, 0, 0, 0, 7, 0, 171, 1, 0, 0, 0, 0, '', 'Show gossip menu 12199 option id 0 if player has reached 1 on skill Alchemy.'), +(15, 12199, 1, 0, 0, 7, 0, 164, 1, 0, 0, 0, 0, '', 'Show gossip menu 12199 option id 1 if player has reached 1 on skill Blacksmithing.'), +(15, 12199, 2, 0, 0, 7, 0, 333, 1, 0, 0, 0, 0, '', 'Show gossip menu 12199 option id 2 if player has reached 1 on skill Enchanting.'), +(15, 12199, 3, 0, 0, 7, 0, 202, 1, 0, 0, 0, 0, '', 'Show gossip menu 12199 option id 3 if player has reached 1 on skill Engineering.'), +(15, 12199, 4, 0, 0, 7, 0, 182, 1, 0, 0, 0, 0, '', 'Show gossip menu 12199 option id 4 if player has reached 1 on skill Herbalism.'), +(15, 12199, 5, 0, 0, 7, 0, 773, 1, 0, 0, 0, 0, '', 'Show gossip menu 12199 option id 5 if player has reached 1 on skill Inscription.'), +(15, 12199, 6, 0, 0, 7, 0, 755, 1, 0, 0, 0, 0, '', 'Show gossip menu 12199 option id 6 if player has reached 1 on skill Jewelcrafting.'), +(15, 12199, 7, 0, 0, 7, 0, 165, 1, 0, 0, 0, 0, '', 'Show gossip menu 12199 option id 7 if player has reached 1 on skill Leatherworking.'), +(15, 12199, 8, 0, 0, 7, 0, 186, 1, 0, 0, 0, 0, '', 'Show gossip menu 12199 option id 8 if player has reached 1 on skill Mining.'), +(15, 12199, 9, 0, 0, 7, 0, 393, 1, 0, 0, 0, 0, '', 'Show gossip menu 12199 option id 9 if player has reached 1 on skill Skinning.'), +(15, 12199, 10, 0, 0, 7, 0, 197, 1, 0, 0, 0, 0, '', 'Show gossip menu 12199 option id 10 if player has reached 1 on skill Tailoring.'), +(15, 12199, 11, 0, 0, 7, 0, 197, 1, 0, 1, 0, 0, '', 'Do not show gossip menu 12199 option id 11 if player has reached 1 on skill Tailoring.'); |