mirror of
https://github.com/araxiaonline/AzerothCore-Converted-Modules-to-latest-TrinityCore.git
synced 2026-06-13 09:32:20 -04:00
36 lines
1.4 KiB
SQL
36 lines
1.4 KiB
SQL
USE world;
|
|
|
|
-- ######################################################--
|
|
-- ENCHANTER - 601015
|
|
-- ######################################################--
|
|
SET
|
|
@Entry := 190012,
|
|
@Model := 9353, -- Undead Necromancer
|
|
@Name := "Beauregard Boneglitter",
|
|
@Title := "Enchantments",
|
|
@Icon := "Speak",
|
|
@GossipMenu := 0,
|
|
@MinLevel := 80,
|
|
@MaxLevel := 80,
|
|
@Faction := 35,
|
|
@NPCFlag := 1,
|
|
@Scale := 1.0,
|
|
@Rank := 0,
|
|
@Type := 7,
|
|
@TypeFlags := 0,
|
|
@FlagsExtra := 2,
|
|
@AIName := "SmartAI",
|
|
@Script := "npc_enchantment";
|
|
|
|
-- NPC
|
|
DELETE FROM creature_template WHERE entry = @Entry;
|
|
INSERT INTO creature_template (entry, modelid1, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, faction, npcflag, speed_walk, speed_run, scale, rank, unit_class, unit_flags, type, type_flags, RegenHealth, flags_extra, AiName, ScriptName) VALUES
|
|
(@Entry, @Model, @Name, @Title, @Icon, @GossipMenu, @MinLevel, @MaxLevel, @Faction, @NPCFlag, 1, 1.14286, @Scale, @Rank, 1, 2, @Type, @TypeFlags, 1, @FlagsExtra, @AIName, @Script);
|
|
|
|
-- NPC EQUIPPED
|
|
DELETE FROM `creature_equip_template` WHERE `CreatureID`=@Entry AND `ID`=1;
|
|
INSERT INTO `creature_equip_template` VALUES (@Entry, 1, 11343, 0, 0, 18019); -- Black/Purple Staff, None
|
|
|
|
-- NPC TEXT
|
|
DELETE FROM `npc_text` WHERE `ID`=@Entry;
|
|
INSERT INTO `npc_text` (`ID`, `text0_0`) VALUES (@Entry, 'Good day $N. Beauregard Boneglitter at your service. I offer a vast array of gear enchantments for the aspiring adventurer.'); |