NPC & Loot Editor revision - Page 3

**GeorgeS** · #31 01-24-2011, 10:55 PM

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

lerxst2112 · #32 01-24-2011, 11:41 PM

Quote:

Originally Posted by GeorgeS

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.

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.

**Kayen** · #33 01-25-2011, 01:22 AM

Working now, thank you.

**trevius** · #34 01-30-2011, 07:42 AM

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

**GeorgeS** · #35 01-31-2011, 12:25 AM

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

GeorgeS

Astal · #36 05-05-2011, 01:09 AM

Quote:

Originally Posted by GeorgeS

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

**GeorgeS** · #37 05-06-2011, 10:27 AM

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

greed80 · #38 05-25-2011, 07:01 AM

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)

**joligario** · #39 05-25-2011, 07:30 AM

Was that a copy/paste or were you typing?

everquest_folder=C:\EverQeust_titanium

Not saying that it is your problem...

**GeorgeS** · #40 05-25-2011, 10:31 AM

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

**Akkadius** · #41 05-25-2011, 10:38 AM

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?

greed80 · #42 05-25-2011, 07:03 PM

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!

**GeorgeS** · #43 05-25-2011, 10:26 PM

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

greed80 · #44 05-26-2011, 06:11 PM

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**

**GeorgeS** · #45 05-27-2011, 01:04 AM

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