diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2022_11_08_00_world.sql | 357 |
1 files changed, 357 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2022_11_08_00_world.sql b/sql/updates/world/3.3.5/2022_11_08_00_world.sql new file mode 100644 index 00000000000..69e6ed4bfa1 --- /dev/null +++ b/sql/updates/world/3.3.5/2022_11_08_00_world.sql @@ -0,0 +1,357 @@ +-- Add Creatures First +DELETE FROM `creature` WHERE `guid` IN (52954, 52955, 86186, 86187, 86188, 86191, 12501, 12502, 12509, 12515, 12529, 12530, 12531, 12532, 12533, 12534, 12535, 12536, 27590, 27591, 27592, 27593, 27594, 27595, 27596, 27597, 27598, 27599, 27600, 36904, 36907, 36924, 36938, 36942, 44025, 44040, 44046, 44049, 44050, 44059, 44061, 44079, 44420, 44421, 44458, 44464, 44948, 45105, 45106, 45489, 45500, 45515, 45516, 55105, 55422, 56334, 56335, 56336); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES +(52954, 12996, 0, 1, 1, 0, 1, -4524.09, -1601.46, 503.945, 2.7995, 300, 0, 0, 1910, 0, 2), +(52955, 12996, 0, 1, 1, 0, 1, -4495.38, -1632.11, 503.281, 1.01164, 300, 0, 0, 1910, 0, 2), +(86186, 13000, 0, 1, 1, 0, 0, -4753.54, -1644.35, 503.408, 5.61996, 300, 0, 0, 328, 0, 0), +(86187, 13000, 0, 1, 1, 0, 0, -4749.15, -1703.06, 503.324, 3.88574, 300, 0, 0, 328, 0, 0), +(86188, 13000, 0, 1, 1, 0, 1, -4739.14, -1705.1, 503.408, 5.25344, 300, 0, 0, 328, 0, 0), +(86191, 12047, 0, 1, 1, 0, 1, -4488.98, -1581.84, 509.088, 4.10152, 300, 0, 0, 2614, 0, 0), +(12501, 721, 0, 1, 1, 0, 0, -4841.44, -1702.25, 505.45, 4.41719, 300, 10, 0, 1, 0, 1), +(12502, 721, 0, 1, 1, 0, 0, -4511.08, -1645.97, 504.892, 4.4366, 300, 10, 0, 1, 0, 1), +(12509, 721, 0, 1, 1, 0, 0, -4432.92, -1556.55, 482.584, 6.02258, 300, 10, 0, 1, 0, 1), +(12515, 721, 0, 1, 1, 0, 0, -4405.9, -1521.26, 479.114, 0.0508368, 300, 10, 0, 1, 0, 1), +(12529, 721, 0, 1, 1, 0, 0, -4296.88, -1435.25, 392.267, 6.27347, 300, 10, 0, 1, 0, 1), +(12530, 721, 0, 1, 1, 0, 0, -4310.62, -1453.52, 402.814, 0.832907, 300, 10, 0, 1, 0, 1), +(12531, 727, 0, 1, 1, 0, 1, -5220.98, -1638.35, 497.961, 2.11185, 300, 0, 0, 1910, 0, 0), +(12532, 5595, 0, 1, 1, 0, 1, -5214.34, -1631.39, 497.968, 2.40855, 300, 0, 0, 5228, 0, 0), +(12533, 727, 0, 1, 1, 0, 1, -4879.94, -1688.11, 503.449, 0.291719, 300, 0, 0, 15952, 0, 2), +(12534, 727, 0, 1, 1, 0, 1, -4906.24, -1731.22, 503.408, 5.2709, 300, 0, 0, 1910, 0, 0), +(12535, 727, 0, 1, 1, 0, 1, -4864.09, -1629.83, 503.438, 4.79965, 300, 0, 0, 1910, 0, 0), +(12536, 727, 0, 1, 1, 0, 1, -4664.78, -1716.51, 503.407, 2.717255, 300, 0, 0, 1910, 0, 0), +(27590, 727, 0, 1, 1, 0, 1, -4677.7, -1727.02, 503.407, 1.16937, 300, 0, 0, 1910, 0, 0), +(27591, 727, 0, 1, 1, 0, 1, -4669.03, -1717.4, 503.407, 0.820305, 300, 0, 0, 1910, 0, 0), +(27592, 727, 0, 1, 1, 0, 1, -4723, -1651.54, 503.781, 0.245117, 300, 0, 0, 1910, 0, 2), +(27593, 5595, 0, 1, 1, 0, 1, -4641.51, -1726.6, 503.407, 1.5708, 300, 0, 0, 5228, 0, 0), +(27594, 727, 0, 1, 1, 0, 1, -4559.09, -1651.06, 503.627, 6.26573, 300, 0, 0, 1910, 0, 0), +(27595, 727, 0, 1, 1, 0, 1, -4606.63, -1694.36, 503.584, 2.80998, 300, 0, 0, 1910, 0, 0), +(27596, 727, 0, 1, 1, 0, 1, -4496.52, -1584.71, 509.088, 2.25148, 300, 0, 0, 1910, 0, 0), +(27597, 727, 0, 1, 1, 0, 1, -5211.04, -1625.78, 497.961, 2.80998, 300, 0, 0, 1910, 0, 0), +(27598, 727, 0, 1, 1, 0, 1, -5244.77, -1648.93, 497.961, 1.46608, 300, 0, 0, 1910, 0, 0), +(27599, 727, 0, 1, 1, 0, 1, -5251.19, -1646.21, 497.961, 1.309, 300, 0, 0, 1910, 0, 0), +(27600, 5595, 0, 1, 1, 0, 1, -4936.77, -1744.47, 503.362, 1.15192, 300, 0, 0, 5228, 0, 0), +(36904, 727, 0, 1, 1, 0, 1, -4857.38, -1685.34, 503.449, 1.57057, 300, 3, 0, 1910, 0, 1), +(36907, 727, 0, 1, 1, 0, 1, -4904.2, -1733.51, 503.407, 2.32129, 300, 0, 0, 1910, 0, 0), +(36924, 727, 0, 1, 1, 0, 1, -4870.97, -1629.69, 503.438, 4.64258, 300, 0, 0, 1910, 0, 0), +(36938, 727, 0, 1, 1, 0, 1, -4751.84, -1645.54, 503.407, 2.63545, 300, 0, 0, 1910, 0, 0), +(36942, 727, 0, 1, 1, 0, 1, -4610.18, -1700.01, 503.781, 1.95477, 300, 0, 0, 1910, 0, 0), +(44025, 5595, 0, 1, 1, 0, 1, -4557.15, -1652.2, 503.776, 2.16421, 300, 0, 0, 5228, 0, 0), +(44040, 727, 0, 1, 1, 0, 1, -4490.69, -1583.53, 509.088, 0.855211, 300, 0, 0, 1910, 0, 0), +(44046, 727, 0, 1, 1, 0, 1, -4486.11, -1590.46, 509.076, 5.20108, 300, 0, 0, 1910, 0, 0), +(44049, 1124, 0, 1, 1, 0, 0, -5227.94, -1470.97, 500.19, 0.0578766, 15, 3, 0, 160, 350, 2), +(44050, 1121, 0, 1, 1, 0, 0, -5225.15, -1467.11, 500.22, 5.06702, 15, 3, 0, 148, 165, 1), +(44059, 1120, 0, 1, 1, 0, 0, -5225.17, -1474.41, 500.18, 1.73751, 15, 3, 0, 137, 0, 1), +(44061, 1120, 0, 1, 1, 0, 0, -5219.43, -1472.34, 500.37, 2.8642, 15, 3, 0, 137, 0, 1), +(44079, 1124, 0, 1, 1, 0, 0, -5227.94, -1470.97, 500.19, 0.0578766, 30, 1, 0, 160, 350, 2), +(44420, 1121, 0, 1, 1, 0, 0, -5225.15, -1467.11, 500.22, 5.06702, 30, 3, 0, 148, 165, 1), +(44421, 1120, 0, 1, 1, 0, 0, -5225.17, -1474.41, 500.18, 1.73751, 30, 3, 0, 137, 0, 1), +(44458, 1120, 0, 1, 1, 0, 0, -5219.43, -1472.34, 500.37, 2.8642, 30, 3, 0, 137, 0, 1), +(44464, 2878, 0, 1, 1, 0, 1, -5125.58, -1696.42, 497.919, 0.244346, 300, 0, 0, 1753, 0, 0), +(44948, 6391, 0, 1, 1, 0, 1, -5125.08, -1694.8, 497.919, 5.63741, 300, 0, 0, 2250, 0, 0), +(45105, 7843, 0, 1, 1, 0, 1, -5246.58, -1518.29, 497.961, 2.35441, 60, 0, 0, 582, 618, 2), +(45106, 7843, 0, 1, 1, 0, 1, -5246.58, -1518.29, 497.961, 2.35441, 60, 0, 0, 582, 618, 0), +(45489, 12996, 0, 1, 1, 0, 1, -4900.52, -1693.01, 503.917, 3.46727, 300, 0, 0, 1910, 0, 2), +(45500, 12996, 0, 1, 1, 0, 1, -4748.86, -1658.8, 504.449, 4.43424, 300, 0, 0, 1910, 0, 2), +(45515, 13000, 0, 1, 1, 0, 1, -4778.53, -1702.25, 503.407, 4.18879, 300, 0, 0, 328, 0, 0), +(45516, 13000, 0, 1, 1, 0, 1, -4708.23, -1701.42, 503.407, 4.11898, 300, 0, 0, 328, 0, 0), +(55105, 853, 0, 1, 1, 0, 1, -5123.7, -1696.05, 497.961, 2.98451, 300, 0, 0, 11828, 0, 0), +(55422, 1124, 0, 1, 1, 0, 1, -4627.8, -791.872, 644.166, 0.136101, 300, 0, 0, 160, 350, 0), +(56334, 1123, 0, 1, 1, 0, 1, -4625.5, -791.542, 643.755, 3.26985, 300, 0, 0, 176, 0, 0), +(56335, 1121, 0, 1, 1, 0, 1, -4631.94, -848.495, 640.672, 0.796625, 300, 0, 0, 166, 178, 2), +(56336, 721, 0, 1, 1, 0, 0, -4702.596, -1659.312, 504.5119, 3.543274, 300, 10, 0, 1, 0, 1); + +-- Give Creatures their respective paths, mounts and emotes +DELETE FROM `creature_addon` WHERE `guid` IN (52954, 52955, 86186, 86187, 86188, 86191, 12533, 12534, 27592, 27594, 27596, 36907, 36938, 44025, 44040, 44046, 44049, 44079, 44464, 44948, 45105, 45489, 45500, 45515, 45516, 55105, 55422, 56334, 56335); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `emote`) VALUES +(52954, 529540, 2786, 0), +(52955, 529550, 2786, 0), +(86186, 0, 0, 1), +(86187, 0, 0, 133), +(86188, 0, 0, 133), +(86191, 0, 0, 1), +(12533, 125330, 0, 0), +(12534, 0, 0, 1), +(27592, 275920, 0, 0), +(27594, 0, 0, 22), +(27596, 0, 0, 28), +(36907, 0, 0, 1), +(36938, 0, 0, 18), +(44025, 0, 0, 66), +(44040, 0, 0, 1), +(44046, 0, 0, 3), +(44049, 440490, 0, 0), +(44079, 440790, 0, 0), +(44464, 0, 0, 21), +(44948, 0, 0, 4), +(45105, 451050, 0, 0), +(45489, 454890, 2786, 0), +(45500, 455000, 2786, 0), +(45515, 0, 0, 133), +(45516, 0, 0, 133), +(55105, 0, 0, 10), +(55422, 0, 0, 1), +(56334, 0, 0, 1), +(56335, 563350, 1166, 0); + +-- Give Creatures their formations to follow +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (12532, 12531, 44049, 44079, 45105); +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(12532, 12532, 0, 0, 3, 0, 0), +(12531, 12531, 0, 0, 3, 0, 0), +(12531, 27597, 0, 0, 3, 0, 0), +(12531, 27598, 0, 0, 3, 0, 0), +(12531, 27599, 0, 0, 3, 0, 0), +(44049, 44049, 0, 0, 515, 0, 0), +(44049, 44050, 3, 45, 515, 0, 0), +(44049, 44059, 3, 305, 515, 0, 0), +(44049, 44061, 3, 360, 515, 0, 0), +(44079, 44079, 0, 0, 515, 0, 0), +(44079, 44420, 3, 45, 515, 0, 0), +(44079, 44421, 3, 305, 515, 0, 0), +(44079, 44458, 3, 360, 515, 0, 0), +(45105, 45106, 2, 0, 512, 0, 0), +(45105, 45105, 0, 0, 512, 0, 0); + +-- Give Creatures their respective waypoints +DELETE FROM `waypoint_data` WHERE `id` IN (563350, 529540, 529550, 125330, 275920, 440490, 440790, 451050, 454890, 455000); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`) VALUES +(563350, 1, -4631.94, -848.495, 640.672, 0.796625, 10000, 0), +(563350, 2, -4618.64, -835.561, 640.453, 0, 0, 0), +(563350, 3, -4601.49, -817.146, 639.26, 0, 0, 0), +(563350, 4, -4602.65, -814.052, 639.594, 0, 0, 0), +(563350, 5, -4608.2, -809.608, 640.899, 0, 0, 0), +(563350, 6, -4612.96, -807.284, 641.739, 0, 0, 0), +(563350, 7, -4618.28, -804.654, 642.979, 0, 0, 0), +(563350, 8, -4621.56, -798.121, 643.449, 0, 0, 0), +(563350, 9, -4625, -786.671, 643.901, 0, 0, 0), +(563350, 10, -4628.18, -779.315, 644.397, 0, 0, 0), +(563350, 11, -4631.17, -772.648, 644.678, 0, 0, 0), +(563350, 12, -4633.12, -766.495, 644.969, 0, 0, 0), +(563350, 13, -4635.65, -759.546, 645.164, 0, 0, 0), +(563350, 14, -4633.12, -766.495, 644.969, 0, 0, 0), +(563350, 15, -4631.17, -772.648, 644.678, 0, 0, 0), +(563350, 16, -4628.18, -779.315, 644.397, 0, 0, 0), +(563350, 17, -4625, -786.671, 643.901, 0, 0, 0), +(563350, 18, -4621.56, -798.121, 643.449, 0, 0, 0), +(563350, 19, -4618.28, -804.654, 642.979, 0, 0, 0), +(563350, 20, -4612.96, -807.284, 641.739, 0, 0, 0), +(563350, 21, -4608.2, -809.608, 640.899, 0, 0, 0), +(563350, 22, -4602.65, -814.052, 639.594, 0, 0, 0), +(563350, 23, -4601.49, -817.146, 639.26, 0, 0, 0), +(563350, 24, -4618.64, -835.561, 640.453, 0, 0, 0), +(529540, 1, -4518.59, -1613.96, 504.427, 0, 0, 0), +(529540, 2, -4519.59, -1625.01, 504.677, 0, 0, 0), +(529540, 3, -4527.15, -1634.56, 504.578, 0, 0, 0), +(529540, 4, -4558.06, -1630.41, 503.901, 0, 0, 0), +(529540, 5, -4563.65, -1636.72, 503.449, 0, 0, 0), +(529540, 6, -4568.63, -1642.61, 503.436, 0, 0, 0), +(529540, 7, -4573.4, -1648.35, 503.436, 0, 0, 0), +(529540, 8, -4584.84, -1650.11, 504.061, 0, 0, 0), +(529540, 9, -4604.96, -1652.27, 504.322, 0, 0, 0), +(529540, 10, -4612.11, -1631.77, 503.592, 0, 0, 0), +(529540, 11, -4720.28, -1632.54, 503.212, 0, 0, 0), +(529540, 12, -4612.11, -1631.77, 503.592, 0, 0, 0), +(529540, 13, -4604.96, -1652.27, 504.322, 0, 0, 0), +(529540, 14, -4584.84, -1650.11, 504.061, 0, 0, 0), +(529540, 15, -4573.4, -1648.35, 503.436, 0, 0, 0), +(529540, 16, -4568.63, -1642.61, 503.436, 0, 0, 0), +(529540, 17, -4563.65, -1636.72, 503.449, 0, 0, 0), +(529540, 18, -4558.06, -1630.41, 503.901, 0, 0, 0), +(529540, 19, -4527.15, -1634.56, 504.578, 0, 0, 0), +(529540, 20, -4519.59, -1625.01, 504.677, 0, 0, 0), +(529550, 1, -4495.38, -1632.11, 503.281, 0, 0, 0), +(529550, 2, -4481.32, -1624.48, 499.031, 0, 0, 0), +(529550, 3, -4476.08, -1615.97, 496.281, 0, 0, 0), +(529550, 4, -4460.79, -1594.32, 490.003, 0, 0, 0), +(529550, 5, -4451.25, -1580.12, 488.128, 0, 0, 0), +(529550, 6, -4438.87, -1565.7, 483.94, 0, 0, 0), +(529550, 7, -4408.5, -1528.73, 478.152, 0, 0, 0), +(529550, 8, -4404.45, -1517.27, 479.902, 0, 0, 0), +(529550, 9, -4438.87, -1565.7, 483.94, 0, 0, 0), +(529550, 10, -4451.25, -1580.12, 488.128, 0, 0, 0), +(529550, 11, -4460.79, -1594.32, 490.003, 0, 0, 0), +(529550, 12, -4476.08, -1615.97, 496.281, 0, 0, 0), +(529550, 13, -4481.32, -1624.48, 499.031, 0, 0, 0), +(529550, 14, -4495.38, -1632.11, 503.281, 0, 0, 0), +(529550, 15, -4522.39, -1665.24, 504.703, 0, 0, 0), +(529550, 16, -4527.54, -1678.83, 504.628, 0, 0, 0), +(529550, 17, -4522.74, -1694.59, 506.753, 0, 0, 0), +(529550, 18, -4527.54, -1678.83, 504.628, 0, 0, 0), +(529550, 19, -4522.39, -1665.24, 504.703, 0, 0, 0), +(125330, 1, -4833.33, -1694.97, 504.074, 0, 0, 0), +(125330, 2, -4850.25, -1694.53, 503.574, 0, 0, 0), +(125330, 3, -4865.31, -1688.79, 503.449, 0, 0, 0), +(125330, 4, -4863.75, -1675.94, 503.449, 0, 0, 0), +(125330, 5, -4865.35, -1659.29, 503.475, 0, 0, 0), +(125330, 6, -4863.75, -1675.94, 503.449, 0, 0, 0), +(125330, 7, -4865.31, -1688.79, 503.449, 0, 0, 0), +(125330, 8, -4879.94, -1688.11, 503.449, 0, 0, 0), +(125330, 9, -4899.74, -1695, 503.699, 0, 0, 0), +(125330, 10, -4922.21, -1715.69, 503.448, 0, 0, 0), +(125330, 11, -4936.63, -1737.98, 503.411, 0, 0, 0), +(125330, 12, -4922.21, -1715.69, 503.448, 0, 0, 0), +(125330, 13, -4899.74, -1695, 503.699, 0, 0, 0), +(125330, 14, -4879.94, -1688.11, 503.449, 0, 0, 0), +(125330, 15, -4865.31, -1688.79, 503.449, 0, 0, 0), +(125330, 16, -4850.25, -1694.53, 503.574, 0, 0, 0), +(125330, 17, -4833.33, -1694.97, 504.074, 0, 0, 0), +(125330, 18, -4820.9, -1691.2, 503.69, 0, 0, 0), +(275920, 1, -4746.25, -1647.44, 503.359, 0, 0, 1), +(275920, 2, -4736.91, -1653.07, 503.769, 0, 0, 1), +(275920, 3, -4723, -1651.54, 503.781, 0, 0, 1), +(275920, 4, -4698.26, -1650.24, 503.574, 0, 0, 1), +(275920, 5, -4671.61, -1650.73, 503.699, 0, 0, 1), +(275920, 6, -4653.1, -1650.52, 503.949, 0, 0, 1), +(275920, 7, -4626.28, -1651.3, 504.197, 0, 0, 1), +(275920, 8, -4611.06, -1648.4, 503.572, 0, 0, 1), +(275920, 9, -4599.79, -1641.67, 503.436, 0, 0, 1), +(275920, 10, -4585.35, -1633.9, 503.436, 0, 0, 1), +(275920, 11, -4573.83, -1631.9, 503.441, 0, 0, 1), +(275920, 12, -4562.14, -1632.03, 503.651, 0, 0, 1), +(275920, 13, -4573.83, -1631.9, 503.441, 0, 0, 1), +(275920, 14, -4585.35, -1633.9, 503.436, 0, 0, 1), +(275920, 15, -4599.79, -1641.67, 503.436, 0, 0, 1), +(275920, 16, -4611.06, -1648.4, 503.572, 0, 0, 1), +(275920, 17, -4626.28, -1651.3, 504.197, 0, 0, 1), +(275920, 18, -4653.1, -1650.52, 503.949, 0, 0, 1), +(275920, 19, -4671.61, -1650.73, 503.699, 0, 0, 1), +(275920, 20, -4698.26, -1650.24, 503.574, 0, 0, 1), +(275920, 21, -4723, -1651.54, 503.781, 0, 0, 1), +(275920, 22, -4736.91, -1653.07, 503.769, 0, 0, 1), +(275920, 23, -4746.03, -1647.40, 503.362, 2.79798, 1000, 1), +(440490, 1, -5231.81, -1463.41, 500.341, 0, 10, 1), +(440490, 2, -5234.02, -1474.23, 500.086, 0, 0, 1), +(440490, 3, -5229.78, -1486.67, 498.985, 0, 0, 1), +(440490, 4, -5231.11, -1514.05, 497.961, 0, 0, 1), +(440490, 5, -5231.26, -1529.69, 497.961, 0, 0, 1), +(440490, 6, -5233.87, -1544.24, 497.961, 0, 0, 1), +(440490, 7, -5235.59, -1559.79, 497.961, 0, 0, 1), +(440490, 8, -5210.25, -1620.56, 498.086, 0, 0, 1), +(440790, 1, -5231.81, -1463.41, 500.341, 0, 100, 1), +(440790, 2, -5234.02, -1474.23, 500.086, 0, 0, 1), +(440790, 3, -5260.96, -1541.46, 497.961, 0, 0, 1), +(440790, 4, -5261.67, -1552.91, 497.961, 0, 0, 1), +(440790, 5, -5267.34, -1565.14, 497.961, 0, 0, 1), +(440790, 6, -5272.42, -1597.53, 497.961, 0, 0, 1), +(440790, 7, -5240.73, -1631.1, 497.961, 0, 0, 1), +(440790, 8, -5234.48, -1635.95, 497.961, 0, 0, 1), +(451050, 1, -5246.58, -1518.29, 497.961, 0, 1000, 1), +(451050, 2, -5249.91, -1542.55, 497.961, 0, 0, 1), +(451050, 3, -5251.34, -1551.03, 497.961, 0, 0, 1), +(451050, 4, -5252.96, -1560.5, 497.961, 0, 0, 1), +(451050, 5, -5250.34, -1568.85, 497.961, 0, 0, 1), +(451050, 6, -5246.25, -1579.79, 497.961, 0, 0, 1), +(451050, 7, -5237.69, -1596.13, 497.961, 0, 0, 1), +(451050, 8, -5222.46, -1613.23, 497.961, 0, 0, 1), +(451050, 9, -5216.4, -1629.66, 497.961, 0, 0, 1), +(451050, 10, -5208.19, -1637.28, 497.961, 0, 0, 1), +(451050, 11, -5193.03, -1647.98, 497.961, 0, 0, 1), +(451050, 12, -5186.24, -1665, 497.961, 0, 0, 1), +(451050, 13, -5173.13, -1669.51, 497.961, 0, 0, 1), +(451050, 14, -5147.58, -1673.94, 497.961, 0, 0, 1), +(451050, 15, -5132.08, -1674.8, 497.961, 0, 1000, 1), +(451050, 16, -5147.58, -1673.94, 497.961, 0, 0, 1), +(451050, 17, -5173.13, -1669.51, 497.961, 0, 0, 1), +(451050, 18, -5186.24, -1665, 497.961, 0, 0, 1), +(451050, 19, -5193.03, -1647.98, 497.961, 0, 0, 1), +(451050, 20, -5208.19, -1637.28, 497.961, 0, 0, 1), +(451050, 21, -5216.4, -1629.66, 497.961, 0, 0, 1), +(451050, 22, -5222.46, -1613.23, 497.961, 0, 0, 1), +(451050, 23, -5237.69, -1596.13, 497.961, 0, 0, 1), +(451050, 24, -5246.25, -1579.79, 497.961, 0, 0, 1), +(451050, 25, -5250.34, -1568.85, 497.961, 0, 0, 1), +(451050, 26, -5252.96, -1560.5, 497.961, 0, 0, 1), +(451050, 27, -5251.34, -1551.03, 497.961, 0, 0, 1), +(451050, 28, -5249.91, -1542.55, 497.961, 0, 0, 1), +(451050, 29, -5246.58, -1518.29, 497.961, 0, 1000, 1), +(454890, 1, -4900.52, -1693.01, 503.917, 0, 0, 0), +(454890, 2, -4905.66, -1696.63, 504.042, 0, 0, 0), +(454890, 3, -4932.19, -1713.26, 503.448, 0, 0, 0), +(454890, 4, -4939.79, -1713.4, 503.407, 0, 0, 0), +(454890, 5, -4991.93, -1697.25, 501.027, 0, 0, 0), +(454890, 6, -5077.13, -1672.12, 497.961, 0, 0, 0), +(454890, 7, -5093.73, -1655.12, 498.509, 0, 0, 0), +(454890, 8, -5101.23, -1649.31, 498.759, 0, 0, 0), +(454890, 9, -5157.22, -1636.24, 498.509, 0, 0, 0), +(454890, 10, -5165.98, -1634.89, 498.259, 0, 0 ,0), +(454890, 11, -5172.99, -1636.41, 497.961, 2.98117, 0, 0), +(454890, 12, -5212.88, -1625.82, 497.961, 0, 0, 0), +(454890, 13, -5222.16, -1625.35, 497.961, 1.49169, 0, 0), +(454890, 14, -5271.97, -1609.86, 497.965, 0.45746, 0, 0), +(454890, 15, -5257.38, -1604.52, 497.961, 4.306, 0, 0), +(454890, 16, -5249.05, -1585.17, 497.961, 0, 0, 0), +(454890, 17, -5235.77, -1578.42, 497.961, -2.68817, 0, 0), +(454890, 18, -5225.53, -1583.78, 497.961, 1.49228, 0, 0), +(454890, 19, -5219.15, -1602.7, 497.961, 2.59347, 0, 0), +(454890, 20, -5212.88, -1625.82, 497.961, 0, 0, 0), +(454890, 21, -5172.99, -1636.41, 497.961, 2.98117, 0, 0), +(454890, 22, -5165.98, -1634.89, 498.259, 0, 0, 0), +(454890, 23, -5157.22, -1636.24, 498.509, 0, 0, 0), +(454890, 24, -5101.23, -1649.31, 498.759, 0, 0, 0), +(454890, 25, -5093.73, -1655.12, 498.509, 0, 0, 0), +(454890, 26, -5077.13, -1672.12, 497.961, 0, 0, 0), +(454890, 27, -5003.67, -1710.3, 498.711, 0, 0, 0), +(454890, 28, -4995.86, -1710.01, 501.534, 0, 0, 0), +(454890, 29, -4992.38, -1705.6, 502.284, 0, 0, 0), +(454890, 30, -4991.93, -1697.25, 501.027, 0, 0, 0), +(454890, 31, -4939.79, -1713.4, 503.407, 0, 0, 0), +(454890, 32, -4932.19, -1713.26, 503.448, 0, 0, 0), +(454890, 33, -4905.66, -1696.63, 504.042, 0, 0, 0), +(455000, 1, -4748.86, -1658.8, 504.449, 0, 0, 0), +(455000, 2, -4791.84, -1658.47, 504.449, 0, 0, 0), +(455000, 3, -4791.71, -1669.03, 503.449, 0, 0, 0), +(455000, 4, -4784.33, -1672.2, 503.449, 0, 0, 0), +(455000, 5, -4782.64, -1679.48, 503.449, 0, 0, 0), +(455000, 6, -4780.94, -1684.72, 503.449, 0, 0, 0), +(455000, 7, -4782.5, -1690.17, 503.449, 0, 0, 0), +(455000, 8, -4788.1, -1689.92, 503.449, 0, 0, 0), +(455000, 9, -4793.46, -1688.05, 503.449, 0, 0, 0), +(455000, 10, -4801.92, -1686.43, 503.449, 0, 0, 0), +(455000, 11, -4809.65, -1687.08, 503.449, 0, 0, 0), +(455000, 12, -4818.29, -1688.46, 503.449, 0, 0, 0), +(455000, 13, -4825.65, -1691.36, 503.699, 0, 0, 0), +(455000, 14, -4832.92, -1693.74, 503.824, 0, 0, 0), +(455000, 15, -4841.56, -1694.59, 503.824, 0, 0, 0), +(455000, 16, -4832.92, -1693.74, 503.824, 0, 0, 0), +(455000, 17, -4825.65, -1691.36, 503.699, 0, 0, 0), +(455000, 18, -4818.29, -1688.46, 503.449, 0, 0, 0), +(455000, 19, -4809.65, -1687.08, 503.449, 0, 0, 0), +(455000, 20, -4801.92, -1686.43, 503.449, 0, 0, 0), +(455000, 21, -4793.46, -1688.05, 503.449, 0, 0, 0), +(455000, 22, -4788.1, -1689.92, 503.449, 0, 0, 0), +(455000, 23, -4782.5, -1690.17, 503.449, 0, 0, 0), +(455000, 24, -4780.94, -1684.72, 503.449, 0, 0, 0), +(455000, 25, -4782.64, -1679.48, 503.449, 0, 0, 0), +(455000, 26, -4784.33, -1672.2, 503.449, 0, 0, 0), +(455000, 27, -4791.71, -1669.03, 503.449, 0, 0, 0), +(455000, 28, -4791.84, -1658.47, 504.449, 0, 0, 0); + +-- Spawn Campfire in Camp +DELETE FROM `gameobject` WHERE `guid`=9896; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(9896, 3085, 0, 1, 1, -4667.08, -1715.54, 503.324, 3.07425, 0, 0, 0.999433, 0.0336635, 25, 100, 1); + +-- Add Combat Script to make Ironforge Guards/Mountaineers use Ranged Weapons +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (727,5595); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (727, 5595); +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(727,0,1,0,0,0,100,0,0,0,2000,4000,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Ironforge Mountaineer - In Combat - Cast 'Shoot'"), +(727,0,2,0,9,0,100,0,0,5,11000,14000,11,12169,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Mountaineer - Within 0-5 Range - Cast 'Shield Block'"), +(727,0,3,0,0,0,100,0,5000,9000,8000,13000,11,12170,0,0,0,0,0,2,0,0,0,0,0,0,0,"Ironforge Mountaineer - In Combat - Cast 'Revenge'"), +(727,0,4,0,22,0,100,0,101,5000,5000,0,80,6800,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Mountaineer - On Received Emote 'Wave' - Run Script"), +(727,0,5,0,22,0,100,0,78,5000,5000,0,80,6801,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Mountaineer - On Received Emote 'Salute' - Run Script"), +(727,0,6,0,22,0,100,0,58,5000,5000,0,80,6802,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Mountaineer - On Received Emote 'Kiss' - Run Script"), +(727,0,7,0,22,0,100,0,84,5000,5000,0,80,6803,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Mountaineer - On Received Emote 'Shy' - Run Script"), +(727,0,8,0,22,0,100,0,77,5000,5000,0,80,6804,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Mountaineer - On Received Emote 'Rude' - Run Script"), +(727,0,9,0,22,0,100,0,22,5000,5000,0,80,6804,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Mountaineer - On Received Emote 'Chicken' - Run Script"), +(727,0,10,0,22,0,100,0,17,5000,5000,0,80,6802,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Mountaineer - On Received Emote 'Bow' - Run Script"), +(5595,0,1,0,0,0,100,0,0,0,2000,4000,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Ironforge Guard - In Combat - Cast 'Shoot'"), +(5595,0,2,0,9,0,100,0,0,5,11000,14000,11,12169,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Guard - Within 0-5 Range - Cast 'Shield Block'"), +(5595,0,3,0,0,0,100,0,5000,9000,8000,13000,11,12170,0,0,0,0,0,2,0,0,0,0,0,0,0,"Ironforge Guard - In Combat - Cast 'Revenge'"), +(5595,0,4,0,22,0,100,0,101,5000,5000,0,80,6800,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Guard - On Received Emote 'Wave' - Run Script"), +(5595,0,5,0,22,0,100,0,78,5000,5000,0,80,6801,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Guard - On Received Emote 'Salute' - Run Script"), +(5595,0,6,0,22,0,100,0,58,5000,5000,0,80,6802,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Guard - On Received Emote 'Kiss' - Run Script"), +(5595,0,7,0,22,0,100,0,84,5000,5000,0,80,6803,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Guard - On Received Emote 'Shy' - Run Script"), +(5595,0,8,0,22,0,100,0,77,5000,5000,0,80,6804,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Guard - On Received Emote 'Rude' - Run Script"), +(5595,0,9,0,22,0,100,0,22,5000,5000,0,80,6804,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Guard - On Received Emote 'Chicken' - Run Script"), +(5595,0,10,0,22,0,100,0,17,5000,5000,0,80,6802,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ironforge Guard - On Received Emote 'Bow' - Run Script"); |