aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorDiscover- <amort11@hotmail.com>2012-03-04 02:45:21 +0100
committerDiscover- <amort11@hotmail.com>2012-03-04 02:45:21 +0100
commitc48a1ad17db9b623795d24bbe83d77247b6ef756 (patch)
treee547e8fb172095e03d8078e9360d0a9355247fb3 /sql
parentc4fd6b89dba06ad8e42065f8aebeb8101d4ccaab (diff)
Scripts/Misc: Script entrance areatriggers for Area 52.
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2012_03_04_00_world_creature_template_addon.sql13
1 files changed, 13 insertions, 0 deletions
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
new file mode 100644
index 00000000000..358dc651735
--- /dev/null
+++ b/sql/updates/world/2012_03_04_00_world_creature_template_addon.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_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");