SET @ENTRY := 100240;
SET @GOSSIP := 65043;
SET @MODEL := 23937;
SET @NPCFLAG := 17;

DELETE FROM `creature_template` WHERE entry = @ENTRY;
DELETE FROM `npc_text` WHERE ID = @GOSSIP;
DELETE FROM `gossip_menu` WHERE entry = @GOSSIP;
DELETE FROM `gossip_menu_option` WHERE menu_id = @GOSSIP;
DELETE FROM `npc_trainer` WHERE (ID >= @ENTRY AND ID <= @ENTRY+13);

INSERT INTO `creature_template` VALUES (@ENTRY, 0, 0, 0, 0, 0, @MODEL, 0, 0, 0, "Jim", "Учитель", null, @GOSSIP, 80, 80, 0, 35, @NPCFLAG, 1, 1.14286, 1, 0, 0, 2000, 2000, 1, 1, 1, 0, 2048, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 0, 3, 1, 5, 1, 1, 1, 1, 0, 0, 1, 0, 0, "", 12340);

INSERT INTO `npc_text` VALUES (@GOSSIP, "", "Здравствуйте, $n.", 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO `gossip_menu` (entry, text_id) VALUES (@GOSSIP, @GOSSIP);

INSERT INTO `gossip_menu_option` VALUES
(@GOSSIP, 0, 3, "|TInterface/ICONS/Trade_alchemy:20|t Алхимия", 0, 5, @NPCFLAG-1, @ENTRY, 0, 0, 0, "", 0),
(@GOSSIP, 1, 3, "|TInterface/ICONS/Trade_blacksmithing:20|t Кузнечное дело", 0, 5, @NPCFLAG-1, @ENTRY+1, 0, 0, 0, "", 0),
(@GOSSIP, 2, 3, "|TInterface/ICONS/Trade_engineering:20|t Инженерное дело", 0, 5, @NPCFLAG-1, @ENTRY+2, 0, 0, 0, "", 0),
(@GOSSIP, 3, 3, "|TInterface/ICONS/Trade_tailoring:20|t Портняжное дело", 0, 5, @NPCFLAG-1, @ENTRY+3, 0, 0, 0, "", 0),
(@GOSSIP, 4, 3, "|TInterface/ICONS/Inv_misc_gem_02:20|t Ювелирное дело", 0, 5, @NPCFLAG-1, @ENTRY+4, 0, 0, 0, "", 0),
(@GOSSIP, 5, 3, "|TInterface/ICONS/Trade_engraving:20|t Наложение чар", 0, 5, @NPCFLAG-1, @ENTRY+5, 0, 0, 0, "", 0),
(@GOSSIP, 6, 3, "|TInterface/ICONS/Inv_inscription_tradeskill01:20|t Начертание", 0, 5, @NPCFLAG-1, @ENTRY+6, 0, 0, 0, "", 0),
(@GOSSIP, 7, 3, "|TInterface/ICONS/Inv_misc_armorkit_17:20|t Кожевничество", 0, 5, @NPCFLAG-1, @ENTRY+7, 0, 0, 0, "", 0),
(@GOSSIP, 8, 3, "|TInterface/ICONS/Inv_misc_food_15:20|t Кулинария", 0, 5, @NPCFLAG-1, @ENTRY+8, 0, 0, 0, "", 0),
(@GOSSIP, 9, 3, "|TInterface/ICONS/Spell_holy_sealofsacrifice:20|t Первая помощь", 0, 5, @NPCFLAG-1, @ENTRY+9, 0, 0, 0, "", 0),
(@GOSSIP, 10, 3, "|TInterface/ICONS/Trade_herbalism:20|t Травничество", 0, 5, @NPCFLAG-1, @ENTRY+10, 0, 0, 0, "", 0),
(@GOSSIP, 11, 3, "|TInterface/ICONS/Trade_leatherworking:20|t Снятие шкур", 0, 5, @NPCFLAG-1, @ENTRY+11, 0, 0, 0, "", 0),
(@GOSSIP, 12, 3, "|TInterface/ICONS/Trade_mining:20|t Горное дело", 0, 5, @NPCFLAG-1, @ENTRY+12, 0, 0, 0, "", 0),
(@GOSSIP, 13, 3, "|TInterface/ICONS/Trade_fishing:20|t Рыбная ловля", 0, 5, @NPCFLAG-1, @ENTRY+13, 0, 0, 0, "", 0);

INSERT INTO `npc_trainer` VALUES
(@ENTRY, -201001, 0, 0, 0, 0),
(@ENTRY, -201002, 0, 0, 0, 0),
(@ENTRY, -201003, 0, 0, 0, 0),
(@ENTRY+1, -201004, 0, 0, 0, 0),
(@ENTRY+1, -201005, 0, 0, 0, 0),
(@ENTRY+1, -201006, 0, 0, 0, 0),
(@ENTRY+2, -201012, 0, 0, 0, 0),
(@ENTRY+2, -201013, 0, 0, 0, 0),
(@ENTRY+2, -201014, 0, 0, 0, 0),
(@ENTRY+3, -201039, 0, 0, 0, 0),
(@ENTRY+3, -201040, 0, 0, 0, 0),
(@ENTRY+3, -201041, 0, 0, 0, 0),
(@ENTRY+4, -201024, 0, 0, 0, 0),
(@ENTRY+4, -201025, 0, 0, 0, 0),
(@ENTRY+4, -201026, 0, 0, 0, 0),
(@ENTRY+5, -201009, 0, 0, 0, 0),
(@ENTRY+5, -201010, 0, 0, 0, 0),
(@ENTRY+5, -201011, 0, 0, 0, 0),
(@ENTRY+6, -201021, 0, 0, 0, 0),
(@ENTRY+6, -201022, 0, 0, 0, 0),
(@ENTRY+6, -201023, 0, 0, 0, 0),
(@ENTRY+7, -201029, 0, 0, 0, 0),
(@ENTRY+8, -202004, 0, 0, 0, 0),
(@ENTRY+8, -202005, 0, 0, 0, 0),
(@ENTRY+8, -202006, 0, 0, 0, 0),
(@ENTRY+9, -202007, 0, 0, 0, 0),
(@ENTRY+9, -202008, 0, 0, 0, 0),
(@ENTRY+9, -202009, 0, 0, 0, 0),
(@ENTRY+10, -201018, 0, 0, 0, 0),
(@ENTRY+10, -201019, 0, 0, 0, 0),
(@ENTRY+10, -201020, 0, 0, 0, 0),
(@ENTRY+11, -201036, 0, 0, 0, 0),
(@ENTRY+11, -201037, 0, 0, 0, 0),
(@ENTRY+11, -201038, 0, 0, 0, 0),
(@ENTRY+12, -201033, 0, 0, 0, 0),
(@ENTRY+12, -201034, 0, 0, 0, 0),
(@ENTRY+12, -201035, 0, 0, 0, 0),
(@ENTRY+13, -202001, 0, 0, 0, 0),
(@ENTRY+13, -202002, 0, 0, 0, 0),
(@ENTRY+13, -202003, 0, 0, 0, 0);