Server Connect, Client connected until...

Makwa · #1 07-17-2006, 05:07 AM

I am using fresh install of Titanium (without live patch),
Using 0.7.0-833 config files.
Using Cavedudes DB.

I can connect to the server just fine.
I can login to server select screen, but when i pick enter world, it says zone unavailable (after doing it 10 times or so), and my client connected goes from 1 (me or course) to 0.

And in that screen i get this error:

unknown packet: .4233692 [92.153.64.0:15->0.0.0.0:0]
[opcode 0x0003 (OP_Unknown) Size=11]
00000: 00 06 00 00 00 00 00 00 - 00 00 00

Anyone know what this means, or the fix?

Thanks much.

Makwa · #2 07-17-2006, 09:53 AM

When you do this serverpack, is it downloading the latest builds, and the latest DB? So, the builds are compatible with the appropriate DB's?

Makwa · #3 07-17-2006, 05:37 PM

so, i have been messing around with some things, and i found one problem in the DB.

When i added message to the traps table, i was able to zone, and my AA's showed up.

I am sure most of you have already figured this out, but it helped my alot.

hope this helps someone.

Arag · #4 07-18-2006, 01:40 PM

so you did get a disconect ( world.exe crash to when tryed to zone ?)
if so can u tel me how to fix it|?
already build 20x a new Db for it :(
im using eq Db now can u help?

Makwa · #5 07-19-2006, 03:53 AM

I am able to connect, and zone ALOT better when i open the files manually.

I click on minilogin.exe, then world, then i have to open two or more zones manually, using cmd.exe then go into your eqemu folder, and type:
zone . 127.0.0.1 7995 127.0.0.1

Let that run. then do the same thing again.

zone . 127.0.0.0 7996 127.0.0.1

By doing this, i can see errors happening, if any. This is how i found the traps DB error. Like i said, i just added the message column in the traps table. Then that error went away.

Then run your eqemu everquest.

I sometimes still have to click enter world a few times before zone can catch up.

It's still really buggy. Drops me for no reason, etc. But i can connect and get into the game.

I am an ASP.NET Web Developer and i made a site locally that will query the database and pull out the best items in the database for my classes that i choose, and insert them into the Inventory table based on my character id.

This is much easier then looking up items in Allakhazam, then doing a search for the item in the game, then summoning the item.

Work in progress.

Arag · #6 07-20-2006, 04:26 AM

thanks!
i wil try that.
im stil not sure where i can change the trap mesage in cc..

and the zone says this ..
and when i zone to a other zone it crashes my world.exe
may this can be the error?

Microsoft Windows XP [versie 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Computer>cd C:\EQEmu-0.7.0-828

C:\EQEmu-0.7.0-828>zone . 127.0.0.0 7996 127.0.0.1
[Status] Using database 'eq' at localhost:3306
[Status] EMuShareMem loaded
[Quest] Tying perl output to eqemu logs
[Quest] Creating EQEmuIO=HASH(0x36657dc)
[Quest] Creating EQEmuIO=HASH(0x3671d4

[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Status] Booting paineel
Map header: 60895 faces, 730 nodes, 78670 facelists
Loaded map: 182685 vertices, 60895 faces
Map BB: (-1105.56 -> 951.63, -14.00 -> 1665.34, -783.69 -> 83.97)
Map ./Maps/paineel.map loaded.
Path File ./Maps/paineel.path not found. <--------------------------------
[Status] Weather should change in 6490 seconds
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
[Status] Loading spawn2 points...
[Status] Loading player corpses...
[Status] Loading traps...
[Status] Loading ground spawns...
[Status] Loading Ground Spawns from DB...
[Status] Loading World Objects from DB...
[Status] Loading Objects from DB...
[Status] Loading doors for paineel ...
[Status] Loading Doors from database...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
[Status] Successfully loaded Zone Config.
[Status] Loading timezone data...
[Status] Init Finished: ZoneID = 75, Time Offset = 0
[Status] Zone Bootup: paineel (75)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [02:23 am]
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: OP_Unknown (#0 eq=0x0000), size: 0 <-----------|

i searched the forum 4 it but stil cant find the answers :(

and btw <--- im stil a newb in this

thanks alot 4 the help!

Makwa · #7 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 · #8 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 · #9 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 · #10 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 · #11 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 · #12 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 · #13 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>

Makwa · #14 07-20-2006, 07:46 AM

I have my DB dumped, but it's 96MB. Way to big to email. Try creating that table in your first from my last post, see if that works at all.

If not, let me know. I will post my db on my site.

I will email you the path to the file to your email address in your profile here, when it is up.

Makwa

Arag · #15 07-20-2006, 07:53 AM

i did the ( 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;

comand in myslq whil using my Db .
it did make the tabel but it keeps saying zone unavailabel ..
did send you a Pm with my mail in it