|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Development::GeorgeS's Tools A forum just for GeorgeS's tools |
08-19-2009, 05:43 AM
|
Sarnak
|
|
Join Date: Jul 2003
Posts: 68
|
|
Spells not showing on Items
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.
|
08-19-2009, 09:25 PM
|
|
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
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.
|
08-20-2009, 04:41 AM
|
Sarnak
|
|
Join Date: Jul 2003
Posts: 68
|
|
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.
|
08-20-2009, 04:52 AM
|
Sarnak
|
|
Join Date: Jul 2003
Posts: 68
|
|
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.
|
08-20-2009, 06:34 PM
|
|
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
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,
|
08-20-2009, 07:16 PM
|
Hill Giant
|
|
Join Date: Sep 2008
Posts: 204
|
|
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..
__________________
|
08-21-2009, 02:03 AM
|
Sarnak
|
|
Join Date: Jul 2003
Posts: 68
|
|
seems we also need to manually add the custom spells that we created to said sql table then?
|
09-22-2009, 05:04 PM
|
Fire Beetle
|
|
Join Date: Jun 2009
Location: Seattle
Posts: 13
|
|
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.
|
09-22-2009, 09:58 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,474
|
|
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.
|
|
|
|
|
|
|
|
09-23-2009, 12:07 AM
|
Fire Beetle
|
|
Join Date: Jun 2009
Location: Seattle
Posts: 13
|
|
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
|
|
|
|
09-23-2009, 04:39 AM
|
Sarnak
|
|
Join Date: Jul 2003
Posts: 68
|
|
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!
|
09-23-2009, 10:48 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,474
|
|
*edit* I think I figured this out -- I'll have this fixed in a few hours tonight
George
Last edited by GeorgeS; 09-23-2009 at 11:12 PM..
|
09-23-2009, 11:47 PM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,474
|
|
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
|
09-24-2009, 09:07 AM
|
Sarnak
|
|
Join Date: Jul 2003
Posts: 68
|
|
Thanks a ton! Any chance you can turn the background into simple Windows GUI? Remote Access makes it totally slow
|
09-24-2009, 09:20 AM
|
Sarnak
|
|
Join Date: Jul 2003
Posts: 68
|
|
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.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 09:32 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|