MW_057DR2_alpha_1 RELEASED!!

wize_one · #1 05-08-2004, 12:36 PM

you wanted it, well it's up and out. head to www.projecteq.net and grab it from the downloads section!

DB has some incomplete info. ie merchants, base factions, etc

Description: new collected database, with pathing(149 zones) you will need to change EMUsharemem/NPCTypes.h from 200000 to 400000 and recompile it. if you do not parts of the database will not work..

like what it has? please go to www.projecteq.net/logdump to see how you can assist with filling the other zones.

Code:

acrylia		akanon		akheva		bazaar		befallen		beholder		blackburrow		bothunder		burningwood		butcher
cauldron		cazicthule		chardok		citymist		cobaltscar		codecay		commons		crushbone		dawnshroud		dreadlands
droga		eastkarana		eastwastes		echo		ecommons		emeraldjungle		erudnext		erudsxing		everfrost		fearplane
feerrott		felwithea		felwitheb		fieldofbone		firiona		freporte		freportn		freportw		frontiermtns		frozenshade
fungusgrove		gfaydark		greatdivide		griegsend		grimling		gukbottom		guktop		halas		highkeep		highpass
hohonora		hohonorb		hole		hollowshade		iceclad		innothule		jaggedpine		kael		kaladima		kaladimb
karnor		katta		kedge		kerraridge		kithicor		lakerathe		lavastorm		letalis		lfaydark		mistmoore
misty		mmcj		mseru		najena		natimbi		nedaria		nektulos		neriaka		neriakb		neriakc
netherbian		nexus		northkarana		nro		nurga		oasis		oggok		overthere		paineel		paludal
permafrost		poair		podisease		poeartha		poearthb		pofire		pojustice		poknowledge		ponightmare		postorms
potactics		potimea		potimeb		potorment		potranquility		povalor		powater		qcat		qeynos		qeynos2
qeytoqrg		qinimi		rathemtn		rivervale		ruji		runnyeye		scarlet		sebilis		shadeweaver		shadowhaven
sharvahl		sirens		soldunga		soldungb		solrotower		southkarana		sro		sseru		ssratemple		steamfont
stonebrunt		swampofnohope		takd		templeveeshan		tenebrous		thedeep		thegrey		thurgadina		thurgadinb		tox
trakanon		twilight		unrest		veeshan		velketor		wakening		warrens		westwastes

Gossamer · #2 05-08-2004, 05:22 PM

*Bows to the powers that be*
Thank you, thank you! Going to get it now to try it out )

KhaN · #3 05-08-2004, 08:06 PM

Awesome job, like always.
Thanks.

vetoeq · #4 05-09-2004, 05:29 AM

Great work guys, I can't wait to try it out...now if I can just get some free time!

govtcheeze · #5 05-09-2004, 07:22 AM

I just confirmed with TCS that the 2 updates I wrote (loot and faction) were included in this release, so you do NOT need to source them.

gthang187 · #6 05-09-2004, 04:29 PM

im looking through the commands to see if there is a way to update the lines. wich will overwrite whats already in the database.

But i cant seem to find a mysql command to do this if you know how or the command to take the old alpha stuff out please let me know thanx

wize_one · #7 05-09-2004, 04:44 PM

create a new db.. then change the db you have listed in db.ini to the new one.

govtcheeze · #8 05-09-2004, 05:01 PM

I HIGHLY advise correcting your .sql file with the below fixes and resourcing the sql.

FYI, when I sourced I got he following output:

Code:

C:\mysql\bin>mysql -f eq&lt;MW_057DR2_alpha_1.sql
ERROR 1061 at line 18254: Duplicate key name 'slotid'
ERROR at line 21993: Unknown command '\\'.
ERROR 1064 at line 21993: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'The dead must rest\\"","1","0","0","-1
","0","0","255","0","3276
ERROR 1061 at line 169041: Duplicate key name 'account'

C:\mysql\bin>mysql -f eq&lt;MW_057DR2_alpha_1.sql

To fix these errors, you have to change the following lines:

Delete (in inventory table):

Code:

20484:   KEY slotid (slotid),
20485:   KEY slotid (charid)

and replace with:

Code:

  UNIQUE KEY slotid (slotid,charid)

Delete (in items table):

Code:

 24217: INSERT INTO items VALUES("5701","0","Engraved Di'Zok Deathbringer","0","0","0","0","0","15","0","0","4","0","0","0","0","0","15","0","0","0","0","0","0","0","0","0","0","-1","","22","0","0","1","0","16","0","22","0","0","0","0","0","0","0","0","0","0","0","0","","0","0","0","0","581","IT178","0","3","50","0","*an inscription reads \\"The dead must rest\\"","1","0","0","-1","0","0","255","0","32767","0","0","0","0","1","0","0","0","0","8192","662","0","0","0","0","0","0","0","1","-1","0","-1","0","0","0","0","0","0","0","0","0","0","0","0","0","0","2003-10-03 20:29:09","50","","0","0","0","0","0","0");

and replace with:

Code:

INSERT INTO items VALUES("5701","0","Engraved Di'Zok Deathbringer","0","0","0","0","0","15","0","0","4","0","0","0","0","0","15","0","0","0","0","0","0","0","0","0","0","-1","","22","0","0","1","0","16","0","22","0","0","0","0","0","0","0","0","0","0","0","0","","0","0","0","0","581","IT178","0","3","50","0","*an inscription reads \"The dead must rest\"","1","0","0","-1","0","0","255","0","32767","0","0","0","0","1","0","0","0","0","8192","662","0","0","0","0","0","0","0","1","-1","0","-1","0","0","0","0","0","0","0","0","0","0","0","0","0","0","2003-10-03 20:29:09","50","","0","0","0","0","0","0");

Delete (in sharedbank table):

Code:

171271:   UNIQUE account (acctid),
171272:  UNIQUE account (slotid)

and replace with:

Code:

  UNIQUE KEY account (acctid,slotid)

Not sure if these errors were causing the inventory stuff before, but no more errors when sourcing

tcsmyworld · #9 05-09-2004, 07:34 PM

I fixed those errors and uploaded the repaired version.
For some reason when I dump the DB info with MySql-Front it puts the Unique and Key fields into seperate lines.

*Note to self- check these on every dump*

Hope you all enjoy the new DB.
As always , a BIG THANKS to the Team , and our group of collectors for a Job Well Done

Jezebell · #10 05-10-2004, 05:27 PM

For some reason Potimeb only has 2 mobs in it and Sleeper is completely empty, these zones were populated in the previous releases.

wize_one · #11 05-10-2004, 05:37 PM

this is a new db, with only collected data.. more people collect the more zones that will be populated

DataMan4971 · #12 05-11-2004, 12:40 AM

Thanks a bunch EQEMU dev team!! Woot this is so fuxxoring awesome man, i remember back in 4.4 when it was a wee baby.

Now!! Its 5.7 DR2 !! Holy dont make me say it!

astrokitten · #13 05-18-2004, 02:24 AM

I run a server that uses the MW55 alpha 1 and 2 db. I checked this db out on another one of my boxes and think its wonderfully done. I would really love to update my server to use this db instead of the ones I have been using, but the thing is I have put alot of work into the MW55 db, ie adding/changing loot and mobs. So to get to my question....I know there must be a way from me to grab that info from my old database, but I havent a clue how.

So if anyone could clue me in on how to transfer my tweaked mobs and loot from my old db to this new one I'd be extremely grateful

-astro

tcsmyworld · #14 05-18-2004, 03:48 AM

Sorry to say, AstroKitten, but the new release is a completely new DB, meaning all npcID's have changed.
The only way to get your custom info into it, will be to re-add them by hand.
We are working on getting a complete collected DB together, including all mechants and pathing for all zones.

rizzen04 · #15 05-18-2004, 04:16 AM

In your new database is there anything else to source other then the tables.sql that is listed on projecteq.net and your new file?

In the cvs I see tons of sql files, are those not needed?