Updated Tool - EqItems Item Editor

[trevius]

In regard to spells; it might be a good idea to change the tools to just pull the spells directly from the spells_new table now. Since the table is there and comes standard with the PEQ database now, there is no reason not to use it. The bonus to this would be that people who use it and who have customized spells, would see all of the spell IDs and Names accurately exactly as they have them set in the table. Everytime I edit or move spells around, I have to play around with Textpad and Excel to make a new spells.txt file for the editors to use so they will match my custom spells table. Would be nice to be able to cut out that extra step at some point

[GeorgeS]

Thanks for the report. I'll fix those issues.

The newest item editor uses the db spell table.

The other tools will shortly..

GeorgeS

[trevius]

Oh, sweet! I didn't know that

I was wondering if you get a chance, would you be able to put a little search window next to the load character button on the item editor main window? Then, just have it run a query for that one character instead of having to load the whole table? It is usable the way that it is now, but it takes a good 30 seconds or so to load my whole char table atm. Probably something people wouldn't notice until that table gets up fairly high. Not a big deal, but just something to consider if you get some time.

[GeorgeS]

Everquest Item Editor and Character Inventory Editor
- 14.4.6 - Sped up loading of spells and toons 100x. Added toon query where large populations of toons exist. Many requested minor features added


I did look at adding as many suggestions as requested. Some things like extra line spaces in item descrition is not repairable without a total rewrite. I did add attuneable to the list. Fixed a few views and added listboxes where possible in the profile editor. These features and fixes are worth 8 hours of my time, so I did spend one day one these.
Fixed the spell adding/removing in the old edit tool. Now to remove a spell, just click on remove.

GeorgeS

[ChaosSlayerZ]

ah George I am sorry to tell you this, but the Old Edit section has stoped working....

I have tried changing something simple on the item like AC, HP, no drop tag- changes do not take effect.

[GeorgeS]

Yup, there was a sql bug

Everquest Item Editor and Character Inventory Editor
- 14.4.7 - Fixed up SQL for old edit

Thanks
GeorgeS

[Nagus69]

maybe this has already been posted - but i notice that while the spell laoding screen is super fast now, its missing about 3k spells (only going to 8500ish now instead of almost 12000).

Any idea how to fix this?

[ChaosSlayerZ]

I will take a guess and say - check your DB spell table and see how many spells are in there.

[zergling]

Also, I think I recall that it only loads sequential spell IDs. If any spell ID is missing in the sequence (say spell 8501 in your case) it would stop loading any more.

I haven't been at this for too long, so I might be wrong, but its pretty quick to check so it can't hurt.

[Nagus69]

well i log in remotely over the good old internet to the items database, so no clue but will ask

[GeorgeS]

If you run this

select count(id) from spells_new;

I get 14,257 spells loaded. The PEQ database holds exatcly this many spells de-nuovo. I no longer use the spells text file, just Cavedude's PEQ datafile.
You would need to DL the database, and just load in the spells. I have a copy of the database on my site.

..also gaps in the id sequence has no bearing on this. It loads everything in.
GeorgeS

[Lillu]

how can I source only the spell portion of the peq db? or could anyone please link me a source where I can get the up to date spell only sql file?

[pfyon]

My PEQ db didn't come with spells (unless I missed an sql file). I had to take the one from my SoF install and import it using the perl import_spells script.

[cavedude]

Originally Posted by pfyon

My PEQ db didn't come with spells (unless I missed an sql file). I had to take the one from my SoF install and import it using the perl import_spells script.

spells_new is included in the .gz file on SVN...

[Nagus69]

Odd request but here goes

I usually work remotely with EQItems and the background of your wonderful tool is a real graphic it seems. Means it is transfered over the slow internet connection.

Do you think it is possible to release a version without a background graphic, just a usual 'windows' looking app?