That error means that you dont have spawnentry table in the database.
To use this new DB that i will give you, you just do this:
1. mysql -u root
2. create database eq < - - name it whatever you want.
3. use eq;
4. source db.sql;
Let it run all the way.
5. do the grant all privileges command.
6. do the insert into account (name, status, minilogin_ip) VALUES ('mini',250,'127.0.0.1');
Make sure that the minilogin_ip is what your using everywhere else.
name is the name of the login into Everquest.
Your DB is probably good, just needs a few tweaks.
If you want to try your DB first, source this in yours:
CREATE TABLE spawnentry (
spawngroupID int(11) NOT NULL default '0',
npcID int(11) NOT NULL default '0',
chance smallint(4) NOT NULL default '0',
PRIMARY KEY (spawngroupID,npcID)
) TYPE=MyISAM;
Or type that in dos, once your in mysql, using your db.
Let me know if that works any better.
Makwa
|