diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_04_15_04_world.sql | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_04_15_04_world.sql b/sql/updates/world/3.3.5/2019_04_15_04_world.sql new file mode 100644 index 00000000000..b39c1e73dff --- /dev/null +++ b/sql/updates/world/3.3.5/2019_04_15_04_world.sql @@ -0,0 +1,56 @@ +-- +DELETE FROM `creature` WHERE `id` IN (17356,17357); +DELETE FROM `creature` WHERE `guid` IN (62804, 62805, 62806, 62807, 62808, 62809, 62810, 62811, 62812, 62813, 62814, 62815, 62816, 62817, 62818, 62819, 62820, 62821, 62822, 62823, 62824, 62825, 62826, 62827, 62828, 62829, 62830, 62831, 62832, 62833, 100256, 100259, 100260, 100261, 100262, 100263, 100264, 100265, 100266, 100267, 100268, 100345, 100347, 100348); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(62804, 17552, 540, 3714, 0, 3, 1, 0, 0, 165.1729, 278.9961, 7.502974, 0.5861885, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17552 (Area: 0 - Difficulty: 0) +(62805, 17552, 540, 3714, 0, 3, 1, 0, 0, 179.6241, 258.1517, 7.795619, 0.6800787, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17552 (Area: 0 - Difficulty: 0) +(62806, 17552, 540, 3714, 0, 3, 1, 0, 0, 191.091, 279.1522, 6.347817, 1.003119, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17552 (Area: 0 - Difficulty: 0) +(62807, 17356, 540, 3714, 0, 3, 1, 0, 0, 147.7169, 178.2593, -44.38002, 4.22875, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17356 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(62808, 17356, 540, 3714, 0, 3, 1, 0, 0, 162.6588, 168.309, -42.24934, 5.462881, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17356 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(62809, 17356, 540, 3714, 0, 3, 1, 0, 0, 124.67, 208.1592, -48.79198, 4.39823, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17356 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(62810, 17356, 540, 3714, 0, 3, 1, 0, 0, 135.8837, 190.9303, -47.383, 5.608172, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17356 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(62811, 17356, 540, 3714, 0, 3, 1, 0, 0, 193.1324, 160.608, -42.27916, 4.485496, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17356 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(62812, 17356, 540, 3714, 0, 3, 1, 0, 0, 176.3961, 164.5533, -42.17995, 3.543018, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17356 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(62813, 17357, 540, 3714, 0, 3, 1, 0, 0, 132.9617, 187.7873, -47.31559, 5.43473, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62814, 17357, 540, 3714, 0, 3, 1, 0, 0, 135.2929, 186.9761, -46.9382, 5.375614, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62815, 17357, 540, 3714, 0, 3, 1, 0, 0, 137.7909, 187.9358, -46.77151, 1.957681, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62816, 17357, 540, 3714, 0, 3, 1, 0, 0, 144.5355, 179.0214, -44.82866, 3.403392, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62817, 17357, 540, 3714, 0, 3, 1, 0, 0, 135.44, 189.626, -47.2776, 2.405689, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62818, 17357, 540, 3714, 0, 3, 1, 0, 0, 149.42, 175.0529, -43.94982, 5.218534, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62819, 17357, 540, 3714, 0, 3, 1, 0, 0, 146.4795, 176.4568, -44.35078, 4.328718, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62820, 17357, 540, 3714, 0, 3, 1, 0, 0, 137.1838, 189.4209, -47.02037, 4.148848, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62821, 17357, 540, 3714, 0, 3, 1, 0, 0, 146.3137, 181.6002, -44.91972, 1.37512, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62822, 17357, 540, 3714, 0, 3, 1, 0, 0, 134.6246, 191.8294, -47.64391, 2.267168, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62823, 17357, 540, 3714, 0, 3, 1, 0, 0, 123.3199, 206.1019, -48.70372, 1.64061, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62824, 17357, 540, 3714, 0, 3, 1, 0, 0, 122.555, 211.5383, -48.68718, 3.944444, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62825, 17357, 540, 3714, 0, 3, 1, 0, 0, 159.3373, 168.9375, -42.64615, 2.199115, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62826, 17357, 540, 3714, 0, 3, 1, 0, 0, 126.7974, 206.1154, -48.74623, 2.635447, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62827, 17357, 540, 3714, 0, 3, 1, 0, 0, 147.7949, 181.0374, -44.69219, 0.2065839, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62828, 17357, 540, 3714, 0, 3, 1, 0, 0, 161.4219, 165.3435, -42.2533, 0.3141593, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62829, 17357, 540, 3714, 0, 3, 1, 0, 0, 127.3508, 209.8471, -48.99863, 2.356194, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62830, 17357, 540, 3714, 0, 3, 1, 0, 0, 125.3769, 211.8038, -48.79873, 4.29351, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62831, 17357, 540, 3714, 0, 3, 1, 0, 0, 161.2182, 172.7577, -42.60646, 4.24115, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62832, 17357, 540, 3714, 0, 3, 1, 0, 0, 160.4581, 174.5785, -42.86815, 2.019137, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(62833, 17357, 540, 3714, 0, 3, 1, 0, 0, 159.2364, 171.2278, -42.84286, 2.043496, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(100256, 17357, 540, 3714, 0, 3, 1, 0, 0, 121.046, 208.516, -48.987, 4.641593, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(100259, 17357, 540, 3714, 0, 3, 1, 0, 0, 159.4344, 166.4781, -42.56333, 3.155734, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(100260, 17357, 540, 3714, 0, 3, 1, 0, 0, 138.8146, 190.5271, -47.00688, 2.866727, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(100261, 17357, 540, 3714, 0, 3, 1, 0, 0, 180.5346, 167.06, -42.06567, 0.541052, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) +(100262, 17357, 540, 3714, 0, 3, 1, 0, 0, 174.4139, 168.0857, -41.9549, 0.7504916, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) +(100263, 17357, 540, 3714, 0, 3, 1, 0, 0, 181.0854, 163.7843, -42.1274, 2.617994, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) +(100264, 17357, 540, 3714, 0, 3, 1, 0, 0, 174.1994, 162.2617, -42.25329, 0.3490658, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) +(100265, 17357, 540, 3714, 0, 3, 1, 0, 0, 193.9574, 165.1353, -42.27957, 3.857178, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(100266, 17357, 540, 3714, 0, 3, 1, 0, 0, 190.2543, 163.6376, -42.26886, 0.7330383, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) +(100267, 17357, 540, 3714, 0, 3, 1, 0, 0, 175.3851, 167.3021, -42.07549, 2.215301, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(100268, 17357, 540, 3714, 0, 3, 1, 0, 0, 192.6443, 157.6837, -42.28234, 0.01745329, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(100345, 17357, 540, 3714, 0, 3, 1, 0, 0, 189.856, 159.6774, -42.27094, 2.9147, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) +(100347, 17357, 540, 3714, 0, 3, 1, 0, 0, 198.7017, 159.8853, -42.29678, 6.143559, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17357 (Area: 0 - Difficulty: 0) +(100348, 17357, 540, 3714, 0, 3, 1, 0, 0, 196.61, 162.742, -42.37, 2.991146, 7200, 7, 0, 0, 0, 1, 0, 0, 0, 14545); -- 17357 (Area: 0 - Difficulty: 0) (Auras: ) + +DELETE FROM `creature_addon` WHERE `guid` IN (62820,62823,62825,62832); +DELETE FROM `waypoint_data` WHERE `id` IN (628200, 628230, 628250, 628320); + +UPDATE `creature_template` SET `flags_extra`= `flags_extra`|128 WHERE `entry`=17552; +DELETE FROM `creature_template_movement` WHERE `CreatureId`= 17552; +INSERT INTO `creature_template_movement` (`CreatureId`,`Ground`,`Swim`,`Flight`,`Rooted`) VALUES +(17552, 0, 0, 1, 0); |