From 833cdf5fe67457714203364655e975bdacf00cf4 Mon Sep 17 00:00:00 2001 From: QAston Date: Sun, 3 May 2009 20:00:29 +0200 Subject: *Update some procflags for 309. *Do not trigger aoe damage for explosive shot. --HG-- branch : trunk --- sql/updates/3070_world_spell_proc_event.sql | 15 +++++++++++++++ sql/updates/3089_world_trinity_string.sql | 4 ++-- 2 files changed, 17 insertions(+), 2 deletions(-) create mode 100644 sql/updates/3070_world_spell_proc_event.sql (limited to 'sql') diff --git a/sql/updates/3070_world_spell_proc_event.sql b/sql/updates/3070_world_spell_proc_event.sql new file mode 100644 index 00000000000..3835a8c6aac --- /dev/null +++ b/sql/updates/3070_world_spell_proc_event.sql @@ -0,0 +1,15 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN (20166, 32385, 32392, 32387, 32393, 32394, + 13046, 13045, 12317, 13048, 13047, -- Enrage + 29724, 29725, 29723); -- Sudden Death + +-- Seal of wisdom +INSERT INTO `spell_proc_event` VALUES +(20166, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 12.000000, 0.000000, 0); + +-- Shadow embrace +INSERT INTO `spell_proc_event` VALUES +(32385, 0x00, 5, 0x00000001, 0x00040000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0), +(32387, 0x00, 5, 0x00000001, 0x00040000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0), +(32392, 0x00, 5, 0x00000001, 0x00040000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0), +(32393, 0x00, 5, 0x00000001, 0x00040000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0), +(32394, 0x00, 5, 0x00000001, 0x00040000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); \ No newline at end of file diff --git a/sql/updates/3089_world_trinity_string.sql b/sql/updates/3089_world_trinity_string.sql index 274ad62e546..e3eaa557c20 100644 --- a/sql/updates/3089_world_trinity_string.sql +++ b/sql/updates/3089_world_trinity_string.sql @@ -1,3 +1,3 @@ -DELETE FROM `trinity_string` WHERE `entry` IN (101); -INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES +DELETE FROM `trinity_string` WHERE `entry` IN (101); +INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES (101, 'Map: %u (%s) Zone: %u (%s) Area: %u (%s) Phase: %u\nX: %f Y: %f Z: %f Orientation: %f\ngrid[%u,%u]cell[%u,%u] InstanceID: %u\n ZoneX: %f ZoneY: %f\nGroundZ: %f FloorZ: %f Have height data (Map: %u VMap: %u)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); \ No newline at end of file -- cgit v1.2.3