aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorNay <dnpd.dd@gmail.com>2012-05-26 15:03:30 +0100
committerNay <dnpd.dd@gmail.com>2012-05-26 15:03:30 +0100
commita0028fca55cce5cebeb2d6ab5449ce2eeeabdf51 (patch)
treed04376153443378e7e98825a9a9d30f634bba72d
parent74da8dc41004adcea6167a4587bded4efa025387 (diff)
DB/Misc:
EAI: Fix unkillable Obsidian Nullifier in AQ Closes #2977 SAI: Use correct action_type for two SAI scripts (was 0) Closes #6569 and fixes DB startup errors
-rw-r--r--sql/updates/world/2012_05_26_00_world_scripts.sql20
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/2012_05_26_00_world_scripts.sql b/sql/updates/world/2012_05_26_00_world_scripts.sql
new file mode 100644
index 00000000000..18b0fa2f6b2
--- /dev/null
+++ b/sql/updates/world/2012_05_26_00_world_scripts.sql
@@ -0,0 +1,20 @@
+-- Correction for Obsidian Nullifier EAI
+UPDATE `creature_ai_scripts` SET
+ `action1_param1` = 23
+WHERE `id` = 1531201;
+
+-- Correction for Wildspawn Felsworn and Wildspawn Hellcaller SAI
+UPDATE `smart_scripts` SET
+ `event_phase_mask` = 2,
+ `action_type` = 22,
+ `action_param1` = 1,
+ `target_type` = 1
+WHERE
+ (`entryorguid` = 11457 AND
+ `source_type` = 0 AND
+ `id` = 10 AND
+ `link` = 0) OR
+ (`entryorguid` = 11455 AND
+ `source_type` = 0 AND
+ `id` = 11 AND
+ `link` = 0);