diff options
| -rw-r--r-- | sql/updates/1814_world.sql | 1 | ||||
| -rw-r--r-- | sql/updates/1857_world.sql | 4 | ||||
| -rw-r--r-- | sql/updates/1877_mangos_7439_01_world_trinity_string.sql | 5 | ||||
| -rw-r--r-- | sql/updates/1881_world.sql | 6 | ||||
| -rw-r--r-- | sql/updates/1884_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/1886_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/1895_world.sql | 8 | ||||
| -rw-r--r-- | sql/updates/7439_01_mangos_mangos_string.sql | 5 | ||||
| -rw-r--r-- | sql/updates/CMakeLists.txt | 2 |
9 files changed, 19 insertions, 16 deletions
diff --git a/sql/updates/1814_world.sql b/sql/updates/1814_world.sql index 9fbcc71a96f..fa403b5ac81 100644 --- a/sql/updates/1814_world.sql +++ b/sql/updates/1814_world.sql @@ -1,3 +1,4 @@ -- Improved Fire Nova Totem +DELETE FROM `spell_proc_event` WHERE `entry` IN (16086, 16544); INSERT INTO `spell_proc_event` VALUES (16086, 0x00, 7, 0, 0x00040000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); INSERT INTO `spell_proc_event` VALUES (16544, 0x00, 7, 0, 0x00040000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0);
\ No newline at end of file diff --git a/sql/updates/1857_world.sql b/sql/updates/1857_world.sql index 255a3b0698c..e17b0774596 100644 --- a/sql/updates/1857_world.sql +++ b/sql/updates/1857_world.sql @@ -1,7 +1,7 @@ DELETE FROM `spell_proc_event` WHERE `entry` IN (47571, 47572, 53754, 53759); --- Psyhic Horror +-- 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); +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/1877_mangos_7439_01_world_trinity_string.sql b/sql/updates/1877_mangos_7439_01_world_trinity_string.sql new file mode 100644 index 00000000000..3389ff73ef4 --- /dev/null +++ b/sql/updates/1877_mangos_7439_01_world_trinity_string.sql @@ -0,0 +1,5 @@ +/*ALTER TABLE db_version CHANGE COLUMN required_7422_01_mangos_mangos_string required_7439_01_mangos_mangos_string bit;*/ + +DELETE FROM `trinity_string` WHERE `entry` IN (175); +INSERT INTO `trinity_string` VALUES +(175,'Liquid level: %f, ground: %f, type: %d, status: %d',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
\ No newline at end of file diff --git a/sql/updates/1881_world.sql b/sql/updates/1881_world.sql index eb7860a5bd1..11c7c789dcd 100644 --- a/sql/updates/1881_world.sql +++ b/sql/updates/1881_world.sql @@ -1,4 +1,4 @@ -DELETE FROM spell_proc_event where entry in (31124, 31126); -insert into spell_proc_event () VALUES +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); +(31126, 0, 8, 16777222, 0, 0, 0, 0, 0, 0, 0);
\ No newline at end of file diff --git a/sql/updates/1884_world.sql b/sql/updates/1884_world.sql index e2d1ed8c461..227e9c826c3 100644 --- a/sql/updates/1884_world.sql +++ b/sql/updates/1884_world.sql @@ -1 +1 @@ -DELETE FROM trinity_string WHERE entry in (10056, 10057);
\ No newline at end of file +DELETE FROM `trinity_string` WHERE `entry` IN (10056, 10057);
\ No newline at end of file diff --git a/sql/updates/1886_world.sql b/sql/updates/1886_world.sql index d682101ff6f..8dbac159633 100644 --- a/sql/updates/1886_world.sql +++ b/sql/updates/1886_world.sql @@ -3,4 +3,4 @@ INSERT INTO `spell_linked_spell` VALUES (61846, 61848, 2, 'Aspect of te dragonha -- Glyph of Aspect of the Monkey REPLACE INTO `spell_proc_event` VALUES (13163, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x0000010, 0.000000, 0.000000, 0); -REPLACE INTO `spell_proc_event` VALUES (61848, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x0000010, 0.000000, 0.000000, 0); +REPLACE INTO `spell_proc_event` VALUES (61848, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x0000010, 0.000000, 0.000000, 0);
\ No newline at end of file diff --git a/sql/updates/1895_world.sql b/sql/updates/1895_world.sql index a6387631352..11c7c789dcd 100644 --- a/sql/updates/1895_world.sql +++ b/sql/updates/1895_world.sql @@ -1,4 +1,4 @@ -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), -(31126, 0, 8, 16777222, 0, 0, 0, 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/7439_01_mangos_mangos_string.sql b/sql/updates/7439_01_mangos_mangos_string.sql deleted file mode 100644 index f20b816a508..00000000000 --- a/sql/updates/7439_01_mangos_mangos_string.sql +++ /dev/null @@ -1,5 +0,0 @@ -/*ALTER TABLE db_version CHANGE COLUMN required_7422_01_mangos_mangos_string required_7439_01_mangos_mangos_string bit;*/ - -DELETE FROM mangos_string WHERE entry in (175); -INSERT INTO mangos_string VALUES - (175,'Liquid level: %f, ground: %f, type: %d, status: %d',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
\ No newline at end of file diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt index 71774b4ebbc..8ad00dcd843 100644 --- a/sql/updates/CMakeLists.txt +++ b/sql/updates/CMakeLists.txt @@ -79,6 +79,8 @@ INSTALL(FILES 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 |