I'll beef up the code to remove the splash lock up screen issue.

Since your splash screen says dbversion unknown, I will guess you don't have the version field in the variables table. But at least I think it's a missing version field. In a previous version the program fixed this by adding the field to your database.

I will add this code back tonight

Thanks fo letting me know


edit*
I take it back, it's not db schema, but the sound playing dll. I am fixing it now...
Also please check for your everquest folder in db.ini. The program looks for a file in this folder and it crashes if the path is wrong.

I am compiling the new version now - it should be live in 10 minutes..


GeorgeS

That was the problem. I just copied the db.ini from an older version and didn't change anything. That file had a comment that said you'd just get no music if it was set to an incorrect directory, so I left it set to the wrong place on purpose. :)

Working now, thank you.

Unless I am just not seeing it, it looks like the qglobals field may have been removed from the NPC editor main screen.

Sorry, it's back in the latest build - must have been inadvertently removed during my coding frenzy :)

GeorgeS

anyway to disable the blue background, its horrible on my eyes

Yes, but I've had this discussion numerous times before and changing it again as usual messes up viewing the table correctly. Sorry, but it stays.

GeorgeS

Need some help if possible, I had this working on my desktop before I reformated and now I can't get it working. I am pretty sure my problem is with my db.ini file, though it looks ok. can anyone tell me what it should look like please?

I get an error saying "MYSQL Connection FAILED! - Check DB.INI or MyODBC Drivers not installed"

I copied all the drivers over to my system32 and got them registered ok.

my db.ini file reads:
host=localhost
user=eq
password=eq
database=peq
everquest_folder=C:\EverQeust_titanium
quest_folder=c:\EQEmu\quests

tried changing localhost to match my IP
EQ folder i tried leaving it as everquest_sod
and database i also tried peq_1751

Please help!

(sorry, I named my db "peq" and I am running titanium)

Was that a copy/paste or were you typing?

everquest_folder=C:\EverQeust_titanium

Not saying that it is your problem...

No misspelling that part should not cause a problem.

You need to DL my connection test tool, as it's a basic mysql connection tester.

Also, MyODBC Drivers were installed?
Is the MYSQL service running?


Check also with Heidisql SQl browser (free download), to eliminate other possibilities.

GeorgeS

George,

One of your tools performs a mob spawn/grid copy from one version of a zone to the next. Anyway we can incorporate that functionality to include doors/objects?

Also, anyway we can get the same information that is immediately written to the database dumped to a SQL file so it can be transferred to another database with ease instead of manual transfer?

Ok, yeah I did type that out so it was just spelled wrong here (oops). I ran your test connection and it did fail for mysql. I did download and install "MySQL connector/ODBC 5.1" that I found on google. I am not sure if the MySQL service is running or not though, I know nothing about about MySQL except what it lists in the guides, how do I check that?

Thanks again for the help!

Ok, that means either mysql is bad installed, or you did not install the correct ODBC drivers. You must use these

http://www.georgestools.eqemulator.net/ODBC_DRIVERS.zip

GeorgeS

George,

I uninstalled the ODBC I got on google and installed yours (I originally did install yours come to find out, and upon the problem I went to the other). I still get the same thing.

Question, I did figure out one error I had on my way to work after I first posted. I Have Everquest installed on a different drive, I named "Z" so tried changing my "everquest_folder=C:\EverQuest_titanium" to Z:\Everquest_titanium. I don't think that is the issue but figured I would throw it out there.

I should note also... Prior to me reinstalling the MySQL was not running (at least, I checked in the task manager under services), it is listed in there now!

**when running your test connection I still get failed, I need to use my MySQL user name and password there right? just making sure**

Yes the mysql user/pass is correct. I would at this point install heidisql and try to connect to you db directly. I suspect a problem with either user name or password, or a bad install of mysql..

also, to connect directly via a dos/command prompt, type in

mysql -u eq --password=eq

and see if you get in.
type exit to get out/quit

George