کد:
-- Buffer SQL for trinitycore. By Lea
-- Edited by Lea
-- Creature entry added by Lea
-- Setting values
SET @BUFFNPC := 909090; -- # (Entry ID of the NPC)
SET @GOPTION := 50031; -- # (1 unused needed from gossip_menu_option)
-- Deleting exsisting menus and scripts from the NPC and the NPC
-- (can be commented out with /* asd */ or -- asd if you need to)
DELETE FROM gossip_menu_option WHERE menu_id = @GOPTION;
DELETE FROM smart_scripts WHERE entryorguid = @BUFFNPC;
DELETE FROM creature_template WHERE entry = @BUFFNPC;
-- Creating the NPC
INSERT INTO creature_template (entry, modelid1, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, Health_mod, Mana_mod, Armor_mod, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, dmg_multiplier, unit_class, unit_flags, type, type_flags, InhabitType, RegenHealth, flags_extra, AiName) VALUES
(@BUFFNPC, '22312', "Mounts Master", "Mounts Master", 'Directions', '50000', 71, 71, 1.56, 1.56, 1.56, 35, 35, 3, 1, 1.14286, 1.25, 1, 1, 1, 2, 7, 138936390, 3, 1, 2, 'SmartAI');
-- Making menus
-- Automatic ID incase of delete code removed
SET @GID := IFNULL((SELECT id FROM gossip_menu_option WHERE menu_id = @GOPTION ORDER BY id DESC LIMIT 1), 0)+1;
INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, box_coded, box_money, box_text) VALUES
(@GOPTION, @GID, 2, 'Ro In Klick Koni Mount Master Toro Savar Wolf Mikone', 1, 1, @GOPTION, 0, 0, 0, NULL),
(@GOPTION, @GID+1, 2, 'Ro In Klick Koni MountMaster Toro Savar Kargadan Mikone', 1, 1, @GOPTION, 0, 0, 0, NULL),
(@GOPTION, @GID+2, 2, 'Ro In Klick Koni MountMaster Toro Savar Goorekhar Mikone', 1, 1, @GOPTION, 0, 0, 0, NULL),
(@GOPTION, @GID+3, 2, 'Ro In Klick Koni MountMaster Toro Savar Laklak Mikone', 1, 1, @GOPTION, 0, 0, 0, NULL),
(@GOPTION, @GID+4, 2, 'Ro In Klick Koni MountMaster Toro Savar Daeinasor Mikone', 1, 1, @GOPTION, 0, 0, 0, NULL),
(@GOPTION, @GID+5, 2, 'Ro In Klick Koni MountMaster Toro Savar Babr Mikone', 1, 1, @GOPTION, 0, 0, 0, NULL),
(@GOPTION, @GID+6, 2, 'Ro In Klick Koni MountMaster Toro Savar Kalagh Mikone', 1, 1, @GOPTION, 0, 0, 0, NULL),
(@GOPTION, @GID+7, 2, 'Ro In Klick Koni MountMaster Toro Savar Goosfand Mikone:D', 1, 1, @GOPTION, 0, 0, 0, NULL),
(@GOPTION, @GID+8, 2, 'Ro In Klick Koni MountMaster Toro Savar Fill Mikone', 1, 1, @GOPTION, 0, 0, 0, NULL),
(@GOPTION, @GID+9, 2, 'Ro In Klick Koni MountMaster Toro Savar Honda 125 Mikone', 1, 1, @GOPTION, 0, 0, 0, NULL);
-- Making the scripts for the NPC that make the player cast the buff on himself (with no manacost)
-- Automatic ID incase of delete code removed
SET @SID := IFNULL((SELECT id FROM smart_scripts WHERE entryorguid = @BUFFNPC ORDER BY id DESC LIMIT 1), 0)+1;
INSERT INTO `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
(@BUFFNPC, 0, @SID, 0, 62, 0, 100, 0, @GOPTION, @GID, 0, 0, 85, 22724, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(@BUFFNPC, 0, @SID+1, 0, 62, 0, 100, 0, @GOPTION, @GID+1, 0, 0, 85, 23248, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(@BUFFNPC, 0, @SID+2, 0, 62, 0, 100, 0, @GOPTION, @GID+2, 0, 0, 85, 49322, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(@BUFFNPC, 0, @SID+3, 0, 62, 0, 100, 0, @GOPTION, @GID+3, 0, 0, 85, 65639, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(@BUFFNPC, 0, @SID+4, 0, 62, 0, 100, 0, @GOPTION, @GID+4, 0, 0, 85, 63635, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(@BUFFNPC, 0, @SID+5, 0, 62, 0, 100, 0, @GOPTION, @GID+5, 0, 0, 85, 24252, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(@BUFFNPC, 0, @SID+6, 0, 62, 0, 100, 0, @GOPTION, @GID+6, 0, 0, 85, 41252, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(@BUFFNPC, 0, @SID+7, 0, 62, 0, 100, 0, @GOPTION, @GID+7, 0, 0, 85, 43900, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(@BUFFNPC, 0, @SID+8, 0, 62, 0, 100, 0, @GOPTION, @GID+8, 0, 0, 85, 59793, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(@BUFFNPC, 0, @SID+9, 0, 62, 0, 100, 0, @GOPTION, @GID+9, 0, 0, 85, 55531, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
-- Update our NPC to have gossip, have our gossip menu and use smart_scripts
-- running this last, so if other queries fail (disabled delete statement?),
-- the creature wont be updated to have an invalid menu
UPDATE creature_template SET gossip_menu_id = @GOPTION, npcflag = npcflag|1, AIName = 'SmartAI' WHERE Entry = @BUFFNPC;
-- If there were no errors, we are ready.
-- You may want to add a gossip_menu row if you want a headline text.
-- Dont forget to restart after running this SQL and/or adding the headline text.
Entry Npc : 909090
