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.
Unknown Spell Issue
Linear Mode
