0.6.1-DR1 Compatible database

[cavedude]

http://www.savefile.com/files/3351769

EDIT: Link should now work, also fixed some bugs with the db. Please use Winrar to extract.

Binaries for this db can be found here:

http://www.savefile.com/files/2040151

This is my own private database so I don't provide ANY support for it. I just saw a need for a db that works with the newest version so I figured I'd save many of you some time and trouble.

I created this database using live logs and eqbuilder. It is NOT as accurate as PEQ's work however it does have Luclin fully popped, as well as Gunthak, half of POP, and a few LDoN zones popped. The faction and loot tables are govtcheeze's with many alterations by myself. The items is 13th floor's newest db, and everything else is either my own, pulled from the forums, or shamelessly stolen from PEQ's db.

Have fun.

[cavedude]

To prevent the slaughtering of innocent noobs please make this change:



update npc_types set npc_faction_id=1938 where name = 'Guard_Pineshade';



One more thing guards won't work properly with this db. They are all setup correctly, but it appears npc_aggro is bugged in 0.6.1-DR1. (If npc_aggro is enabled, mobs will aggro other mobs but deal no damage) I haven't found time to look at the source to find the problem. Once the emu code is fixed, guards will be fully functional with no db changes required.

[solid11]

Lol...
;)

[jammey97]

So what happened to the file? The url works but there's no file there to download anymore. :(

[cavedude]

savefile screwed up and deleted all active files. Problem is now the system will only accept inactive files. Hopefully, it will be fixed soon. When it is I'll re-upload.

[Sakrateri]

You can get it here http://www.members.cox.net/fatesdestiny/6.1DR1.zip until its fixed .

redid the file into a zip , should work ok now

[kawika]

When I try to unrar that db, I get the following:http://www.eqemulator.net/forums/images/icons/icon4.gif W:\EQEmu Files\dbase\DB.rar: CRC failed in eq0.6.1-DR1.sql. The file is corrupt
http://www.eqemulator.net/forums/images/icons/icon4.gif W:\EQEmu Files\dbase\DB.rar: Unexpected end of archive


Thanks

[Sakrateri]

yeah , dunno why but you should be able to close that error box and click extract to (folder name) and it work anyway.

If not try here ftp://68.225.183.196/ must you IE to use the ftp , wont work with mozilla.

[SiliconeClone]

I get the same error from the one link and the FTP does not seem to want to connect even with IE.

[Coke]

Thankl you muchly!!! I was looking for a Luclin comaptible db!

[kawika]

It does extract anyways, wasn't sure if there'd be a problem with the dbase or not.

[kawika]

I tried sourcing in this database, it cuts off in the middle of sourcing the spawns for Dreadlands. Here's the last line that it tries to source in.INSERT INTO spawn2 VALUES (16551,86109,'dreadlands',3391,-1797.88,573.3,341,-Not sure if anything can be done about this but thought I'd let you know.

Thanks

[sylverwolf]

when i first tried the first link, i forgot about this thread. found it again by accident with a good link.

thanks a ton :)

[Sakrateri]

Redid the above file http://www.members.cox.net/fatesdestiny/6.1DR1.zip
so its a zip now , it should work ok . Let me know

[kawika]

It unzipped without error, will let you know how it goes when I try to source it. Thank you!

[WildcardX]

Odd.. I downloaded the new link twice and both times I got an error about invalid compressed data in the zip file.

[mindping]

yes, when extracting the 104 meg sql file, its only 77 megs after keeping the curropted extracted file

[Sakrateri]

ok dont know whats wrong there , I downloaded it from work and it worked fine. mabeys its just to large , try to download the FTP one , thats a zip also now.

[jammey97]

The file from cox.net gives me a CRC error. (The new zip file).
The ftp link times out getting directory listing using IE or any other ftp client.

[Sakrateri]

umm, whats a crc error? Sorry guys just tried to help , mabey I can split the sql up into a couple smaller ones and try to distribute like that.

[jammey97]

A CRC error means the file extracted from the zip doesn't match the origional file that was zipped up. It's just a basic form of error detection.

It might have been corrupted when copying it to the cox.net server.

I'm not sure what the attachment size limit is for this forum, but perhaps you could recreate the zip (test it to make sure there's no errors) and attach it to a post here.

[kawika]

I was able to download the new zip and extract it without problems. I was only getting CRC errors on the first rar file.

[jammey97]

I've downloaded it on 3 different machines and used 3 different programs to unzip it. All of them gave an error during extraction.

kawika : care to post a link to your working zip?

[cavedude]

Updated original link.

[jammey97]

New link works great, no errors in the rar file.

Thanks =D

[iamjooish]

anyone know which servers are using this? I think I'll make habit of playing on servers that are only luclin-enabled ;P

also..

t is NOT as accurate as PEQ's work

or shamelessly stolen from PEQ's db.

so wouldn't it actually be as accurate as Peq's work? I'm confused.

anyways, sounds nice. Hopefully now that I have the compiled 6.1 dr1 I might get to toy around with it...

[cavedude]

PEQ has done a lot of work to their database in regards to perfecting spawns and such. I pretty much just spawned everything from logs and only fixed/added entires I knew were wrong or missing. The tables I took from PEQ are minor ones such as starting items.

[iamjooish]

a few more n00b querstions


So I could mix some of peq's tables with yours and it would stil work?

also...

INSERT INTO variables VALUES ('LoginType','Public','Set this to Minilogin to login using a minilogin server :)',20050602212938);


it looks like some of you might have to do some editting to the db before you can get it to work. :p

[cavedude]

My database and PEQ's db only have limited compatiblity. Some tables can be exchanged, others can't. If you don't know much about how all the tables interact I suggest leaving them be.

The database is setup for public login by default. If everybody used minilogin, there weren't be any cool servers for people to gether on.

[iamjooish]

well I can try... >:) your tables seem to be more detailed...
a big plus would be to just get Alt. Adv working again.


The minilogin thing was to prevent others from running into the same wall I ran into a dozen times...

update: zone points seem a little DoA... Couldn't Login to cab east with them but PEQ Velious's Zone points worked fine (so I can tell)... just a heads up.

edit again: fixed. somehow dropping zone_points, loading PEQ's table, dropping it, then reloading yours seemed to work.

[wooow]

I am experiencing a problem with this database. When I tried to log in with minilogin, it gives an error saying:

xxxxxx new client from ip: 127.0.0.1 port: xxxx
Unknown packet: 0: 00 02 00 00 00 00 00 00 - 00 00 00

Anyone knows what's happening? When I switch to the PEQ database everything works well. Any help is greatly appreciated, I want Luclin badly.

(I've sourced PEQ database into EQ, and the 0.6.1-DR1 into EQ2, all I changed was the db.ini file and the EQ2 didn't work. I'm using 0.6.1 EQEmu with pre 5.11 patch)

[cavedude]

Make sure you have an account setup in the database with the client's IP specified.

[cavedude]

For those of you who want the 0.6.0-DR3 version of this database, it can be found bundled with the Server Pack found here: http://eqemulator.net/forums/showthread.php?t=18934

[wooow]

wow, nice package, can't wait to try it out. I was hoping someone would put up something like this for newbies. Well, last question, will it be pre-5.11 client compatible?

[cavedude]

Yes, the package works with my client which is dated 10/13/04. I have gotten reports that it works with some clients before and after that date as well, but that's third hand information and I don't have exact dates or version numbers for those.