MSH-DB v0.1 Released!

[DeletedUser]

Yes, you can have your very own MSH-DB v0.1 too!

This is the famous Merkur, Spud, Hogie DB run on Eros & Hogiebane. It is an addon for Drawde's db, and has real spots for mobs like in sebilis & ssratemple, etc.

You can find it at, doh, where did I put that link? Oh yeah, http://eqemu.net/mshdb/msh-db-v0.1.zip . Remember, it isn't supported, and read the text file in the zip file!!!!

[Ariak]

Very, Very nice.

[ninja_looter]

Thank you Hogie, I have always enjoyed your servers.

[_OZZY_]

Will a 0.3.2 compatible version of this be released?

[Shawn319]

No idea. unless someone converts this probably not because Merkur left and took the spawn collector with him :(

[Lurker_005]

*edit* Just finished putting everything into 1 big download to keep confusion to a minimum.

This is a bit quick and dirty.

Included is everything needed for the DB
db32.sql is the released EQEmu clean DB
I edited of Drawde's 0.85 DB edited for EQEmu 3.2
And I edited Merkur's msh-db-v0.1.zip to work with EQEmu 3.2

Useage

Put all the files into your mysql\bin dir
run mysql
create a new DB
mysql>create database eq32;
mysql>use eq32;
mysql>source go.sql;




*deleted*EQEmu3.2_Drawde0.85+_MSH0.1.zip
Just add the original MSH_db_0.1 to Drawde's 0.95 there will be some errors, but it should only affect some 20 spawns out of 26000

[_OZZY_]

Whoa is this a beauty! Thanks a whole lot Lurker! The speed of the updates to 3rd party tools is excellent!

[Shawn319]

Dont forget, if u use "eq32" as the DB, you need to change database= to say eq32 in db.ini

[Shawn319]

and this go.sql looks kinda wierd.

source db32.sql;
source msh.sql;

delete from npc_types;
delete from spawn2;
delete from spawnentry;
delete from spawngroup;
delete from npc_faction;
delete from faction_list;
delete from merchantlist;
delete from lootdrop;
delete from loottable;
delete from lootdrop_entries;
delete from loottable_entries;
delete from starting_items;
delete from tradeskillrecipe;

source npc_types.txt;
source spawn2.txt;
source spawnentry.txt;
source spawngroup.txt;
source npc_faction.txt;
source faction_list.txt;
source merchantlist.txt;
source loot.txt;
source starting_items.txt;
source tradeskillrecipe.txt;

The first two lines will source both DB's in, next you completely delete all spawn data from the DB????? that would clear out MSH also which doesnt get re-sourced in later.

Wierd =P

[Read_Me_txt]

No spawns in Ssra and crashes the zone server when entering GFay, <shrug> I dont protest to know anything :P just reporting a bug.

[Shawn319]

Well with the way go.sql is setup its no wonder all of the MSH spawned zones will be empty.

[Lurker_005]

/EM Smacks himself really hard!

Shawn, your right.

source msh.sql;

Needs to be the last line.

If you already have the DB, just edit go.sql (it is just a text file) and move that line to the end. Then drop and re-install the DB

I have also fixed the file linked above for anyone new getting it.

[Shawn319]

and might as well leave out the first "source msh.sql" because it all gets cleared out in the next few lines (of go.sql).

just wait till its all done to source msh.sql......



=)

[Lurker_005]

This is basically the same as the DB I posted above, but I used the table format from the EQEmu3.1 release for npc_types.

This seems to get rid of the error in zone.exe See how this works (less crashes, droping to login screen?)

*deleted*eqemu3.2_DB_test.zip
The original MSH_db_0.1 can be applied to 0.95 with only a few errors (20 or less)

[Shawn319]

ummm if the npc_types changed since 0.3.1 then a 0.3.1 npc_types table structure will not workin 0.3.2 :(


why do you think we release a new db.sql with every release? its because we want people to get it working hehe.