-
Notifications
You must be signed in to change notification settings - Fork 1
/
VelvetyJosh.sql
41 lines (38 loc) · 1.66 KB
/
VelvetyJosh.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
-- ######################################################--
-- EXCHANGE - 999005
-- ######################################################--
SET
@Entry := 999005,
@Model := 2299, -- Greedy Kobold
@Name := "Velvety Josh",
@Title := "Cloths",
@Icon := "Buy",
@GossipMenu := 0, -- Does not need any Gossip
@MinLevel := 80,
@MaxLevel := 80,
@Faction := 35,
@NPCFlag := 128,
@Scale := 1.0,
@Rank := 0,
@Type := 7,
@TypeFlags := 0,
@FlagsExtra := 2,
@AIName := "SmartAI",
@Script := "";
-- NPC
DELETE FROM `creature_template` WHERE `entry` = @Entry;
INSERT INTO `creature_template` (`entry`, `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, @Name, @Title, @Icon, @GossipMenu, @MinLevel, @MaxLevel, @Faction, @NPCFlag, 1, 1.14286, 1, @Rank, 1, 2, @Type, @TypeFlags, 1, @FlagsExtra, @AIName, @Script);
DELETE FROM `creature_template_model` WHERE `CreatureID` = @Entry;
INSERT INTO `creature_template_model` (`CreatureID`, `Idx`, `CreatureDisplayID`, `DisplayScale`, `Probability`) VALUES
(@Entry, 0, @Model, @Scale, 1);
-- NPC ITEMS
DELETE FROM npc_vendor WHERE entry = @Entry;
INSERT INTO npc_vendor (`entry`, `item`, `slot`) VALUES
(@Entry, 2589, 0), -- Linen Cloth
(@Entry, 2592, 1), -- Wool Cloth
(@Entry, 4306, 2), -- Silk Cloth
(@Entry, 4338, 3), -- Mageweave Cloth
(@Entry, 14047, 4), -- Runecloth
(@Entry, 21877, 5), -- Netherweave Cloth
(@Entry, 33470, 6); -- Frostweave Cloth