Looking for Ariak's most recent db...

[1010101]

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]

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]

/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]

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]

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]

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

[ryco]

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]

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

[Lurker_005]

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]

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]

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
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]

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]

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]

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]

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

[ryco]

Hehehe, well I got the items to work, that's real good for me already so I'm happy for a while :oP

[frax]

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

OMG, I have to add that to each and every one of the several thousand NPC types? Has anyone done this already? If not, *Sigh* i guess i could get through maybe a thousand a day. If anyone has this done already, please help me out. I want the high dungeon spawns (ST/ToV/etc...). Thanks in advance

[Lurker_005]

Use a text editor with search and replace, it will take less than 30 seconds.

[Ariak]

Give me one day, maybe the end of today, if I keep it up..

I finally started to work. I took a long long two week break, I think. Hopefully, I should get back into work.