From 4ad3f56bdfe9ab4477baf55cc602a7b072f27acc Mon Sep 17 00:00:00 2001 From: Ovah Date: Tue, 8 Sep 2020 17:24:21 +0200 Subject: DB: Rename SQL file added in dad187615df603ad8614531a0ec84c1a5e136838 --- sql/updates/world/3.3.5/2020_08_xx_xx_world.sql | 15 --------------- sql/updates/world/3.3.5/2020_09_08_00_world | 15 +++++++++++++++ 2 files changed, 15 insertions(+), 15 deletions(-) delete mode 100644 sql/updates/world/3.3.5/2020_08_xx_xx_world.sql create mode 100644 sql/updates/world/3.3.5/2020_09_08_00_world (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2020_08_xx_xx_world.sql b/sql/updates/world/3.3.5/2020_08_xx_xx_world.sql deleted file mode 100644 index 97bfb0b992d..00000000000 --- a/sql/updates/world/3.3.5/2020_08_xx_xx_world.sql +++ /dev/null @@ -1,15 +0,0 @@ --- Disable movement flag updates for Grauf and let script handle them -UPDATE `creature_template` SET `flags_extra` = `flags_extra`| 0x200 WHERE `entry`=26893; --- Disable movement flag updates for Blood-Queen Lana'thel -UPDATE `creature_template_movement` SET `Ground`= 1, `Flight`= 0 WHERE `CreatureId` IN (37955, 38434, 38435, 38436); -UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (37955, 38434, 38435, 38436); --- Disable movement flag updates for Malygos -UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (28859, 31734); --- Disable movement flag updates for Razorscale -UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (33186, 33724); -UPDATE `creature_template_movement` SET `Ground`= 1 WHERE `CreatureId` IN (33186, 33724); --- Disable movement flag updates for Enslaved Proto-Drake -UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (24083, 31669); -UPDATE `creature_template_movement` SET `Ground`= 1 WHERE `CreatureId` IN (24083, 31669); --- Disable movement flag updates for Enslaved Netherwing Drake -UPDATE `creature_template` SET `flags_extra` = `flags_extra`| 0x200 WHERE `entry`=21722; diff --git a/sql/updates/world/3.3.5/2020_09_08_00_world b/sql/updates/world/3.3.5/2020_09_08_00_world new file mode 100644 index 00000000000..97bfb0b992d --- /dev/null +++ b/sql/updates/world/3.3.5/2020_09_08_00_world @@ -0,0 +1,15 @@ +-- Disable movement flag updates for Grauf and let script handle them +UPDATE `creature_template` SET `flags_extra` = `flags_extra`| 0x200 WHERE `entry`=26893; +-- Disable movement flag updates for Blood-Queen Lana'thel +UPDATE `creature_template_movement` SET `Ground`= 1, `Flight`= 0 WHERE `CreatureId` IN (37955, 38434, 38435, 38436); +UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (37955, 38434, 38435, 38436); +-- Disable movement flag updates for Malygos +UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (28859, 31734); +-- Disable movement flag updates for Razorscale +UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (33186, 33724); +UPDATE `creature_template_movement` SET `Ground`= 1 WHERE `CreatureId` IN (33186, 33724); +-- Disable movement flag updates for Enslaved Proto-Drake +UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x200 WHERE `entry` IN (24083, 31669); +UPDATE `creature_template_movement` SET `Ground`= 1 WHERE `CreatureId` IN (24083, 31669); +-- Disable movement flag updates for Enslaved Netherwing Drake +UPDATE `creature_template` SET `flags_extra` = `flags_extra`| 0x200 WHERE `entry`=21722; -- cgit v1.2.3