Server Connect, Client connected until...

[Makwa]

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]

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]

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]

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]

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]

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]

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]

may this wil work 4 you.
http://eqemu.sesmar.net/forum/index.php?topic=137.0