Updated EQITEMS and BOTS editor

**GeorgeS** · #1 08-09-2009, 01:26 AM

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 · #2 08-13-2009, 02:08 PM

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 · #3 08-13-2009, 02:19 PM

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 · #4 08-13-2009, 03:20 PM

Quote:

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 · #5 08-13-2009, 03:29 PM

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 · #6 08-13-2009, 03:49 PM

Bleh ignore me...

Taurinus · #7 08-15-2009, 09:41 PM

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 · #8 08-17-2009, 08:39 PM

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

**GeorgeS** · #9 08-17-2009, 10:01 PM

Need details.

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

GeorgeS

Shadow-Wolf · #10 08-18-2009, 09:34 AM

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

**GeorgeS** · #11 08-18-2009, 10:31 AM

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 · #12 08-18-2009, 10:38 AM

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** · #13 08-18-2009, 10:16 PM

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 · #14 08-18-2009, 10:30 PM

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 · #15 08-19-2009, 01:08 AM

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.