mirror of
https://github.com/araxiaonline/AzerothCore-Converted-Modules-to-latest-TrinityCore.git
synced 2026-06-13 01:22:21 -04:00
104 lines
4.1 KiB
SQL
104 lines
4.1 KiB
SQL
USE world;
|
|
|
|
-- ######################################################--
|
|
-- BEASTMASTER - 601026
|
|
-- ######################################################--
|
|
SET
|
|
@Entry := 190014,
|
|
@Model := 729, -- Shadowfang Moonwalker (White Worgen)
|
|
@Name := "White Fang",
|
|
@Title := "BeastMaster",
|
|
@Icon := "Speak",
|
|
@GossipMenu := 0,
|
|
@MinLevel := 80,
|
|
@MaxLevel := 80,
|
|
@Faction := 35,
|
|
@NPCFlag := 4194433,
|
|
@Scale := 1.0,
|
|
@Rank := 0,
|
|
@Type := 7,
|
|
@TypeFlags := 0,
|
|
@FlagsExtra := 2,
|
|
@AIName := "SmartAI",
|
|
@Script := "BeastMaster";
|
|
|
|
-- 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, 2196, 1906, 0, 18019); -- Haunch of Meat, Torch
|
|
|
|
-- NPC TEXT
|
|
DELETE FROM `npc_text` WHERE `ID`=@Entry;
|
|
INSERT INTO `npc_text` (`ID`, `text0_0`) VALUES (@Entry, 'Greetings $N. And when, on the still cold nights, he pointed his nose at a star and howled long and wolflike, it was his ancestors, dead and dust, pointing nose at star and howling down through the centuries and through him.');
|
|
|
|
-- NPC ITEMS
|
|
DELETE FROM npc_vendor WHERE entry = @Entry;
|
|
INSERT INTO npc_vendor (entry, item) VALUES
|
|
-- MEAT
|
|
(@Entry,35953), -- (75) -- Mead Blasted Caribou
|
|
(@Entry,33454), -- (65) -- Salted Venison
|
|
(@Entry,27854), -- (55) -- Smoked Talbuk Venison
|
|
(@Entry,8952), -- (45) -- Roasted Quail
|
|
(@Entry,4599), -- (35) -- Cured Ham Steak
|
|
(@Entry,3771), -- (25) -- Wild Hog Shank
|
|
(@Entry,3770), -- (15) -- Mutton Chop
|
|
(@Entry,2287), -- (5) -- Haunch of Meat
|
|
(@Entry,117), -- (1) -- Tough Jerky
|
|
-- FUNGUS
|
|
(@Entry,35947), -- (75) -- Sparkling Frostcap
|
|
(@Entry,33452), -- (65) -- Honey-Spiced Lichen
|
|
(@Entry,27859), -- (55) -- Zangar Caps
|
|
(@Entry,8948), -- (45) -- Dried King Bolete
|
|
(@Entry,4608), -- (35) -- Raw Black Truffle
|
|
(@Entry,4607), -- (25) -- Delicious Cave Mold
|
|
(@Entry,4606), -- (15) -- Spongy Morel
|
|
(@Entry,4605), -- (5) -- Red-Speckled Mushroom
|
|
(@Entry,4604), -- (1) -- Forest Mushroom Cap
|
|
-- BREAD
|
|
(@Entry,35950), -- (75) -- Sweet Potato Bread
|
|
(@Entry,33449), -- (65) -- Crusty Flatbread
|
|
(@Entry,27855), -- (55) -- Mag'har Grainbread
|
|
(@Entry,8950), -- (45) -- Homemade Cherry Pie
|
|
(@Entry,4601), -- (35) -- Soft Banana Bread
|
|
(@Entry,4544), -- (25) -- Mulgore Spice Bread
|
|
(@Entry,4542), -- (15) -- Moist Cornbread
|
|
(@Entry,4541), -- (5) -- Freshly Baked Bread
|
|
(@Entry,4540), -- (1) -- Tough Hunk of Bread
|
|
-- FRUIT
|
|
(@Entry,35948), -- (75) -- Savory Snowplum
|
|
(@Entry,35949), -- (65) -- Tundra Berries
|
|
(@Entry,27856), -- (55) -- Sklethyl Berries
|
|
(@Entry,8953), -- (45) -- Deep Fried Plantains
|
|
(@Entry,4602), -- (35) -- Moon Harvest Pumpkin
|
|
(@Entry,4539), -- (25) -- Goldenbark Apple
|
|
(@Entry,4538), -- (15) -- Snapvine Watermelon
|
|
(@Entry,4537), -- (5) -- Tel'Abim Banana
|
|
(@Entry,4536), -- (1) -- Shiny Red Apple
|
|
-- FISH
|
|
(@Entry,35951), -- (75) -- Poached Emperor Salmon
|
|
(@Entry,33451), -- (65) -- Filet of Icefin
|
|
(@Entry,27858), -- (55) -- Sunspring Carp
|
|
(@Entry,8957), -- (45) -- Spinefin Halibut
|
|
(@Entry,21552), -- (35) -- Striped Yellowtail
|
|
(@Entry,4594), -- (25) -- Rockscale Cod
|
|
(@Entry,4593), -- (15) -- Bristle Whisker Catfish
|
|
(@Entry,4592), -- (5) -- Longjaw Mud Snapper
|
|
(@Entry,787), -- (1) -- Slitherskin Mackeral
|
|
-- CHEESE
|
|
(@Entry,35952), -- (75) -- Briny Hardcheese
|
|
(@Entry,33443), -- (65) -- Sour Goat Cheese
|
|
(@Entry,27857), -- (55) -- Gradar Sharp
|
|
(@Entry,8932), -- (45) -- Alterac Swiss
|
|
(@Entry,3927), -- (35) -- Fine Aged Chedder
|
|
(@Entry,1707), -- (25) -- Stormwind Brie
|
|
(@Entry,422), -- (15) -- Dwarven Mild
|
|
(@Entry,414), -- (5) -- Dalaran Sharp
|
|
(@Entry,2070), -- (1) -- Darnassian Bleu
|
|
-- BUFF
|
|
(@Entry,33875), -- Kibler's Bits
|
|
-- RARE
|
|
(@Entry,21024); -- Chimaerok Tenderloin |