[AndMetal]

Originally Posted by circuitdragon

Seems if an item shows "Unknown Spell Effect" or how ever it shows, this is a bad thing. The items themselves when equiped have no ill effect, until you cast a spell.

The reason this is happening is because the items are trying to use a spell that isn't in the spells_us.txt file (usually items that are post-Titanium that are in the DB). The Titanium spells_us.txt file goes up to Spell ID 8446.

Unless you update the spells_us.txt file on both the server & client sides to a more recent version (the latest live version has 15,999 spells, but also has more fields that the current version of the client & server don't support), you will experience this issue. For stability issues, it might be worth it to restrict items that use spells that aren't in your spells file:

UPDATE items SET minstatus = 100 WHERE proceffect > 8446 OR clickeffect > 8446 OR focuseffect > 8446 OR worneffect > 8446 OR scrolleffect > 8446

That would restrict the item to only being summoned by accounts that have a status of 100 or higher (usually GMs).

Alternatively, you could change items that have those higher Spell IDs to remove the spell:

UPDATE items SET proceffect = '-1' WHERE proceffect > 8446
UPDATE items SET clickeffect = '-1' WHERE clickeffect > 8446
UPDATE items SET focuseffect = '-1' WHERE focuseffect > 8446
UPDATE items SET worneffect = '-1' WHERE worneffect > 8446
UPDATE items SET scrolleffect = '-1' WHERE scrolleffect > 8446

That would still allow users to have access to the items, but not crash the server. The only downside is that, if you update your DB frequently to CVS, you'll have to add in the change every time you source it. It might be a good idea to add that into a .sql script if you do update your database regularly (to incorporate any needed changes).

Originally Posted by circuitdragon

Seems a lot of the higher ends items have the same effect on them...which is causing me problems. The effect is "Zuriki's Song of Shenanigans" #5375....just a little more FYI...

What items are you seeing this on? I did a search of my DB (which is current to PEQ CVS as of about a week or so ago) and this is all I got:

Output from SQL command SELECT id, Name, proceffect, clickeffect, focuseffect, worneffect, scrolleffect FROM items WHERE proceffect = 5375 OR clickeffect = 5375 OR focuseffect = 5375 OR worneffect = 5375 OR scrolleffect = 5375 ORDER BY id LIMIT 100; ..
id	Name					proceffect	clickeffect	focuseffect	worneffect	scrolleffect 
77116	Spell: Zuriki's Song of Shenanigans	-1		-1		-1		-1		5375

This is just the scroll that allows bards to scribe the spell. Then again, the first part of the post should address the root of the issue, this might just indicate a secondary problem in your copy of the database.