API tools faq
paste
image

Miss Danna and the lil' kids

image
Nov 25th, 2011
489
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 14.67 KB | None | 0 0
raw download clone embed print report
  1. -- SPAWN CORRECTION
  2. UPDATE creature SET `position_x`='-8838.52', `position_y`='670.28', `position_z`='98.0987', `orientation`='0.553153', `curhealth`='713', `MovementType`='2' WHERE `guid`='75622';
  3. UPDATE creature SET `position_x`='-8838.57', `position_y`='667.07', `position_z`='98.0103', `orientation`='0.553137', `curhealth`='42' WHERE `guid`='38929'; -- 3505
  4. UPDATE creature SET `position_x`='-8840.46', `position_y`='666.881', `position_z`='97.9108', `orientation`='0.553158', `curhealth`='42' WHERE `guid`='75617'; -- 3507
  5. UPDATE creature SET `position_x`='-8841.74', `position_y`='670.394', `position_z`='97.9404', `orientation`='0.629918', `curhealth`='42' WHERE `guid`='75618'; -- 3508
  6. UPDATE creature SET `position_x`='-8839.57', `position_y`='666.843', `position_z`='97.9588', `orientation`='0.474919', `curhealth`='42' WHERE `guid`='75619'; -- 3509
  7. UPDATE creature SET `position_x`='-8841.32', `position_y`='667.768', `position_z`='97.8914', `orientation`='0.553006', `curhealth`='42' WHERE `guid`='75620'; -- 3510
  8. UPDATE creature SET `map`='0', `position_x`='-8841.58', `position_y`='669.168', `position_z`='97.9151', `orientation`='0.55451', `curhealth`='42' WHERE `guid`='25908'; -- 3511
  9. UPDATE creature SET `position_x`='-8841.64', `position_y`='671.515', `position_z`='97.9739', `orientation`='0.556232', `curhealth`='42' WHERE `guid`='75621'; -- 3512
  10.  
  11. -- TEMPLATE
  12. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "713", `maxhealth` = "713", `armor` = "1014", `speed_walk` = "1", `maxdmg` = "47", `attackpower` = "12", `baseattacktime` = "2000", `rangeattacktime` = "2000", `unit_flags` = "768", `minrangedmg` = "25", `maxrangedmg` = "38", `rangedattackpower` = "10", `mingold` = "0", `maxgold` = "0" WHERE entry=3513;
  13. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "1", `maxlevel` = "1", `minhealth` = "42", `maxhealth` = "42", `armor` = "17", `faction_A` = "12", `faction_H` = "12", `mindmg` = "1", `maxdmg` = "2", `attackpower` = "0", `rangeattacktime` = "2000", `minrangedmg` = "1", `maxrangedmg` = "2", `rangedattackpower` = "0" WHERE entry=3505;
  14. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "1", `maxlevel` = "1", `minhealth` = "42", `maxhealth` = "42", `armor` = "17", `mindmg` = "1", `maxdmg` = "2", `attackpower` = "0", `rangeattacktime` = "2000", `minrangedmg` = "1", `maxrangedmg` = "2", `rangedattackpower` = "0" WHERE entry=3507;
  15. 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=3508;
  16. UPDATE creature_template SET `modelid3` = "0", `minlevel` = "1", `maxlevel` = "1", `minhealth` = "42", `maxhealth` = "42", `armor` = "17", `faction_A` = "12", `faction_H` = "12", `mindmg` = "1", `maxdmg` = "2", `attackpower` = "0", `rangeattacktime` = "2000", `minrangedmg` = "1", `maxrangedmg` = "2", `rangedattackpower` = "0" WHERE entry=3509;
  17. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "40", `maxhealth` = "40", `armor` = "14", `mindmg` = "1", `maxdmg` = "2", `attackpower` = "0", `rangeattacktime` = "2000", `minrangedmg` = "1", `maxrangedmg` = "2", `rangedattackpower` = "0", `maxgold` = "0" WHERE entry=3510;
  18. 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", `MovementType` = "1", `flags_extra` = "0" WHERE entry=3511;
  19. 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=3512;
  20. UPDATE creature_template SET `speed_walk` = "1.05" WHERE entry IN ('3505', '3507', '3508', '3509', '3510', '3511', '3512', '3513');
  21.  
  22. -- MISS DANNA'S MOVEMENT
  23. DELETE FROM `creature_movement` WHERE `id`='75622';
  24. 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`)
  25. VALUES
  26. ('75622', '1', '-8824.65', '677.359', '97.6724', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.475434', '0', '0'),
  27. ('75622', '2', '-8844.06', '721.315', '97.3127', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.88051', '0', '0'),
  28. ('75622', '3', '-8794.66', '745.738', '97.8358', '2500', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.461308', '0', '0'),
  29. ('75622', '4', '-8765.71', '737.339', '98.9571', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.97089', '0', '0'),
  30. ('75622', '5', '-8744.1', '711.742', '98.1589', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.41954', '0', '0'),
  31. ('75622', '6', '-8736.13', '717.57', '101.035', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.689092', '0', '0'),
  32. ('75622', '7', '-8714.09', '735.726', '97.8129', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.689092', '0', '0'),
  33. ('75622', '8', '-8698.83', '714.642', '97.0168', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.37793', '0', '0'),
  34. ('75622', '9', '-8657.55', '748.029', '96.6892', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.696168', '0', '0'),
  35. ('75622', '10', '-8658.68', '767.899', '96.6925', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.39283', '0', '0'),
  36. ('75622', '11', '-8634.49', '787.411', '96.6512', '1500', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.689813', '0', '0'),
  37. ('75622', '12', '-8662.17', '821.239', '96.6386', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.61677', '0', '0'),
  38. ('75622', '13', '-8653.53', '826.735', '96.5285', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.676461', '0', '0'),
  39. ('75622', '14', '-8608.62', '861.791', '96.6798', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.634051', '0', '0'),
  40. ('75622', '15', '-8600.32', '850.058', '96.6911', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.34958', '0', '0'),
  41. ('75622', '16', '-8616.11', '837.915', '96.7385', '3000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.89818', '0', '0'),
  42. ('75622', '17', '-8637.49', '816.942', '96.6393', '2500', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.91545', '0', '0'),
  43. ('75622', '18', '-8629.56', '781.904', '96.6514', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.94588', '0', '0'),
  44. ('75622', '19', '-8623.89', '774.974', '96.6518', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.67881', '0', '0'),
  45. ('75622', '20', '-8623.29', '775.529', '96.6512', '11000', '0', '2000005134', '0', '0', '0', '0', '1', '0', '0', '0.570434', '0', '0'),
  46. ('75622', '21', '-8623.29', '775.529', '96.6512', '10000', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0.570434', '0', '0'),
  47. ('75622', '22', '-8623.29', '775.529', '96.6512', '8000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.570434', '0', '0'),
  48. ('75622', '23', '-8623.29', '775.529', '96.6512', '11000', '0', '2000005135', '0', '0', '0', '0', '1', '0', '0', '0.570434', '0', '0'),
  49. ('75622', '24', '-8623.29', '775.529', '96.6512', '4000', '0', '2000005136', '0', '0', '0', '0', '1', '0', '0', '0.570434', '0', '0'),
  50. ('75622', '25', '-8594.06', '757.656', '96.6537', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.31581', '0', '0'),
  51. ('75622', '26', '-8578.89', '737.947', '96.6719', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.29853', '0', '0'),
  52. ('75622', '27', '-8596.77', '717.424', '96.6572', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.04032', '0', '0'),
  53. ('75622', '28', '-8562.25', '673.301', '97.0168', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.38428', '0', '0'),
  54. ('75622', '29', '-8536.52', '690.402', '97.6668', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.588496', '0', '0'),
  55. ('75622', '30', '-8522.24', '670.618', '102.794', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.28283', '0', '0'),
  56. ('75622', '31', '-8508.77', '650.151', '100.292', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.31579', '0', '0'),
  57. ('75622', '32', '-8557.68', '615.023', '102.352', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.74443', '0', '0'),
  58. ('75622', '33', '-8568.14', '613.353', '102.382', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.31113', '0', '0'),
  59. ('75622', '34', '-8581.15', '593.053', '103.562', '3000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.12964', '0', '0'),
  60. ('75622', '35', '-8585.6', '562.85', '101.927', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4.57203', '0', '0'),
  61. ('75622', '36', '-8573.45', '540.833', '101.757', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.27575', '0', '0'),
  62. ('75622', '37', '-8535.68', '488.072', '101.081', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.28282', '0', '0'),
  63. ('75622', '38', '-8538.69', '479.398', '102.572', '0', '0', '2000005137', '0', '0', '0', '0', '0', '0', '0', '4.09766', '0', '0'),
  64. ('75622', '39', '-8548.29', '467.484', '104.514', '0', '0', '2000005138', '0', '0', '0', '0', '0', '0', '0', '4.18483', '0', '0'),
  65. ('75622', '40', '-8544.94', '464.148', '104.414', '9000', '0', '0', '0', '0', '0', '0', '1', '0', '0', '5.4187', '0', '0'),
  66. ('75622', '41', '-8544.94', '464.148', '104.414', '9000', '0', '2000005139', '0', '0', '0', '0', '1', '0', '0', '5.4187', '0', '0'),
  67. ('75622', '42', '-8544.94', '464.148', '104.414', '5000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5.4187', '0', '0'),
  68. ('75622', '43', '-8544.94', '464.148', '104.414', '1000', '0', '0', '0', '0', '0', '0', '1', '0', '0', '5.4187', '0', '0'),
  69. ('75622', '44', '-8564.17', '466.02', '104.524', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.05461', '0', '0'),
  70. ('75622', '45', '-8583.28', '480.99', '104.214', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.16088', '0', '0'),
  71. ('75622', '46', '-8606.08', '504.922', '103.722', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.48667', '0', '0'),
  72. ('75622', '47', '-8633.15', '534.792', '100.272', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.30773', '0', '0'),
  73. ('75622', '48', '-8655.92', '552.797', '96.9437', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.35678', '0', '0'),
  74. ('75622', '49', '-8671.53', '554.116', '97.1805', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.22901', '0', '0'),
  75. ('75622', '50', '-8713.5', '519.816', '97.1699', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.83377', '0', '0'),
  76. ('75622', '51', '-8731.17', '541.957', '101.124', '1500', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.25669', '0', '0'),
  77. ('75622', '52', '-8749.98', '561.766', '97.3988', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.38468', '0', '0'),
  78. ('75622', '53', '-8736.87', '574.559', '97.3823', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.833519', '0', '0'),
  79. ('75622', '54', '-8770.53', '609.421', '97.2463', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.30536', '0', '0'),
  80. ('75622', '55', '-8795.9', '587.923', '97.3792', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3.8353', '0', '0'),
  81. ('75622', '56', '-8827.8', '624.687', '93.8494', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.31713', '0', '0'),
  82. ('75622', '57', '-8928.94', '540.519', '94.3157', '0', '0', '2000005140', '0', '0', '0', '0', '0', '0', '0', '3.77404', '0', '0'),
  83. ('75622', '58', '-8907.67', '509.135', '93.8416', '0', '0', '2000005141', '0', '0', '0', '0', '0', '0', '0', '5.19562', '0', '0'),
  84. ('75622', '59', '-8933.21', '488.088', '93.8429', '9000', '0', '2000005142', '0', '0', '0', '0', '1', '0', '0', '3.92406', '0', '0'),
  85. ('75622', '60', '-8933.21', '488.088', '93.8429', '8000', '0', '0', '0', '0', '0', '0', '1', '0', '0', '3.92406', '0', '0'),
  86. ('75622', '61', '-8933.21', '488.088', '93.8429', '2000', '0', '0', '0', '0', '0', '0', '1', '0', '0', '3.92406', '0', '0'),
  87. ('75622', '62', '-8911.65', '505.615', '93.8585', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.652114', '0', '0'),
  88. ('75622', '63', '-8925.24', '543.334', '94.268', '1250', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.615201', '0', '0'),
  89. ('75622', '64', '-8833.34', '620.843', '93.4683', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.863387', '0', '0'),
  90. ('75622', '65', '-8854.67', '660.036', '96.8874', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.04072', '0', '0'),
  91. ('75622', '66', '-8838.52', '670.28', '98.0987', '5000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0.553153', '0', '0');
  92.  
  93. -- TEXTS
  94. DELETE FROM `db_script_string` WHERE `entry` IN ('2000005134','2000005135','2000005136','2000005137','2000005138','2000005139','2000005140','2000005141','2000005142');
  95. INSERT INTO `db_script_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`)
  96. VALUES
  97. ('2000005134', 'Here we have the Cathedral of Light, the center of spiritual enlightenment here in Stormwind.', '', '', '', '', '', '', '', ''),
  98. ('2000005135', 'Yes, that is true. Paladins and Priests alike train their skills and research great truths behind the walls of the Cathedral.', '', '', '', '', '', '', '', ''),
  99. ('2000005136', 'Children if you would please follow me, we will now be going to see the keep where King Anduin Wrynn himself sits on this throne.', '', '', '', '', '', '', '', ''),
  100. ('2000005137', 'Here we have Stormwind Keep. Built upon the ruins of Stormwind Castle, which was destroyed by the Horde in the first Great War.', '', '', '', '', '', '', '', ''),
  101. ('2000005138', 'When the Horde was shattered, men returned here and began to rebuild the once great city as a testament to our own survival.', '', '', '', '', '', '', '', ''),
  102. ('2000005139', 'Yes, well...let\'s head on to the monument dedicated to the heroes of the two Great Wars, the Valley of Heroes. Follow Me.', '', '', '', '', '', '', '', ''),
  103. ('2000005140', 'Isn\'t it amazing, children? All who enter the city must walk beneath the watchful eyes of the greatest heroes of our lands.', '', '', '', '', '', '', '', ''),
  104. ('2000005141', 'Breathtaking. Children, when we return to the school, you will each give an oral report on one of these legendary people.', '', '', '', '', '', '', '', ''),
  105. ('2000005142', 'Now, take another long look before we make our way to the Holy District and the great Cathedral of Light.', '', '', '', '', '', '', '', '');
  106.  
  107. -- CREATURE LINKING
  108. DELETE FROM `creature_linking_template` WHERE `entry` IN ('2331', '3504');
  109. INSERT INTO `creature_linking_template` (`entry`, `map`, `master_entry`, `flag`)
  110. VALUES
  111. ('3505', '0', '3513', '512'),
  112. ('3507', '0', '3513', '512'),
  113. ('3508', '0', '3513', '512'),
  114. ('3509', '0', '3513', '512'),
  115. ('3510', '0', '3513', '512'),
  116. ('3511', '0', '3513', '512'),
  117. ('3512', '0', '3513', '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!