EQEmulator Forums - MW_057DR2_alpha

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)

- - MW_057DR2_alpha_1 RELEASED!! (https://www.eqemulator.org/forums/showthread.php?t=13653)

MW_057DR2_alpha_1 RELEASED!!

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

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

Awesome job, like always.
Thanks.

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

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.

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 :)

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

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 :)

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 :)

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

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

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!

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

-astro

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.

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?