diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_05_22_04_world.sql | 147 |
1 files changed, 147 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_05_22_04_world.sql b/sql/updates/world/3.3.5/2019_05_22_04_world.sql new file mode 100644 index 00000000000..f93466332d4 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_05_22_04_world.sql @@ -0,0 +1,147 @@ +-- +DELETE FROM `creature` WHERE `id` IN (21303,21304); +DELETE FROM `creature` WHERE `guid` IN (105952, 105954, 105955, 105957, 105968, 105970, 105975, 105978, 105980, 105981, 105982, 105983, 105984, 105985, 105986, 105995, 105996, 106073, 106118, 106239, 106245, 106246, 106248, 106252, 106253, 106254, 106262, 106263, 106264, 106289, 106290, 106291, 106292, 106293, 106294, 106295, 106296, 106297, 106298, 106299, 106300, 106301, 106324, 106325) AND `id` IN (21303,21304); +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 +(105952, 21303, 552, 0, 0, 3, 1, 0, 1, 206.342, -98.2784, -10.0262, 2.652900, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106252, 21304, 552, 0, 0, 3, 1, 0, 1, 206.342, -98.2784, -10.0262, 2.652900, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106248, 21304, 552, 0, 0, 3, 1, 0, 1, 197.795, -86.5381, -10.1018, 5.903840, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105954, 21303, 552, 0, 0, 3, 1, 0, 1, 197.795, -86.5381, -10.1018, 5.903840, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106253, 21304, 552, 0, 0, 3, 1, 0, 1, 213.626, -161.424, -10.0346, 2.740170, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105955, 21303, 552, 0, 0, 3, 1, 0, 1, 213.626, -161.424, -10.0346, 2.740170, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106254, 21304, 552, 0, 0, 3, 1, 0, 1, 273.438, -64.0700, 22.45340, 22.45340, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105957, 21303, 552, 0, 0, 3, 1, 0, 1, 273.438, -64.0700, 22.45340, 22.45340, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106262, 21304, 552, 0, 0, 3, 1, 0, 1, 270.819, -45.4794, 22.45340, 4.468040, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105968, 21303, 552, 0, 0, 3, 1, 0, 1, 270.819, -45.4794, 22.45340, 4.468040, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105970, 21303, 552, 0, 0, 3, 1, 0, 1, 226.184, -162.096, -10.0352, 0.349066, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106263, 21304, 552, 0, 0, 3, 1, 0, 1, 226.184, -162.096, -10.0352, 0.349066, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105975, 21303, 552, 0, 0, 3, 1, 0, 1, 245.982, -194.617, -10.0217, 0.872665, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106264, 21304, 552, 0, 0, 3, 1, 0, 1, 245.982, -194.617, -10.0217, 0.872665, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105978, 21303, 552, 0, 0, 3, 1, 0, 1, 285.416, 127.1270, 22.29510, 4.694940, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106289, 21304, 552, 0, 0, 3, 1, 0, 1, 285.416, 127.1270, 22.29510, 4.694940, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105980, 21303, 552, 0, 0, 3, 1, 0, 1, 253.689, 139.8680, 22.41210, 2.303830, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106290, 21304, 552, 0, 0, 3, 1, 0, 1, 253.689, 139.8680, 22.41210, 2.303830, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105981, 21303, 552, 0, 0, 3, 1, 0, 1, 253.951, 155.0010, 22.38060, 4.939280, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106291, 21304, 552, 0, 0, 3, 1, 0, 1, 253.951, 155.0010, 22.38060, 4.939280, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105982, 21303, 552, 0, 0, 3, 1, 0, 1, 298.848, 151.7480, 22.31050, 5.707230, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106292, 21304, 552, 0, 0, 3, 1, 0, 1, 298.848, 151.7480, 22.31050, 5.707230, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105983, 21303, 552, 0, 0, 3, 1, 0, 1, 306.976, 141.1120, 22.22860, 3.028500, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106293, 21304, 552, 0, 0, 3, 1, 0, 1, 306.976, 141.1120, 22.22860, 3.028500, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105984, 21303, 552, 0, 0, 3, 1, 0, 1, 272.501, -40.1927, 22.50900, 2.914700, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106294, 21304, 552, 0, 0, 3, 1, 0, 1, 272.501, -40.1927, 22.50900, 2.914700, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105985, 21303, 552, 0, 0, 3, 1, 0, 1, 232.754, -198.125, -10.0230, 5.619960, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106295, 21304, 552, 0, 0, 3, 1, 0, 1, 232.754, -198.125, -10.0230, 5.619960, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105986, 21303, 552, 0, 0, 3, 1, 0, 1, 262.560, -65.5981, 22.45340, 1.500980, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106296, 21304, 552, 0, 0, 3, 1, 0, 1, 262.560, -65.5981, 22.45340, 1.500980, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105995, 21303, 552, 0, 0, 3, 1, 0, 1, 312.929, -7.19062, 22.52450, 4.031710, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106297, 21304, 552, 0, 0, 3, 1, 0, 1, 312.929, -7.19062, 22.52450, 4.031710, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(105996, 21303, 552, 0, 0, 3, 1, 0, 1, 311.119, -5.50369, 22.52450, 1.570800, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106298, 21304, 552, 0, 0, 3, 1, 0, 1, 311.119, -5.50369, 22.52450, 1.570800, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106073, 21303, 552, 0, 0, 3, 1, 0, 1, 293.885, 70.93680, 22.52620, 1.553340, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106299, 21304, 552, 0, 0, 3, 1, 0, 1, 293.885, 70.93680, 22.52620, 1.553340, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106118, 21303, 552, 0, 0, 3, 1, 0, 1, 291.632, 70.58090, 22.52690, 2.007130, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106300, 21304, 552, 0, 0, 3, 1, 0, 1, 291.632, 70.58090, 22.52690, 2.007130, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106239, 21303, 552, 0, 0, 3, 1, 0, 1, 397.070, 25.33310, 48.29600, 0.523599, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106301, 21304, 552, 0, 0, 3, 1, 0, 1, 397.070, 25.33310, 48.29600, 0.523599, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106245, 21303, 552, 0, 0, 3, 1, 0, 1, 392.004, 18.38570, 48.29600, 1.483530, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106324, 21304, 552, 0, 0, 3, 1, 0, 1, 392.004, 18.38570, 48.29600, 1.483530, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106246, 21303, 552, 0, 0, 3, 1, 0, 1, 257.344, 155.5680, 22.33210, 4.712390, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0), +(106325, 21304, 552, 0, 0, 3, 1, 0, 1, 257.344, 155.5680, 22.33210, 4.712390, 86400, 0, 0, 20283, 0, 0, 0, 0, 0, 0); +UPDATE `creature_template_addon` SET `bytes1`=7, `bytes2`=1, `auras`="29266" WHERE `entry` IN (21303,21304); + +DELETE FROM `pool_pool` WHERE `mother_pool`=598; +INSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`) VALUES +(576, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 1'), +(577, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 2'), +(578, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 3'), +(579, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 4'), +(580, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 5'), +(581, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 6'), +(582, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 7'), +(583, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 8'), +(584, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 9'), +(585, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 10'), +(586, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 11'), +(587, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 12'), +(588, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 13'), +(589, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 14'), +(590, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 15'), +(591, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 16'), +(592, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 17'), +(593, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 18'), +(594, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 19'), +(595, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 20'), +(596, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 21'), +(597, 598, 0, 'Arcatraz - Warder/Defender Corpses - Pool 22'); + +DELETE FROM `pool_template` WHERE `entry` IN (576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598); +INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES +(576, 1, 'Arcatraz - Warder/Defender Corpses - Pool 1'), +(577, 1, 'Arcatraz - Warder/Defender Corpses - Pool 2'), +(578, 1, 'Arcatraz - Warder/Defender Corpses - Pool 3'), +(579, 1, 'Arcatraz - Warder/Defender Corpses - Pool 4'), +(580, 1, 'Arcatraz - Warder/Defender Corpses - Pool 5'), +(581, 1, 'Arcatraz - Warder/Defender Corpses - Pool 6'), +(582, 1, 'Arcatraz - Warder/Defender Corpses - Pool 7'), +(583, 1, 'Arcatraz - Warder/Defender Corpses - Pool 8'), +(584, 1, 'Arcatraz - Warder/Defender Corpses - Pool 9'), +(585, 1, 'Arcatraz - Warder/Defender Corpses - Pool 10'), +(586, 1, 'Arcatraz - Warder/Defender Corpses - Pool 11'), +(587, 1, 'Arcatraz - Warder/Defender Corpses - Pool 12'), +(588, 1, 'Arcatraz - Warder/Defender Corpses - Pool 13'), +(589, 1, 'Arcatraz - Warder/Defender Corpses - Pool 14'), +(590, 1, 'Arcatraz - Warder/Defender Corpses - Pool 15'), +(591, 1, 'Arcatraz - Warder/Defender Corpses - Pool 16'), +(592, 1, 'Arcatraz - Warder/Defender Corpses - Pool 17'), +(593, 1, 'Arcatraz - Warder/Defender Corpses - Pool 18'), +(594, 1, 'Arcatraz - Warder/Defender Corpses - Pool 19'), +(595, 1, 'Arcatraz - Warder/Defender Corpses - Pool 20'), +(596, 1, 'Arcatraz - Warder/Defender Corpses - Pool 21'), +(597, 1, 'Arcatraz - Warder/Defender Corpses - Pool 22'), +(598, 16, 'Arcatraz - Warder/Defender Corpses - Master Pool'); + +DELETE FROM `pool_creature` WHERE `pool_entry` IN (576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597); +INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES +(105952, 576, 0, 'Arcatraz - Defender Corpse - Pool 1'), +(106252, 576, 0, 'Arcatraz - Warder Corpse - Pool 1'), +(106248, 577, 0, 'Arcatraz - Defender Corpse - Pool 2'), +(105954, 577, 0, 'Arcatraz - Warder Corpse - Pool 2'), +(106253, 578, 0, 'Arcatraz - Defender Corpse - Pool 3'), +(105955, 578, 0, 'Arcatraz - Warder Corpse - Pool 3'), +(106254, 579, 0, 'Arcatraz - Defender Corpse - Pool 4'), +(105957, 579, 0, 'Arcatraz - Warder Corpse - Pool 4'), +(106262, 580, 0, 'Arcatraz - Defender Corpse - Pool 5'), +(105968, 580, 0, 'Arcatraz - Warder Corpse - Pool 5'), +(105970, 581, 0, 'Arcatraz - Defender Corpse - Pool 6'), +(106263, 581, 0, 'Arcatraz - Warder Corpse - Pool 6'), +(105975, 582, 0, 'Arcatraz - Defender Corpse - Pool 7'), +(106264, 582, 0, 'Arcatraz - Warder Corpse - Pool 7'), +(105978, 583, 0, 'Arcatraz - Defender Corpse - Pool 8'), +(106289, 583, 0, 'Arcatraz - Warder Corpse - Pool 8'), +(105980, 584, 0, 'Arcatraz - Defender Corpse - Pool 9'), +(106290, 584, 0, 'Arcatraz - Warder Corpse - Pool 9'), +(105981, 585, 0, 'Arcatraz - Defender Corpse - Pool 10'), +(106291, 585, 0, 'Arcatraz - Warder Corpse - Pool 10'), +(105982, 586, 0, 'Arcatraz - Defender Corpse - Pool 11'), +(106292, 586, 0, 'Arcatraz - Warder Corpse - Pool 11'), +(105983, 587, 0, 'Arcatraz - Defender Corpse - Pool 12'), +(106293, 587, 0, 'Arcatraz - Warder Corpse - Pool 12'), +(105984, 588, 0, 'Arcatraz - Defender Corpse - Pool 13'), +(106294, 588, 0, 'Arcatraz - Warder Corpse - Pool 13'), +(105985, 589, 0, 'Arcatraz - Defender Corpse - Pool 14'), +(106295, 589, 0, 'Arcatraz - Warder Corpse - Pool 14'), +(105986, 590, 0, 'Arcatraz - Defender Corpse - Pool 15'), +(106296, 590, 0, 'Arcatraz - Warder Corpse - Pool 15'), +(105995, 591, 0, 'Arcatraz - Defender Corpse - Pool 16'), +(106297, 591, 0, 'Arcatraz - Warder Corpse - Pool 16'), +(105996, 592, 0, 'Arcatraz - Defender Corpse - Pool 17'), +(106298, 592, 0, 'Arcatraz - Warder Corpse - Pool 17'), +(106073, 593, 0, 'Arcatraz - Defender Corpse - Pool 18'), +(106299, 593, 0, 'Arcatraz - Warder Corpse - Pool 18'), +(106118, 594, 0, 'Arcatraz - Defender Corpse - Pool 19'), +(106300, 594, 0, 'Arcatraz - Warder Corpse - Pool 19'), +(106239, 595, 0, 'Arcatraz - Defender Corpse - Pool 20'), +(106301, 595, 0, 'Arcatraz - Warder Corpse - Pool 20'), +(106245, 596, 0, 'Arcatraz - Defender Corpse - Pool 21'), +(106324, 596, 0, 'Arcatraz - Warder Corpse - Pool 21'), +(106246, 597, 0, 'Arcatraz - Defender Corpse - Pool 22'), +(106325, 597, 0, 'Arcatraz - Warder Corpse - Pool 22'); |