Where are focus effects?

[Movement]

I have some Defiant Armor in my database. The armor is fine but focus effects are showing "unknown spell". I want to fix this, any way to find out where the item is making the call to "focus effects" in the DB?

[Movement]

Disregard. The Defiant piece in question has a focus effect of "-1". Which means not implemented or not available. I will have to manually add it into the database. To answer my own question, "Focus Effects" are actually "spell effects" which are bonuses that happen when certain criteria on items are met.

[Movement]

Update: I figured it out. There is FocusEffect and BardEffect. The effect for Percussion Resonance III was not in my spells.txt file. After importing this entry under "spell=21215" in spells_new to my spells_us.txt and reloading, it actually showed up. I am posting this information so that other may be able to learn from it.

I should add that I had to manually add the spell into the database because the item focus effect makes a call to the DB under the spells table for the BardFocusEffect. Once I imported the spell data from spellsnew to spells_us and made the effect in the spells table and relogged/hotfixed, the item showed the focus effect properly. Now I just have to test it with a bard >_< lol