diff options
| author | Killyana <morphone1@gmail.com> | 2018-02-15 22:02:44 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2018-02-15 22:02:44 +0100 |
| commit | 671665aec638ab22e6c90237351cc784b1d4f4fb (patch) | |
| tree | b2fba6a440e0c6d48fac4d4956bfc0b066fc8443 | |
| parent | 29f7258dc824659cb2de81c5ff3b3b3853de2a8b (diff) | |
DB: Fix mode DB errors
| -rw-r--r-- | sql/updates/world/3.3.5/2018_02_15_03_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_02_15_03_world.sql b/sql/updates/world/3.3.5/2018_02_15_03_world.sql new file mode 100644 index 00000000000..72c8613c57e --- /dev/null +++ b/sql/updates/world/3.3.5/2018_02_15_03_world.sql @@ -0,0 +1,11 @@ +-- +UPDATE `smart_scripts` SET `target_type`=24 WHERE `target_type`=16 AND `event_type`=2 AND `action_type` IN (33,15,11); +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=13197 AND `source_type`=0 AND `id`=11; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=16977 AND `source_type`=0 AND `id`=14; +UPDATE `smart_scripts` SET `target_type`=18, `target_param1`=25 WHERE `target_type`=7 AND `event_type`=7 AND `action_type` IN (6); +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=25773 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=19480 AND `source_type`=0 AND `id`=2; +UPDATE `smart_scripts` SET `event_type`=4 WHERE `entryorguid`=18400 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=28444 AND `source_type`=0 AND `id`=1; +UPDATE `smart_scripts` SET `event_type`=10, `event_param1`=1, `event_param1`=20 WHERE `entryorguid`=19283 AND `source_type`=0 AND `id`=3; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=27202 AND `source_type`=0 AND `id`=6; |