image

Titan-Forged vendor

Dec 17th, 2011
345
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 2.29 KB | None | 0 0
  1. -- WINTERGRASP VENDORS SPAWN
  2. DELETE FROM `creature` WHERE `id` IN ('39172', '39173');
  3. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  4. VALUES
  5. ('39172', '571', '1', '385', '31346', '0', '5372.67', '2786.74', '409.442', '2.80998', '300', '0', '0', '12600', '0', '0', '0'),
  6. ('39173', '571', '1', '65', '0', '0', '5372.67', '2786.74', '409.442', '2.80998', '600', '0', '0', '12600', '0', '0', '0');
  7.  
  8. -- ALLIANCE 39172
  9. UPDATE creature_template SET `modelid3` = "0", `faction_A` = "1892", `faction_H` = "1892", `npcflag` = "128", `unit_flags` = "768" WHERE entry=39172;
  10. -- STUFF SOLD
  11. DELETE FROM `npc_vendor` WHERE `entry`='39172';
  12. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  13. VALUES
  14. ('39172', '51568', '0', '0', '2578'),
  15. ('39172', '51569', '0', '0', '2578'),
  16. ('39172', '51570', '0', '0', '2578'),
  17. ('39172', '51571', '0', '0', '2578'),
  18. ('39172', '51572', '0', '0', '2579'),
  19. ('39172', '51573', '0', '0', '2579'),
  20. ('39172', '51574', '0', '0', '2579'),
  21. ('39172', '51575', '0', '0', '2579'),
  22. ('39172', '51576', '0', '0', '2579'),
  23. ('39172', '51577', '0', '0', '2579'),
  24. ('39172', '51578', '0', '0', '2579'),
  25. ('39172', '51579', '0', '0', '2579'),
  26. ('39172', '51580', '0', '0', '2579'),
  27. ('39172', '51581', '0', '0', '2579');
  28.  
  29. -- HORDE
  30. UPDATE creature_template SET `modelid3` = "0", `faction_A` = "1981", `faction_H` = "1981", `npcflag` = "128", `unit_flags` = "768" WHERE entry=39173;
  31. -- STUFF SOLD 39173
  32. DELETE FROM `npc_vendor` WHERE `entry`='39173';
  33. INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
  34. VALUES
  35. ('39173', '51568', '0', '0', '2578'),
  36. ('39173', '51569', '0', '0', '2578'),
  37. ('39173', '51570', '0', '0', '2578'),
  38. ('39173', '51571', '0', '0', '2578'),
  39. ('39173', '51572', '0', '0', '2579'),
  40. ('39173', '51573', '0', '0', '2579'),
  41. ('39173', '51574', '0', '0', '2579'),
  42. ('39173', '51575', '0', '0', '2579'),
  43. ('39173', '51576', '0', '0', '2579'),
  44. ('39173', '51577', '0', '0', '2579'),
  45. ('39173', '51578', '0', '0', '2579'),
  46. ('39173', '51579', '0', '0', '2579'),
  47. ('39173', '51580', '0', '0', '2579'),
  48. ('39173', '51581', '0', '0', '2579');
Advertisement
Add Comment
Please, Sign In to add comment