diff options
| author | Killyana <morphone1@gmail.com> | 2018-02-15 22:43:35 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2018-02-15 22:43:35 +0100 |
| commit | a974707d471f169a5e744437d5207f46858f781d (patch) | |
| tree | 3cc176a9f1fb599251c0edcc745551b47b0a9d2c | |
| parent | 671665aec638ab22e6c90237351cc784b1d4f4fb (diff) | |
DB: Fix last part of DB errors
| -rw-r--r-- | sql/updates/world/3.3.5/2018_02_15_04_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_02_15_04_world.sql b/sql/updates/world/3.3.5/2018_02_15_04_world.sql new file mode 100644 index 00000000000..262e0c7b032 --- /dev/null +++ b/sql/updates/world/3.3.5/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; |