Character creation Log

Category¶

Common Server	service_metrics-character_creation_log
Test Server	service_metrics_test-character_creation_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 hhss (No space) 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 hhss 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_creation_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
account_character_count_var	Variance in creating or deleting characters Positive number means creation, and negative number means deletion e.g., +1: creating one character, -2: deleting two characters	int	Y
account_character_count_curr	The number of total characters after creating or deleting character	int	Y
app_id	AppID which Hive SDK uses by game 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": GAMEVIL	string (3)	Y
country	Input the country code directly if client_ip is not given e.g., KR Reference: Identifier Policy	string (2)	N
guid	Unique key generated per log Random format such as uuid is recommended	varchar(64)	N

Log sample¶

 {
      "date": datetime.datetime.today().strftime("%Y-%m-%d %H:%M:%S"),
      "dateTime": "2012-11-26 13:32:45",
      "category": "derbyday_character_creation_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"
    }