DB/SAI: Set distance option for SMART_ACTION_SOUND on various NPCs

Closes #20726

1 files changed, 62 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2017_10_26_00_world.sql b/sql/updates/world/3.3.5/2017_10_26_00_world.sql
new file mode 100644
index 00000000000..10a3eea3b40
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_10_26_00_world.sql
@@ -0,0 +1,62 @@
+-- 
+UPDATE `smart_scripts` SET `target_type`=1, `target_param1`=0, `action_param3`=1 WHERE `action_type`=4 AND `action_param1`=6197 AND `source_type`=9; 
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1922 AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=40373 AND `source_type`= 0 AND `id`=2;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=40373 AND `source_type`= 0  AND `id`=3;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1057800 AND `source_type`= 9 AND `id`=1;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=5710 AND `source_type`=0  AND `id`=9;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=2801600 AND `source_type`=9  AND `id`=17;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=834 AND `source_type`=0  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=2729 AND `source_type`=0  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1922 AND `source_type`=0  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=28487 AND `source_type`=0  AND `id`=1;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=25465 AND `source_type`=0  AND `id`=1;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=10408 AND `source_type`=0  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=10409 AND `source_type`=0  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=2681402 AND `source_type`=9  AND `id`=6;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=2681402 AND `source_type`=9  AND `id`=9;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=2681402 AND `source_type`=9  AND `id`=12;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=2397700 AND `source_type`=9  AND `id`=2;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=28639 AND `source_type`=0  AND `id`=2;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=2664801 AND `source_type`=9  AND `id`=7;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=17953 AND `source_type`=0  AND `id`=2;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=3131000 AND `source_type`=9  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=3131001 AND `source_type`=9  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=3131002 AND `source_type`=9  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=3131003 AND `source_type`=9  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=3131004 AND `source_type`=9  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=3131005 AND `source_type`=9  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=3131006 AND `source_type`=9  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=3131007 AND `source_type`=9  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=3131008 AND `source_type`=9  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=27249 AND `source_type`=0  AND `id`=5;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=10610 AND `source_type`=0  AND `id`=2;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1061000 AND `source_type`=9  AND `id`=22;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1061000 AND `source_type`=9  AND `id`=33;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1061000 AND `source_type`=9  AND `id`=63;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1061000 AND `source_type`=9  AND `id`=66;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1061000 AND `source_type`=9  AND `id`=69;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1061000 AND `source_type`=9  AND `id`=72;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1061000 AND `source_type`=9  AND `id`=83;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1061000 AND `source_type`=9  AND `id`=99;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1061000 AND `source_type`=9  AND `id`=106;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1061000 AND `source_type`=9  AND `id`=116;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1061000 AND `source_type`=9  AND `id`=121;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1061000 AND `source_type`=9  AND `id`=123;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1061000 AND `source_type`=9  AND `id`=128;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1061000 AND `source_type`=9  AND `id`=142;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1061000 AND `source_type`=9  AND `id`=143;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=3904800 AND `source_type`=9  AND `id`=3;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=30736 AND `source_type`=0  AND `id`=1;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=28416 AND `source_type`=0  AND `id`=13;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=2428400 AND `source_type`=9  AND `id`=6;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=32236 AND `source_type`=0  AND `id`=4;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=32236 AND `source_type`=0  AND `id`=12;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=2294100 AND `source_type`=9  AND `id`=1;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1449 AND `source_type`=0  AND `id`=5;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=1508 AND `source_type`=0  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=2958 AND `source_type`=0  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=2959 AND `source_type`=0  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=2960 AND `source_type`=0  AND `id`=0;
+UPDATE `smart_scripts` SET `action_param2`=0, `action_param3`=1,`target_type`=1, `target_param1`=0,`target_param2`=0,`target_param3`=0 WHERE `action_type`=4 AND `entryorguid`=3108300 AND `source_type`=9 AND `id`=18;
+UPDATE `smart_scripts` SET `action_param6`=1 WHERE `action_type`=115 AND `action_param1`=6292 AND `action_param2`=6294 AND `source_type`=9  AND `id`=2;