diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/1857_world.sql | 7 | ||||
| -rw-r--r-- | sql/updates/1906_world.sql | 6 | ||||
| -rw-r--r-- | sql/updates/1910_world.sql | 11 | ||||
| -rw-r--r-- | sql/updates/1911_world.sql | 4 | ||||
| -rw-r--r-- | sql/updates/CMakeLists.txt | 4 |
5 files changed, 24 insertions, 8 deletions
diff --git a/sql/updates/1857_world.sql b/sql/updates/1857_world.sql deleted file mode 100644 index e17b0774596..00000000000 --- a/sql/updates/1857_world.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN (47571, 47572, 53754, 53759); --- Psychic Horror -INSERT INTO `spell_proc_event` VALUES (47571, 0x00, 6, 65536, 0x00000000, 0x00000000, 0x00000000, 0x0002000, 0.000000, 0.000000, 0); -INSERT INTO `spell_proc_event` VALUES (47572, 0x00, 6, 59981, 0x00000000, 0x00000000, 0x00000000, 0x0002000, 0.000000, 0.000000, 0); --- Improved Fear -INSERT INTO `spell_proc_event` VALUES (53754, 0x00, 5, 0x00000000, 1024, 0x00000000, 0x00000000, 0x0002000, 0.000000, 0.000000, 0); -INSERT INTO `spell_proc_event` VALUES (53759, 0x00, 5, 0x00000000, 1024, 0x00000000, 0x00000000, 0x0002000, 0.000000, 0.000000, 0);
\ No newline at end of file diff --git a/sql/updates/1906_world.sql b/sql/updates/1906_world.sql new file mode 100644 index 00000000000..c4e9a85b7fa --- /dev/null +++ b/sql/updates/1906_world.sql @@ -0,0 +1,6 @@ +-- Nature's Grace -- +DELETE FROM `spell_proc_event` WHERE `entry` IN (16880, 61345, 61346); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(16880, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x0000002, 0.000000, 0.000000, 0), +(61345, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x0000002, 0.000000, 0.000000, 0), +(61346, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x0000002, 0.000000, 0.000000, 0); diff --git a/sql/updates/1910_world.sql b/sql/updates/1910_world.sql new file mode 100644 index 00000000000..940c152bdd5 --- /dev/null +++ b/sql/updates/1910_world.sql @@ -0,0 +1,11 @@ +-- Shattered Barrier +-- Psychic Horror +-- Improved Fear +DELETE FROM `spell_proc_event` WHERE `entry` IN (44745, 54787, 47571, 47572, 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, 0x00000000, 0x0006000, 0.000000, 0.000000, 0), +(47572, 0x00, 6, 59981, 0x00000000, 0x00000000, 0x00000000, 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);
\ No newline at end of file diff --git a/sql/updates/1911_world.sql b/sql/updates/1911_world.sql new file mode 100644 index 00000000000..4a351fcaabc --- /dev/null +++ b/sql/updates/1911_world.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN (44545, 44543); +INSERT INTO `spell_proc_event` VALUES +(44545, 0x00, 3, 1049120, 4096, 0x00000000, 0x0010000, 0x00000000, 15.000000, 0.000000, 0), +(44543, 0x00, 3, 1049120, 4096, 0x00000000, 0x0010000, 0x00000000, 7.000000, 0.000000, 0); diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt index 8ad00dcd843..bfdbdc46d48 100644 --- a/sql/updates/CMakeLists.txt +++ b/sql/updates/CMakeLists.txt @@ -78,10 +78,12 @@ INSTALL(FILES 1814_world.sql 1825_world.sql 1828_world.sql -1857_world.sql 1877_mangos_7439_01_world_trinity_string.sql 1881_world.sql 1884_world.sql 1886_world.sql 1895_world.sql +1906_world.sql +1910_world.sql +1911_world.sql DESTINATION share/trinity/sql/updates)
\ No newline at end of file |