DB/Creatures: Added missing movement override data

1 files changed, 53 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_05_06_01_world.sql b/sql/updates/world/master/2024_05_06_01_world.sql
new file mode 100644
index 00000000000..21101bfcde8
--- /dev/null
+++ b/sql/updates/world/master/2024_05_06_01_world.sql
@@ -0,0 +1,53 @@
+DELETE FROM `creature_movement_override` WHERE `SpawnId` NOT IN (851331,6000693,6000695,6000700,6000707,6000708,6000709,6000721,6000723,6000727,6000729,6000732,6000736,6000763);
+UPDATE `creature_movement_override` SET `HoverInitiallyEnabled`=0 WHERE `SpawnId` IN (6000693,6000695,6000700,6000707,6000708,6000709,6000721,6000723,6000727,6000729,6000732,6000736,6000763);
+
+DELETE FROM `creature_static_flags_override` WHERE `SpawnId` IN (106339, 106340, 125724, 395475, 395522, 395523, 395542, 395570, 460002, 460043, 650356, 850856, 850858, 850861, 850862, 850864, 850865, 850866, 850867, 850868, 850871, 850973, 851014, 851023, 851084, 851100, 851115, 851127, 851155, 851158, 851182, 851194, 851201, 1050851, 1050886, 1050973, 1050980, 1050981, 1051014, 6000695, 8000023, 8000024, 9000012, 9000013, 9000211, 9000224, 9001454, 9001469);
+INSERT INTO `creature_static_flags_override` (`SpawnId`, `DifficultyId`, `StaticFlags1`, `StaticFlags2`, `StaticFlags3`, `StaticFlags4`, `StaticFlags5`, `StaticFlags6`, `StaticFlags7`, `StaticFlags8`) VALUES
+(106339, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(106340, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(125724, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(395475, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(395522, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(395523, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(395542, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(395570, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(460002, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(460043, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(650356, 0, 0x0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(850856, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(850858, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(850861, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(850862, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(850864, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(850865, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(850866, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(850867, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(850868, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(850871, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(850973, 0, 0x100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(851014, 0, 0x100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(851023, 0, 0x100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(851084, 0, 0x100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(851100, 0, 0x100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(851115, 0, 0x100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(851127, 0, 0x100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(851155, 0, 0x100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(851158, 0, 0x100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(851182, 0, 0x100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(851194, 0, 0x100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(851201, 0, 0x100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1050851, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1050886, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1050973, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1050980, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1050981, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1051014, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(6000695, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(8000023, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(8000024, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(9000012, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(9000013, 0, 0x20000100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(9000211, 0, 0x0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(9000224, 0, 0x0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(9001454, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(9001469, 0, 0x20000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL);