Advertisement
bucur35

Sunken Treasure

Aug 31st, 2012
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.95 KB | None | 0 0
  1. /****************
  2.  Sunken Treasure
  3. ****************/
  4.  
  5. -- Assign
  6.  
  7. UPDATE `gameobject_questrelation` SET `id`=55138, `quest`=25609 WHERE  LIMIT 1;
  8.  
  9. -- Script
  10.  
  11. DELETE FROM `gameobject`  WHERE `guid`=25609 LIMIT 1;
  12. INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`) VALUES
  13. (@Object+0, 25609, 0, 1, -5919.012207, -4167.396973, -107.655624, 0, 120),
  14. (@Object+1, 25609, 0, 1, -5919.567871, -4189.332520, -111.045128, 0, 120),
  15. (@Object+2, 25609, 0, 1, -5908.170410, -4197.998047, -92.071098, 0, 120),
  16. (@Object+3, 25609, 0, 1, -5897.161621, -4223.054199, -119.458977, 0, 120),
  17. (@Object+4, 25609, 0, 1, -5925.237305, -4252.893066, -185.162155, 0, 120),
  18. (@Object+5, 25609, 0, 1, -5895.654297, -4261.860352, -159.134842, 0, 120),
  19. (@Object+6, 25609, 0, 1, -5887.202148, -4295.677734, -170.276978, 0, 120),
  20. (@Object+7, 25609, 0, 1, -5908.208008, -4139.554688, -94.333839, 0, 120);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement