-
-
Save marioaparcero/7371b2dbc785db053c2b5ca8d4441807 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
USE world3; | |
-- 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 menu_id = @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 world3.creature_template (`entry`, `modelid1`, `name`, `subname`, `minlevel`, `maxlevel`, `faction`, `npcflag`, `rank`, `AIName`, `gossip_menu_id`) VALUES | |
(@NpcEntry, @NpcDisplayID, @NpcName, @NpcSubName, 80, 80, 35, 1, 4, 'SmartAI', @GossipOptionID); | |
-- gossip_menu_option - gossip menus | |
SET @GID := IFNULL((SELECT option_id FROM world3.gossip_menu_option WHERE menu_id = @GossipOptionID ORDER BY option_id DESC LIMIT 1), 0)+1; | |
INSERT INTO world3.gossip_menu_option (`menu_id`, `option_id`, `option_icon`, `option_text`, `action_menu_id`) 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 world3.smart_scripts WHERE entryorguid = @NpcEntry ORDER BY id DESC LIMIT 1), 0)+1; | |
INSERT INTO world3.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'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
First off, if you change the database name, you should change it everywhere. Use n++ and press ctrl+h and replace them all.
Second, I see you're using an older version of TC world database, or an outdated one. Only gossip_menu_option is messed up on your side.
Here's the gossip_menu_option you need https://paste2.org/NJk9AGOB
I noticed one more thing. If you added "USE world3;" there's no need to add world3.creature_template, world3.gossip_menu_option, world3.smart_scripts.
Just write tables without world3.