Fixed 0.95 spawn data to work with EQEMU 0.3.3.1

[Drawde]

http://www.innersystems.com/~drawde/worlddata0.95.zip
I've uploaded a new version of my world data DB addon which is fully compatible
with EQEmu 3.3.1 (it has the missing npc_types tables back in). It doesn't have any
major changes since the last version, apart from slightly improved/debugged merchant lists.
I know some people have created fixes to get earlier versions to work with 3.3.1, but I thought that
releasing a fixed version would make things easier.
The next version should hopefully have more tradeskill recipes (alchemy and poison), spawns
for some more Velious zones (such as Tower of Frozen Shadow) and maybe some books. As you might expect from the numbering, version 1.0 probably won't be the final one!
(Might be a while though since I've just got the hang of using the NWN editor demo!)

[Shawn319]

Can you try to merge MSH DB into yours then release it? it would save us all alot of time :)

[Drawde]

I'll have a look at the MSH DB and see what I can do.

[Nylacra]

What the difference between drawde's DB and MSH database?

:confused:

[Trumpcard]

MSH is a addon to his.. It goes over what his puts in and makes several updates in other zones. It was generated using a spawn collector program Merkur developed.

Puts Drawde's in, then add MSH afterwards..

[Shawn319]

should be very easy drawde, it was made to append your database. (0.85 i think it was)

[Lurker_005]

Nice Drawde. I'm glad ya released this, I think I was making a mess of the 0.95 thread :rolleyes:

*edit* I have looked at MSH with 0.95 some, it would seem there aren't too many errors, it should work ok.

[Lurker_005]

Adding MSH_db_0.1 to Drawde's 0.95 does seem to work.

For some reason I thought there were a LOT more errors, I was wrong. I loaded the 3.3.1 DB, Drawde's 0.95 for 3.3.1, then MSH_db_0.1 and it worked rather well. I havn't played using the DB yet though.

Attached is the sql file I used to import it all, see go.sql for more info. Also included is the list of erors encountered. So others know what to expect, and to make it easier to fix the errors.

[O6scured]

Lurker,
In MSH db you included a *fixed db* we use that or the original one posted by hoogie?

[Lurker_005]

The original.

Guess I should delete the obsolete one to reduce confusion.

[morpheus014]

I was wondering if someone could clarifiy this for me-- Did 3.3.1 put back the tables that were removed from the 3.2 DB or am i mistaken on this.. if so I am going to try my old 3.1 db and see if it works...

[O6scured]

Lurker,

It failed on me. I made a fresh database called eq and ran go.sql... went downstairs and had some cake and came back to find repeating errors of count of row does not match value or whatever. not sure what stage it was in. I used 3.3.1 db and the go.sql in the .zip u had and the msh.zip... Any ideas?

[Lurker_005]

O6scured,
you forgot Drawde's 0.95, Take a look at go.sql for more info

Morpheus,
The npc_types reverted, But there are other changes. If you want to know more, earlier I posted a sql file that should get a 3.1 DB updated to 3.3.1 page 2 here (http://forums.eqemu.net/attachment.php?s=&postid=12190)

[O6scured]

lol figured out why it failed... I had ver 3.2 db.sql in from when I was using the converter... oops

[kachime]

i'm not fond of the MSH myself
loaded that and found Dark Elves and Ogres in Cabilis! (ICK!)
heh
not to mention a few of the basic Iksar spawns weren't really working properly (they were underground)
question though.
how do i fix Factions so Iksar are KoS to others and so on and so forth?
and anyone know how to get NPC's to follow commands (like get groups to fight and ransack a zone or something)

[morpheus014]

O ok thx a bunch lurker, I have nice DB from 3.1.1 that ive been working on for a while, want to try and continue using it :) thx again for the clarification