diff options
| -rw-r--r-- | sql/FULL/world_spell_full.sql | 90 | ||||
| -rw-r--r-- | sql/updates/4542_8191_world_spell_affect.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4544_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4547_world_scripts.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4549_world_script.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4572_script_texts.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4572_world_script.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4577_world_scripts.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4583_world_command.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4594_world_scripts.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4597_world_command.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4598_world_spell_bonus_data.sql | 2 |
12 files changed, 56 insertions, 56 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 diff --git a/sql/updates/4542_8191_world_spell_affect.sql b/sql/updates/4542_8191_world_spell_affect.sql index 74e28a00b59..646c9c3dc00 100644 --- a/sql/updates/4542_8191_world_spell_affect.sql +++ b/sql/updates/4542_8191_world_spell_affect.sql @@ -1,3 +1,3 @@ -- ALTER TABLE db_version CHANGE COLUMN required_8190_01_mangos_creature_template required_8191_01_mangos_spell_affect bit; -DROP TABLE IF EXISTS `spell_affect`; +DROP TABLE IF EXISTS `spell_affect`;
\ No newline at end of file diff --git a/sql/updates/4544_world.sql b/sql/updates/4544_world.sql index 90f7e193f15..ab92495e48b 100644 --- a/sql/updates/4544_world.sql +++ b/sql/updates/4544_world.sql @@ -1,3 +1,3 @@ UPDATE `creature_template` SET `ScriptName`='npc_sinkhole_kill_credit' WHERE (`entry`='26248') or (`entry`='26249'); UPDATE `item_template` SET `ScriptName`='item_incendiary_explosives' WHERE (`entry`='35704'); -UPDATE `creature_template` SET `flags_extra`='2' WHERE (`entry`='26250'); +UPDATE `creature_template` SET `flags_extra`='2' WHERE (`entry`='26250');
\ No newline at end of file diff --git a/sql/updates/4547_world_scripts.sql b/sql/updates/4547_world_scripts.sql index 82f682e482e..39be645d833 100644 --- a/sql/updates/4547_world_scripts.sql +++ b/sql/updates/4547_world_scripts.sql @@ -2,4 +2,4 @@ UPDATE `creature_template` SET `ScriptName`='npc_captured_rageclaw' WHERE (`entr UPDATE `creature_template` SET `ScriptName`='npc_drakuru_shackles' WHERE (`entry`='29700'); DELETE FROM `spell_script_target` WHERE `entry` IN (55083,55223,59951,59952); -INSERT INTO `spell_script_target` VALUES (55083, 1, 29700),(55223, 1, 29686),(59951, 1, 29686),(59952, 1, 29686); +INSERT INTO `spell_script_target` VALUES (55083, 1, 29700),(55223, 1, 29686),(59951, 1, 29686),(59952, 1, 29686);
\ No newline at end of file diff --git a/sql/updates/4549_world_script.sql b/sql/updates/4549_world_script.sql index b020a560cec..ba567eb4343 100644 --- a/sql/updates/4549_world_script.sql +++ b/sql/updates/4549_world_script.sql @@ -1,4 +1,4 @@ UPDATE `creature_template` SET `ScriptName`='npc_khunok_the_behemoth' WHERE (`entry`='25862'); -- DB CONTENT -- -UPDATE `quest_template` SET `SrcSpell`='46232' WHERE (`entry`='11878'); +UPDATE `quest_template` SET `SrcSpell`='46232' WHERE (`entry`='11878');
\ No newline at end of file diff --git a/sql/updates/4572_script_texts.sql b/sql/updates/4572_script_texts.sql index d9c4a644c92..e594d05401c 100644 --- a/sql/updates/4572_script_texts.sql +++ b/sql/updates/4572_script_texts.sql @@ -46,4 +46,4 @@ INSERT INTO `script_texts` (`entry`, `content_default`, `content_loc1`, `content (-1615040,'Unlike, I have many talents.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,14138,1,0,0,'vesperon SAY_VESPERON_SPECIAL_2'), (-1615041,'A Vesperon Disciple appears in the Twilight!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,0,5,0,0,'shadron WHISPER_VESPERON_DICIPLE'), -(-1615042,'%s begins to open a Twilight Portal!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,0,5,0,0,'sartharion drake WHISPER_OPEN_PORTAL'); +(-1615042,'%s begins to open a Twilight Portal!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,0,5,0,0,'sartharion drake WHISPER_OPEN_PORTAL');
\ No newline at end of file diff --git a/sql/updates/4572_world_script.sql b/sql/updates/4572_world_script.sql index f34a407ab17..314d0929de8 100644 --- a/sql/updates/4572_world_script.sql +++ b/sql/updates/4572_world_script.sql @@ -1 +1 @@ -UPDATE instance_template SET script='instance_obsidian_sanctum' WHERE map=615; +UPDATE instance_template SET script='instance_obsidian_sanctum' WHERE map=615;
\ No newline at end of file diff --git a/sql/updates/4577_world_scripts.sql b/sql/updates/4577_world_scripts.sql index 930ebec424a..e73aaea3438 100644 --- a/sql/updates/4577_world_scripts.sql +++ b/sql/updates/4577_world_scripts.sql @@ -7,4 +7,4 @@ UPDATE creature_template SET ScriptName='mob_twilight_whelp' WHERE entry IN (308 UPDATE creature_template SET ScriptName='mob_acolyte_of_shadron' WHERE entry=31218; UPDATE creature_template SET ScriptName='mob_acolyte_of_vesperon' WHERE entry=31219; -UPDATE gameobject_template SET ScriptName='go_resonite_cask' WHERE entry=178145; +UPDATE gameobject_template SET ScriptName='go_resonite_cask' WHERE entry=178145;
\ No newline at end of file diff --git a/sql/updates/4583_world_command.sql b/sql/updates/4583_world_command.sql index 6c5bc49f013..52e3b40eb59 100644 --- a/sql/updates/4583_world_command.sql +++ b/sql/updates/4583_world_command.sql @@ -1 +1 @@ -DELETE FROM `command` WHERE `name` = 'reload spell_affect'; +DELETE FROM `command` WHERE `name` = 'reload spell_affect';
\ No newline at end of file diff --git a/sql/updates/4594_world_scripts.sql b/sql/updates/4594_world_scripts.sql index ebdcb7f761f..ac1056590bb 100644 --- a/sql/updates/4594_world_scripts.sql +++ b/sql/updates/4594_world_scripts.sql @@ -1,3 +1,3 @@ UPDATE `item_template` SET `ScriptName`='item_dart_gun' WHERE `entry`=44222; -UPDATE `creature_template` SET `ScriptName`='npc_kalecgos' WHERE `entry` IN (24844, 24848); +UPDATE `creature_template` SET `ScriptName`='npc_kalecgos' WHERE `entry` IN (24844, 24848);
\ No newline at end of file diff --git a/sql/updates/4597_world_command.sql b/sql/updates/4597_world_command.sql index 374cbb2c632..26096dd3143 100644 --- a/sql/updates/4597_world_command.sql +++ b/sql/updates/4597_world_command.sql @@ -1,4 +1,4 @@ DELETE FROM `command` WHERE `name` IN ('reload creature_linked_respawn', 'npc setlink'); INSERT INTO `command` (`name`,`security`,`help`) VALUES ('reload creature_linked_respawn',2,'Syntax: .reload creature_linked_respawn\r\nReload creature_linked_respawn table.'), -('npc setlink',2,'Syntax: .npc setlink $creatureGUID\r\n\r\nLinks respawn of selected creature to the condition that $creatureGUID defined is alive.'); +('npc setlink',2,'Syntax: .npc setlink $creatureGUID\r\n\r\nLinks respawn of selected creature to the condition that $creatureGUID defined is alive.');
\ No newline at end of file diff --git a/sql/updates/4598_world_spell_bonus_data.sql b/sql/updates/4598_world_spell_bonus_data.sql index 0127e88b5a7..da3da6315a7 100644 --- a/sql/updates/4598_world_spell_bonus_data.sql +++ b/sql/updates/4598_world_spell_bonus_data.sql @@ -1 +1 @@ -DELETE FROM `spell_bonus_data` WHERE `entry` = 53600; +DELETE FROM `spell_bonus_data` WHERE `entry` = 53600;
\ No newline at end of file |