Here are the latest logs

18:51:52 I Init: Starting EQ2Emulator WorldServer...
18:51:52 I DB: Using database 'eq2world' at 127.0.0.1
18:51:52 I Patcher: Connecting to DB PatchServer...
18:51:52 I Patcher: Connected to patch server at updates.eq2emulator.net:9104
18:51:52 E Patcher: You have tried to download updates too quickly and are now locked out, try again later
18:51:52 I World: Loading System Data...
18:51:53 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
18:51:53 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
18:51:53 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
18:51:53 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
18:51:53 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
18:51:53 E Packet: Could not find struct named 'WS_QuestExamineInfoHeader'
18:51:53 E Packet: Could not find struct named 'WS_QuestExamineInfoHeader'
18:51:54 I World: Loaded System Data (took 2 seconds)
18:51:54 W Threaded: Using Threaded loading of static data...
18:51:54 I Guilds: Loading Guilds...
18:51:54 W Thread: Item Loading Thread started.
18:51:54 I Guilds: Loaded 0 Guild(s)
18:51:54 I Recipes: Loading Recipe Books...
18:51:54 W Thread: Spell Loading Thread started.
18:51:54 I Recipes: Loading Recipes...
18:51:54 I DB: Using database 'eq2world' at 127.0.0.1
18:51:54 I DB: Using database 'eq2world' at 127.0.0.1
18:51:54 I Spells: Loading Spells...
18:51:54 I Items: Loading Items...
18:51:54 I Tradeskills: Loading Tradeskill Events...
18:51:54 I AA: Loading Alternate Advancements...
18:51:54 I AA: Loaded 0 Alternate Advancement(s)
18:51:54 I AA: Loading AA Tree Nodes...
18:51:54 I AA: Loaded 0 AA Tree Nodes
18:51:54 I Titles: Loading Titles...
18:51:54 I Languages: Loading Languages...
18:51:54 I Chat: Loading channels...
18:51:54 I LUA: Loading Spawn Scripts...
18:51:54 I LUA: Loading Zone Scripts...
18:51:54 I World: Loading House Zone Data...
18:51:54 I World: Loading Heroic OP Data...
18:51:54 I World: Loading Race Types Data...
18:51:54 I World: - Loaded 0 Race Types
18:51:54 I World: Waiting for load threads to finish.
18:51:54 I Items: Loaded 0 Total Items (took 0 seconds)
18:51:54 I Collect: Loading Collections...
18:51:54 I Merchants: Loading Merchants...
18:51:54 I Quests: Loading Quests...
18:51:54 W Thread: Item Loading Thread completed.
18:51:54 I Spells: Loaded 0 Spells (took 0 seconds)
18:51:54 I Spells: Loading Spell Errors...
18:51:54 I Traits: Loading Traits...
18:51:54 I Traits: Loaded 0 Trait(s)
18:51:54 W Thread: Spell Loading Thread completed.
18:51:54 I World: Load threads finished.
18:51:54 I World: Total World startup time: 2 seconds.
18:51:54 I Net: World server listening on: 127.0.0.1:9000
18:51:54 I Zone: Starting static zones...
18:51:54 I IRC: Starting global IRC server...
18:51:54 I Console: Type 'help' or '?' and press enter for menu options.
18:51:54 I World: Connected to LoginServer: 127.0.0.1: 9100


18:51:48 I DB: Using database 'eq2world' at 127.0.0.1
18:51:48 I Login: =====================================
18:51:48 I Login: Initializing Minilogin...
18:51:48 I Login: LoginServer.ini read.
18:51:48 I Login: Loading opcodes...
18:51:48 I Login: Loading Structs... SUCCESS!
18:51:48 I Login: Loading world list...
18:51:48 I Login: Login server listening on port: 9100
18:51:48 I Login: Kickstarting LoginServer Heartbeat...
18:51:54 I Login: 5716 New Server connection: 127.0.0.1, port: 30147
18:52:08 I Login: New client from ip: 192.168.1.*, port: 54572
18:52:28 I Login: New client from ip: 192.168.1.*, port: 54572
18:52:28 I Login: Using Login Packet version: 60114
18:54:17 I Login: New client from ip: 192.168.1.*, port: 54572
18:54:17 I Login: Using Login Packet version: 60114
18:54:47 I Login: New client from ip: 192.168.1.*, port: 51258
18:55:06 I Login: New client from ip: 192.168.1.*, port: 51258
18:55:06 I Login: Using Login Packet version: 60114
18:56:15 I Login: New client from ip: 192.168.1.*, port: 51258
18:56:16 I Login: Using Login Packet version: 60114

And still can't get into the world?

Logs are showing no errors at this point, however I do not see anything in world to indicate a character was created, though the logs for that might be disabled by default. If you still can't get into the world then I would suggest opening up log_config.xml and going through each category setting enabled on every config to true except trace and packet and level = 0, this will spit out more in the logs that might give a clue if you still can't get into the world.

Here is an example of what I mean, this is the world category As you can see Level="0" for everything and only packet and trace are disabled, every thing else is enabled. Do this for all categories and then run the servers again.

no such luck unfortunately

Does your world server DB have a character in it? Also did the logs after changing the log_config.xml give anything interesting?

not sure what you mean about the world server. I have 2 accounts set up for testing and each has a character or 2 in it, none of which seem to log in

here is the last info

19:44:45 I Init: Starting EQ2Emulator WorldServer...
19:44:45 I DB: Using database 'eq2world' at 127.0.0.1
19:44:45 I Patcher: Connecting to DB PatchServer...
19:44:45 I Patcher: Connected to patch server at updates.eq2emulator.net:9104
19:44:45 I Patcher: Server is up to date
19:44:45 I World: Loading System Data...
19:44:46 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
19:44:46 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
19:44:46 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
19:44:46 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
19:44:46 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
19:44:46 E Packet: Could not find struct named 'WS_QuestExamineInfoHeader'
19:44:46 E Packet: Could not find struct named 'WS_QuestExamineInfoHeader'
19:44:47 I World: Loaded System Data (took 2 seconds)
19:44:47 W Threaded: Using Threaded loading of static data...
19:44:47 I Guilds: Loading Guilds...
19:44:47 W Thread: Item Loading Thread started.
19:44:47 W Thread: Spell Loading Thread started.
19:44:47 I Guilds: Loaded 0 Guild(s)
19:44:47 I Recipes: Loading Recipe Books...
19:44:47 I Recipes: Loading Recipes...
19:44:47 I DB: Using database 'eq2world' at 127.0.0.1
19:44:47 I DB: Using database 'eq2world' at 127.0.0.1
19:44:47 I Tradeskills: Loading Tradeskill Events...
19:44:47 I AA: Loading Alternate Advancements...
19:44:47 I AA: Loaded 0 Alternate Advancement(s)
19:44:47 I AA: Loading AA Tree Nodes...
19:44:47 I Spells: Loading Spells...
19:44:47 I AA: Loaded 0 AA Tree Nodes
19:44:47 I Titles: Loading Titles...
19:44:47 I Languages: Loading Languages...
19:44:47 I Chat: Loading channels...
19:44:47 I LUA: Loading Spawn Scripts...
19:44:47 I LUA: Loading Zone Scripts...
19:44:47 I World: Loading House Zone Data...
19:44:47 I World: Loading Heroic OP Data...
19:44:47 I World: Loading Race Types Data...
19:44:47 I World: - Loaded 0 Race Types
19:44:47 I World: Waiting for load threads to finish.
19:44:47 I Items: Loading Items...
19:44:47 I Items: Loaded 0 Total Items (took 0 seconds)
19:44:47 I Collect: Loading Collections...
19:44:47 I Merchants: Loading Merchants...
19:44:47 I Quests: Loading Quests...
19:44:47 W Thread: Item Loading Thread completed.
19:44:47 I Spells: Loaded 0 Spells (took 0 seconds)
19:44:47 I Spells: Loading Spell Errors...
19:44:47 I Traits: Loading Traits...
19:44:47 I Traits: Loaded 0 Trait(s)
19:44:47 W Thread: Spell Loading Thread completed.
19:44:47 I World: Load threads finished.
19:44:47 I World: Total World startup time: 2 seconds.
19:44:47 I Net: World server listening on: 127.0.0.1:9000
19:44:47 I Zone: Starting static zones...
19:44:47 I IRC: Starting global IRC server...
19:44:47 I Console: Type 'help' or '?' and press enter for menu options.
19:44:47 I World: Connected to LoginServer: 127.0.0.1: 9100


19:44:40 I DB: Using database 'eq2world' at 127.0.0.1
19:44:40 I Login: =====================================
19:44:40 I Login: Initializing Minilogin...
19:44:40 I Login: LoginServer.ini read.
19:44:40 I Login: Loading opcodes...
19:44:40 I Login: Loading Structs... SUCCESS!
19:44:40 I Login: Loading world list...
19:44:40 I Login: Login server listening on port: 9100
19:44:40 I Login: Kickstarting LoginServer Heartbeat...
19:44:47 I Login: 6973 New Server connection: 127.0.0.1, port: 47299
19:45:03 I Login: New client from ip: 192.168.1.*, port: 63739
19:47:29 I Login: New client from ip: 192.168.1.*, port: 63739
19:47:30 I Login: Using Login Packet version: 60114
19:49:10 I Login: New client from ip: 192.168.1.*, port: 63739
19:49:10 I Login: Using Login Packet version: 60114

Skywalker646 wrote: Mon Dec 10, 2018 8:52 pm not sure what you mean about the world server.

the DB that eq2world.exe uses, according to your log the db name is eq2world, so does that DB have any characters in it?

From what I can see from the logd login is not talking to world, when a character is created or a character is selected and play is hit there should be some info in the world console. What exactly is it doing now?

oh yes, it is showing all the characters i created, so it seems to be sending them to the database at least. As for what happens, i click to enter the world and it hangs on "connecting to zone server" before sending the client back to the character select screen

For whatever reason login is not talking to world in your case, same goes for the client. When you hit play the login server will send a packet with the address of the world server to connect to and the client should attempt a connection there, however your log shows no incoming connections on the world server so the client communication isn't even reaching it.

You appear to be using 127.0.0.1 for the ip so port forwarding isn't the issue here. The only thing I can think of that would block communication is the firewall. Do you have a rule for port 9000?

i actually disabled the firewall completely and still have the same issue

Can you post the contents of your loginserver.ini then?

### --- This file tells world.exe what loginserver to connect to.
### --- Change the account and password fields to the information you used when you created your SERVER account.

### --- NOTE: the word "Server" is added to each server automaticly.

# READ README.TXT

[LoginServer]
loginserver=127.0.0.1
loginport=9100
worldname=Name
worldaddress=127.0.0.1
# internalworldaddress=
worldport=9000
locked=false
account=Account from SQL
password=Password from SQL
#autotableupdates retrieves the latest table updates and applies them to your database
#autotableupdates valid options=always, ask, and never
autotableupdates=always
#autotableverbose displays detailed information about the updates; options=true or false
autotableverbose=True
#autotabledata retrieves the latest data for tables like the opcodes table; options=true or false
autotabledata=true

[WorldServer]
Defaultstatus=
Unavailzone=

[UpdateServer]
updateserveraddress=updates.eq2emulator.net
updateserverport=9104

[LoginConfig]
ServerMode=StandAlone
ServerPort=9100

i was fiddling with the loginserver.ini file and dropped out worldaddress and added my 192.168... addie to the internal one after reading some material on the settings, but now the client just completely closes out when i try to enter the world. No error messages in the server though

Can you use the attached log_config.xml and replace the one you are currently using and then restart both minilogin and world and then post the produced log after attempting to log in. Also put the ip's back to 127.0.0.1 in loginserver.ini. This won't solve the error but hopefully the log it produces will give us a clue on what is going wrong.

Something that was just pointed out to me is that the loginstructs.xml is not visible on svn so I will attach the latest version, drop this in with minilogin and overwrite the old.

here are the logs from the new code

20:47:29 I DB: Using database 'eq2world' at 127.0.0.1
20:47:29 W Misc: Error parsing log config. Log setting 'Enabled' has invalid value 'FaTruelse'. 'true'/'on' or 'false'/'off' are valid values
20:47:29 I Login: =====================================
20:47:29 I Login: Initializing Minilogin...
20:47:29 I Login: LoginServer.ini read.
20:47:29 I Login: Loading opcodes...
20:47:29 D DBCore: Query Successful, 38 rows returned
20:47:29 D DBCore: Query Successful, 527 rows returned
20:47:29 D DBCore: Query Successful, 527 rows returned
20:47:29 D DBCore: Query Successful, 528 rows returned
20:47:29 D DBCore: Query Successful, 528 rows returned
20:47:29 D DBCore: Query Successful, 528 rows returned
20:47:29 D DBCore: Query Successful, 531 rows returned
20:47:29 D DBCore: Query Successful, 558 rows returned
20:47:29 D DBCore: Query Successful, 558 rows returned
20:47:29 D DBCore: Query Successful, 558 rows returned
20:47:29 D DBCore: Query Successful, 558 rows returned
20:47:29 D DBCore: Query Successful, 558 rows returned
20:47:29 D DBCore: Query Successful, 559 rows returned
20:47:29 D DBCore: Query Successful, 559 rows returned
20:47:30 D DBCore: Query Successful, 558 rows returned
20:47:30 D DBCore: Query Successful, 558 rows returned
20:47:30 D DBCore: Query Successful, 558 rows returned
20:47:30 D DBCore: Query Successful, 558 rows returned
20:47:30 D DBCore: Query Successful, 558 rows returned
20:47:30 D DBCore: Query Successful, 559 rows returned
20:47:30 D DBCore: Query Successful, 559 rows returned
20:47:30 D DBCore: Query Successful, 559 rows returned
20:47:30 D DBCore: Query Successful, 559 rows returned
20:47:30 D DBCore: Query Successful, 559 rows returned
20:47:30 D DBCore: Query Successful, 559 rows returned
20:47:30 D DBCore: Query Successful, 559 rows returned
20:47:30 D DBCore: Query Successful, 559 rows returned
20:47:30 D DBCore: Query Successful, 559 rows returned
20:47:30 D DBCore: Query Successful, 559 rows returned
20:47:30 D DBCore: Query Successful, 560 rows returned
20:47:30 D DBCore: Query Successful, 560 rows returned
20:47:30 D DBCore: Query Successful, 560 rows returned
20:47:30 D DBCore: Query Successful, 560 rows returned
20:47:30 D DBCore: Query Successful, 560 rows returned
20:47:30 D DBCore: Query Successful, 560 rows returned
20:47:30 D DBCore: Query Successful, 560 rows returned
20:47:30 D DBCore: Query Successful, 560 rows returned
20:47:30 D DBCore: Query Successful, 560 rows returned
20:47:30 D DBCore: Query Successful, 560 rows returned
20:47:30 I Login: Loading Structs... SUCCESS!
20:47:30 I Login: Loading world list...
20:47:30 D DBCore: Query returned no results in DBcore::RunQuery!
update login_worldstats set world_status=-4, current_players=0, current_zones=0
20:47:30 I Login: Login server listening on port: 9100
20:47:30 D World: Starting factory Reader
20:47:30 D World: Starting factory Writer
20:47:30 I Login: Kickstarting LoginServer Heartbeat...
20:47:30 D DBCore: Query returned no results in DBcore::RunQuery!
UPDATE login_config SET config_value = 1544590050 WHERE config_name = 'login_heartbeat'
20:47:40 I Login: 10283 New Server connection: 127.0.0.1, port: 44229
20:47:40 D Opcode: Opcode 1000 (4096): ServerOP_LSInfo
20:47:40 D DBCore: Query Successful, 1 rows returned
20:47:40 D DBCore: Query Successful, 1 rows returned
20:47:40 D DBCore: Query Successful, 1 rows returned
20:47:40 D DBCore: Query returned no results in DBcore::RunQuery!
update login_worldservers set login_version='0.7.3-dev' where id=1
20:47:40 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus
20:47:40 D DBCore: Query returned no results in DBcore::RunQuery!
update login_worldstats set connected_time=now() where world_id=1 and (UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_update)) > 300
20:47:40 D DBCore: Query returned no results in DBcore::RunQuery!
update login_worldservers set lastseen=1544590060 where id=1
20:47:40 D DBCore: Query returned no results in DBcore::RunQuery!
update login_worldservers set ip_address='127.0.0.1' where id=1
20:47:55 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus
20:48:10 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus
20:48:25 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus
20:48:40 D DBCore: Query returned no results in DBcore::RunQuery!
insert into login_worldstats (world_id, world_status, current_players, current_zones, last_update, world_max_level) values(1, 1, 0, 0, NOW(), 50) ON DUPLICATE KEY UPDATE current_players=0,current_zones=0,world_max_level=50,world_status=1,last_update=NOW()
20:48:40 D DBCore: Query returned no results in DBcore::RunQuery!
update login_worldservers set lastseen=1544590120 where id=1
20:48:40 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus
20:48:51 I Login: New client from ip: 192.168.1.*, port: 63902
20:48:55 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus
20:49:10 D World: Removing connection...
20:49:10 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus
20:49:12 I Login: New client from ip: 192.168.1.*, port: 63902
20:49:12 D Opcode: Opcode 0001 (1): ServerOP_LSInfo
20:49:12 D Login: First struct version = 44392
20:49:12 D Login: First struct failed, trying the second
20:49:12 D Login: Second struct version = 60114
20:49:12 D DBCore: Query Successful, 1 rows returned
20:49:12 D DBCore: Query returned no results in DBcore::RunQuery!
UPDATE account SET ip_address='192.168.1.*' WHERE id = 2
20:49:12 I Login: Using Login Packet version: 60114
20:49:12 D Opcode: Opcode 0021 (33): OP_LsClientVerifylogReplyMsg
20:49:12 D Logs: Saving 'Verify Log' log, size of: 683
20:49:12 D DBCore: Query returned no results in DBcore::RunQuery!
insert into log_messages (log_type, message, account, client_data_version, log_time) values ('Verify Log', 'build=\"SOEBuild=12133L\" version=\"SOEVersionString=2015/8/17 11:12:50\" build_type=\"USER OPTIMIZED\" ls_address=\"none\" zone=\"<None>\" loc=\" 0.00 0.00 0.00\" performance=\"3\" alert=\"G:\\live\\eq2\\framework\\vdl\\VdlErr.cpp(85): (VDL Parser) runtimevdl/cbaseclasses.vdl(21) : Error, File not found, runtimevdl/services.vdl.\n\"\nbuild=\"SOEBuild=12133L\" version=\"SOEVersionString=2015/8/17 11:12:50\" build_type=\"USER OPTIMIZED\" ls_address=\"none\" zone=\"<None>\" loc=\" 0.00 0.00 0.00\" performance=\"3\" alert=\"G:\\live\\eq2\\framework\\vdl\\VdlErr.cpp(85): (VDL Parser) runtimevdl/cbaseclasses.vdl(22) : Error, File not found, runtimevdl/soemote.vdl.\n\"\n', 'mattgasser', 60114, 1544590152)
20:49:25 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus
20:49:27 D Opcode: Opcode 0008 (8): OP_AllWSDescRequestMsg
20:49:27 D Opcode: Opcode 000A (10): OP_AllCharactersDescRequestMsg
20:49:27 D DBCore: Query Successful, 2 rows returned
20:49:27 D DBCore: Query Successful, 0 rows returned
20:49:27 D DBCore: Query Successful, 1 rows returned
20:49:27 D DBCore: Query Successful, 47 rows returned
20:49:27 D DBCore: Query Successful, 0 rows returned
20:49:27 D DBCore: Query Successful, 0 rows returned
20:49:27 D DBCore: Query Successful, 1 rows returned
20:49:27 D DBCore: Query Successful, 47 rows returned
20:49:27 D DBCore: Query Successful, 0 rows returned
20:49:34 D Opcode: Opcode 0013 (19): OP_PlayCharacterRequestMsg
20:49:34 D DBCore: Query Successful, 1 rows returned
20:49:34 D Opcode: Opcode AB01 (43777): ServerOP_UsertoWorldResp
20:49:40 D DBCore: Query returned no results in DBcore::RunQuery!
insert into login_worldstats (world_id, world_status, current_players, current_zones, last_update, world_max_level) values(1, 1, 0, 0, NOW(), 50) ON DUPLICATE KEY UPDATE current_players=0,current_zones=0,world_max_level=50,world_status=1,last_update=NOW()
20:49:40 D DBCore: Query returned no results in DBcore::RunQuery!
update login_worldservers set lastseen=1544590180 where id=1
20:49:40 D Opcode: Opcode 1001 (4097): ServerOP_LSStatus


20:47:38 W Misc: Error parsing log config. Log setting 'Enabled' has invalid value 'FaTruelse'. 'true'/'on' or 'false'/'off' are valid values
20:47:38 I Init: Starting EQ2Emulator WorldServer...
20:47:38 I DB: Using database 'eq2world' at 127.0.0.1
20:47:38 D World: Randomizing World...
20:47:38 D Init: ./LoginServer.ini read...
20:47:38 I Patcher: Connecting to DB PatchServer...
20:47:38 I Patcher: Connected to patch server at updates.eq2emulator.net:9104
20:47:38 I Patcher: Server is up to date
20:47:38 I World: Loading System Data...
20:47:38 D DBCore: Query Successful, 38 rows returned
20:47:38 D DBCore: Query Successful, 527 rows returned
20:47:38 D DBCore: Query Successful, 527 rows returned
20:47:38 D DBCore: Query Successful, 528 rows returned
20:47:38 D DBCore: Query Successful, 528 rows returned
20:47:38 D DBCore: Query Successful, 528 rows returned
20:47:38 D DBCore: Query Successful, 531 rows returned
20:47:38 D DBCore: Query Successful, 558 rows returned
20:47:38 D DBCore: Query Successful, 558 rows returned
20:47:38 D DBCore: Query Successful, 558 rows returned
20:47:38 D DBCore: Query Successful, 558 rows returned
20:47:38 D DBCore: Query Successful, 558 rows returned
20:47:38 D DBCore: Query Successful, 559 rows returned
20:47:38 D DBCore: Query Successful, 559 rows returned
20:47:38 D DBCore: Query Successful, 558 rows returned
20:47:38 D DBCore: Query Successful, 558 rows returned
20:47:38 D DBCore: Query Successful, 558 rows returned
20:47:38 D DBCore: Query Successful, 558 rows returned
20:47:38 D DBCore: Query Successful, 558 rows returned
20:47:38 D DBCore: Query Successful, 559 rows returned
20:47:38 D DBCore: Query Successful, 559 rows returned
20:47:38 D DBCore: Query Successful, 559 rows returned
20:47:38 D DBCore: Query Successful, 559 rows returned
20:47:38 D DBCore: Query Successful, 559 rows returned
20:47:38 D DBCore: Query Successful, 559 rows returned
20:47:38 D DBCore: Query Successful, 559 rows returned
20:47:38 D DBCore: Query Successful, 559 rows returned
20:47:38 D DBCore: Query Successful, 559 rows returned
20:47:38 D DBCore: Query Successful, 559 rows returned
20:47:38 D DBCore: Query Successful, 560 rows returned
20:47:38 D DBCore: Query Successful, 560 rows returned
20:47:38 D DBCore: Query Successful, 560 rows returned
20:47:38 D DBCore: Query Successful, 560 rows returned
20:47:38 D DBCore: Query Successful, 560 rows returned
20:47:38 D DBCore: Query Successful, 560 rows returned
20:47:38 D DBCore: Query Successful, 560 rows returned
20:47:38 D DBCore: Query Successful, 560 rows returned
20:47:38 D DBCore: Query Successful, 560 rows returned
20:47:38 D DBCore: Query Successful, 560 rows returned
20:47:39 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
20:47:39 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
20:47:39 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
20:47:39 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
20:47:39 E Packet: Could not find struct named 'Substruct_TargetSpellEffects'
20:47:39 E Packet: Could not find struct named 'WS_QuestExamineInfoHeader'
20:47:39 E Packet: Could not find struct named 'WS_QuestExamineInfoHeader'
20:47:40 D DBCore: Query Successful, 1 rows returned
20:47:40 D DBCore: Query Successful, 437 rows returned
20:47:40 D DBCore: Query Successful, 69 rows returned
20:47:40 D DBCore: Query Successful, 224 rows returned
20:47:40 D DBCore: Query Successful, 17 rows returned
20:47:40 D DBCore: Query Successful, 175 rows returned
20:47:40 D DBCore: Query Successful, 7 rows returned
20:47:40 D DBCore: Query Successful, 21670 rows returned
20:47:40 D DBCore: Query Successful, 126 rows returned
20:47:40 D DBCore: Query returned no results in DBcore::RunQuery!
update character_details set xp_vitality=100 where (xp_vitality + 0.000000) > 100
20:47:40 D DBCore: Query returned no results in DBcore::RunQuery!
update character_details set xp_vitality=(xp_vitality+0.000000) where (xp_vitality + 0.000000) <= 100
20:47:40 D DBCore: Query returned no results in DBcore::RunQuery!
update variables set variable_value=1544590060 where variable_name='vitalitytimer'
20:47:40 D DBCore: Query Successful, 6 rows returned
20:47:40 D DBCore: Query returned no results in DBcore::RunQuery!
UPDATE characters SET is_online = 0;
20:47:40 D DBCore: Query Successful, 1 rows returned
20:47:40 D DBCore: Query Successful, 82 rows returned
20:47:40 D DBCore: Query Successful, 1 rows returned
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 I World: Loaded System Data (took 2 seconds)
20:47:40 W Threaded: Using Threaded loading of static data...
20:47:40 M Reformat: JA: This is as far as I got reformatting the console logs.
20:47:40 I Guilds: Loading Guilds...
20:47:40 W Thread: Item Loading Thread started.
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 I Guilds: Loaded 0 Guild(s)
20:47:40 I Recipes: Loading Recipe Books...
20:47:40 W Thread: Spell Loading Thread started.
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Recipes: Loaded 0 Recipe Books
20:47:40 I Recipes: Loading Recipes...
20:47:40 I DB: Using database 'eq2world' at 127.0.0.1
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Recipes: Loaded 0 recipes
20:47:40 I DB: Using database 'eq2world' at 127.0.0.1
20:47:40 I Tradeskills: Loading Tradeskill Events...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Tradeskills: Loaded 0 tradeskill events
20:47:40 I AA: Loading Alternate Advancements...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 I AA: Loaded 0 Alternate Advancement(s)
20:47:40 I AA: Loading AA Tree Nodes...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 I AA: Loaded 0 AA Tree Nodes
20:47:40 I Titles: Loading Titles...
20:47:40 D DBCore: Query Successful, 472 rows returned
20:47:40 D World: Loaded 472 Titles
20:47:40 I Languages: Loading Languages...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D World: Loaded 0 Languages
20:47:40 I Chat: Loading channels...
20:47:40 I LUA: Loading Spawn Scripts...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D LUA: Loaded 0 SpawnScripts
20:47:40 I LUA: Loading Zone Scripts...
20:47:40 D DBCore: Query Successful, 795 rows returned
20:47:40 D LUA: Loaded 6 ZoneScripts
20:47:40 I World: Loading House Zone Data...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 I World: Loading Heroic OP Data...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 I World: Loading Race Types Data...
20:47:40 I World: - Loaded 0 Race Types
20:47:40 I World: Waiting for load threads to finish.
20:47:40 I Spells: Loading Spells...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 I Items: Loading Items...
20:47:40 D Items: Loaded 0 Normal Items
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 Baubles
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 Bags
20:47:40 D Items: Loaded 0 Books
20:47:40 D Items: Loaded 0 Item Sets
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 House Items
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 Food Items
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 Weapons
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 Ranged Weapons
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 Thrown Weapons
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 Armor Pieces
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 Shields
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 Skill Items
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 Adornment Items
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 Recipe Book Items
20:47:40 D Items: Loaded 0 House Containers
20:47:40 D Items: Loading Item Appearances...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 Item Appearances
20:47:40 D Items: Loading Item Stats...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 Item Stats
20:47:40 D Items: Loading Item Effects...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 Item Effects
20:47:40 D Items: Loading Item Level Overrides...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Items: Loaded 0 Item Level Overrides
20:47:40 I Items: Loaded 0 Total Items (took 0 seconds)
20:47:40 D DBCore: Query Successful, 1 rows returned
20:47:40 I Collect: Loading Collections...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Collect: Loaded 0 collections
20:47:40 D Collect: Loaded 0 collection items
20:47:40 D Collect: Loaded 0 collection rewards
20:47:40 I Merchants: Loading Merchants...
20:47:40 D Merchant: Clearing Merchant Inventory...
20:47:40 D Merchant: Loading Merchant Inventory...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Merchant: Loaded 0 Merchant Inventory Item(s)
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Merchant: Loaded 0 Merchant List(s)
20:47:40 I Quests: Loading Quests...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Quest: Loaded 0 Quest(s)
20:47:40 W Thread: Item Loading Thread completed.
20:47:40 D Spells: Loading Spell Effects...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Spells: Loaded 0 Spell Effects.
20:47:40 D Spells: Loading Spell LUA Data...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Spells: Loaded 0 Spell LUA Data entries.
20:47:40 D Spells: Loading Spells Scripts...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Spells: Loaded 0 SpellScripts
20:47:40 I Spells: Loaded 0 Spells (took 0 seconds)
20:47:40 I Spells: Loading Spell Errors...
20:47:40 D DBCore: Query Successful, 328 rows returned
20:47:40 I Traits: Loading Traits...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 I Traits: Loaded 0 Trait(s)
20:47:40 W Thread: Spell Loading Thread completed.
20:47:40 I World: Load threads finished.
20:47:40 I World: Total World startup time: 2 seconds.
20:47:40 D World: Starting factory Reader
20:47:40 D World: Starting factory Writer
20:47:40 I Net: World server listening on port 9000
20:47:40 I Zone: Starting static zones...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 I IRC: Starting global IRC server...
20:47:40 D IRC: Connecting to IRC server irc.eq2emulator.net:6667.
20:47:40 D IRC: Successfully connected to the global IRC server!
20:47:40 D Thread: Starting console command thread...
20:47:40 I Console: Type 'help' or '?' and press enter for menu options.
20:47:40 D Thread: Starting autoinit loginserver thread...
20:47:40 I World: Connected to LoginServer: 127.0.0.1: 9100
20:47:40 D Opcode: Opcode 0x201C (8220): ServerOP_ZoneUpdates
20:47:40 D Login: Looking for Login Zone Updates...
20:47:40 D DBCore: Query Successful, 0 rows returned
20:47:40 D Opcode: Opcode 0x201D (8221): ServerOP_LoginEquipment
20:47:40 M TODO: Implement map<character id <map<slot id, updatestruct> > method to update Login.
..\..\source\WorldServer\LoginServer.cpp, LoginServer::Process, 242
20:47:40 D Login: Looking for Login Appearance Updates...
20:48:40 D DBCore: Query returned no results in DBcore::RunQuery!
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 101, 1544590060, 1544590060) ON DUPLICATE KEY UPDATE stat_value = 1544590060, stat_date = 1544590060;
20:48:40 D DBCore: Query returned no results in DBcore::RunQuery!
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 102, 0, 1544590060) ON DUPLICATE KEY UPDATE stat_value = 0, stat_date = 1544590060;
20:48:40 D DBCore: Query returned no results in DBcore::RunQuery!
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 107, 0, 1544590060) ON DUPLICATE KEY UPDATE stat_value = 0, stat_date = 1544590060;
20:48:40 D DBCore: Query Successful, 1 rows returned
20:48:40 D DBCore: Query returned no results in DBcore::RunQuery!
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 104, 2, 1544590120) ON DUPLICATE KEY UPDATE stat_value = 2, stat_date = 1544590120;
20:48:40 D DBCore: Query Successful, 1 rows returned
20:48:40 D DBCore: Query returned no results in DBcore::RunQuery!
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 105, 4, 1544590120) ON DUPLICATE KEY UPDATE stat_value = 4, stat_date = 1544590120;
20:48:40 D DBCore: Query Successful, 1 rows returned
20:48:40 D DBCore: Query returned no results in DBcore::RunQuery!
INSERT INTO statistics (char_id, guild_id, stat_id, stat_value, stat_date) VALUES(0, 0, 106, 1, 1544590120) ON DUPLICATE KEY UPDATE stat_value = 1, stat_date = 1544590120;