morpher.sql

-- Here you can set NPC entry, name, subname, gossip_menu_id, displayID
SET @NpcEntry := 180009;
SET @NpcName := 'Morpher';
SET @NpcSubName := '';
SET @NpcDisplayID := 30883;
SET @GossipOptionID := 50090;
SET @GOSSIP_ICON_DOT := 10; -- Yellow Dot

-- If @NpcEntry, @GossipOptionID already exists in your database, delete those entries
DELETE FROM world.gossip_menu_option WHERE MenuID = @GossipOptionID;
DELETE FROM world.conditions WHERE SourceGroup = @GossipOptionID;
DELETE FROM world.smart_scripts WHERE entryorguid = @NpcEntry;
DELETE FROM world.creature_template WHERE entry = @NpcEntry;

-- Creature Template - The Actual NPC
INSERT INTO world.creature_template (`entry`, `modelid1`, `name`, `subname`, `minlevel`, `maxlevel`, `faction`, `npcflag`, `rank`, `AIName`, `gossip_MenuID`) VALUES 
(@NpcEntry, @NpcDisplayID, @NpcName, @NpcSubName, 80, 80, 35, 1, 4, 'SmartAI', @GossipOptionID);

-- gossip_menu_option - gossip menus
SET @GID := IFNULL((SELECT OptionID FROM world.gossip_menu_option WHERE MenuID = @GossipOptionID ORDER BY OptionID DESC LIMIT 1), 0)+1;
INSERT INTO world.gossip_menu_option (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `ActionMenuID`) VALUES
(@GossipOptionID, @GID,   @GOSSIP_ICON_DOT, 'Tauren Male', @GossipOptionID), 
(@GossipOptionID, @GID+1, @GOSSIP_ICON_DOT, 'Tauren Female', @GossipOptionID), 
(@GossipOptionID, @GID+2, @GOSSIP_ICON_DOT, 'Gnome Male', @GossipOptionID), 
(@GossipOptionID, @GID+3, @GOSSIP_ICON_DOT, 'Gnome Female', @GossipOptionID),
(@GossipOptionID, @GID+4, @GOSSIP_ICON_DOT, 'Human Male', @GossipOptionID),
(@GossipOptionID, @GID+5, @GOSSIP_ICON_DOT, 'Human Female', @GossipOptionID),
(@GossipOptionID, @GID+6, @GOSSIP_ICON_DOT, 'Blood Elf Male', @GossipOptionID),
(@GossipOptionID, @GID+7, @GOSSIP_ICON_DOT, 'Blood Elf Female', @GossipOptionID),
(@GossipOptionID, @GID+8, @GOSSIP_ICON_DOT, 'Green Slime', @GossipOptionID),
(@GossipOptionID, @GID+9, @GOSSIP_ICON_DOT, 'Succubus', @GossipOptionID),
(@GossipOptionID, @GID+10, @GOSSIP_ICON_DOT, 'Dreadlord', @GossipOptionID),
(@GossipOptionID, @GID+11, @GOSSIP_ICON_DOT, 'Piglet', @GossipOptionID),
(@GossipOptionID, @GID+12, @GOSSIP_ICON_DOT, 'Shade', @GossipOptionID),
(@GossipOptionID, @GID+13, @GOSSIP_ICON_DOT, 'Dreaming Whelp', @GossipOptionID),
(@GossipOptionID, @GID+14, @GOSSIP_ICON_DOT, 'FelGuard', @GossipOptionID),
(@GossipOptionID, @GID+15, @GOSSIP_ICON_DOT, 'DeathKnight', @GossipOptionID),
(@GossipOptionID, @GID+16, @GOSSIP_ICON_DOT, 'Boar', @GossipOptionID),
(@GossipOptionID, @GID+17, @GOSSIP_ICON_DOT, 'Skeleton', @GossipOptionID),
(@GossipOptionID, @GID+18, @GOSSIP_ICON_DOT, 'Chicken', @GossipOptionID),
(@GossipOptionID, @GID+19, @GOSSIP_ICON_DOT, 'Ghoul', @GossipOptionID),
(@GossipOptionID, @GID+20, @GOSSIP_ICON_DOT, 'Trogg', @GossipOptionID),
(@GossipOptionID, @GID+21, @GOSSIP_ICON_DOT, 'Zombie', @GossipOptionID),
(@GossipOptionID, @GID+22, @GOSSIP_ICON_DOT, 'Male Assassin', @GossipOptionID),
(@GossipOptionID, @GID+23, @GOSSIP_ICON_DOT, 'Female Assassin', @GossipOptionID),
(@GossipOptionID, @GID+24, @GOSSIP_ICON_DOT, 'Male Pirate', @GossipOptionID),
(@GossipOptionID, @GID+25, @GOSSIP_ICON_DOT, 'Female Pirate', @GossipOptionID),
(@GossipOptionID, @GID+26, @GOSSIP_ICON_DOT, 'Peasant', @GossipOptionID),
(@GossipOptionID, @GID+27, @GOSSIP_ICON_DOT, 'Darkspear Warrior', @GossipOptionID),
(@GossipOptionID, @GID+28, @GOSSIP_ICON_DOT, 'Gnomeregan Infantry', @GossipOptionID),
(@GossipOptionID, @GID+29, @GOSSIP_ICON_DOT, 'Honor the Dead', @GossipOptionID),
(@GossipOptionID, @GID+30, @GOSSIP_ICON_DOT, 'Wolvar', @GossipOptionID),
(@GossipOptionID, @GID+31, @GOSSIP_ICON_DOT, 'Pygmy Oil', @GossipOptionID);

-- Smart Scripts - Cast spell when clicking on a gossip menu (e.g. 'Tauren Male' cast spell 23757)
SET @SID := IFNULL((SELECT id FROM world.smart_scripts WHERE entryorguid = @NpcEntry ORDER BY id DESC LIMIT 1), 0)+1;
INSERT INTO world.smart_scripts (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(@NpcEntry, 0, @SID,   0, 62, 0, 100, 0, @GossipOptionID, @GID,   0, 0, 85, 23757, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Tauren Male'),
(@NpcEntry, 0, @SID+1, 0, 62, 0, 100, 0, @GossipOptionID, @GID+1, 0, 0, 85, 37811, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Tauren Female'),
(@NpcEntry, 0, @SID+2, 0, 62, 0, 100, 0, @GossipOptionID, @GID+2, 0, 0, 85, 37808, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Gnome Male'),
(@NpcEntry, 0, @SID+3, 0, 62, 0, 100, 0, @GossipOptionID, @GID+3, 0, 0, 85, 37809, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Gnome Female'),
(@NpcEntry, 0, @SID+4, 0, 62, 0, 100, 0, @GossipOptionID, @GID+4, 0, 0, 85, 35466, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Human Male'),
(@NpcEntry, 0, @SID+5, 0, 62, 0, 100, 0, @GossipOptionID, @GID+5, 0, 0, 85, 37805, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Human Female'),
(@NpcEntry, 0, @SID+6, 0, 62, 0, 100, 0, @GossipOptionID, @GID+6, 0, 0, 85, 37807, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Blood Elf Male'),
(@NpcEntry, 0, @SID+7, 0, 62, 0, 100, 0, @GossipOptionID, @GID+7, 0, 0, 85, 37806, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Blood Elf Female'),
(@NpcEntry, 0, @SID+8, 0, 62, 0, 100, 0, @GossipOptionID, @GID+8, 0, 0, 85, 8299, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Green Slime'),
(@NpcEntry, 0, @SID+9, 0, 62, 0, 100, 0, @GossipOptionID, @GID+9, 0, 0, 85, 8315, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Succubus'),
(@NpcEntry, 0, @SID+10, 0, 62, 0, 100, 0, @GossipOptionID, @GID+10, 0, 0, 85, 8321, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Dreadlord'),
(@NpcEntry, 0, @SID+11, 0, 62, 0, 100, 0, @GossipOptionID, @GID+11, 0, 0, 85, 8324, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Piglet'),
(@NpcEntry, 0, @SID+12, 0, 62, 0, 100, 0, @GossipOptionID, @GID+12, 0, 0, 85, 8357, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Shade'),
(@NpcEntry, 0, @SID+13, 0, 62, 0, 100, 0, @GossipOptionID, @GID+13, 0, 0, 85, 8360, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Dreaming Whelp'),
(@NpcEntry, 0, @SID+14, 0, 62, 0, 100, 0, @GossipOptionID, @GID+14, 0, 0, 85, 8872, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'FelGuard'),
(@NpcEntry, 0, @SID+15, 0, 62, 0, 100, 0, @GossipOptionID, @GID+15, 0, 0, 85, 17400, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'DeathKnight'),
(@NpcEntry, 0, @SID+16, 0, 62, 0, 100, 0, @GossipOptionID, @GID+16, 0, 0, 85, 17533, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Boar'),
(@NpcEntry, 0, @SID+17, 0, 62, 0, 100, 0, @GossipOptionID, @GID+17, 0, 0, 85, 21751, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Skeleton'),
(@NpcEntry, 0, @SID+18, 0, 62, 0, 100, 0, @GossipOptionID, @GID+18, 0, 0, 85, 3245, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Chicken'),
(@NpcEntry, 0, @SID+19, 0, 62, 0, 100, 0, @GossipOptionID, @GID+19, 0, 0, 85, 3287, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Ghoul'),
(@NpcEntry, 0, @SID+20, 0, 62, 0, 100, 0, @GossipOptionID, @GID+20, 0, 0, 85, 5142, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Trogg'),
(@NpcEntry, 0, @SID+21, 0, 62, 0, 100, 0, @GossipOptionID, @GID+21, 0, 0, 85, 7293, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Zombie'),
(@NpcEntry, 0, @SID+22, 0, 62, 0, 100, 0, @GossipOptionID, @GID+22, 0, 0, 85, 8219, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Male Assassin'),
(@NpcEntry, 0, @SID+23, 0, 62, 0, 100, 0, @GossipOptionID, @GID+23, 0, 0, 85, 8220, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Female Assassin'),
(@NpcEntry, 0, @SID+24, 0, 62, 0, 100, 0, @GossipOptionID, @GID+24, 0, 0, 85, 8221, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Male Pirate'),
(@NpcEntry, 0, @SID+25, 0, 62, 0, 100, 0, @GossipOptionID, @GID+25, 0, 0, 85, 8222, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Female Pirate'),
(@NpcEntry, 0, @SID+26, 0, 62, 0, 100, 0, @GossipOptionID, @GID+26, 0, 0, 85, 18142, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Peasant'),
(@NpcEntry, 0, @SID+27, 0, 62, 0, 100, 0, @GossipOptionID, @GID+27, 0, 0, 85, 75532, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Darkspear Warrior'),
(@NpcEntry, 0, @SID+28, 0, 62, 0, 100, 0, @GossipOptionID, @GID+28, 0, 0, 85, 75531, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Gnomeregan Infantry'),
(@NpcEntry, 0, @SID+29, 0, 62, 0, 100, 0, @GossipOptionID, @GID+29, 0, 0, 85, 65386, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Honor the Dead'),
(@NpcEntry, 0, @SID+30, 0, 62, 0, 100, 0, @GossipOptionID, @GID+30, 0, 0, 85, 61340, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Wolvar'),
(@NpcEntry, 0, @SID+31, 0, 62, 0, 100, 0, @GossipOptionID, @GID+31, 0, 0, 85, 53806, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Pygmy Oil');

can help me? wowsyndicate.com/chat I'm admin.

https://gist.github.com/marioaparcero/7371b2dbc785db053c2b5ca8d4441807