diff options
| -rw-r--r-- | sql/updates/world/2015_07_31_04_world.sql | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_31_04_world.sql b/sql/updates/world/2015_07_31_04_world.sql new file mode 100644 index 00000000000..c125281d353 --- /dev/null +++ b/sql/updates/world/2015_07_31_04_world.sql @@ -0,0 +1,45 @@ +-- Winterspring Rndmmovement +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =49161; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =48935; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =49779; +UPDATE `creature` SET `spawndist` = 8, `MovementType` = 1 WHERE id =50258; +UPDATE `creature` SET `spawndist` = 8, `MovementType` = 1 WHERE id =7459; +UPDATE `creature` SET `spawndist` = 8, `MovementType` = 1 WHERE id =7460; +UPDATE `creature` SET `spawndist` = 8, `MovementType` = 1 WHERE id =7458; +UPDATE `creature` SET `spawndist` = 3, `MovementType` = 1 WHERE id =7438; +UPDATE `creature` SET `spawndist` = 8, `MovementType` = 1 WHERE id =7450; +UPDATE `creature` SET `spawndist` = 3, `MovementType` = 1 WHERE id =7439; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =48918; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =7443; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =7444; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =7455; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =7448; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =7433; +UPDATE `creature` SET `spawndist` = 3, `MovementType` = 1 WHERE id =7430; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =7448; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =7434; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =48952; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =7523; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =7524; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =48665; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =48664; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =48670; +UPDATE `creature` SET `spawndist` = 3, `MovementType` = 1 WHERE id =7442; +UPDATE `creature` SET `spawndist` = 3, `MovementType` = 1 WHERE id =7441; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =48768; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =48767; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =7452; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =7453; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =7451; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =7454; +UPDATE `creature` SET `spawndist` = 5, `MovementType` = 1 WHERE id =50250; +UPDATE `creature` SET `spawndist` = 3, `MovementType` = 1 WHERE id =51681; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =7431; +UPDATE `creature` SET `spawndist` = 10, `MovementType` = 1 WHERE id =7432; +UPDATE `creature` SET `spawndist`=5, `MovementType`=1 WHERE `guid` IN (277028, 277016, 277002); +UPDATE `creature` SET `spawndist`=10, `MovementType`=1 WHERE `guid` IN (277004); +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=50282; +DELETE FROM `creature` WHERE `guid` IN (278016,277241,277234,278024,277131,277135,277139, 277139,277144,278026,277138,277128, 277227, 278033, 278042, 278010,278011,278005, 278041,277134,277165,278072,277138,278026,278023, 277146,278006,277239,277143,278001,278000,277133,277999,277246,277240,277129); +UPDATE `creature` SET `spawndist`=5, `MovementType`=1 WHERE `id` IN (49346, 49347); +UPDATE `creature` SET `spawndist`=15, `MovementType`=1 WHERE `id` IN (7456); +UPDATE `creature` SET `spawndist`=10, `MovementType`=1 WHERE `id` IN (50044); |