DB/SAI: Remove some redundant creature_texts using SMART_ACTION_CALL_FOR_HELP

1 files changed, 4 insertions, 0 deletions

diff --git a/sql/updates/world/2013_01_10_01_world_sai.sql b/sql/updates/world/2013_01_10_01_world_sai.sql
new file mode 100644
index 00000000000..da6c5f994f2
--- /dev/null
+++ b/sql/updates/world/2013_01_10_01_world_sai.sql
@@ -0,0 +1,4 @@
+DELETE FROM `creature_text` WHERE `entry` IN (2287, 2706, 2719, 10828, 16357, 17210);
+UPDATE `smart_scripts` SET `action_param2`=1 WHERE `action_type`=39 AND `entryorguid` IN (2287, 2706, 2719, 10828, 16357, 17210, 3987);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2287, 2719) AND `action_param1`=1 AND `action_type`=1;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2706, 10828, 16357, 17210, 3987) AND `action_param1`=0 AND `action_type`=1;