diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_04_01_02_world.sql | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_04_01_02_world.sql b/sql/updates/world/3.3.5/2019_04_01_02_world.sql new file mode 100644 index 00000000000..3476afaa2f3 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_04_01_02_world.sql @@ -0,0 +1,50 @@ +-- +DELETE FROM `spawn_group` WHERE `SpawnId` IN (SELECT `guid` FROM `creature` WHERE `id`=17199) AND `spawnType`=0; +DELETE FROM `creature` WHERE `id` IN (17199); +DELETE FROM `creature` WHERE guid IN (97922, 97923, 97924, 97925, 97926, 97933, 97934, 97935, 97936, 97937, 97938, 97939, 97941, 97943, 97944, 97967, 97969, 97970, 97971, 97972, 97973, 97974, 97975, 97976, 97977, 97978, 97979, 97980, 97981, 97993, 98029, 98077, 98151, 98171, 98195, 98196, 98230, 98248, 98263, 98308, 98342, 98343, 98347, 98349); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES +(97922, 17199, 530, 1, 1, 0, 0, -3120.12, -12710.9, 5.13408, 0.699321, 300, 5, 0, 176, 0, 1), +(97923, 17199, 530, 1, 1, 0, 0, -3176.76, -12719.3, 15.798, 2.73415, 300, 5, 0, 176, 0, 1), +(97924, 17199, 530, 1, 1, 0, 0, -3156.42, -12709.7, 12.448, 0.475577, 300, 5, 0, 176, 0, 1), +(97925, 17199, 530, 1, 1, 0, 0, -3140.3, -12697.6, 12.4179, 5.73741, 300, 5, 0, 176, 0, 1), +(97926, 17199, 530, 1, 1, 0, 0, -3118.94, -12684.6, 10.9932, 6.11986, 300, 5, 0, 176, 0, 1), +(97933, 17199, 530, 1, 1, 0, 0, -3218.03, -12713.4, 25.3786, 2.40778, 300, 5, 0, 176, 0, 1), +(97934, 17199, 530, 1, 1, 0, 0, -3143.65, -12646.3, 25.3452, 3.01777, 300, 5, 0, 176, 0, 1), +(97935, 17199, 530, 1, 1, 0, 0, -3247.22, -12718, 24.9263, 3.33018, 300, 5, 0, 176, 0, 1), +(97936, 17199, 530, 1, 1, 0, 0, -3245.97, -12670.3, 32.0543, 4.79995, 300, 5, 0, 176, 0, 1), +(97937, 17199, 530, 1, 1, 0, 0, -3108.8, -12608.5, 26.3195, 1.69338, 300, 5, 0, 176, 0, 1), +(97938, 17199, 530, 1, 1, 0, 0, -3280.49, -12681.3, 24.7055, 3.37199, 300, 5, 0, 176, 0, 1), +(97939, 17199, 530, 1, 1, 0, 0, -3284.35, -12716.2, 21.6305, 6.22177, 300, 5, 0, 176, 0, 1), +(97941, 17199, 530, 1, 1, 0, 0, -3324.66, -12686.6, 20.7186, 2.92973, 300, 5, 0, 176, 0, 1), +(97943, 17199, 530, 1, 1, 0, 0, -3342.84, -12748.9, 15.5701, 0.109579, 300, 5, 0, 176, 0, 1), +(97944, 17199, 530, 1, 1, 0, 0, -3252.54, -12786.9, 20.6558, 5.27945, 300, 5, 0, 176, 0, 1), +(97967, 17199, 530, 1, 1, 0, 0, -3281.98, -12751.6, 20.3169, 6.03253, 300, 5, 0, 176, 0, 1), +(97969, 17199, 530, 1, 1, 0, 0, -3387.31, -12747.5, 13.377, 4.85616, 300, 5, 0, 176, 0, 1), +(97970, 17199, 530, 1, 1, 0, 0, -3376.31, -12650.6, 29.1723, 0.583667, 300, 5, 0, 176, 0, 1), +(97971, 17199, 530, 1, 1, 0, 0, -3145.11, -12617, 32.5336, 0.867047, 300, 5, 0, 176, 0, 1), +(97972, 17199, 530, 1, 1, 0, 0, -3079.73, -12610, 17.9235, 3.66559, 300, 5, 0, 176, 0, 1), +(97973, 17199, 530, 1, 1, 0, 0, -3067.45, -12640.4, 8.76546, 0.278506, 300, 5, 0, 176, 0, 1), +(97974, 17199, 530, 1, 1, 0, 0, -3182.59, -12651.2, 29.9848, 3.89063, 300, 5, 0, 176, 0, 1), +(97975, 17199, 530, 1, 1, 0, 0, -3090.59, -12655.5, 11.8905, 4.2916, 300, 5, 0, 176, 0, 1), +(97976, 17199, 530, 1, 1, 0, 0, -3374.81, -12673.2, 21.4849, 3.50184, 300, 5, 0, 176, 0, 1), +(97977, 17199, 530, 1, 1, 0, 0, -3382.47, -12711.1, 18.5991, 0.652482, 300, 5, 0, 176, 0, 1), +(97978, 17199, 530, 1, 1, 0, 0, -3410.71, -12779.9, 14.1811, 0.386222, 300, 5, 0, 176, 0, 1), +(97979, 17199, 530, 1, 1, 0, 0, -3381.65, -12779.4, 14.6083, 0.140354, 300, 5, 0, 176, 0, 1), +(97980, 17199, 530, 1, 1, 0, 0, -3423.3, -12739.9, 11.6829, 3.90526, 300, 5, 0, 176, 0, 1), +(97981, 17199, 530, 1, 1, 0, 0, -3415.83, -12691.5, 21.2378, 3.59137, 300, 5, 0, 176, 0, 1), +(97993, 17199, 530, 1, 1, 0, 0, -3386.23, -12813.7, 13.1284, 4.55818, 300, 5, 0, 176, 0, 1), +(98029, 17199, 530, 1, 1, 0, 0, -3353.32, -12712, 17.6634, 1.62562, 300, 5, 0, 176, 0, 1), +(98077, 17199, 530, 1, 1, 0, 0, -3346.5, -12678.4, 20.7171, 0.478639, 300, 5, 0, 176, 0, 1), +(98151, 17199, 530, 1, 1, 0, 0, -3327.66, -12781.5, 19.2012, 2.11543, 300, 5, 0, 176, 0, 1), +(98171, 17199, 530, 1, 1, 0, 0, -3316.03, -12752.2, 17.1344, 2.58071, 300, 5, 0, 176, 0, 1), +(98195, 17199, 530, 1, 1, 0, 0, -3319.77, -12714.4, 24.8751, 0.537071, 300, 5, 0, 176, 0, 1), +(98196, 17199, 530, 1, 1, 0, 0, -3237.74, -12746.1, 23.9903, 0.624292, 300, 5, 0, 176, 0, 1), +(98230, 17199, 530, 1, 1, 0, 0, -3238.02, -12693.1, 28.4397, 3.36429, 300, 5, 0, 176, 0, 1), +(98248, 17199, 530, 1, 1, 0, 0, -3179, -12694, 19.9713, 1.71817, 300, 5, 0, 176, 0, 1), +(98263, 17199, 530, 1, 1, 0, 0, -3189.43, -12748.1, 13.416, 3.55688, 300, 5, 0, 176, 0, 1), +(98308, 17199, 530, 1, 1, 0, 0, -3225.23, -12642.2, 37.5313, 2.43577, 300, 5, 0, 176, 0, 1), +(98342, 17199, 530, 1, 1, 0, 0, -3270.63, -12656, 26.7487, 0.403353, 300, 5, 0, 176, 0, 1), +(98343, 17199, 530, 1, 1, 0, 0, -3128.22, -12662.3, 17.8892, 3.91911, 300, 5, 0, 176, 0, 1), +(98347, 17199, 530, 1, 1, 0, 0, -3091.63, -12709, 6.01611, 5.47875, 300, 5, 0, 176, 0, 1), +(98349, 17199, 530, 1, 1, 0, 0, -3083.81, -12680.9, 5.80764, 0.13918, 300, 5, 0, 176, 0, 1); +
\ No newline at end of file |