Advertisement
bucur35

Sunken Treasure

Aug 31st, 2012
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. /****************
  2.  Sunken Treasure
  3. ****************/
  4.  
  5. -- Spawn game objects
  6.  
  7. SET @Object :=xxxxx;
  8.  
  9. DELETE FROM `gameobject` WHERE  `id`=55138 LIMIT 1;
  10. INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`) VALUES
  11. (@Object+0, 55138, 0, 1, -5919.012207, -4167.396973, -107.655624, 0, 120),
  12. (@Object+1, 55138, 0, 1, -5919.567871, -4189.332520, -111.045128, 0, 120),
  13. (@Object+2, 55138, 0, 1, -5908.170410, -4197.998047, -92.071098, 0, 120),
  14. (@Object+3, 55138, 0, 1, -5897.161621, -4223.054199, -119.458977, 0, 120),
  15. (@Object+4, 55138, 0, 1, -5925.237305, -4252.893066, -185.162155, 0, 120),
  16. (@Object+5, 55138, 0, 1, -5895.654297, -4261.860352, -159.134842, 0, 120),
  17. (@Object+6, 55138, 0, 1, -5887.202148, -4295.677734, -170.276978, 0, 120),
  18. (@Object+7, 55138, 0, 1, -5908.208008, -4139.554688, -94.333839, 0, 120);
  19.  
  20. -- Script
  21.  
  22. DELETE FROM `gameobject_template` WHERE  `entry`=203090 LIMIT 1;
  23. INSERT INTO `gameobject_template` (`entry`,  `type`,  `displayId`,  `name`,  `faction`,  `flags`,  `size`,  `questItem1`,  `questItem2`,  `questItem3`,  `questItem4`,  `questItem5`,  `questItem6`,  `data0`,  `data1`,  `data2`,  `data3`,  `data4`,  `data5`,  `data6`,  `data7`,  `data8`,  `data9`,  `data10`,  `data11`,  `data12`,  `data13`,  `data14`,  `data15`,  `data16`,  `data17`,  `data18`,  `data19`,  `data20`,  `data21`,  `data22`,  `data23`,  `data24`,  `data25`,  `data26`,  `data27`,  `data28`,  `data29`,  `data30`,  `data31`,  `WDBVerified`) VALUES
  24. (203090, 3, 259, 'Sunken Treasure Chest', 0, 4, 2, 55138, 0, 0, 0, 0, 0, 1691, 203090, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19676, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13329);
  25.  
  26. -- Assign
  27.  
  28. UPDATE `gameobject_questrelation` SET `id`=55138, `quest`=25609;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement