* Continuing cleaning sql

* Used trinity sql coding style
* Now complete

--HG--
branch : trunk

1 files changed, 45 insertions, 45 deletions

diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql
index 7d1e6fd12f4..fbf97ae488c 100644
--- a/sql/FULL/world_spell_full.sql
+++ b/sql/FULL/world_spell_full.sql
@@ -1544,6 +1544,7 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`
 (47632, -1, -1, 0.15, -1, 'Death Knight - Death Coil'),
 (47633, -1, -1, 0.15, -1, 'Death Knight - Death Coil Heal'),
 (55095, -1, -1, -1, 0.055, 'Death Knight - Frost Fever'),
+(58621, -1, -1, 0.08, -1, 'Death Knight - Glyph of Chains of Ice'),
 (49184, -1, -1, 0.1, -1, 'Death Knight - Howling Blast'),
 (45477, -1, -1, 0.1, -1, 'Death Knight - Icy Touch'),
 (56903, 0, 0, 0, 0, 'Death Knight - Lichflame'),
@@ -1555,9 +1556,12 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`
 (5185, 1.611, -1, -1, -1, 'Druid - Healing Touch'),
 (42231, 0.12898, -1, -1, -1, 'Druid - Hurricane Triggered'),
 (5570, -1, 0.2, -1, -1, 'Druid - Insect Swarm'),
+(33745, -1, -1, -1, 0.01, 'Druid - Lacerate($AP*0.05 / number of ticks)'),
 (33763, 0.6453, 0.09518, -1, -1, 'Druid - Lifebloom'),
+(48628, -1, -1, -1, 0.15, 'Druid - Lock Jaw'),
 (8921, 0.1515, 0.13, -1, -1, 'Druid - Moonfire'),
 (50464, 0.67305, -1, -1, -1, 'Druid - Nourish'),
+(1822, -1, -1, 0.01, 0.06, 'Druid - Rake ($AP*0.18 / number of ticks)'),
 (8936, 0.539, 0.188, -1, -1, 'Druid - Regrowth'),
 (774, -1, 0.37604, -1, -1, 'Druid - Rejuvenation'),
 (50294, 0.0119, -1, -1, -1, 'Druid - Starfall AOE rank 1'),
@@ -1570,10 +1574,20 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`
 (53195, 0.0458, -1, -1, -1, 'Druid - Starfall rank 4'),
 (2912, 1, -1, -1, -1, 'Druid - Starfire'),
 (18562, 0, 0, 0, 0, 'Druid - Swiftmend'),
+(50256, -1, -1, 0.08, -1, 'Druid - Swipe'),
 (44203, 0.538, -1, -1, -1, 'Druid - Tranquility Triggered'),
 (61391, 0.193, -1, -1, -1, 'Druid - Typhoon'),
 (48438, -1, 0.11505, -1, -1, 'Druid - Wild Growth'),
 (5176, 0.5714, -1, -1, -1, 'Druid - Wrath'),
+(60089, -1, -1, 0.05, -1, 'Faerie Fire (feral)'),
+(3044, -1, -1, 0.15, -1, 'Hunter - Arcane Shot'),
+(3674, -1, -1, -1, 0.02, 'Hunter - Black Arrow($RAP*0.1 / number of ticks)'),
+(19306, -1, -1, 0.2, -1, 'Hunter - Counterattack'),
+(13812, -1, -1, 0.1, -1, 'Hunter - Explosive Trap Effect'),
+(13797, -1, -1, -1, 0.02, 'Hunter - Immolation Trap($RAP*0.1 / number of ticks)'),
+(1495, -1, -1, 0.2, -1, 'Hunter - Mongoose Bite'),
+(1978, -1, -1, -1, 0.04, 'Hunter - Serpent Sting($RAP*0.2 / number of ticks)'),
+(56641, -1, -1, 0.1, -1, 'Hunter - Steady Shot'),
 (55039, 0, 0, 0, 0, 'Item - Gnomish Lightning Generator'),
 (44425, 0.7143, -1, -1, -1, 'Mage - Arcane Barrage'),
 (30451, 0.7143, -1, -1, -1, 'Mage - Arcane Blast'),
@@ -1621,6 +1635,7 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`
 (53726, 0.25, -1, 0.16, -1, 'Paladin - Judgement of the Martyr Enemy'),
 (53725, 0.0833, -1, 0.0533, -1, 'Paladin - Judgement of the Martyr Self'),
 (31804, 0, 0, 0, 0, 'Paladin - Judgement of Vengeance'),
+(54158, 0.25, -1, 0.16, -1, 'Paladin - Jugdement (Seal of Light, Seal of Wisdom, Seal of Justice)'),
 (58597, 0.75, -1, -1, -1, 'Paladin - Sacred Shield'),
 (53601, 0.75, -1, -1, -1, 'Paladin - Sacred Shield'),
 (31893, 0, 0, 0, 0, 'Paladin - Seal of Blood Proc Enemy'),
@@ -1658,6 +1673,33 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`
 (34433, 0.65, -1, -1, -1, 'Priest - Shadowfiend'),
 (585, 0.714, -1, -1, -1, 'Priest - Smite'),
 (34914, -1, 0.4, -1, -1, 'Priest - Vampiric Touch'),
+(2818, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 1($AP*0.12 / number of ticks)'),
+(2819, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 2($AP*0.12 / number of ticks)'),
+(11353, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 3($AP*0.12 / number of ticks)'),
+(11354, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 4($AP*0.12 / number of ticks)'),
+(25349, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 5($AP*0.12 / number of ticks)'),
+(26968, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 6($AP*0.12 / number of ticks)'),
+(27187, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 7($AP*0.12 / number of ticks)'),
+(57969, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 8($AP*0.12 / number of ticks)'),
+(57970, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 9($AP*0.12 / number of ticks)'),
+(703, -1, -1, -1, 0.02, 'Rogue - Garrote'),
+(1776, -1, -1, 0.21, -1, 'Rogue - Gouge'),
+(8680, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 1'),
+(8685, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 2'),
+(8689, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 3'),
+(11335, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 4'),
+(11336, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 5'),
+(11337, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 6'),
+(26890, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 7'),
+(57964, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 8'),
+(57965, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 9'),
+(13218, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 1'),
+(13222, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 2'),
+(13223, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 3'),
+(13224, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 4'),
+(27189, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 5'),
+(57974, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 6'),
+(57975, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 7'),
 (1064, 1.34, -1, -1, -1, 'Shaman - Chain Heal'),
 (421, 0.57, -1, -1, -1, 'Shaman - Chain Lightning'),
 (974, 0.4762, -1, -1, -1, 'Shaman - Earth Shield'),
@@ -1750,53 +1792,11 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`
 (30294, 0, 0, 0, 0, 'Warlock - Soul Leech'),
 (30108, -1, 0.2, -1, -1, 'Warlock - Unstable Affliction'),
 (31117, 1.8, -1, -1, -1, 'Warlock - Unstable Affliction Dispell'),
-(54158, 0.25, -1, 0.16, -1, 'Paladin - Jugdement (Seal of Light, Seal of Wisdom, Seal of Justice)'),
-(60089, -1, -1, 0.05, -1, 'Faerie Fire (feral)'),
-(58621, -1, -1, 0.08, -1, 'Death Knight - Glyph of Chains of Ice'),
-(13797, -1, -1, -1, 0.02, 'Hunter - Immolation Trap($RAP*0.1 / number of ticks)'),
-(3674, -1, -1, -1, 0.02, 'Hunter - Black Arrow($RAP*0.1 / number of ticks)'),
-(1978, -1, -1, -1, 0.04, 'Hunter - Serpent Sting($RAP*0.2 / number of ticks)'),
-(703, -1, -1, -1, 0.02, 'Rogue - Garrote'),
-(2818, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 1($AP*0.12 / number of ticks)'),
-(2819, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 2($AP*0.12 / number of ticks)'),
-(11353, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 3($AP*0.12 / number of ticks)'),
-(11354, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 4($AP*0.12 / number of ticks)'),
-(25349, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 5($AP*0.12 / number of ticks)'),
-(26968, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 6($AP*0.12 / number of ticks)'),
-(27187, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 7($AP*0.12 / number of ticks)'),
-(57969, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 8($AP*0.12 / number of ticks)'),
-(57970, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 9($AP*0.12 / number of ticks)'),
-(48628, -1, -1, -1, 0.15, 'Druid - Lock Jaw'),
-(1822, -1, -1, -1, 0.06, 'Druid - Rake ($AP*0.18 / number of ticks)'),
-(33745, -1, -1, -1, 0.01, 'Druid - Lacerate($AP*0.05 / number of ticks)'),
-(6572, -1, -1, 0.207, -1, 'Warrior - Revenge'),
 (57755, -1, -1, 0.5, -1, 'Warrior - Heroic Throw'),
-(6343, -1, -1, 0.12, -1, 'Warrior - Thunder Clap'),
-(50256, -1, -1, 0.08, -1, 'Druid - Swipe'),
-(1776, -1, -1, 0.21, -1, 'Rogue - Gouge'),
-(8680, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 1'),
-(8685, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 2'),
-(8689, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 3'),
-(11335, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 4'),
-(11336, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 5'),
-(11337, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 6'),
-(26890, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 7'),
-(57964, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 8'),
-(57965, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 9'),
-(13218, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 1'),
-(13222, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 2'),
-(13223, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 3'),
-(13224, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 4'),
-(27189, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 5'),
-(57974, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 6'),
-(57975, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 7'),
-(1495, -1, -1, 0.2, -1, 'Hunter - Mongoose Bite'),
-(19306, -1, -1, 0.2, -1, 'Hunter - Counterattack'),
-(3044, -1, -1, 0.15, -1, 'Hunter - Arcane Shot'),
-(56641, -1, -1, 0.1, -1, 'Hunter - Steady Shot'),
-(13812, -1, -1, 0.1, -1, 'Hunter - Explosive Trap Effect'),
 (20253, -1, -1, 0.12, -1, 'Warrior - Intercept'),
-(61491, -1, -1, 0.12, -1, 'Warrior - Intercept');
+(61491, -1, -1, 0.12, -1, 'Warrior - Intercept'),
+(6572, -1, -1, 0.207, -1, 'Warrior - Revenge'),
+(6343, -1, -1, 0.12, -1, 'Warrior - Thunder Clap');
 
 -- --------
 -- SPELL ELIXIR