diff options
| author | Killyana <morphone1@gmail.com> | 2017-03-04 13:21:47 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2017-03-04 13:21:47 +0100 |
| commit | f22fd77c580505f8f54d9a2f4f5f2793f7c9b19c (patch) | |
| tree | 1568356656634659304c7aecd5246f434669338b | |
| parent | 15a207fcac15d336b848f9759f75386e12b6a35f (diff) | |
DB/SAI: Fix some DB errors
Ref #18542
| -rw-r--r-- | sql/updates/world/3.3.5/2017_03_04_02_world_335.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_03_04_02_world_335.sql b/sql/updates/world/3.3.5/2017_03_04_02_world_335.sql new file mode 100644 index 00000000000..a988bc1d7a6 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_03_04_02_world_335.sql @@ -0,0 +1,21 @@ +-- +UPDATE `smart_scripts` SET `event_param3`=2000 ,`event_param4`=2000 WHERE `entryorguid` IN (6182) AND `source_type`=0 AND `id`=22; +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid` IN (7726) AND `source_type`=0 AND `id`=3; +UPDATE `smart_scripts` SET `event_param3`=8000 ,`event_param4`=10000 WHERE `entryorguid` IN (7727) AND `source_type`=0 AND `id`=2; +UPDATE `smart_scripts` SET `event_param3`=3000 ,`event_param4`=4000 WHERE `entryorguid` IN (9043) AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `event_param3`=3000 ,`event_param4`=4000 WHERE `entryorguid` IN (9043) AND `source_type`=0 AND `id`=1; +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid` IN (9520) AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `event_flags`=3 WHERE `entryorguid` IN (9707) AND `source_type`=0 AND `id`=3; +UPDATE `smart_scripts` SET `event_flags`=3 WHERE `entryorguid` IN (9708) AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `event_param3`=3000 ,`event_param4`=7000 WHERE `entryorguid` IN (9817) AND `source_type`=0 AND `id`=7; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (10261) AND `source_type`=0 AND `id`=1; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (10263) AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `event_flags`=3, `action_type`=41 WHERE `entryorguid` IN (10375) AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `event_flags`=3, `action_type`=41 WHERE `entryorguid` IN (10680) AND `source_type`=0 AND `id`=4; +UPDATE `smart_scripts` SET `event_flags`=3, `action_type`=41 WHERE `entryorguid` IN (10681) AND `source_type`=0 AND `id`=4; +UPDATE `smart_scripts` SET `event_param3`=8000 ,`event_param4`=10000 WHERE `entryorguid` IN (11340) AND `source_type`=0 AND `id`=2; +UPDATE `smart_scripts` SET `event_param3`=15000 ,`event_param4`=20000 WHERE `entryorguid` IN (11353) AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid` IN (13197) AND `source_type`=0 AND `id`=4; +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid` IN (13197) AND `source_type`=0 AND `id`=6; +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid` IN (13197) AND `source_type`=0 AND `id`=7; +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid` IN (13197) AND `source_type`=0 AND `id`=8; |