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]

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

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.

[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

[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