Ok, i renamed the unknown008 column to SpellCharges ... which fixes the errors my word.exe was giving me.
Now for more errors/bugs:
Once i've create a character and log off.... the next time i log on, it will not be available at char selection.
However, the char is added to the character column...
Whenever i create a new character ... an entry is added to my account column -->
in this case under name:TwŸ0ŒÌ±(÷ cóÙ`*÷£„,æw .. and then the char name.
I cannot log on my server without deleting this new entry.
When my roommate connects to my server (via local network), he can create a character ... and the info about his char is stored like it is supposed to be , and the character is available at char selection after logging off.
However, when my roommate logs in, it just freeze upon zone entrance.
**************************************************
world, minilogin, boot5zones output
**************************************************
world.exe
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR1
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=34229, max id=77505
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Breaking linux compiles....
TCP listening on: 66.253.xxx.xxx:9000
World server listening on: 66.253.xxx.xxx:9000
Connected to LoginServer: 66.253.xxx.xxx:5999
22312 New TCP connection: 127.0.0.1:2718
22312 New TCP connection: 127.0.0.1:2719
New zoneserver: #1 127.0.0.1:2719
New zoneserver: #2 127.0.0.1:2718
Zoneserver SetConnectInfo: 127.0.0.1:2718: 66.253.xxx.xxx:8784
Zoneserver SetConnectInfo: 127.0.0.1:2719: 66.253.xxx.xxx:8780
22390 New TCP connection: 127.0.0.1:2720
22390 New TCP connection: 127.0.0.1:2721
22390 New TCP connection: 127.0.0.1:2722
New zoneserver: #3 127.0.0.1:2722
New zoneserver: #4 127.0.0.1:2721
New zoneserver: #5 127.0.0.1:2720
Zoneserver SetConnectInfo: 127.0.0.1:2720: 66.253.xxx.xxx:8781
Zoneserver SetConnectInfo: 127.0.0.1:2721: 66.253.xxx.xxx:8783
Zoneserver SetConnectInfo: 127.0.0.1:2722: 66.253.xxx.xxx:8782
49156 New client from ip: 66.253.xxx.xxx port: 2724
Account Attempting to be created:Twƒ0î??(??c??`¡??úä,µw 20
Logged in: FirstLogin Account #5: Twƒ0î??(??c??`¡??úä,µw
Received unknown opcode: 0x02eb size:0 bytes
Name approval request for:Cleric race:8 class:2
Character creation request from Twƒ0î??(??c??`¡??úä,µw LS#0 (66.253.xxx.xxx:2724
) :
Name: Cleric
Race: 8 Class: 2 Gender: 0 Deity: 202 Start zone: 8
STR STA AGI DEX WIS INT CHA Total
120 100 70 90 93 60 45 578
Face: 7 Eye colors: 5 5
Hairstyle: 1 Haircolor: 14
Beard: 1 Beardcolor: 14
Validating char creation info...
Found 0 errors in character creation request
[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE p
layer_choice=8 AND player_class=2 AND player_deity=202 AND player_race=8
[Status] Found starting location in start_zones
Current location: kaladima 771.00, 132.00, 2.00
Bind location: kaladima 771.00, 132.00, 2.00
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (rac
e = 8 or race = 0) AND (class = 2 or class = 0) AND (deityid = 202 or deityid=0)
AND (zoneid = 60 or zoneid = 0) AND gm <= 20 ORDER BY id
Character creation successful: Cleric
Read group ID for 'Cleric': 0
0: 2C 30 2C 2E 52 65 74 61 - 72 64 2C 30 36 37 61 37 | ,0,.Cleric,067a7
16: 39 64 34 00 | 9d4.
Attempting autobootup of kaladima (60) for Cleric
Zoneserver SetZone: 66.253.xxx.xxx:8781 kaladima (60)
Enter world: Cleric: kaladima (60)
Broadcasting a world time update
Zoneserver SetZone: 66.253.xxx.xxx:8781 kaladima (60)
Client disconnected
Removing client from ip:66.253.xxx.xxx port:2724
244875 New client from ip: 66.253.xxx.xxx port: 1089
Logged in: FirstLogin Account #3: gabelord
301578 New client from ip: 66.253.xxx.xxx port: 2729
Logged in: FirstLogin Account #1: cyberstormx
Could not get CharInfo for Cleric
Client disconnected
Removing client from ip:66.253.xxx.xxx port:2729
Received unknown opcode: 0x02eb size:0 bytes
Read group ID for 'Gabriel': 0
0: 2C 30 2C 2E 47 61 62 72 - 69 65 6C 2C 30 36 37 61 | ,0,.Gabriel,067a
16: 37 39 64 34 00 | 79d4.
Attempting autobootup of qeynos (1) for Gabriel
Zoneserver SetZone: 66.253.xxx.xxx:8783 qeynos (1)
Enter world: Gabriel: qeynos (1)
Broadcasting a world time update
Zoneserver SetZone: 66.253.xxx.xxx:8783 qeynos (1)
Received unknown opcode: 0x0376 size:0 bytes
Client disconnected
Removing client from ip:66.253.xxx.xxx port:1089
Zoneserver SetZone: 66.253.xxx.xxx:8781 (0)
Zoneserver SetZone: 66.253.xxx.xxx:8781 (0)
Zoneserver SetZone: 66.253.xxx.xxx:8783 (0)
Zoneserver SetZone: 66.253.xxx.xxx:8783 (0)
Minilogin.exe
LoginServer.ini read.
Server mode: Standalone
Login server listening on port:5999
5671 New Server connection: 66.253.xxx.xxx port: 40202
49921 New client from ip: 127.0.0.1 port: 2723
240187 New client from ip: 66.253.xxx.xxx port: 1088
313859 New client from ip: 127.0.0.1 port: 2731
Zone.exe (roommate's that freezes immediately)
[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR1
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 170 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000
Map ./Maps/qeynos.map not found.
[Status] Weather should change in 3856 seconds
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 1; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for qeynos ...
[Status] Done loading doors for qeynos ...
[Status] Zone Bootup: qeynos (1)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [01:04 am]
[Status] 323125 New client from ip:66.253.xxx.xxx port:1091
Read group ID for 'Gabriel': 0
Setting stats for BL Pet for Race: 1
No pet type modifications defined for race: 1
Summoning BeastLord Pet: 43
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x037f, size: 0
Setting stats for BL Pet for Race: 1
No pet type modifications defined for race: 1
Summoning BeastLord Pet: 43
Setting stats for BL Pet for Race: 1
No pet type modifications defined for race: 1
Summoning BeastLord Pet: 43
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x0355, size: 4
Unknown opcode: 0x01e5 size:8 Client:Gabriel
0: 0A 00 00 00 D2 3E 73 7D | .....>s}
Setting stats for BL Pet for Race: 1
No pet type modifications defined for race: 1
Summoning BeastLord Pet: 43
Client linkdead: Gabriel
Dropping client: Process=false, ip=66.253.xxx.xxx, port=1091
[Status] Zone Shutdown: qeynos (1)
Zone.exe (My char zoning in ... Get booted to server select when i get killed.)
[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR1
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 170 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000
Map ./Maps/kaladima.map not found.
[Status] Weather should change in 2400 seconds
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 60; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for kaladima ...
[Status] Done loading doors for kaladima ...
[Status] Zone Bootup: kaladima (60)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [11:49 pm]
[Status] 99640 New client from ip:66.253.xxx.xxx port:2726
Read group ID for 'Cleric': 0
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x037f, size: 0
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x0355, size: 4
Unknown opcode: 0x01e5 size:8 Client:Cleric
0: 0A 00 00 00 D2 3E 73 7D | .....>s}
[Status] Zoning 'Cleric' to: kaladima (60) x=-179.000000, y=3131.000000, z=3.130
000
Dropping client: Process=false, ip=66.253.xxx.xxx, port=2726
[Status] Zone Shutdown: kaladima (60)
************************************************** ***
Whenever i try to zone i seem to get black screen or get booted to server select.
Roommate's freezes upon zone entrance, post character select.
Any ideas ?
*Edit: Seems my roommate only had trouble with qeynos, he started a new character in halas, and it works like a charm .. zoning and everything.
I , the host, can still not zone correctly ... or see my chars at char selection.