From 5d5cbf04dfdc5e962b8b9fadbdce7c0f95fd1483 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sat, 19 Jul 2014 14:14:23 +0200 Subject: DB/Creature: Fix startup errors --- .../world/2014_07_19_00_world_creature_misc.sql | 20 -------------------- .../world/2014_07_19_01_world_creature_misc.sql | 20 ++++++++++++++++++++ .../world/2014_07_19_03_world_creature_addon.sql | 5 +++++ 3 files changed, 25 insertions(+), 20 deletions(-) delete mode 100644 sql/updates/world/2014_07_19_00_world_creature_misc.sql create mode 100644 sql/updates/world/2014_07_19_01_world_creature_misc.sql create mode 100644 sql/updates/world/2014_07_19_03_world_creature_addon.sql diff --git a/sql/updates/world/2014_07_19_00_world_creature_misc.sql b/sql/updates/world/2014_07_19_00_world_creature_misc.sql deleted file mode 100644 index 1f8eba3d33c..00000000000 --- a/sql/updates/world/2014_07_19_00_world_creature_misc.sql +++ /dev/null @@ -1,20 +0,0 @@ -DELETE FROM `creature_addon` WHERE `guid` IN ( -132567, -132568, -132566, -132564, -132565, -132553, -132554, -132555, -132556, -132557, -132558, -132559, -132560, -132561, -132562, -132563); -DELETE FROM `creature_template_addon` WHERE `entry`=23051; -INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES -(23051, 0, 0x0, 0x1, ''); diff --git a/sql/updates/world/2014_07_19_01_world_creature_misc.sql b/sql/updates/world/2014_07_19_01_world_creature_misc.sql new file mode 100644 index 00000000000..1f8eba3d33c --- /dev/null +++ b/sql/updates/world/2014_07_19_01_world_creature_misc.sql @@ -0,0 +1,20 @@ +DELETE FROM `creature_addon` WHERE `guid` IN ( +132567, +132568, +132566, +132564, +132565, +132553, +132554, +132555, +132556, +132557, +132558, +132559, +132560, +132561, +132562, +132563); +DELETE FROM `creature_template_addon` WHERE `entry`=23051; +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(23051, 0, 0x0, 0x1, ''); diff --git a/sql/updates/world/2014_07_19_03_world_creature_addon.sql b/sql/updates/world/2014_07_19_03_world_creature_addon.sql new file mode 100644 index 00000000000..598e78ce16e --- /dev/null +++ b/sql/updates/world/2014_07_19_03_world_creature_addon.sql @@ -0,0 +1,5 @@ +DELETE FROM `creature_addon` WHERE `guid` IN ( +45221, +45222, +45223, +45224); -- cgit v1.2.3