View Single Post
  #11  
Old 07-20-2006, 06:48 AM
Makwa
Fire Beetle
 
Join Date: Jun 2004
Posts: 23
Default

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
Reply With Quote