NPCs, that don't cast spells #2

[sorvani]

SQL i know, it's the C++ i am learning, but I was just hoping I wouldn't have to type it all out for all the classes if you had done it and saved it already.

The above reads "I was being lazy"

[trevius]

Originally Posted by sorvani

SQL i know, it's the C++ i am learning, but I was just hoping I wouldn't have to type it all out for all the classes if you had done it and saved it already.

The above reads "I was being lazy"

LOL, it would take you the same amount of time or less using the SQL he provided and the class list link I provided as it took you to type that reply :P

[sorvani]

-- 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;

-- 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