diff options
| author | Killyana <morphone1@gmail.com> | 2018-02-15 22:43:35 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-06-22 12:46:44 +0200 |
| commit | 2c179a1f43915fe20dcd84faf0085a07eabe0615 (patch) | |
| tree | 8ffa9b394d1d06dd493a603d7cdbcf9519c37d98 | |
| parent | f6e0531dd8087c52facfbce16a465dba6f5e1933 (diff) | |
DB: Fix last part of DB errors
(cherry picked from commit a974707d471f169a5e744437d5207f46858f781d)
| -rw-r--r-- | sql/updates/world/master/2021_06_21_03_world_2018_02_15_04_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_06_21_03_world_2018_02_15_04_world.sql b/sql/updates/world/master/2021_06_21_03_world_2018_02_15_04_world.sql new file mode 100644 index 00000000000..262e0c7b032 --- /dev/null +++ b/sql/updates/world/master/2021_06_21_03_world_2018_02_15_04_world.sql @@ -0,0 +1,11 @@ +-- +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid` IN (25321,25322) AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid` IN (30154) AND `source_type`=0 AND `id`=4; +UPDATE `smart_scripts` SET `target_type`=23 WHERE `entryorguid` IN (25401) AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid` IN (22423) AND `source_type`=0 AND `id`=9; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid` IN (14354) AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid` IN (13197) AND `source_type`=0 AND `id`=9; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid` IN (16769) AND `source_type`=0 AND `id`=9; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid` IN (16769) AND `source_type`=0 AND `id`=4; +UPDATE `smart_scripts` SET `target_type`=21, target_param1=30 WHERE `entryorguid` IN (15420) AND `source_type`=0 AND `id`=3; +UPDATE `smart_scripts` SET `target_type`=21, target_param1=30 WHERE `entryorguid` IN (3584) AND `source_type`=0 AND `id`=2; |