EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   0.6.1-DR1 Compatible database (https://www.eqemulator.org/forums/showthread.php?t=18564)

cavedude 05-15-2005 08:41 AM

0.6.1-DR1 Compatible database
 
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 05-15-2005 12:04 PM

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

Code:


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 05-15-2005 02:32 PM

Lol...
;)

jammey97 05-29-2005 03:23 AM

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

cavedude 05-29-2005 03:29 AM

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 05-29-2005 06:50 PM

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 05-30-2005 01:48 AM

When I try to unrar that db, I get the following:
Code:

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 05-30-2005 03:21 AM

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 05-30-2005 05:09 AM

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

Coke 05-30-2005 05:10 AM

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

kawika 05-30-2005 05:54 AM

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

kawika 05-30-2005 10:43 AM

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.
Code:

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 05-30-2005 12:06 PM

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 05-30-2005 11:29 PM

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 05-31-2005 12:55 AM

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

WildcardX 05-31-2005 06:30 AM

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

mindping 05-31-2005 08:19 AM

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

Sakrateri 05-31-2005 09:09 AM

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 05-31-2005 10:31 AM

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 05-31-2005 10:03 PM

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 06-01-2005 01:45 AM

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 06-01-2005 06:18 AM

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 06-02-2005 12:10 PM

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 06-02-2005 02:01 PM

Updated original link.

jammey97 06-03-2005 02:58 AM

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

Thanks =D

iamjooish 06-04-2005 03:35 AM

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

also..

Quote:

t is NOT as accurate as PEQ's work
Quote:

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 06-04-2005 07:10 AM

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 06-05-2005 03:02 AM

a few more n00b querstions


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

also...

Code:

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 06-05-2005 05:18 AM

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 06-06-2005 03:00 PM

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 07-03-2005 05:06 AM

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 07-03-2005 08:37 AM

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

cavedude 07-04-2005 03:02 AM

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 07-04-2005 05:49 AM

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 07-04-2005 07:23 AM

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.


All times are GMT -4. The time now is 11:42 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.