DB/Pathing: Finish Winterspring Rndmmovement

* updates #15181
* actually we already did this in 03.15 together with the waypointmovement, but forgot to share it

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);