Updated Tool - EqItems Item Editor

[Emmeric]

Originally Posted by GeorgeS

Ok, your spells_us.txt has some problem with it regarding field count or a extra "^" delimmeter somewhere.
My spellfilehandler (this tool) has an extra copy. If it's knackered, then redownload another copy.

Ti uses 200 fields and SoF has 215 fields

GeorgeS

Redownload? Ok, thanks. Will downloading again effect any of my new spells added?

[lerxst2112]

Just export a new file from your database.

[Emmeric]

Originally Posted by lerxst2112

Just export a new file from your database.

Not to sound contrary, but I tried that when my server was not connecting. Tried several times to export from Navicat so that my work wasn't wasted.

None of the files were readable. Couldn't source any of them.

The errors hinted at duplicate fields and some -1 values.

At that point, I lose patience.


Edit: however, I now use the backup command function liberally.

[lerxst2112]

You don't use Navicat to export a spell file... There are several spell file utilities available. There's one on Georges web site, you can do it with Null's Spell Editor, and there's a perl script in the utils directory where you downloaded the server source.

As a side note, I've exported and imported tables with Navicat and had no issues. It doesn't dump them in a very efficient manner though. I prefer SQLyog for that.

[GeorgeS]

Originally Posted by Emmeric

Redownload? Ok, thanks. Will downloading again effect any of my new spells added?

I would think your back up plan sounds good. When you are ready to export the EQ spell file, then just make copies of the text spell file and the spell table.

I should think your new custom spells are fine. Just import them in as usual.

[Swedgamer]

I donwloaded your latest EQ item editor from your website but it won't connect properly.

I have installed odbc drivers, I've registered all *.ocx without problems and filled out the db.ini correctly.
I've also tested the connection with your connection tester and it works.

When I run the eqitems.exe it says:

Error in connecting to the database - perhaps a missing version field in variables table?

Then shows the load screen and pressing lets start gives:

Run-time error '-2147024894 (80070002)':
Automation Error
The system cannot find the file specified

The Logfile says

creating log entry
Identified user:root
Identified database:peq
Identified host:localhost
Identified everquest_folder:c:\eqemu\
Completed getting user info
credential output to screen ok
Call to ODBC open connection started
Call to ODBC open connection created
Call to ODBC open connection string completed
Call to ODBC open connection open
Call to ODBC open recordset started
Call to ODBC open connection completed
Open RS with sql: SELECT value FROM variables WHERE varname='DBVersion'
Recordset version returned: 070_pop_cvs
Starting music: c:\eqemu\\deaththeme.mp3
Splash returned an error-connection fail
Splash request to load MAIN program started
Started Main ok
Started to read all init *.txt files
Started to read all init *.txt files - ok done
MAIN exectuted ok - Form Load done and exiting

Hope someone can help me

[GeorgeS]

From the log file, it appears the mp3 dll failed to load.
I'll have to check when I'm back at the PC to make sure.
Might be the error check failed and has to be coded to be more robust.

GeorgeS

[Swedgamer]

Hey George! Nvm my last post! I'm a tool!

I had the EQ path set to my server folder ... not my Eq client!! Changed it and all programs I tried works now!

Sorry for the inconvenience and thanks for the great tools!

[GeorgeS]

Ok good to know

George