Skip to content

Character login log

Category

Common Server service_metrics-character_login_log
Test Server service_metrics_test-character_login_log

Log specification

Note

The snake-cased field, like server_id, is transformed to camel case, like serverId, when it stores in the final storage (BigQuery), and the log sent in the unspecified form, such as serverid, is not saved in its column.

Field Name Description Type Required
date The time storing log
Format: yyyy-mm-dd hh🇲🇲ss
e.g., 2012-01-19 16:24:00
Required for Scribe/FTP type, optional for Fluentd type		 string N
dateTime The time storing log
Format: yyyy-mm-dd hh🇲🇲ss
e.g., 2012-01-19 16:24:00		 string Y
category [The brand name of game]_[Log name]
The brand name of game is the third item of app_id
e.g., "derbyday_character_login_log"		 string Y
timezone UTC offset of time parameter in the log
* Fix the value of timezone as a blank or GMT+09:00 as the value of date is always KST when sending log definition as scribe or ftp type.
e.g., "GMT+09:00"
* Set the value of timezone flexiblely in accordance with the value of dateTime when sending log definition as fluentd or http type.
e.g., "GMT+10:30"		 string Y
channel C2S: HIVE, KAK: Kakao Talk, LIN: LINE, WEI: Weibo string (3) Y
channel_uid User identifier on login channel (Generally bigint is in use, but some channels may use string type)
Send 0 if the information is unknown such as LINE		 string (64) Y
game Use the brand name of game (e.g., derbydays). The third item of app_id
e.g., com.com2us.littlelegends.kakao.freefull.apple.global.ios.universal => littlelegends		 string (50) Y
server_id Server Code
Refer to Table of Server Code to input server code (JSON Input Code)		 string Y
account_id Unique account identifier in server (PK) bigint Y
account_level Account level of user. In the game without level, set as 0 int Y
character_id Character identifier used in server
Set this identifier as 0 if the game has no character		 bigint Y
character_type_id The value of character type used in server
Set this value as 0 if the game has no character		 int Y
character_level Character level used in server
Set this level as 0 if the game has no character		 int Y
app_id AppID which Hive SDK uses
e.g., 'com.com2us.derbyday.kakao.freefull.google.global.android.common'		 string (200) Y
client_ip Client IP. This value extracts the value of country from GeoIP string (32) Y
**server_ip Server IP string (32) Y
company Game publishing company, the target of log:
e.g., "C2S": Com2uS, "GVI": Com2uS Holdings		 string (3) Y
country Input the country code directly if client_ip is not given string (2) N
guid Unique key generated per log
Random format such as uuid is recommended		 varchar(64) N

Log sample

 {
      "date": "2017-03-01 11:22:33",
      "dateTime": "2017-03-01 11:22:33",
      "category": "derbyday_character_login_log",
      "channel_uid": "111",
      "game": "misample",
      "server_id": "SEA",
      "account_id": 222,
      "account_level": 0,
      "character_id": 111,
      "character_type_id": 10001,
      "character_level": 32,
      "app_id": "com.com2us.misample",
      "client_ip": "112.11.111.111",
      "server_ip": "10.0.0.1",
      "channel": "C2S",
      "company": "GVI",
      "guid": "ca4bd34c867f4617a819ae139d8d6670"
    }