obsidian/笔记文件/2.笔记/数据中台 临时记录.md
2025-06-11 22:29:27 +08:00

2.3 KiB
Raw Permalink Blame History

#灵感

sql的数据转换也是使用这个json插件

!Pasted image 20250206194552.png

玩家公共属性结构

!Pasted image 20250223175028.png

震动插件 dll报错

!img_v3_02jq_002c6700-6aed-4f14-bed0-3dce53ae280h.jpg

子线程,设置优先级最高的逻辑

!Pasted image 20250224160412.png

!Pasted image 20250317103739.png

三消 埋点的amp和数据中台lua接口

!Pasted image 20250324103035.png

埋点的总接口:

!Pasted image 20250324103133.png

三消这边,会有一个,本地记录的会话 触发时间

!Pasted image 20250324103359.png

!img_v3_02l0_d4ed12cc-7795-4e1f-ba6b-b2a85b8e17hu.jpg

!img_v3_02l0_b7de53fd-74a7-40db-bd73-52c904c4d8hu.jpg

!Pasted image 20250403114121.png

三消登录接口:

!Pasted image 20250414170920.png

注册接口:

!Pasted image 20250414171005.png

项目组频繁发送埋点的屏蔽,在这里:

!Pasted image 20250423164317.png

对齐AMP 用户属性,用户属性,增量上传相关

!Pasted image 20250509145032.png

!img_v3_02k9_c4f0c181-f5d1-4224-ba9a-a803859b50hu.jpg

安卓和ios的数据库文件恢复相关

!Pasted image 20250510100803.png

!Pasted image 20250510100520.png

表名参考

!Pasted image 20250510183627.png

slot项目的数据中台脚本也是同一个

!Pasted image 20250514140147.png

当前slot的数据中台消息结构

{
  "event_timestamp": 1747277484,
  "event_properties": {
    "user_properties": {
      "vid": "9.9.9",
      "pk_id": "2001"
    }
  },
  "public_properties": "{\"os\":\"windows\",\"app_version\":\"9.9.9\",\"channel_id\":\"2001\",\"os_version\":\"windows 10  (10.0.19045) 64bit\",\"device_model\":\"h410m (hasee computer)\",\"device_id\":\"\",\"uid\":\"\"}",
  "event_name": "pj_open_login"
}

slot端发送接口

!Pasted image 20250515145833.png

!Pasted image 20250515153514.png

!Pasted image 20250520145708.png

上报地址

元素
https://iddcevent.icongamesg.com/report/?appid=tnhhj7s56874

蜂鸟
https://iddcevent.hummingbirdgamesltd.com/report/?appid=v6lra90l16v4

X项目
https://iddcevent.doomsurvivor.com/report/?appid=75952c98ee9b

这里是slot设置公共属性的地方

!Pasted image 20250611195221.png

注册成功 lua逻辑

!Pasted image 20250611210130.png