API tools faq
paste
Advertisement
Rushor

Untitled

Rushor
Aug 18th, 2014
317
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.49 KB | None | 0 0
raw download clone embed print report
  1. SET @GUID := 2033158;
  2. DELETE FROM `gameobject` WHERE `guid` BETWEEN @GUID AND @GUID+51 AND `id`=181276;
  3. INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  4. (@GUID, 181276, 545, 3, 1, 58.5667, -204.123, -22.6133, 0, 0, 0, 0.993572, -0.113203, 2700, 100, 1),
  5. (@GUID+1, 181276, 545, 3, 1, 58.5667, -204.123, -22.6133, 0, 0, 0, 0.993572, -0.113203, 2700, 100, 1),
  6. (@GUID+2, 181276, 530, 1, 1, 657.941, 6443.58, 21.3223, 2.33874, 0, 0, 0.920505, 0.390731, 60, 100, 1),
  7. (@GUID+3, 181276, 530, 1, 1, 785.26, 6723.05, 20.0622, 1.79769, 0, 0, 0.782608, 0.622515, 60, 100, 1),
  8. (@GUID+4, 181276, 530, 1, 1, 1000.79, 8098.37, 22.8685, -2.47837, 0, 0, 0.945519, -0.325568, 60, 100, 1),
  9. (@GUID+5, 181276, 530, 1, 1, 755.452, 7906.58, 23.3914, 0, 0, 0, 0, 1, 60, 100, 1),
  10. (@GUID+6, 181276, 530, 1, 1, 1232.02, 8670.86, 19.2138, 0.261799, 0, 0, 0.130526, 0.991445, 60, 100, 1),
  11. (@GUID+7, 181276, 530, 1, 1, 978.896, 8378.65, 23.2019, -0.733038, 0, 0, 0.358368, -0.93358, 60, 100, 1),
  12. (@GUID+8, 181276, 530, 1, 1, 558.517, 8079.06, 23.1242, -1.72788, 0, 0, 0.760406, -0.649448, 60, 100, 1),
  13. (@GUID+9, 181276, 530, 1, 1, 1029.5, 8594.19, 23.766, -2.67035, 0, 0, 0.97237, -0.233445, 60, 100, 1),
  14. (@GUID+10, 181276, 530, 1, 1, 916.977, 8606.69, 22.5519, -2.04204, 0, 0, 0.85264, -0.522498, 60, 100, 1),
  15. (@GUID+11, 181276, 530, 1, 1, 742.956, 8687.42, 15.1519, -2.61799, 0, 0, 0.965926, -0.258819, 60, 100, 1),
  16. (@GUID+12, 181276, 530, 1, 1, 204.353, 8169.52, 23.3274, 0.401426, 0, 0, 0.199368, 0.979925, 60, 100, 1),
  17. (@GUID+13, 181276, 530, 1, 1, 159.645, 8943.44, 22.6112, 0.959931, 0, 0, 0.461749, 0.887011, 60, 100, 1),
  18. (@GUID+14, 181276, 530, 1, 1, -131.107, 8814.37, 24.3029, -2.1293, 0, 0, 0.87462, -0.48481, 60, 100, 1),
  19. (@GUID+15, 181276, 530, 1, 1, 522.205, 6323.62, 22.5429, -3.10669, 0, 0, 0.999848, -0.017452, 60, 100, 1),
  20. (@GUID+16, 181276, 530, 1, 1, 1030.67, 8727.31, 5.33556, 0, 0, 0, 0, 0, 60, 0, 1),
  21. (@GUID+17, 181276, 530, 1, 1, 459.721, 5300.83, -1.64052, 0, 0, 0, 0, 0, 60, 0, 1),
  22. (@GUID+18, 181276, 530, 1, 1, 512.408, 5850.85, 23.8378, -1.32645, 0, 0, 0, 1, 60, 255, 1),
  23. (@GUID+19, 181276, 530, 1, 1, -193.153, 7896.41, 20.4815, 2.19912, 0, 0, 0, 1, 60, 255, 1),
  24. (@GUID+20, 181276, 530, 1, 1, 393.071, 5887.61, 22.5333, 0, 0, 0, 0, 0, 60, 0, 1),
  25. (@GUID+21, 181276, 530, 1, 1, 309.43, 5341.78, 22.8067, 0, 0, 0, 0, 0, 60, 0, 1),
  26. (@GUID+22, 181276, 530, 1, 1, 541.504, 5192.18, 3.11218, 0, 0, 0, 0, 0, 60, 0, 1),
  27. (@GUID+23, 181276, 530, 1, 1, 58.056, 5531.34, 23.64, 0, 0, 0, 0, 0, 60, 0, 1),
  28. (@GUID+24, 181276, 530, 1, 1, 725.806, 5508.13, -1.81071, 0, 0, 0, 0, 0, 60, 0, 1),
  29. (@GUID+25, 181276, 530, 1, 1, 824.051, 5370.86, -0.944571, 0, 0, 0, 0, 0, 60, 0, 1),
  30. (@GUID+26, 181276, 530, 1, 1, 561.567, 5624.54, 18.8166, 0, 0, 0, 0, 0, 60, 0, 1),
  31. (@GUID+27, 181276, 530, 1, 1, 537.986, 5434.93, -3.62889, 0, 0, 0, 0, 0, 60, 0, 1),
  32. (@GUID+28, 181276, 530, 1, 1, 538.579, 5322.72, -24.1594, 0, 0, 0, 0, 0, 60, 0, 1),
  33. (@GUID+29, 181276, 530, 1, 1, 611.324, 5518.14, -1.16461, -1.79769, 0, 0, 0, 1, 60, 255, 1),
  34. (@GUID+30, 181276, 530, 1, 1, 475.503, 5950.67, 22.8493, 0.628317, 0, 0, 0, 1, 60, 255, 1),
  35. (@GUID+31, 181276, 530, 1, 1, 695.183, 5439.76, -23.4568, 0, 0, 0, 0, 0, 60, 0, 1),
  36. (@GUID+32, 181276, 530, 1, 1, 314.989, 7734.13, 23.2506, 0, 0, 0, 0, 0, 60, 0, 1),
  37. (@GUID+33, 181276, 530, 1, 1, 363.723, 8162.48, 23.1161, 0, 0, 0, 0, 0, 60, 0, 1),
  38. (@GUID+34, 181276, 530, 1, 1, 114.665, 8606.88, 22.2169, 0, 0, 0, 0, 0, 60, 0, 1),
  39. (@GUID+35, 181276, 530, 1, 1, -139.498, 8998.17, 22.8894, 0, 0, 0, 0, 0, 60, 0, 1),
  40. (@GUID+36, 181276, 530, 1, 1, 325.983, 5721.31, 22.6486, 0, 0, 0, 0, 0, 60, 0, 1),
  41. (@GUID+37, 181276, 530, 1, 1, 758.05, 5651.15, 23.09, -0.855211, 0, 0, 0, 1, 60, 255, 1),
  42. (@GUID+38, 181276, 530, 1, 1, 836.484, 5675.57, 24.7045, -3.05433, 0, 0, 0, 1, 60, 255, 1),
  43. (@GUID+39, 181276, 530, 1, 1, 888.652, 5313.54, 19.8773, 0, 0, 0, 0, 0, 60, 0, 1),
  44. (@GUID+40, 181276, 530, 1, 1, 709.53, 5259.44, -0.880973, 0, 0, 0, 0, 0, 60, 0, 1),
  45. (@GUID+41, 181276, 530, 1, 1, 818.973, 5240.57, 22.035, 0, 0, 0, 0, 0, 60, 0, 1),
  46. (@GUID+42, 181276, 530, 1, 1, 607.469, 5870.84, 22.6128, 0, 0, 0, 0, 0, 60, 0, 1),
  47. (@GUID+43, 181276, 530, 1, 1, -392.144, 6500.78, 21.553, 2.54818, 0, 0, 0, 1, 60, 255, 1),
  48. (@GUID+44, 181276, 530, 1, 1, -252.617, 6198.28, 23.9543, -2.28638, 0, 0, 0, 1, 60, 255, 1),
  49. (@GUID+45, 181276, 530, 1, 1, -178.382, 6021.08, 22.5117, -1.93732, 0, 0, 0, 1, 60, 255, 1),
  50. (@GUID+46, 181276, 530, 1, 1, 907, 5103.25, 4.49501, 0, 0, 0, 0, 0, 60, 0, 1),
  51. (@GUID+47, 181276, 547, 1, 1, -55.9415, -29.0174, -1.69497, -1.32645, 0, 0, 0, 1, 2700, 100, 1),
  52. (@GUID+48, 181276, 546, 1, 1, 376.429, -453.141, 33.1995, -2.25147, 0, 0, 0, 1, 2700, 100, 1),
  53. (@GUID+49, 181276, 547, 1, 1, -170.84, -779.574, 42.7871, -3.03684, 0, 0, 0, 1, 2700, 100, 1),
  54. (@GUID+50, 181276, 547, 1, 1, -146.687, -255.88, -1.58513, -0.628317, 0, 0, 0, 1, 2700, 100, 1),
  55. (@GUID+51, 181276, 546, 1, 1, 278.916, -236.037, 29.1704, 2.70526, 0, 0, 0, 1, 2700, 100, 1);
  56.  
  57. DELETE FROM `pool_gameobject` WHERE `guid` BETWEEN @GUID AND @GUID+51 AND `pool_entry`=975;
  58. INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`) VALUES
  59. (@GUID, 975, 0, ''),
  60. (@GUID+1, 975, 0, ''),
  61. (@GUID+2, 975, 0, ''),
  62. (@GUID+3, 975, 0, ''),
  63. (@GUID+4, 975, 0, ''),
  64. (@GUID+5, 975, 0, ''),
  65. (@GUID+6, 975, 0, ''),
  66. (@GUID+7, 975, 0, ''),
  67. (@GUID+8, 975, 0, ''),
  68. (@GUID+9, 975, 0, ''),
  69. (@GUID+10, 975, 0, ''),
  70. (@GUID+11, 975, 0, ''),
  71. (@GUID+12, 975, 0, ''),
  72. (@GUID+13, 975, 0, ''),
  73. (@GUID+14, 975, 0, ''),
  74. (@GUID+15, 975, 0, ''),
  75. (@GUID+16, 975, 0, ''),
  76. (@GUID+17, 975, 0, ''),
  77. (@GUID+18, 975, 0, ''),
  78. (@GUID+19, 975, 0, ''),
  79. (@GUID+20, 975, 0, ''),
  80. (@GUID+21, 975, 0, ''),
  81. (@GUID+22, 975, 0, ''),
  82. (@GUID+23, 975, 0, ''),
  83. (@GUID+24, 975, 0, ''),
  84. (@GUID+25, 975, 0, ''),
  85. (@GUID+26, 975, 0, ''),
  86. (@GUID+27, 975, 0, ''),
  87. (@GUID+28, 975, 0, ''),
  88. (@GUID+29, 975, 0, ''),
  89. (@GUID+30, 975, 0, ''),
  90. (@GUID+31, 975, 0, ''),
  91. (@GUID+32, 975, 0, ''),
  92. (@GUID+33, 975, 0, ''),
  93. (@GUID+34, 975, 0, ''),
  94. (@GUID+35, 975, 0, ''),
  95. (@GUID+36, 975, 0, ''),
  96. (@GUID+37, 975, 0, ''),
  97. (@GUID+38, 975, 0, ''),
  98. (@GUID+39, 975, 0, ''),
  99. (@GUID+40, 975, 0, ''),
  100. (@GUID+41, 975, 0, ''),
  101. (@GUID+42, 975, 0, ''),
  102. (@GUID+43, 975, 0, ''),
  103. (@GUID+44, 975, 0, ''),
  104. (@GUID+45, 975, 0, ''),
  105. (@GUID+46, 975, 0, ''),
  106. (@GUID+47, 975, 0, ''),
  107. (@GUID+48, 975, 0, ''),
  108. (@GUID+49, 975, 0, ''),
  109. (@GUID+50, 975, 0, ''),
  110. (@GUID+51, 975, 0, '');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!