diff options
| author | offl <offl@users.noreply.github.com> | 2020-07-06 22:55:52 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-21 20:25:48 +0100 |
| commit | f5892e5aa5303e08d8285e690c41c89d645a8042 (patch) | |
| tree | caeae38e52fc25b17ca2f2eafaec15f921b961e5 | |
| parent | 80f605f0f6c43c372050a1f7096f41517d182343 (diff) | |
DB/SAI: Remove useless event params and no repeat event flag from some event types
Closes #24898
(cherry picked from commit 5ac25bb7844ce0816796236bdafce2105e84d8c4)
| -rw-r--r-- | sql/updates/world/master/2022_01_21_24_world_2020_07_05_04_world.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_21_24_world_2020_07_05_04_world.sql b/sql/updates/world/master/2022_01_21_24_world_2020_07_05_04_world.sql new file mode 100644 index 00000000000..3cd883f3db1 --- /dev/null +++ b/sql/updates/world/master/2022_01_21_24_world_2020_07_05_04_world.sql @@ -0,0 +1,3 @@ +-- +UPDATE `smart_scripts` SET `event_param2` = 0 WHERE `entryorguid` = 24137 AND `source_type` = 0 AND `event_type` = 61; +UPDATE `smart_scripts` SET `event_flags` = `event_flags` &~ 1 WHERE `event_type` = 11; |