Spells not showing on Items

Nagus69 · #1 08-19-2009, 05:43 AM

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** · #2 08-19-2009, 09:25 PM

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 · #3 08-20-2009, 04:41 AM

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 · #4 08-20-2009, 04:52 AM

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** · #5 08-20-2009, 06:34 PM

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 · #6 08-20-2009, 07:16 PM

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 · #7 08-21-2009, 02:03 AM

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

Pallos · #8 09-22-2009, 05:04 PM

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** · #9 09-22-2009, 09:58 PM

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

Quote:

Originally Posted by 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.

Pallos · #10 09-23-2009, 12:07 AM

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 · #11 09-23-2009, 04:39 AM

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** · #12 09-23-2009, 10:48 PM

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

George

**GeorgeS** · #13 09-23-2009, 11:47 PM

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 · #14 09-24-2009, 09:07 AM

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

Nagus69 · #15 09-24-2009, 09:20 AM

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.