diff options
| author | Malcrom <malcromdev@gmail.com> | 2013-11-07 23:52:30 -0330 |
|---|---|---|
| committer | Malcrom <malcromdev@gmail.com> | 2013-11-07 23:52:30 -0330 |
| commit | 98a7a2236811075502e66c85b714167405eaccce (patch) | |
| tree | a6650bc5042c7bf7b2a2a10f3e1654cf95ad7618 | |
| parent | 8370f70f2646fdc76da7d74a3c3adb2a49ca57a5 (diff) | |
DB/Misc: Remove some unneeded creature_ai_texts and EAI.
| -rw-r--r-- | sql/updates/world/2013_11_07_05_world_misc.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2013_11_07_05_world_misc.sql b/sql/updates/world/2013_11_07_05_world_misc.sql new file mode 100644 index 00000000000..5467468192f --- /dev/null +++ b/sql/updates/world/2013_11_07_05_world_misc.sql @@ -0,0 +1,10 @@ +-- Remove some unused creature_ai_texts +DELETE FROM creature_ai_texts WHERE entry IN (-1,-133,-134,-135,-136,-137,-138,-139,-217,-218,-219,-220,-221,-222,-223,-224,-225,-226,-227,-810,-811,-812,-813,-814,-815); +DELETE FROM creature_ai_texts WHERE entry BETWEEN -876 AND -841; +DELETE FROM creature_ai_texts WHERE entry BETWEEN -643 AND -634; +DELETE FROM creature_ai_texts WHERE entry BETWEEN -763 AND -740; +-- Clean up some EAI errors +UPDATE creature_ai_scripts SET action1_param2 = 0 WHERE action1_type = 1 AND creature_id IN (22992,22993,22994,23163); +-- Remove some EAI already converted to cpp +DELETE FROM creature_ai_scripts WHERE creature_id IN (26529,26530,26532,26533); +UPDATE creature_template SET AIName = '' WHERE entry IN (26529,26530,26532,26533); |