diff options
| author | Tome <tome@trinitycore.contrib> | 2011-07-05 01:01:19 +0200 |
|---|---|---|
| committer | click <click@gonnamakeyou.com> | 2011-07-05 01:01:19 +0200 |
| commit | fa29708759439d248b52e350abe02835d9062f48 (patch) | |
| tree | b88173bab955d318553cdc3ef61861b6a1f33d8f | |
| parent | 8eea1ef807f18b7000b56396b3497c6a7a43447b (diff) | |
DB: Clean up some EAI-scripts and creature templates (already converted, deprecated or missing the AI)
| -rw-r--r-- | sql/updates/world/2011_07_04_04_world_creature_ai_scripts.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2011_07_04_04_world_creature_ai_scripts.sql b/sql/updates/world/2011_07_04_04_world_creature_ai_scripts.sql new file mode 100644 index 00000000000..19d97d48a12 --- /dev/null +++ b/sql/updates/world/2011_07_04_04_world_creature_ai_scripts.sql @@ -0,0 +1,9 @@ +-- Remove EAI events for Eye of the Storm Emissary and Eye of the Storm Envoy (incorrectly added earlier) +DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (22013,22015); + +-- Scripts already converted to SAI, removing EAI equivalents +DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (18103,26349,26370,27234,27235,27236,27237); + +-- Update: Use EventAI for Oluf the Violent, Iron Rune-shaper, Slag, Apprentice Osterkilgr, Scarlet Highlord Daion +UPDATE `creature_template` SET `AIName`='EventAI', `ScriptName`='' WHERE `entry` IN (23931,26270,28585,30409,32417); + |