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

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

11-20-2005, 05:44 PM
|
Sarnak
|
|
Join Date: Apr 2005
Posts: 42
|
|
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. 
|

11-20-2005, 09:33 PM
|
Hill Giant
|
|
Join Date: Jul 2004
Posts: 196
|
|
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.
|
 |
|
 |

11-21-2005, 01:21 AM
|
 |
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
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.
|
 |
|
 |

11-28-2005, 07:19 AM
|
 |
Sarnak
|
|
Join Date: Apr 2003
Location: UK
Posts: 61
|
|
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~
|

11-28-2005, 12:14 PM
|
 |
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
Sure they can be combined, but I'm not going to. It would take too much time I don't have.
|
 |
|
 |

06-06-2006, 10:29 AM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
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.
|
 |
|
 |

06-07-2006, 03:01 AM
|
Fire Beetle
|
|
Join Date: Nov 2004
Posts: 3
|
|
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...
|

06-08-2006, 02:13 AM
|
Demi-God
|
|
Join Date: Jan 2005
Posts: 1,109
|
|
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.
|

06-14-2006, 08:35 AM
|
Forum Guide
|
|
Join Date: Sep 2003
Location: California
Posts: 1,474
|
|
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
|

06-21-2006, 09:40 PM
|
Sarnak
|
|
Join Date: May 2005
Posts: 58
|
|
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. ><
|

06-21-2006, 11:34 PM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
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.
|

06-21-2006, 11:44 PM
|
Sarnak
|
|
Join Date: May 2006
Location: "We're not in Kansas anymore."
Posts: 36
|
|
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.
|

06-21-2006, 11:33 PM
|
I built it I will Support it!
|
|
Join Date: Jun 2005
Location: Michigan
Posts: 214
|
|
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.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 08:53 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |