5.9DR2 Alpha 1 Released!

Malignus Wingnut · #1 10-11-2004, 01:15 PM

This database is fully compatible with the current release of EQEmu, 5.9 DR2.

If has Classic through PoP spawned (minus poinnovation, potimeb, and nightmareb).

It has loot for every mob spawned as well as all items up through GoD.

Download can be located here:

http://home.comcast.net/~molimo140/5.9DR2_alpha_1.zip

~Enjoy.

sdabbs65 · #2 10-11-2004, 01:37 PM

Thanks
it works great.
this has saved me many hours of work..

Valkyeri · #3 10-11-2004, 01:43 PM

Good job ! Thanks a whole bunch.

Malignus Wingnut · #4 10-11-2004, 02:17 PM

For those who care, this is what this database is made of:

MW_057DR2_Alpha_1.sql
mwupdate.sql
aa.sql
aa_levels.sql
aa_timers.sql
altadv_vars.sql
FactionListUpdate.sql
FactionNpcUpdate.sql
FactionTablesUpdate.sql
kos.sql
allitems.sql

As well as the following command -

Code:

ALTER TABLE npc_types ADD COLUMN ac smallint(6) NOT NULL DEFAULT 0;

sdabbs65 · #5 10-11-2004, 02:24 PM

Quote:

Originally Posted by Malignus Wingnut

For those who care, this is what this database is made of:

MW_057DR2_Alpha_1.sql
mwupdate.sql
aa.sql
aa_levels.sql
aa_timers.sql
altadv_vars.sql
FactionListUpdate.sql
FactionNpcUpdate.sql
FactionTablesUpdate.sql
kos.sql
allitems.sql

As well as the following command -

Code:

ALTER TABLE npc_types ADD COLUMN ac smallint(6) NOT NULL DEFAULT 0;

small warning...
if you have PEQ 5.8 installed you will get doors that wont open..
in front of other doors.
I droped the doors SQL table and still have this issue hmmm

Malignus Wingnut · #6 10-11-2004, 03:00 PM

DO NOT source this database on top of an existing database

CREATE A NEW DATABASE.

Code:

create database NAME;

replace name with whatever...then

Code:

use NAME;

Then source....

Arcane · #7 10-12-2004, 12:40 AM

Silly question; but will this DB cause the server using it to become "Legit"?

sotonin · #8 10-12-2004, 01:09 AM

Being "legit" is determined by what commands you allow the players to have in the server's config.

finwe · #9 10-12-2004, 02:14 AM

i have a problem with this database... when u create a char u appear anywhere in the zone of spawnnn... inside blocls for example???

can it be because point of spawn r wrong in the database???

is outthere a solution????

tks and sorry for my english.

sotonin · #10 10-12-2004, 03:34 AM

It's a problem with alpha1 and classic that will be corrected in future releases. We've fixed a crapload of things for our kunark release including ALL start points, starting gear, etc. It will be great. Test it on PEQ The Grand Creation if you want to see it in action.

We'll eventually have a full pop one out as well, With all the kinks worked out. Right now the only pop able DBs are pretty buggy and comprised of our older dbs (merged in) with classic. The alpha1 was so messy and laid out horribly that it really just creates more problems merging it in with real zone info. Our classic and onward are cleaned up considerably and extraneous information removed.

Again, please help us test the db and the code so we can release kunark quickly and get started on velious!

Arcane · #11 10-12-2004, 06:58 AM

What kind of information do you need to help fix things? Does the database control where you pop from one zone to another or is that hard coded?

sotonin · #12 10-12-2004, 07:01 AM

The database controls that stuff. We just need ppl to play the game and find things that are wrong with it.

Arcane · #13 10-12-2004, 07:09 AM

Okay I'll try and detail some of the things I've found for you; I know there is an issue with going from Misty Thicket to the Planes of Knowlege in that you fall, hit the ground and lay there bleeding to death if you are a low level character

Another one is leaving Rivervale going in to Kithicor Woods, you start out at the wrong z coords and appear in darkness with no way to move. I am guessing these are the proper coords to pop in to the zone with, as they are just at the edge of the zone boundry:

x= 3825.0
y= 2022.0
z= 466.0
Heading 134.9

Another one where you have to walk out a ways then you plummet to your death is leaving Highhold Keep (??? Can't remember exactly the name) entering Eastern Plains of Karana the z is way to high; the coords I think should be as follows:

x= -8338.0
y= -3097.0
z= 693.7
Heading 14.3

If you want the information like that, I can continue to field it for you, if not I'll leave off with this post on this particular subject.

sotonin · #14 10-12-2004, 07:15 AM

Sorry i only deal with PEQ issues. and we are on kunark now. so POK is nonexistent.

I'll check out misty thicket on our server but im guessing its just happening on yours because of this 5.9 merged db has bad info from alpha1.

If these are from your own database / server then it doesnt really help. If you find these issues while playing on PEQ TGC then yes by all means report them here.....

http://www.peqserver.com/forums

Arcane · #15 10-12-2004, 10:23 AM

The one other than PoK are from the PEQ and the Alpha