From 1776b16773cbff1262ef62268b7a6827ac002c07 Mon Sep 17 00:00:00 2001 From: Discover- Date: Sun, 4 Mar 2012 13:19:47 +0100 Subject: DB/Misc: Fix SQL of c48a1ad17db9b623795d24bbe83d77247b6ef756 --- .../world/2012_03_04_00_world_creature_template_addon.sql | 13 ------------- sql/updates/world/2012_03_04_00_world_misc.sql | 13 +++++++++++++ 2 files changed, 13 insertions(+), 13 deletions(-) delete mode 100644 sql/updates/world/2012_03_04_00_world_creature_template_addon.sql create mode 100644 sql/updates/world/2012_03_04_00_world_misc.sql (limited to 'sql') diff --git a/sql/updates/world/2012_03_04_00_world_creature_template_addon.sql b/sql/updates/world/2012_03_04_00_world_creature_template_addon.sql deleted file mode 100644 index 358dc651735..00000000000 --- a/sql/updates/world/2012_03_04_00_world_creature_template_addon.sql +++ /dev/null @@ -1,13 +0,0 @@ --- Spotlight aura for spotlight NPC -DELETE FROM `creature_template_addon` WHERE `entry`=19913; -INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES -(19913,0,0,0,0,'39312'); - --- Scriptnames for areatriggers -SET @AT_AREA_52_SOUTHSET := 4472; -SET @AT_AREA_52_NORTHSET := 4466; -SET @AT_AREA_52_WESTSET := 4471; -SET @AT_AREA_52_EASTSET := 4422; -DELETE FROM `areatrigger_scripts` WHERE `entry` IN (@AT_AREA_52_SOUTH,@AT_AREA_52_NORTH,@AT_AREA_52_WEST,@AT_AREA_52_EAST) -INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES -(@AT_AREA_52_SOUTH,"at_area_52_entrance"),(@AT_AREA_52_NORTH,"at_area_52_entrance"),(@AT_AREA_52_WEST,"at_area_52_entrance"),(@AT_AREA_52_EAST,"at_area_52_entrance"); diff --git a/sql/updates/world/2012_03_04_00_world_misc.sql b/sql/updates/world/2012_03_04_00_world_misc.sql new file mode 100644 index 00000000000..af556f648b8 --- /dev/null +++ b/sql/updates/world/2012_03_04_00_world_misc.sql @@ -0,0 +1,13 @@ +-- Spotlight aura for spotlight NPC +DELETE FROM `creature_template_addon` WHERE `entry`=19913; +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(19913,0,0,0,0,'39312'); + +-- Scriptnames for areatriggers +SET @AT_AREA_52_SOUTH := 4472; +SET @AT_AREA_52_NORTH := 4466; +SET @AT_AREA_52_WEST := 4471; +SET @AT_AREA_52_EAST := 4422; +DELETE FROM `areatrigger_scripts` WHERE `entry` IN (@AT_AREA_52_SOUTH,@AT_AREA_52_NORTH,@AT_AREA_52_WEST,@AT_AREA_52_EAST); +INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES +(@AT_AREA_52_SOUTH,"at_area_52_entrance"),(@AT_AREA_52_NORTH,"at_area_52_entrance"),(@AT_AREA_52_WEST,"at_area_52_entrance"),(@AT_AREA_52_EAST,"at_area_52_entrance"); -- cgit v1.2.3