diff options
| -rw-r--r-- | sql/updates/world/master/2021_11_23_04_world_2019_01_30_05_world.sql | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_23_04_world_2019_01_30_05_world.sql b/sql/updates/world/master/2021_11_23_04_world_2019_01_30_05_world.sql new file mode 100644 index 00000000000..8614f1b1a82 --- /dev/null +++ b/sql/updates/world/master/2021_11_23_04_world_2019_01_30_05_world.sql @@ -0,0 +1,47 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (43690,96909,96913,96920,96931,96939,96954,96955,96956,96957,96958,96959,96960,96961,96962,96963,96964,96965,96996,97143,97255,97256,97257,97258,97259,97261,97346,97352); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES +(43690, 23118, 530, '0', 0, 0, 0, 1724.264, 7378.032, 369.8983, 4.1538850, 300, 0, 0, 0, 0, 0), +(96909, 23119, 530, '0', 0, 0, 0, 1724.264, 7378.032, 369.8983, 4.1538850, 300, 0, 0, 0, 0, 0), +(96913, 23118, 530, '0', 0, 0, 0, 1699.965, 7339.737, 370.0056, 2.8274300, 300, 0, 0, 0, 0, 0), +(96920, 23119, 530, '0', 0, 0, 0, 1699.965, 7339.737, 370.0056, 2.8274300, 300, 0, 0, 0, 0, 0), +(96931, 23118, 530, '0', 0, 0, 0, 1635.728, 7236.379, 368.8360, 3.3850480, 300, 0, 0, 0, 0, 0), +(96939, 23119, 530, '0', 0, 0, 0, 1635.728, 7236.379, 368.8360, 3.3850480, 300, 0, 0, 0, 0, 0), +(96954, 23118, 530, '0', 0, 0, 0, 1650.052, 7206.133, 369.0356, 1.2217290, 300, 0, 0, 0, 0, 0), +(96955, 23119, 530, '0', 0, 0, 0, 1650.052, 7206.133, 369.0356, 1.2217290, 300, 0, 0, 0, 0, 0), +(96956, 23118, 530, '0', 0, 0, 0, 1444.903, 7303.924, 373.7010, 2.9146900, 300, 0, 0, 0, 0, 0), +(96957, 23119, 530, '0', 0, 0, 0, 1444.903, 7303.924, 373.7010, 2.9146900, 300, 0, 0, 0, 0, 0), +(96958, 23118, 530, '0', 0, 0, 0, 1412.624, 7361.099, 370.1049, 0.2617982, 300, 0, 0, 0, 0, 0), +(96959, 23119, 530, '0', 0, 0, 0, 1412.624, 7361.099, 370.1049, 0.2617982, 300, 0, 0, 0, 0, 0), +(96960, 23118, 530, '0', 0, 0, 0, 1437.102, 7289.250, 373.7963, 0.4886912, 300, 0, 0, 0, 0, 0), +(96961, 23119, 530, '0', 0, 0, 0, 1437.102, 7289.250, 373.7963, 0.4886912, 300, 0, 0, 0, 0, 0), +(96962, 23118, 530, '0', 0, 0, 0, 1339.803, 7300.026, 368.5673, 0.3665176, 300, 0, 0, 0, 0, 0), +(96963, 23119, 530, '0', 0, 0, 0, 1339.803, 7300.026, 368.5673, 0.3665176, 300, 0, 0, 0, 0, 0), +(96964, 23118, 530, '0', 0, 0, 0, 1341.605, 7217.468, 375.0737, 1.3439010, 300, 0, 0, 0, 0, 0), +(96965, 23119, 530, '0', 0, 0, 0, 1341.605, 7217.468, 375.0737, 1.3439010, 300, 0, 0, 0, 0, 0), +(96996, 23118, 530, '0', 0, 0, 0, 1521.983, 7309.528, 367.4526, 0.6453460, 300, 0, 0, 0, 0, 0), +(97143, 23119, 530, '0', 0, 0, 0, 1521.983, 7309.528, 367.4526, 0.6453460, 300, 0, 0, 0, 0, 0), +(97255, 23118, 530, '0', 0, 0, 0, 1303.507, 7190.829, 371.5774, 3.2986870, 300, 0, 0, 0, 0, 0), +(97256, 23119, 530, '0', 0, 0, 0, 1303.507, 7190.829, 371.5774, 3.2986870, 300, 0, 0, 0, 0, 0), +(97257, 23118, 530, '0', 0, 0, 0, 1361.807, 7161.544, 371.1580, 0.1047193, 300, 0, 0, 0, 0, 0), +(97258, 23119, 530, '0', 0, 0, 0, 1361.807, 7161.544, 371.1580, 0.1047193, 300, 0, 0, 0, 0, 0), +(97259, 23118, 530, '0', 0, 0, 0, 1448.179, 7207.929, 369.0707, 5.5676010, 300, 0, 0, 0, 0, 0), +(97261, 23119, 530, '0', 0, 0, 0, 1448.179, 7207.929, 369.0707, 5.5676010, 300, 0, 0, 0, 0, 0), +(97346, 23118, 530, '0', 0, 0, 0, 1508.000, 7209.453, 370.4677, 0.2094394, 300, 0, 0, 0, 0, 0), +(97352, 23119, 530, '0', 0, 0, 0, 1508.000, 7209.453, 370.4677, 0.2094394, 300, 0, 0, 0, 0, 0); + +UPDATE `creature` SET `spawntimesecs`=30 WHERE `id` IN (23118); +UPDATE `gameobject` SET `spawntimesecs`=30 WHERE `id` IN (185861); + + +DELETE FROM `gameobject` WHERE `guid` IN (27954,27955,27956,27957); +DELETE FROM `gameobject_addon` WHERE `guid` IN (27954,27955,27956,27957); + +UPDATE `gameobject_template` SET `AIName`='' WHERE `entry`=185861; +DELETE FROM `smart_scripts` WHERE `entryorguid`=185861 AND `source_type`=1; +DELETE FROM `smart_scripts` WHERE `entryorguid`=23118 AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(23118, 0, 0, 1, 8, 0, 100, 513, 40160, 0, 1000, 1000, 0, 33, 23118, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, 0, "Bombing Run Target Bunny - ON Spellhit 'Throw Bomb' - Quest Credit 'Bombing Run'"), +(23118, 0, 1, 2, 61, 0, 100, 512, 0, 0, 0, 0, 0, 45, 0, 1, 0, 0, 0, 0, 19, 23119, 3, 0, 0, 0, 0, 0, 0, "Bombing Run Target Bunny - On Spellhit 'Throw Bomb' - Set Data 0 1"), +(23118, 0, 2, 3, 61, 0, 100, 512, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 20, 185861, 3, 0, 0, 0, 0, 0, 0, "Bombing Run Target Bunny - On Spellhit 'Throw Bomb' - despawn"), +(23118, 0, 3, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 41, 10, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, "Bombing Run Target Bunny - On Spellhit 'Throw Bomb' - despawn"); |