From fff86b77296eb8787ef8ceeb681739234c9b49b9 Mon Sep 17 00:00:00 2001 From: Nay Date: Thu, 10 Jan 2013 15:41:10 +0000 Subject: DB/SAI: Remove some redundant creature_texts using SMART_ACTION_CALL_FOR_HELP --- sql/updates/world/2013_01_10_01_world_sai.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/world/2013_01_10_01_world_sai.sql (limited to 'sql') 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; -- cgit v1.2.3