aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorWarpten <vertozor@gmail.com>2012-10-22 21:18:21 +0200
committerWarpten <vertozor@gmail.com>2012-10-22 21:18:21 +0200
commita664a356e2d069f3c136bb56485aeb12be866f28 (patch)
treeab287887c93c5e77820b52115a1dba38385e48e2 /sql
parent71f6b7d74bee986d80d233ae55cb6b3be17f499a (diff)
Scripts/Ruby Sanctum:
* Fixed a crash caused by the grid. * Update spawnmasks. * Misc updates and corrections. Closes #8079. Closes #8078. Closes #8081. Closes #8077.
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2012_10_14_00_world_creature.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2012_10_14_00_world_creature.sql b/sql/updates/world/2012_10_14_00_world_creature.sql
new file mode 100644
index 00000000000..dd650f37aef
--- /dev/null
+++ b/sql/updates/world/2012_10_14_00_world_creature.sql
@@ -0,0 +1,10 @@
+-- Spawnmask updates
+UPDATE `creature` SET `spawnMask`=15 WHERE `id` IN(40091, 40081);
+
+-- Auras updates (Now in script, can't be used in creature_addon because dynamically spawned)
+DELETE FROM `creature_template_addon` WHERE `entry` IN(39863, 40142);
+
+-- Blazing Aura
+-- NOTE: This still does not work, no clue why. Probably a core-side bug ?
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13,2,75886,0,0,31,0,3,40683,0,0,0, '', 'Blazing Aura can only target Living Embers');