diff options
| -rw-r--r-- | sql/updates/world/2016_02_21_00_world.sql | 142 |
1 files changed, 142 insertions, 0 deletions
diff --git a/sql/updates/world/2016_02_21_00_world.sql b/sql/updates/world/2016_02_21_00_world.sql new file mode 100644 index 00000000000..599b4c70ff1 --- /dev/null +++ b/sql/updates/world/2016_02_21_00_world.sql @@ -0,0 +1,142 @@ +-- +SET @Cguid:=375591; +DELETE FROM `creature` WHERE `guid` BETWEEN @Cguid+0 AND @Cguid+9; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseid`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES +(@Cguid+0, 49957, 530, 1, 0, 36930, 1, -2008.36, -11811.9, 54.4879, 1.62316, 300, 0, 0, 610, 655, 0), +(@Cguid+1, 49959, 530, 1, 0, 36929, 1, -1927.17, -11858.4, 51.5349, 2.46091, 300, 0, 0, 562, 1633, 0), +(@Cguid+2, 49961, 530, 1, 0, 36928, 1, -1929.83, -11856, 51.6173, 5.63741, 300, 0, 0, 699, 0, 0), +(@Cguid+3, 49962, 530, 1, 0, 36927, 1, -2006.56, -11809.5, 55.3832, 3.63029, 300, 0, 0, 562, 1633, 0), +(@Cguid+4, 49964, 530, 1, 0, 36925, 1, -2009.79, -11809.4, 54.7862, 5.46288, 300, 0, 0, 610, 655, 0), +(@Cguid+5, 49966, 530, 1, 0, 36924, 1, -2062.2, -11867.6, 49.0188, 4.10152, 300, 0, 0, 732, 655, 0), +(@Cguid+6, 51795, 530, 1, 0, 16792, 1, -1917.34, -11950.9, 60.1836, 2.93214, 300, 0, 0, 116235, 0, 0), +(@Cguid+7, 51905, 530, 1, 0, 17375, 1, -4128.77, -12517.8, 44.7383, 3.72974, 300, 0, 0, 116235, 0, 2), +(@Cguid+8, 51905, 530, 1, 0, 17374, 1, -3978.1, -12433.5, 20.8775, 0.174785, 300, 0, 0, 116235, 0, 2), +(@Cguid+9, 51905, 530, 1, 0, 17373, 1, -4187.19, -12490.7, 44.5119, 4.11811, 300, 0, 0, 116235, 0, 2); + +DELETE FROM `creature_addon` WHERE `guid` IN (@Cguid+7, @Cguid+8, @Cguid+9); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(@Cguid+7,@Cguid+7*10,0,0,1,0, ''), +(@Cguid+8,@Cguid+8*10,0,0,1,0, ''), +(@Cguid+9,@Cguid+9*10,0,0,1,0, ''); + +DELETE FROM `waypoint_data` WHERE `id` IN (@Cguid+7*10, @Cguid+8*10, @Cguid+9*10); +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@Cguid+7*10, 1, -4061.74, -12472.6, 34.6412, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 2, -4060.81, -12472.3, 34.6412, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 3, -4065.33, -12474.4, 35.3882, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 4, -4066.67, -12475, 35.7406, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 5, -4069.96, -12478.8, 36.3656, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 6, -4071.27, -12480.3, 36.9906, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 7, -4073.96, -12483.3, 37.6156, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 8, -4075, -12484.4, 37.7406, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 9, -4083.33, -12487.5, 38.2406, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 10, -4087.81, -12489.7, 38.9906, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 11, -4092.28, -12492, 39.7406, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 12, -4094.96, -12493.3, 40.3656, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 13, -4098.54, -12495.1, 41.2406, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 14, -4100, -12495.8, 41.6331, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 15, -4103.53, -12497.7, 42.2581, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 16, -4106.18, -12499.1, 42.8831, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 17, -4107.81, -12500, 43.2877, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 18, -4116.67, -12504.2, 43.7877, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 19, -4120.57, -12507.3, 44.4127, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 20, -4121.88, -12508.3, 44.5377, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 21, -4122.92, -12509.9, 44.6627, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 22, -4123.44, -12511.5, 44.7877, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 23, -4125, -12512, 44.7877, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 24, -4127.08, -12516.7, 44.7877, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 25, -4133.33, -12520.8, 44.6053, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 26, -4139.16, -12524.7, 45.2303, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 27, -4139.58, -12525, 45.3553, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 28, -4141.67, -12526, 45.4803, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 29, -4143.75, -12526, 45.4803, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 30, -4145.83, -12526, 45.3553, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 31, -4147.4, -12527.1, 45.3553, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 32, -4147.4, -12528.1, 45.2303, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 33, -4147.4, -12529.2, 45.2303, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 34, -4149.48, -12533.3, 45.2878, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 35, -4151.04, -12537.5, 45.6628, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 36, -4151.04, -12539.6, 45.9128, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 37, -4151.04, -12541.7, 46.4128, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 38, -4153.73, -12543, 47.1628, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 39, -4154.17, -12543.2, 47.0378, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 40, -4156.25, -12544.8, 47.6628, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 41, -4158.33, -12544.8, 47.1628, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 42, -4159.38, -12545.8, 46.9128, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 43, -4160.42, -12550, 46.5378, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 44, -4162.08, -12551.1, 45.6628, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 45, -4165.41, -12553.3, 46.2878, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 46, -4166.67, -12554.2, 46.787, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 47, -4168.11, -12555.4, 46.6192, 0, 0, 0, 0, 100, 0), +(@Cguid+7*10, 48, -4168.11, -12555.4, 46.6192, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 1, -3986.59, -12435.3, 22.5984, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 2, -3985.67, -12434.9, 22.5984, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 3, -3981.73, -12434.2, 21.8484, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 4, -3978.78, -12433.7, 21.0984, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 5, -3976.81, -12433.3, 20.4585, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 6, -3973.86, -12432.8, 19.8335, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 7, -3968.94, -12431.9, 19.0835, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 8, -3965.98, -12431.4, 18.3743, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 9, -3964.01, -12431, 17.7493, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 10, -3962.04, -12430.7, 17.1243, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 11, -3960.08, -12430.3, 16.4993, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 12, -3957.12, -12429.8, 15.8743, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 13, -3953.19, -12429.1, 15.1243, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 14, -3950.23, -12428.6, 14.3743, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 15, -3947.28, -12428.1, 13.7493, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 16, -3944.33, -12427.6, 12.9993, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 17, -3941.37, -12427, 12.3743, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 18, -3938.42, -12426.5, 11.7493, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 19, -3932.51, -12425.5, 11.0611, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 20, -3928.58, -12424.8, 10.4361, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 21, -3924.64, -12424.1, 9.81107, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 22, -3920.7, -12423.4, 9.18607, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 23, -3915.78, -12422.5, 8.43607, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 24, -3912.83, -12422, 7.68607, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 25, -3909.87, -12421.5, 6.93607, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 26, -3906.92, -12421, 6.18607, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 27, -3902.98, -12420.3, 5.43607, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 28, -3899.04, -12419.6, 4.88049, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 29, -3896.09, -12419, 4.13049, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 30, -3893.14, -12418.5, 3.63049, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 31, -3890.19, -12418, 3.00549, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 32, -3886.25, -12417.3, 2.38049, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 33, -3881.33, -12416.4, 1.75549, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 34, -3875.42, -12415.4, 1.13049, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 35, -3865.58, -12413.7, 0.61739, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 36, -3861.64, -12413, -0.00761, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 37, -3853.76, -12411.6, 0.61739, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 38, -3833.09, -12407.9, 0.06805, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 39, -3817.34, -12405.1, -0.68195, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 40, -3794.7, -12401.2, -1.24708, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 41, -3783.87, -12399.2, -1.76022, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 42, -3735.64, -12390.7, -2.31746, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 43, -3728.75, -12389.5, -2.87577, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 44, -3708.08, -12385.8, -3.50077, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 45, -3697.25, -12383.9, -2.87836, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 46, -3691.34, -12382.9, -2.25336, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 47, -3684.45, -12381.7, -1.62836, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 48, -3676.58, -12380.3, -1.00336, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 49, -3668.7, -12378.9, -0.37835, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 50, -3650, -12375.6, -0.96306, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 51, -3636.22, -12373.2, -0.33806, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 52, -3632.28, -12372.5, 0.26415, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 53, -3605.7, -12367.8, 0.88915, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 54, -3599.79, -12366.7, 1.53784, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 55, -3590.94, -12365.2, 2.04595, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 56, -3579.12, -12363.1, 2.67095, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 57, -3572.23, -12361.9, 3.29595, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 58, -3565.34, -12360.6, 3.85212, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 59, -3559.44, -12359.6, 4.47712, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 60, -3555.5, -12358.9, 5.10212, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 61, -3551.56, -12358.2, 5.72712, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 62, -3543.69, -12356.8, 6.35212, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 63, -3536.79, -12355.6, 6.97712, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 64, -3532.86, -12354.9, 7.51007, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 65, -3528.92, -12354.2, 8.01007, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 66, -3526.86, -12353.8, 8.33675, 0, 0, 0, 0, 100, 0), +(@Cguid+8*10, 67, -3526.86, -12353.8, 8.33675, 0, 0, 0, 0, 100, 0), +(@Cguid+9*10, 1, -4185.19, -12488.5, 44.5125, 0, 0, 0, 0, 100, 0), +(@Cguid+9*10, 2, -4185.05, -12487.5, 44.5125, 0, 0, 0, 0, 100, 0), +(@Cguid+9*10, 3, -4195.25, -12502.6, 44.5099, 0, 0, 0, 0, 100, 0), +(@Cguid+9*10, 4, -4195.25, -12502.6, 44.5099, 0, 0, 0, 0, 100, 0); |