aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorQAston <none@none>2009-03-15 23:59:06 +0100
committerQAston <none@none>2009-03-15 23:59:06 +0100
commit5bc3df176a50bc0eaa5c8f02e57229fd882b39fd (patch)
tree40708404528627727a80e2846f686de48df3fe2f /sql
parent61f519ca26f6d75e2096b5469691a0f37d53bbed (diff)
*Fix Living Bomb target selection.
*Fix healing mod apply for devouring plague. *Fix psychic horror. --HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/1912_world.sql5
-rw-r--r--sql/updates/1939_word.sql5
-rw-r--r--sql/updates/CMakeLists.txt1
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