2020-09-26 21:09:09.6521 [Thread-1] DEBUG DBConnector - SELECT `server_id`, `url`, `port` FROM `eod_configuration`.`table_chatting_server`; 2020-09-26 21:09:09.6677 [Thread-1] DEBUG DBConnector - SELECT `database_id`, `url`, `port`, `username`, `password`, `allocated_max_id_player`, `allocated_max_id_character`, `allocated_max_id_item`, `allocated_max_id_post` FROM `eod_configuration`.`table_game_database`; 2020-09-26 21:09:09.6834 [Thread-1] DEBUG DBConnector - SELECT `server_id`, `url`, `port` FROM `eod_configuration`.`table_party_server`; 2020-09-26 21:09:09.6834 [Thread-1] DEBUG DBConnector - SELECT `server_id`, `url`, `port` FROM `eod_configuration`.`table_occupation_war_server`; 2020-09-26 21:09:09.6990 [Thread-1] DEBUG DBConnector - SELECT `mode`, `season_number`, `start_datetime`, `end_datetime`, `update_datetime` FROM `eod_configuration`.`table_occupation_war_season`; 2020-09-26 21:09:09.6990 [Thread-1] DEBUG DBConnector - SELECT `server_id`, `url`, `port` FROM `eod_configuration`.`table_ranking_server`; 2020-09-26 21:09:09.8240 [Thread-9] INFO WebApiApplication - [Session Start] [DateTime] : 2020-09-26 오후 9:09:09 [Session ID] : 5pqtx4uqsctq4srw2remndbp 2020-09-26 21:09:10.0896 [Thread-9] INFO IndexController - Create new session. [Session ID] : 5pqtx4uqsctq4srw2remndbp 2020-09-26 21:09:10.0896 [Thread-9] INFO Service - [Response Start] ProtocolCode = [CheckAccountExistance], Request = [{"relationType":2,"account":"g11871908275080989243","authenticationNumber":0}] 2020-09-26 21:09:10.1052 [Thread-9] DEBUG DBConnector - SELECT COALESCE((SELECT 1 FROM `eod_authentication`.`table_account_relationship` WHERE (`account` = 'g11871908275080989243') AND (`related` = 1)), 0) 2020-09-26 21:09:10.1365 [Thread-9] INFO Service - [Response Success] ProtocolCode = [CheckAccountExistance], ErrorCode = [0], Response = [{"existance":true}] 2020-09-26 21:09:10.2146 [Thread-8] INFO WebApiApplication - [Session Start] [DateTime] : 2020-09-26 오후 9:09:10 [Session ID] : rewvmfxs4okomebj2mzgaqre 2020-09-26 21:09:10.2146 [Thread-8] INFO IndexController - Create new session. [Session ID] : rewvmfxs4okomebj2mzgaqre 2020-09-26 21:09:10.2146 [Thread-8] INFO Service - [Response Start] ProtocolCode = [LoginUserByInput], Request = [{"accountRelation":2,"account":"g11871908275080989243","platformType":11,"deviceModel":"samsungSM-N986N","deviceOs":"AndroidOS10/API-29(QP1A.190711.020/N986NKSU1ATI2)","authenticationNumber":0}] 2020-09-26 21:09:10.2146 [Thread-8] DEBUG DBConnector - SELECT `account`, `user_id`, `relation_type`, `related`, `generate_datetime` FROM `eod_authentication`.`table_account_relationship` WHERE (`account` = 'g11871908275080989243') LIMIT 1; 2020-09-26 21:09:10.2302 [Thread-8] DEBUG DBConnector - SELECT `user_id`, `serial_code`, `authentication_number`, `state`, `sanctions_end_datetime`, `nickname`, `join_datetime`, `last_login_datetime`, `application_version`, `game_data_version`, `platform_type`, `device_model`, `device_os` FROM `eod_authentication`.`table_account_user` WHERE (`user_id` = 9) LIMIT 1; 2020-09-26 21:09:10.2302 [Thread-8] DEBUG DBConnector - SELECT `user_id`, `authentication_number`, `nickname`, `notice_state`, `guardian_level`, `guardian_experience`, `guardian_stone_enhance_point`, `money_gamecash_by_bonus`, `money_gamecash_by_purchase`, `friendship_point`, `current_bought_premium_package`, `deletable_friend_count`, `last_accessed_datetime`, `last_played_character`, `enable_to_change_nickname`, `representative_character`, `enable_to_change_representative_character_datetime`, `joined_guild_id`, `guild_coin`, `mileage`, `cumulative_mileage`, `is_completed_tutorial`, `enable_to_guild_activity_datetime`, `guild_attendance_datetime`, `related_account_facebook` FROM `eod_game`.`table_player` WHERE (`user_id` = 9) LIMIT 1; 2020-09-26 21:09:10.2615 [Thread-8] DEBUG DBConnector - UPDATE `eod_game`.`table_player` SET `is_completed_tutorial` = True WHERE (`user_id` = 9); 2020-09-26 21:09:10.2771 [Thread-8] DEBUG DBConnector - SELECT `database_id`, `server_number`, `url`, `port`, `recently_access_count` FROM `eod_configuration`.`table_game_server`; 2020-09-26 21:09:10.3084 [Thread-8] DEBUG DBConnector - SELECT COALESCE((SELECT 1 FROM `eod_authentication`.`table_account_user` WHERE (`authentication_number` = '6782784255246695453')), 0) 2020-09-26 21:09:10.3084 [Thread-8] DEBUG DBConnector - UPDATE `eod_authentication`.`table_account_user` SET `authentication_number` = 6782784255246695453, `last_login_datetime` = '2020-09-26 12:09:10', `platform_type` = 11, `device_model` = 'samsungSM-N986N', `device_os` = 'AndroidOS10/API-29(QP1A.190711.020/N986NKSU1ATI2)', `update_datetime` = '2020-09-26 21:09:10' WHERE (`user_id` = 9); 2020-09-26 21:09:10.3084 [Thread-8] DEBUG DBConnector - UPDATE `eod_game`.`table_player` SET `authentication_number` = 6782784255246695453, `update_datetime` = '2020-09-26 21:09:10' WHERE (`user_id` = 9); 2020-09-26 21:09:10.3396 [Thread-8] INFO Service - [Response Success] ProtocolCode = [LoginUserByInput], ErrorCode = [0], Response = [{"serialCode":"TR1ONS3U5I05QACQ","authenticationNumber":6782784255246695453,"nickname":"폼폼","gameServers":[{"address":"http://175.124.227.25:7200/Game/Index","port":7200}],"recommendGameServerIndex":0,"chattingServers":[{"address":"175.124.227.25","port":31000}],"partyServers":[{"address":"175.124.227.25","port":32000}],"occupationWarServers":[{"address":"175.124.227.25","port":34000}],"rankingServers":[{"address":"175.124.227.25","port":33000}],"currentServerDatetime":"2020-09-26T21:09:10.3240098+09:00","playerState":0,"SanctionEndDatetime":"0001-01-01T00:00:00"}] 2020-09-26 21:14:45.4449 [Thread-57] INFO WebApiApplication - [Session Start] [DateTime] : 2020-09-26 오후 9:14:45 [Session ID] : ple5ukyompn2qwugotcgwmvg 2020-09-26 21:14:45.4449 [Thread-56] INFO IndexController - Create new session. [Session ID] : ple5ukyompn2qwugotcgwmvg 2020-09-26 21:14:45.4449 [Thread-56] INFO Service - [Response Start] ProtocolCode = [CheckAccountExistance], Request = [{"relationType":4,"account":"3107215666007908","authenticationNumber":0}] 2020-09-26 21:14:45.4761 [Thread-56] DEBUG DBConnector - SELECT COALESCE((SELECT 1 FROM `eod_authentication`.`table_account_relationship` WHERE (`account` = '3107215666007908') AND (`related` = 1)), 0) 2020-09-26 21:14:45.4761 [Thread-56] INFO Service - [Response Success] ProtocolCode = [CheckAccountExistance], ErrorCode = [0], Response = [{"existance":false}] 2020-09-26 21:14:45.5230 [Thread-56] INFO WebApiApplication - [Session Start] [DateTime] : 2020-09-26 오후 9:14:45 [Session ID] : bplhmnxvpzmvfndb3nb3d4ty 2020-09-26 21:14:45.5230 [Thread-57] INFO IndexController - Create new session. [Session ID] : bplhmnxvpzmvfndb3nb3d4ty 2020-09-26 21:14:45.5230 [Thread-57] INFO Service - [Response Start] ProtocolCode = [CreateAccount], Request = [{"relationType":4,"account":"3107215666007908","authenticationNumber":0}] 2020-09-26 21:14:45.5543 [Thread-57] DEBUG DBConnector - SELECT COALESCE((SELECT 1 FROM `eod_authentication`.`table_account_relationship` WHERE (`account` = '3107215666007908') AND (`related` = 1)), 0) 2020-09-26 21:14:45.5699 [Thread-57] DEBUG DBConnector - SELECT COALESCE((SELECT 1 FROM `eod_authentication`.`table_account_user` WHERE (`serial_code` = 'EB9WKWRPYTIIMAPY')), 0) 2020-09-26 21:14:45.5855 [Thread-57] DEBUG DBConnector - SELECT COALESCE((SELECT 1 FROM `eod_authentication`.`table_account_user` WHERE (`authentication_number` = '4530266997935917950')), 0) 2020-09-26 21:14:45.5855 [Thread-57] DEBUG DBConnector - INSERT INTO `eod_authentication`.`table_account_user` (`serial_code`, `authentication_number`, `state`, `sanctions_end_datetime`, `nickname`, `join_datetime`, `last_login_datetime`, `application_version`, `game_data_version`, `platform_type`, `device_model`, `device_os`, `update_datetime`) VALUES ('EB9WKWRPYTIIMAPY', 4530266997935917950, 0, '1000-01-01 00:00:00', '[empty]EB9WKWRPYTIIMAPY', '2020-09-26 21:14:45', '1000-01-01 00:00:00', 0, 0, 0, '', '', '2020-09-26 21:14:45'); 2020-09-26 21:14:45.6168 [Thread-57] DEBUG DBConnector - INSERT INTO `eod_game`.`table_player` (`user_id`, `authentication_number`, `nickname`, `notice_state`, `vip_level`, `vip_point`, `guardian_level`, `guardian_experience`, `guardian_stone_enhance_point`, `money_gamecash_by_bonus`, `money_gamecash_by_purchase`, `friendship_point`, `current_bought_premium_package`, `deletable_friend_count`, `last_accessed_datetime`, `last_played_character`, `enable_to_change_nickname`, `representative_character`, `enable_to_change_representative_character_datetime`, `joined_guild_id`, `is_completed_tutorial`, `enable_to_guild_activity_datetime`, `guild_attendance_datetime`, `related_account_facebook`, `update_datetime`) VALUES (17, 4530266997935917950, '[empty]EB9WKWRPYTIIMAPY', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '1000-01-01 00:00:00', 0, True, 0, '1000-01-01 00:00:00', 0, False, '1000-01-01 00:00:00', '1000-01-01 00:00:00', '', '2020-09-26 12:14:45'); 2020-09-26 21:14:45.6480 [Thread-57] DEBUG DBConnector - SELECT `account`, `user_id`, `relation_type`, `related`, `generate_datetime` FROM `eod_authentication`.`table_account_relationship` WHERE (`account` = '3107215666007908') LIMIT 1; 2020-09-26 21:14:45.6480 [Thread-57] DEBUG DBConnector - INSERT INTO `eod_authentication`.`table_account_relationship` (`account`, `user_id`, `relation_type`, `related`, `generate_datetime`) VALUES ('3107215666007908', 17, 4, True, '2020-09-26 21:14:45'); 2020-09-26 21:14:45.6636 [Thread-57] DEBUG DBConnector - UPDATE `eod_game`.`table_player` SET `related_account_facebook` = '3107215666007908', `update_datetime` = '2020-09-26 21:14:45' WHERE (`user_id` = 17); 2020-09-26 21:14:45.6792 [Thread-57] INFO Service - [Response Success] ProtocolCode = [CreateAccount], ErrorCode = [0], Response = [{"serialCode":"EB9WKWRPYTIIMAPY","authenticationNumber":4530266997935917950}] 2020-09-26 21:14:45.6949 [Thread-40] INFO WebApiApplication - [Session Start] [DateTime] : 2020-09-26 오후 9:14:45 [Session ID] : x2ui4g3adh2zm0obkim2kssa 2020-09-26 21:14:45.6949 [Thread-56] INFO IndexController - Create new session. [Session ID] : x2ui4g3adh2zm0obkim2kssa 2020-09-26 21:14:45.6949 [Thread-56] INFO Service - [Response Start] ProtocolCode = [LoginUserByInput], Request = [{"accountRelation":4,"account":"3107215666007908","platformType":11,"deviceModel":"samsungSM-N986N","deviceOs":"AndroidOS10/API-29(QP1A.190711.020/N986NKSU1ATI2)","authenticationNumber":0}] 2020-09-26 21:14:45.6949 [Thread-56] DEBUG DBConnector - SELECT `account`, `user_id`, `relation_type`, `related`, `generate_datetime` FROM `eod_authentication`.`table_account_relationship` WHERE (`account` = '3107215666007908') LIMIT 1; 2020-09-26 21:14:45.6949 [Thread-56] DEBUG DBConnector - SELECT `user_id`, `serial_code`, `authentication_number`, `state`, `sanctions_end_datetime`, `nickname`, `join_datetime`, `last_login_datetime`, `application_version`, `game_data_version`, `platform_type`, `device_model`, `device_os` FROM `eod_authentication`.`table_account_user` WHERE (`user_id` = 17) LIMIT 1; 2020-09-26 21:14:45.6949 [Thread-56] DEBUG DBConnector - SELECT `user_id`, `authentication_number`, `nickname`, `notice_state`, `guardian_level`, `guardian_experience`, `guardian_stone_enhance_point`, `money_gamecash_by_bonus`, `money_gamecash_by_purchase`, `friendship_point`, `current_bought_premium_package`, `deletable_friend_count`, `last_accessed_datetime`, `last_played_character`, `enable_to_change_nickname`, `representative_character`, `enable_to_change_representative_character_datetime`, `joined_guild_id`, `guild_coin`, `mileage`, `cumulative_mileage`, `is_completed_tutorial`, `enable_to_guild_activity_datetime`, `guild_attendance_datetime`, `related_account_facebook` FROM `eod_game`.`table_player` WHERE (`user_id` = 17) LIMIT 1; 2020-09-26 21:14:45.7261 [Thread-56] DEBUG DBConnector - SELECT `database_id`, `server_number`, `url`, `port`, `recently_access_count` FROM `eod_configuration`.`table_game_server`; 2020-09-26 21:14:45.7261 [Thread-56] DEBUG DBConnector - SELECT COALESCE((SELECT 1 FROM `eod_authentication`.`table_account_user` WHERE (`authentication_number` = '5135930251742109782')), 0) 2020-09-26 21:14:45.7261 [Thread-56] DEBUG DBConnector - UPDATE `eod_authentication`.`table_account_user` SET `authentication_number` = 5135930251742109782, `last_login_datetime` = '2020-09-26 12:14:45', `platform_type` = 11, `device_model` = 'samsungSM-N986N', `device_os` = 'AndroidOS10/API-29(QP1A.190711.020/N986NKSU1ATI2)', `update_datetime` = '2020-09-26 21:14:45' WHERE (`user_id` = 17); 2020-09-26 21:14:45.7417 [Thread-56] DEBUG DBConnector - UPDATE `eod_game`.`table_player` SET `authentication_number` = 5135930251742109782, `update_datetime` = '2020-09-26 21:14:45' WHERE (`user_id` = 17); 2020-09-26 21:14:45.7417 [Thread-56] INFO Service - [Response Success] ProtocolCode = [LoginUserByInput], ErrorCode = [0], Response = [{"serialCode":"EB9WKWRPYTIIMAPY","authenticationNumber":5135930251742109782,"nickname":"","gameServers":[{"address":"http://175.124.227.25:7200/Game/Index","port":7200}],"recommendGameServerIndex":0,"chattingServers":[{"address":"175.124.227.25","port":31000}],"partyServers":[{"address":"175.124.227.25","port":32000}],"occupationWarServers":[{"address":"175.124.227.25","port":34000}],"rankingServers":[{"address":"175.124.227.25","port":33000}],"currentServerDatetime":"2020-09-26T21:14:45.7417991+09:00","playerState":0,"SanctionEndDatetime":"0001-01-01T00:00:00"}] 2020-09-26 21:29:09.8093 [Thread-16] DEBUG DBConnector - SELECT `server_id`, `url`, `port` FROM `eod_configuration`.`table_chatting_server`; 2020-09-26 21:29:09.8093 [Thread-16] DEBUG DBConnector - SELECT `database_id`, `url`, `port`, `username`, `password`, `allocated_max_id_player`, `allocated_max_id_character`, `allocated_max_id_item`, `allocated_max_id_post` FROM `eod_configuration`.`table_game_database`; 2020-09-26 21:29:09.8093 [Thread-16] DEBUG DBConnector - SELECT `server_id`, `url`, `port` FROM `eod_configuration`.`table_party_server`; 2020-09-26 21:29:09.8250 [Thread-16] DEBUG DBConnector - SELECT `server_id`, `url`, `port` FROM `eod_configuration`.`table_occupation_war_server`; 2020-09-26 21:29:09.8250 [Thread-16] DEBUG DBConnector - SELECT `mode`, `season_number`, `start_datetime`, `end_datetime`, `update_datetime` FROM `eod_configuration`.`table_occupation_war_season`; 2020-09-26 21:29:09.8250 [Thread-16] DEBUG DBConnector - SELECT `server_id`, `url`, `port` FROM `eod_configuration`.`table_ranking_server`; 2020-09-26 21:29:09.8406 [Thread-16] INFO WebApiApplication -