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-13-2006, 02:01 PM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

I have a question;
Concerning the the dropdown menu "Tools > NPC > Copy Existing NPC" , I get a copy of the NPC, but not in the zone in use. Is there a way to move it back to the zone it was duped in?
Reply With Quote
  #2  
Old 06-13-2006, 04:50 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

NPC's can be shared/re-used in any zone i.e certain bats can be found everywhere. So what you need to do is go into spawneditor and add that npc into the spawngroup, so yes you can but not directly in npc editor.

I think your question is valid, however I think adding that functionality is complex and may yield errors in the database.

I'm off now to make the spawneditor ready for 0.7.0-800 06/07/2006 build date.

-edit - now the spawneditor should be 0.7.0-800 compatible. A few feature enhancements such as error checking is added .
You can now type in the npcid and the program responds with npcname automatically.
Also, clicking on the npc row (in spawnentry grid) will populate the NPC_search pop-up and you can thereby search for the npc that way.

http://66.159.225.58/eqemu/GeorgeS_EqEmu_Files.zip

GeorgeS

Last edited by GeorgeS; 06-14-2006 at 01:45 AM..
Reply With Quote
  #3  
Old 06-13-2006, 11:09 PM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by GeorgeS
NPC's can be shared/re-used in any zone i.e certain bats can be found everywhere. So what you need to do is go into spawneditor and add that npc into the spawngroup, so yes you can but not directly in npc editor.

I think your question is valid, however I think adding that functionality is complex and may yield errors in the database.

I'm off now to make the spawneditor ready for 0.7.0-800 06/07/2006 build date.

-edit - now the spawneditor should be 0.7.0-800 compatible. A few feature enhancements such as error checking is added .
You can now type in the npcid and the program responds with npcname automatically.
Also, clicking on the npc row (in spawnentry grid) will populate the NPC_search pop-up and you can thereby search for the npc that way.

http://66.159.225.58/eqemu/GeorgeS_EqEmu_Files.zip

GeorgeS
I still can't get it to run for me, I always get the same error on any version;
a runtime error followed by "unknown colum 'spawnentry.spawn_limit' in 'field list'

The version spawn editor I have is 06.08.01.
Reply With Quote
  #4  
Old 06-14-2006, 02:43 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Found a bad sql query refering to the old db schema. This new version I just compiled works fine on my machine, but dl it and see if it works for you.
new ver# is 06.08.03, just released

GeorgeS
Reply With Quote
  #5  
Old 06-14-2006, 05:57 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by GeorgeS
Found a bad sql query refering to the old db schema. This new version I just compiled works fine on my machine, but dl it and see if it works for you.
new ver# is 06.08.03, just released

GeorgeS
Hi- I tried the links, the must be down? post me a link when you can. and if you need a place to post your downloads, I have my own server here running for 6+ years now, you're welcome to some space.

Thanks
Reply With Quote
  #6  
Old 06-15-2006, 12:30 AM
Belfedia
Demi-God
 
Join Date: Jan 2005
Posts: 1,109
Default

Quote:
Originally Posted by Angelox
Hi- I tried the links, the must be down? post me a link when you can. and if you need a place to post your downloads, I have my own server here running for 6+ years now, you're welcome to some space.

Thanks
Download working for me ???
__________________
__________________________________________________ _____________________________________
I speak english like a spanish cow..., I speak spanish like a english pudding...
But I try to speak good french !!! (Non au langage SMS sur forum)
http://eqfroggy.new.fr : Froggy French Server Website.
Reply With Quote
  #7  
Old 06-15-2006, 12:55 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by Belfedia
Download working for me ???
Hi, it is now thank you, although editor posted is same one from before.
Also, I noticed a small bug in the npc_loot_editor : if I search for an item with a " ' " in it, the program crashes. example: "Muramite's Sheild" ( I just did that, hehe!). This has been a small problem with all versions, on both database.
Reply With Quote
  #8  
Old 06-25-2006, 01:36 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by Angelox
I still can't get it to run for me, I always get the same error on any version;
a runtime error followed by "unknown colum 'spawnentry.spawn_limit' in 'field list'

The version spawn editor I have is 06.08.01.
Same bugs in these too
Reply With Quote
  #9  
Old 06-25-2006, 05:33 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default ...finally found the bug

I found the issue finally. I tried it on all db's cavedudes and peq and it should now work for you.
The correct version should be 'Spawn Editor 6.11.00'

If you see any other issues in the other utilities, pls let me know.

GeorgeS
Reply With Quote
  #10  
Old 06-25-2006, 07:14 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by GeorgeS
I found the issue finally. I tried it on all db's cavedudes and peq and it should now work for you.
The correct version should be 'Spawn Editor 6.11.00'

If you see any other issues in the other utilities, pls let me know.

GeorgeS

Thanks for your work, heres a few problems.

I switched back to PEQ.

Spawn Editor - when I go to create a new id in spawn editor, it crashes with a runtime error and Unknown column "condition" in "field" list. I tried in Befallen and Harbingers.

Loot Editor -
In Harbingers Spire, when I click on a mob with body Id of 34 it crashes with Run-Time error 9, "Subscript out of range". I'm mostly working on populating harbingers with npc's, loots, spawns, etc.

Grid Editor from the start appears ok, I really haven't started using it yet.

Tradeskill Recipes gives me an OCX error when i start it - Component "TABCTL32.OCX" not regged - I probably can figure that one out, but I'm not really into tradeskills yet.
Reply With Quote
  #11  
Old 06-25-2006, 10:34 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

ok, fixed those issues.

Spawn Editor 6.11.02
-fixed condition field for EQEmu-0.7.0-806 compliancy (ignore condition field to prevent incompatibility issues with 0.6.6)
Spawn Editor 6.11.00
-fixed issue of creating a new spawngroup. Program should now handle both cavedudes and peq database schemas properly

NPC and Loot Editor 6.11.00
-fixed bodytype not found error.

TradeSkill Recipe Editor 0.2.1
-TABCTL32.OCX error? You must register the provided ocx with included resources/register_ocx.bat

Grid Editor 6.09.03
-Examined the mysql connection string, and verified all programs using the connection class can use non local ip i.e 192.168.1.3
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
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 04:09 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