diff options
| author | Kaelima <kaelima@live.se> | 2012-10-23 03:58:48 -0700 |
|---|---|---|
| committer | Kaelima <kaelima@live.se> | 2012-10-23 03:58:48 -0700 |
| commit | 1ff5b836570332a80c7749cf69bbc47f172f7f28 (patch) | |
| tree | bfffbe3621e3951c3f2b5966733b75ad43f83540 /sql | |
| parent | 1be638e7310bdd362566a6dc463bf94950d50616 (diff) | |
| parent | a664a356e2d069f3c136bb56485aeb12be866f28 (diff) | |
Merge pull request #8074 from Warpten/halionUpdate
Scripts/Ruby Sanctum: Misc fixes.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2012_10_14_00_world_creature.sql | 10 |
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'); |