API tools faq
paste
image

Crier Goodman

image
Oct 17th, 2011
382
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 11.21 KB | None | 0 0
raw download clone embed print report
  1. -- Spawn
  2. UPDATE creature SET `position_x`='-8767.91', `position_y`='605.781', `position_z`='96.9183', `orientation`='96.9183', `curhealth`='71', `MovementType`='2' WHERE id=2198;
  3.  
  4. -- AI
  5. DELETE FROM creature_ai_scripts WHERE creature_id=2198;
  6. INSERT INTO creature_ai_scripts (`creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`)
  7. VALUES
  8. ('2198', '10', '0', '100', '0', '0', '15', '0', '0', '12', '68', '1', '600000', '0', '0', '0', '0', '0', '0', '0', '0', 'Crier Goodman - Summon Stormwind City Guard on Hostile LOS');
  9.  
  10. -- Stats
  11. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "71", `maxhealth` = "71", `armor` = "51", `mindmg` = "3", `maxdmg` = "4", `attackpower` = "1", `baseattacktime` = "2000", `rangeattacktime` = "2000", `unit_flags` = "0", `minrangedmg` = "2", `maxrangedmg` = "3", `rangedattackpower` = "1", `pickpocketloot` = "0", `maxgold` = "0", `AIName` = "EventAI" WHERE entry=2198;
  12.  
  13. -- Movement
  14. SET @guid=(SELECT guid FROM creature WHERE id=2198);
  15. DELETE FROM creature_movement WHERE id=@guid;
  16. 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`)
  17. VALUES
  18. (@guid, '1', '-8765.11', '602.961', '96.9325', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.51731', '0', '0'),
  19. (@guid, '2', '-8738.37', '576.435', '97.5082', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.49375', '0', '0'),
  20. (@guid, '3', '-8747.92', '560.924', '97.401', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.37849', '0', '0'),
  21. (@guid, '4', '-8734.05', '544.365', '101.121', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.46626', '0', '0'),
  22. (@guid, '5', '-8714.53', '522.998', '97.5844', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.18999', '0', '0'),
  23. (@guid, '6', '-8720', '511.48', '96.6439', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.2057', '0', '0'),
  24. (@guid, '7', '-8694.46', '476.849', '95.3214', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.19529', '0', '0'),
  25. (@guid, '8', '-8713.97', '454.127', '97.0164', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.3667', '0', '0'),
  26. (@guid, '9', '-8718.42', '434.199', '97.3375', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.49551', '0', '0'),
  27. (@guid, '10', '-8715.52', '423.727', '98.2343', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.98245', '0', '0'),
  28. (@guid, '11', '-8690.31', '396.369', '101.731', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.424003', '0', '0'),
  29. (@guid, '12', '-8660.7', '410.462', '102.798', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.874821', '0', '0'),
  30. (@guid, '13', '-8631.91', '451.343', '102.248', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.15521', '0', '0'),
  31. (@guid, '14', '-8643.37', '474.208', '102.515', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.97673', '0', '0'),
  32. (@guid, '15', '-8641.43', '479.421', '102.506', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.05154', '0', '0'),
  33. (@guid, '16', '-8610.68', '505.709', '103.473', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.627421', '0', '0'),
  34. (@guid, '17', '-8571.94', '470.952', '104.306', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.58093', '0', '0'),
  35. (@guid, '18', '-8560.3', '467.067', '104.516', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.96106', '0', '0'),
  36. (@guid, '19', '-8543.74', '475.691', '103.514', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.452277', '0', '0'),
  37. (@guid, '20', '-8537.33', '489.533', '100.55', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.13714', '0', '0'),
  38. (@guid, '21', '-8560.12', '519.892', '100.266', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.21471', '0', '0'),
  39. (@guid, '22', '-8585.63', '566.315', '102.288', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.07884', '0', '0'),
  40. (@guid, '23', '-8584.23', '585.423', '103.55', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.49764', '0', '0'),
  41. (@guid, '24', '-8573.45', '604.235', '103.138', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.0264', '0', '0'),
  42. (@guid, '25', '-8559.56', '615.383', '102.301', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.552808', '0', '0'),
  43. (@guid, '26', '-8511.53', '650.489', '100.291', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.6447', '0', '0'),
  44. (@guid, '27', '-8523.07', '668.287', '102.741', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.24063', '0', '0'),
  45. (@guid, '28', '-8533.62', '683.333', '97.8676', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.20057', '0', '0'),
  46. (@guid, '29', '-8541.43', '685.816', '97.6298', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.03702', '0', '0'),
  47. (@guid, '30', '-8556.23', '676.839', '97.0158', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.84363', '0', '0'),
  48. (@guid, '31', '-8563.75', '677.751', '97.0158', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.8556', '0', '0'),
  49. (@guid, '32', '-8588.25', '704.04', '97.0158', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.26026', '0', '0'),
  50. (@guid, '33', '-8590.28', '713.413', '96.6514', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.7152', '0', '0'),
  51. (@guid, '34', '-8587.41', '727.634', '96.7234', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.31229', '0', '0'),
  52. (@guid, '35', '-8579.62', '736.987', '96.7305', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.760938', '0', '0'),
  53. (@guid, '36', '-8597.86', '760.438', '96.6954', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.22728', '0', '0'),
  54. (@guid, '37', '-8617.29', '751.816', '96.7137', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.71796', '0', '0'),
  55. (@guid, '38', '-8635.58', '739.17', '96.7632', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.52161', '0', '0'),
  56. (@guid, '39', '-8658.31', '763.999', '96.7304', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.3121', '0', '0'),
  57. (@guid, '40', '-8633.78', '786.469', '96.6516', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.710672', '0', '0'),
  58. (@guid, '41', '-8646.82', '832.286', '96.6354', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.84793', '0', '0'),
  59. (@guid, '42', '-8682.28', '876.787', '97.0167', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.26655', '0', '0'),
  60. (@guid, '43', '-8711.31', '859.929', '96.978', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.19115', '0', '0'),
  61. (@guid, '44', '-8722.66', '874.024', '102.549', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.30425', '0', '0'),
  62. (@guid, '45', '-8735.51', '888.845', '101.387', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.17701', '0', '0'),
  63. (@guid, '46', '-8741.93', '890.667', '101.498', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.86502', '0', '0'),
  64. (@guid, '47', '-8755.47', '890.881', '101.817', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.12577', '0', '0'),
  65. (@guid, '48', '-8772.67', '903.62', '100.571', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.54458', '0', '0'),
  66. (@guid, '49', '-8815.58', '954.474', '100.726', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.26655', '0', '0'),
  67. (@guid, '50', '-8833.28', '941.587', '104.934', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.75566', '0', '0'),
  68. (@guid, '51', '-8848.82', '930.63', '102.494', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.75566', '0', '0'),
  69. (@guid, '52', '-8856.56', '931.04', '101.945', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.14384', '0', '0'),
  70. (@guid, '53', '-8891.1', '913.623', '110.661', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.55617', '0', '0'),
  71. (@guid, '54', '-8898.57', '916.314', '112.035', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.66082', '0', '0'),
  72. (@guid, '55', '-8909.78', '934.644', '116.508', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.96103', '0', '0'),
  73. (@guid, '56', '-8936.08', '951.698', '117.113', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.03859', '0', '0'),
  74. (@guid, '57', '-8982.38', '961.137', '115.949', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.96948', '0', '0'),
  75. (@guid, '58', '-9003.53', '955.904', '110.962', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.38417', '0', '0'),
  76. (@guid, '59', '-9016.34', '931.286', '108.166', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.2324', '0', '0'),
  77. (@guid, '60', '-9006.53', '902.374', '105.766', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.03979', '0', '0'),
  78. (@guid, '61', '-8990.21', '898.444', '105.716', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.94693', '0', '0'),
  79. (@guid, '62', '-8976.55', '875.777', '106.535', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.15446', '0', '0'),
  80. (@guid, '63', '-8976.11', '855.658', '105.823', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.73348', '0', '0'),
  81. (@guid, '64', '-8988.29', '838.602', '105.83', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.0282', '0', '0'),
  82. (@guid, '65', '-8992.57', '818.509', '104.291', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.80417', '0', '0'),
  83. (@guid, '66', '-8988.58', '800.03', '102.038', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.00445', '0', '0'),
  84. (@guid, '67', '-8980.34', '783.129', '97.9284', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.66889', '0', '0'),
  85. (@guid, '68', '-8958.49', '770.706', '93.2911', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.76628', '0', '0'),
  86. (@guid, '69', '-8930.13', '774.847', '87.8644', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.160897', '0', '0'),
  87. (@guid, '70', '-8909.21', '790.266', '87.4974', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.635277', '0', '0'),
  88. (@guid, '71', '-8881.54', '756.024', '96.1996', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.39715', '0', '0'),
  89. (@guid, '72', '-8868.96', '758.685', '97.0519', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.102778', '0', '0'),
  90. (@guid, '73', '-8858.19', '743.429', '100.457', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.32725', '0', '0'),
  91. (@guid, '74', '-8847.73', '725.187', '97.3503', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.19294', '0', '0'),
  92. (@guid, '75', '-8826.08', '678.11', '97.5324', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.06571', '0', '0'),
  93. (@guid, '76', '-8851.6', '659.74', '97.0278', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.87505', '0', '0'),
  94. (@guid, '77', '-8838.36', '644.21', '95.6793', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.45605', '0', '0'),
  95. (@guid, '78', '-8816.95', '640.913', '94.2295', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6.09929', '0', '0'),
  96. (@guid, '79', '-8813.08', '632.071', '94.2295', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.1254', '0', '0'),
  97. (@guid, '80', '-8818.06', '615.229', '95.0204', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.42482', '0', '0'),
  98. (@guid, '81', '-8794.98', '589.458', '97.4722', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.4427', '0', '0'),
  99. (@guid, '82', '-8770.94', '608.788', '97.2266', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.38694', '0', '0');
  100.  
Advertisement
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!