Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- WINTERGRASP VENDORS SPAWN
- DELETE FROM `creature` WHERE `id` IN ('39172', '39173');
- INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
- VALUES
- ('39172', '571', '1', '385', '31346', '0', '5372.67', '2786.74', '409.442', '2.80998', '300', '0', '0', '12600', '0', '0', '0'),
- ('39173', '571', '1', '65', '0', '0', '5372.67', '2786.74', '409.442', '2.80998', '600', '0', '0', '12600', '0', '0', '0');
- -- ALLIANCE 39172
- UPDATE creature_template SET `modelid3` = "0", `faction_A` = "1892", `faction_H` = "1892", `npcflag` = "128", `unit_flags` = "768" WHERE entry=39172;
- -- STUFF SOLD
- DELETE FROM `npc_vendor` WHERE `entry`='39172';
- INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
- VALUES
- ('39172', '51568', '0', '0', '2578'),
- ('39172', '51569', '0', '0', '2578'),
- ('39172', '51570', '0', '0', '2578'),
- ('39172', '51571', '0', '0', '2578'),
- ('39172', '51572', '0', '0', '2579'),
- ('39172', '51573', '0', '0', '2579'),
- ('39172', '51574', '0', '0', '2579'),
- ('39172', '51575', '0', '0', '2579'),
- ('39172', '51576', '0', '0', '2579'),
- ('39172', '51577', '0', '0', '2579'),
- ('39172', '51578', '0', '0', '2579'),
- ('39172', '51579', '0', '0', '2579'),
- ('39172', '51580', '0', '0', '2579'),
- ('39172', '51581', '0', '0', '2579');
- -- HORDE
- UPDATE creature_template SET `modelid3` = "0", `faction_A` = "1981", `faction_H` = "1981", `npcflag` = "128", `unit_flags` = "768" WHERE entry=39173;
- -- STUFF SOLD 39173
- DELETE FROM `npc_vendor` WHERE `entry`='39173';
- INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
- VALUES
- ('39173', '51568', '0', '0', '2578'),
- ('39173', '51569', '0', '0', '2578'),
- ('39173', '51570', '0', '0', '2578'),
- ('39173', '51571', '0', '0', '2578'),
- ('39173', '51572', '0', '0', '2579'),
- ('39173', '51573', '0', '0', '2579'),
- ('39173', '51574', '0', '0', '2579'),
- ('39173', '51575', '0', '0', '2579'),
- ('39173', '51576', '0', '0', '2579'),
- ('39173', '51577', '0', '0', '2579'),
- ('39173', '51578', '0', '0', '2579'),
- ('39173', '51579', '0', '0', '2579'),
- ('39173', '51580', '0', '0', '2579'),
- ('39173', '51581', '0', '0', '2579');
Advertisement
Add Comment
Please, Sign In to add comment