diff options
| author | QAston <none@none> | 2009-05-15 18:09:44 +0200 |
|---|---|---|
| committer | QAston <none@none> | 2009-05-15 18:09:44 +0200 |
| commit | ab195a1031f03c7e473aa15ecba0bf600de4642d (patch) | |
| tree | 33fac00254cd043c5352f4b3c19845c8e3d45ea9 | |
| parent | 47d5fc51c512c3f53e70ca99bc0548840d515d97 (diff) | |
*Add sqls for latest commit.
--HG--
branch : trunk
| -rw-r--r-- | sql/updates/3320_worldspell_enchant_proc_data.sql | 18 | ||||
| -rw-r--r-- | sql/world_spell_full.sql | 24 |
2 files changed, 41 insertions, 1 deletions
diff --git a/sql/updates/3320_worldspell_enchant_proc_data.sql b/sql/updates/3320_worldspell_enchant_proc_data.sql new file mode 100644 index 00000000000..351207e7367 --- /dev/null +++ b/sql/updates/3320_worldspell_enchant_proc_data.sql @@ -0,0 +1,18 @@ +CREATE TABLE `spell_enchant_proc_data` ( + `entry` INT(10) UNSIGNED NOT NULL, + `customChance` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `PPMChance` FLOAT UNSIGNED NOT NULL DEFAULT '0', + `procEx` FLOAT UNSIGNED NOT NULL DEFAULT '0' +) ENGINE=MYISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Spell enchant proc data'; + +-- Frostbrand Weapon + +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (2, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (12, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (524, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (1667, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (1668, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (2635, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3782, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3783, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3784, 0, 8.8,0); diff --git a/sql/world_spell_full.sql b/sql/world_spell_full.sql index 12a3f5d2745..f43c087d4cb 100644 --- a/sql/world_spell_full.sql +++ b/sql/world_spell_full.sql @@ -1493,4 +1493,26 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell (9784, 0, 0, 0, 0, 0, 0, 64, 0, 0, 0), (9799, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0), (56372, 0, 3, 0, 128, 0, 16384, 0, 0, 0, 0); --- (42370, 0x00, 11, 0x00000080, 0x00000000, 0x00000000, 0.000000, 0.000000, 0);
\ No newline at end of file +-- (42370, 0x00, 11, 0x00000080, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); + +-- -------- +-- ENCHANT PROC +-- -------- + +CREATE TABLE `spell_enchant_proc_data` ( + `entry` INT(10) UNSIGNED NOT NULL, + `customChance` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `PPMChance` FLOAT UNSIGNED NOT NULL DEFAULT '0', + `procEx` FLOAT UNSIGNED NOT NULL DEFAULT '0' +) ENGINE=MYISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Spell enchant proc data'; + +-- Frostbrand Weapon +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (2, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (12, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (524, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (1667, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (1668, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (2635, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3782, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3783, 0, 8.8,0); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES (3784, 0, 8.8,0);
\ No newline at end of file |