I'm currently working on these changes.
POWER REGEN CHANGES - - - - Database Query!
- Code: Select all
UPDATE spell SET Value = '2'
WHERE
name = 'Rhyme of Creation' OR
name = 'Purity of Mind' OR
name = 'Empowering Unity' OR
name = 'Song of Power' OR
name = 'Comprehension of Power';
UPDATE spell SET Value = '4'
WHERE
name = 'Rhyme of Nature' OR
name = 'Perception of Power' OR
name = 'Song of Energy' OR
name = 'Empowering Harmony' OR
name = 'Purity of Thought';
UPDATE spell SET Value = '6'
WHERE
name = 'Rhyme of the World' OR
name = 'Purity of Intellect' OR
name = 'Empowering Tranquility' OR
name = 'Song of Clarity' OR
name = 'Perspicuity of Power';
UPDATE spell SET Value = '8'
WHERE
name = 'Rhyme of the Cosmos' OR
name = 'Circle of Cognition' OR
name = 'Song of the Mind' OR
name = 'Invest Concordance' OR
name = 'Purity of Contemplation' OR
name = 'Empowering Concordance';
UPDATE spell SET Value = '10'
WHERE
name = 'Rhyme of the Creation' OR
name = 'Purity of Meditation' OR
name = 'Invest Perfection' OR
name = 'Empowering Perfection' OR
name = 'Song of Empowering' OR
name = 'Circle of Lucidity' OR
name = 'Lucidity of Power';
- Code: Select all
/* Bainshee, Mentalist, Minstrel, Paladin, Skald. Goes by their spell name.*/
UPDATE spell SET Damage = '30'
WHERE
name = 'Audible Barrier' OR
name = 'Tumultuous Barrier' OR
name = 'Resounding Barrier' OR
name = 'Illusion of Guarding' OR
name = 'Illusion of Shielding' OR
name = 'Illusion of Protection' OR
name = 'Barrier of Sound' OR
name = 'Shield of Melody' OR
name = 'Wall of Song' OR
name = 'Barrier of Faith' OR
name = 'Barrier of Virtue' OR
name = 'Barrier of Temperance';
/* VALKYRIE, Because of the ' in Odin's, Had to go by Spell ID.*/
UPDATE spell SET Damage = '30'
WHERE
SpellID = '12516' OR
SpellID = '12517' OR
SpellID = '12518';
Damage Add + Celerity ---- Need to know best way to do this - New Spell Handler, or Subspell. If Subspell how exactly would i know if the subspell will cancel with damage add?
