bucur35

Cementing Our Victory

Sep 3rd, 2012
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.81 KB | None | 0 0
  1. /*************************
  2.   Cementing Our Victory
  3. *************************/
  4.  
  5. SET @GUID:= 212910;
  6.  
  7. DELETE FROM `gameobject` WHERE `id` = 204880;
  8.  
  9. INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  10. (@GUID+0,'204880','0','1','1','-3968.95','-5949.12','9.0483','0.142347','0','0','0.0711133','0.997468','300','0','1'),
  11. (@GUID+1,'204880','0','1','1','-3996.26','-5967.9','9.60234','4.06149','0','0','0.896076','-0.4439','300','0','1'),
  12. (@GUID+2,'204880','0','1','1','-3982.91','-6005.79','10.1594','5.29455','0','0','0.47443','-0.880293','300','0','1'),
  13. (@GUID+3,'204880','0','1','1','-3957.04','-6039.84','7.02856','5.53802','0','0','0.36402','-0.931391','300','0','1'),
  14. (@GUID+4,'204880','0','1','1','-3926.32','-6066.07','9.52702','0.169829','0','0','0.0848125','0.996397','300','0','1'),
  15. (@GUID+5,'204880','0','1','1','-3938.1','-6091.79','7.67448','5.01182','0','0','0.593729','-0.804665','300','0','1'),
  16. (@GUID+6,'204880','0','1','1','-3927.86','-6123.38','8.77926','4.76442','0','0','0.688474','-0.725261','300','0','1'),
  17. (@GUID+7,'204880','0','1','1','-3911.73','-6157.95','8.52099','0.322988','0','0','0.160793','0.986988','300','0','1'),
  18. (@GUID+8,'204880','0','1','1','-3844.08','-6100.37','7.62063','1.15551','0','0','0.546145','0.837691','300','0','1'),
  19. (@GUID+9,'204880','0','1','1','-3815.5','-6077.15','8.44524','1.15551','0','0','0.546145','0.837691','300','0','1'),
  20. (@GUID+10,'204880','0','1','1','-3832.67','-6046.04','7.53959','1.96447','0','0','0.83174','0.555165','300','0','1'),
  21. (@GUID+11,'204880','0','1','1','-3834.85','-6008.39','8.50761','2.21187','0','0','0.893884','0.448298','300','0','1'),
  22. (@GUID+12,'204880','0','1','1','-3821.42','-5957.27','7.01585','0.978796','0','0','0.470094','0.882616','300','0','1'),
  23. (@GUID+13,'204880','0','1','1','-3770.33','-5891.15','6.97878','4.96077','0','0','0.614072','-0.78925','300','0','1'),
  24. (@GUID+14,'204880','0','1','1','-3631.67','-5786.77','10.6441','5.97','0','0','0.155953','-0.987764','300','0','1'),
  25. (@GUID+15,'204880','0','1','1','-3597.6','-5821.03','12.5708','4.74478','0','0','0.695561','-0.718467','300','0','1'),
  26. (@GUID+16,'204880','0','1','1','-3630.09','-5888.45','15.9492','1.1508','0','0','0.544172','0.838974','300','0','1'),
  27. (@GUID+17,'204880','0','1','1','-3708.97','-5921.16','7.50569','4.09605','0','0','0.888272','-0.459318','300','0','1'),
  28. (@GUID+18,'204880','0','1','1','-3779.98','-6018.74','8.73579','4.09212','0','0','0.889172','-0.457573','300','0','1');
  29.  
  30. DELETE FROM `gameobject_loot_template` WHERE `entry` = 204880;
  31. INSERT INTO `gameobject_loot_template` VALUES
  32. (204880, 60337, -100, 1, 0, 1, 1);
  33.  
  34. UPDATE `gameobject_template` SET `data3` = 1 WHERE `entry` = 204880;
Advertisement
Add Comment
Please, Sign In to add comment