API tools faq
paste
image

Donna & William

image
Nov 25th, 2011
348
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 24.89 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM creature_template_addon WHERE entry IN (2532, 2533);
  2. INSERT INTO creature_template_addon (`entry`, `mount`, `bytes1`, `b2_0_sheath`, `b2_1_pvp_state`, `emote`, `moveflags`, `auras`)
  3. VALUES
  4. ('2532', '0', '0', '0', '0', '0', '0', ''),
  5. ('2533', '0', '0', '0', '0', '0', '0', '');
  6.  
  7. -- DONNA
  8. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "42", `maxhealth` = "42", `armor` = "17", `mindmg` = "1", `maxdmg` = "2", `attackpower` = "0", `rangeattacktime` = "2000", `minrangedmg` = "1", `maxrangedmg` = "2", `rangedattackpower` = "0", `maxgold` = "0" WHERE entry=2532;
  9. UPDATE creature SET `position_x`='-8744.68', `position_y`='556.069', `position_z`='97.9521', `orientation`='5.45979', `curhealth`='42', `MovementType`='2' WHERE `guid`='75574';
  10.  
  11. -- MOVEMENT
  12. DELETE FROM creature_movement WHERE id=75574;
  13. 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`)
  14. VALUES
  15. ('75574', '1', '-8731.58', '541.932', '101.111', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.45979', '0', '0'),
  16. ('75574', '2', '-8720.52', '529.999', '99.3708', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.45979', '0', '0'),
  17. ('75574', '3', '-8716.57', '522.528', '97.612', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.19904', '0', '0'),
  18. ('75574', '4', '-8710.38', '522.662', '97.4771', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.021693', '0', '0'),
  19. ('75574', '5', '-8703.03', '528.912', '97.669', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.410465', '0', '0'),
  20. ('75574', '6', '-8685.83', '539.951', '97.7841', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.570687', '0', '0'),
  21. ('75574', '7', '-8679.19', '551.407', '97.4845', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.04507', '0', '0'),
  22. ('75574', '8', '-8663.87', '554.612', '96.8751', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.206262', '0', '0'),
  23. ('75574', '9', '-8651.75', '548.373', '96.9836', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.80772', '0', '0'),
  24. ('75574', '10', '-8638.92', '537.941', '99.4104', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.60038', '0', '0'),
  25. ('75574', '11', '-8629.57', '534.889', '100.717', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.96794', '0', '0'),
  26. ('75574', '12', '-8616.79', '517.027', '103.246', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.33334', '0', '0'),
  27. ('75574', '13', '-8610.89', '516.332', '103.775', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6.16586', '0', '0'),
  28. ('75574', '14', '-8600.68', '525.372', '106.517', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.724625', '0', '0'),
  29. ('75574', '15', '-8582.68', '540.197', '102.279', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.674359', '0', '0'),
  30. ('75574', '16', '-8582.6', '557.728', '101.851', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.56657', '0', '0'),
  31. ('75574', '17', '-8588.54', '571.377', '102.515', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.98126', '0', '0'),
  32. ('75574', '18', '-8582.75', '582.445', '103.492', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.08905', '0', '0'),
  33. ('75574', '19', '-8581.09', '596.986', '103.326', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.45662', '0', '0'),
  34. ('75574', '20', '-8572.61', '609.681', '102.628', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.982235', '0', '0'),
  35. ('75574', '21', '-8554.31', '617.579', '102.079', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.407324', '0', '0'),
  36. ('75574', '22', '-8547.34', '628.095', '100.969', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.985377', '0', '0'),
  37. ('75574', '23', '-8524.76', '636.519', '99.995', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.357058', '0', '0'),
  38. ('75574', '24', '-8514.57', '643.758', '100.198', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.61781', '0', '0'),
  39. ('75574', '25', '-8512.06', '652.878', '100.291', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.30268', '0', '0'),
  40. ('75574', '26', '-8521.83', '666.528', '102.661', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.19175', '0', '0'),
  41. ('75574', '27', '-8535.99', '686.327', '97.6789', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.19175', '0', '0'),
  42. ('75574', '28', '-8544.53', '685.475', '97.5076', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.24104', '0', '0'),
  43. ('75574', '29', '-8564.66', '672.461', '97.0156', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.71542', '0', '0'),
  44. ('75574', '30', '-8573.9', '661.108', '97.5108', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.02958', '0', '0'),
  45. ('75574', '31', '-8592.18', '657.221', '98.1965', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.351', '0', '0'),
  46. ('75574', '32', '-8604.52', '656.575', '98.7059', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.19392', '0', '0'),
  47. ('75574', '33', '-8620.36', '652.313', '99.1877', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.4044', '0', '0'),
  48. ('75574', '34', '-8644.6', '658.89', '101.207', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.87662', '0', '0'),
  49. ('75574', '35', '-8655.94', '660.699', '100.858', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.98343', '0', '0'),
  50. ('75574', '36', '-8668.29', '676.294', '99.6044', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.29464', '0', '0'),
  51. ('75574', '37', '-8671.98', '683.76', '98.8546', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.03074', '0', '0'),
  52. ('75574', '38', '-8705.22', '725.675', '97.1356', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.24123', '0', '0'),
  53. ('75574', '39', '-8714.54', '732.607', '97.8152', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.50198', '0', '0'),
  54. ('75574', '40', '-8729.44', '723.121', '101.552', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.70835', '0', '0'),
  55. ('75574', '41', '-8742.16', '710.686', '98.2678', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.9157', '0', '0'),
  56. ('75574', '42', '-8738.48', '700.884', '98.718', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.07181', '0', '0'),
  57. ('75574', '43', '-8752.58', '688.263', '100.448', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.87172', '0', '0'),
  58. ('75574', '44', '-8773.14', '671.75', '103.092', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.81831', '0', '0'),
  59. ('75574', '45', '-8774.24', '667.734', '103.092', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.44349', '0', '0'),
  60. ('75574', '46', '-8762.72', '649.633', '103.733', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.27915', '0', '0'),
  61. ('75574', '47', '-8759.08', '635.326', '102.912', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.96185', '0', '0'),
  62. ('75574', '48', '-8758.8', '629.108', '102.25', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.4482', '0', '0'),
  63. ('75574', '49', '-8761.79', '618.03', '99.275', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.4482', '0', '0'),
  64. ('75574', '50', '-8792.64', '593.169', '97.6035', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.81988', '0', '0'),
  65. ('75574', '51', '-8801.18', '592.338', '97.3394', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.23869', '0', '0'),
  66. ('75574', '52', '-8816.1', '613.304', '95.2455', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.18939', '0', '0'),
  67. ('75574', '53', '-8828.86', '627.785', '94.0444', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.29307', '0', '0'),
  68. ('75574', '54', '-8826.57', '637.878', '94.243', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.34745', '0', '0'),
  69. ('75574', '55', '-8818.02', '645.358', '94.2658', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.719127', '0', '0'),
  70. ('75574', '56', '-8811.9', '638.996', '94.2287', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.47864', '0', '0'),
  71. ('75574', '57', '-8812.1', '630.047', '94.2287', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.6901', '0', '0'),
  72. ('75574', '58', '-8824.53', '623.322', '93.8413', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.63767', '0', '0'),
  73. ('75574', '59', '-8837.91', '642.898', '95.4907', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.17054', '0', '0'),
  74. ('75574', '60', '-8851.59', '652.393', '96.44', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.53497', '0', '0'),
  75. ('75574', '61', '-8847.92', '662.602', '97.4256', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.22492', '0', '0'),
  76. ('75574', '62', '-8830.06', '673.308', '98.2819', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.540053', '0', '0'),
  77. ('75574', '63', '-8826.73', '680.102', '97.2982', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.11496', '0', '0'),
  78. ('75574', '64', '-8833.85', '697.773', '97.5546', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.95377', '0', '0'),
  79. ('75574', '65', '-8840.87', '711.413', '97.5676', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.10928', '0', '0'),
  80. ('75574', '66', '-8840.99', '722.775', '97.3683', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.58149', '0', '0'),
  81. ('75574', '67', '-8826.64', '729.331', '98.4387', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.428527', '0', '0'),
  82. ('75574', '68', '-8816.81', '738.407', '97.9223', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.745828', '0', '0'),
  83. ('75574', '69', '-8793.3', '743.694', '98.3306', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.221182', '0', '0'),
  84. ('75574', '70', '-8768.96', '740.105', '99.1632', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6.1368', '0', '0'),
  85. ('75574', '71', '-8759.32', '727.137', '98.2857', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.3514', '0', '0'),
  86. ('75574', '72', '-8731.58', '697.112', '98.6319', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.45822', '0', '0'),
  87. ('75574', '73', '-8730.4', '687.347', '98.7743', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.83304', '0', '0'),
  88. ('75574', '74', '-8723.18', '673.754', '98.6213', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.20061', '0', '0'),
  89. ('75574', '75', '-8714.73', '664.722', '98.9638', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.4645', '0', '0'),
  90. ('75574', '76', '-8706.44', '635.994', '100.299', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.99326', '0', '0'),
  91. ('75574', '77', '-8705.95', '611.391', '99.9666', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.73251', '0', '0'),
  92. ('75574', '78', '-8711.1', '594.366', '98.6165', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.41835', '0', '0'),
  93. ('75574', '79', '-8720.06', '591.749', '98.5704', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.42561', '0', '0'),
  94. ('75574', '80', '-8734.96', '576.142', '97.4009', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.95025', '0', '0'),
  95. ('75574', '81', '-8743.7', '570.146', '97.382', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.74291', '0', '0'),
  96. ('75574', '82', '-8747.05', '560.624', '97.4024', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.37437', '0', '0');
  97.  
  98. -- SPEECH
  99. DELETE FROM db_script_string WHERE entry IN (2000005078, 2000005079, 2000005080, 2000005081, 2000005082, 2000005083, 2000005084, 2000005085);
  100. INSERT INTO db_script_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`)
  101. VALUES
  102. ('2000005078', 'WAAAHHH!', '', '', '', '', '', '', '', ''),
  103. ('2000005079', 'Gimmie my dolly!!', '', '', '', '', '', '', '', ''),
  104. ('2000005080', 'I\'m telling Mommy!', '', '', '', '', '', '', '', ''),
  105. ('2000005081', 'You\'re hurting her!', '', '', '', '', '', '', '', ''),
  106. ('2000005082', 'Betsy! Give me Betsy back!', '', '', '', '', '', '', '', ''),
  107. ('2000005083', 'Stop pulling her hair out!', '', '', '', '', '', '', '', ''),
  108. ('2000005084', 'Don\'t hurt Betsy, you meanie!', '', '', '', '', '', '', '', ''),
  109. ('2000005085', 'Stop! You\'ll pull her head off!', '', '', '', '', '', '', '', '');
  110.  
  111.  
  112. UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '2532';
  113. DELETE FROM `creature_ai_scripts` WHERE `creature_id` = '2532';
  114. 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`) VALUES
  115. ('2532', '1', '0', '100', '0', '0', '0', '25000', '25000', '1', '2000005078', '2000005079', '2000005080', '1', '2000005081', '2000005082', '2000005083', '1', '2000005084', '2000005085', '0', 'Donna - Random Text');
  116.  
  117.  
  118.  
  119. -- WILLIAM
  120. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "42", `maxhealth` = "42", `minmana` = "0", `maxmana` = "0", `armor` = "17", `mindmg` = "1", `maxdmg` = "2", `attackpower` = "0", `rangeattacktime` = "2000", `minrangedmg` = "1", `maxrangedmg` = "2", `rangedattackpower` = "0", `maxgold` = "0" WHERE entry=2533;
  121. UPDATE creature SET `position_x`='-8739.04', `position_y`='549.987', `position_z`='100.173', `orientation`='5.45979', `curhealth`='42', `MovementType`='2' WHERE `guid`='75575';
  122.  
  123. -- MOVEMENT
  124. DELETE FROM creature_movement WHERE id=75575;
  125. 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`)
  126. VALUES
  127. ('75575', '1', '-8731.58', '541.932', '101.111', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.45979', '0', '0'),
  128. ('75575', '2', '-8720.52', '529.999', '99.3708', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.45979', '0', '0'),
  129. ('75575', '3', '-8716.57', '522.528', '97.612', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.19904', '0', '0'),
  130. ('75575', '4', '-8710.38', '522.662', '97.4771', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.021693', '0', '0'),
  131. ('75575', '5', '-8703.03', '528.912', '97.669', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.410465', '0', '0'),
  132. ('75575', '6', '-8685.83', '539.951', '97.7841', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.570687', '0', '0'),
  133. ('75575', '7', '-8679.19', '551.407', '97.4845', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.04507', '0', '0'),
  134. ('75575', '8', '-8663.87', '554.612', '96.8751', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.206262', '0', '0'),
  135. ('75575', '9', '-8651.75', '548.373', '96.9836', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.80772', '0', '0'),
  136. ('75575', '10', '-8638.92', '537.941', '99.4104', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.60038', '0', '0'),
  137. ('75575', '11', '-8629.57', '534.889', '100.717', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.96794', '0', '0'),
  138. ('75575', '12', '-8616.79', '517.027', '103.246', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.33334', '0', '0'),
  139. ('75575', '13', '-8610.89', '516.332', '103.775', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6.16586', '0', '0'),
  140. ('75575', '14', '-8600.68', '525.372', '106.517', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.724625', '0', '0'),
  141. ('75575', '15', '-8582.68', '540.197', '102.279', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.674359', '0', '0'),
  142. ('75575', '16', '-8582.6', '557.728', '101.851', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.56657', '0', '0'),
  143. ('75575', '17', '-8588.54', '571.377', '102.515', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.98126', '0', '0'),
  144. ('75575', '18', '-8582.75', '582.445', '103.492', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.08905', '0', '0'),
  145. ('75575', '19', '-8581.09', '596.986', '103.326', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.45662', '0', '0'),
  146. ('75575', '20', '-8572.61', '609.681', '102.628', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.982235', '0', '0'),
  147. ('75575', '21', '-8554.31', '617.579', '102.079', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.407324', '0', '0'),
  148. ('75575', '22', '-8547.34', '628.095', '100.969', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.985377', '0', '0'),
  149. ('75575', '23', '-8524.76', '636.519', '99.995', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.357058', '0', '0'),
  150. ('75575', '24', '-8514.57', '643.758', '100.198', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.61781', '0', '0'),
  151. ('75575', '25', '-8512.06', '652.878', '100.291', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.30268', '0', '0'),
  152. ('75575', '26', '-8521.83', '666.528', '102.661', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.19175', '0', '0'),
  153. ('75575', '27', '-8535.99', '686.327', '97.6789', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.19175', '0', '0'),
  154. ('75575', '28', '-8544.53', '685.475', '97.5076', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.24104', '0', '0'),
  155. ('75575', '29', '-8564.66', '672.461', '97.0156', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.71542', '0', '0'),
  156. ('75575', '30', '-8573.9', '661.108', '97.5108', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.02958', '0', '0'),
  157. ('75575', '31', '-8592.18', '657.221', '98.1965', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.351', '0', '0'),
  158. ('75575', '32', '-8604.52', '656.575', '98.7059', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.19392', '0', '0'),
  159. ('75575', '33', '-8620.36', '652.313', '99.1877', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.4044', '0', '0'),
  160. ('75575', '34', '-8644.6', '658.89', '101.207', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.87662', '0', '0'),
  161. ('75575', '35', '-8655.94', '660.699', '100.858', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.98343', '0', '0'),
  162. ('75575', '36', '-8668.29', '676.294', '99.6044', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.29464', '0', '0'),
  163. ('75575', '37', '-8671.98', '683.76', '98.8546', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.03074', '0', '0'),
  164. ('75575', '38', '-8705.22', '725.675', '97.1356', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.24123', '0', '0'),
  165. ('75575', '39', '-8714.54', '732.607', '97.8152', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.50198', '0', '0'),
  166. ('75575', '40', '-8729.44', '723.121', '101.552', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.70835', '0', '0'),
  167. ('75575', '41', '-8742.16', '710.686', '98.2678', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.9157', '0', '0'),
  168. ('75575', '42', '-8738.48', '700.884', '98.718', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.07181', '0', '0'),
  169. ('75575', '43', '-8752.58', '688.263', '100.448', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.87172', '0', '0'),
  170. ('75575', '44', '-8773.14', '671.75', '103.092', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.81831', '0', '0'),
  171. ('75575', '45', '-8774.24', '667.734', '103.092', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.44349', '0', '0'),
  172. ('75575', '46', '-8762.72', '649.633', '103.733', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.27915', '0', '0'),
  173. ('75575', '47', '-8759.08', '635.326', '102.912', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.96185', '0', '0'),
  174. ('75575', '48', '-8758.8', '629.108', '102.25', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.4482', '0', '0'),
  175. ('75575', '49', '-8761.79', '618.03', '99.275', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.4482', '0', '0'),
  176. ('75575', '50', '-8792.64', '593.169', '97.6035', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.81988', '0', '0'),
  177. ('75575', '51', '-8801.18', '592.338', '97.3394', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.23869', '0', '0'),
  178. ('75575', '52', '-8816.1', '613.304', '95.2455', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.18939', '0', '0'),
  179. ('75575', '53', '-8828.86', '627.785', '94.0444', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.29307', '0', '0'),
  180. ('75575', '54', '-8826.57', '637.878', '94.243', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.34745', '0', '0'),
  181. ('75575', '55', '-8818.02', '645.358', '94.2658', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.719127', '0', '0'),
  182. ('75575', '56', '-8811.9', '638.996', '94.2287', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.47864', '0', '0'),
  183. ('75575', '57', '-8812.1', '630.047', '94.2287', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.6901', '0', '0'),
  184. ('75575', '58', '-8824.53', '623.322', '93.8413', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.63767', '0', '0'),
  185. ('75575', '59', '-8837.91', '642.898', '95.4907', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.17054', '0', '0'),
  186. ('75575', '60', '-8851.59', '652.393', '96.44', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.53497', '0', '0'),
  187. ('75575', '61', '-8847.92', '662.602', '97.4256', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.22492', '0', '0'),
  188. ('75575', '62', '-8830.06', '673.308', '98.2819', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.540053', '0', '0'),
  189. ('75575', '63', '-8826.73', '680.102', '97.2982', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.11496', '0', '0'),
  190. ('75575', '64', '-8833.85', '697.773', '97.5546', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.95377', '0', '0'),
  191. ('75575', '65', '-8840.86', '711.403', '97.5683', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.10928', '0', '0'),
  192. ('75575', '66', '-8840.99', '722.775', '97.3683', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.58149', '0', '0'),
  193. ('75575', '67', '-8826.64', '729.331', '98.4387', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.428527', '0', '0'),
  194. ('75575', '68', '-8816.81', '738.407', '97.9223', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.745828', '0', '0'),
  195. ('75575', '69', '-8793.3', '743.694', '98.3306', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.221182', '0', '0'),
  196. ('75575', '70', '-8768.96', '740.105', '99.1632', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6.1368', '0', '0'),
  197. ('75575', '71', '-8759.32', '727.137', '98.2857', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.3514', '0', '0'),
  198. ('75575', '72', '-8731.58', '697.112', '98.6319', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.45822', '0', '0'),
  199. ('75575', '73', '-8730.4', '687.347', '98.7743', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.83304', '0', '0'),
  200. ('75575', '74', '-8723.18', '673.754', '98.6213', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.20061', '0', '0'),
  201. ('75575', '75', '-8714.73', '664.722', '98.9638', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.4645', '0', '0'),
  202. ('75575', '76', '-8706.44', '635.994', '100.299', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.99326', '0', '0'),
  203. ('75575', '77', '-8705.95', '611.391', '99.9666', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.73251', '0', '0'),
  204. ('75575', '78', '-8711.1', '594.366', '98.6165', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.41835', '0', '0'),
  205. ('75575', '79', '-8720.06', '591.749', '98.5704', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.42561', '0', '0'),
  206. ('75575', '80', '-8734.96', '576.142', '97.4009', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.95025', '0', '0'),
  207. ('75575', '81', '-8743.7', '570.146', '97.382', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.74291', '0', '0'),
  208. ('75575', '82', '-8747.05', '560.624', '97.4024', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.37437', '0', '0');
  209.  
  210. -- SPEECH
  211. DELETE FROM db_script_string WHERE entry IN (2000005057, 2000005058, 2000005059, 2000005060, 2000005061, 2000005062, 2000005063, 2000005064);
  212. INSERT INTO db_script_string (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`)
  213. VALUES
  214. ('2000005057', 'Oops!', '', '', '', '', '', '', '', ''),
  215. ('2000005058', 'Crybaby! Crybaby!', '', '', '', '', '', '', '', ''),
  216. ('2000005059', 'Ha ha! I have Betsy!', '', '', '', '', '', '', '', ''),
  217. ('2000005060', 'Baby wants her dolly!', '', '', '', '', '', '', '', ''),
  218. ('2000005061', 'What happens when I do this?', '', '', '', '', '', '', '', ''),
  219. ('2000005062', 'I have your dolly! Nyah nyah!', '', '', '', '', '', '', '', ''),
  220. ('2000005063', 'I wonder if your dolly can swim!', '', '', '', '', '', '', '', ''),
  221. ('2000005064', 'If you want her back you\'re gonna have to beg!', '', '', '', '', '', '', '', '');
  222.  
  223. UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '2533';
  224. DELETE FROM `creature_ai_scripts` WHERE `creature_id` = '2533';
  225. 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`) VALUES
  226. ('2533', '1', '0', '100', '1', '0', '0', '25000', '25000', '1', '2000005057', '2000005058', '2000005059', '1', '2000005060', '2000005061', '2000005062', '1', '2000005063', '2000005064', '0', 'William - Random Say');
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!