Server Connect, Client connected until...

Makwa · #1 07-20-2006, 04:57 AM

No, that isnt the reason for the crash when zoning. Mine says the same. Both the path error and the OpCode error. But it still runs.

I have noticed that when there are errors in some of the tables, that when i zone, it will crash.

To add the message to the traps table do this:

Open up the control panel for the DB, and connect to the DB that your using ( i have 3 ) i am playing with.

Edit the traps table, and enter a new field. Name it message, and use varchar for the datatype. At the bottom in the Field Propertied tab, enter 100 for the length.

If you dont have a control center in dos do this.

1. Change to your mysql\bin directory.
2. mysql -u root peq <- - whatever your DB is named.
3. ALTER TABLE `traps` ADD `message` varchar(100);
4. exit
5. exit

There are a lot of things that can make you not zone. This is what i did to the DB to get going.

1. I started with the PEQ DB.
2. Made the traps change.
3. Went to the download section of the main page of eqemulator, and i went into each release and started from 0.7.0 and went into each one, and made all of the DB changes all the way up to the one at the top. Some are already done, some are not.

That got me running.

The first time that i run EQ and i select my server, it hangs at the connecting to the server. I control+alt+delete that and do it again. But the next time it goes into the game. I dont know why yet, but it works.

When i get to the character selection screen, it does take a few times for it to zone in.

There are a bunch of errors on the screen, saying i have been disconnected, but it will eventually log into the game.

I no longer have to go into dos and do the zone commands. It now lets me do the icon from cavedudes, which runs, minilogin, then world, then zones.

Honostly, it is really sad to see that people dont share their working databases. They start out with help from here, and someones DB, but dont share the wealth. They want you to play on their server. Then they make rules for you to play. That's sad.

Their are a lot of people out there, that have figured things out that can help everyone else. It's a game people.

Let me know where your at after all of this.

Makwa

Arag · #2 07-20-2006, 05:23 AM

thanks alot i wil go to the download page and get all the mysql codes from the log til the last release..
i let you know if it works when ready.
thanks alot for your help!!

btw is there a way so i can use your Db ?
if so.
may you be so kind to share it with me
?

Much Respect for your help and intrest!

Makwa · #3 07-20-2006, 05:31 AM

Absolutely you can have mine. I am all for sharing the wealth. Let me pack it, zip it, and i will email it to you. I have to check the size of the zip file after i do it though. If its too big to email, i will give you a link to the file on my website, and you can download it there.

Makwa

Arag · #4 07-20-2006, 05:40 AM

cool! that wil help alot~!!
i have do the comands into mysql now it ony keep saying zone unavailebel :(
so i i keep doing thing wrong or something :(
i followed the wikki for the 7.0 step by step and befor i did all the comands the mini was working 25% hahahah ,
now i cant log in anny more so there is some thing not correct :(

may you can tell me how to instal your Db correctly when i downloaded it?

thx

btw i get this in zone.exe when i try to enter world

Path File ./Maps/freportw.path not found.
[Status] Weather should change in 6728 seconds
Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.wa
lkspeed' in 'field list'
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
Error3 in PopulateZoneLists query 'SELECT spawnentry.spawngroupID, npcid, chance
, spawnentry.spawn_limit AS gsl, npc_types.spawn_limit AS sl FROM spawnentry, s
pawn2 LEFT JOIN npc_types ON spawnentry.npcID = npc_types.id WHERE spawnentry.sp
awngroupID=spawn2.spawngroupID AND zone='freportw' ORDER by chance' #1054: Unkno
wn column 'spawnentry.spawn_limit' in 'field list'
[Error] Loading spawn groups failed.
Zone->Init failed

Makwa · #5 07-20-2006, 06:48 AM

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

Makwa · #6 07-20-2006, 06:53 AM

Can you post me the contents of your eqemu_config.xml file, and your loginserver.ini?

Thanks,

Makwa

Arag · #7 07-20-2006, 07:34 AM

Quote:

Originally Posted by Makwa

Can you post me the contents of your eqemu_config.xml file, and your loginserver.ini?

Thanks,

Makwa

sure il post them first and then create the Db
when you have it ready 4 me

login.ini
###Your current configuration is as follows:

loginserver.ini:
[LoginServer]
loginserver=127.0.0.1
loginport=5999
worldname=My Minilogin
worldaddress=127.0.0.1
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=
[ChatChannelServer]

worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=Minilogin
ServerPort=5999

------------------------------------------------------------------------

eqeum_config

<?xml version="1.0">
<server>
<world>
<shortname>minilogin</shortname>
<longname>My Minilogin</longname>


<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>


<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>


<key>some long random string</key>


<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<zones>
<defaultstatus>20</defaultstatus>


<ports low="7000" high="7100"/>
</zones>


<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>eq</username>
<password>eq</password>
<db>eq</db>
</database>

<launcher>




</launcher>

<files>




</files>

<directories>



</directories>