View Full Version : Looking for Ariak's most recent db...
1010101
04-02-2002, 09:26 AM
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..
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
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
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);
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.
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.
Hehehe, well I got the items to work, that's real good for me already so I'm happy for a while :oP
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
04-14-2002, 02:26 AM
Use a text editor with search and replace, it will take less than 30 seconds.
Ariak
04-15-2002, 12:17 PM
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.
vBulletin® v3.8.11, Copyright ©2000-2024, vBulletin Solutions Inc.