GeorgeS Database tools updated

[ChaosSlayer]

there are 2 easy ways to edit such npcs:
a) add them to any spawn group in the same zone with 0% chance to spawn, then they will pop up in Georges npc editor
b) edit them directly in mySQl browser

[loglos]

George,

When running most of your tools, I could get connected to the db but I could not get past the intro page. I would get:

Run-time error '339':
Component 'a.ocx' or one of its dependencies not correctly registered: a file is missing or invalid

The test connection tool ran fine. It was something else. It took me a while but I finally figured it out and wanted to pass this info on. I'm not sure how many it will affect.

As far as I know, the second part of this will only affect those in Vista 64 Bit but the shortcut trick may work for those on Vista 32.

First, create a short cut to the file register_ocx.bat in the resource directory (from the zip you downloaded). In the shortcut to this bat file, edit the properties and select run as administrator. When you run the bat file, if it can't find the files, add the path to each ocx (as in the sample below).

For 64 bit:

c:\windows\syswow64 is actually where the 32 bit tools reside. There is a regsvr32 in system32 (which is 64bit) and a regsvr32 in syswow64 (which is 32 bit).

Edit the bat file so that it looks like this (or just create a new file):

c:\windows\syswow64\regsvr32 C:\Shared\eqemu\resources\a.ocx 
c:\windows\syswow64\regsvr32 C:\Shared\eqemu\resources\DXAnimatedGIF.ocx 
c:\windows\syswow64\regsvr32 C:\Shared\eqemu\resources\imagelist.ocx 
c:\windows\syswow64\regsvr32 C:\Shared\eqemu\resources\TABCTL32.OCX 
c:\windows\syswow64\regsvr32 C:\Shared\eqemu\resources\MSCOMCTL.OCX 

echo all registered

I got rid of the /s at the end of the commands because that was making it run silently and I was not seeing the error codes.

Now run the shortcut. You should get a dialog after each ocx saying that the dll was successfully loaded. Now the tools will work.

If you are running vista 64 and are having problems accessing mysql via odbc, post a reply here and I will write up a fix for that.

Hope this helps someone,

loglos

[ChaosSlayer]

Geogre, so what did you decided on Tradeskill editor? (see above)
Can you redesign it a little bit so it is all in one page (recepies list on one side, and recipy detaisl on another, auto shown when recepy in the list is clicked)

thanks

[ChaosSlayer]

oh another thing- the editor will produce an error when there is no any recepies in the DB and you trying to make new one

[GeorgeS]

I will look to see if I can do this without a total rewrite.
The error should be easy to fix, and I'll start on this now.

GeorgeS

[ChaosSlayer]

Thank you George

[GeorgeS]

Just finished the program -
Tabs are gone and entire interface is on a single page now
Copy/Paste for ingredients added.

1.0.0 -Redid front interface so no more tabs, and added copy/paste ingredients function too.

GeorgeS

[Babul]

Hello, I wanted to try your tools but all the download links on the web page do not work.

[GeorgeS]

Try then now. Changed some left over link to the correct ones

GeorgeS

[Babul]

Thanks GeorgeS, I have downloaded the tools now and isntalled.

Unfortunatly they dont seem to work with my configuration, I have edited the db.ini with the correct information which allow me to run both the server and another tool I downloaded (EQemu database editor) but for some reason i am gettin errors, some open with check your db.ini or myodbc drivers but they are intalled version 5.1.

The connect tool also fail but the same info work with mysql admin to connect and with the server iteself, so it seems there is a problem with my setup and the version of your tool?

And on some i get an error 91 run time error object variable or with block variable not set.

I am using win xp sp3
mysql server 5.0.67 with PEQ database and the last version of the Emu server.

Any help would be very appreciated.

[Babul]

And on some (spawn editor and grid editor) i get an error 91 run time error object variable or with block variable not set , while the npc lot edit open and then also give the same db error and another error if i click past this: missing isbot field please add the SQL to create the bot first. and on the graphical window it say Running DBversion: unknown.

[GeorgeS]

If the cursory check connection program does not work, then it's the ODBC drivers no doubt. Use the ones from my site and only those will work

Next, make sure you're using ip=127.0.0.1 on local machine.

GeorgeS