Advertisement
Rushor

Untitled

Aug 17th, 2014
296
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.80 KB | None | 0 0
  1. SET @GUID := 200005;
  2. DELETE FROM `gameobject` WHERE `guid` BETWEEN @GUID AND @GUID+42;
  3. INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  4. (@GUID, 165658, 409, 1, 1010.06, -739.994, -155.03, 5.21929, 0, 0, 0.507212, -0.861822, 300, 100, 1),
  5. (@GUID+1, 165658, 409, 1, 1010.06, -739.994, -155.03, 5.21929, 0, 0, 0.507212, -0.861822, 300, 100, 1),
  6. (@GUID+2, 165658, 409, 1, 1066.13, -807.71, -151.816, 3.06338, 0, 0, 0.999235, 0.039098, 300, 100, 1),
  7. (@GUID+3, 165658, 409, 1, 1072.1, -898.61, -157.093, 2.74136, 0, 0, 0.980044, 0.198783, 300, 100, 1),
  8. (@GUID+4, 165658, 409, 1, 952.074, -877.046, -174.356, 5.82955, 0, 0, 0.22488, -0.974386, 300, 100, 1),
  9. (@GUID+5, 165658, 409, 1, 1102.02, -968.525, -182.504, 5.17767, 0, 0, 0.525037, -0.851079, 300, 100, 1),
  10. (@GUID+6, 165658, 409, 1, 1158.81, -1028.01, -184.122, 2.02822, 0, 0, 0.84901, 0.528376, 300, 100, 1),
  11. (@GUID+7, 165658, 409, 1, 950.241, -662.906, -199.686, 3.19846, 0, 0, 0.999596, -0.02843, 300, 100, 1),
  12. (@GUID+8, 165658, 409, 1, 902.068, -640.519, -199.686, 2.99033, 0, 0, 0.997141, 0.0755594, 300, 100, 1),
  13. (@GUID+9, 165658, 409, 1, 896.894, -529.287, -202.423, 4.20377, 0, 0, 0.862256, -0.506472, 300, 100, 1),
  14. (@GUID+10, 165658, 409, 1, 794.497, -513.925, -210.555, 2.99818, 0, 0, 0.99743, 0.071643, 300, 100, 1),
  15. (@GUID+11, 165658, 409, 1, 679.33, -473.297, -211.302, 3.65792, 0, 0, 0.966861, -0.255305, 300, 100, 1),
  16. (@GUID+12, 165658, 409, 1, 579.453, -767.434, -208.065, 2.63298, 0, 0, 0.967838, 0.251576, 300, 100, 1),
  17. (@GUID+13, 165658, 409, 1, 578.856, -847.387, -206.238, 4.64752, 0, 0, 0.729665, -0.683805, 300, 100, 1),
  18. (@GUID+14, 165658, 409, 1, 579.6, -1181.76, -195.215, 4.28231, 0, 0, 0.841707, -0.539935, 300, 100, 1),
  19. (@GUID+15, 165658, 409, 1, 635.518, -1186.69, -195.447, 0.653767, 0, 0, 0.321093, 0.947048, 300, 100, 1),
  20. (@GUID+16, 165658, 409, 1, 732.068, -1092.37, -170.779, 5.47219, 0, 0, 0.394478, -0.918905, 300, 100, 1),
  21. (@GUID+17, 165658, 409, 1, 814.651, -1153.84, -153.189, 0.744089, 0, 0, 0.363521, 0.931586, 300, 100, 1),
  22. (@GUID+18, 165658, 409, 1, 913.101, -1000.13, -195.44, 1.9536, 0, 0, 0.828711, 0.559676, 300, 100, 1),
  23. (@GUID+19, 165658, 409, 1, 770.895, -971, -207.026, 5.55465, 0, 0, 0.356264, -0.934385, 300, 100, 1),
  24. (@GUID+20, 165658, 409, 1, 771.275, -1018.62, -205.715, 0.720527, 0, 0, 0.352521, 0.935804, 300, 100, 1),
  25. (@GUID+21, 165658, 409, 1, 730.963, -1127.63, -140.271, 3.56367, 0, 0, 0.977814, -0.209475, 300, 100, 1),
  26. (@GUID+22, 165658, 409, 1, 660.942, -1194.76, -121.508, 4.63181, 0, 0, 0.735014, -0.678052, 300, 100, 1),
  27. (@GUID+23, 165658, 409, 1, 783.364, -1207.26, -120.561, 5.62141, 0, 0, 0.324881, -0.945755, 300, 100, 1),
  28. (@GUID+24, 165658, 230, 1, 640.581, -138.03, -68.888, 6.13078, 0, 0, 0.0761288, -0.997098, 300, 100, 1),
  29. (@GUID+25, 165658, 230, 1, 666.174, -205.577, -78.3634, 5.01551, 0, 0, 0.59224, -0.805762, 300, 100, 1),
  30. (@GUID+26, 165658, 230, 1, 642.106, -263.413, -82.0564, 4.62674, 0, 0, 0.73673, -0.676187, 300, 100, 1),
  31. (@GUID+27, 165658, 230, 1, 545.033, -267.174, -71.8572, 2.62005, 0, 0, 0.966191, 0.257826, 300, 100, 1),
  32. (@GUID+28, 165658, 230, 1, 309.895, -202.297, -77.0269, 2.8596, 0, 0, 0.990076, 0.140532, 300, 100, 1),
  33. (@GUID+29, 165658, 230, 1, 282.596, -100.225, -74.3335, 1.36341, 0, 0, 0.630118, 0.776499, 300, 100, 1),
  34. (@GUID+30, 165658, 230, 1, 336.691, -60.604, -70.2526, 0.581939, 0, 0, 0.286881, 0.957966, 300, 100, 1),
  35. (@GUID+40, 165658, 230, 1, 643.435, 138.501, -73.8688, 1.85821, 0, 0, 0.801086, 0.59855, 300, 100, 1),
  36. (@GUID+41, 165658, 230, 1, 677.154, 204.68, -72.0401, 1.32414, 0, 0, 0.614752, 0.788721, 300, 100, 1),
  37. (@GUID+42, 165658, 230, 1, 748.658, 167.945, -72.156, 0.177461, 0, 0, 0.088614, 0.996066, 300, 100, 1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement