Myra spawn db

Myra · #1 12-12-2003, 02:42 PM

OK, it took a while, but here's what I have. I took the Drawde's old 4.4 DB and Telmet's old 4.3 DB, converted to 5.0 and then merged zones from each together.

The result is spawns,loot,merchants and factions for over 140 zones:

acrylia
airplane
akanon
akheva
bazaar
befallen
beholder
blackburrow
burningwood
butcher
cabeast
cabwest
cauldron
cazicthule
charasis
chardok
citymist
cobaltscar
commons
crushbone
crystal
dalnir
dawnshroud
dreadlands
droga
eastkarana
eastwastes
echo
ecommons
emeraldjungle
erudnext
erudnint
erudsxing
everfrost
fearplane
feerrott
felwithea
felwitheb
fieldofbone
firiona
freporte
freportn
freportw
frontiermtns
frozenshadow
fungusgrove
gfaydark
greatdivide
griegsend
grimling
grobb
growthplane
gukbottom
guktop
halas
hateplane
highkeep
highpass
hole
hollowshade
iceclad
innothule
kael
kaesora
kaladima
kaladimb
karnor
katta
kedge
kerraridge
kithicor
kurn
lakeofillomen
lakerathe
lavastorm
letalis
lfaydark
maiden
mischiefplane
mistmoore
misty
mseru
najena
necropolis
nektulos
neriaka
neriakb
neriakc
netherbian
nexus
northkarana
nro
nurga
oasis
oggok
oot
overthere
paineel
paw
permafrost
qcat
qey2hh1
qeynos
qeynos2
qeytoqrg
qrg
rathemtn
rivervale
runnyeye
scarlet
sebilis
shadeweaver
shadowhaven
sharvahl
sirens
skyfire
skyshrine
sleeper
soldunga
soldungb
soltemple
southkarana
sro
sseru
ssratemple
steamfont
stonebrunt
swampofnohope
templeveeshan
tenebrous
thedeep
thegrey
thurgadina
thurgadinb
timorous
tox
trakanon
tutorial
twilight
umbral
unrest
veeshan
velketor
vexthal
wakening
warrens
warslikswood
westwastes

Its nothing special. Nobody moves. But its a start, and more than the Scorpious2k server had to start with 6 months ago.

Scorp thinks there could be trouble with items (not included). The items in the tables are from the 4.4 items table and there are a lot of changes in 5.0. You may need to check these out.

I am not taking credit for the work here, I have only taken the great efforts by Drawde and Telmet, changed numbers and merged them together to make a big collection of spawns.

It only contains spawn/loot/npc/faction tables. You MUST first source db.sql which came with the EQEMU package.

I don't have anywhere to host it yet. :-( If anyone would like to test it out for me, send me a PM and we can figure out how to get you a copy...

Migs · #2 12-12-2003, 05:49 PM

Excellent work, this will surely help things move along faster.
My question is this.. do you know which zones you are missing? *IF any at all* :P

:P

rockocool · #3 12-12-2003, 06:13 PM

Great, this is something I will definitely merge into the tcsmyworld DB I am currently using for 5.2 server. I will just check out the Mobs part. I think the spawn table are same for 5.0 and 5.2 am I right? Then I should be able to source in the rows for spawns with no need of change. Thanks, Myra!

Kroeg · #4 12-12-2003, 08:41 PM

I would definitely back up your existing db if I were you before doing that

Scorpious2k · #5 12-13-2003, 12:58 AM

Quote:

Originally Posted by rockocool

Great, this is something I will definitely merge into the tcsmyworld DB

This can be very difficult depending on what you have in mind, as Myra could tell you if she was awake at the moment

.

If you are going to replace the current db with what's in Myra's and keep the rest, no problem. But if you want to keep the spawns already there, you are in for some major work. I'll be glad to explain if you'd like.

omper · #6 12-13-2003, 04:25 AM

listen to the wize Scorpious2k. What you are planning can be overwhelming.

Omper

rockocool · #7 12-13-2003, 09:35 AM

In fact, I am going to leave the zones that have already been spawned in tcsmyworld's db intact (especially those with moving mobs), and then for those zones that are empty, I will source in spawns from this db (since it's a combine of telmet and Dwarde's I trust the quality), for example, texthal. Players in my server kept asking for mobs in high lvl zones like texthal, which are currently empty. Do u guys think this is doable or not? I understand merging mobs for already poped zones could give me quite a bit of work to do, and may not be worth it.
Anyway, wont be able to get my hands on this Until Sunday night. Will backup my db, then play with it.

devn00b · #8 12-13-2003, 12:33 PM

being an expert of Telmets db (he and i did ALOT of work together on that db). It shouldnt be compatable with TCS's db at all, ive looked at them.

While Telmets was once based on drawde's they are too different. and the results wouldnt be wortht your time.

I have telmets converted to the current DB standard, and may release it here soon..possibly as an offical eqemu database.

No offense to TCS, but Telmets is far more advanced (minus pathing) in the sense that its cleaner (has far far far fewer bad spawns).

cybermax · #9 12-13-2003, 01:14 PM

Pls toss me this DB with spawns :P I would like to have spawns in most zones, rather than moving in few.. I love the moving db no doubt, but it gets rather boring killing guards in freeport heh..

Anyway.. PM me if you have no place to host this, to figure out how we can exchange this.. (Mail, some temp ftp, messenger.. whatever).

Myra · #10 12-13-2003, 02:00 PM

There are items missing from the 5.x database that were in the 4.4 and these missing items were used as loot and in merchant lists. This will cause problems for you, I would like to fix it before I release it. (Give me a day or two :P)

cybermax · #11 12-13-2003, 02:33 PM

Sure thing

Myra · #12 12-14-2003, 04:04 AM

Well, I'm done! I'm ready for people to test it. Any victims, I meen volunteers?

AK1122 · #13 12-14-2003, 04:15 AM

me me!

Wumpas · #14 12-14-2003, 04:17 AM

I would love to be a victim I mean a "Volunteer"

I have a few days off here and would love to check out your database.

Thank you for the hard work Myra Ive been dabling with TCS database for a cople days now and its nothing short of amazing anyone can do anything with the databases.

AK1122 · #15 12-14-2003, 04:45 AM

http://m77.host.sk/AK1122/MyraDB.zip
nuff said