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 11-20-2005, 05:15 PM
fathernitwit
Developer
 
Join Date: Jul 2004
Posts: 773
Default

its a nice idea Arex, but the fact is... nobody ever helps. I havent seen a single line of SQL posted reguarding fixing the PEQ database since I have been here (by non-PEQ quest team), with the exception of global, non-PEQ specific things like zone lines/doors. I would love for this to change, but I dont think its going to.
Reply With Quote
  #2  
Old 11-20-2005, 05:44 PM
SiliconeClone
Sarnak
 
Join Date: Apr 2005
Posts: 42
Default

Aye what FNW said, they don't get alot of help over there. That makes things very, very slow. There are packet collectors and such you can use to help. Or simply using their database and running around and finding things.. even simple things, like such and such has the wrong faction. The more help they have (even if it is just feedback) the faster they will move along.

I'd love to say that I help over there but honestly I don't. Then again I don't even really run a server or play eqlive, I just like to fiddle with things lol.

But the rest of it is what it is. Want expansions faster, then help them get it out.
__________________
Silicone Clone
Creator of Patch Creator v1.06
Reply With Quote
  #3  
Old 11-20-2005, 09:33 PM
Arex
Hill Giant
 
Join Date: Jul 2004
Posts: 196
Default

I am sure that community could help to PEQ, if they release 1 snapshot of his DB each month, then ppl can to see that the bugs that they have posted on PEQ forums have been fixed and they continue working on improve PEQ-DB, but PEQ makes 1 release each 4-6 months, it give a feeling of project is neglect. I know that u are doing very nice DB's, but i think that u policy of releases is wrong.

For example, u could give a release each month with ONLY 4-5 zones more done, then ppl begin to check that zones and could post bugs, fix, etc. I am sure that u could revive project doing it.
Reply With Quote
  #4  
Old 11-21-2005, 01:21 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

PEQ's database is better overall. They are both accurate in that fact that the base spawns were created from Live logs. However, PEQ spent a lot more time perfecting the spawns, factions, and loot where as I just populated all the zones I could and corrected any blarring errors that I found along the way. I actually never intending on releasing my database. My original intend was that I'd create a database from scratch as a learning tool. I never really thought people would like it as much as they do. So, coming from the horse's mouth:

If you want a more Live-like gaming experience, go with PEQ.

If you want to play on Luclin and some PoP zones, go with mine.

As for the time between releases... you're going to find that most of the sub-projects within EQEmu suffer from that. The simple fact is there aren't many of us working on things and the few there are are all just doing what we can to help. Plus, I am pretty certain that most of the devels/world builders are older so we have wives, kids, jobs, and the like to worry about. Just be patient and I assure you the wait is always well worth it in this community.
Reply With Quote
  #5  
Old 11-28-2005, 07:19 AM
nadineemu's Avatar
nadineemu
Sarnak
 
Join Date: Apr 2003
Location: UK
Posts: 61
Default

just a question, is there a way to combine cavedudes and PEQ database'es into one, but so that cavedudes doesn't overwrite the already present mob info on PEQ database, or will it just add a ton of duplicates?
__________________
me version 1.2
~ No place like home Server Controller~
Reply With Quote
  #6  
Old 11-28-2005, 12:14 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Sure they can be combined, but I'm not going to. It would take too much time I don't have.
Reply With Quote
  #7  
Old 06-06-2006, 10:29 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by fathernitwit
its a nice idea Arex, but the fact is... nobody ever helps. I havent seen a single line of SQL posted reguarding fixing the PEQ database since I have been here (by non-PEQ quest team), with the exception of global, non-PEQ specific things like zone lines/doors. I would love for this to change, but I dont think its going to.
You know, I'd love to help out - I tried playing on your PEQ server, but when I realized drops and loot tables, were missing, and spells become less and less available as you go up in levels, I stopped and went over to my server where I can look at the loot tables and spawns and what ever else, fix them myself. I've always been a "drop fanatic" - I played EQ live for many years (since they started), and all I ever did was camp mobs for their drops. I have many drop rates and spawns from a lot of zones "engraved" in my head.
But how do I tell you what needs to be fixed on spawns and drops? what if you already fixed it in your current datqbase, and I'm wasting your time? I only know whats wrong from the PEQ database availale to the users.
I noticed my favorite expansion LoY, has all zones unpopulated - I have downloaded editors and have them all working, but there must be some table missing for the LoY zones, that enables a starting point for all the NPCs to be placed. I can't (for the life of me) get one NPC to stick there. If someone told me how, I could have most of those zones poplulated with all the named NPC's and their drops. You could then have my work and use it with what you have.
Harbringer's Spire is a great zone - It's all in my head too; I can still see them all standing in their spawn spots. But when it comes to PEQ, I'm still green as they come, trying to figure things out on how to get a bare zone like that rolling.
Reply With Quote
  #8  
Old 06-07-2006, 03:01 AM
curt1zzle
Fire Beetle
 
Join Date: Nov 2004
Posts: 3
Default

Quote:
Originally Posted by fathernitwit
its a nice idea Arex, but the fact is... nobody ever helps. I havent seen a single line of SQL posted reguarding fixing the PEQ database since I have been here (by non-PEQ quest team), with the exception of global, non-PEQ specific things like zone lines/doors. I would love for this to change, but I dont think its going to.
It's not a simple task. I'm sure if the ordinary user was capable that you'd get a lot more help.

I for one would help if I knew how...
Reply With Quote
  #9  
Old 06-08-2006, 02:13 AM
Belfedia
Demi-God
 
Join Date: Jan 2005
Posts: 1,109
Default

Quote:
Originally Posted by curt1zzle
I for one would help if I knew how...
That the problem for all people, this is a hard work to combine this 2 db.
Making a program for make that, take a long time :(
__________________
__________________________________________________ _____________________________________
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
  #10  
Old 06-14-2006, 08:35 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Yes it's hard work, but more so, very prone to errors.

I have thought of combining the two, but it's complicated, and requires lot's of 'hand crafted code'

Simple things like tradeskill recipes should be easier to merge, but the itemid's may be different

even the database schemas are different in some aspects. There are reference tables (like classes, races, spells) in Cavedudes DB that are excellent, and should be inlcuded in PEQ.

I'm looking into some of these tasks...
GeorgeS
Reply With Quote
  #11  
Old 06-21-2006, 09:40 PM
EliteSting
Sarnak
 
Join Date: May 2005
Posts: 58
Default

I'm currently starting work on Luclin, I spent many years playing live and have first hand knowledge of every luclin zone. After I get some zones done I'll post the database ( using cavedudes db , I like the idea of combining the two though , maybe I'll look into that ). It's going to be a while though , even with the db , item , and quest editors I have up and going. I'm a perfectionist , and don't like leaving anything half-assed , so yeah it may be a while. My current dilema is figuring out how to run scripts in game , so I can write encounters and tune them properly ( or as close as I can get them ).... O.o nm , I just had an idea. ><
Reply With Quote
  #12  
Old 06-21-2006, 11:34 PM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

How about something in the line of a "public" database? since PEQ editor is web-based and you can actually set it up at any web site, point it to the PEQ or EQ database you want to work on, give it a unique password, and you're ready to start.
You could have a group of people adding data to it like this. I think Cavedude's would be the one to use, since it gives a better start for something like this.
Problems would be - how would you decide how to choose/trust for adding data here? you can't let everyone, that would result in problems. And the database would have to be tested/backed up often, since it can pick up bugs while editing.
Reply With Quote
  #13  
Old 06-21-2006, 11:44 PM
CamelFilter
Sarnak
 
Join Date: May 2006
Location: "We're not in Kansas anymore."
Posts: 36
Default

Only problem I can see with that, is too many peeps adding diff loot tables and whatnot, losing track. If someone did that I'd suggest having certain people work on certain tables. Like one person on NPCs, their pathing, and spawngroups. One on aggro and loot tables. One on errmm AAs... Something like that. But they'd all have to work around the same rea at the same time. Just doing like one zone at a time.
Reply With Quote
  #14  
Old 06-21-2006, 11:33 PM
sesmar
I built it I will Support it!
 
Join Date: Jun 2005
Location: Michigan
Posts: 214
Default

Quote:
Originally Posted by GeorgeS
even the database schemas are different in some aspects. There are reference tables (like classes, races, spells) in Cavedudes DB that are excellent, and should be inlcuded in PEQ.
The reference tables, and dont quote me on this, I believe came from my DB editor, and from the Allakazam Clone (races and spells). I was using these tables for my DB Classes that I wrote in order to make it easier for the user to enter Bodytype, class, race and spell information. As far as the base information goes, as long as you keep up on the SQL updates from the Changelog in both Cavedudes and the PEQ DB they should have the exact same schema or the Emulator would not work with them.
__________________
Reply With Quote
Reply


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 08:53 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