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 :)

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

The newest item editor uses the db spell table. :)

The other tools will shortly..

GeorgeS

Oh, sweet! I didn't know that :D

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.

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

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. :confused:

Yup, there was a sql bug

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

Thanks
GeorgeS

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?

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

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.

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

If you run this
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

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?

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...

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?

To clear it up: I use this tool over RDC (no admin rights on this PC but RDC is open, hence this odd request)

I was wondering if it where possible to make a version of your great item editor for us people who use 1024X768 resoultion ...the sides of the program get cut off and make it impossible to close the program except by using the task manager ..thanks for listening to my suggestion

Grindle

I'm afraid any changes at this point is not easily doable. I get requests like this at times. The tool uses screen pixel references, so changing bitmaps or sizes is very hard and would likely break functionality in many ways.

The other question regarding removing bitmaps -since the tool is gui driven, the only way is to reduce the bitmaps to 16 color images - something I won't do.

Sorry, but my time is limited.


GeorgeS

Can someone shoot me the latest of Georges item editor? His source has been down

did you use the link in his signature?
You may have to use IE to see the link to download it?

im getting the mysql database connection error, i installed the odbc and fixed the db.ini for my db but it still wont connect. any idea where im going wrong.

also my db.ini is the following:

host=localhost
user=eq
password=*****
database=peq
everquest_folder=C:\Everquest

Download this tool
http://www.georgestools.eqemulator.n...connection.zip
and see if you can connect.


GeorgeS

i figured it out, i forgot to do one mysql command...... doh!

Is there going to be a way to get this to work without MySql because i'm running vista, I just want to make items and copy and paste them into someone elses DB from my computer, and i dont have an XP box laying aroudn to do it... George?

No the tools integrate with PEQ schemas and mysql directly and there are no intentions to change this unless we change the schema to another database.
The tools can work with any commercial database, the only difference would be the connection string - so a very easy fix for those that need to run a database off MSSQL, or ORACLE for example.


GeorgeS

So I can't do anything on Vista at all

yes you can do it with vista. Im running mine on vista. its just a little more work required because vista is a piece of.........

Tools run on XP all the way thru Win7-64

GeorgeS

when editing items for some one elses data base how would i go about exporting the items for them to import into their database?

The only way I know is DL my SQL browser

Connect to the DB then type this into the input box

this will pull out items 1001 and 1002 and 1009
(You do this for all custom items you make)
then press 'export as sql' then select the export option you want then export.
The file 'output.sql' is created in the root folder of the tool.

You then source that sql in

GeorgeS

Can't find link for tools
 

Been all over your new web site in firefox and IE and I cannot see an actual link to the npc loot editor and item editor. I can't see a link to the entire tools set either. I even did CTRL +F searches for the words and none of the words are links. Looks like a mistake? OR am I blind? I recently had to replace a hard drive so I need to redownload. Other hard drive is ok but over at my parents right now hehe.

The links show up ok in win 7 IE. Can you post a screen shot of the webpage as you see it?

That way I'll be better able to figure what's going on

GeorgeS

Doesn't display.
 

It does not display the links in IE 6.

If I view the source I can extract the links.

This is why some people cannot see the links... A few of the links are not showing up in IE 6 OR Mozilla Firefox...!!!

http://img207.imageshack.us/img207/1...nshotyw.th.jpg

Ok, I see the issue. I'll redo the page.

GeorgeS

Good to see you are still here contributing to the community GeorgeS. Been a while.

Thanks for the tools George, I love it.

For anyone who has problems with register_ocx.bat and the files associated with it, some careful reading through the various threads will prove worth its time.

64bit Windows 7 seems to be running the item editor just fine. I had to run cmd as an administrator and then do

regsvr32 c:\users\me\desktop\itemtools\resources a.ocx

just for example. i did that with all the files one by one and its working fine except for the music it seems.

*edit, i didnt run the register thing. late night installs do that.

I apologize in advance if I missed this being addressed, this is a real long thread.

If I make the damage of an item too high, the item's damage only goes up maybe a third of what I set it at - or not at all.

Does this have to do with the item editor? It shows correctly in eqitems, but in game it's the capped version.

Thanks, and wow with your work!

Since the editor only works with the mysql database, it cannot control what goes on in the game. So the code in the emulator can modify the data in reads. So, in essence, the tool only writes what you put in, and the emulator interprets that higher up.


GeorgeS