Myra spawn db

[Myra]

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]

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 :D :P

[rockocool]

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]

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

[Scorpious2k]

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]

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

Omper

[rockocool]

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]

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]

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]

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]

Sure thing :)

[Myra]

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

[AK1122]

me me!

[Wumpas]

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]

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

[Wumpas]

For those with problems with that link try rightclick save worked for me

Is this a complete database I tried sourcing it by itself and it gave alot of 1046 errors next I tried sourcing it into the db.sql with 0.5.2-Update then it gave me colum number dosent match value errors.

how exactly does one source the myra database?

Do i create all the tables manuly before sorcing and if so what are the table and field parameters?

thank you for your help im going to continue to dink around with it mabe ill solve my own problem :D

[cybermax]

This is a "spawn only" db Womp.. You need to eg. modify the MW db to use theese spawns instead.

Ill do some testing, and see what i can come up with.. (Now if someone would fix the still messed up zone points, i would be happy as a .. well.. whatever)

[Wumpas]

Ok thanks makes more sense now hehe

Do I drop tables then and then source this if so which tables need to go?
I will experiment with this myself (not on my working DB) ill see if i can figure it out thank you the help

most zone points have been right on for me im using

MW_051_052_alpha1.sql
0.5.2-Update.sql

only unfinished one ive found are on luclin and the hole

EDIT -- I remeberd I can brows though the sql in notepad ill figure out the tables I need to drop myself I think---

i discoverd droping the tables is a bad idea as well instead i think i half to clear the data in tables

faction_list
items
lootdrop
lootdrop_entries
loottable
loottable_entries
merchantlist
npc_faction
npc_faction_entries
npc_spells
npc_spells_entries
npc_types
spawn2
spawnentry
spawngroup

after this source Myradb.sql?

Am i correct with this asumption?

[Scorpious2k]

Am i correct with this asumption?

Yes, she fixed it so that it could be used after the standard release db is installed

[cybermax]

Since the myradb does not contain how to create the different tables, you need to not only drop them, but create them new..

I got the create strings from db.sql that comes with 5.2, and then did this to each different table in myradb :

DROP TABLE npc_faction;
CREATE TABLE npc_faction (
id int(11) NOT NULL auto_increment,
name tinytext,
primaryfaction int(11) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

Ie.. first i drop the table npc_faction, then i create it (with the data from the db.sql), then i source in myradb info here..

DROP TABLE npc_faction;
CREATE TABLE npc_faction (
id int(11) NOT NULL auto_increment,
name tinytext,
primaryfaction int(11) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

INSERT INTO npc_faction VALUES (1,'Aagron_Faction',311);
INSERT INTO npc_faction VALUES (2,'Aanina_Rockfinder_Faction',108);
INSERT INTO npc_faction VALUES (3,'Aarina_Ratsbone_Faction',108);
INSERT INTO npc_faction VALUES (4,'abandoned_heretic_pet_Faction',302);

And so on.. this has to be done for each table listed in the db.

And it worked :)

EDIT: Dont delete the items table tho.. cos myra db only have some adds for this, and not the complete db items. (Due to some spawn loots was not listed in the default items db)

the only problems i see so far, is some faction issues (wich i should be able to tweak myself if i can figure out how to).. ie. no "mobs" are kos to me..

Still have some difficulties with the zone points tho.. Could you try to create some NEW characters Wumpas? Ie. not just #zone your current caracter around, but create new one.. Human agnostic monk++ cos i cant seem to get much working other than the froglok pally starting in gukta. (i can then move my human monk over to the bazaar and start playing tho..)

[Wumpas]

all i did was ( you did alot mroe than you needed to hehe)

sourced MW_051_052_alpha1.sql
sourced 0.5.2-Update.sql

describe faction_list


look at the id field and use that with a comparison operator to clear the data

DELETE FROM faction_list WHERE id >= 0;

I repeated for every table in my above post

i then sourced myrasdb did my grant and account insert

P.S. im in freeport right now with human monk works great

EDITED ***Myra has fixed this now all bow to her***

[AK1122]

create database eq;
use eq
source db.sql
source myradb.sql
source itemdump.sql

thats it
dont need to drop create n stuff

[AK1122]

uploading new archives.. included in there is a for dummies file =)

[Wumpas]

Thank you myra and ak1122 i love your documentation

Sword of Banning+1

That is going in my favorite_quotes.txt

Hilarious

Im going to set this database up right now

As to the method I explained in above posts for he original version of this file It may be flawwed all the merchants tell me to leave them alone im not in the magition class guild blah blah

But mob factions worked well those orcs hated me heh

Ill run this version and see if the merchant issues are anny diffrent.

resaults pending

thank you so much myra and ak1122

RESULTS

This could be my error but ak1122 I think thers a problem

for one itemdumps.sql??? you mean dumpeditems.sql correct?

this was my order

create database myrab;
source db.sql;
source myradb.sql

(this is as far as i got as my pc speaker made my head explode)

I also tried using your sourcethisfordummies.sql and this prodeced the same result.

not sure whats up there but Im going to mess around with it some more and if I find anything ill let you all know.

Thanks again Myra

I sourced db.sql

then sourced myradb.sql

got about 5 billion
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1

and it's not logging in I would say this one needs a little more twinking probbly just a small fix before it's useable.
great add on tho once you get it working I had to remove a few things and it works fine.

[Bearik]

ERROR 1136: Column count doesn't match value count at row 1

Getting the same.

[Scorpious2k]

sounds like a table changed. any idea which one is producing the error?

[cybermax]

P.S. im in freeport right now with human monk works great

Hmm.. If i create a Human monk on "Tranquil" deity, it will have starting city of West Freeport. I can create the character, but when i press "Enter World", zone.exe will crash.. over.. and over.. and over.. and guess what? over again..

Same for a "Agnostic" monk that start in Qeynos. Also same for many many others.. Ie. High Elf Palladin, Halfling Ranger.. i can make a list, but i frankly think i wont bother cos it has to be some weird stuff happening at my house then?

I have done this :
Created database named eq.
Sourced MW_051_052_alpha1.sql Dated 27.11.2003 (11:14)
Sourced 0.5.2-Update.sql (that came with the precompiled 052 binaries)

Made my accounts, made characters.. but very few of them i can create a NEW character and press "Enter World" without a crash.

I can however (as i posted before), create a Froglok Paladin in Gukta. Then when i log this on, i use #movechar Mymonk Bazaar, and i can then log on my monk wich then is in the bazaar.

Please verify that you have created a NEW human monk, both agnostic and tranquil, and pressed "Enter World" with using the above database and the update. (Not only use #zone freportw).

If this works for you with the above dated DB, i am totally lost.. :P

[cybermax]

And to why the myradb is not 100% up date with the 052 db.sql, here is what i found to be different :

Table structure of npc_types has ADDED this :
lastname varchar(32),

There is also some changes in the "items" table.. i cannot figure out how to change this to be right tho.. :( I tried to compare the items table structure from the one i got working to the default "db.sql", but could not find any differences.. its getting late here.. hehe.. going bliiiing :P

[Scorpious2k]

And to why the myradb is not 100% up date with the 052 db.sql, here is what i found to be different :

Table structure of npc_types has ADDED this :
lastname varchar(32),

Caught that and fixed it, thanks.

There is also some changes in the "items" table

The items in her DB are actually right - db.sql is wrong for items. If you d/l the items dump db and source it first, the items in her db will be fine. She will have the other fixed soon.

[cybermax]

Oki.. for now doing it in this order then :

source db.sql
source dumpeditems.sql
ALTER TABLE npc_types DROP lastname;
source myradb.sql
ALTER TABLE npc_types ADD lastname VARCHAR(32) AFTER name;

And that took care of that for now :)

[Scorpious2k]

Good solution :-)

[AK1122]

Scorp, Myra

I think you just need to source with older db.sql and run 052-update.sql

When u have a working db email it to me so i can reupdate host :D

[Scorpious2k]

When u have a working db email it to me so i can reupdate host :D

She got it all done last night, but didn't get a chance to send it out. She's in school right now, but will be able to send it out when she gets home.

[Scorpious2k]

Here's a fix in the meantime for the merchant problem:

# shopkeeper, banker, beastlord gm, enchanter gm, magician gm
update `npc_types` set class=41 where class=32;
update `npc_types` set class=34 where class=31;
update `npc_types` set class=33 where class=30;
update `npc_types` set class=32 where class=29;
# wizard gm, necro gm, shaman gm, rogue gm, bard gm
update `npc_types` set class=31 where class=28;
update `npc_types` set class=30 where class=27;
update `npc_types` set class=29 where class=26;
update `npc_types` set class=28 where class=25;
update `npc_types` set class=27 where class=24;
# monk gm, druid gm, shadowknight gm, ranger gm, paladin gm
update `npc_types` set class=26 where class=23;
update `npc_types` set class=25 where class=22;
update `npc_types` set class=24 where class=21;
update `npc_types` set class=23 where class=20;
update `npc_types` set class=22 where class=19;
# cleric gm, warrior gm & banker
update `npc_types` set class=21 where class=18;
update `npc_types` set class=20 where class=17;
update `npc_types` set class=40 where class=16;

[Bearik]

Hats off to you Myra, this DB is A+

Testing it out on my server, so far no problems other than a crash in Tox. Sourcing it in is a bit messy but i'm sure we can get it a little smoother :)

And Scorp thanks for that fix.

[Myra]

When u have a working db email it to me so i can reupdate host :D

She got it all done last night, but didn't get a chance to send it out. She's in school right now, but will be able to send it out when she gets home.

Sent. :wink:

[rockocool]

I just source this DB and use eqadmin to check which zones are poped, and it seems it's missing most of the planes, which are poped in telmet's DB. ;) So great job Myra, but if you could add in those missing zones from telmets, it would be a plus! :P

[rockocool]

Is this included in the updated myraDB or not yet?

Here's a fix in the meantime for the merchant problem:

# shopkeeper, banker, beastlord gm, enchanter gm, magician gm
update `npc_types` set class=41 where class=32;
update `npc_types` set class=34 where class=31;
update `npc_types` set class=33 where class=30;
update `npc_types` set class=32 where class=29;
# wizard gm, necro gm, shaman gm, rogue gm, bard gm
update `npc_types` set class=31 where class=28;
update `npc_types` set class=30 where class=27;
update `npc_types` set class=29 where class=26;
update `npc_types` set class=28 where class=25;
update `npc_types` set class=27 where class=24;
# monk gm, druid gm, shadowknight gm, ranger gm, paladin gm
update `npc_types` set class=26 where class=23;
update `npc_types` set class=25 where class=22;
update `npc_types` set class=24 where class=21;
update `npc_types` set class=23 where class=20;
update `npc_types` set class=22 where class=19;
# cleric gm, warrior gm & banker
update `npc_types` set class=21 where class=18;
update `npc_types` set class=20 where class=17;
update `npc_types` set class=40 where class=16;

[Scorpious2k]

The merchants are fixed in what she sent to AK1122, if he has the new version up for download.

[Myra]

All the bugs are worked out, and a host has been found.

http://www.bossmob.com/Myra/MyraDB.zip

Create the database, source the latest db.sql, items, then source my db. Thats it.

[Myra]

I just source this DB and use eqadmin to check which zones are poped, and it seems it's missing most of the planes, which are poped in telmet's DB. ;) So great job Myra, but if you could add in those missing zones from telmets, it would be a plus! :P

I get of school next week, I have to have something to do. (I'm doing it next week for those who want me to spell it out for them.)

[cbarnes]

Ok I noticed that the file is the exact file (time, date, size) as the one that was posted earlier. I'm still getting the same errors (Error 1062: Duplicate.. etc)

Any ideas?

I believe I'm doing everything correct, its just erroring out on the Myradb.sql source part.

Thanks in advance

[Bearik]

I'm getting tons of errors, mostly duplicate blah blah.

The last one didnt do this using cybermax' method though

[AK1122]

Sorry am on work trip atm... had 2 hours notice before having to jet :S

am testing stuff, there are a FEW spawns that are messed up (im guessing that the spawns were messed in telmet's or drawdes)

As soon as im back (jan 2nd) gnna start the real testing on the DB.. till then, good work Myra :D

(please update ur first post with the URL thou, helps) :D