|
|
 |
 |
 |
 |
|
 |
 |
|
 |
 |
|
 |
|
Archive::Database/World Building Archive area for General Discussion's posts that were moved here after an inactivity period of 90 days. |
 |
|
 |

05-08-2004, 12:36 PM
|
Dragon
|
|
Join Date: Jan 2004
Location: LasShithole, NV
Posts: 520
|
|
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
__________________
Perfect quote from another site: it's immature pricks who refuse to read the numerous stickies in every forum pointing out what to do and what not to do that get flamed. Grow up and learn to do your fucking homework before opening your cake hole, junior. EQEmu doesn't like you anymore, and that's why you're getting errors. So go away.
__________________
|
 |
|
 |

05-08-2004, 05:22 PM
|
Sarnak
|
|
Join Date: Apr 2004
Posts: 92
|
|
*Bows to the powers that be*
Thank you, thank you! Going to get it now to try it out )
|

05-08-2004, 08:06 PM
|
 |
Dragon
|
|
Join Date: Mar 2004
Location: France, Bordeaux.
Posts: 677
|
|
Awesome job, like always.
Thanks.
__________________
|

05-09-2004, 05:29 AM
|
Hill Giant
|
|
Join Date: Apr 2003
Posts: 125
|
|
Great work guys, I can't wait to try it out...now if I can just get some free time!
|

05-09-2004, 07:22 AM
|
Hill Giant
|
|
Join Date: Mar 2004
Location: South Florida
Posts: 247
|
|
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.
|

05-09-2004, 04:29 PM
|
Sarnak
|
|
Join Date: Dec 2003
Posts: 53
|
|
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 
|

05-09-2004, 04:44 PM
|
Dragon
|
|
Join Date: Jan 2004
Location: LasShithole, NV
Posts: 520
|
|
create a new db.. then change the db you have listed in db.ini to the new one.
__________________
Perfect quote from another site: it's immature pricks who refuse to read the numerous stickies in every forum pointing out what to do and what not to do that get flamed. Grow up and learn to do your fucking homework before opening your cake hole, junior. EQEmu doesn't like you anymore, and that's why you're getting errors. So go away.
__________________
|
 |
|
 |

05-09-2004, 05:01 PM
|
Hill Giant
|
|
Join Date: Mar 2004
Location: South Florida
Posts: 247
|
|
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<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<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 
|
 |
|
 |

05-09-2004, 07:34 PM
|
 |
Discordant
|
|
Join Date: Feb 2002
Posts: 452
|
|
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 
__________________
Founder PEQ (ProjectEQ)
|

05-10-2004, 05:27 PM
|
Discordant
|
|
Join Date: Feb 2004
Location: Florida
Posts: 441
|
|
For some reason Potimeb only has 2 mobs in it and Sleeper is completely empty, these zones were populated in the previous releases.
__________________
Eru, the Creator of Arda
ServerOwner for The First Age
An EQEMulator Roleplaying [Custom-Legit] Server
The First Age Website
Running on: Asus A7N8X-Deluxe, AMD Athlon XP 2100+, Geil 1024MB PC3200 Ultra DDR RAM,
WD 40GB 7200rpm ATA-100 HDD, Visiontek 128MB Geforce4 TI 4400, Windows XP Pro SP2
|

05-10-2004, 05:37 PM
|
Dragon
|
|
Join Date: Jan 2004
Location: LasShithole, NV
Posts: 520
|
|
this is a new db, with only collected data.. more people collect the more zones that will be populated
__________________
Perfect quote from another site: it's immature pricks who refuse to read the numerous stickies in every forum pointing out what to do and what not to do that get flamed. Grow up and learn to do your fucking homework before opening your cake hole, junior. EQEmu doesn't like you anymore, and that's why you're getting errors. So go away.
__________________
|

05-11-2004, 12:40 AM
|
Sarnak
|
|
Join Date: Dec 2003
Location: Seattle
Posts: 46
|
|
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!
__________________
-Keep you friends close, and your enemies closer-The Art of War
Artemis, the Emperor of Assasins - Draclian Signus, GM Admin and complete follower of the way of Draclian Signus.
|

05-18-2004, 02:24 AM
|
Fire Beetle
|
|
Join Date: Apr 2004
Posts: 5
|
|
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
|

05-18-2004, 03:48 AM
|
 |
Discordant
|
|
Join Date: Feb 2002
Posts: 452
|
|
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.
__________________
Founder PEQ (ProjectEQ)
|

05-18-2004, 04:16 AM
|
Hill Giant
|
|
Join Date: Apr 2004
Location: The Overthere
Posts: 123
|
|
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?
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 07:11 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |