Updated EQITEMS and BOTS editor

[GeorgeS]

Everquest Item Editor and Character Inventory Editor

- 14.4.11 - Added support for the new BOTS system. Old one is discontinued. Rerun register_ocx.bat if the music does not play. Added support for win7 32/64bit
Added BOT editing and equipping. Must have compatible bot tables. A copy of this schema is called bots.sql in /resources folder.
This sql is same as PEQ revision 781

In the future, adding/deleting BOTS and creating groups will be added
Remember, the PEQ rev781 database BOTS is supported. I've saved a entire copy of this in resources folder.

Backup your BOTS tables first

GeorgeS

[nosfentora]

Just out of curiosity - seeing as we've moved to loading the spells from the db, can eqitems use the db for spells too, instead of the eq folder?

[nosfentora]

And is there a way to specify a different port for the db? i have my db @ home and don't like opening 3306 up, so i opened up another port in the virtual server section of my router page so it's a little more secure.

[pfyon]

And is there a way to specify a different port for the db? i have my db @ home and don't like opening 3306 up, so i opened up another port in the virtual server section of my router page so it's a little more secure.

Yes, your mysql my.ini (or my.cnf, I don't remember which) file has the port number it listens on. You can change that to whatever you want.

If you're running a server on a linux system, you can also use openssh and putty to tunnel a port for mysql. This means you have to log in with putty first and then connect to the port on your computer that you set up to use for this.

[nosfentora]

actually i meant for changing the port used by georges's eqitems.

unless i'm mistaken, if the port is changed in my.ini, eqitems will no longer work as it's looking for 3306 by default.

sorry, should have been clearer.

[nosfentora]

Bleh ignore me...

[Taurinus]

GeorgeS,

Thank you for providing and maintaining this excellent tool. It is by far the easiest way to create custom items.

Infact, I think all of your tools are great. Keep up the great work!

[Shadow-Wolf]

Getting this error with the tool: Run-time Error '-2147220927 (80040241) Automation Error

[GeorgeS]

Need details.

Schema version, what exactly were you doing when it crashed..

GeorgeS

[Shadow-Wolf]

0.7.0 Pop_cvs DB revision 781, after pressing the start button it crashes with that error.

[GeorgeS]

So the splash screen runs ok - you get music?

I think if it ran for you in the previous version, it must be the new music library.

What OS?

[Shadow-Wolf]

I don't think I've used your tool since the first version came out, I just recently came back to eqemu. I'm not hearing any music from it and I am running XP Pro 32bit.

[GeorgeS]

Ok, the problem has been reproduced.

You need to specify the everquest folder in the db.ini file

host=localhost
user=eqme
password=eqme
database=peq
everquest_folder=c:\EverQuest

Also, in c:\EverQuest, there must be the mountainpass.mp3 and deaththeme.mp3 music files.

That's the problem

GeorgeS

[loen]

I tried changing to the c:\everquest folder putting the spells files and the 2 mp3 files listed in there, and Im still getting the automation error as well. I also tried using c:\program files\Sony\Everquest in there but it failed as well. Do you need to use Titanium or will SoF work?

[Shadow-Wolf]

nope, doesn't solve the problem at all. If it helps any, your other tools like tradeskill and others work fine but don't play music either.

[GeorgeS]

Everquest Item Editor and Character Inventory Editor
- 14.4.13 - Some OS's don't run the music right and cause an automation error. Now you can turn off music at the splash screen. Added error checking for this.

This version has the error checking in case your OS install did not install specific service pack dll's. These cause no music to be heard and the control therefore cannot load and fails. Now it "should" work

Give it a try

GeorgeS

[Shadow-Wolf]

Works like a champ, thanks :D

[nosfentora]

On saving an edited item i'm getting

Run-time error '-2147217900 (80040e14)':
[MySQL][ODBC 3.41 Driver][mysqld-5.1.37-community] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near "range="0" WHERE id=1118" at line 1


Abjurer's Earring -> New Edit
copied (ok),
error on save. (no values edited).
PEQ DB 946, EQItems 14.4.13, Vista Ultimate 64 (SP2)

happens on save of any item copied w/ new edit.
each failed save picks next available slot in db, but no value is saved to table (ie the next time i try and it failed, the id was 1119)

Old Edit gives 'Run time error '9' Subscript out of range' for any item.

[GeorgeS]

I looked at my code and it seems ok, but I think where it failed might be in the classes field, therefore if possible can you send me you field structure for items table and the item that failed in a sql export? From there I can fix the problem.

GeorgeS

[nosfentora]

Sent pm this am.

[GeorgeS]

Thanks, I have what I need, and I think I already found my table has missing fields. This is likely the issue.

I'll post the fix when I get back from work.

GeorgeS

[nosfentora]

Yw. And awesome job on this tool!

[GeorgeS]

I am still trying to fix the issue.

Regarding error "Old Edit gives 'Run time error '9' Subscript out of range' for any item."

This was fixed today. Field# exceeded variable declaration.

Now regarding the other more serious error. So we know that 'new edit' copy works fine, but fails if you save the copied item ~ around where it updates the "range" field.

Can you verify this assumption below?
if you save an original (not copied) item in new edit with no changes -- it works ok? but fails when saving the copied one?

BTW - I loaded in the latest schema and could not reproduce the error. Could be my version of mysql (mysql-5.0.77) that may be causing this, but still there has to be a reason why a simple query like UPDATE items SET range="0" WHERE id='1079' (it fails here everytime?)
fails???

This is weird and a real brain twister..
I'm on it and I'll let you know when I'm done

GeorgeS

[nosfentora]

Just tested now with a newly downloaded copy of eqitems (14.4.13) and newly installed OBDC drivers (3.51) to make sure i was up to date.

DB is still PEQ 946

It failed on saving an un-edited (non-copy) item, failed on saving an edited (non-copy) item, saving an un-edited copy, and saving an edited copy. (this time i tried on id 47344 (Abhorrent Brimestone of Charring)

could it be that MySQL 5.1.37 has something new that doesn't like that query?

Using NaviCat 8.2.11 i ran the query:
update items set range=0 where id=47344

it failed

"[SQL] update items set range=0 where id=47344

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range=0 where id=47344' at line 1"

[GeorgeS]

ok so it looks like what appears to be simple sql fails. Can you try and see which of these work?


UPDATE items SET range="0" WHERE id='1079'
UPDATE items SET range='0' WHERE id='1079'


One thing I can tell is that by the time range fails, many other fields using this query work, so it could boil down to the field struct - or something similar

Later
GeorgeS

[nosfentora]

Same error - i did try those variations before posting, should have posted that too =)

[nosfentora]

Dropped system and re-sourced Rev 946, still getting the same errors.

Something must have changed between 5.0.77 and 5.1.37 ... but why would updating a field (that particular one) fail?

is 'range' now a reserved word?

[nosfentora]

according to navicat, range is a reserved word (highlights blue like set, update, insert, etc)

update items set `range`=0 where id=1079

worked.

[fade1973]

I am also getting the same runtime error. althou i can get in and get the program to work i get the run time error anytime i try to save an edited item.

BTW great work on the tools.

[GeorgeS]

Great work on that fix!!!

I'll work on adding this to the program and post the update later!

GeorgeS

[bergalas]

is it posible for you to make a way to disable sound in these files my sound card crapped out on me and now i cant load your programs i get the following error

runtime error'-2137220906 (80040256)' Automation Error it didnt start till my sound card died on me

[nosfentora]

When the app starts, before you click on 'lets start' you can click on the radio button to the left 'editor music off' that will turn the music off for that session.

GeorgeS - would you want to make that selection 'permanent' so that one doesn't need to turn it off every time?

also, i believe that the app loads spells from the database, so pointing it to the eq folder is no longer necessary. If you set it to nothing (="") it shouldn't load the music (though it will give you the 'music library error') and you should be all set. Clicking 'editor music off' does away with that error in either case.

[GeorgeS]

Ok folks,

- 14.4.14 - Changed sql to use `range` with quotes since it's a reserved word in mysql. Saving items should now work.

Download the latest binary with this fix.
Regarding the sound issue, just disable it at the splash screen option.

GeorgeS

[bergalas]

i see no radio button??

[bergalas]

http://i27.tinypic.com/11vpnw6.jpg

maybe im missin something here?

[bergalas]

also tried the eq folder fix in the ini same error ugh

[nosfentora]

that's definitely an old version - current is 14.4.14 (you have 14.4.12)

[bergalas]

really only one version behind he just made .14

[nosfentora]

actually there was .13 too. (i'm guessing the radio button showed up 1st in 14.4.13, that's the rev i was having the sql problems with).

(sorry, didn't meant to come off as an ass)

[bergalas]

well yeah i know, just saying, i downloaded this one like last week or something ill download the newest and see if that fixes the problem

[nosfentora]

It seems that if you equip your character with an item that does not have a correct icon file (the 'dragon' icon appears in eqitems, and the 'necklace' in game), you can save the inventory template, however it's empty (the .bot file) and crashes if you try to load it for another character (ie bot) with message

Run-time error '53':
File not found: "resources/icons/item_.gif"

example of item used:
id 105411
Inflicted Forcestrike Silk Cap

i'm assuming this is due to missing/invalid icons, but thought you'd like to know.

[GeorgeS]

I think there are quite a few missing icons, so I decided to extract them today. Adding several hundred will take me some time. I should have this done by friday nite

*edit

Everquest Item Editor and Character Inventory Editor
- 14.4.15 - Added support for SOF's extra icon set. These view ok, but have the 'pink' border around them due to no transparency added yet.

So as mentioned above, the icons are now up to ~2990, but the latest ones have a pink (255,0,255) background because this will be used to convert them into a transparent gif. So for now they will work.

GeorgeS

[nosfentora]

How would you suggest I rectify these in the PEQ DB so that they show up correctly there too?