I've been working on trying to get the emu up and working , and am making headway , but im running into the same problem ( zone unavilable when I hit enter at character select ) . I've got the latest win32 binaries (EQEmu-0.7.0-801.zip ) , and Ive done :
ALTER TABLE spawnentry DROP spawn_limit;
ALTER TABLE spawngroup ADD spawn_limit tinyint(4) NOT NULL default '0';
ALTER TABLE altadv_vars ADD class_type int unsigned NOT NULL DEFAULT 0;
to the eq database , and even confirmed the changes were made. Zones boot fine with no errors , using minilogin and it all seems to look/work ok , the 5 dynamic zones go into sleep mode ( well , at the top of the window it says 0: sleeping ) When they start up it says they're active , and then go into sleep mode a short while after. I'm using a fresh Titanium install , and haven't patched anything.
I've got both the peq and cavedudes databases sourced . Everything connects fine until I get to character select , I can create characters just fine , the problem begins when I try to enter the world.
World Log :
Quote:
---------------------------------------------
[06.17. - 08:48:20] Starting Log: logs/eqemu_debug_world_3708.log
[06.17. - 08:48:20] [WORLD__INIT] Loading server configuration..
[06.17. - 08:48:20] [WORLD__INIT] Log settings loaded from log.ini
[06.17. - 08:48:20] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[06.17. - 08:48:20] [WORLD__INIT] Connecting to MySQL...
[06.17. - 08:48:20] [WORLD__INIT] Starting HTTP world service...
[06.17. - 08:48:20] [WORLD__HTTP] Loaded mime types from mime.types
[06.17. - 08:48:20] [WORLD__INIT] Loading variables..
[06.17. - 08:48:20] [WORLD__INIT] Loading zones..
[06.17. - 08:48:20] [WORLD__INIT] Clearing groups..
[06.17. - 08:48:20] [WORLD__INIT] Clearing temporary merchant lists..
[06.17. - 08:48:20] [WORLD__INIT] Loading items..
[06.17. - 08:48:25] [WORLD__INIT] Loading guilds..
[06.17. - 08:48:25] [WORLD__INIT] Loading EQ time of day..
[06.17. - 08:48:25] [WORLD__INIT] Loading launcher list..
[06.17. - 08:48:25] [WORLD__INIT] Reboot zone modes ON
[06.17. - 08:48:25] [WORLD__INIT] Deleted 0 stale player corpses from database
[06.17. - 08:48:25] [WORLD__INIT] Deleted 0 stale player backups from database
[06.17. - 08:48:25] [WORLD__INIT] Zone (TCP) listener started.
[06.17. - 08:48:25] [WORLD__INIT] Client (UDP) listener started.
[06.17. - 08:48:25] [NET__IDENTIFY] Registered patch 6.2
[06.17. - 08:48:25] [NET__IDENTIFY] Registered patch Titanium
[06.17. - 08:48:25] [NET__IDENTIFY] Registered patch Live
[06.17. - 08:48:25] [WORLD__LS] Connecting to login server...
[06.17. - 08:48:25] [WORLD__LS] Setting World to MiniLogin Server type
[06.17. - 08:48:25] [WORLD__LS] Connected to Loginserver: 127.0.0.1:5999
[06.17. - 08:48:40] [WORLD__ZONE] New TCP connection from 127.0.0.1:3896
[06.17. - 08:48:40] [WORLD__CONSOLE] New launcher from 127.0.0.1:3896
[06.17. - 08:48:40] [WORLD__LAUNCH] Adding pending launcher 1
[06.17. - 08:48:40] [WORLD__LAUNCH] Launcher Identified itself as 'zones'. Loading zone list.
[06.17. - 08:48:40] [WORLD__LAUNCH] Removing pending launcher 1. Adding zones to active list.
[06.17. - 08:48:45] [WORLD__LAUNCH] zones: dynamic_01 reported state STARTED (1 starts)
[06.17. - 08:49:11] [WORLD__LAUNCH] zones: dynamic_02 reported state STARTED (1 starts)
[06.17. - 08:49:17] [WORLD__LAUNCH] zones: dynamic_03 reported state STARTED (1 starts)
[06.17. - 08:49:22] [WORLD__LAUNCH] zones: dynamic_04 reported state STARTED (1 starts)
[06.17. - 08:49:26] [WORLD__LAUNCH] zones: dynamic_05 reported state STARTED (1 starts)
[06.17. - 08:49:46] [WORLD__ZONE] New TCP connection from 127.0.0.1:3902
[06.17. - 08:49:46] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:3902
[06.17. - 08:49:46] [WORLD__ZONE] [1] Zone started with name dynamic_01 by launcher zones
[06.17. - 08:49:46] [WORLD__ZONE] [1] Auto zone port configuration. Telling zone to use port 7000
[06.17. - 08:49:46] [WORLD__ZONE] New TCP connection from 127.0.0.1:3903
[06.17. - 08:49:46] [WORLD__CONSOLE] New zoneserver #2 from 127.0.0.1:3903
[06.17. - 08:49:46] [WORLD__ZONE] [2] Zone started with name dynamic_02 by launcher zones
[06.17. - 08:49:46] [WORLD__ZONE] [2] Auto zone port configuration. Telling zone to use port 7001
[06.17. - 08:49:46] [WORLD__ZONE] New TCP connection from 127.0.0.1:3904
[06.17. - 08:49:46] [WORLD__ZONE] New TCP connection from 127.0.0.1:3905
[06.17. - 08:49:46] [WORLD__CONSOLE] New zoneserver #3 from 127.0.0.1:3904
[06.17. - 08:49:46] [WORLD__ZONE] New TCP connection from 127.0.0.1:3906
[06.17. - 08:49:46] [WORLD__CONSOLE] New zoneserver #4 from 127.0.0.1:3906
[06.17. - 08:49:46] [WORLD__CONSOLE] New zoneserver #5 from 127.0.0.1:3905
[06.17. - 08:49:46] [WORLD__ZONE] [5] Zone started with name dynamic_04 by launcher zones
[06.17. - 08:49:46] [WORLD__ZONE] [5] Auto zone port configuration. Telling zone to use port 7002
[06.17. - 08:49:46] [WORLD__ZONE] [4] Zone started with name dynamic_05 by launcher zones
[06.17. - 08:49:46] [WORLD__ZONE] [4] Auto zone port configuration. Telling zone to use port 7003
[06.17. - 08:49:46] [WORLD__ZONE] [3] Zone started with name dynamic_03 by launcher zones
[06.17. - 08:49:46] [WORLD__ZONE] [3] Auto zone port configuration. Telling zone to use port 7004
[06.17. - 08:50:52] [WORLD__CLIENT] New connection from 127.0.0.1:3908
[06.17. - 08:50:52] [NET__IDENT_TRACE] 127.0.0.1:3908: First opcode 0x4dd0 did not match expected 0x2792
[06.17. - 08:50:52] [NET__IDENT_TRACE] 127.0.0.1:3908: Tried patch 6.2_world, and it did not match.
[06.17. - 08:50:52] [NET__IDENT_TRACE] 127.0.0.1:3908: First opcode 0x4dd0 did not match expected 0x2ec9
[06.17. - 08:50:52] [NET__IDENT_TRACE] 127.0.0.1:3908: Tried patch 6.2_zone, and it did not match.
[06.17. - 08:50:52] [NET__IDENT_TRACE] 127.0.0.1:3908: First opcode matched 0x4dd0 and length matched 464
[06.17. - 08:50:52] [NET__IDENTIFY] Identified stream 127.0.0.1:3908 with signature Titanium_world
[06.17. - 08:50:52] [WORLD__CLIENT] New client from 127.0.0.1:3908
[06.17. - 08:50:52] [WORLD__CLIENT_TRACE] NOCLE: Recevied EQApplicationPacket
[06.17. - 08:50:52] [WORLD__CLIENT] mini: Logged in. Mode=(CharSel)
[06.17. - 08:50:52] [WORLD__CLIENT] mini: MiniLogin Account #1
[06.17. - 08:50:52] [GUILDS__OUT_PACKETS] mini: Sending OP_GuildsList of length 96064
[06.17. - 08:50:52] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x00fb
[06.17. - 08:50:52] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x00fa
[06.17. - 08:50:52] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x0105
[06.17. - 08:50:52] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x0106
[06.17. - 08:50:52] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x0100
[06.17. - 08:50:52] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x00ff
[06.17. - 08:51:02] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:51:25] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:51:25] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:51:50] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:51:51] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:52:13] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:52:13] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x00fc
[06.17. - 08:52:13] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x010a
[06.17. - 08:52:13] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x010b
[06.17. - 08:52:13] [WORLD__CLIENT] mini: Attempting autobootup of neriakb (41)
[06.17. - 08:52:13] [WORLD__CLIENT_TRACE] mini: Sending EQApplicationPacket OpCode 0x00c7
[06.17. - 08:52:13] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:52:31] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:52:31] [WORLD__CLIENT_ERR] mini: Received unknown EQApplicationPacket
[06.17. - 08:52:31] [WORLD__CLIENT_ERR] [OpCode OP_WorldLogout (0x771 Size=0]
[06.17. - 08:52:31] [WORLD__CLIENT_TRACE] mini: Recevied EQApplicationPacket
[06.17. - 08:52:31] [WORLD__CLIENT] mini: Client disconnected (not active in process)
|
When Minilogin starts up it goes through the usual. Then when the client connects it gets :
137875 New Client from ip: 127.0.0.1 port: 3907
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 | ...........
The sleeping zone window doesn't show anything.
I've also noticed this error log entry :
Quote:
---------------------------------------------
[06.17. - 08:52:13] Starting Log: logs/eqemu_error_zone_1352.log
[06.17. - 08:52:13] Error in PopulateZoneLists query 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, timeleft, _condition, cond_value FROM spawn2 WHERE zone='neriakb'': #1054: Unknown column '_condition' in 'field list'
[06.17. - 08:52:13] Loading spawn2 points failed.
|
I'm guessing the database is missing an entry. I've seen references to the " x, y, z " problem some people are having. Is this the same thing? Thanks to all for your awsome work on this project. I wish I knew more to help out , but I guess I'll play catch up for now. If I missed this in the forums or wikki , I'm terribly sorry.