Need Some Help and Willing to Help others when I learn - Page 2

xeeman · #16 04-14-2004, 04:45 AM

I'm using the ones from Jezebell's How To:

=========
4. Download TCMyWorld's Alpha 1 database and TCMyWorld's Alpha 2 database

Download lootdrop update by govtcheeze v0.2

Right click and save target as doorupdate-03-15-04.sql

Extract them to C:\mysql\bin
==========

They have been sourced already, and I even took the "long route" and sourced Alpha1 and Alpha2 to be more complete.

Thanks for you help Monrezz.

(?) Should I source another database?

(?) If so, can you provide a link to it?

Monrezz · #17 04-14-2004, 10:27 AM

Hmmm, re-read your problem and it sounds as if World.exe can only detect one zone-server - hence the fact you can login but can't zone (no zone-servers free).

Post the output of your World and Zone.exe's.

xeeman · #18 04-14-2004, 02:29 PM

Ok---tonight when I logged in my character created last night (put me in Felwithe), I popped in GFay near the Kelethin PoK book. Whenever I tried zoning, I received the same "Zone not ready to receive visitors yet." message.

On the bright side, I did make myself a server_op as well as flagged myself a GM, changed my level, and generally did some cool things...

============
boot5zones.bat
============
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.5
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading NPCTypes from database...
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[Status] Loading Doors from database...
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 5023
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'help' defaulting to access level 0!
[Status] command_init(): Warning: Command 'version' defaulting to access level 0
!
[Status] command_init(): Warning: Command 'serversidename' defaulting to access
level 0!
[Status] command_init(): Warning: Command 'loc' defaulting to access level 0!
[Status] command_init(): Warning: Command 'flag' defaulting to access level 0!
[Status] command_init(): Warning: Command 'si' defaulting to access level 0!
[Status] 160 commands loaded
[Status] Entering sleep mode
Connected to worldserver: localhost:9000
[Status] Weather should change in 7188 seconds
Init: Loading zone lists, zone state or spawn list, player corpses
Zonepoints loaded into memory
, timezone data - Done. ZoneID = 49; Time Offset = 0
Reading zhdr file './cfg/oggok.cfg'
Using database for safe coords.
Zone safe coords are x = -99; y = -345; z= 4
Reading zhdr file './cfg/oggok.cfg'
Using database for safe coords.
Zone safe coords are x = -99; y = -345; z= 4
Using default zone header data...
Converting old zone data...
Attempting to write ./cfg\oggok.cfg
Write complete.
Reading zhdr file './cfg/oggok.cfg'
Using database for safe coords.
Zone safe coords are x = -99; y = -345; z= 4
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for oggok ...
[Status] Done loading doors for oggok ...
Petition 1 pettime = 1075244406
Petition 4 pettime = 1077918843
Petition 18 pettime = 1077916536
Petition 20 pettime = 1077476008
Petition 44 pettime = 1077493301
Petition 54 pettime = 1075595761
Petition 94 pettime = 1077935724
Petition 174 pettime = 1077767613
[Status] Zone Bootup: oggok (49)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [11:45 pm]
[Status] 547327 New client from ip:24.28.239.154 port:4770
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x02f8, size: 4
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x032a, size: 8
[Status] WARNING: Closest zone point for feerrott is 382.898834, you might need
to update your zone_points table if you dont arrive at the right spot.
[Status] Zoning 'Furor' to: feerrott (47) x=808.000000, y=1672.000000, z=58.0000
00
WARNING: No target coords for this zone in DB found
Zoning to safe coords: oggok (49), x=-2, y=-2, z=-2
[Status] Zoning 'Furor' to: oggok (49) x=-2.000000, y=-2.000000, z=-2.000000
[Status] WARNING: Closest zone point for feerrott is 484.946655, you might need
to update your zone_points table if you dont arrive at the right spot.
[Status] Zoning 'Furor' to: feerrott (47) x=808.000000, y=1672.000000, z=58.0000
00
Unknown opcode: 0x0186 size:0 Client:Furor
Client disconnected (cs=d): Furor
Dropping client: Process=false, ip=24.28.239.154, port=4770
[Status] Zone Shutdown: oggok (49)
[Status] Weather should change in 70 seconds
Init: Loading zone lists, zone state or spawn list, player corpses
Zonepoints loaded into memory
, timezone data - Done. ZoneID = 54; Time Offset = 0
Reading zhdr file './cfg/gfaydark.cfg'
Using database for safe coords.
Zone safe coords are x = 10; y = -20; z= 0
Reading zhdr file './cfg/gfaydark.cfg'
Using database for safe coords.
Zone safe coords are x = 10; y = -20; z= 0
Using default zone header data...
Converting old zone data...
Attempting to write ./cfg\gfaydark.cfg
Write complete.
Reading zhdr file './cfg/gfaydark.cfg'
Using database for safe coords.
Zone safe coords are x = 10; y = -20; z= 0
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for gfaydark ...
[Status] Done loading doors for gfaydark ...
Petition 1 pettime = 1075244406
Petition 4 pettime = 1077918843
Petition 18 pettime = 1077916536
Petition 20 pettime = 1077476008
Petition 44 pettime = 1077493301
Petition 54 pettime = 1075595761
Petition 94 pettime = 1077935724
Petition 174 pettime = 1077767613
[Status] Zone Bootup: gfaydark (54)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [05:58 am]
[Status] 1663031 New client from ip:192.168.0.254 port:1093
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x02f8, size: 4
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x032a, size: 8
[Status] Weather should change in 51 seconds
[Status] Weather should change in 7384 seconds
[Status] Zoning 'Xeeman' to: gfaydark (54) x=10.000000, y=-20.000000, z=0.000000

Client disconnected (cs=d): Xeeman
Dropping client: Process=false, ip=192.168.0.254, port=1093
[Status] 2518701 New client from ip:192.168.0.254 port:1102
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x032a, size: 8
[Status] Zoning 'Xeeman' to: poknowledge (202) x=882.000000, y=838.000000, z=-15
7.000000
[Status] Zoning 'Xeeman' to: gfaydark (54) x=37.137501, y=811.879028, z=-145.000
000
Door 78 triggering door 77
Door 78 triggering door 77
Door 78 triggering door 77
Door 78 triggering door 77
Door 78 triggering door 77
[Status] Zoning 'Xeeman' to: felwithea (61) x=200.000000, y=40.000000, z=4.00000
0
[Status] Zoning 'Xeeman' to: gfaydark (54) x=-441.000000, y=-2023.000000, z=4.00
0000

===============
world.exe
==============
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.5
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26679, max id=68199
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Assassinating people that whine about horses...done
TCP listening on: rexpage.homedns.org:9000
World server listening on: rexpage.homedns.org:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997
6421384 New TCP connection: 127.0.0.1:1253
New zoneserver: #1 127.0.0.1:1253
Zoneserver SetConnectInfo: 127.0.0.1:1253: rexpage.homedns.org:7995
6826326 New client from ip: 24.28.239.154 port: 4767
Account Attempting to be created:Vasker88 0
Logged in: FirstLogin LS#52231: Vasker88
Received unknown opcode: 0x02ee size:0 bytes
6924497 New client from ip: 192.168.0.254 port: 1063
Logged in: FirstLogin LS#42482: xeeman
Name approval request for:Furor race:10 class:1
Character creation request from Vasker88 LS#52231 (24.28.239.154:4767) :
Name: Furor
Race: 10 Class: 1 Gender: 0 Deity: 396 Start zone: 7
STR STA AGI DEX WIS INT CHA Total
147 150 75 70 67 60 37 606
Face: 5 Eye colors: 6 6
Hairstyle: 255 Haircolor: 255
Beard: 255 Beardcolor: 255
Validating char creation info...
Found 0 errors in character creation request
No start_zones entry in database, using defaults
Current location: oggok -99.00, -345.00, 4.00
Bind location: feerrott 905.00, 1050.96, 25.76
Character creation successful: Furor
Attempting autobootup of oggok (49) for Furor
Zoneserver SetZone: rexpage.homedns.org:7995 oggok (49)
Enter world: Furor: oggok (49)
Broadcasting a world time update
Zoneserver SetZone: rexpage.homedns.org:7995 oggok (49)
Client disconnected
Removing client from ip:24.28.239.154 port:4767
7024911 New client from ip: 172.174.101.176 port: 2443
Account Attempting to be created:Ikkan 0
Logged in: FirstLogin LS#40604: Ikkan
Received unknown opcode: 0x02ee size:0 bytes
Received unknown opcode: 0x02ee size:0 bytes
Name approval request for:Ikkan race:9 class:1
Character creation request from Ikkan LS#40604 (172.174.101.176:2443) :
Name: Ikkan
Race: 9 Class: 1 Gender: 0 Deity: 211 Start zone: 5
STR STA AGI DEX WIS INT CHA Total
118 119 88 75 60 52 65 577
Face: 3 Eye colors: 0 0
Hairstyle: 0 Haircolor: 0
Beard: 0 Beardcolor: 0
Validating char creation info...
Found 0 errors in character creation request
No start_zones entry in database, using defaults
Current location: neriaka 156.92, -2.94, 31.75
Bind location: nektulos -258.77, -1198.27, -5.67
Character creation successful: Ikkan
Attempting autobootup of neriaka (40) for Ikkan
Error: No zoneserver to bootup neriaka (40) for Ikkan
Received unknown opcode: 0x02ee size:0 bytes
Attempting autobootup of neriaka (40) for Ikkan
Error: No zoneserver to bootup neriaka (40) for Ikkan
Received unknown opcode: 0x02ee size:0 bytes
Attempting autobootup of neriaka (40) for Ikkan
Error: No zoneserver to bootup neriaka (40) for Ikkan
Received unknown opcode: 0x02ee size:0 bytes
Name approval request for:Nazlug race:4 class:1
Character creation request from Ikkan LS#40604 (172.174.101.176:2443) :
Name: Nazlug
Race: 4 Class: 1 Gender: 0 Deity: 211 Start zone: 9
STR STA AGI DEX WIS INT CHA Total
75 100 100 80 80 75 75 585
Face: 6 Eye colors: 0 0
Hairstyle: 0 Haircolor: 255
Beard: 255 Beardcolor: 0
Validating char creation info...
Found 0 errors in character creation request
No start_zones entry in database, using defaults
Current location: gfaydark 10.00, -20.00, 0.00
Bind location: gfaydark 10.00, -20.00, 0.00
Character creation successful: Nazlug
Telling client to continue session with:
Client disconnected
Removing client from ip:172.174.101.176 port:2443
Received unknown opcode: 0x00f0 size:0 bytes
Client disconnected
Removing client from ip:192.168.0.254 port:1063
7221584 New client from ip: 192.168.0.254 port: 1080
Logged in: FirstLogin LS#42482: xeeman
Received unknown opcode: 0x02ee size:0 bytes
Received unknown opcode: 0x00f0 size:0 bytes
Client disconnected
Removing client from ip:192.168.0.254 port:1080
7403896 New client from ip: 192.168.0.254 port: 1086
Logged in: FirstLogin LS#42482: xeeman
Received unknown opcode: 0x02ee size:0 bytes
Attempting autobootup of gfaydark (54) for Xeeman
Error: No zoneserver to bootup gfaydark (54) for Xeeman
Received unknown opcode: 0x02ee size:0 bytes
World: processing ZTZ from egress zone (49) client: Furor
World (49): FAILED to boot a zone for Furor
Attempting autobootup of gfaydark (54) for Xeeman
Error: No zoneserver to bootup gfaydark (54) for Xeeman
Received unknown opcode: 0x02ee size:0 bytes
Attempting autobootup of gfaydark (54) for Xeeman
Error: No zoneserver to bootup gfaydark (54) for Xeeman
Received unknown opcode: 0x02ee size:0 bytes
Name approval request for:Boibl race:5 class:2
Character creation request from xeeman LS#42482 (192.168.0.254:1086) :
Name: Boibl
Race: 5 Class: 2 Gender: 0 Deity: 215 Start zone: 10
STR STA AGI DEX WIS INT CHA Total
60 70 85 75 130 92 80 592
Face: 1 Eye colors: 3 3
Hairstyle: 1 Haircolor: 255
Beard: 255 Beardcolor: 8
Validating char creation info...
Found 0 errors in character creation request
No start_zones entry in database, using defaults
Current location: felwithea 94.00, -25.00, 3.75
Bind location: gfaydark 10.00, -20.00, 0.00
Character creation successful: Boibl
Telling client to continue session with: Xeeman
Attempting autobootup of felwithea (61) for Boibl
Error: No zoneserver to bootup felwithea (61) for Boibl
Received unknown opcode: 0x02ee size:0 bytes
Attempting autobootup of gfaydark (54) for Xeeman
Error: No zoneserver to bootup gfaydark (54) for Xeeman
Received unknown opcode: 0x02ee size:0 bytes
World: processing ZTZ from egress zone (49) client: Furor
World (49): FAILED to boot a zone for Furor
Zoneserver SetZone: rexpage.homedns.org:7995 (0)
Zoneserver SetZone: rexpage.homedns.org:7995 (0)
7826985 New client from ip: 24.28.239.154 port: 4772
Logged in: FirstLogin LS#52231: Vasker88
Received unknown opcode: 0x02ee size:0 bytes
Received unknown opcode: 0x00f0 size:0 bytes
Client disconnected
Removing client from ip:24.28.239.154 port:4772
Attempting autobootup of gfaydark (54) for Xeeman
Zoneserver SetZone: rexpage.homedns.org:7995 gfaydark (54)
Enter world: Xeeman: gfaydark (54)
Broadcasting a world time update
Zoneserver SetZone: rexpage.homedns.org:7995 gfaydark (54)
Client disconnected
Removing client from ip:192.168.0.254 port:1086
8937802 New client from ip: 192.168.0.254 port: 1099
Logged in: FirstLogin LS#42482: xeeman
Enter world: Xeeman: gfaydark (54)
Zoneserver SetZone: rexpage.homedns.org:7995 gfaydark (54)
Client disconnected
Removing client from ip:192.168.0.254 port:1099
207.36.180.194:5997: TCPConnection::RecvData(): Error: 10054
Connected to LoginServer: eqlogin2.eqemulator.net:5997
World: processing ZTZ from egress zone (54) client: Xeeman
World (54): FAILED to boot a zone for Xeeman
24.174.184.4:5997: TCPConnection::RecvData(): Error: 10054
Connected to LoginServer: eqlogin1.eqemulator.net:5997
World: processing ZTZ from egress zone (54) client: Xeeman
World (54): FAILED to boot a zone for Xeeman
207.36.180.194:5997: TCPConnection::RecvData(): Error: 10054
Connected to LoginServer: eqlogin1.eqemulator.net:5997
207.36.180.194:5997: TCPConnection::RecvData(): Error: 10054
Error: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error:
10060'
Connected to LoginServer: eqlogin1.eqemulator.net:5997
10936836 New client from ip: 192.168.0.254 port: 1114
Logged in: FirstLogin LS#42482: xeeman
Zoneserver SetZone: rexpage.homedns.org:7995 (0)
Zoneserver SetZone: rexpage.homedns.org:7995 (0)
Received unknown opcode: 0x02ee size:0 bytes
Received unknown opcode: 0x00f0 size:0 bytes
Client disconnected
Removing client from ip:192.168.0.254 port:1114
11006196 New client from ip: 192.168.0.254 port: 1118
Logged in: FirstLogin LS#42482: xeeman
Received unknown opcode: 0x02ee size:0 bytes
Attempting autobootup of gfaydark (54) for Xeeman
Zoneserver SetZone: rexpage.homedns.org:7995 gfaydark (54)
Enter world: Xeeman: gfaydark (54)
Broadcasting a world time update
Zoneserver SetZone: rexpage.homedns.org:7995 gfaydark (54)
Client disconnected
Removing client from ip:192.168.0.254 port:1118
World: processing ZTZ from egress zone (54) client: Xeeman
World (54): FAILED to boot a zone for Xeeman
Zoneserver SetZone: rexpage.homedns.org:7995 (0)
Zoneserver SetZone: rexpage.homedns.org:7995 (0)
207.36.180.194:5997: TCPConnection::RecvData(): Error: 10054
Connected to LoginServer: eqlogin3.eqemulator.net:5997

Loosenut · #19 04-14-2004, 02:46 PM

When you say this

Quote:

5997
5999
7995-8015 (depending on how many zone servers you run - they all require a unique port)
9000

..Are those the ports we are allowed to used for boot5zones.bat?. Like only use those numbers for best performance or can we use any 4 digit numbers?

xeeman · #20 04-14-2004, 04:07 PM

PROBLEM SOLVED!

As usual, it was a stupid newbie problem. I forgot to put the darn port numbers for each of the zones in the load5zones.bat file!

Now I'm off to figure out how to do really cool things in EQEmu! :idea:

Monrezz · #21 04-14-2004, 09:24 PM

Heh, glad you got it sorted.

On the ports question:

5997 }
5999 } All Needed - cannot change.
9000 }
7995-8015 <= Zone servers can run on any port, but it's useful to have standardization.

xeeman · #22 04-15-2004, 12:41 AM

Quote:

..Are those the ports we are allowed to used for boot5zones.bat?. Like only use those numbers for best performance or can we use any 4 digit numbers?

Make sure that whatever ports you use, they are properly fwd'ed to your server if you are behind a router.

mikenune · #23 04-15-2004, 09:44 AM

Quote:

Originally Posted by Monrezz

7995-8015 <= Zone servers can run on any port, but it's useful to have standardization.

I think that should be:

7995-8015 >=

Basically, what you want to do is start with 7995 for your first zone, then just keep adding 1 for each Zone Server you start after the first. You shouldn't have to worry about anything comflicting unless you get to #1006 and try using port 9000

Monrezz · #24 04-15-2004, 10:41 PM

Quote:

Originally Posted by mikenune

I think that should be:

7995-8015 >=

Sorry, that was meant to be an arrow :P

<= Left!
=> Right!

Heh, sorry for the confusion.

diesalot · #25 04-29-2004, 02:07 PM

Glad I finally talked one of you into helping out this team. *smirk*
I'm Aerie over there. I had the issue with the spawn list conning fine, but all the mobs being white on Scorpious2K.
Still having that issue, btw. If ya pop over, I'm Pokke and Halfon mostly.

Looking forwards to crashing your server...

Pokke