search

cmangos / wotlk-db

A content database for mangos-wotlk, and World of Warcraft Client Patch 3.3.5
GNU General Public License v3.0
112 stars 97 forks source link

The Path of the Protector #535

Open rmzV opened 1 year ago

rmzV commented 1 year ago

https://www.wowhead.com/quest=8747/the-path-of-the-protector#comments https://www.wowhead.com/quest=8752/the-path-of-the-conqueror#comments https://www.wowhead.com/quest=8757/the-path-of-the-invoker#comments

this quest series was, like take one and cancel another, now youcan have all of them

"Be warned, once you have chosen your path, you will have no recourse should you change your mind. " https://wowwiki-archive.fandom.com/wiki/Quest:The_Path_of_the_Protector_(Neutral)

also if you lose you can have another from dragon "you must have the ring on you to upgrade it. if you lose it you can take it again from anachronos." https://www.wowhead.com/quest=8752/the-path-of-the-conqueror#comments

NeatElves commented 1 year ago

UPDATE quest_template SET ExclusiveGroup = 8747 WHERE entry IN (8747,8752,8757);

And the rest gossip, through spells:

INSERT INTO `spell_template` (`Id`, `Dispel`, `Mechanic`, `Attributes`, `AttributesEx`, `AttributesEx2`, `AttributesEx3`, `AttributesEx4`, `AttributesEx5`, `AttributesEx6`, `AttributesEx7`, `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`, `EffectItemType1`, `EffectItemType2`, `EffectItemType3`, `EffectMiscValue1`, `EffectMiscValue2`, `EffectMiscValue3`, `EffectMiscValueB1`, `EffectMiscValueB2`, `EffectMiscValueB3`, `EffectTriggerSpell1`, `EffectTriggerSpell2`, `EffectTriggerSpell3`, `EffectSpellClassMask1_1`, `EffectSpellClassMask1_2`, `EffectSpellClassMask1_3`, `EffectSpellClassMask2_1`, `EffectSpellClassMask2_2`, `EffectSpellClassMask2_3`, `EffectSpellClassMask3_1`, `EffectSpellClassMask3_2`, `EffectSpellClassMask3_3`, `MaxTargetLevel`, `SpellFamilyName`, `SpellFamilyFlags`, `SpellFamilyFlags2`, `MaxAffectedTargets`, `DmgClass`, `PreventionType`, `DmgMultiplier1`, `DmgMultiplier2`, `DmgMultiplier3`, `AreaId`, `SchoolMask`, `SpellName`) VALUES
(25921, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 1, 0, 0, 101, 0, 0, 0, 0, 0, 6, 0, -1, 0, 0, 24, 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, 21206, 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, 0, 0, 0, 1, 'Signet Ring of the Bronze Dragonflight CASTER R1 DND'),
(25922, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 1, 0, 0, 101, 0, 0, 0, 0, 0, 6, 0, -1, 0, 0, 24, 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, 21207, 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, 0, 0, 0, 1, 'Signet Ring of the Bronze Dragonflight CASTER R2 DND'),
(25923, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 1, 0, 0, 101, 0, 0, 0, 0, 0, 6, 0, -1, 0, 0, 24, 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, 21208, 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, 0, 0, 0, 1, 'Signet Ring of the Bronze Dragonflight CASTER R3 DND'),
(25924, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 1, 0, 0, 101, 0, 0, 0, 0, 0, 6, 0, -1, 0, 0, 24, 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, 21209, 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, 0, 0, 0, 1, 'Signet Ring of the Bronze Dragonflight CASTER R4 DND'),
(25925, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 1, 0, 0, 101, 0, 0, 0, 0, 0, 6, 0, -1, 0, 0, 24, 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, 21210, 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, 0, 0, 0, 1, 'Signet Ring of the Bronze Dragonflight CASTER R5 DND'),
(25927, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 1, 0, 0, 101, 0, 0, 0, 0, 0, 6, 0, -1, 0, 0, 24, 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, 21201, 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, 0, 0, 0, 1, 'Signet Ring of the Bronze Dragonflight DPS R1 DND'),
(25928, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 1, 0, 0, 101, 0, 0, 0, 0, 0, 6, 0, -1, 0, 0, 24, 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, 21202, 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, 0, 0, 0, 1, 'Signet Ring of the Bronze Dragonflight DPS R2 DND'),
(25929, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 1, 0, 0, 101, 0, 0, 0, 0, 0, 6, 0, -1, 0, 0, 24, 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, 21203, 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, 0, 0, 0, 1, 'Signet Ring of the Bronze Dragonflight DPS R3 DND'),
(25930, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 1, 0, 0, 101, 0, 0, 0, 0, 0, 6, 0, -1, 0, 0, 24, 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, 21204, 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, 0, 0, 0, 1, 'Signet Ring of the Bronze Dragonflight DPS R4 DND'),
(25931, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 1, 0, 0, 101, 0, 0, 0, 0, 0, 6, 0, -1, 0, 0, 24, 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, 21205, 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, 0, 0, 0, 1, 'Signet Ring of the Bronze Dragonflight DPS R5 DND'),
(25932, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 1, 0, 0, 101, 0, 0, 0, 0, 0, 6, 0, -1, 0, 0, 24, 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, 21196, 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, 0, 0, 0, 1, 'Signet Ring of the Bronze Dragonflight TANK R1 DND'),
(25933, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 1, 0, 0, 101, 0, 0, 0, 0, 0, 6, 0, -1, 0, 0, 24, 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, 21197, 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, 0, 0, 0, 1, 'Signet Ring of the Bronze Dragonflight TANK R2 DND'),
(25934, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 1, 0, 0, 101, 0, 0, 0, 0, 0, 6, 0, -1, 0, 0, 24, 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, 21198, 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, 0, 0, 0, 1, 'Signet Ring of the Bronze Dragonflight TANK R3 DND'),
(25935, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 1, 0, 0, 101, 0, 0, 0, 0, 0, 6, 0, -1, 0, 0, 24, 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, 21199, 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, 0, 0, 0, 1, 'Signet Ring of the Bronze Dragonflight TANK R4 DND'),
(25936, 0, 0, 256, 0, 0, 0, 0, 0, 0, 0, 0, 0, 256, 1, 0, 0, 101, 0, 0, 0, 0, 0, 6, 0, -1, 0, 0, 24, 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, 21200, 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, 0, 0, 0, 1, 'Signet Ring of the Bronze Dragonflight TANK R5 DND');