Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 06-12-2006, 06:05 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Thanks for the info. I agree the 0.6.6 and 0.7.x have those changes to the spawnentry and spawnentry tables.

Also, I have taken a serious look at both databases and found the discrepancies -specifically in the npc table.

Anyways, I fixed ALL the programs to work with both PEQ and CAVEDUDES 0.6.6 databases. 0.7.x should work in all except the spawneditor.exe because of the field changes.

Let me know of any problems...

GeorgeS
http://66.159.225.58/eqemu/GeorgeS_EqEmu_Files.zip
Reply With Quote
  #2  
Old 06-13-2006, 04:38 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by GeorgeS
Thanks for the info. I agree the 0.6.6 and 0.7.x have those changes to the spawnentry and spawnentry tables.

Also, I have taken a serious look at both databases and found the discrepancies -specifically in the npc table.

Anyways, I fixed ALL the programs to work with both PEQ and CAVEDUDES 0.6.6 databases. 0.7.x should work in all except the spawneditor.exe because of the field changes.

Let me know of any problems...

GeorgeS
http://66.159.225.58/eqemu/GeorgeS_EqEmu_Files.zip
I'm useing the latest EQEMU (0.7.0-800), I'm able to see everything, and I can edit / put in changes , but the won't save into the EQ database; when I restart the editor, the changes are gone. I tried the loot editor in Harbinger's Spire , and the Grid editor in Lfay (didn't try anything else yet).
I will keep you informed of whatever problems I run into with your programs.
The Spawn Editor would be very helpful also, but "beggars can't be choosy!" Im really happy with what you already have made out.

Thank you very much for doing this - If I ever get a lot done with this database, anyone who wants it, can have it.
Reply With Quote
  #3  
Old 06-13-2006, 07:31 AM
sesmar
I built it I will Support it!
 
Join Date: Jun 2005
Location: Michigan
Posts: 214
Default

I downloaded and was looking at your Editors today and noticed you have to run the batch file to register a few DLL's might I suggest using the /s option to get rid of the annoying message box.

Code:
regsvr32 a.ocx /s
regsvr32 DXAnimatedGIF.ocx /s
regsvr32 imagelist.ocx /s

echo all registered
Just my thoughts.
__________________
Reply With Quote
  #4  
Old 06-13-2006, 07:56 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by sesmar
I downloaded and was looking at your Editors today and noticed you have to run the batch file to register a few DLL's might I suggest using the /s option to get rid of the annoying message box.

Code:
regsvr32 a.ocx /s
regsvr32 DXAnimatedGIF.ocx /s
regsvr32 imagelist.ocx /s

echo all registered
Just my thoughts.
I had done this before; Everytime I got an .ocx error, I'd find the file , run regsrvr32 on it. I did run your batch just incase.
I figured out my mistake- it was a stupid one; i wasn't saving them! I had been useing the peqeditor since it works partially on eq database and it spoiled me into not saving.

Thanks for the help
Reply With Quote
  #5  
Old 06-13-2006, 10:12 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

The Spawn Editor would be very easy to fix, but I think a unique version for 0.7.x and later would be better than trying to make one version to work on all every db schema out there.

So anyway, an 0.7 version is next up...

Next in the cards will be an enhancement to the existing eqitems.exe (items viewer) so you will be able to equip any of your characters easily with a eq like graphical interface. I'm going to start coding this enhancement later this week.


- sesmar - your changes are noted and will be done. -

If anyone's interested in the source code - it's going to be available when I get my server updated to a larger hardrive.

GeorgeS
Reply With Quote
  #6  
Old 06-13-2006, 02:32 PM
Jibbatwinkers
Sarnak
 
Join Date: May 2006
Location: Cincinnati
Posts: 73
Default

I'm having some issue with connecting to MYSql. I've messed with the db.ini for about an hour, i know my database name is 'eq', ive tried the pw/name i use for all my database things, and ive tried 127.0.0.1/168.192.1.5(onlan)/and localhost but nothing seems to work. I have winMYSQLAdmin 1.4 and I've tried it with a vew different versions of 7.0 (i saw in the readme which were supported). Any ideas?
Reply With Quote
  #7  
Old 06-13-2006, 04:32 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

If you can go to winmysqladmin 1.4 server properties and in my.ini Setup tab you should see your username/pass info at the bottom.

Next you should download the myODBC driver from my site
http://66.159.225.58/eqemu/ODBC_DRIVERS.ZIP
and install. Reboot and try again.

If that does not work then send me a private email and we can go from there.
also, what is the error you're getting?

GeorgeS
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:12 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3