Server empty of NPC's
 

I join someone else's server... all the zones are full of NPC's.... mine, all the zones are empty. If its a DB that I need to get, anyone have a link to where I can get a decent one? I just wanna go fight in Seb, maybe kill Trakanon.

http://cecugfile.net/
Its under downloads

Thanks for the quick reply.... I downloaded the DB, went into mysql, and using the downloaded DB in the directory did:

use eq;
source db.sql

However, after finishing this, and using install.bat, I get a bunch of errors:

For about 20k lines at least. I don't understand.... how can the DB not be compatible with itself? Is there a way to erase the EQ db and start over from scratch?

Oh yes, and the end result is: No NPC types in the database, and all the zones are empty. The Spawn table is full.... but the NPC types is empty. Help!

There must be something wrong with the install.bat file. Source in the spawns manually, go into the mysql and do the use <database name> and then source spawns.sql, i believe thats the name. That seemed to work for me. I think you need to start back fresh again (I did anyway), install the spawns BEFORE install.bat.

Thanks for all the help yo.... one more question, how to start fresh? Ie, how do I delete the database to start over again?

You could go into mySQL and type in "drop database eq;" without quotes and then to re-create, type "create database eq;" without quotes. Or you can go into winmysqladmin, right click on the database, click drop database, then right click in the white area and click create database.

Thanks man, I really appreciate your help.

ok i just did all this and am getting the 1017 error now =( I redid the patch, all files are good, but keep getting 1017 by adding these db's, any idea why?