diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_06_06_06_world.sql | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_06_06_06_world.sql b/sql/updates/world/3.3.5/2019_06_06_06_world.sql new file mode 100644 index 00000000000..d6397ec4e03 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_06_06_06_world.sql @@ -0,0 +1,31 @@ +-- +DELETE FROM `creature` WHERE `id` IN (23444) AND `guid` IN (109726, 109728, 109736, 109764, 109765, 109766, 109767, 109768, 109770, 109774, 109777, 109779, 109785, 109802, 109803, 109804, 109811, 109813, 109814, 109863, 109899, 109902, 109917, 109918); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(109726, 23444, 530, 1, 1, 0, 4023.48, 5884.76, 268.1, 5.67232, 300, 0, 0), +(109728, 23444, 530, 1, 1, 0, 4026.57, 5885.07, 275.7, 0.593412, 300, 0, 0), +(109736, 23444, 530, 1, 1, 0, 4015.97, 5895.41, 270.196, 5.84685, 300, 0, 0), +(109764, 23444, 530, 1, 1, 0, 4002.59, 5896.95, 276.084, 0.942478, 300, 0, 0), +(109765, 23444, 530, 1, 1, 0, 4028.33, 5901.81, 275.885, 4.01426, 300, 0, 0), +(109766, 23444, 530, 1, 1, 0, 4013.89, 5902.67, 272.256, 6.16101, 300, 0, 0), +(109767, 23444, 530, 1, 1, 0, 4015.94, 5899.61, 272.49, 0.0872665, 300, 0, 0), +(109768, 23444, 530, 1, 1, 0, 4012.26, 5910.36, 274.268, 3.01942, 300, 0, 0), +(109770, 23444, 530, 1, 1, 0, 4027.88, 5899.01, 276.829, 2.25147, 300, 0, 0), +(109774, 23444, 530, 1, 1, 0, 4027.71, 5899.27, 272.368, 3.75246, 300, 0, 0), +(109777, 23444, 530, 1, 1, 0, 4026.51, 5904.03, 268.377, 6.26573, 300, 0, 0), +(109779, 23444, 530, 1, 1, 0, 4025.83, 5887.44, 275.763, 0.314159, 300, 0, 0), +(109785, 23444, 530, 1, 1, 0, 4012.01, 5903.19, 269.512, 1.53589, 300, 0, 0), +(109802, 23444, 530, 1, 1, 0, 4028.61, 5904.03, 272.706, 5.34071, 300, 0, 0), +(109803, 23444, 530, 1, 1, 0, 4025.82, 5899.68, 268.112, 4.67748, 300, 0, 0), +(109804, 23444, 530, 1, 1, 0, 4024.19, 5884.32, 276.075, 0.0174533, 300, 0, 0), +(109811, 23444, 530, 1, 1, 0, 4016.7, 5878.5, 275.011, 4.59022, 300, 0, 0), +(109813, 23444, 530, 1, 1, 0, 4013.86, 5902.67, 276.362, 0.506145, 300, 0, 0), +(109814, 23444, 530, 1, 1, 0, 4030.21, 5899.13, 267.882, 4.57276, 300, 0, 0), +(109863, 23444, 530, 1, 1, 0, 4029.42, 5885.52, 267.808, 3.76991, 300, 0, 0), +(109899, 23444, 530, 1, 1, 0, 4011.63, 5905.28, 276.52, 0.191986, 300, 0, 0), +(109902, 23444, 530, 1, 1, 0, 4013.97, 5905.27, 275.847, 0.349066, 300, 0, 0), +(109917, 23444, 530, 1, 1, 0, 4023.53, 5889.88, 272.276, 5.44543, 300, 0, 0), +(109918, 23444, 530, 1, 1, 0, 4025.63, 5901.54, 276.751, 4.34587, 300, 0, 0); + +DELETE FROM `creature_template_movement` WHERE `CreatureId`=23444; +INSERT INTO `creature_template_movement` (`CreatureID`, `Ground`, `Swim`, `Flight`, `Rooted`) VALUES +(23444,0,0,1,0); |