aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/1693_world.sql
diff options
context:
space:
mode:
authorDrahy <none@none>2009-03-07 22:17:45 +0100
committerDrahy <none@none>2009-03-07 22:17:45 +0100
commit3f36d9eb9530a85864fa994143625d121d9dc647 (patch)
tree79084aa8dc1959a279176b4ef81daf943692bfce /sql/updates/1693_world.sql
parent42d681eecdd668b9d53c93acf0e205047458a781 (diff)
* Trinity sql coding style
* Added 1703_world.sql * Small fixies in other files --HG-- branch : trunk
Diffstat (limited to 'sql/updates/1693_world.sql')
-rw-r--r--sql/updates/1693_world.sql13
1 files changed, 7 insertions, 6 deletions
diff --git a/sql/updates/1693_world.sql b/sql/updates/1693_world.sql
index 6806dab4c42..51bf45011b7 100644
--- a/sql/updates/1693_world.sql
+++ b/sql/updates/1693_world.sql
@@ -1,9 +1,10 @@
-- Update Proc Rate
-INSERT INTO `spell_proc_event` VALUES ('60442', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45');
-INSERT INTO `spell_proc_event` VALUES ('57345', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45');
-INSERT INTO `spell_proc_event` VALUES ('61356', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45');
-INSERT INTO `spell_proc_event` VALUES ('54707', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60');
-INSERT INTO `spell_proc_event` VALUES ('54808', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60');
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+('60442', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'),
+('57345', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'),
+('61356', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45'),
+('54707', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60'),
+('54808', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60');
-- Update Spell Coefficients
DELETE FROM `spell_bonus_data` WHERE `entry` IN ('689', '18790', '172', '42223', '42224', '42225', '42226', '42218', '47817', '47818', '1949', '5857', '11681', '11682', '27214', '47822', '27243', '30108', '17962', '6789', '48181', '29722', '5676', '686', '17877', '30283', '1120', '30294', '44425', '42208', '42209', '42210', '42211', '42212', '42213', '42198', '42937', '42938', '11113', '31661', '120', '19750', '635', '25914', '25913', '25903', '27175', '33074', '48820', '48821', '58597', '31803', '53742', '31893', '32221', '53719', '53718', '20167', '20424', '31804', '53733', '31898', '32220', '53726', '53725', '20267', '20187', '20467', '53600', '596', '2944', '8092', '27813', '27817', '27818', '33619');
@@ -83,4 +84,4 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`
('27813', '0', '0', '0', 'Priest - Blessed Recovery Rank 1'),
('27817', '0', '0', '0', 'Priest - Blessed Recovery Rank 2'),
('27818', '0', '0', '0', 'Priest - Blessed Recovery Rank 3'),
-('33619', '0', '0', '0', 'Priest - Reflective Shield');
+('33619', '0', '0', '0', 'Priest - Reflective Shield'); \ No newline at end of file