API tools faq
paste
image

Try

image
Nov 25th, 2011
436
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 14.44 KB | None | 0 0
raw download clone embed print report
  1. -- SELECT * FROM `udb`.`creature` WHERE id IN (2330, 2331, 3504);
  2.  
  3. -- SPAWN CORRECTION
  4. UPDATE creature SET `position_x`='-8856.26', `position_y`='741.91', `position_z`='100.666', `orientation`='2.15696', `curhealth`='713', `MovementType`='2' WHERE `guid`='38932';
  5. UPDATE creature SET `position_x`='-8855.95', `position_y`='739.398', `position_z`='100.652', `orientation`='2.15696', `curhealth`='42' WHERE `id`='2331';
  6. UPDATE creature SET `position_x`='-8854.86', `position_y`='740.935', `position_z`='100.705', `orientation`='2.15696', `curhealth`='42' WHERE `id`='3504';
  7.  
  8. -- TEMPLATE
  9. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "713", `maxhealth` = "713", `armor` = "1014", `speed_walk` = "1", `maxdmg` = "47", `attackpower` = "12", `dmg_multiplier` = "0.9", `baseattacktime` = "2000", `rangeattacktime` = "2000", `minrangedmg` = "25", `maxrangedmg` = "38", `rangedattackpower` = "10", `mingold` = "0", `maxgold` = "0" WHERE entry=2330;
  10. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "42", `maxhealth` = "42", `armor` = "17", `speed_walk` = "1", `mindmg` = "1", `maxdmg` = "2", `attackpower` = "0", `rangeattacktime` = "2000", `unit_flags` = "768", `minrangedmg` = "1", `maxrangedmg` = "2", `rangedattackpower` = "0", `maxgold` = "0" WHERE entry=2331;
  11. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "1", `maxlevel` = "1", `minhealth` = "42", `maxhealth` = "42", `armor` = "17", `faction_A` = "12", `faction_H` = "12", `speed_walk` = "1", `mindmg` = "1", `maxdmg` = "2", `attackpower` = "0", `rangeattacktime` = "2000", `unit_flags` = "768", `minrangedmg` = "1", `maxrangedmg` = "2", `rangedattackpower` = "0" WHERE entry=3504;
  12.  
  13. -- KARLEE CHADDIS' MOVEMENT
  14. DELETE FROM `creature_movement` WHERE `id`='38932';
  15. 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`)
  16. VALUES
  17. ('38932', '1', '-8856.26', '741.91', '100.666', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.15696', '0', '0'),
  18. ('38932', '2', '-8860.26', '747.938', '99.9222', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.15696', '0', '0'),
  19. ('38932', '3', '-8866.15', '756.326', '97.8264', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.16089', '0', '0'),
  20. ('38932', '4', '-8870.51', '760.372', '96.7027', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.45148', '0', '0'),
  21. ('38932', '5', '-8879.54', '756.138', '96.2687', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.91262', '0', '0'),
  22. ('38932', '6', '-8883.45', '758.191', '95.4731', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.48536', '0', '0'),
  23. ('38932', '7', '-8907.48', '788.261', '87.7863', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.23875', '0', '0'),
  24. ('38932', '8', '-8906.29', '794.423', '87.3173', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.03552', '0', '0'),
  25. ('38932', '9', '-8899.1', '801.189', '87.6105', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.905926', '0', '0'),
  26. ('38932', '10', '-8899.88', '815.041', '89.3389', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.61278', '0', '0'),
  27. ('38932', '11', '-8899.09', '826.687', '92.5864', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.612', '0', '0'),
  28. ('38932', '12', '-8905.65', '841.38', '95.4271', '4000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.0691', '0', '0'),
  29. ('38932', '13', '-8905.3', '845.868', '95.7969', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.25386', '0', '0'),
  30. ('38932', '14', '-8898.15', '863.912', '96.2546', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.15097', '0', '0'),
  31. ('38932', '15', '-8893.39', '873.065', '98.9773', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.18867', '0', '0'),
  32. ('38932', '16', '-8888.58', '889.208', '102.944', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.23108', '0', '0'),
  33. ('38932', '17', '-8888.8', '897.531', '105.943', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.85783', '0', '0'),
  34. ('38932', '18', '-8896.33', '913.303', '110.988', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.08559', '0', '0'),
  35. ('38932', '19', '-8904.33', '926.304', '114.899', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.1657', '0', '0'),
  36. ('38932', '20', '-8919.41', '948.481', '117.337', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.38247', '0', '0'),
  37. ('38932', '21', '-8966.43', '954.028', '117.362', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.01629', '0', '0'),
  38. ('38932', '22', '-8982.42', '966.381', '116.043', '4000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.73433', '0', '0'),
  39. ('38932', '23', '-8999.42', '964.996', '116.326', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.39643', '0', '0'),
  40. ('38932', '24', '-9012.36', '953.626', '116.256', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.26115', '0', '0'),
  41. ('38932', '25', '-9008.41', '945.283', '116.895', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.53821', '0', '0'),
  42. ('38932', '26', '-9000.86', '940.914', '117.094', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.82645', '0', '0'),
  43. ('38932', '27', '-8998.38', '939.901', '117.094', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.91284', '0', '0'),
  44. ('38932', '28', '-8996.34', '945.169', '117.097', '5000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.17061', '0', '0'),
  45. ('38932', '29', '-8996.34', '945.169', '117.097', '5000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.17061', '0', '0'),
  46. ('38932', '30', '-8996.34', '945.169', '117.097', '1500', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.17061', '0', '0'),
  47. ('38932', '31', '-8999.05', '940.572', '117.096', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.25251', '0', '0'),
  48. ('38932', '32', '-9002.62', '941.706', '117.095', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.66993', '0', '0'),
  49. ('38932', '33', '-9012.38', '947.61', '116.227', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.48301', '0', '0'),
  50. ('38932', '34', '-9012.45', '951.694', '116.246', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.07008', '0', '0'),
  51. ('38932', '35', '-9004.83', '961.988', '116.276', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.834459', '0', '0'),
  52. ('38932', '36', '-8998.64', '965.802', '116.292', '4000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.086759', '0', '0'),
  53. ('38932', '37', '-8983.94', '966.422', '116.028', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.063197', '0', '0'),
  54. ('38932', '38', '-8980.01', '965.284', '116.256', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.80289', '0', '0'),
  55. ('38932', '39', '-8957.87', '953.377', '117.299', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.77933', '0', '0'),
  56. ('38932', '40', '-8920.67', '947.641', '117.337', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6.1304', '0', '0'),
  57. ('38932', '41', '-8900.95', '920.6', '113.443', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.2806', '0', '0'),
  58. ('38932', '42', '-8894.54', '911.478', '110.762', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.551718', '0', '0'),
  59. ('38932', '43', '-8877.53', '920.808', '107.603', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.508521', '0', '0'),
  60. ('38932', '44', '-8854.97', '933.374', '101.999', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.508521', '0', '0'),
  61. ('38932', '45', '-8848.88', '930.711', '102.495', '3000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.572924', '0', '0'),
  62. ('38932', '46', '-8834.61', '940.936', '105.143', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.576851', '0', '0'),
  63. ('38932', '47', '-8818.28', '953.205', '100.678', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.576065', '0', '0'),
  64. ('38932', '48', '-8815.14', '952.722', '100.867', '4000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.93091', '0', '0'),
  65. ('38932', '49', '-8804.01', '942.261', '101.241', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.612193', '0', '0'),
  66. ('38932', '50', '-8802.37', '936.981', '101.242', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.3827', '0', '0'),
  67. ('38932', '51', '-8777.24', '909.299', '100.262', '3000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.43768', '0', '0'),
  68. ('38932', '52', '-8766.76', '893.892', '101.386', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.57355', '0', '0'),
  69. ('38932', '53', '-8737.03', '892.761', '101.221', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6.22072', '0', '0'),
  70. ('38932', '54', '-8731.93', '886.272', '101.744', '3000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.39605', '0', '0'),
  71. ('38932', '55', '-8723.13', '875.04', '102.678', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.39605', '0', '0'),
  72. ('38932', '56', '-8712.31', '861.661', '97.2752', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.39605', '0', '0'),
  73. ('38932', '57', '-8712.2', '853.618', '96.8655', '3000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.39388', '0', '0'),
  74. ('38932', '58', '-8725.87', '834.533', '96.149', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.1614', '0', '0'),
  75. ('38932', '59', '-8726.58', '813.587', '97.0276', '4000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.89182', '0', '0'),
  76. ('38932', '60', '-8717.15', '795.784', '97.0391', '4000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.9201', '0', '0'),
  77. ('38932', '61', '-8721.79', '782.622', '97.8839', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.11114', '0', '0'),
  78. ('38932', '62', '-8732.2', '766.047', '98.0898', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.3444', '0', '0'),
  79. ('38932', '63', '-8724.93', '751.443', '98.2043', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.41804', '0', '0'),
  80. ('38932', '64', '-8713.3', '732.548', '97.8146', '4000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.42668', '0', '0'),
  81. ('38932', '65', '-8699.05', '715.705', '97.0168', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.42668', '0', '0'),
  82. ('38932', '66', '-8661.63', '744.699', '96.6531', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.754345', '0', '0'),
  83. ('38932', '67', '-8660.26', '765.872', '96.6997', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.31041', '0', '0'),
  84. ('38932', '68', '-8634.36', '787.361', '96.6525', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.685231', '0', '0'),
  85. ('38932', '69', '-8632.43', '787.372', '96.6512', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.394633', '0', '0'),
  86. ('38932', '70', '-8606.16', '761.17', '96.7387', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.49894', '0', '0'),
  87. ('38932', '71', '-8592.08', '756.77', '96.651', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.91598', '0', '0'),
  88. ('38932', '72', '-8579.7', '737.671', '96.7114', '4000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.61379', '0', '0'),
  89. ('38932', '73', '-8594.53', '717.706', '96.6514', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.03574', '0', '0'),
  90. ('38932', '74', '-8581.67', '697.638', '97.0168', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.41254', '0', '0'),
  91. ('38932', '75', '-8561.08', '673.827', '97.0168', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.603542', '0', '0'),
  92. ('38932', '76', '-8536.53', '690.079', '97.6665', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.39731', '0', '0'),
  93. ('38932', '77', '-8528.41', '679.123', '100.793', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.3439', '0', '0'),
  94. ('38932', '78', '-8517.6', '662.84', '102.123', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.3439', '0', '0'),
  95. ('38932', '79', '-8510.36', '651.605', '100.292', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.24573', '0', '0'),
  96. ('38932', '80', '-8516.68', '643.439', '100.134', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.75426', '0', '0'),
  97. ('38932', '81', '-8557.25', '615.273', '102.337', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.42125', '0', '0'),
  98. ('38932', '82', '-8563.65', '615.408', '102.278', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.78646', '0', '0'),
  99. ('38932', '83', '-8583.79', '586.194', '103.594', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.3598', '0', '0'),
  100. ('38932', '84', '-8584.4', '560.743', '101.871', '4000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.1397', '0', '0'),
  101. ('38932', '85', '-8578.23', '543.501', '101.782', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.81238', '0', '0'),
  102. ('38932', '86', '-8593.35', '530.953', '105.659', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.80845', '0', '0'),
  103. ('38932', '87', '-8609.85', '515.571', '103.841', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.97025', '0', '0'),
  104. ('38932', '88', '-8616.86', '517.629', '103.218', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.3162', '0', '0'),
  105. ('38932', '89', '-8657.5', '553.006', '96.9502', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.64214', '0', '0'),
  106. ('38932', '90', '-8673.57', '552.873', '97.2864', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.2249', '0', '0'),
  107. ('38932', '91', '-8713.67', '519.808', '97.1597', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.19446', '0', '0'),
  108. ('38932', '92', '-8717.22', '524.985', '98.1892', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.27221', '0', '0'),
  109. ('38932', '93', '-8745.36', '557.023', '97.6718', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.37371', '0', '0'),
  110. ('38932', '94', '-8745', '566.133', '97.4006', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.01418', '0', '0'),
  111. ('38932', '95', '-8738.14', '576.508', '97.5043', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.44518', '0', '0'),
  112. ('38932', '96', '-8769.94', '608.175', '97.1405', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.38706', '0', '0'),
  113. ('38932', '97', '-8795.54', '589.658', '97.4546', '4000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.33208', '0', '0'),
  114. ('38932', '98', '-8832.6', '630.401', '94.0918', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.28496', '0', '0'),
  115. ('38932', '99', '-8851.55', '661.112', '97.1319', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.659181', '0', '0'),
  116. ('38932', '100', '-8824.74', '678.622', '97.5366', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.97629', '0', '0'),
  117. ('38932', '101', '-8847.34', '726.835', '97.6974', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.05091', '0', '0');
  118.  
  119. -- CREATURE LINKING
  120. DELETE FROM `creature_linking_template` WHERE `entry` IN ('2331', '3504');
  121. INSERT INTO `creature_linking_template` (`entry`, `map`, `master_entry`, `flag`)
  122. VALUES
  123. ('2331', '0', '2330', '512'),
  124. ('3504', '0', '2330', '512');
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!