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 10-09-2006, 02:53 AM
bobbydole
Fire Beetle
 
Join Date: Jul 2006
Posts: 26
Default Populating newer zones..?

Hello...

I just my server up and running and my friends and I played a bit over the weekend, we had some problems, but over all it was pretty fun. However, right now I've only got PEQ database installed, and I would like to get more zones.. pop, gates, LoDN, LoY, stuff like that. So are there any DB's released that have some of these zones populated, or how do I go about getting the data for these zones so I can populate them myself? I would like to stick as close to EQ as possible..

Thanks for the help.

bobbydole
Reply With Quote
  #2  
Old 10-09-2006, 03:45 AM
mattmeck
Guest
 
Posts: n/a
Default

PeQ is the only DB out that sticks close to live, if your interested in helping them further the DB check out there web site / forums.
Reply With Quote
  #3  
Old 10-09-2006, 05:08 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

In the short-term, you can d/l 2 other databases with more info in them. Cavedudes, and Angelox. The former having many mobs populated but not highly tuned, and the latter being an extended effort of Angelox who has done tons of work to get PEQ + LoY + some PoP+ zones populated. Both can be found through links here.

There are also some community DBs posted around in this forum - work others have done, and posted links to their entire DB. Lots of custom stuff in those, though. Your best bet is PEQ for stability. Angelox for stability + some additional content. And, a tool written by a guy Zephyr to pull stuff from one (Cavedude) database and put into another (any).

Hope this helps.
Reply With Quote
  #4  
Old 10-09-2006, 05:43 AM
bobbydole
Fire Beetle
 
Join Date: Jul 2006
Posts: 26
Default

Quote:
Originally Posted by John Adams
There are also some community DBs posted around in this forum - work others have done, and posted links to their entire DB. Lots of custom stuff in those, though. Your best bet is PEQ for stability. Angelox for stability + some additional content. And, a tool written by a guy Zephyr to pull stuff from one (Cavedude) database and put into another (any).

Hope this helps.
Thanks it does help! I was thinking of switching to Angelox's DB because it sounds like it's got some good content, and i've spent a long time in LoY. However what I would really like to do is add some content that isn't already in the DB, but really I don't know how to start. Could I log into EQLive now and start collecting packet logs, or are the tools outdated? And once I got the packet logs, how do I get them into my DB? The wiki says that the collector doesn't work with Live, but there are logs at www.projecteq.net/logs can I use those and add them to my DB?
Reply With Quote
  #5  
Old 10-09-2006, 07:58 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

I know nothing about the packet collectors, since I've been here they have been outdated and unusable. I would hit them up over at PEQ and see what they think. The perl script that Zephyr wrote does a great (clean) job of identifying diffs in databases. takes only a moment to setup, and even if you don't use the data, it gives you an idea how everything is hooked together.
Reply With Quote
  #6  
Old 10-09-2006, 01:48 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

I think Angelox spawned LOY zones from memory (if memory serves me right). so you can do the same. The tools for this are out there.


GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #7  
Old 10-09-2006, 01:52 PM
mattmeck
Guest
 
Posts: n/a
Default

PEQ has several tools, im not sure if there just for the PEQ team or if its open to the public.

PEQ shairs in your vision, best thing would be to help them IMO, then it would get done quicker then you by yourself, or them without you!

Also it will ensure your not doing stuff they already have done.
Reply With Quote
  #8  
Old 10-10-2006, 02:47 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

When i first started out with EqEmu, I was incredibly impressed with the whole project; I couldn't believe someone actually figured out a way to play EQ at home - and I still am!
After the "newness" of it all began to rub off, I realized all the work that still needs to be done, and I knew "ditto" on how to pitch-in and help.
The only place I ever got any answers and help was in these forums; I tried the PEQ forums and got no interest and no replies.
It seems to me, there is not enough people (programmers, zone-spawners, etc) in EqEmu that would constitute smaller groups breaking off and starting things on their own. I see it better to stay in one place, and since EQEmulator Forums appear to be the oldest and have the most traffic, this is the most logical place to stay at. The EQEmulator forums have a very nice comunity going, and a lot of dedicated people.
When we talk about "live", where do we start? "EQ Live" is constantly changing , for better and for worse (more worse than better). Years ago, Everquest belonged to Verant - it was a whole different game in those days. Nowdays, it belongs to the Sony Corperation, and the only thing the "Verant" version of EQ had in common with the current "SOE" version, is the name, "Everquest".
All these things like, higher level caps/skill caps, alt adv points kills the original EQ game and the old zones are rendered useless. places like South Karana that once boasted hundreds of players on a busy night, become empty "wastelands".
What is an emulator? how do we apply the word "emulator" to EqEmu?
Do we want to our server appealing to other players, or just ourselves? What do most players look for in this game?
First thing I did when I finally got a server running was invite some old gamer friends and gave them GM status; big mistake! since they were able to do anything in the game, they got bored real fast and were gone in a few days.
So how am I going to make something playable out of EqEmu, that would spawn interest and maybe capture a handful of players?
Here's my opinion , and I know many others agree;
- Before you open your server to the public, make sure special spawns and drops are as uncommon as they are on Live. If you want to know how rare, look at how I have things on my LoY zones and a few others I fixed. Setting spawns and drops should be a priority, plat should be very scarce - you should be able to start out looting sp's and gp's not pps. It should a little harder just to be able to acumulate plat for your first weapons and /or spells.
- Faction, alt/adv and all the rest, should be at the bottom of your "to-do" list - the only faction you need at first, is the KOS aggro the mobs have. You can do these things, but first you need an interesting, playable enviroment.

It's a shame so many people are "hiding in a corner" with their backs facing this project as a whole - the result is the big decline you see in the player base.
In a situation like this, you need real players and their input more than the abilty to keep a running server. You also need a constant flow of newly interested programmers, zone-spawners to the project as a whole (not rag-tag servers, we already have enough of those).

One thing I know for sure; I will never be able to make a "better" Everquest and top all the things Everquest had - If SOE hasn't been able to in all these years, I certainly will not either. The best I can do is try and make things as "Everquest-like" as possible (maybe add some of the better ideas SOE had at first), in hopes to spawn some interest in gameplay.

I'm one guy, and look at what I did - I want to do more and will. Crap! look at what Cavedude did all by his own little self! And I'm no "programmer" , mind you - just wanted to see an feel a few things I felt on live. Reality is, no matter how stupid and old any question seems in this forum, someone should try and answer because you'll never know who's the next "Cavedude" or" Angelox"- and you might have just pushed him out. A bunch of you posters here helped/trained me to do this work, so in return, I feel I "owe" you all - and what I do in EqEmu belongs to all of you, thus promptly posted.

But what if we had a group of people (on my train of thought) working on a common database that was being updated and POSTED TO THE PUBLIC almost daily? then we could have someone making/posting small SQL patches for the people who already have this "common database" installed. It would have to be done mostly via this forum, because if not, it would end up with another "small group" away from the main flow of users and players again.

After all, we do this so we can have fun and play a good, interesting game, no?
Reply With Quote
  #9  
Old 10-10-2006, 04:02 AM
eq4me
Hill Giant
 
Join Date: Jul 2006
Posts: 166
Default

Amen Angelox

ok, this is getting a litte OT bit here we go:
Tuning EQ for an population of well under 100 people per server is no easy task. Much of the thinks that are taken for granted by the Sony Developers are not there. Like the ability to buy or tradeskill for equipment well above the level to obtain it even with a full group. Also much of the world is deserted because anyone goes to the zone with the best loot and exp. On EQLive thist might be fine but imho not on EQEmu. There should be some way to make older zones, quests and items more appealing to players. How that could be done without making a custom DB I am still pondering.

Unfortunately most Players only want a fast fix of EQ, which they cant have on EQLive. They cant get fast enough to the highest level and get the best gear but are the first to cry for new content. Typically they get very agitated on each bugfix and 'nerf'.

The below is a thread I started on the Darktides forum, I was rather baffled by the response. It is a perfect example of how the average player thinks. Hell, even I could not contain myself and used every bug I found and reported until it was fixed.

http://www.atfreeforum.com/darktides...orum=darktides

A few more acerbic and bitter threads and ingame chats later I decided that my time was better spend helping the community.

Last edited by eq4me; 10-10-2006 at 12:14 PM..
Reply With Quote
  #10  
Old 10-10-2006, 04:59 AM
mattmeck
Guest
 
Posts: n/a
Default

Quote:
Originally Posted by Angelox
The only place I ever got any answers and help was in these forums; I tried the PEQ forums and got no interest and no replies.
I was not aware they have died off like this, I always send people to there because its always been *the* place to help out for a live like DB.

Not sure what to say.
Reply With Quote
  #11  
Old 10-10-2006, 06:25 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Unfortunately most Players only want a fast fix of EQ, which they cant have on EQLive. They cant get fast enough to the highest level and get the best gear but are the first to cry for new content. Typically they get very agitated on each bugfix and 'nerf'.
You have to separate the players from the non-players; by this I mean, the new Everquest has evolved into something like a giant "Chat" service where most people just want to show off their gear and brag about thier stats. To a point where people will buy ubber accounts, so they can get in on that train too. The raids became more like a place to go "hang out" at, and hope you win on a roll when the mob gets mass-killed.
The real players are different; they want to play! And since SOE is in it for the money, they want to keep all partys happy; So they started things like the "progression servers" - which brought a lot of players back into the game - meanwhile, the old servers were still there for the ones who like to chat and what- not.
Quote:
There should be some way to make older zones, quests and items more appealing to players. How that could be done without making a custom DB I am still pondering.
I think that ANY thing you make, be it custom or not - things have to be rare and hard to get. The game can't be "fast and easy" - when they are, people loose interest fast.

I would have never known that you don't speak good english, had you not said so.
Reply With Quote
  #12  
Old 10-10-2006, 06:31 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

Angelox, I agree with you on most things you just said. Bravo, and well stated, as usual. However, the problem I see with Emulators is population. If your server is "exactly like live" (or like live was back in the golden era of EQ), that means pretty slow progression - even WITH full groups/guilds of people. Anyone who used to play EQ has already played to level 50+ the slow way. Most want to stampede at 10x level bonus and get to "the good stuff" that they have missed since quitting. And, since most of that content is still missing or un-tuned, they play, kick a gods ass once or twice, get bored, and quit. I had the same experience as you, GM'd all my buddies who #level 255'd themselves and killed the entire world. and they are now gone. But, the world is there for them as-is should they get the desire.

I'd love to run a public server, one that's finely tuned. Hell, I'd love to offer mine now as-is, because I too am still amazed that this works! But, I do not have the time to be a GM, or programmer, or manage the data. My job is very busy, and my home life away from the computer is as well. So it's not all about people not caring or not wanting to contribute. Believe me, if I had the time, I'd be in there with you tweaking and doing all I could. I feel like a sponge sometimes, but that's my life ~grin~. Maybe someday...

All in all, good points from everyone. Oh, and my original thought about excessive loots dropping. If you are the only player in 10 zones on a given day, you will grow tired of never accomplishing anything, and leave that server for one that offers faster XP and more loot at young ages. That's my opinion, anyway.

(are we still on topic? hehe!) Good discussion though. As for PEQ site, I get responses there. Maybe it was an off week?
Reply With Quote
  #13  
Old 10-10-2006, 06:40 AM
sdabbs65
Dragon
 
Join Date: Dec 2003
Location: Earth
Posts: 818
Default ..

Quote:
Originally Posted by mattmeck
I was not aware they have died off like this, I always send people to there because its always been *the* place to help out for a live like DB.

Not sure what to say.
PEQ has not updated anything since Thu Mar 17, 2005.<last release>
they have been updateing quests and such but for databases nothing
new in a while.
it <WAS> the best Everquest live like database avaliable for EQEmulator tho
at that time.
__________________
hosting Eqemu/Runuo/wow Emulators.

www.cheaterz.info
Reply With Quote
  #14  
Old 10-10-2006, 06:44 AM
bobbydole
Fire Beetle
 
Join Date: Jul 2006
Posts: 26
Default

Wow.. I guess I didn't expect this kind of response, all I wanted to know was the best way of populating the zones based on packets collection. And it sounds like I can't just login to live and collect the NPC names, spawn locs and pathing info, because none of the packet collectors currently work with live. And i haven't been able to figure what to do with the packet files currently at www.projecteq.net/logs/ (which seems like they're what i'm looking for), eqbuilder/eqExtractor doesn't seem to work.. :(

So i'm unsure on the steps I should take next. I would like to get the zones populated as close to EQLive as possible, but i'm not sure I have the time to manually add the mobs to the zones. I don't know how long it would take compared with using the packet logs.

As for the problem with low population and stuff, I'm not really sure I care about that stuff right now. For me EQLive is the reference, which everything else should be based off of, so you want that as good as you can get it. Fine-Tuning it for your population size should be done by a server-by-server basis. So when i get PoD up and running, and submitted it to Angelox's DB or PEQ or whatever, people can do whatever they want with it. But there should always be that reference for every one to access. I think that's what the PEQ guys were aiming for, but it (appears) to be bogged down. That's why I think Angelox's DB is a good idea, like PEQ but with out the data restrictions.

However, getting back on topic, whats the best way of getting the zones populated?
Reply With Quote
  #15  
Old 10-10-2006, 06:53 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by John Adams
(are we still on topic? hehe!) Good discussion though. As for PEQ site, I get responses there. Maybe it was an off week?
I dunno, maybe they didn't like me - I'm sort of a "newbee" and can ask real stupid questions at times.
A lot of times, I can't see the sky because I'm standing under a tree - this results in a stupid question: "where did the sky go?"
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:06 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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3