EQEmulator Forums - Unknown Spell Issue

Using the following SQL statement, I decided to give my GM character a Loop of the Clerk using the ROF2 client:

Code:

SET @clientMax = 45000, @slot = 18;



Select i.id, i.name, w.name as worn, f.name as focus, p.name as proc, c.id as click_id, c.name as click

from items i

left join spells_new w on w.id = i.worneffect

left join spells_new f on f.id = i.focuseffect

left join spells_new p on p.id = i.proceffect

left join spells_new c on c.id = i.clickeffect

where (i.worneffect = -1 or (i.worneffect < @clientMax and w.name is not null and w.name != ''))

and (i.focuseffect = -1 or (i.focuseffect < @clientMax and f.name is not null and f.name != ''))

and (i.proceffect = -1 or (i.proceffect < @clientMax and p.name is not null and p.name != ''))

and (i.clickeffect = -1 or (i.clickeffect < @clientMax and c.name is not null and c.name != ''))

and i.slots = @slot

order by aint desc;

clientMax is set to 45000 because I read that was the ROF max spell Id.

The database indicates that the worn effect for the Loop is Sharpshooting IX, the focus effect is Detrimental Duration 35 L95, there is no proc effect, and the click effect is Geomantra X.

When I view the item in-game, it indicates the focus effect is called Tenacity of Kolos, the Click Effect is Unknown Spell, and the Worn Effect is Unknown Spell.

When I use the item, it pulls the correct spell duration and effect, but the spell icon is for Unknown Spell and the spell text is "You feel bogus as an unknown spell accosts you.", otherwise, the spell behaves as intended.

My initial assumption is that the ROF2 client would pull the icon id, spell name, and spell texts from the database based on a spell id, and would pull the spell icon from the uifiles directory, however, this does not seem to be the case.