EQEmulator Forums - NPCs, that don't cast spells #2

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