From 8b96182b1cb8d79c63fc0a30377cea9a480b418c Mon Sep 17 00:00:00 2001
From: QAston <none@none>
Date: Sun, 15 Mar 2009 02:06:59 +0100
Subject: *Fix Shattered Barrier

--HG--
branch : trunk
---
 sql/updates/1857_world.sql |  7 -------
 sql/updates/1910_world.sql | 11 +++++++++++
 sql/updates/CMakeLists.txt |  2 +-
 3 files changed, 12 insertions(+), 8 deletions(-)
 delete mode 100644 sql/updates/1857_world.sql
 create mode 100644 sql/updates/1910_world.sql

(limited to 'sql')

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
-- 
cgit v1.2.3