gistfile1.txt

/* Delete deprecated spell ranks 3.3.5a
66188 - Death Strike, rank 1 enUS
66196 - Frost Strike, rank 1 enUS
66198 - Obliterate, rank 1 enUS
66215 - Blood Strike, rank 1 enUS
66216 - not found
*/
DELETE FROM `spell_ranks` WHERE `first_spell_id` IN (66188, 66196, 66198, 66215, 66216); 

-- spell_proc fixups
UPDATE `spell_proc` SET `AttributesMask`= 0 WHERE `SpellId`= 48108; -- 48108 - Hot Streak, rank 1 enUS
/*
1120 - Drain Soul, rank 1 enUS
1719 - Recklessness, rank 1 enUS
11129 - Combustion, rank 1 enUS [talent]
17364 - Stormstrike, rank 1 enUS [talent]
18119 - Improved Soul Fire, rank 1 enUS [talent] [passive]
20234 - Last Word, rank 1 enUS [talent] [passive]
20925 - Holy Shield, rank 1 enUS [talent]
24932 - Leader of the Pack, rank 1 enUS
30299 - Nether Protection, rank 1 enUS [talent] [passive]
30675 - Acute Overload, rank 1 enUS [passive]
31244 - Quick Recovery, rank 1 enUS [passive]
31876 - Communion, rank 1 enUS [talent] [passive]
34753 - Holy Concentration, rank 1 enUS [talent] [passive]
43819 - Lucidity, rank 1 enUS
44404 - Missile Barrage, rank 1 enUS [talent] [passive]
44449 - Burnout, rank 1 enUS [passive]
48516 - Planetary Alignment <NNF>, rank 1 enUS [passive]
49182 - Blade Barrier, rank 1 enUS [talent] [passive]
53290 - Hunting Party, rank 1 enUS [talent] [passive]
53380 - Inquiry of Faith, rank 1 enUS [talent] [passive]
53551 - Sacred Cleansing, rank 1 enUS [talent] [passive]
53646 - Demonic Pact, rank 1 enUS
54747 - Burning Determination, rank 1 enUS [passive]
54754 - Glyph of Rejuvenation, rank 1 enUS [passive]
54937 - Glyph of Divine Favor, rank 1 enUS [passive]
54939 - Glyph of Divinity, rank 1 enUS [passive]
55677 - Glyph of Dispel Magic, rank 1 enUS [passive]
55689 - Glyph of Power Word: Barrier, rank 1 enUS [passive]
57870 - Glyph of Lesser Proportion, rank 1 enUS [passive]
58620 - Glyph of Chains of Ice, rank 1 enUS [passive]
62259 - Glyph of Death Grip, rank 1 enUS [passive]
63280 - Glyph of Shamanistic Rage, rank 1 enUS [passive]
63611 - Improved Blood Presence, rank 1 enUS
64127 - Body and Soul, rank 1 enUS [talent] [passive]
53583 - not found
*/
DELETE FROM `spell_proc` WHERE `SpellId` IN (-20234, 30675, 31244, 31876, -44404, -49182, 53290, -53380, 54747, -64127, 1719, 11129, 24932, 53646, 54754, 54937, 54939, 55677, 62259, 63280, 53551, 48516, 44449, -34753, 20925, -18119, 57870, -30299, 17364, 43819, 55689, 58620, 63611, 1120, -53583);
/*
47383 - Molten Core, rank 1 enUS
71162 - Molten Core, rank 1 enUS
71165 - Molten Core, rank 1 enUS
*/
UPDATE `spell_proc` SET `ProcFlags`= 0x00010000 WHERE `SpellId` IN (47383, 71162, 71165);
UPDATE `spell_proc` SET `ProcFlags`= 0x00000004 | 0x00000010 WHERE `SpellId`= 62606; -- 62606 - Savage Defense, rank 1 enUS
UPDATE `spell_proc` SET `SpellPhaseMask`= 2 WHERE `SpellId` IN (70664, 31656, -48539, 28716, 40438, 56218, 62606, -47245, -47195, -19572, 37603, 38394, 40478, 45054, 60061, 60170, 60176, 60487, 61188, 64752, 64824, 64914, 67209, 67356, 67361, 67365, 70730, 70841, 70854, 71174, 71176, 71178, 71198, 71606, 71637, -12317);
UPDATE `spell_proc` SET `SpellPhaseMask`= 0, `SpellTypeMask`= 0 WHERE `SpellId` IN (-49018, -53486, -33191, 46832, 74981, 90738, 90759, 87900, 87897);
UPDATE `spell_proc` SET `ProcFlags`= 0x000A22A8 WHERE `SpellId`= -30299;
UPDATE `spell_proc` SET `ProcFlags`= 0x00014000, `HitMask`= 0 WHERE `SpellId`= -16880;
UPDATE `spell_proc` SET `SpellPhaseMask`= 1, `SpellId`= -12322 WHERE `SpellId`= 12322;
UPDATE `spell_proc` SET `HitMask`= 0 WHERE `SpellId` IN (84722, 84723);
UPDATE `spell_proc` SET `ProcFlags`= 0x00015000, `HitMask`= 0 WHERE `SpellId`= -48965;

-- quest_template_addon fixups
UPDATE `quest_template_addon` SET `ProvidedItemCount`= 1 WHERE `ID`= 14386;