diff options
| author | Killyana <morphone1@gmail.com> | 2017-10-26 17:17:14 +0200 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2021-01-21 22:30:40 +0100 |
| commit | b17a23635d5e1d36cc4f51866e85d11d9442ccbf (patch) | |
| tree | 63a94cfa344c61d1f51a7f3b59dc35bafa8c8b24 | |
| parent | bb24c6a11b2410f6dd4ef34f2b7fb87e4b01ba37 (diff) | |
DB/SAI: Set distance option for SMART_ACTION_SOUND on various NPCs
Closes #20726
(cherry picked from commit 6544cb9816eb535a15d4f724edf42517e03f4d51)
| -rw-r--r-- | sql/updates/world/master/2021_01_15_00_world_2017_10_26_00_world.sql | 62 |
1 files changed, 62 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_01_15_00_world_2017_10_26_00_world.sql b/sql/updates/world/master/2021_01_15_00_world_2017_10_26_00_world.sql new file mode 100644 index 00000000000..330674fbbba --- /dev/null +++ b/sql/updates/world/master/2021_01_15_00_world_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; |