API tools faq
paste
Guest User

Untitled

a guest
Jan 23rd, 2018
74
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 6.75 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM gameobject WHERE guid IN (6759, 10529, 4535, 14312, 2889, 13732, 15409, 15418, 16226, 16227, 13806, 12565, 12566, 12568, 12576, 12575, 7288, 16220, 1055, 16294, 3340);
  2.  
  3. -- Kira Moonshine
  4. -- Spawn
  5. UPDATE creature SET `position_x`='-9126.18', `position_y`='394.417', `position_z`='91.7424', `orientation`='3.92184', `curhealth`='247', `MovementType`='2' WHERE id=3937;
  6.  
  7. -- Movement
  8. SET @guid=(SELECT `guid` FROM `creature` WHERE `id`='3937');
  9.  
  10. DELETE FROM `creature_movement` WHERE `id`=@guid;
  11. INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`)
  12. VALUES
  13. (@guid, '1', '-9126.16', '394.437', '91.7448', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.92184', '0', '0'),
  14. (@guid, '2', '-9149.4', '371.436', '90.5661', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.92184', '0', '0'),
  15. (@guid, '3', '-9176.05', '334.029', '83.0087', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.11584', '0', '0'),
  16. (@guid, '4', '-9183.22', '297.601', '77.6922', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.763', '0', '0'),
  17. (@guid, '5', '-9184.93', '245.883', '73.0884', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.44335', '0', '0'),
  18. (@guid, '6', '-9197.58', '220.912', '71.4942', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.82759', '0', '0'),
  19. (@guid, '7', '-9250.63', '165.225', '67.8549', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.82288', '0', '0'),
  20. (@guid, '8', '-9285.54', '149.001', '66.4971', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.46474', '0', '0'),
  21. (@guid, '9', '-9378.72', '106.149', '60.3028', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.57155', '0', '0'),
  22. (@guid, '10', '-9433.42', '75.7027', '56.1161', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.59512', '0', '0'),
  23. (@guid, '11', '-9462.44', '65.9774', '56.01', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.29588', '0', '0'),
  24. (@guid, '12', '-9470.47', '65.4031', '56.1275', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.08854', '0', '0'),
  25. (@guid, '13', '-9490.4', '59.1956', '55.9618', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.44354', '0', '0'),
  26. (@guid, '14', '-9500.86', '46.0694', '55.9648', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.06243', '0', '0'),
  27. (@guid, '15', '-9544.86', '-53.9701', '56.7403', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.29805', '0', '0'),
  28. (@guid, '16', '-9553.88', '-110.507', '57.7333', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.55016', '0', '0'),
  29. (@guid, '17', '-9543.93', '-106.981', '57.8092', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.54994', '0', '0'),
  30. (@guid, '18', '-9543.27', '-81.1444', '57.8416', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.51224', '0', '0'),
  31. (@guid, '19', '-9541.29', '-48.7551', '56.6601', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.23892', '0', '0'),
  32. (@guid, '20', '-9534.49', '-31.5541', '56.1397', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.041', '0', '0'),
  33. (@guid, '21', '-9509.24', '11.5561', '56.3607', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.041', '0', '0'),
  34. (@guid, '22', '-9486.23', '73.7671', '56.2986', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.1973', '0', '0'),
  35. (@guid, '23', '-9481.3', '105.623', '56.4422', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.41721', '0', '0'),
  36. (@guid, '24', '-9476.57', '152.908', '56.3557', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.49811', '0', '0'),
  37. (@guid, '25', '-9480.41', '185.803', '55.3184', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.01647', '0', '0'),
  38. (@guid, '26', '-9505.8', '222.489', '52.8972', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.25287', '0', '0'),
  39. (@guid, '27', '-9530.23', '246.038', '50.9302', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.92989', '0', '0'),
  40. (@guid, '28', '-9562.42', '252.957', '49.6144', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.92989', '0', '0'),
  41. (@guid, '29', '-9619.82', '257.001', '47.2105', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.07126', '0', '0'),
  42. (@guid, '30', '-9625.87', '247.5', '46.7826', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.64677', '0', '0'),
  43. (@guid, '31', '-9558.87', '245.123', '49.6862', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6.10525', '0', '0'),
  44. (@guid, '32', '-9539.11', '241.569', '50.6787', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6.10525', '0', '0'),
  45. (@guid, '33', '-9514.46', '217.805', '52.7325', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.49264', '0', '0'),
  46. (@guid, '34', '-9495.19', '193.441', '54.6587', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.25938', '0', '0'),
  47. (@guid, '35', '-9488.06', '177.861', '55.4668', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.76065', '0', '0'),
  48. (@guid, '36', '-9484.13', '147.64', '56.571', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.64206', '0', '0'),
  49. (@guid, '37', '-9487.88', '119.292', '56.9634', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.68996', '0', '0'),
  50. (@guid, '38', '-9482.05', '66.4314', '56.1972', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.96171', '0', '0'),
  51. (@guid, '39', '-9436.97', '65.4173', '56.3779', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.037268', '0', '0'),
  52. (@guid, '40', '-9399.3', '94.3994', '58.621', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.407976', '0', '0'),
  53. (@guid, '41', '-9370.01', '100.86', '60.9139', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.323938', '0', '0'),
  54. (@guid, '42', '-9306.79', '136.49', '65.5034', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.577622', '0', '0'),
  55. (@guid, '43', '-9280.75', '145.374', '66.8506', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.086748', '0', '0'),
  56. (@guid, '44', '-9246.37', '158.521', '68.2631', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.425255', '0', '0'),
  57. (@guid, '45', '-9218.88', '196.695', '68.8469', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.946759', '0', '0'),
  58. (@guid, '46', '-9189.62', '223.718', '72.2167', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.745697', '0', '0'),
  59. (@guid, '47', '-9175.37', '266.382', '75.2194', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.24835', '0', '0'),
  60. (@guid, '48', '-9175.11', '316.319', '80.1316', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.55387', '0', '0'),
  61. (@guid, '49', '-9168.54', '335.204', '84.1804', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.09049', '0', '0'),
  62. (@guid, '50', '-9150.66', '360.438', '90.1681', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.81874', '0', '0'),
  63. (@guid, '51', '-9121.78', '385.189', '91.4254', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.665587', '0', '0');
Add Comment
Please, Sign In to add comment
Public Pastes
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!