diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2011_09_03_02_world_spell_script_names.sql (renamed from sql/updates/world/2011_09_03_02_spell_script_names.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/world/2011_09_03_06_world_spell_threat.sql | 134 | ||||
| -rw-r--r-- | sql/updates/world/2011_09_03_07_world_achievement_criteria_data.sql | 28 | ||||
| -rw-r--r-- | sql/updates/world/2011_09_03_08_world_spell_dbc.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2011_09_03_09_world_spell_dbc.sql | 5 | ||||
| -rw-r--r-- | sql/updates/world/2011_09_03_10_world_spell_dbc.sql | 3 | ||||
| -rw-r--r-- | sql/updates/world/2011_09_04_00_world_quest_template.sql | 6 | ||||
| -rw-r--r-- | sql/updates/world/2011_09_04_01_world_trinity_string.sql | 3 | ||||
| -rw-r--r-- | sql/updates/world/2011_09_04_02_world_trinity_string.sql | 1 |
9 files changed, 182 insertions, 0 deletions
diff --git a/sql/updates/world/2011_09_03_02_spell_script_names.sql b/sql/updates/world/2011_09_03_02_world_spell_script_names.sql index b7b6907b7f1..b7b6907b7f1 100644 --- a/sql/updates/world/2011_09_03_02_spell_script_names.sql +++ b/sql/updates/world/2011_09_03_02_world_spell_script_names.sql diff --git a/sql/updates/world/2011_09_03_06_world_spell_threat.sql b/sql/updates/world/2011_09_03_06_world_spell_threat.sql new file mode 100644 index 00000000000..a59a7739350 --- /dev/null +++ b/sql/updates/world/2011_09_03_06_world_spell_threat.sql @@ -0,0 +1,134 @@ +-- ---------- +-- Tank Class Passive Threat +-- ---------- +DELETE FROM spell_linked_spell WHERE spell_effect IN (57340, 57339); +INSERT INTO spell_linked_spell VALUES + (7376, 57339, 2, 'Defensive Stance Passive - Tank Class Passive Threat'), + (21178, 57339, 2, 'Bear Form (Passive2) - Tank Class Passive Threat'), + (25780, 57340, 2, 'Righteous Fury - Tank Class Passive Threat'), + (48263, 57340, 2, 'Frost Presence - Tank Class Passive Threat'); + +-- ---------- +-- restructure spell_threat +-- ---------- +TRUNCATE TABLE `spell_threat`; +ALTER TABLE `spell_threat` CHANGE `Threat` `flatMod` int(6); +ALTER TABLE `spell_threat` ADD COLUMN `pctMod` FLOAT NOT NULL DEFAULT 1.0 COMMENT 'threat multiplier for damage/healing' AFTER `flatMod`; +ALTER TABLE `spell_threat` ADD COLUMN `apPctMod` FLOAT NOT NULL DEFAULT 0.0 COMMENT 'additional threat bonus from attack power' AFTER `pctMod`; +INSERT INTO `spell_threat` VALUES +-- Other +-- Src: SELECT id, SpellNameEN, RankEN FROM `Spell` WHERE `DescriptionEN` LIKE '%threat%' AND `SpellFamilyName` <> '0' AND NOT (Attributes & 0x40) GROUP BY SpellNameEN ORDER BY RankEN DESC; + (5676, 0, 2.00, 0.0), -- Searing Pain (Rank 1) (Warlock) + (28176, 0, 0.00, 0.0), -- Fel Armor - Heal (Rank 1) (Warlock) [Assumption] + (8056, 0, 2.00, 0.0), -- Frost Shock (Rank 1) (Shaman) [Assumption] + (26688, 0, 0.00, 0.0), -- Anesthetic Poison - Proc (Rank 1) (Rogue) + (15237, 0, 0.00, 0.0), -- Holy Nova - Heal (Rank 1) (Priest) + (23455, 0, 0.00, 0.0), -- Holy Nova - Damage (Rank 1) (Priest) + (32546, 0, 0.50, 0.0), -- Binding Heal (Rank 1) (Priest) [Assumption] + (33619, 0, 0.00, 0.0), -- Reflective Shield - Proc (Priest) + (2139, 180, 1.00, 0.0), -- Counterspell (Mage) [Assumption] +-- Death Knight +-- Src: http://www.tankspot.com/showthread.php?40485-Death-Knight-threat-values&p=113584#post113584 + (63611, 0, 0.00, 0.0), -- Blood Presence - Heal + (45524, 240, 1.00, 0.0), -- Chains of Ice + (43265, 0, 1.90, 0.0), -- Death and Decay + (49576, 110, 1.00, 0.0), -- Death Grip + (48743, 0, 0.00, 0.0), -- Death Pact + (65142, 0, 0.00, 0.0), -- Ebon Plague + (47568, 0, 0.00, 0.0), -- Empower Rune Weapon + (51209, 112, 1.00, 0.0), -- Hungering Cold + (49039, 110, 1.00, 0.0), -- Lichborn + (56815, 0, 1.75, 0.0), -- Rune Strike + (50422, 0, 0.00, 0.0), -- Scent of Blood - Proc + (55090, 51, 1.00, 0.0), -- Scourge Strike (Rank 1) + (55265, 63, 1.00, 0.0), -- Scourge Strike (Rank 2) + (55270, 98, 1.00, 0.0), -- Scourge Strike (Rank 3) + (55271, 120, 1.00, 0.0), -- Scourge Strike (Rank 4) + (49916, 138, 1.00, 0.0), -- Strangulate + (50181, 0, 0.00, 0.0), -- Vendetta - Proc +-- Druid +-- Src: http://www.tankspot.com/showthread.php?47813-WOTLK-Bear-Threat-Values&p=200948#post200948 + (17057, 0, 0.00, 0.0), -- Furor - Proc + (5211, 53, 1.00, 0.0), -- Bash (Rank 3) + (6798, 105, 1.00, 0.0), -- Bash (Rank 2) + (8983, 158, 1.00, 0.0), -- Bash (Rank 1) + (45334, 40, 1.00, 0.0), -- Feral Charge (Bear) - Root + (19675, 80, 1.00, 0.0), -- Feral Charge (Bear) - Interrupt + (34299, 0, 0.00, 0.0), -- Improved Leader of the Pack - Heal + (6807, 13, 1.00, 0.0), -- Maul (Rank 1) + (6808, 20, 1.00, 0.0), -- Maul (Rank 2) + (6809, 27, 1.00, 0.0), -- Maul (Rank 3) + (8972, 47, 1.00, 0.0), -- Maul (Rank 4) + (9745, 75, 1.00, 0.0), -- Maul (Rank 5) + (9880, 106, 1.00, 0.0), -- Maul (Rank 6) + (9881, 140, 1.00, 0.0), -- Maul (Rank 7) + (26996, 212, 1.00, 0.0), -- Maul (Rank 8) + (48479, 345, 1.00, 0.0), -- Maul (Rank 9) + (48480, 422, 1.00, 0.0), -- Maul (Rank 10) + (60089, 638, 1.00, 0.0), -- Faerie Fire (Feral) - Proc + (33745, 182, 0.50, 0.0), -- Lacerate (Rank 1) + (48567, 409, 0.50, 0.0), -- Lacerate (Rank 2) + (48568, 515, 0.50, 0.0), -- Lacerate (Rank 3) + (779, 0, 1.50, 0.0), -- Swipe (Bear) (Rank 1) + (5209, 98, 1.00, 0.0), -- Challenging Roar + (29166, 0, 10.0, 0.0), -- Innervate [base is 5 per 1 mana] +-- Paladin +-- Src: http://www.tankspot.com/showthread.php?39761-Paladin-Threat-Values-(Updated-for-3.2.2)&p=103813#post103813 + (7294, 0, 2.00, 0.0), -- Retribution Aura + (20185, 0, 0.00, 0.0), -- Judgement of Light + (19742, 0, 0.00, 0.0), -- Blessing of Wisdom (Rank 1) + (25894, 0, 0.00, 0.0), -- Greater Blessing of Wisdom (Rank 1) + (20470, 0, 0.00, 0.0), -- Righteous Fury + (498, 0, 0.00, 0.0), -- Divine Protection +-- Warrior +-- Src: http://www.tankspot.com/showthread.php?39775-WoW-3.0-Threat-Values-(Warrior)&p=103972#post103972 + (845, 8, 1.00, 0.0), -- Cleave (Rank 1) + (7369, 15, 1.00, 0.0), -- Cleave (Rank 2) + (11608, 25, 1.00, 0.0), -- Cleave (Rank 3) + (11609, 35, 1.00, 0.0), -- Cleave (Rank 4) + (20569, 48, 1.00, 0.0), -- Cleave (Rank 5) + (25231, 68, 1.00, 0.0), -- Cleave (Rank 6) + (47519, 95, 1.00, 0.0), -- Cleave (Rank 7) + (47520, 112, 1.00, 0.0), -- Cleave (Rank 8) + (78, 5, 1.00, 0.0), -- Heroic Strike (Rank 1) + (284, 10, 1.00, 0.0), -- Heroic Strike (Rank 2) + (285, 16, 1.00, 0.0), -- Heroic Strike (Rank 3) + (1608, 22, 1.00, 0.0), -- Heroic Strike (Rank 4) + (11564, 31, 1.00, 0.0), -- Heroic Strike (Rank 5) + (11565, 48, 1.00, 0.0), -- Heroic Strike (Rank 6) + (11566, 70, 1.00, 0.0), -- Heroic Strike (Rank 7) + (11567, 92, 1.00, 0.0), -- Heroic Strike (Rank 8) + (25286, 104, 1.00, 0.0), -- Heroic Strike (Rank 9) + (29707, 121, 1.00, 0.0), -- Heroic Strike (Rank 10) + (30324, 164, 1.00, 0.0), -- Heroic Strike (Rank 11) + (47449, 224, 1.00, 0.0), -- Heroic Strike (Rank 12) + (47450, 259, 1.00, 0.0), -- Heroic Strike (Rank 13) + (57755, 0, 1.50, 0.0), -- Heroic Throw + (6572, 7, 1.00, 0.0), -- Revenge (Rank 1) + (6574, 11, 1.00, 0.0), -- Revenge (Rank 2) + (7379, 15, 1.00, 0.0), -- Revenge (Rank 3) + (11600, 27, 1.00, 0.0), -- Revenge (Rank 4) + (11601, 41, 1.00, 0.0), -- Revenge (Rank 5) + (25288, 53, 1.00, 0.0), -- Revenge (Rank 6) + (25269, 58, 1.00, 0.0), -- Revenge (Rank 7) + (30357, 71, 1.00, 0.0), -- Revenge (Rank 8) + (57823, 121, 1.00, 0.0), -- Revenge (Rank 9) + (23922, 228, 1.00, 0.0), -- Shield Slam (Rank 1) + (23923, 268, 1.00, 0.0), -- Shield Slam (Rank 2) + (23924, 307, 1.00, 0.0), -- Shield Slam (Rank 3) + (23925, 347, 1.00, 0.0), -- Shield Slam (Rank 4) + (25258, 387, 1.00, 0.0), -- Shield Slam (Rank 5) + (30356, 426, 1.00, 0.0), -- Shield Slam (Rank 6) + (47487, 650, 1.00, 0.0), -- Shield Slam (Rank 7) + (47488, 770, 1.00, 0.0), -- Shield Slam (Rank 8) + (1464, 18, 1.00, 0.0), -- Slam (Rank 1) + (8820, 24, 1.00, 0.0), -- Slam (Rank 2) + (11604, 38, 1.00, 0.0), -- Slam (Rank 3) + (11605, 49, 1.00, 0.0), -- Slam (Rank 4) + (25241, 59, 1.00, 0.0), -- Slam (Rank 5) + (25242, 78, 1.00, 0.0), -- Slam (Rank 6) + (47474, 123, 1.00, 0.0), -- Slam (Rank 7) + (47475, 140, 1.00, 0.0), -- Slam (Rank 8) + (7386, 345, 1.00, 0.05), -- Sunder Armor + (20243, 0, 1.00, 0.05), -- Devastate (Rank 1) + (6343, 0, 1.85, 0.0); -- Thunder Clap (Rank 1) diff --git a/sql/updates/world/2011_09_03_07_world_achievement_criteria_data.sql b/sql/updates/world/2011_09_03_07_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..7ae27745be6 --- /dev/null +++ b/sql/updates/world/2011_09_03_07_world_achievement_criteria_data.sql @@ -0,0 +1,28 @@ +DELETE FROM `disables` WHERE `entry` IN (1242, 1803, 1804, 1805, 1806, 1807, 1808, 1809, 1810, 1825, 1811, 1812, 1813, 1814, 1815, 1816, 1817, 1818, 1819, 1826, 3386, 3387, 3388, 3389) AND `sourceType` = 4; + +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (1242, 1803, 1804, 1805, 1806, 1807, 1808, 1809, 1810, 1825, 1811, 1812, 1813, 1814, 1815, 1816, 1817, 1818, 1819, 1826, 3386, 3387, 3388, 3389); +INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES +(1242, 11, 0, 0, 'achievement_bg_av_perfection'), +(1803, 11, 0, 0, 'achievement_bg_av_perfection'), +(1804, 11, 0, 0, 'achievement_bg_av_perfection'), +(1805, 11, 0, 0, 'achievement_bg_av_perfection'), +(1806, 11, 0, 0, 'achievement_bg_av_perfection'), +(1807, 11, 0, 0, 'achievement_bg_av_perfection'), +(1808, 11, 0, 0, 'achievement_bg_av_perfection'), +(1809, 11, 0, 0, 'achievement_bg_av_perfection'), +(1810, 11, 0, 0, 'achievement_bg_av_perfection'), +(1825, 11, 0, 0, 'achievement_bg_av_perfection'), +(1811, 11, 0, 0, 'achievement_bg_av_perfection'), +(1812, 11, 0, 0, 'achievement_bg_av_perfection'), +(1813, 11, 0, 0, 'achievement_bg_av_perfection'), +(1814, 11, 0, 0, 'achievement_bg_av_perfection'), +(1815, 11, 0, 0, 'achievement_bg_av_perfection'), +(1816, 11, 0, 0, 'achievement_bg_av_perfection'), +(1817, 11, 0, 0, 'achievement_bg_av_perfection'), +(1818, 11, 0, 0, 'achievement_bg_av_perfection'), +(1819, 11, 0, 0, 'achievement_bg_av_perfection'), +(1826, 11, 0, 0, 'achievement_bg_av_perfection'), +(3386, 11, 0, 0, 'achievement_everything_counts'), +(3387, 11, 0, 0, 'achievement_everything_counts'), +(3388, 11, 0, 0, 'achievement_everything_counts'), +(3389, 11, 0, 0, 'achievement_everything_counts');
\ No newline at end of file diff --git a/sql/updates/world/2011_09_03_08_world_spell_dbc.sql b/sql/updates/world/2011_09_03_08_world_spell_dbc.sql new file mode 100644 index 00000000000..4d57e320822 --- /dev/null +++ b/sql/updates/world/2011_09_03_08_world_spell_dbc.sql @@ -0,0 +1,2 @@ +ALTER TABLE `spell_dbc` ADD COLUMN `AttributesEx6` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `AttributesEx5`; +ALTER TABLE `spell_dbc` ADD COLUMN `AttributesEx7` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `AttributesEx6`; diff --git a/sql/updates/world/2011_09_03_09_world_spell_dbc.sql b/sql/updates/world/2011_09_03_09_world_spell_dbc.sql new file mode 100644 index 00000000000..31d4b19b1ca --- /dev/null +++ b/sql/updates/world/2011_09_03_09_world_spell_dbc.sql @@ -0,0 +1,5 @@ +-- Dummy effect with caster as target +DELETE FROM `spell_dbc` WHERE `id` IN (68308); +INSERT INTO `spell_dbc` (`Id`, `Attributes`, `AttributesEx`, `AttributesEx2`,`AttributesEx3`,`AttributesEx4`,`AttributesEx5`,`AttributesEx6`,`Effect1`,`EffectImplicitTargetA1`,`EffectImplicitTargetB1`,`comment`) +VALUES +(68308, 0x09800100, 0x00000420, 0x00004005, 0x10040000, 0x00000080, 0x00000008, 0x00001000, 3, 1, 0, 'Vault of Archavon - Earth, Wind & Fire - Achievement Check'); diff --git a/sql/updates/world/2011_09_03_10_world_spell_dbc.sql b/sql/updates/world/2011_09_03_10_world_spell_dbc.sql new file mode 100644 index 00000000000..119bf863a8b --- /dev/null +++ b/sql/updates/world/2011_09_03_10_world_spell_dbc.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_dbc` WHERE `Id`=63975; +INSERT INTO `spell_dbc` (`Id`, `Dispel`, `Mechanic`, `Attributes`, `AttributesEx`, `AttributesEx2`, `AttributesEx3`, `AttributesEx4`, `AttributesEx5`, `Stances`, `StancesNot`, `Targets`, `CastingTimeIndex`, `AuraInterruptFlags`, `ProcFlags`, `ProcChance`, `ProcCharges`, `MaxLevel`, `BaseLevel`, `SpellLevel`, `DurationIndex`, `RangeIndex`, `StackAmount`, `EquippedItemClass`, `EquippedItemSubClassMask`, `EquippedItemInventoryTypeMask`, `Effect1`, `Effect2`, `Effect3`, `EffectDieSides1`, `EffectDieSides2`, `EffectDieSides3`, `EffectRealPointsPerLevel1`, `EffectRealPointsPerLevel2`, `EffectRealPointsPerLevel3`, `EffectBasePoints1`, `EffectBasePoints2`, `EffectBasePoints3`, `EffectMechanic1`, `EffectMechanic2`, `EffectMechanic3`, `EffectImplicitTargetA1`, `EffectImplicitTargetA2`, `EffectImplicitTargetA3`, `EffectImplicitTargetB1`, `EffectImplicitTargetB2`, `EffectImplicitTargetB3`, `EffectRadiusIndex1`, `EffectRadiusIndex2`, `EffectRadiusIndex3`, `EffectApplyAuraName1`, `EffectApplyAuraName2`, `EffectApplyAuraName3`, `EffectAmplitude1`, `EffectAmplitude2`, `EffectAmplitude3`, `EffectMultipleValue1`, `EffectMultipleValue2`, `EffectMultipleValue3`, `EffectMiscValue1`, `EffectMiscValue2`, `EffectMiscValue3`, `EffectMiscValueB1`, `EffectMiscValueB2`, `EffectMiscValueB3`, `EffectTriggerSpell1`, `EffectTriggerSpell2`, `EffectTriggerSpell3`, `EffectSpellClassMaskA1`, `EffectSpellClassMaskA2`, `EffectSpellClassMaskA3`, `EffectSpellClassMaskB1`, `EffectSpellClassMaskB2`, `EffectSpellClassMaskB3`, `EffectSpellClassMaskC1`, `EffectSpellClassMaskC2`, `EffectSpellClassMaskC3`, `MaxTargetLevel`, `SpellFamilyName`, `SpellFamilyFlags1`, `SpellFamilyFlags2`, `SpellFamilyFlags3`, `MaxAffectedTargets`, `DmgClass`, `PreventionType`, `DmgMultiplier1`, `DmgMultiplier2`, `DmgMultiplier3`, `AreaGroupId`, `SchoolMask`, `Comment`) VALUES +(63975,0,0,384,0,0,262144,128,0,0,0,0,1,0,0,0,0,0,0,0,0,13,0,-1,0,0,77,0,0,0,1,1,0,0,0,0,0,0,0,0,0,6,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,'Glyph of Blackstab - 3.2.2'); diff --git a/sql/updates/world/2011_09_04_00_world_quest_template.sql b/sql/updates/world/2011_09_04_00_world_quest_template.sql new file mode 100644 index 00000000000..4ff774b65b4 --- /dev/null +++ b/sql/updates/world/2011_09_04_00_world_quest_template.sql @@ -0,0 +1,6 @@ +UPDATE `quest_template` SET `RequiredRaces`=1101 WHERE `entry` IN (4362,4363); -- The Fate of the Kingdom & The Princess's Surprise +UPDATE `quest_template` SET `NextQuestId`=4342 WHERE `entry`=4341; -- Kharan Mighthammer +UPDATE `quest_template` SET `PrevQuestId`=4341 WHERE `entry`=4342; -- Kharan's Tale +UPDATE `quest_template` SET `PrevQuestId`=4342 WHERE `entry`=4361; -- The Bearer of Bad News +UPDATE `quest_template` SET `PrevQuestId`=4361 WHERE `entry`=4362; -- The Fate of the Kingdom +UPDATE `quest_template` SET `PrevQuestId`=4362 WHERE `entry`=4363; -- The Princess's Surprise diff --git a/sql/updates/world/2011_09_04_01_world_trinity_string.sql b/sql/updates/world/2011_09_04_01_world_trinity_string.sql new file mode 100644 index 00000000000..0f36a362db9 --- /dev/null +++ b/sql/updates/world/2011_09_04_01_world_trinity_string.sql @@ -0,0 +1,3 @@ +DELETE FROM `trinity_string` WHERE `entry`=5030; +INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES +(5030, '%s attempts to run away in fear!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); diff --git a/sql/updates/world/2011_09_04_02_world_trinity_string.sql b/sql/updates/world/2011_09_04_02_world_trinity_string.sql new file mode 100644 index 00000000000..36722947feb --- /dev/null +++ b/sql/updates/world/2011_09_04_02_world_trinity_string.sql @@ -0,0 +1 @@ +UPDATE `trinity_string` SET `content_default`='Faction %s (%u) can''t have reputation.' WHERE `entry`=326; -- can'nt -> can't |