aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorQAston <none@none>2009-03-15 02:06:59 +0100
committerQAston <none@none>2009-03-15 02:06:59 +0100
commit8b96182b1cb8d79c63fc0a30377cea9a480b418c (patch)
tree6f99250311fc69efe695a1c7af88e1ed4b7a0307 /sql
parent47b39981a1693ba931743c0ac1d4e092ec62a2d8 (diff)
*Fix Shattered Barrier
--HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/1857_world.sql7
-rw-r--r--sql/updates/1910_world.sql11
-rw-r--r--sql/updates/CMakeLists.txt2
3 files changed, 12 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/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/CMakeLists.txt b/sql/updates/CMakeLists.txt
index a7f648271f8..cabb11663c7 100644
--- a/sql/updates/CMakeLists.txt
+++ b/sql/updates/CMakeLists.txt
@@ -78,7 +78,6 @@ 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
@@ -86,4 +85,5 @@ INSTALL(FILES
1895_world.sql
1905_world.sql
1906_world.sql
+1910_world.sql
DESTINATION share/trinity/sql/updates) \ No newline at end of file