Advertisement
bucur35

Sunken Treasure

Aug 31st, 2012
99
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`=203090 LIMIT 1;
  10. INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`) VALUES
  11. (@Object+0, 203090, 0, 1, -5919.012207, -4167.396973, -107.655624, 0, 120),
  12. (@Object+1, 203090, 0, 1, -5919.567871, -4189.332520, -111.045128, 0, 120),
  13. (@Object+2, 203090, 0, 1, -5908.170410, -4197.998047, -92.071098, 0, 120),
  14. (@Object+3, 203090, 0, 1, -5897.161621, -4223.054199, -119.458977, 0, 120),
  15. (@Object+4, 203090, 0, 1, -5925.237305, -4252.893066, -185.162155, 0, 120),
  16. (@Object+5, 203090, 0, 1, -5895.654297, -4261.860352, -159.134842, 0, 120),
  17. (@Object+6, 203090, 0, 1, -5887.202148, -4295.677734, -170.276978, 0, 120),
  18. (@Object+7, 203090, 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`,  
  24. `size`,  `questItem1`,  `questItem2`,  `questItem3`,  `questItem4`,  `questItem5`,  `questItem6`,  `data0`,  `data1`,  `data2`,  `data3`,  
  25. `data4`,  `data5`,  `data6`,  `data7`,  `data8`,  `data9`,  `data10`,  `data11`,  `data12`,  `data13`,  `data14`,  `data15`,  `data16`,  
  26. `data17`,  `data18`,  `data19`,  `data20`,  `data21`,  `data22`,  `data23`,  `data24`,  `data25`,  `data26`,  `data27`,  `data28`,  
  27. `data29`,  `data30`,  `data31`,  `WDBVerified`) VALUES
  28. (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,
  29. 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13329);
  30.  
  31. -- Assigm
  32.  
  33. UPDATE `gameobject_questrelation` SET `id`=203090, `quest`=25609;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement