From 8b246d66d31b8f99544a4e7b74ccfa16b9c0f3c4 Mon Sep 17 00:00:00 2001
From: Anubisss <none@none>
Date: Sun, 15 Mar 2009 13:54:00 +0100
Subject: *Remove incorrect sqls. Add the correct one.

--HG--
branch : trunk
---
 sql/updates/1881_world.sql |  4 ----
 sql/updates/1895_world.sql |  4 ----
 sql/updates/1906_world.sql |  6 ------
 sql/updates/1927_world.sql | 11 +++++++++++
 sql/updates/CMakeLists.txt |  4 +---
 5 files changed, 12 insertions(+), 17 deletions(-)
 delete mode 100644 sql/updates/1881_world.sql
 delete mode 100644 sql/updates/1895_world.sql
 delete mode 100644 sql/updates/1906_world.sql
 create mode 100644 sql/updates/1927_world.sql

(limited to 'sql')

diff --git a/sql/updates/1881_world.sql b/sql/updates/1881_world.sql
deleted file mode 100644
index 11c7c789dcd..00000000000
--- a/sql/updates/1881_world.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-DELETE FROM `spell_proc_event` WHERE `entry` IN (31124, 31126);
-INSERT INTO `spell_proc_event` VALUES
-(31124, 0, 8, 16777222, 0, 0, 0, 0, 0, 0, 0),
-(31126, 0, 8, 16777222, 0, 0, 0, 0, 0, 0, 0);
\ No newline at end of file
diff --git a/sql/updates/1895_world.sql b/sql/updates/1895_world.sql
deleted file mode 100644
index 11c7c789dcd..00000000000
--- a/sql/updates/1895_world.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-DELETE FROM `spell_proc_event` WHERE `entry` IN (31124, 31126);
-INSERT INTO `spell_proc_event` VALUES
-(31124, 0, 8, 16777222, 0, 0, 0, 0, 0, 0, 0),
-(31126, 0, 8, 16777222, 0, 0, 0, 0, 0, 0, 0);
\ No newline at end of file
diff --git a/sql/updates/1906_world.sql b/sql/updates/1906_world.sql
deleted file mode 100644
index c4e9a85b7fa..00000000000
--- a/sql/updates/1906_world.sql
+++ /dev/null
@@ -1,6 +0,0 @@
--- 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/1927_world.sql b/sql/updates/1927_world.sql
new file mode 100644
index 00000000000..8867c6cb24a
--- /dev/null
+++ b/sql/updates/1927_world.sql
@@ -0,0 +1,11 @@
+-- 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, 0x48, 7, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0),
+(61345, 0x48, 7, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0),
+(61346, 0x48, 7, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0.000000, 0.000000, 0);
+-- Blade Twisting --
+DELETE FROM `spell_proc_event` WHERE `entry` IN (31124, 31126);
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+(31124, 0x00, 8, 0x01000006, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0),
+(31126, 0x00, 8, 0x01000006, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0);
diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt
index bfdbdc46d48..833a80fc083 100644
--- a/sql/updates/CMakeLists.txt
+++ b/sql/updates/CMakeLists.txt
@@ -79,11 +79,9 @@ INSTALL(FILES
 1825_world.sql
 1828_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
+1927_world.sql
 DESTINATION share/trinity/sql/updates)
\ No newline at end of file
-- 
cgit v1.2.3