search

xackery / eqcleanup

Cleans up PEQ database to go to certain progressions
GNU General Public License v3.0
6 stars 3 forks source link

Delete spells after velious, and update spells back to velious era levels. Spells on 1, 4, 8, 12, 16 etc. #34

Open minijag opened 6 years ago

minijag commented 6 years ago

-- Delete Warrior Disciplines not from Classic, Kunark, or Velious DELETE FROM spells_new WHERE name NOT IN ( 'Resistant Discipline', 'Fearless Discipline', 'Evasive Discipline', 'Charge Discipline', 'Mighty Strike Discipline', 'Defensive Discipline', 'Furious Discipline', 'Precision Discipline', 'Felstrike Discipline', 'Fortitude Discipline', 'Aggressive Discipline' ) AND classes1 > 0 AND classes1 < 254;

-- Delete Cleric spells not from Classic, Kunark, or Velious DELETE FROM spells_new WHERE name NOT IN ( 'Courage', 'Cure Poison', 'Divine Aura', 'Flash of Light', 'Lull', 'Minor Healing', 'Spook the Dead', 'Strike', 'True North', 'Yaulp',

'Cure Blindness', 'Cure Disease', 'Furor', 'Gate', 'Holy Armor', 'Light Healing', 'Reckless Strength', 'Stun', 'Summon Drink', 'Ward Undead',

'Center', 'Endure Fire', 'Endure Poison', 'Fear', 'Hammer of Wrath', 'Invigor', 'Root', 'Sense the Dead', 'Soothe', 'Summon Food', 'Word of Pain',

'Bind Affinity', 'Cancel Magic', 'Endure Cold', 'Endure Disease', 'Expulse Undead', 'Halo of Light', 'Healing', 'Invisibility versus Undead', 'Sense Summoned', 'Smite', 'Symbol of Transal',

'Calm', 'Daring', 'Endure Magic', 'Extinguish Fatigue', 'Holy Might', 'Spirit Armor', 'Ward Summoned', 'Word of Shadow', 'Yaulp II',

'Bravery', 'Counteract Poison', 'Dismiss Undead', 'Greater Healing', 'Hammer of Striking', 'Inspire Fear', 'Symbol of Ryltan', 'Wave of Fear',

'Abundant Drink', 'Counteract Disease', 'Divine Barrier', 'Instill', 'Expulse Summoned', 'Guard', 'Imbue Black Pearl', 'Imbue Black Sapphire', 'Imbue Diamond', 'Imbue Emerald', 'Imbue Opal', 'Imbue Peridot', 'Imbue Plains Pebble', 'Imbue Rose Quartz', 'Imbue Ruby', 'Imbue Sapphire', 'Imbue Topaz', 'Panic the Dead', 'Revive', 'Word of Spirit', 'Wrath',

'Abundant Food', 'Armor of Protection', 'Atone', 'Blinding Luminance', 'Expel Undead', 'Force', 'Frenzied Strength', 'Resist Fire', 'Resist Poison', 'Superior Healing', 'Symbol of Pinzarn', 'Tremor', 'Valor', 'Word of Health',

'Armor of Faith', 'Complete Heal', 'Dismiss Summoned', 'Invoke Fear', 'Nullify Magic', 'Pacify', 'Resist Cold', 'Resist Disease', 'Resuscitate', 'Turning of the Unnatural', 'Word of Souls',

'Banish Undead', 'Celestial Healing', 'Earthquake', 'Hammer of Requital', 'Resist Magic', 'Resolution', 'Retribution', 'Symbol of Naltron', 'Yaulp III',

'Abolish Poison', 'Expel Summoned', 'Immobilize', 'Resurrection', 'Shield of Words', 'Sound of Force', 'Word Divine', 'Word of Healing',

'Improved Invisibility to Undead',

'Death Pact', 'Dread of Night', 'Remedy', 'Sunskin',

'Heroic Bond', 'Heroism', 'Upheaval', 'Word of Vigor',

'Annul Magic', 'Divine Light', 'Yaulp IV',

'Reckoning', 'Symbol of Marzin', 'Unswerving Hammer of Faith',

'Exile Undead', 'Fortitude', 'Stun Command', 'Wake of Tranquility',

'Banish Summoned', 'Mark of Karn', 'Paralyzing Earth', 'Reviviscence',

'Aegis', 'Bulwark of Faith', 'Trepidation', 'Word of Restoration',

'Antidote', 'Enforced Reverence', 'Naltron''s Mark',

'Celestial Elixir', 'The Unspoken Word',

'Aegolism', 'Banishment of Shadows', 'Divine Intervention', 'Word of Redemption' ) AND classes2 > 0 AND classes2 < 254;

-- Delete Paladin spells not from Classic, Kunark, or Velious DELETE FROM spells_new WHERE name NOT IN ( 'Resistant Discipline', 'Fearless Discipline', 'Holyforge Discipline', 'Sanctification Discipline',

'Courage', 'Cure Poison', 'Flash of Light', 'Minor Healing', 'Spook the Dead', 'True North', 'Yaulp',

'Cure Disease', 'Hammer of Wrath', 'Holy Armor', 'Light Healing', 'Lull', 'Sense the Dead', 'Ward Undead',

'Center', 'Endure Poison', 'Halo of Light', 'Invigor', 'Invisibility versus Undead', 'Reckless Strength', 'Root',

'Endure Magic', 'Expulse Undead', 'Hammer of Striking', 'Healing', 'Soothe', 'Spirit Armor', 'Stun', 'Symbol of Transal',

'Cancel Magic', 'Counteract Poison', 'Daring', 'Divine Purpose', 'Endure Disease', 'Greater Healing', 'Symbol of Ryltan', 'Yaulp II', 'Guard',

'Dismiss Undead', 'Calm', 'Divine Might', 'Holy Might', 'Revive', 'Symbol of Pinzarn', 'Valor', 'Armor of Faith',

'Flame of Light',

'Pacify', 'Resist Disease',

'Force', 'Frenzied Strength',

'Divine Glory',

'Instill', 'Expel Undead',

'Divine Favor', 'Divine Aura', 'Resist Magic', 'Wave of Healing',

'Counteract Disease', 'Yaulp III',

'Superior Healing',

'Nullify Magic', 'Symbol of Naltron',

'Celestial Cleansing', 'Resurrection',

'Divine Strength', 'Resolution', 'Shield of Words', 'Yaulp IV' ) AND classes3 > 0 AND classes3 < 254; -- Delete Ranger spells and disciplines not from Classic, Kunark, or Velious DELETE FROM spells_new WHERE name NOT IN ( 'Resistant Discipline', 'Fearless Discipline', 'Trueshot Discipline', 'Weaponshield Discipline',

'Endure Fire', 'Flame Lick', 'Glimpse', 'Lull Animal', 'Minor Healing', 'Skin Like Wood', 'Snare',

'Burst of Fire', 'Camouflage', 'Cure Poison', 'Dance of the Fireflies', 'Feet like Cat', 'Grasping Roots', 'Invoke Lightning', 'Thistlecoat',

'Bind Sight', 'Endure Cold', 'Enduring Breath', 'Firefist', 'Harmony', 'Ignite', 'Light Healing', 'Panic Animal', 'Skin Like Rock', 'Ward Summoned',

'Barbcoat', 'Cancel Magic', 'Eyes of the Cat', 'Invigor', 'Shield of Thistles', 'Stinging Swarm', 'Strength of Earth', 'Spirit of Wolf',

'Bramblecoat', 'Call of Sky', 'Calm Animal', 'Careless Lightning', 'Dismiss Summoned', 'Healing', 'Levitate', 'See Invisible', 'Skin Like Steel',

'Spikecoat', 'Ensnaring Roots', 'Immolate', 'Resist Fire', 'Shield of Brambles', 'Superior Camouflage', 'Wolf Form',

'Call of Flame', 'Call of Earth',

'Ensnare', 'Jolt', 'Strength of Nature',

'Extinguish Fatigue', 'Firestrike',

'Storm Strength',

'Drones of Doom', 'Skin Like Diamond',

'Call of Fire', 'Chloroplast', 'Cinder Jolt', 'Resist Cold',

'Chill Sight', 'Greater Wolf Form',

'Greater Healing',

'Nullify Magic', 'Shield of Spikes',

'Calefaction', 'Skin Like Nature',

'Call of the Predator', 'Enveloping Roots', 'Thorncoat' ) AND classes4 > 0 AND classes4 < 254; -- Delete Shadowknight spells and disciplines not from Classic, Kunark, or Velious DELETE FROM spells_new WHERE name NOT IN ( 'Resistant Discipline', 'Fearless Discipline', 'Unholy Aura Discipline', 'Leechcurse Discipline',

'Disease Cloud', 'Invisibility versus Undead', 'Leering Corpse', 'Lifetap', 'Locate Corpse', 'Sense the Dead', 'Siphon Strength',

'Bone Walk', 'Clinging Darkness', 'Endure Cold', 'Fear', 'Lifespike', 'Numb the Dead', 'Shadow Step',

'Convoke Shadow', 'Dark Empathy', 'Deadeye', 'Engulfing Darkness', 'Grim Aura', 'Spook the Dead', 'Vampiric Embrace', 'Ward Undead',

'Strengthen Death',

'Endure Disease', 'Feign Death', 'Gather Shadows', 'Heat Blood', 'Lifedraw', 'Restless Bones', 'Wave of Enfeeblement',

'Shieldskin',

'Animate Dead', 'Cancel Magic', 'Expulse Undead', 'Heart Flutter', 'Resist Cold', 'Shadow Vortex', 'Shroud of Hate',

'Breath of the Dead', 'Dismiss Undead', 'Dooming Darkness', 'Invoke Fear', 'Life Leech', 'Shadow Sight', 'Summon Dead', 'Word of Spirit',

'Shroud of Pain',

'Siphon Life', 'Summon Corpse',

'Malignant Dead', 'Rest the Dead',

'Boil Blood',

'Banshee Aura', 'Panic the Dead',

'Bobbing Corpse', 'Expel Undead', 'Shroud of Death', 'Shroud of Undeath', 'Spirit Tap',

'Steelskin',

'Vampiric Curse', 'Drain Spirit',

'Cackling Bones', 'Nullify Magic',

'Cascading Darkness', 'Diamondskin',

'Asystole', 'Drain Soul', 'Death Peace' ) AND classes5 > 0 AND classes5 < 254; -- Delete Druid spells not from Classic, Kunark, or Velious DELETE FROM spells_new WHERE name NOT IN ( 'Burst of Flame', 'Dance of the Fireflies', 'Endure Fire', 'Flame Lick', 'Lull Animal', 'Minor Healing', 'Panic Animal', 'Sense Animals', 'Skin like Wood', 'Snare',

'Burst of Fire', 'Camouflage', 'Cure Disease', 'Cure Poison', 'Gate', 'Grasping Roots', 'Harmony', 'Invoke Lightning', 'Ward Summoned', 'Whirling Wind',

'Endure Cold', 'Enduring Breath', 'Firefist', 'Ignite', 'Invisibility versus Animals', 'Light Healing', 'Shield of Thistles', 'Starshine', 'Strength of Earth', 'Thistlecoat', 'Treeform',

'Befriend Animal', 'Bind Affinity', 'Cascade of Hail', 'Expulse Summoned', 'Halo of Light', 'Invigor', 'Levitate', 'See Invisible', 'Skin like Rock', 'Spirit of Wolf', 'Stinging Swarm', 'Summon Drink', 'Summon Food',

'Barbcoat', 'Calm Animal', 'Cancel Magic', 'Careless Lightning', 'Dizzying Wind', 'Endure Disease', 'Endure Poison', 'Feral Spirit', 'Healing', 'Ring of Butcher', 'Ring of Commons', 'Ring of Karana', 'Ring of Toxxulia', 'Shield of Barbs', 'Superior Camouflage', 'Terrorize Animal',

'Charm Animals', 'Creeping Crud', 'Dismiss Summoned', 'Ensnaring Roots', 'Pogonip', 'Resist Fire', 'Ring of Feerrott', 'Ring of Lavastorm', 'Ring of Ro', 'Ring of Steamfont', 'Ring of the Combines', 'Scale of Wolf', 'Skin like Steel', 'Spirit of Cheetah', 'Sunbeam', 'Tremor', 'Wolf Form',

'Beguile Plants', 'Bramblecoat', 'Circle of Butcher', 'Circle of Commons', 'Circle of Karana', 'Circle of Toxxulia', 'Counteract Disease', 'Counteract Poison', 'Ensnare', 'Extinguish Fatigue', 'Greater Healing', 'Imbue Emerald', 'Imbue Plains Pebble', 'Immolate', 'Ring of Misty', 'Shield of Brambles', 'Succor: East', 'Combust',

'Beguile Animals', 'Circle of Feerrott', 'Circle of Iceclad', 'Circle of Lavastorm', 'Circle of Ro', 'Circle of Steamfont', 'Circle of the Combines', 'Drones of Doom', 'Earthquake', 'Endure Magic', 'Expel Summoned', 'Fury of Air', 'Greater Wolf Form', 'Lightning Strike', 'Regeneration', 'Resist Cold', 'Ring of Great Divide', 'Ring of Iceclad', 'Strength of Stone', 'Succor: Butcher',

'Avalanche', 'Circle of Great Divide', 'Circle of Misty', 'Enveloping Roots', 'Firestrike', 'Pack Regeneration', 'Pack Spirit', 'Ring of Cobalt Scar', 'Ring of Wakening Lands', 'Ro''s Fiery Sundering', 'Share Wolf Form', 'Shield of Spikes', 'Skin Like Diamond', 'Spikecoat', 'Succor: Ro', 'Wind of the North', 'Wind of the South',

'Allure of the Wild', 'Banish Summoned', 'Calefaction', 'Chloroplast', 'Circle of Cobalt Scar', 'Circle of Wakening Lands', 'Drifting Death', 'Fixation of Ro', 'Form of the Great Wolf', 'Nullify Magic', 'Resist Disease', 'Resist Poison', 'Savage Spirit', 'Storm Strength', 'Succor: Lavastorm',

'Engulfing Roots', 'Fire', 'Ice', 'Lightning Blast', 'Pack Chloroplast', 'Resist Magic', 'Shield of Thorns', 'Skin Like Nature', 'Starfire', 'Succor: North', 'Thorncoat',

'Improved Superior Camouflage',

'Circle of Winter', 'Legacy of Spike', 'Repulse Animal', 'Superior Healing', 'Upheaval',

'Breath of Ro', 'Call of Karana', 'Circle of Summer', 'Egress',

'Glamour of Tunare', 'Spirit of Scale', 'Winged Death',

'Blizzard', 'Form of the Howler', 'Regrowth', 'Scoriae',

'Annul Magic', 'Chloroblast', 'Exile Summoned', 'Girdle of Karana', 'Nature Walkers Behest', 'Tunare''s Request',

'Bladecoat', 'Breath of Karana', 'Engorging Roots', 'Wake of Karana',

'Bonds of Tunare', 'Frost', 'Natureskin', 'Succor',

'Fist of Karana', 'Regrowth of the Grove', 'Shield of Blades',

'Legacy of Thorn', 'Spirit of Oak', 'Wildfire',

'Banishment', 'Entrapping Roots', 'Form of the Hunter', 'Mask of the Hunter', 'Nature''s Touch', 'Protection of the Glades' ) AND classes6 > 0 AND classes6 < 254; -- Delete Monk disciplines not from Classic, Kunark, or Velious DELETE FROM spells_new WHERE name NOT IN ( 'Resistant Discipline', 'Fearless Discipline', 'Stonestance Discipline', 'Thunderkick Discipline', 'Whirlwind Discipline', 'Voiddance Discipline', 'Inner Flame Discipline', 'Hundred Fists Discipline', 'Silentfist Discipline', 'Ashenhand Discipline' ) AND classes7 > 0 AND classes7 < 254; -- Delete Bard spells and disciplines not from Classic, Kunark, or Velious DELETE FROM spells_new WHERE name NOT IN ( 'Resistant Discipline', 'Fearless Discipline', 'Deftdance Discipline', 'Puretone Discipline',

'Chant of Battle', 'Chords of Dissonance', 'Jaxan''s Jig o'' Vigor', 'Lyssa''s Locating Lyric', 'Selo''s Accelerando', 'Hymn of Restoration', 'Jonthan''s Whistling Warsong', 'Kelin''s Lugubrious Lament', 'Elemental Rhythms', 'Anthem De Arms', 'Cinda''s Charismatic Carillon', 'Brusco''s Boastful Bellow', 'Purifying Rhythms', 'Lyssa''s Cataloging Libretto', 'Kelin''s Lucid Lullaby', 'Tarew''s Aquatic Ayre', 'Guardian Rhythms', 'Denon''s Disruptive Discord', 'Shauri''s Sonorous Clouding', 'Largo''s Melodic Binding', 'Cassindra''s Chant of Clarity', 'Melanie''s Mellifluous Motion', 'Alenia''s Disenchanting Melody', 'Selo''s Consonant Chain', 'Lyssa''s Veracious Concord', 'Psalm of Warmth', 'Angstlich''s Appalling Screech', 'Solon''s Song of the Sirens', 'Crission''s Pixie Strike', 'Psalm of Vitality', 'Fufil''s Curtailing Chant', 'Agilmente''s Aria of Eagles', 'Cassindra''s Chorus of Clarity', 'Psalm of Cooling', 'Cantana of Soothing', 'Lyssa''s Solidarity of Vision', 'Denon''s Dissension', 'Vilia''s Verses of Celerity', 'Psalm of Purity', 'Tuyen''s Chant of Flame', 'Solon''s Bewitching Bravura', 'Syvelian''s Anti-Magic Aria', 'Psalm of Mystic Shielding', 'McVaxius'' Berserker Crescendo', 'Denon''s Desperate Dirge', 'Cassindra''s Elegy', 'Jonthan''s Provocation', 'Tuyen''s Chant of Frost', 'Niv''s Melody of Preservation', 'Selo''s Chords of Cessation', 'Shield of Songs', 'Verses of Victory', 'Melody of Ervaj', 'Selo''s Song of Travel', 'Largo''s Assonant Binding', 'Nillipus'' March of the Wee', 'Song of Twilight', 'Song of Dawn', 'Vilia''s Chorus of Celerity', 'Selo''s Assonant Strain', 'Cantata of Replenishment', 'Brusco''s Bombastic Bellow', 'Occlusion of Sound', 'Song of Highsun', 'Song of Midnight', 'McVaxius'' Rousing Rondo', 'Cassindra''s Insipid Ditty', 'Niv''s Harmonic', 'Jonthan''s Inspiration', 'Denon''s Bereavement', 'Solon''s Charismatic Concord', 'Kazumi''s Note of Preservation', 'Angstlich''s Assonance', 'Composition of Ervaj' ) AND classes8 > 0 AND classes8 < 254; -- Delete Rogue disciplines not from Classic, Kunark, or Velious DELETE FROM spells_new WHERE name NOT IN ( 'Resistant Discipline', 'Fearless Discipline', 'Counterattack Discipline', 'Deadeye Discipline', 'Nimble Discipline', 'Kinesthetics Discipline', 'Blinding Speed Discipline', 'Duelist Discipline' ) AND classes9 > 0 AND classes9 < 254; -- Delete Shaman spells not from Classic, Kunark, or Velious DELETE FROM spells_new WHERE name NOT IN ( 'Burst of Flame', 'Cure Disease', 'Dexterous Aura', 'Endure Cold', 'Flash of Light', 'Inner Fire', 'Minor Healing', 'Strengthen', 'True North',

'Cure Poison', 'Drowsy', 'Endure Fire', 'Feet like Cat', 'Fleeting Fury', 'Frost Rift', 'Gate', 'Scale Skin', 'Sicken', 'Spirit Pouch', 'Summon Drink',

'Cure Blindness', 'Endure Disease', 'Light Healing', 'Sense Animals', 'Serpent Sight', 'Spirit of Bear', 'Spirit of Wolf', 'Spirit Sight', 'Summon Food', 'Tainted Breath',

'Bind Affinity', 'Burst of Strength', 'Disempower', 'Endure Poison', 'Enduring Breath', 'Invisibility versus Animals', 'Levitate', 'Root', 'Spirit of Snake', 'Spirit Strike', 'Turtle Skin', 'Walking Sleep',

'Affliction', 'Cancel Magic', 'Endure Magic', 'Frenzy', 'Healing', 'Infectious Cloud', 'Insidious Fever', 'Malaise', 'Shrink', 'Spirit of Cat', 'Spirit Strength', 'Vision',

'Cannibalize', 'Counteract Disease', 'Creeping Vision', 'Envenomed Breath', 'Frost Strike', 'Invigor', 'Poison Storm', 'Protect', 'Regeneration', 'Resist Cold', 'Spirit of Cheetah', 'Spirit of Monkey', 'Spirit of Ox', 'Scale of Wolf',

'Alluring Aura', 'Befriend Animal', 'Counteract Poison', 'Greater Healing', 'Imbue Amber', 'Imbue Ivory', 'Imbue Jade', 'Imbue Sapphire', 'Invisibility', 'Listless Power', 'Quickness', 'Raging Strength', 'Resist Fire', 'Rising Dexterity', 'Tagar''s Insects', 'Ultravision',

'Charm Animals', 'Companion Spirit', 'Instill', 'Fury', 'Health', 'Malaisement', 'Nimble', 'Resist Disease', 'Scourge', 'Shifting Shield', 'Shock of the Tainted', 'Talisman of Tnarg', 'Winter''s Roar',

'Assiduous Vision', 'Blinding Luminance', 'Cannibalize II', 'Chloroplast', 'Deftness', 'Extinguish Fatigue', 'Furious Strength', 'Gale of Poison', 'Glamour', 'Insidious Malady', 'Resist Poison', 'Togor''s Insects', 'Tumultuous Strength', 'Venom of the Snake', 'Vigilant Spirit',

'Agility', 'Alacrity', 'Blast of Poison', 'Blizzard Blast', 'Guardian', 'Guardian Spirit', 'Incapacitate', 'Nullify Magic', 'Resist Magic', 'Stamina', 'Summon Companion', 'Talisman of Altuna',

'Abolish Disease', 'Charisma', 'Dexterity', 'Envenomed Bolt', 'Frenzied Spirit', 'Malosi', 'Plague', 'Rage', 'Strength',

'Spirit Quickening',

'Superior Healing', 'Immobilize', 'Talisman of Jasinth', 'Turgur''s Insects',

'Insidious Decay', 'Regrowth', 'Spirit of Scale',

'Cripple', 'Deliriously Nimble', 'Talisman of Shadoo',

'Cannibalize III', 'Ice Strike', 'Riotous Health', 'Shroud of the Spirits',

'Annul Magic', 'Chloroblast', 'Form of the Great Bear', 'Spirit of the Howler', 'Talisman of Kragg', 'Torrent of Poison',

'Acumen', 'Bane of Nife', 'Celerity', 'Paralyzing Earth',

'Malosini', 'Maniacal Strength', 'Talisman of the Brute', 'Talisman of the Cat',

'Cannibalize IV', 'Mortal Deftness', 'Talisman of the Rhino', 'Talisman of the Serpent', 'Tigir''s Insects',

'Pox of Bertoxxulous', 'Talisman of the Raptor', 'Unfailing Reverence', 'Voice of the Berserker',

'Avatar', 'Focus of Spirit', 'Malo', 'Primal Avatar', 'Torpor' ) AND classes10 > 0 AND classes10 < 254; -- Delete Necromancer spells not from Classic, Kunark, or Velious DELETE FROM spells_new WHERE name NOT IN ( 'Cavorting Bones', 'Coldlight', 'Disease Cloud', 'Invisibility versus Undead', 'Lifetap', 'Locate Corpse', 'Minor Shielding', 'Reclaim Energy', 'Sense the Dead', 'Siphon Strength',

'Leering Corpse', 'Lifespike', 'Clinging Darkness', 'Poison Bolt', 'Endure Cold', 'Grim Aura', 'Fear', 'Numb the Dead', 'Gate', 'True North',

'Bone Walk', 'Ward Undead', 'Dark Pact', 'Deadeye', 'Gather Shadows', 'Lesser Shielding', 'Vampiric Embrace', 'Impart Strength', 'Dark Empathy', 'Mend Bones', 'Shadow Step',

'Bind Affinity', 'Convoke Shadow', 'Lifedraw', 'Engulfing Darkness', 'Heat Blood', 'Leach', 'Endure Disease', 'Scent of Dusk', 'Sight Graft', 'Spook the Dead', 'Wave of Enfeeblement',

'Restless Bones', 'Heart Flutter', 'Infectious Cloud', 'Banshee Aura', 'Shielding', 'Shieldskin', 'Spirit Armor', 'Cure Disease', 'Hungry Earth', 'Feign Death', 'Voice Graft', 'Cancel Magic',

'Animate Dead', 'Siphon Life', 'Expulse Undead', 'Word of Shadow', 'Allure of Death', 'Harmshield', 'Shadow Compact', 'Dominate Undead', 'Shadow Vortex', 'Track Corpse', 'Identify',

'Haunting Corpse', 'Shock of Poison', 'Resist Cold', 'Leatherskin', 'Major Shielding', 'Breath of the Dead', 'Shadow Sight', 'Intensify Death', 'Rest the Dead', 'Scent of Shadow', 'Screaming Terror', 'Rapacious Subversion',

'Summon Dead', 'Spirit Tap', 'Dooming Darkness', 'Boil Blood', 'Vampiric Curse', 'Dismiss Undead', 'Word of Spirit', 'Renew Bones', 'Panic the Dead',

'Invoke Shadow', 'Venom of the Snake', 'Torbas'' Acid Blast', 'Call of Bones', 'Greater Shielding', 'Steelskin', 'Resist Disease', 'Beguile Undead', 'Invoke Fear', 'Root', 'Surge of Enfeeblement',

'Malignant Dead', 'Drain Spirit', 'Chilling Embrace', 'Scourge', 'Expel Undead', 'Word of Souls', 'Augment Death', 'Counteract Disease', 'Scent of Darkness', 'Nullify Magic', 'Summon Corpse',

'Cackling Bones', 'Asystole', 'Ignite Bones', 'Incinerate Bones', 'Dead Man Floating', 'Arch Shielding', 'Diamondskin', 'Pact of Shadow', 'Corporeal Empathy', 'Covetous Subversion', 'Summon Companion',

'Invoke Death', 'Drain Soul', 'Cascading Darkness', 'Ignite Blood', 'Bond of Death', 'Banish Undead', 'Lich', 'Dead Men Floating', 'Cajole Undead', 'Paralyzing Earth',

'Improved Invisibility to Undead',

'Splurt', 'Envenomed Bolt', 'Dread of Night', 'Sacrifice',

'Plague', 'Defoliation', 'Manaskin', 'Scent of Terris',

'Minion of Shadows', 'Convergence', 'Instill', 'Annul Magic',

'Deflux', 'Shield of the Magi', 'Shadowbond', 'Thrall of Bones',

'Augmentation of Death', 'Chill Bones', 'Conglaciation of Bone', 'Levant', 'Infusion', 'Skin of the Shadow',

'Servant of Bones', 'Cessation of Cor', 'Trepidation', 'Sedulous Subversion',

'Vexing Mordinia', 'Exile Undead', 'Conjure Corpse',

'Pyrocruor', 'Quivering Veil of Xarn', 'Immobilize',

'Emissary of Thule', 'Touch of Night', 'Devouring Darkness',

'Trucidation', 'Banishment of Shadows', 'Demi Lich', 'Arch Lich', 'Enslave Death' ) AND classes11 > 0 AND classes11 < 254; -- Delete Wizard spells not from Classic, Kunark, or Velious DELETE FROM spells_new WHERE name NOT IN ( 'Frost Bolt', 'Minor Shielding', 'Numbing Cold', 'Shock of Frost', 'Sphere of Light',

'Fade', 'Gate', 'Glimpse', 'Icestrike', 'O''Keils Radiation', 'Root', 'See Invisible', 'Shock of Fire',

'Column of Frost', 'Eye of Zomm', 'Fingers of Fire', 'Fire Bolt', 'Lesser Shielding', 'Sense Summoned', 'Shadow Step', 'Shock of Ice', 'True North',

'Bind Affinity', 'Cancel Magic', 'Firestorm', 'Frost Spiral of Al''Kabor', 'Gaze', 'Halo of Light', 'Resistant Skin', 'Shock of Lightning',

'Bind Sight', 'Flame Shock', 'Heat Sight', 'Identify', 'Invisibility', 'Lightning Bolt', 'Pillar of Fire', 'Project Lightning', 'Shielding', 'Shieldskin',

'Elemental Shield', 'Instill', 'Fay Gate', 'Fire Spiral of Al''Kabor', 'Force Shock', 'North Gate', 'Sight', 'Tishan''s Clash', 'Tox Gate',

'Cast Force', 'Cazic Gate', 'Column of Lightning', 'Combine Gate', 'Common Gate', 'Frost Shock', 'Leatherskin', 'Levitate', 'Lightning Storm', 'Major Shielding', 'Nek Gate', 'Ro Gate', 'West Gate',

'Bonds of Force', 'Energy Storm', 'Evacuate: North', 'Fay Portal', 'Imbue Fire Opal', 'Inferno Shock', 'Magnify', 'North Portal', 'Shock Spiral of Al''Kabor', 'Thunder Strike', 'Tox Portal', 'Yonder',

'Cazic Portal', 'Circle of Force', 'Combine Portal', 'Evacuate: Fay', 'Great Divide Gate (Not on P99)', 'Greater Shielding', 'Harvest', 'Ice Shock', 'Iceclad Gate', 'Iceclad Portal', 'Lava Storm', 'Nek Portal', 'Nullify Magic', 'O''Keils Flickering Flame', 'Steelskin', 'Thunderclap',

'Chill Sight', 'Cobalt Scar Gate (not on P99)', 'Common Portal', 'Concussion', 'Evacuate: Ro', 'Force Spiral of Al''Kabor', 'Great Divide Portal', 'Immobilize', 'Invisibility to Undead', 'Lightning Shock', 'Markar''s Relocation', 'Ro Portal', 'Shifting Sight', 'Tishan''s Relocation', 'Translocate: Combine', 'Translocate: Fay', 'Translocate: North', 'Translocate: Tox', 'Wakening Lands Gate', 'West Portal',

'Arch Shielding', 'Cobalt Scar Portal', 'Conflagration', 'Diamondskin', 'Elemental Armor', 'Enticement of Flame', 'Evacuate: Nek', 'Force Strike', 'Frost Storm', 'Gravity Flux', 'Translocate: Cazic', 'Translocate: Common', 'Translocate: West', 'Translocate: Nek', 'Translocate: Ro', 'Wakening Lands Portal',

'Alter Plane: Hate', 'Alter Plane: Sky',

'Evacuate: West', 'Ice Comet', 'Markar''s Clash', 'Paralyzing Earth', 'Rend', 'Supernova', 'Translocate: Cobalt Scar', 'Translocate: Great Divide', 'Translocate: Iceclad', 'Translocate: Wakening Lands', 'Wrath of Al''Kabor',

'Translocate',

'Atol''s Spectral Shackles', 'Draught of Fire', 'Pillar of Frost', 'Tishan''s Discord',

'Abscond', 'Lure of Frost', 'Manaskin', 'Tears of Druzzil', 'Translocate: Group',

'Annul Magic', 'Inferno of Al''Kabor', 'Jyll''s Static Pulse',

'Pillar of Lightning', 'Shield of the Magi', 'Thunderbold', 'Voltaic Draught',

'Draught of Jiva', 'Improved Invisibility', 'Lure of Flame', 'Plainsight', 'Tears of Solusek',

'Jyll''s Zephyr of Ice', 'Markar''s Discord', 'Retribution of Al''Kabor',

'Draught of Ice', 'Evacuate', 'Eye of Tallon', 'Pillar of Flame',

'Fetter', 'Lure of Lightning', 'Manasink', 'Tears of Prexus',

'Flaming Sword of Xuzl', 'Invert Gravity', 'Jyll''s Wave of Heat', 'Vengeance of Al''Kabor',

'Disintegrate', 'Hsagra''s Wrath', 'Ice Spear of Solist', 'Lure of Ice', 'Porlos'' Fury', 'Sunstrike', 'Winds of Gelid' ) AND classes12 > 0 AND classes12 < 254; -- Delete Magician spells not from Classic, Kunark, or Velious DELETE FROM spells_new WHERE name NOT IN ( 'Burst of Flame', 'Flare', 'Minor Shielding', 'Reclaim Energy', 'Summon Dagger', 'Summon Drink', 'Summon Food', 'True North',

'Burn', 'Elementalkin: Air', 'Elementalkin: Earth', 'Elementalkin: Fire', 'Elementalkin: Water', 'Fire Flux', 'Gate', 'Sense Summoned', 'Summon Bandages', 'Summon Wisp',

'Dimensional Pocket', 'Elementaling: Air', 'Elementaling: Earth', 'Elementaling: Fire', 'Elementaling: Water', 'Eye of Zomm', 'Flame Bolt', 'Invisibility', 'Lesser Shielding', 'Renew Elements', 'Shield of Fire', 'Shock of Blades', 'Staff of Tracing',

'Bind Affinity', 'Burnout', 'Cancel Magic', 'Column of Fire', 'Elemental: Air', 'Elemental: Earth', 'Elemental: Fire', 'Elemental: Water', 'Rain of Blades', 'Summon Fang', 'Ward Summoned',

'Identify', 'Minor Summoning: Air', 'Minor Summoning: Earth', 'Minor Summoning: Fire', 'Minor Summoning: Water', 'Phantom Leather', 'See Invisible', 'Shielding', 'Shock of Flame', 'Staff of Warding', 'Summon Heatstone', 'Summon Throwing Dagger',

'Bolt of Flame', 'Elemental Shield', 'Expulse Summoned', 'Lesser Summoning: Air', 'Lesser Summoning: Earth', 'Lesser Summoning: Fire', 'Lesser Summoning: Water', 'Rain of Fire', 'Renew Summoning', 'Shield of Flame', 'Spear of Warding', 'Summon Arrows', 'Summon Waterstone',

'Cornucopia', 'Everfount', 'Flame Flux', 'Major Shielding', 'Malaise', 'Shock of Spikes', 'Staff of Runes', 'Summoning: Air', 'Summoning: Earth', 'Summoning: Fire', 'Summoning: Water',

'Burnout II', 'Dismiss Summoned', 'Expedience', 'Greater Summoning: Air', 'Greater Summoning: Earth', 'Greater Summoning: Fire', 'Greater Summoning: Water', 'Inferno Shield', 'Phantom Chain', 'Rain of Spikes', 'Summon Coldstone', 'Sword of Runes',

'Blaze', 'Cinder Bolt', 'Dimensional Hole', 'Greater Shielding', 'Minor Conjuration: Air', 'Minor Conjuration: Earth', 'Minor Conjuration: Fire', 'Minor Conjuration: Water', 'Monster Summoning I', 'Nullify Magic', 'Staff of Symbols', 'Summon Shard of the Core',

'Barrier of Combustion', 'Dagger of Symbols', 'Expel Summoned', 'Flame Arc', 'Lesser Conjuration: Air', 'Lesser Conjuration: Earth', 'Lesser Conjuration: Fire', 'Lesser Conjuration: Water', 'Rain of Lava', 'Summon Companion', 'Summon Ring of Flight',

'Arch Shielding', 'Conjuration: Air', 'Conjuration: Earth', 'Conjuration: Fire', 'Conjuration: Water', 'Elemental Armor', 'Elemental Maelstrom', 'Malaisement', 'Modulating Rod', 'Phantom Plate', 'Shock of Swords',

'Summon Orb',

'Banish Summoned', 'Burnout III', 'Greater Conjuration: Air', 'Greater Conjuration: Earth', 'Greater Conjuration: Fire', 'Greater Conjuration: Water', 'Lava Bolt', 'Rain of Swords', 'Shield of Lava',

'Monster Summoning II',

'Gift of Xev', 'Malosi', 'Scintillation', 'Vocarate: Earth',

'Bristlebane''s Bundle', 'Char', 'Phantom Armor', 'Vocarate: Fire',

'Annul Magic', 'Boon of Immolation', 'Quiver of Marr', 'Vocarate: Air',

'Bandoleer of Luclin', 'Scars of Sigil', 'Shield of the Magi', 'Vocarate: Water',

'Burnout IV', 'Call of the Hero', 'Pouch of Quellious', 'Rage of Zomm', 'Sirocco', 'Wrath of the Elements',

'Cadeau of Flame', 'Dyzil''s Deafening Decoy', 'Exile Summoned', 'Muzzle of Mardu',

'Eye of Tallon', 'Greater Vocaration: Earth', 'Shock of Steel',

'Greater Vocaration: Fire', 'Malosini', 'Velocity',

'Greater Vocaration: Air', 'Manastorm', 'Seeking Flame of Seukor', 'Valiant Companion',

'Aegis of Ro', 'Banishment', 'Greater Vocaration: Water', 'Mala', 'Monster Summoning III' ) AND classes13 > 0 AND classes13 < 254; -- Delete Enchanter spells not from Classic, Kunark, or Velious DELETE FROM spells_new WHERE name NOT IN ( 'Lull', 'Minor Illusion', 'Minor Shielding', 'Pendril''s Animation', 'Reclaim Energy', 'Shallow Breath', 'Strengthen', 'Taper Enchantment', 'True North', 'Weaken',

'Color Flux', 'Enfeeblement', 'Fear', 'Gate', 'Haze', 'Illusion: Half-Elf', 'Illusion: Human', 'Invisibility', 'Juli''s Animation', 'Mesmerize', 'Suffocating Sphere', 'Tashan',

'Alliance', 'Bind Sight', 'Cancel Magic', 'Chaotic Feedback', 'Enchant Clay', 'Enchant Silver', 'Eye of Confusion', 'Illusion: Gnome', 'Illusion: Wood Elf', 'Lesser Shielding', 'Mircyl''s Animation', 'Root', 'See Invisible', 'Sentinel', 'Soothe',

'Bind Affinity', 'Charm', 'Choke', 'Ebbing Strength', 'Enduring Breath', 'Illusion: Dark Elf', 'Illusion: Erudite', 'Illusion: Halfling', 'Illusion: High Elf', 'Kilan''s Animation', 'Languid Pace', 'Memory Blur', 'Mist', 'Serpent Sight', 'Thicken Mana', 'Whirl Till You Hurl',

'Breeze', 'The Overthere.', 'Chase the Moon', 'Disempower', 'Enchant Electrum', 'Enthrall', 'Identify', 'Illusion: Barbarian', 'Illusion: Dwarf', 'Illusion: Tree', 'Invisibility versus Undead', 'Levitate', 'Mesmerization', 'Quickness', 'Rune I', 'Sanity Warp', 'Shalee''s Animation', 'Shielding',

'Benevolence', 'Berserker Strength', 'Calm', 'Cloud', 'Color Shift', 'Crystallize Mana', 'Endure Magic', 'Feckless Might', 'Illusion: Iksar', 'Illusion: Ogre', 'Illusion: Troll', 'Shifting Sight', 'Sisna''s Animation', 'Sympathetic Aura', 'Tashani',

'Alacrity', 'Beguile', 'Chaos Flux', 'Enchant Gold', 'Illusion: Earth Elemental', 'Illusion: Skeleton', 'Invigor', 'Major Shielding', 'Rune II', 'Sagar''s Animation', 'Strip Enchantment', 'Tepid Deeds',

'Augmentation', 'Clarify Mana', 'Clarity', 'Curse of the Simple Mind', 'Dyn''s Dizzying Draught', 'Instill', 'Feedback', 'Illusion: Air Elemental', 'Illusion: Water Elemental', 'Listless Power', 'Nullify Magic', 'Obscure', 'Suffocate', 'Uleen''s Animation', 'Ultravision',

'Anarchy', 'Boltran''s Animation', 'Cast Sight', 'Enchant Platinum', 'Entrance', 'Gift of Magic', 'Thurgadin.', 'Greater Shielding', 'Illusion: Fire Elemental', 'Insipid Weakness', 'Mana Sieve', 'Radiant Visage', 'Rune III',

'Aanya''s Animation', 'Cajoling Whispers', 'Celerity', 'Distill Mana', 'Gravity Flux', 'Illusion: Dry Bone', 'Illusion: Spirit Wolf', 'Immobilize', 'Insight', 'Invoke Fear', 'Mind Wipe', 'Pacify', 'Rampage', 'Resist Magic', 'Shade', 'Wandering Mind',

'Arch Shielding', 'Boon of the Garou', 'Brilliance', 'Color Skew', 'Discordant Mind', 'Enchant Velium', 'Extinguish Fatigue', 'Illusion: Werewolf', 'Incapacitate', 'Pillage Enchantment', 'Rune IV', 'Shiftless Deeds', 'Summon Companion', 'Tashania', 'Weakness', 'Yegoreff''s Animation',

'Adorning Grace', 'Allure', 'Berserker Spirit', 'Blanket of Forgetfulness', 'Dazzle', 'Enchant Adamantite', 'Enchant Brellium', 'Enchant Mithril', 'Enchant Steel', 'Gasping Embrace', 'Group Resist Magic', 'Kintaz''s Animation', 'Paralyzing Earth', 'Purify Mana', 'Reoccurring Amnesia', 'Shadow', 'Swift Like The Wind',

'Improved Invisibility',

'Collaboration', 'Theft of Thought', 'Wake of Tranquility',

'Boon of the Clear Mind', 'Color Slant', 'Fascination', 'Rune V',

'Aanya''s Quickening', 'Boltran''s Agacerie', 'Cripple', 'Recant Magic',

'Clarity II', 'Dementia', 'Glamour of Kintaz', 'Shield of the Magi',

'Gift of Insight', 'Largarn''s Lamentation', 'Memory Flux', 'Wind of Tishani', 'Zumaik''s Animation',

'Augment', 'Overwhelming Splendor', 'Torment of Argli', 'Trepidation',

'Enlightenment', 'Forlorn Deeds', 'Tashanian', 'Umbra',

'Bedlam', 'Fetter', 'Wonderous Rapidity',

'Asphyxiate', 'Gift of Pure Thought', 'Rapture',

'Dictate', 'Gift of Brilliance', 'Visions of Grandeur', 'Wind of Tishanian' ) AND classes14 > 0 AND classes14 < 254;

UPDATE spells_new SET classes2=1 WHERE classes2 < 61 AND name IN ( 'Courage', 'Cure Poison', 'Divine Aura', 'Flash of Light', 'Lull', 'Minor Healing', 'Spook the Dead', 'Strike', 'True North', 'Yaulp');

UPDATE spells_new SET classes2=5 WHERE classes2 < 61 AND name IN ( 'Cure Blindness', 'Cure Disease', 'Furor', 'Gate', 'Holy Armor', 'Light Healing', 'Reckless Strength', 'Stun', 'Summon Drink', 'Ward Undead');

UPDATE spells_new SET classes2=9 WHERE classes2 < 61 AND name IN ( 'Center', 'Endure Fire', 'Endure Poison', 'Fear', 'Hammer of Wrath', 'Invigor', 'Root', 'Sense the Dead', 'Soothe', 'Summon Food', 'Word of Pain');

UPDATE spells_new SET classes2=14 WHERE classes2 < 61 AND name IN ( 'Bind Affinity', 'Cancel Magic', 'Endure Cold', 'Endure Disease', 'Expulse Undead', 'Halo of Light', 'Healing', 'Invisibility versus Undead', 'Sense Summoned', 'Smite', 'Symbol of Transal');

UPDATE spells_new SET classes2=19 WHERE classes2 < 61 AND name IN ( 'Calm', 'Daring', 'Endure Magic', 'Extinguish Fatigue', 'Holy Might', 'Spirit Armor', 'Ward Summoned', 'Word of Shadow', 'Yaulp II');

UPDATE spells_new SET classes2=24 WHERE classes2 < 61 AND name IN ( 'Bravery', 'Counteract Poison', 'Dismiss Undead', 'Greater Healing', 'Hammer of Striking', 'Inspire Fear', 'Symbol of Ryltan', 'Wave of Fear');

UPDATE spells_new SET classes2=29 WHERE classes2 < 61 AND name IN ( 'Abundant Drink', 'Counteract Disease', 'Divine Barrier', 'Instill', 'Expulse Summoned', 'Guard', 'Imbue Black Pearl', 'Imbue Black Sapphire', 'Imbue Diamond', 'Imbue Emerald', 'Imbue Opal', 'Imbue Peridot', 'Imbue Plains Pebble', 'Imbue Rose Quartz', 'Imbue Ruby', 'Imbue Sapphire', 'Imbue Topaz', 'Panic the Dead', 'Revive', 'Word of Spirit', 'Wrath');

UPDATE spells_new SET classes2=34 WHERE classes2 < 61 AND name IN ( 'Abundant Food', 'Armor of Protection', 'Atone', 'Blinding Luminance', 'Expel Undead', 'Force', 'Frenzied Strength', 'Resist Fire', 'Resist Poison', 'Superior Healing', 'Symbol of Pinzarn', 'Tremor', 'Valor', 'Word of Health');

UPDATE spells_new SET classes2=39 WHERE classes2 < 61 AND name IN ( 'Armor of Faith', 'Complete Heal', 'Dismiss Summoned', 'Invoke Fear', 'Nullify Magic', 'Pacify', 'Resist Cold', 'Resist Disease', 'Resuscitate', 'Turning of the Unnatural', 'Word of Souls');

UPDATE spells_new SET classes2=44 WHERE classes2 < 61 AND name IN ( 'Banish Undead', 'Celestial Healing', 'Earthquake', 'Hammer of Requital', 'Resist Magic', 'Resolution', 'Retribution', 'Symbol of Naltron', 'Yaulp III');

UPDATE spells_new SET classes2=49 WHERE classes2 < 61 AND name IN ( 'Abolish Poison', 'Expel Summoned', 'Immobilize', 'Resurrection', 'Shield of Words', 'Sound of Force', 'Word Divine', 'Word of Healing');

UPDATE spells_new SET classes2=50 WHERE classes2 < 61 AND name IN ( 'Improved Invisibility to Undead');

UPDATE spells_new SET classes2=51 WHERE classes2 < 61 AND name IN ( 'Death Pact', 'Dread of Night', 'Remedy', 'Sunskin');

UPDATE spells_new SET classes2=52 WHERE classes2 < 61 AND name IN ( 'Heroic Bond', 'Heroism', 'Upheaval', 'Word of Vigor');

UPDATE spells_new SET classes2=53 WHERE classes2 < 61 AND name IN ( 'Annul Magic', 'Divine Light', 'Yaulp IV');

UPDATE spells_new SET classes2=54 WHERE classes2 < 61 AND name IN ( 'Reckoning', 'Symbol of Marzin', 'Unswerving Hammer of Faith');

UPDATE spells_new SET classes2=55 WHERE classes2 < 61 AND name IN ( 'Exile Undead', 'Fortitude', 'Stun Command', 'Wake of Tranquility');

UPDATE spells_new SET classes2=56 WHERE classes2 < 61 AND name IN ( 'Banish Summoned', 'Mark of Karn', 'Paralyzing Earth', 'Reviviscence');

UPDATE spells_new SET classes2=57 WHERE classes2 < 61 AND name IN ( 'Aegis', 'Bulwark of Faith', 'Trepidation', 'Word of Restoration');

UPDATE spells_new SET classes2=58 WHERE classes2 < 61 AND name IN ( 'Antidote', 'Enforced Reverence', 'Naltron''s Mark');

UPDATE spells_new SET classes2=59 WHERE classes2 < 61 AND name IN ( 'Celestial Elixir', 'The Unspoken Word');

UPDATE spells_new SET classes2=60 WHERE classes2 < 61 AND name IN ( 'Aegolism', 'Banishment of Shadows', 'Divine Intervention', 'Word of Redemption');

UPDATE spells_new SET classes3=9 WHERE classes3 < 61 AND name IN ( 'Courage', 'Cure Poison', 'Flash of Light', 'Minor Healing', 'Spook the Dead', 'True North', 'Yaulp');

UPDATE spells_new SET classes3=15 WHERE classes3 < 61 AND name IN ( 'Cure Disease', 'Hammer of Wrath', 'Holy Armor', 'Light Healing', 'Lull', 'Sense the Dead', 'Ward Undead');

UPDATE spells_new SET classes3=22 WHERE classes3 < 61 AND name IN ( 'Center', 'Endure Poison', 'Halo of Light', 'Invigor', 'Invisibility versus Undead', 'Reckless Strength', 'Root');

UPDATE spells_new SET classes3=30 WHERE classes3 < 61 AND name IN ( 'Endure Magic', 'Expulse Undead', 'Hammer of Striking', 'Healing', 'Soothe', 'Spirit Armor', 'Stun', 'Symbol of Transal');

UPDATE spells_new SET classes3=39 WHERE classes3 < 61 AND name IN ( 'Cancel Magic', 'Counteract Poison', 'Daring', 'Divine Purpose', 'Endure Disease', 'Greater Healing', 'Symbol of Ryltan', 'Yaulp II', 'Guard');

UPDATE spells_new SET classes3=49 WHERE classes3 < 61 AND name IN ( 'Dismiss Undead', 'Calm', 'Divine Might', 'Holy Might', 'Revive', 'Symbol of Pinzarn', 'Valor', 'Armor of Faith');

UPDATE spells_new SET classes3=50 WHERE classes3 < 61 AND name IN ( 'Flame of Light');

UPDATE spells_new SET classes3=51 WHERE classes3 < 61 AND name IN ( 'Pacify', 'Resist Disease');

UPDATE spells_new SET classes3=52 WHERE classes3 < 61 AND name IN ( 'Force', 'Frenzied Strength');

UPDATE spells_new SET classes3=53 WHERE classes3 < 61 AND name IN ( 'Divine Glory');

UPDATE spells_new SET classes3=54 WHERE classes3 < 61 AND name IN ( 'Instill', 'Expel Undead');

UPDATE spells_new SET classes3=55 WHERE classes3 < 61 AND name IN ( 'Divine Favor', 'Divine Aura', 'Resist Magic', 'Wave of Healing');

UPDATE spells_new SET classes3=56 WHERE classes3 < 61 AND name IN ( 'Counteract Disease', 'Yaulp III');

UPDATE spells_new SET classes3=57 WHERE classes3 < 61 AND name IN ( 'Superior Healing');

UPDATE spells_new SET classes3=58 WHERE classes3 < 61 AND name IN ( 'Nullify Magic', 'Symbol of Naltron');

UPDATE spells_new SET classes3=59 WHERE classes3 < 61 AND name IN ( 'Celestial Cleansing', 'Resurrection');

UPDATE spells_new SET classes3=60 WHERE classes3 < 61 AND name IN ( 'Divine Strength', 'Resolution', 'Shield of Words', 'Yaulp IV');

UPDATE spells_new SET classes4=9 WHERE classes4 < 61 AND name IN ( 'Endure Fire', 'Flame Lick', 'Glimpse', 'Lull Animal', 'Minor Healing', 'Skin Like Wood', 'Snare');

UPDATE spells_new SET classes4=15 WHERE classes4 < 61 AND name IN ( 'Burst of Fire', 'Camouflage', 'Cure Poison', 'Dance of the Fireflies', 'Feet like Cat', 'Grasping Roots', 'Invoke Lightning', 'Thistlecoat');

UPDATE spells_new SET classes4=22 WHERE classes4 < 61 AND name IN ( 'Bind Sight', 'Endure Cold', 'Enduring Breath', 'Firefist', 'Harmony', 'Ignite', 'Light Healing', 'Panic Animal', 'Skin Like Rock', 'Ward Summoned');

UPDATE spells_new SET classes4=30 WHERE classes4 < 61 AND name IN ( 'Barbcoat', 'Cancel Magic', 'Eyes of the Cat', 'Invigor', 'Shield of Thistles', 'Stinging Swarm', 'Strength of Earth', 'Spirit of Wolf');

UPDATE spells_new SET classes4=39 WHERE classes4 < 61 AND name IN ( 'Bramblecoat', 'Call of Sky', 'Calm Animal', 'Careless Lightning', 'Dismiss Summoned', 'Healing', 'Levitate', 'See Invisible', 'Skin Like Steel');

UPDATE spells_new SET classes4=49 WHERE classes4 < 61 AND name IN ( 'Spikecoat', 'Ensnaring Roots', 'Immolate', 'Resist Fire', 'Shield of Brambles', 'Superior Camouflage', 'Wolf Form');

UPDATE spells_new SET classes4=50 WHERE classes4 < 61 AND name IN ( 'Call of Flame', 'Call of Earth');

UPDATE spells_new SET classes4=51 WHERE classes4 < 61 AND name IN ( 'Ensnare', 'Jolt', 'Strength of Nature');

UPDATE spells_new SET classes4=52 WHERE classes4 < 61 AND name IN ( 'Extinguish Fatigue', 'Firestrike');

UPDATE spells_new SET classes4=53 WHERE classes4 < 61 AND name IN ( 'Storm Strength');

UPDATE spells_new SET classes4=54 WHERE classes4 < 61 AND name IN ( 'Drones of Doom', 'Skin Like Diamond');

UPDATE spells_new SET classes4=55 WHERE classes4 < 61 AND name IN ( 'Call of Fire', 'Chloroplast', 'Cinder Jolt', 'Resist Cold');

UPDATE spells_new SET classes4=56 WHERE classes4 < 61 AND name IN ( 'Chill Sight', 'Greater Wolf Form');

UPDATE spells_new SET classes4=57 WHERE classes4 < 61 AND name IN ( 'Greater Healing');

UPDATE spells_new SET classes4=58 WHERE classes4 < 61 AND name IN ( 'Nullify Magic', 'Shield of Spikes');

UPDATE spells_new SET classes4=59 WHERE classes4 < 61 AND name IN ( 'Calefaction', 'Skin Like Nature');

UPDATE spells_new SET classes4=60 WHERE classes4 < 61 AND name IN ( 'Call of the Predator', 'Enveloping Roots', 'Thorncoat');

UPDATE spells_new SET classes5=9 WHERE classes5 < 61 AND name IN ( 'Disease Cloud', 'Invisibility versus Undead', 'Leering Corpse', 'Lifetap', 'Locate Corpse', 'Sense the Dead', 'Siphon Strength');

UPDATE spells_new SET classes5=15 WHERE classes5 < 61 AND name IN ( 'Bone Walk', 'Clinging Darkness', 'Endure Cold', 'Fear', 'Lifespike', 'Numb the Dead', 'Shadow Step');

UPDATE spells_new SET classes5=22 WHERE classes5 < 61 AND name IN ( 'Convoke Shadow', 'Dark Empathy', 'Deadeye', 'Engulfing Darkness', 'Grim Aura', 'Spook the Dead', 'Vampiric Embrace', 'Ward Undead');

UPDATE spells_new SET classes5=29 WHERE classes5 < 61 AND name IN ( 'Strengthen Death');

UPDATE spells_new SET classes5=30 WHERE classes5 < 61 AND name IN ( 'Endure Disease', 'Feign Death', 'Gather Shadows', 'Heat Blood', 'Lifedraw', 'Restless Bones', 'Wave of Enfeeblement');

UPDATE spells_new SET classes5=34 WHERE classes5 < 61 AND name IN ( 'Shieldskin');

UPDATE spells_new SET classes5=39 WHERE classes5 < 61 AND name IN ( 'Animate Dead', 'Cancel Magic', 'Expulse Undead', 'Heart Flutter', 'Resist Cold', 'Shadow Vortex', 'Shroud of Hate');

UPDATE spells_new SET classes5=49 WHERE classes5 < 61 AND name IN ( 'Breath of the Dead', 'Dismiss Undead', 'Dooming Darkness', 'Invoke Fear', 'Life Leech', 'Shadow Sight', 'Summon Dead', 'Word of Spirit');

UPDATE spells_new SET classes5=50 WHERE classes5 < 61 AND name IN ( 'Shroud of Pain');

UPDATE spells_new SET classes5=51 WHERE classes5 < 61 AND name IN ( 'Siphon Life', 'Summon Corpse');

UPDATE spells_new SET classes5=52 WHERE classes5 < 61 AND name IN ( 'Malignant Dead', 'Rest the Dead');

UPDATE spells_new SET classes5=53 WHERE classes5 < 61 AND name IN ( 'Boil Blood');

UPDATE spells_new SET classes5=54 WHERE classes5 < 61 AND name IN ( 'Banshee Aura', 'Panic the Dead');

UPDATE spells_new SET classes5=55 WHERE classes5 < 61 AND name IN ( 'Bobbing Corpse', 'Expel Undead', 'Shroud of Death', 'Shroud of Undeath', 'Spirit Tap');

UPDATE spells_new SET classes5=56 WHERE classes5 < 61 AND name IN ( 'Steelskin');

UPDATE spells_new SET classes5=57 WHERE classes5 < 61 AND name IN ( 'Vampiric Curse', 'Drain Spirit');

UPDATE spells_new SET classes5=58 WHERE classes5 < 61 AND name IN ( 'Cackling Bones', 'Nullify Magic');

UPDATE spells_new SET classes5=59 WHERE classes5 < 61 AND name IN ( 'Cascading Darkness', 'Diamondskin');

UPDATE spells_new SET classes5=60 WHERE classes5 < 61 AND name IN ( 'Asystole', 'Drain Soul', 'Death Peace');

UPDATE spells_new SET classes6=1 WHERE classes6 < 61 AND name IN ( 'Burst of Flame', 'Dance of the Fireflies', 'Endure Fire', 'Flame Lick', 'Lull Animal', 'Minor Healing', 'Panic Animal', 'Sense Animals', 'Skin like Wood', 'Snare');

UPDATE spells_new SET classes6=5 WHERE classes6 < 61 AND name IN ( 'Burst of Fire', 'Camouflage', 'Cure Disease', 'Cure Poison', 'Gate', 'Grasping Roots', 'Harmony', 'Invoke Lightning', 'Ward Summoned', 'Whirling Wind');

UPDATE spells_new SET classes6=9 WHERE classes6 < 61 AND name IN ( 'Endure Cold', 'Enduring Breath', 'Firefist', 'Ignite', 'Invisibility versus Animals', 'Light Healing', 'Shield of Thistles', 'Starshine', 'Strength of Earth', 'Thistlecoat', 'Treeform');

UPDATE spells_new SET classes6=14 WHERE classes6 < 61 AND name IN ( 'Befriend Animal', 'Bind Affinity', 'Cascade of Hail', 'Expulse Summoned', 'Halo of Light', 'Invigor', 'Levitate', 'See Invisible', 'Skin like Rock', 'Spirit of Wolf', 'Stinging Swarm', 'Summon Drink', 'Summon Food');

UPDATE spells_new SET classes6=19 WHERE classes6 < 61 AND name IN ( 'Barbcoat', 'Calm Animal', 'Cancel Magic', 'Careless Lightning', 'Dizzying Wind', 'Endure Disease', 'Endure Poison', 'Feral Spirit', 'Healing', 'Ring of Butcher', 'Ring of Commons', 'Ring of Karana', 'Ring of Toxxulia', 'Shield of Barbs', 'Superior Camouflage', 'Terrorize Animal');

UPDATE spells_new SET classes6=24 WHERE classes6 < 61 AND name IN ( 'Charm Animals', 'Creeping Crud', 'Dismiss Summoned', 'Ensnaring Roots', 'Pogonip', 'Resist Fire', 'Ring of Feerrott', 'Ring of Lavastorm', 'Ring of Ro', 'Ring of Steamfont', 'Ring of the Combines', 'Scale of Wolf', 'Skin like Steel', 'Spirit of Cheetah', 'Sunbeam', 'Tremor', 'Wolf Form');

UPDATE spells_new SET classes6=29 WHERE classes6 < 61 AND name IN ( 'Beguile Plants', 'Bramblecoat', 'Circle of Butcher', 'Circle of Commons', 'Circle of Karana', 'Circle of Toxxulia', 'Counteract Disease', 'Counteract Poison', 'Ensnare', 'Extinguish Fatigue', 'Greater Healing', 'Imbue Emerald', 'Imbue Plains Pebble', 'Immolate', 'Ring of Misty', 'Shield of Brambles', 'Succor: East', 'Combust');

UPDATE spells_new SET classes6=34 WHERE classes6 < 61 AND name IN ( 'Beguile Animals', 'Circle of Feerrott', 'Circle of Iceclad', 'Circle of Lavastorm', 'Circle of Ro', 'Circle of Steamfont', 'Circle of the Combines', 'Drones of Doom', 'Earthquake', 'Endure Magic', 'Expel Summoned', 'Fury of Air', 'Greater Wolf Form', 'Lightning Strike', 'Regeneration', 'Resist Cold', 'Ring of Great Divide', 'Ring of Iceclad', 'Strength of Stone', 'Succor: Butcher');

UPDATE spells_new SET classes6=39 WHERE classes6 < 61 AND name IN ( 'Avalanche', 'Circle of Great Divide', 'Circle of Misty', 'Enveloping Roots', 'Firestrike', 'Pack Regeneration', 'Pack Spirit', 'Ring of Cobalt Scar', 'Ring of Wakening Lands', 'Ro''s Fiery Sundering', 'Share Wolf Form', 'Shield of Spikes', 'Skin Like Diamond', 'Spikecoat', 'Succor: Ro', 'Wind of the North', 'Wind of the South');

UPDATE spells_new SET classes6=44 WHERE classes6 < 61 AND name IN ( 'Allure of the Wild', 'Banish Summoned', 'Calefaction', 'Chloroplast', 'Circle of Cobalt Scar', 'Circle of Wakening Lands', 'Drifting Death', 'Fixation of Ro', 'Form of the Great Wolf', 'Nullify Magic', 'Resist Disease', 'Resist Poison', 'Savage Spirit', 'Storm Strength', 'Succor: Lavastorm');

UPDATE spells_new SET classes6=49 WHERE classes6 < 61 AND name IN ( 'Engulfing Roots', 'Fire', 'Ice', 'Lightning Blast', 'Pack Chloroplast', 'Resist Magic', 'Shield of Thorns', 'Skin Like Nature', 'Starfire', 'Succor: North', 'Thorncoat');

UPDATE spells_new SET classes6=50 WHERE classes6 < 61 AND name IN ( 'Improved Superior Camouflage');

UPDATE spells_new SET classes6=51 WHERE classes6 < 61 AND name IN ( 'Circle of Winter', 'Legacy of Spike', 'Repulse Animal', 'Superior Healing', 'Upheaval');

UPDATE spells_new SET classes6=52 WHERE classes6 < 61 AND name IN ( 'Breath of Ro', 'Call of Karana', 'Circle of Summer', 'Egress');

UPDATE spells_new SET classes6=53 WHERE classes6 < 61 AND name IN ( 'Glamour of Tunare', 'Spirit of Scale', 'Winged Death');

UPDATE spells_new SET classes6=54 WHERE classes6 < 61 AND name IN ( 'Blizzard', 'Form of the Howler', 'Regrowth', 'Scoriae');

UPDATE spells_new SET classes6=55 WHERE classes6 < 61 AND name IN ( 'Annul Magic', 'Chloroblast', 'Exile Summoned', 'Girdle of Karana', 'Nature Walkers Behest', 'Tunare''s Request');

UPDATE spells_new SET classes6=56 WHERE classes6 < 61 AND name IN ( 'Bladecoat', 'Breath of Karana', 'Engorging Roots', 'Wake of Karana');

UPDATE spells_new SET classes6=57 WHERE classes6 < 61 AND name IN ( 'Bonds of Tunare', 'Frost', 'Natureskin', 'Succor');

UPDATE spells_new SET classes6=58 WHERE classes6 < 61 AND name IN ( 'Fist of Karana', 'Regrowth of the Grove', 'Shield of Blades');

UPDATE spells_new SET classes6=59 WHERE classes6 < 61 AND name IN ( 'Legacy of Thorn', 'Spirit of Oak', 'Wildfire');

UPDATE spells_new SET classes6=60 WHERE classes6 < 61 AND name IN ( 'Banishment', 'Entrapping Roots', 'Form of the Hunter', 'Mask of the Hunter', 'Nature''s Touch', 'Protection of the Glades');

UPDATE spells_new SET classes10=1 WHERE classes10 < 61 AND name IN ( 'Burst of Flame', 'Cure Disease', 'Dexterous Aura', 'Endure Cold', 'Flash of Light', 'Inner Fire', 'Minor Healing', 'Strengthen', 'True North');

UPDATE spells_new SET classes10=5 WHERE classes10 < 61 AND name IN ( 'Cure Poison', 'Drowsy', 'Endure Fire', 'Feet like Cat', 'Fleeting Fury', 'Frost Rift', 'Gate', 'Scale Skin', 'Sicken', 'Spirit Pouch', 'Summon Drink');

UPDATE spells_new SET classes10=9 WHERE classes10 < 61 AND name IN ( 'Cure Blindness', 'Endure Disease', 'Light Healing', 'Sense Animals', 'Serpent Sight', 'Spirit of Bear', 'Spirit of Wolf', 'Spirit Sight', 'Summon Food', 'Tainted Breath');

UPDATE spells_new SET classes10=14 WHERE classes10 < 61 AND name IN ( 'Bind Affinity', 'Burst of Strength', 'Disempower', 'Endure Poison', 'Enduring Breath', 'Invisibility versus Animals', 'Levitate', 'Root', 'Spirit of Snake', 'Spirit Strike', 'Turtle Skin', 'Walking Sleep');

UPDATE spells_new SET classes10=19 WHERE classes10 < 61 AND name IN ( 'Affliction', 'Cancel Magic', 'Endure Magic', 'Frenzy', 'Healing', 'Infectious Cloud', 'Insidious Fever', 'Malaise', 'Shrink', 'Spirit of Cat', 'Spirit Strength', 'Vision');

UPDATE spells_new SET classes10=24 WHERE classes10 < 61 AND name IN ( 'Cannibalize', 'Counteract Disease', 'Creeping Vision', 'Envenomed Breath', 'Frost Strike', 'Invigor', 'Poison Storm', 'Protect', 'Regeneration', 'Resist Cold', 'Spirit of Cheetah', 'Spirit of Monkey', 'Spirit of Ox', 'Scale of Wolf');

UPDATE spells_new SET classes10=29 WHERE classes10 < 61 AND name IN ( 'Alluring Aura', 'Befriend Animal', 'Counteract Poison', 'Greater Healing', 'Imbue Amber', 'Imbue Ivory', 'Imbue Jade', 'Imbue Sapphire', 'Invisibility', 'Listless Power', 'Quickness', 'Raging Strength', 'Resist Fire', 'Rising Dexterity', 'Tagar''s Insects', 'Ultravision');

UPDATE spells_new SET classes10=34 WHERE classes10 < 61 AND name IN ( 'Charm Animals', 'Companion Spirit', 'Instill', 'Fury', 'Health', 'Malaisement', 'Nimble', 'Resist Disease', 'Scourge', 'Shifting Shield', 'Shock of the Tainted', 'Talisman of Tnarg', 'Winter''s Roar');

UPDATE spells_new SET classes10=39 WHERE classes10 < 61 AND name IN ( 'Assiduous Vision', 'Blinding Luminance', 'Cannibalize II', 'Chloroplast', 'Deftness', 'Extinguish Fatigue', 'Furious Strength', 'Gale of Poison', 'Glamour', 'Insidious Malady', 'Resist Poison', 'Togor''s Insects', 'Tumultuous Strength', 'Venom of the Snake', 'Vigilant Spirit');

UPDATE spells_new SET classes10=44 WHERE classes10 < 61 AND name IN ( 'Agility', 'Alacrity', 'Blast of Poison', 'Blizzard Blast', 'Guardian', 'Guardian Spirit', 'Incapacitate', 'Nullify Magic', 'Resist Magic', 'Stamina', 'Summon Companion', 'Talisman of Altuna');

UPDATE spells_new SET classes10=49 WHERE classes10 < 61 AND name IN ( 'Abolish Disease', 'Charisma', 'Dexterity', 'Envenomed Bolt', 'Frenzied Spirit', 'Malosi', 'Plague', 'Rage', 'Strength');

UPDATE spells_new SET classes10=50 WHERE classes10 < 61 AND name IN ( 'Spirit Quickening');

UPDATE spells_new SET classes10=51 WHERE classes10 < 61 AND name IN ( 'Superior Healing', 'Immobilize', 'Talisman of Jasinth', 'Turgur''s Insects');

UPDATE spells_new SET classes10=52 WHERE classes10 < 61 AND name IN ( 'Insidious Decay', 'Regrowth', 'Spirit of Scale');

UPDATE spells_new SET classes10=53 WHERE classes10 < 61 AND name IN ( 'Cripple', 'Deliriously Nimble', 'Talisman of Shadoo');

UPDATE spells_new SET classes10=54 WHERE classes10 < 61 AND name IN ( 'Cannibalize III', 'Ice Strike', 'Riotous Health', 'Shroud of the Spirits');

UPDATE spells_new SET classes10=55 WHERE classes10 < 61 AND name IN ( 'Annul Magic', 'Chloroblast', 'Form of the Great Bear', 'Spirit of the Howler', 'Talisman of Kragg', 'Torrent of Poison');

UPDATE spells_new SET classes10=56 WHERE classes10 < 61 AND name IN ( 'Acumen', 'Bane of Nife', 'Celerity', 'Paralyzing Earth');

UPDATE spells_new SET classes10=57 WHERE classes10 < 61 AND name IN ( 'Malosini', 'Maniacal Strength', 'Talisman of the Brute', 'Talisman of the Cat');

UPDATE spells_new SET classes10=58 WHERE classes10 < 61 AND name IN ( 'Cannibalize IV', 'Mortal Deftness', 'Talisman of the Rhino', 'Talisman of the Serpent', 'Tigir''s Insects');

UPDATE spells_new SET classes10=59 WHERE classes10 < 61 AND name IN ( 'Pox of Bertoxxulous', 'Talisman of the Raptor', 'Unfailing Reverence', 'Voice of the Berserker');

UPDATE spells_new SET classes10=60 WHERE classes10 < 61 AND name IN ( 'Avatar', 'Focus of Spirit', 'Malo', 'Primal Avatar', 'Torpor');

UPDATE spells_new SET classes11=1 WHERE classes11 < 61 AND name IN ( 'Cavorting Bones', 'Coldlight', 'Disease Cloud', 'Invisibility versus Undead', 'Lifetap', 'Locate Corpse', 'Minor Shielding', 'Reclaim Energy', 'Sense the Dead', 'Siphon Strength');

UPDATE spells_new SET classes11=4 WHERE classes11 < 61 AND name IN ( 'Leering Corpse', 'Lifespike', 'Clinging Darkness', 'Poison Bolt', 'Endure Cold', 'Grim Aura', 'Fear', 'Numb the Dead', 'Gate', 'True North');

UPDATE spells_new SET classes11=8 WHERE classes11 < 61 AND name IN ( 'Bone Walk', 'Ward Undead', 'Dark Pact', 'Deadeye', 'Gather Shadows', 'Lesser Shielding', 'Vampiric Embrace', 'Impart Strength', 'Dark Empathy', 'Mend Bones', 'Shadow Step');

UPDATE spells_new SET classes11=12 WHERE classes11 < 61 AND name IN ( 'Bind Affinity', 'Convoke Shadow', 'Lifedraw', 'Engulfing Darkness', 'Heat Blood', 'Leach', 'Endure Disease', 'Scent of Dusk', 'Sight Graft', 'Spook the Dead', 'Wave of Enfeeblement');

UPDATE spells_new SET classes11=16 WHERE classes11 < 61 AND name IN ( 'Restless Bones', 'Heart Flutter', 'Infectious Cloud', 'Banshee Aura', 'Shielding', 'Shieldskin', 'Spirit Armor', 'Cure Disease', 'Hungry Earth', 'Feign Death', 'Voice Graft', 'Cancel Magic');

UPDATE spells_new SET classes11=20 WHERE classes11 < 61 AND name IN ( 'Animate Dead', 'Siphon Life', 'Expulse Undead', 'Word of Shadow', 'Allure of Death', 'Harmshield', 'Shadow Compact', 'Dominate Undead', 'Shadow Vortex', 'Track Corpse', 'Identify');

UPDATE spells_new SET classes11=24 WHERE classes11 < 61 AND name IN ( 'Haunting Corpse', 'Shock of Poison', 'Resist Cold', 'Leatherskin', 'Major Shielding', 'Breath of the Dead', 'Shadow Sight', 'Intensify Death', 'Rest the Dead', 'Scent of Shadow', 'Screaming Terror', 'Rapacious Subversion');

UPDATE spells_new SET classes11=29 WHERE classes11 < 61 AND name IN ( 'Summon Dead', 'Spirit Tap', 'Dooming Darkness', 'Boil Blood', 'Vampiric Curse', 'Dismiss Undead', 'Word of Spirit', 'Renew Bones', 'Panic the Dead');

UPDATE spells_new SET classes11=34 WHERE classes11 < 61 AND name IN ( 'Invoke Shadow', 'Venom of the Snake', 'Torbas'' Acid Blast', 'Call of Bones', 'Greater Shielding', 'Steelskin', 'Resist Disease', 'Beguile Undead', 'Invoke Fear', 'Root', 'Surge of Enfeeblement');

UPDATE spells_new SET classes11=39 WHERE classes11 < 61 AND name IN ( 'Malignant Dead', 'Drain Spirit', 'Chilling Embrace', 'Scourge', 'Expel Undead', 'Word of Souls', 'Augment Death', 'Counteract Disease', 'Scent of Darkness', 'Nullify Magic', 'Summon Corpse');

UPDATE spells_new SET classes11=44 WHERE classes11 < 61 AND name IN ( 'Cackling Bones', 'Asystole', 'Ignite Bones', 'Incinerate Bones', 'Dead Man Floating', 'Arch Shielding', 'Diamondskin', 'Pact of Shadow', 'Corporeal Empathy', 'Covetous Subversion', 'Summon Companion');

UPDATE spells_new SET classes11=49 WHERE classes11 < 61 AND name IN ( 'Invoke Death', 'Drain Soul', 'Cascading Darkness', 'Ignite Blood', 'Bond of Death', 'Banish Undead', 'Lich', 'Dead Men Floating', 'Cajole Undead', 'Paralyzing Earth');

UPDATE spells_new SET classes11=50 WHERE classes11 < 61 AND name IN ( 'Improved Invisibility to Undead');

UPDATE spells_new SET classes11=51 WHERE classes11 < 61 AND name IN ( 'Splurt', 'Envenomed Bolt', 'Dread of Night', 'Sacrifice');

UPDATE spells_new SET classes11=52 WHERE classes11 < 61 AND name IN ( 'Plague', 'Defoliation', 'Manaskin', 'Scent of Terris');

UPDATE spells_new SET classes11=53 WHERE classes11 < 61 AND name IN ( 'Minion of Shadows', 'Convergence', 'Instill', 'Annul Magic');

UPDATE spells_new SET classes11=54 WHERE classes11 < 61 AND name IN ( 'Deflux', 'Shield of the Magi', 'Shadowbond', 'Thrall of Bones');

UPDATE spells_new SET classes11=55 WHERE classes11 < 61 AND name IN ( 'Augmentation of Death', 'Chill Bones', 'Conglaciation of Bone', 'Levant', 'Infusion', 'Skin of the Shadow');

UPDATE spells_new SET classes11=56 WHERE classes11 < 61 AND name IN ( 'Servant of Bones', 'Cessation of Cor', 'Trepidation', 'Sedulous Subversion');

UPDATE spells_new SET classes11=57 WHERE classes11 < 61 AND name IN ( 'Vexing Mordinia', 'Exile Undead', 'Conjure Corpse');

UPDATE spells_new SET classes11=58 WHERE classes11 < 61 AND name IN ( 'Pyrocruor', 'Quivering Veil of Xarn', 'Immobilize');

UPDATE spells_new SET classes11=59 WHERE classes11 < 61 AND name IN ( 'Emissary of Thule', 'Touch of Night', 'Devouring Darkness');

UPDATE spells_new SET classes11=60 WHERE classes11 < 61 AND name IN ( 'Trucidation', 'Banishment of Shadows', 'Demi Lich', 'Arch Lich', 'Enslave Death');

UPDATE spells_new SET classes12=1 WHERE classes12 < 61 AND name IN ( 'Frost Bolt', 'Minor Shielding', 'Numbing Cold', 'Shock of Frost', 'Sphere of Light');

UPDATE spells_new SET classes12=4 WHERE classes12 < 61 AND name IN ( 'Fade', 'Gate', 'Glimpse', 'Icestrike', 'O`Keils Radiation', 'Root', 'See Invisible', 'Shock of Fire');

UPDATE spells_new SET classes12=8 WHERE classes12 < 61 AND name IN ( 'Column of Frost', 'Eye of Zomm', 'Fingers of Fire', 'Fire Bolt', 'Lesser Shielding', 'Sense Summoned', 'Shadow Step', 'Shock of Ice', 'True North');

UPDATE spells_new SET classes12=12 WHERE classes12 < 61 AND name IN ( 'Bind Affinity', 'Cancel Magic', 'Firestorm', 'Frost Spiral of Al''Kabor', 'Gaze', 'Halo of Light', 'Resistant Skin', 'Shock of Lightning');

UPDATE spells_new SET classes12=16 WHERE classes12 < 61 AND name IN ( 'Bind Sight', 'Flame Shock', 'Heat Sight', 'Identify', 'Invisibility', 'Lightning Bolt', 'Pillar of Fire', 'Project Lightning', 'Shielding', 'Shieldskin');

UPDATE spells_new SET classes12=20 WHERE classes12 < 61 AND name IN ( 'Elemental Shield', 'Instill', 'Fay Gate', 'Fire Spiral of Al''Kabor', 'Force Shock', 'North Gate', 'Sight', 'Tishan''s Clash', 'Tox Gate');

UPDATE spells_new SET classes12=24 WHERE classes12 < 61 AND name IN ( 'Cast Force', 'Cazic Gate', 'Column of Lightning', 'Combine Gate', 'Common Gate', 'Frost Shock', 'Leatherskin', 'Levitate', 'Lightning Storm', 'Major Shielding', 'Nek Gate', 'Ro Gate', 'West Gate');

UPDATE spells_new SET classes12=29 WHERE classes12 < 61 AND name IN ( 'Bonds of Force', 'Energy Storm', 'Evacuate: North', 'Fay Portal', 'Imbue Fire Opal', 'Inferno Shock', 'Magnify', 'North Portal', 'Shock Spiral of Al''Kabor', 'Thunder Strike', 'Tox Portal', 'Yonder');

UPDATE spells_new SET classes12=34 WHERE classes12 < 61 AND name IN ( 'Cazic Portal', 'Circle of Force', 'Combine Portal', 'Evacuate: Fay', 'Great Divide Gate (Not on P99)', 'Greater Shielding', 'Harvest', 'Ice Shock', 'Iceclad Gate', 'Iceclad Portal', 'Lava Storm', 'Nek Portal', 'Nullify Magic', 'O`Keils Flickering Flame', 'Steelskin', 'Thunderclap');

UPDATE spells_new SET classes12=39 WHERE classes12 < 61 AND name IN ( 'Chill Sight', 'Cobalt Scar Gate (not on P99)', 'Common Portal', 'Concussion', 'Evacuate: Ro', 'Force Spiral of Al''Kabor', 'Great Divide Portal', 'Immobilize', 'Invisibility to Undead', 'Lightning Shock', 'Markar''s Relocation', 'Ro Portal', 'Shifting Sight', 'Tishan''s Relocation', 'Translocate: Combine', 'Translocate: Fay', 'Translocate: North', 'Translocate: Tox', 'Wakening Lands Gate', 'West Portal');

UPDATE spells_new SET classes12=44 WHERE classes12 < 61 AND name IN ( 'Arch Shielding', 'Cobalt Scar Portal', 'Conflagration', 'Diamondskin', 'Elemental Armor', 'Enticement of Flame', 'Evacuate: Nek', 'Force Strike', 'Frost Storm', 'Gravity Flux', 'Translocate: Cazic', 'Translocate: Common', 'Translocate: West', 'Translocate: Nek', 'Translocate: Ro', 'Wakening Lands Portal');

UPDATE spells_new SET classes12=46 WHERE classes12 < 61 AND name IN ( 'Alter Plane: Hate', 'Alter Plane: Sky');

UPDATE spells_new SET classes12=49 WHERE classes12 < 61 AND name IN ( 'Evacuate: West', 'Ice Comet', 'Markar''s Clash', 'Paralyzing Earth', 'Rend', 'Supernova', 'Translocate: Cobalt Scar', 'Translocate: Great Divide', 'Translocate: Iceclad', 'Translocate: Wakening Lands', 'Wrath of Al''Kabor');

UPDATE spells_new SET classes12=50 WHERE classes12 < 61 AND name IN ( 'Translocate');

UPDATE spells_new SET classes12=51 WHERE classes12 < 61 AND name IN ( 'Atol''s Spectral Shackles', 'Draught of Fire', 'Pillar of Frost', 'Tishan''s Discord');

UPDATE spells_new SET classes12=52 WHERE classes12 < 61 AND name IN ( 'Abscond', 'Lure of Frost', 'Manaskin', 'Tears of Druzzil', 'Translocate: Group');

UPDATE spells_new SET classes12=53 WHERE classes12 < 61 AND name IN ( 'Annul Magic', 'Inferno of Al''Kabor', 'Jyll''s Static Pulse');

UPDATE spells_new SET classes12=54 WHERE classes12 < 61 AND name IN ( 'Pillar of Lightning', 'Shield of the Magi', 'Thunderbold', 'Voltaic Draught');

UPDATE spells_new SET classes12=55 WHERE classes12 < 61 AND name IN ( 'Draught of Jiva', 'Improved Invisibility', 'Lure of Flame', 'Plainsight', 'Tears of Solusek');

UPDATE spells_new SET classes12=56 WHERE classes12 < 61 AND name IN ( 'Jyll''s Zephyr of Ice', 'Markar''s Discord', 'Retribution of Al''Kabor');

UPDATE spells_new SET classes12=57 WHERE classes12 < 61 AND name IN ( 'Draught of Ice', 'Evacuate', 'Eye of Tallon', 'Pillar of Flame');

UPDATE spells_new SET classes12=58 WHERE classes12 < 61 AND name IN ( 'Fetter', 'Lure of Lightning', 'Manasink', 'Tears of Prexus');

UPDATE spells_new SET classes12=59 WHERE classes12 < 61 AND name IN ( 'Flaming Sword of Xuzl', 'Invert Gravity', 'Jyll''s Wave of Heat', 'Vengeance of Al''Kabor');

UPDATE spells_new SET classes12=60 WHERE classes12 < 61 AND name IN ( 'Disintegrate', 'Hsagra''s Wrath', 'Ice Spear of Solist', 'Lure of Ice', 'Porlos'' Fury', 'Sunstrike', 'Winds of Gelid');

UPDATE spells_new SET classes13=1 WHERE classes13 < 61 AND name IN ( 'Burst of Flame', 'Flare', 'Minor Shielding', 'Reclaim Energy', 'Summon Dagger', 'Summon Drink', 'Summon Food', 'True North');

UPDATE spells_new SET classes13=4 WHERE classes13 < 61 AND name IN ( 'Burn', 'Elementalkin: Air', 'Elementalkin: Earth', 'Elementalkin: Fire', 'Elementalkin: Water', 'Fire Flux', 'Gate', 'Sense Summoned', 'Summon Bandages', 'Summon Wisp');

UPDATE spells_new SET classes13=8 WHERE classes13 < 61 AND name IN ( 'Dimensional Pocket', 'Elementaling: Air', 'Elementaling: Earth', 'Elementaling: Fire', 'Elementaling: Water', 'Eye of Zomm', 'Flame Bolt', 'Invisibility', 'Lesser Shielding', 'Renew Elements', 'Shield of Fire', 'Shock of Blades', 'Staff of Tracing');

UPDATE spells_new SET classes13=12 WHERE classes13 < 61 AND name IN ( 'Bind Affinity', 'Burnout', 'Cancel Magic', 'Column of Fire', 'Elemental: Air', 'Elemental: Earth', 'Elemental: Fire', 'Elemental: Water', 'Rain of Blades', 'Summon Fang', 'Ward Summoned');

UPDATE spells_new SET classes13=16 WHERE classes13 < 61 AND name IN ( 'Identify', 'Minor Summoning: Air', 'Minor Summoning: Earth', 'Minor Summoning: Fire', 'Minor Summoning: Water', 'Phantom Leather', 'See Invisible', 'Shielding', 'Shock of Flame', 'Staff of Warding', 'Summon Heatstone', 'Summon Throwing Dagger');

UPDATE spells_new SET classes13=20 WHERE classes13 < 61 AND name IN ( 'Bolt of Flame', 'Elemental Shield', 'Expulse Summoned', 'Lesser Summoning: Air', 'Lesser Summoning: Earth', 'Lesser Summoning: Fire', 'Lesser Summoning: Water', 'Rain of Fire', 'Renew Summoning', 'Shield of Flame', 'Spear of Warding', 'Summon Arrows', 'Summon Waterstone');

UPDATE spells_new SET classes13=24 WHERE classes13 < 61 AND name IN ( 'Cornucopia', 'Everfount', 'Flame Flux', 'Major Shielding', 'Malaise', 'Shock of Spikes', 'Staff of Runes', 'Summoning: Air', 'Summoning: Earth', 'Summoning: Fire', 'Summoning: Water');

UPDATE spells_new SET classes13=29 WHERE classes13 < 61 AND name IN ( 'Burnout II', 'Dismiss Summoned', 'Expedience', 'Greater Summoning: Air', 'Greater Summoning: Earth', 'Greater Summoning: Fire', 'Greater Summoning: Water', 'Inferno Shield', 'Phantom Chain', 'Rain of Spikes', 'Summon Coldstone', 'Sword of Runes');

UPDATE spells_new SET classes13=34 WHERE classes13 < 61 AND name IN ( 'Blaze', 'Cinder Bolt', 'Dimensional Hole', 'Greater Shielding', 'Minor Conjuration: Air', 'Minor Conjuration: Earth', 'Minor Conjuration: Fire', 'Minor Conjuration: Water', 'Monster Summoning I', 'Nullify Magic', 'Staff of Symbols', 'Summon Shard of the Core');

UPDATE spells_new SET classes13=39 WHERE classes13 < 61 AND name IN ( 'Barrier of Combustion', 'Dagger of Symbols', 'Expel Summoned', 'Flame Arc', 'Lesser Conjuration: Air', 'Lesser Conjuration: Earth', 'Lesser Conjuration: Fire', 'Lesser Conjuration: Water', 'Rain of Lava', 'Summon Companion', 'Summon Ring of Flight');

UPDATE spells_new SET classes13=44 WHERE classes13 < 61 AND name IN ( 'Arch Shielding', 'Conjuration: Air', 'Conjuration: Earth', 'Conjuration: Fire', 'Conjuration: Water', 'Elemental Armor', 'Elemental Maelstrom', 'Malaisement', 'Modulating Rod', 'Phantom Plate', 'Shock of Swords');

UPDATE spells_new SET classes13=46 WHERE classes13 < 61 AND name IN ( 'Summon Orb');

UPDATE spells_new SET classes13=49 WHERE classes13 < 61 AND name IN ( 'Banish Summoned', 'Burnout III', 'Greater Conjuration: Air', 'Greater Conjuration: Earth', 'Greater Conjuration: Fire', 'Greater Conjuration: Water', 'Lava Bolt', 'Rain of Swords', 'Shield of Lava');

UPDATE spells_new SET classes13=50 WHERE classes13 < 61 AND name IN ( 'Monster Summoning II');

UPDATE spells_new SET classes13=51 WHERE classes13 < 61 AND name IN ( 'Gift of Xev', 'Malosi', 'Scintillation', 'Vocarate: Earth');

UPDATE spells_new SET classes13=52 WHERE classes13 < 61 AND name IN ( 'Bristlebane''s Bundle', 'Char', 'Phantom Armor', 'Vocarate: Fire');

UPDATE spells_new SET classes13=53 WHERE classes13 < 61 AND name IN ( 'Annul Magic', 'Boon of Immolation', 'Quiver of Marr', 'Vocarate: Air');

UPDATE spells_new SET classes13=54 WHERE classes13 < 61 AND name IN ( 'Bandoleer of Luclin', 'Scars of Sigil', 'Shield of the Magi', 'Vocarate: Water');

UPDATE spells_new SET classes13=55 WHERE classes13 < 61 AND name IN ( 'Burnout IV', 'Call of the Hero', 'Pouch of Quellious', 'Rage of Zomm', 'Sirocco', 'Wrath of the Elements');

UPDATE spells_new SET classes13=56 WHERE classes13 < 61 AND name IN ( 'Cadeau of Flame', 'Dyzil''s Deafening Decoy', 'Exile Summoned', 'Muzzle of Mardu');

UPDATE spells_new SET classes13=57 WHERE classes13 < 61 AND name IN ( 'Eye of Tallon', 'Greater Vocaration: Earth', 'Shock of Steel');

UPDATE spells_new SET classes13=58 WHERE classes13 < 61 AND name IN ( 'Greater Vocaration: Fire', 'Malosini', 'Velocity');

UPDATE spells_new SET classes13=59 WHERE classes13 < 61 AND name IN ( 'Greater Vocaration: Air', 'Manastorm', 'Seeking Flame of Seukor', 'Valiant Companion');

UPDATE spells_new SET classes13=60 WHERE classes13 < 61 AND name IN ( 'Aegis of Ro', 'Banishment', 'Greater Vocaration: Water', 'Mala', 'Monster Summoning III');

UPDATE spells_new SET classes14=1 WHERE classes14 < 61 AND name IN ( 'Lull', 'Minor Illusion', 'Minor Shielding', 'Pendril''s Animation', 'Reclaim Energy', 'Shallow Breath', 'Strengthen', 'Taper Enchantment', 'True North', 'Weaken');

UPDATE spells_new SET classes14=4 WHERE classes14 < 61 AND name IN ( 'Color Flux', 'Enfeeblement', 'Fear', 'Gate', 'Haze', 'Illusion: Half-Elf', 'Illusion: Human', 'Invisibility', 'Juli''s Animation', 'Mesmerize', 'Suffocating Sphere', 'Tashan');

UPDATE spells_new SET classes14=8 WHERE classes14 < 61 AND name IN ( 'Alliance', 'Bind Sight', 'Cancel Magic', 'Chaotic Feedback', 'Enchant Clay', 'Enchant Silver', 'Eye of Confusion', 'Illusion: Gnome', 'Illusion: Wood Elf', 'Lesser Shielding', 'Mircyl''s Animation', 'Root', 'See Invisible', 'Sentinel', 'Soothe');

UPDATE spells_new SET classes14=12 WHERE classes14 < 61 AND name IN ( 'Bind Affinity', 'Charm', 'Choke', 'Ebbing Strength', 'Enduring Breath', 'Illusion: Dark Elf', 'Illusion: Erudite', 'Illusion: Halfling', 'Illusion: High Elf', 'Kilan''s Animation', 'Languid Pace', 'Memory Blur', 'Mist', 'Serpent Sight', 'Thicken Mana', 'Whirl Till You Hurl');

UPDATE spells_new SET classes14=16 WHERE classes14 < 61 AND name IN ( 'Breeze', 'The Overthere.', 'Chase the Moon', 'Disempower', 'Enchant Electrum', 'Enthrall', 'Identify', 'Illusion: Barbarian', 'Illusion: Dwarf', 'Illusion: Tree', 'Invisibility versus Undead', 'Levitate', 'Mesmerization', 'Quickness', 'Rune I', 'Sanity Warp', 'Shalee''s Animation', 'Shielding');

UPDATE spells_new SET classes14=20 WHERE classes14 < 61 AND name IN ( 'Benevolence', 'Berserker Strength', 'Calm', 'Cloud', 'Color Shift', 'Crystallize Mana', 'Endure Magic', 'Feckless Might', 'Illusion: Iksar', 'Illusion: Ogre', 'Illusion: Troll', 'Shifting Sight', 'Sisna''s Animation', 'Sympathetic Aura', 'Tashani');

UPDATE spells_new SET classes14=24 WHERE classes14 < 61 AND name IN ( 'Alacrity', 'Beguile', 'Chaos Flux', 'Enchant Gold', 'Illusion: Earth Elemental', 'Illusion: Skeleton', 'Invigor', 'Major Shielding', 'Rune II', 'Sagar''s Animation', 'Strip Enchantment', 'Tepid Deeds');

UPDATE spells_new SET classes14=29 WHERE classes14 < 61 AND name IN ( 'Augmentation', 'Clarify Mana', 'Clarity', 'Curse of the Simple Mind', 'Dyn''s Dizzying Draught', 'Instill', 'Feedback', 'Illusion: Air Elemental', 'Illusion: Water Elemental', 'Listless Power', 'Nullify Magic', 'Obscure', 'Suffocate', 'Uleen''s Animation', 'Ultravision');

UPDATE spells_new SET classes14=34 WHERE classes14 < 61 AND name IN ( 'Anarchy', 'Boltran''s Animation', 'Cast Sight', 'Enchant Platinum', 'Entrance', 'Gift of Magic', 'Thurgadin.', 'Greater Shielding', 'Illusion: Fire Elemental', 'Insipid Weakness', 'Mana Sieve', 'Radiant Visage', 'Rune III');

UPDATE spells_new SET classes14=39 WHERE classes14 < 61 AND name IN ( 'Aanya''s Animation', 'Cajoling Whispers', 'Celerity', 'Distill Mana', 'Gravity Flux', 'Illusion: Dry Bone', 'Illusion: Spirit Wolf', 'Immobilize', 'Insight', 'Invoke Fear', 'Mind Wipe', 'Pacify', 'Rampage', 'Resist Magic', 'Shade', 'Wandering Mind');

UPDATE spells_new SET classes14=44 WHERE classes14 < 61 AND name IN ( 'Arch Shielding', 'Boon of the Garou', 'Brilliance', 'Color Skew', 'Discordant Mind', 'Enchant Velium', 'Extinguish Fatigue', 'Illusion: Werewolf', 'Incapacitate', 'Pillage Enchantment', 'Rune IV', 'Shiftless Deeds', 'Summon Companion', 'Tashania', 'Weakness', 'Yegoreff''s Animation');

UPDATE spells_new SET classes14=49 WHERE classes14 < 61 AND name IN ( 'Adorning Grace', 'Allure', 'Berserker Spirit', 'Blanket of Forgetfulness', 'Dazzle', 'Enchant Adamantite', 'Enchant Brellium', 'Enchant Mithril', 'Enchant Steel', 'Gasping Embrace', 'Group Resist Magic', 'Kintaz''s Animation', 'Paralyzing Earth', 'Purify Mana', 'Reoccurring Amnesia', 'Shadow', 'Swift Like The Wind');

UPDATE spells_new SET classes14=50 WHERE classes14 < 61 AND name IN ( 'Improved Invisibility');

UPDATE spells_new SET classes14=51 WHERE classes14 < 61 AND name IN ( 'Collaboration', 'Theft of Thought', 'Wake of Tranquility');

UPDATE spells_new SET classes14=52 WHERE classes14 < 61 AND name IN ( 'Boon of the Clear Mind', 'Color Slant', 'Fascination', 'Rune V');

UPDATE spells_new SET classes14=53 WHERE classes14 < 61 AND name IN ( 'Aanya''s Quickening', 'Boltran''s Agacerie', 'Cripple', 'Recant Magic');

UPDATE spells_new SET classes14=54 WHERE classes14 < 61 AND name IN ( 'Clarity II', 'Dementia', 'Glamour of Kintaz', 'Shield of the Magi');

UPDATE spells_new SET classes14=55 WHERE classes14 < 61 AND name IN ( 'Gift of Insight', 'Largarn''s Lamentation', 'Memory Flux', 'Wind of Tishani', 'Zumaik''s Animation');

UPDATE spells_new SET classes14=56 WHERE classes14 < 61 AND name IN ( 'Augment', 'Overwhelming Splendor', 'Torment of Argli', 'Trepidation');

UPDATE spells_new SET classes14=57 WHERE classes14 < 61 AND name IN ( 'Enlightenment', 'Forlorn Deeds', 'Tashanian', 'Umbra');

UPDATE spells_new SET classes14=58 WHERE classes14 < 61 AND name IN ( 'Bedlam', 'Fetter', 'Wonderous Rapidity');

UPDATE spells_new SET classes14=59 WHERE classes14 < 61 AND name IN ( 'Asphyxiate', 'Gift of Pure Thought', 'Rapture');

UPDATE spells_new SET classes14=60 WHERE classes14 < 61 AND name IN ( 'Dictate', 'Gift of Brilliance', 'Visions of Grandeur', 'Wind of Tishanian');

xackery commented 5 years ago

Very nice