Code:
-- update all NPC Spell casting classes that are missing a default spell id
-- Cleric
update npc_types set npc_spells_id=1 where (class=2 or class=21) and npc_spells_id=0;
-- Paladin
update npc_types set npc_spells_id=8 where (class=3 or class=22) and npc_spells_id=0;
-- Ranger
update npc_types set npc_spells_id=10 where (class=4 or class=23) and npc_spells_id=0;
-- Shadow Knight
update npc_types set npc_spells_id=9 where (class=5 or class=24) and npc_spells_id=0;
-- Druid
update npc_types set npc_spells_id=7 where (class=6 or class=25) and npc_spells_id=0;
-- Bard
update npc_types set npc_spells_id=11 where (class=8 or class=27) and npc_spells_id=0;
-- Shaman
update npc_types set npc_spells_id=6 where (class=10 or class=29) and npc_spells_id=0;
-- Necromancer
update npc_types set npc_spells_id=3 where (class=11 or class=30) and npc_spells_id=0;
-- Wizard
update npc_types set npc_spells_id=2 where (class=12 or class=31) and npc_spells_id=0;
-- Magician
update npc_types set npc_spells_id=4 where (class=13 or class=32) and npc_spells_id=0;
-- Enchanter
update npc_types set npc_spells_id=5 where (class=14 or class=33) and npc_spells_id=0;
-- Beatlord
update npc_types set npc_spells_id=12 where (class=15 or class=34) and npc_spells_id=0;
Code:
-- Cleric Affected rows: 679
-- Paladin Affected rows: 321
-- Ranger Affected rows: 133
-- Shadow Knight Affected rows: 483
-- Druid Affected rows: 361
-- Bard Affected rows: 107
-- Shaman Affected rows: 636
-- Necromancer Affected rows: 416
-- Wizard Affected rows: 585
-- Magician Affected rows: 192
-- Enchanter Affected rows: 256
-- Beatlord Affected rows: 34