EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Development (https://www.eqemulator.org/forums/forumdisplay.php?f=621)
-   -   Looking for Ariak's most recent db... (https://www.eqemulator.org/forums/showthread.php?t=983)

1010101 04-02-2002 09:26 AM

Looking for Ariak's most recent db...
 
I've been trying to find a copy of Ariak's most recent database (preferably already compiled) but am having no luck, as Ariak's site seems to be experiencing some technical difficulties. I did get an out-of-date version from a mirror I found by searching one of the threads here, but I'd really like the ToV spawns.

If someone could email it to me (or mirror it somewhere), that'd be greatly appreciated. My email address is 1010101@mighty.co.za.

If you email it to me, please post here that you did so, as I'd hate to receive 10 copies :). Thanks in advance.

- 1010101
(http://www.gameroom.com/1010101)

DeletedUser 04-02-2002 10:48 AM

Hey 1010101, nice to see youve come to our boards (A month ago, but I didn't see ya)

Try visiting: http://nctimes.net/~threeofus/

When you click db.zip and it goes to the geocities page, add a space after the link and you can download it.

Seems to be his new site..

Ariak 04-02-2002 10:53 AM

/dev/n00b is sponsoring a site for me. Geocities would lock out the page after like 10 meg of data-transfer a day.. Which, basically, is 3 visits and 3 downloads or something.

1010101 04-02-2002 10:54 AM

Woohoo! Thanks, image. I appreciate the quick response :). And I'm glad to be here. Expect to see much more of me in the coming months.

- 1010101
(http://www.gameroom.com/1010101)

devn00b 04-02-2002 11:19 AM

hehe i grew rather annoyed at going to geocrap and getting that you have excceded you xfer limit!

soo worthless!

glad to help. wish i could do more for the emu =)

Ariak 04-03-2002 05:12 AM

!
 
Fixxing the site today, or tomorrow, whenever I am not busy..

ryco 04-09-2002 12:17 PM

Ariak, does that new DB work with 0.3.0 Emu ?
I'm a newbie hehe tryed to use your DB ( which looks really awesome ) but got some errors ...

devn00b 04-09-2002 12:36 PM

That DB 1.07 i thin it is (could be wrong) is not compatable with the current emu.

Lurker_005 04-09-2002 03:46 PM

1.07 is NOT compatable with EQEmu0.3.0

However the data can be imported in. Use the DB that came with 3.0 and import the data from the spawn,loot,merchant related tables.

Note you have to add data to the spawn2 table, there are several new column's of data required. But some default values work fine in them. I have a post with more info somewhere, in the Dev forum I think.

Or just wait for her next release :D

ryco 04-09-2002 09:15 PM

ahhhh ok thought so...
Could you just explain me how to import the item data ?
I tried to copy/paste the item things into drawde's db, but it doesn't work hehe

Thanks for the help

Lurker_005 04-10-2002 10:12 AM

Don't try to mix Drawde's and Ariak's databases, it just isn't worth the hastle, just have a copy of both. If you really want Ariak's database in 3.0 it is easiest to work with the db.sql file. first copy out the aproriate tables to seperate files. Like how Drawde has (not the Full DB) Don't save the table structure, just the "INSERT ...." lines The only one you should have to edit is npc_types add 0,0,' ',' ',0,0,0,1,0,0,0,0 to all the lines
Code:

INSERT INTO npc_types VALUES (1,'Aagron',35,1,1,2010,0,3,3,0,9,37,5,0);

Becomes
INSERT INTO npc_types VALUES (1,'Aagron',35,1,1,2010,0,3,3,0,9,37,5,0,0,0,' ',' ',0,0,0,1,0,0,0,0);


ryco 04-10-2002 10:51 AM

Well I took only the items from Ariak's db and made a item.txt with them, then I removed the items from Drawde's and went in mysql, did :
use eq
source db.sql
...
use eq
source item.txt

and I think I got it to work now =)
thanks for the help

Lurker_005 04-10-2002 11:42 AM

That should be ok, but while Ariak had some extra items, Drwade's was using the latest collected items(I think) You could source the latest collected items, then Ariak's. It will beep 25000 times, but you'll have the lates collected items plus any Ariak added.

ryco 04-10-2002 01:27 PM

Had fun with Ariak's items tonight, really tons of nice toys hehe
Good idea to add both, but I can't stand with the beeps :D

Ariak 04-10-2002 11:35 PM

My DB is not compatible with the current DB. I am lazy.


All times are GMT -4. The time now is 02:28 PM.

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