diff options
| -rw-r--r-- | sql/updates/world/master/2023_09_24_00_world.sql | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_09_24_00_world.sql b/sql/updates/world/master/2023_09_24_00_world.sql new file mode 100644 index 00000000000..bdea1a05666 --- /dev/null +++ b/sql/updates/world/master/2023_09_24_00_world.sql @@ -0,0 +1,44 @@ +-- SAI +UPDATE `creature_template` SET `AIName`='' WHERE `entry`=30657; + +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=6741 AND `id`=3 AND `link`=4; +UPDATE `smart_scripts` SET `id`=3 WHERE `source_type`=0 AND `entryorguid`=6741 AND `id`=4; +UPDATE `smart_scripts` SET `action_type`=33, `action_param1`=15402 WHERE `source_type`=0 AND `entryorguid`=15402 AND `id`=5; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=17612 AND `id`=5 AND `event_type`=6; +UPDATE `smart_scripts` SET `id`=5 WHERE `source_type`=0 AND `entryorguid`=17612 AND `id`=6 AND `event_type`=54; +UPDATE `smart_scripts` SET `id`=6 WHERE `source_type`=0 AND `entryorguid`=17612 AND `id`=7 AND `event_type`=1; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=17716 AND `id`=1; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=19273 AND `id`=0 AND `event_param1`=10162; +UPDATE `smart_scripts` SET `id`=0 WHERE `source_type`=0 AND `entryorguid`=19273 AND `id`=1; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=19851 AND `id`=4; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=20209 AND `id` IN (12,13); +UPDATE `smart_scripts` SET `link`=0 WHERE `source_type`=0 AND `entryorguid`=20209 AND `id`=11; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=20417 AND `id` IN (14,15); +UPDATE `smart_scripts` SET `link`=0 WHERE `source_type`=0 AND `entryorguid`=20417 AND `id`=13; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=20418 AND `id` IN (16,17); +UPDATE `smart_scripts` SET `link`=0 WHERE `source_type`=0 AND `entryorguid`=20418 AND `id`=15; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=20440 AND `id` IN (15,16); +UPDATE `smart_scripts` SET `link`=0 WHERE `source_type`=0 AND `entryorguid`=20440 AND `id`=14; +UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=347365 WHERE `source_type`=0 AND `entryorguid`=25729 AND `id`=21; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=27383 AND `id`=21 AND `action_type`=15; +UPDATE `smart_scripts` SET `id`=21, `event_type`=6 WHERE `source_type`=0 AND `entryorguid`=27383 AND `id`=22; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=28105 AND `id`=11; +UPDATE `smart_scripts` SET `link`=0 WHERE `source_type`=0 AND `entryorguid`=28105 AND `id`=10; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=30657 AND `id`=0; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=198883; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=1030700 AND `id`=4; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=1848201 AND `id`=3 AND `action_type`=15; +UPDATE `smart_scripts` SET `id`=3 WHERE `source_type`=9 AND `entryorguid`=1848201 AND `id`=4 AND `action_type`=82; +UPDATE `smart_scripts` SET `id`=4 WHERE `source_type`=9 AND `entryorguid`=1848201 AND `id`=5 AND `action_type`=83; +UPDATE `smart_scripts` SET `id`=5 WHERE `source_type`=9 AND `entryorguid`=1848201 AND `id`=6 AND `action_type`=1; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=2546001 AND `id`=0 AND `action_type`=15; +UPDATE `smart_scripts` SET `id`=0 WHERE `source_type`=9 AND `entryorguid`=2546001 AND `id`=1 AND `action_param1`=45602; +UPDATE `smart_scripts` SET `id`=1 WHERE `source_type`=9 AND `entryorguid`=2546001 AND `id`=2 AND `action_param1`=46598; +UPDATE `smart_scripts` SET `id`=2 WHERE `source_type`=9 AND `entryorguid`=2546001 AND `id`=3 AND `action_type`=41; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=2743901 AND `id`=10 AND `action_type`=15; +UPDATE `smart_scripts` SET `id`=10 WHERE `source_type`=9 AND `entryorguid`=2743901 AND `id`=11 AND `action_type`=1; +UPDATE `smart_scripts` SET `id`=11 WHERE `source_type`=9 AND `entryorguid`=2743901 AND `id`=12 AND `action_type`=17; +UPDATE `smart_scripts` SET `id`=12 WHERE `source_type`=9 AND `entryorguid`=2743901 AND `id`=13 AND `action_type`=97; +UPDATE `smart_scripts` SET `id`=13 WHERE `source_type`=9 AND `entryorguid`=2743901 AND `id`=14 AND `action_type`=41; +UPDATE `smart_scripts` SET `action_type`=56, `action_param1`=22115, `action_param2`=1 WHERE `source_type`=0 AND `entryorguid`=16014 AND `id`=0; +UPDATE `smart_scripts` SET `action_type`=56, `action_param1`=21986, `action_param2`=1 WHERE `source_type`=0 AND `entryorguid`=16032 AND `id`=0; |