-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathVendorTemplate.sql
45 lines (43 loc) · 2.63 KB
/
VendorTemplate.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
-- Vendor Template --
-- --------------------------------------------------------------------------------------- --
SET
@Entry := 500001,
@Model := 27216,
@Scale := 2,
@Name := "Vendor NPC",
@Title := "",
@Icon := "Buy", -- Directions, Gunner, vehicleCursor, Driver, Attack, Buy, Speak, Pickup, Interact, Trainer, Taxi, Repair, LootAll --
@Rank := 0, -- 0 Normal, 1:Elite, 2:Rare Elite, 3:Boss, 4:Rare --
@Type := 7, -- 0:None, 1:Beast, 2:Dragonkin, 3:Demon, 4:Elemental, 5:Giant, 6:Undead, 7:Humanoid, 8:Critter, 9:Mechanical --
@Flags := 128, -- 128: Normal vendor, 4224: Repair vendor
@Level := 80,
@Faction := 35;
-- Item List --
DELETE FROM npc_vendor WHERE `Entry` = @Entry;
INSERT INTO npc_vendor
-- ----------------------------------------------------------------------------------------
(Entry, Slot, ExtendedCost, Item) VALUES
-- ----------------------------------------------------------------------------------------
(@Entry, 1, 0, 33447), -- Runic Healing Potion --
(@Entry, 2, 0, 33448), -- Runic Mana Potion --
(@Entry, 3, 0, 40087), -- Powerful Rejuvenation Potion --
(@Entry, 4, 0, 40077), -- Crazy Alchemist's Potion --
(@Entry, 4, 0, 40081), -- Potion of Nightmares --
(@Entry, 4, 0, 40093), -- Indestructible Potion --
(@Entry, 4, 0, 40211), -- Potion of Speed --
(@Entry, 4, 0, 40212), -- Potion of Wild Magic --
(@Entry, 6, 0, 9172), -- Invisibility Potion --
(@Entry, 6, 0, 2459), -- Swiftness Potion --
(@Entry, 6, 0, 6372), -- Swim Speed Potion --
(@Entry, 6, 0, 7676), -- Thistle Tea --
(@Entry, 6, 0, 13442), -- Mighty Rage Potion --
(@Entry, 6, 0, 5634), -- Free Action Potion --
(@Entry, 6, 0, 20008); -- Living Action Potion --
-- ----------------------------------------------------------------------------------------
-- Creature --
DELETE FROM creature_template WHERE Entry = @Entry;
INSERT INTO creature_template (`Entry`, `Name`, `Subname`, `IconName`, `Minlevel`, `Maxlevel`, `Faction`, `Rank`, `NpcFlag`, `Type`) VALUES
(@Entry, @Name, @Title, @Icon, @Level, @Level, @Faction, @Rank, @Flags, @Type);
DELETE FROM creature_template_model WHERE CreatureID = @Entry;
INSERT INTO creature_template_model (`CreatureID`, `CreatureDisplayID`, `DisplayScale`, `Probability`)
VALUES (@Entry, @Model, @Scale, 1);