Advertisement
bucur35

asdgg

Sep 3rd, 2012
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.53 KB | None | 0 0
  1. /***************************
  2.   Cementing Our Victory
  3. ***************************/  
  4.  
  5. -- Gobject script
  6.  
  7. DELETE FROM `gameobject_template` WHERE  `entry`=204880 LIMIT 1;
  8. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `flags`, `questItem1`, `data0`, `data1`, `data2`, `data6`, `data24`, `data25`, `data26`, `data27`, `data28`, `data29`, `data30`, `data31`, `WDBVerified`) VALUES
  9. (204880, 3, 10352, 'Verrall River Muck', 4, 60337, 43, 204880, 30, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13329);
  10.  
  11. -- Gobject spawn
  12.  
  13. SET @OBJECT := 60337;
  14. SET @GUID := 1324691;
  15.  
  16. DELETE FROM `gameobject` WHERE  `guid`=@GUID LIMIT 1;
  17. INSERT INTO `gameobject` (`guid`,  `id`,  `map`, `position_x`,  `position_y`,  `position_z`, `spawntimesecs`) VALUES
  18. (@GUID+0, @OBJECT, 0, -3824.390869, -6009.685059, 7.733586, 120),
  19. (@GUID+1, @OBJECT, 0, -3816.848633, -5966.995605, 7.560461, 120),
  20. (@GUID+2, @OBJECT, 0, -3789.693115, -5954.684082, 7.734461, 120),
  21. (@GUID+3, @OBJECT, 0, -3743.188477, -5952.549316, 7.811245, 120),
  22. (@GUID+4, @OBJECT, 0, -3745.292969, -5999.690918, 7.734093, 120),
  23. (@GUID+5, @OBJECT, 0, -3817.141357, -6053.581055, 7.663999, 120),
  24. (@GUID+6, @OBJECT, 0, -3847.444824, -6025.316406, 7.733634, 120),
  25. (@GUID+7, @OBJECT, 0, -3889.384521, -5990.997070, 7.629901, 120),
  26. (@GUID+8, @OBJECT, 0, -3925.928711, -5986.321289, 7.721721, 120),
  27. (@GUID+9, @OBJECT, 0, -3988.002930, -5976.875488, 7.950207, 120),
  28. (@GUID+10, @OBJECT, 0, -3899.330811, -6049.043457, 7.585964, 120),
  29. (@GUID+11, @OBJECT, 0, -3865.116211, -6096.554199, 7.704701, 120);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement