Files
Maximilian Unsinn acade408ee Initial Release
2021-04-07 20:04:32 +02:00

28 lines
1.0 KiB
SQL

USE world;
-- ######################################################--
-- ALL MOUNTS VENDOR - 601014
-- ######################################################--
SET
@Entry := 190013,
@Model := 26571, -- Large Black Knight, 21249 (Armored Orc)
@Name := "The Mountain",
@Title := "Mount Trainer",
@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 := "AllMountsNPC";
-- 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);