diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/1912_world.sql | 5 | ||||
| -rw-r--r-- | sql/updates/1939_word.sql | 5 | ||||
| -rw-r--r-- | sql/updates/CMakeLists.txt | 1 |
3 files changed, 7 insertions, 4 deletions
diff --git a/sql/updates/1912_world.sql b/sql/updates/1912_world.sql index 267dcf548e9..39b405c32c3 100644 --- a/sql/updates/1912_world.sql +++ b/sql/updates/1912_world.sql @@ -1,11 +1,8 @@ -- Shattered Barrier --- Psychic Horror -- Improved Fear -DELETE FROM `spell_proc_event` WHERE `entry` IN (44745, 54787, 47571, 47572, 53754, 53759); +DELETE FROM `spell_proc_event` WHERE `entry` IN (44745, 54787, 53754, 53759); INSERT INTO `spell_proc_event` VALUES (44745, 0x00, 3, 0x00000000, 0x00000001, 0x00000000, 0x00008000, 0x0006000, 0.000000, 0.000000, 0), (54787, 0x00, 3, 0x00000000, 0x00000001, 0x00000000, 0x00008000, 0x0006000, 0.000000, 0.000000, 0), -(47571, 0x00, 6, 65536, 0x00000000, 0x00000000, 65536, 0x0006000, 0.000000, 0.000000, 0), -(47572, 0x00, 6, 59981, 0x00000000, 0x00000000, 65536, 0x0006000, 0.000000, 0.000000, 0), (53754, 0x00, 5, 0x00000000, 1024, 0x00000000, 0x00000000, 0x0006000, 0.000000, 0.000000, 0), (53759, 0x00, 5, 0x00000000, 1024, 0x00000000, 0x00000000, 0x0006000, 0.000000, 0.000000, 0); diff --git a/sql/updates/1939_word.sql b/sql/updates/1939_word.sql new file mode 100644 index 00000000000..dec33f94d59 --- /dev/null +++ b/sql/updates/1939_word.sql @@ -0,0 +1,5 @@ +-- Psychic Horror +DELETE FROM `spell_proc_event` WHERE `entry` IN (47571, 47572); +INSERT INTO `spell_proc_event` VALUES +(47571, 0x00, 6, 65536, 0x00000000, 0x00000000, 0x00010000, 0x0006000, 0.000000, 50.000000, 0), +(47572, 0x00, 6, 65536, 0x00000000, 0x00000000, 0x00010000, 0x0006000, 0.000000, 100.000000, 0); diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt index 0dff617efb2..10df6b2b148 100644 --- a/sql/updates/CMakeLists.txt +++ b/sql/updates/CMakeLists.txt @@ -84,4 +84,5 @@ INSTALL(FILES 1911_world.sql 1912_world.sql 1927_world.sql +1939_word.sql DESTINATION share/trinity/sql/updates)
\ No newline at end of file |