Spells not showing on Items

[Nagus69]

Quick question - im using EQEmu with PEQ and EQItems from George. Sometimes, i select a spell for an item (clickable) from the drop down and they don't show up in game.

Any ideas where to look for a fix? Shouldn't all spells that appear in the drop down be available or are there different sources (almost sounds like it) for the game to parse spell data.

[trevius]

Make sure you are setting the maxcharges and clicktype fields properly when adding click effects. If you click the little question mark on the new editor window near the click stuff, it explains each field a bit and even has a button that will set them to a default clicky setting that you can then adjust if needed.

[Nagus69]

Ok - i forgot that back in the early days (3 months ago ;)) however that's not the issue.

It seems the server is using a different set of spell file than the editor does.

[Nagus69]

I think i found the error - there is a file in the EQItems directory called

spells_new.zip which containts spells_new.sql.

This sql file seems to upload the entire spellfile into the SQL Database. That differs from the file that the server uses. Also, not sure how i can make custom spells if the server is using the sql files.

Someone enlighten me please.

[trevius]

I was under the impression that GeorgeS' item editor now queries your actual spells_new table running in your database, so it should always match up. Maybe you are running an older version of the tool from before this functionality was added,

[Lillu]

The spells_new table of this server has 10K spell IDs, the spells table has 8402 spellid.. thats not up to date, right? how can we update it? I'm a tad confused with all the spell files/sources/tables and all..

[Nagus69]

seems we also need to manually add the custom spells that we created to said sql table then?

[Pallos]

Im having the same issue when creating clickies. I created the spell and its in the database, I can #cast the spell and I when i put it on a clickie in the item Editor it shows it there. But if i go into the DB the clickeffect is listed as -1. The item in game had no spell on it, it had the focus effect but not the click.

So I edited the DB and put the spell number in, now it works But only with the SOF client, the effect doesnt show up on the titanium client at all. Any Ideas on this? I used the manastone as a file to copy and as far as I know is a functional click item.

[GeorgeS]

I'll look into the issue of the clickie vs. focus effect. -- I'll make a manastone with a new clickie and report back.



Now with making new spells, I'm assuming SOF has a higher spell_id limit therefore spells that work for it may fail in Ti. Just a guess.

GeorgeS


Im having the same issue when creating clickies. I created the spell and its in the database, I can #cast the spell and I when i put it on a clickie in the item Editor it shows it there. But if i go into the DB the clickeffect is listed as -1. The item in game had no spell on it, it had the focus effect but not the click.

So I edited the DB and put the spell number in, now it works But only with the SOF client, the effect doesnt show up on the titanium client at all. Any Ideas on this? I used the manastone as a file to copy and as far as I know is a functional click item.

[Pallos]

Well to Clarify a little George, The item has both a clickie spell and a focus effect. The focus effect is being saved by the new editor but the click effect is not being saved correctly. If I use the grid or the old Editor I can get the clickie on the item Either through the spell list on the old editor or directly modifying the field on the grid editor.

But again after going through this, the spell still is not visible in ttanium when it is in SOF, if this is a issue about the Max number of spells available in Titanium, is there a work around on this?

The Spell is new and it is ID 15929 but even so, since this is a server side effect and not a actual spell casting shouldnt the click work anyway and say unknown spell? I can #cast this spell from Titanium and can #findspell and its there and fine in titanium.

here is the spell info if you need it

15929^Black Avatar^PLAYER_1^Deathavatar^^^An avatar of the black planes arrives to do your bidding.^ cracks a evil grin as an avatar of death is called into being.^^0^^0^0^16000^2250^2250^0^0^0^0^1^0^0^0^0^0 ^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0 ^0^0^0^0^0^2512^2106^-1^-1^-1^-1^1^1^1^1^28144^20508^-1^-1^100^100^100^100^100^100^100^100^100^100^100^100^ 0^1^0^4^71^254^254^254^254^254^254^254^254^254^254 ^254^6^0^14^-1^0^0^255^255^255^255^255^255^255^255^255^255^255^ 255^255^255^255^255^43^0^0^4^0^0^0^0^0^0^0^0^0^0^0 ^0^0^0^0^0^0^0^0^0^91^151^0^0^0^0^0^0^0^0^0^5438^6 9^103^^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^5 1^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^1^0^0

[Nagus69]

I have the same problem with just the Titanium Client.

Orignial Titanium had about 8400 spells. With customs etc i am now at 8550ish spells. When i browse with NewEdit, i can select the Spells/Focii etc in the drop down list and click save. When i return to the main menu, the spells are not listed.

If i click OldEdit, i can manually enter the spell/focii/worn etc ID and it is actually saved permanently. If i go then back with NewEdit, a spell is still listed there but it's a totally different one. I assume it has something to do with the fact, that even tho we use spell_new table, the EQItems client still has it's own table somewhere since i can select up to spell ID 10000 when i know that i only have 8550.

Just wanted to say, thanks alot for not only creating this tool but also for keeping this up to date!

[GeorgeS]

*edit* I think I figured this out -- I'll have this fixed in a few hours tonight


George

[GeorgeS]

Thanks for your patience. I think it's sorted out now.


Everquest Item Editor and Character Inventory Editor
- 14.4.17 - Found a bug when adding spell effect. The program still referred to the old text file and now it uses the database exclusively!



GeorgeS

[Nagus69]

Thanks a ton! Any chance you can turn the background into simple Windows GUI? Remote Access makes it totally slow :)

[Nagus69]

Just tried this out - it doesn't work.

Frontend showed indeed Version 14.4.17 but it's no different. Spell still go up to ID 10000 and custom spells still don't get saved when using new edit.

[lich2594]

Titanium has a 9999 spell limit, SoF does not.

If you have over the limit you will not see the effects/spells.

[GeorgeS]

That's correct about the spell limit, however.

I added a few lines of code update the spell effects after saving. Spell effects do work as I've checked this over many times. The code for writing focus/clickies/ etc.. is the same, so if it works for one, it will work for all.

Newest version will have the above added now (ver ..18)

GeorgeS

[Nagus69]

I can confirm that custom Effects are now stored again using new edit. We still can select spells up to ID 10000 but i guess that is something on our end.

[Pallos]

Well I overwrote some old test spells and put them down in the 800 range so there would be no issue with titanium. Created the click and everything worked fine in SOF. Everything worked fine in my C:/temp/everquest (titanium) diectory.

This is where is gets wierd

The same Exact copy of the c:/temp/eq directory resides in program files ( this is in vista btw) with the client in that directory the clickie still listed the deleted spell. Not only that but when you clicked it, it not only casted the new spell it casted the deleted spell at the same time. Mind you these two directories are EXACTLY the same. When I moved the client directory out of the program files directory everything worked like it should. It leads me to believe there is some caching issue with Program files or a deal with the oriinal istall registry entries, I havent bothered to look tbh.

(on a side note in the program files directory even though the eqclient.ini had velious armor enabled they did not show till I moved the client out of the program files directory)

So my problem looks to be solved , if you are still seeing the wrong spell in the clickie this might be something to look out for. Provided you have done everything else like updated the spells_us file for your client(s).

[Wesell]

Windows Vista redirects writes to the Program Files folder to a folder in your users folder. It's an attempt to maintain compatibility with apps that expect to be able to write to these directories when the user running them does not have permissions to do so.

If you were saving that ini file with the 64bit version of notepad it would tell you that you didn't have permissions to save the file because 64bit apps are not subject to this redirection and will get to see the error. Basically the feature is confusing and not very helpful, but I guess they thought they would break too many windows 95 apps without it.