Whats the best DB that has NPC's?

Skifreak107 · #1 04-17-2002, 11:00 AM

Hey everyone, whats the best DB to use? I wanna be able to do dragon raids and stuff

Also merchants would be cool. Are there any zone listings for the #zone command? I tried trakanon but it took me to the teeth and I dont know the name of the zone hes in... :P
-Ski

stormgod · #2 04-17-2002, 11:12 AM

ariak is goin to release his soon , its based on drawde's db + NTOV planes kael and the like

(he will release it tomorow or in a few days max )

Skifreak107 · #3 04-17-2002, 11:16 AM

Very cool thanks, I got a question about DBs? Do I just replace the db file or do I have to go through the whole mysql thing?
-Ski

stormgod · #4 04-17-2002, 11:21 AM

you can just run mysql and then do the same process ( use eq , source db.sql ) but your goin to hear a lot of computer beeps (about 25 000 ) so best thing is to drop the db and recreate it , then you source it

I may be wrong of course so if someone else has a better id listen to him ;o)

Trumpcard · #5 04-17-2002, 01:13 PM

mysql -f eq < filename.sql

will cause a force option that has the nice side affect of disabling the beeps...

Hmm · #6 04-17-2002, 06:10 PM

you two guys should combine the efforts heh its never effecent to work seperately.

Ariak · #7 04-17-2002, 11:35 PM

There is an easy way to remove beeps.

1) Do a database dump
cmd - cd mysql cd bin
mysqldump eq > db.sql
then delete 'eq' 'in eqemuadmin'
add 'eq'
open 'mysql'
use eq
source db.sql (the dumped data)

If you open a DB, then dump it, then re-open it, THEN dump it, a second time, it loses 100% of its errors. This allows me to catch bugged spawns