a light bulb just came on while preparing to add my Cleric bot nukes back into the 701 spell list. The npc_spells_entries table indexes the id column (in addition to the npc_spells_id and spellid columns). Anyway, my first monification to my cleric's spell list was to remove nukes (spell "type" 1) to force them to save mana. Later, I added in additional heal spells to that list. However, when I did so, I did not define an "id" for the new heals. So, MySQL would have automatically assigned an id to the spell, and as a result it's highly likely that the id that the spell picked up was one of the ids that the nukes use to have.
If the new bot code uses the "id" column to identify spells (instead of spellid), and doesn't check the 'type' column while deciding where or not to cast the spell, this could cause the bot to cast a heal on the target that is being killed, if the npc_spell_entries table has been altered in the way mine has.
Anyway, I'm going to add my nukes back into the cleric spell list, compile the latest source and see if it fixes anything for me.
|