Skip to content

Instantly share code, notes, and snippets.

View aoxu's full-sized avatar

Ao Xu aoxu

View GitHub Profile
SELECT
user_id,
max(event_params.value.int_value) as max_layer /* 只要已解锁的最大矿层数 */
FROM
`analytics_168921341.events_*` AS T,
T.event_params
WHERE
event_name = 'activate_manto'
AND event_params.key = 'manto_id'
AND user_id IN (
SELECT
max_layer,
COUNT(user_id) as user_count
FROM (
SELECT
user_id,
max(event_params.value.int_value) as max_layer /* 只要已解锁的最大矿层数 */
FROM
`analytics_168921341.events_*` AS T,
T.event_params
SELECT
user_id,
max(event_params.value.int_value) /* 只要已解锁的最大矿层数 */
FROM
`analytics_168921341.events_*` AS T,
T.event_params
WHERE
event_name = 'activate_manto'
AND event_params.key = 'manto_id'
AND _TABLE_SUFFIX BETWEEN '20181108' AND '20181109'
SELECT
DISTINCT user_id
FROM
`analytics_168921341.events_*` AS T,
T.event_params
WHERE
event_name = 'tutorial_complete'
AND event_params.key = 'guide_id'
AND event_params.value.int_value = 51
AND geo.country = 'United States' /* 修改为指定国家 */
SELECT
DISTINCT user_id
FROM
`analytics_168921341.events_*` AS T,
T.event_params
WHERE
event_name = 'tutorial_complete'
AND event_params.key = 'guide_id'
AND event_params.value.int_value = 51
AND geo.country = 'United States' /* 修改为指定国家 */
@aoxu
aoxu / userid.csv
Created October 28, 2018 02:27
次日流失用户id
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
84953
84954
84956
84968
84977
84978
84982
84999
85000
85001
@aoxu
aoxu / gist:c7904652d2fd0aa05abde04643d97133
Created September 20, 2018 08:13
曝光一个微信支付钓鱼网站,和相关骗局信息,提醒老人小心上当受骗~
钓鱼网站的地址是 qq.weixinbnhk.cn
如果电脑访问,会跳转到建行网站。
来源是家人收到的短信
https://ws1.sinaimg.cn/large/70dcc3a2gy1fvg29wtojyj20k0140jtl.jpg
家人的手机打开是这样
https://ws1.sinaimg.cn/large/70dcc3a2gy1fvg2afhbjrj20k0140ach.jpg
我看了一下貌似是比较新的骗局,通过伪基站来伪造从95017发来短信,声称要实名认证,然后钓鱼网站来盗取微信支付的密码。
网上查到的相关案例:
@aoxu
aoxu / Douban.md
Created September 11, 2018 06:38 — forked from Expost/Douban.md
豆瓣高评分书籍

爬虫爬了好久,总共从豆瓣爬下来了 16894465 本书,有评分的有 279377 本。

简单统计如下:

  • 评分在9分及以上的有 24038 本,评分在9分及以上且评价人数在1000以上的有 980 本。
  • 评分在8.5分及以上的有 59521 本,评分在8.5及以上且评价人数在1000以上的有 2941 本。
  • 评分在8分及以上的有 112513 本,评分在8及以上且评价人数在1000以上的有 4968 本。
  • 评分在7分及以上的有 244044 本,评分在7及以上且评价人数在1000以上的有 7760 本。
  • 评分在6分及以上的有 276303 本,评分在6及以上且评价人数在1000以上的有 8115 本。
  • 评分在5分及以上的有 279005 本,评分在5及以上且评价人数在1000以上的有 8126 本。
Ex [WebSocketResponse]: HandleEvents - Message: 1: The object of type 'Transform' has been destroyed but you are still trying to access it.
Your script should either check if it is null or you should not destroy the object. at (wrapper managed-to-native) UnityEngine.Transform:INTERNAL_get_localScale (UnityEngine.Vector3&)
at UnityEngine.Transform.get_localScale () [0x00004] in /Users/builduser/buildslave/unity/build/artifacts/generated/common/runtime/TransformBindings.gen.cs:135
at FairyGUI.DisplayObject.SetScale (Single xv, Single yv) [0x00007] in /Users/xatest/Code/bitbucket/tradeandfight/Assets/Plugins/FairyGUI/Scripts/Core/DisplayObject.cs:465
at FairyGUI.GLoader.UpdateLayout () [0x001ff] in /Users/xatest/Code/bitbucket/tradeandfight/Assets/Plugins/FairyGUI/Scripts/UI/GLoader.cs:485
at FairyGUI.GLoader.LoadFromPackage (System.String itemURL) [0x000b3] in /Users/xatest/Code/bitbucket/tradeandfight/Assets/Plugins/FairyGUI/Scripts/UI/GLoader.cs:334
at FairyGUI.GLoader.LoadContent () [0x00038]
@aoxu
aoxu / searchengine.json
Created March 13, 2018 08:54
小米手机内置浏览器搜索引擎配置
{"default_search_engine":{"name":"sogou","isRecommended":true},"data":{"sogou":{"title_zh_CN":"Google","title_zh_TW":"Google","title_en_US":"Google","label":"Google","keyword":"google.com","favicon_uri":"http:\/\/www.google.com\/favicon.ico","search_uri":"http:\/\/www.google.com\/search?hl=zh-TW&ie=UTF-8&source=android-browser&q={searchTerms}","encoding":"UTF-8","suggest_uri":"http:\/\/suggestqueries.google.com\/complete\/search?hl=zh-TW&ie=UTF-8&source=android-browser&q={searchTerms}"},"baidu_search_box":{"title_zh_CN":"百度","title_zh_TW":"百度","title_en_US":"baidu","label":"baidu","keyword":"baidu.com","favicon_uri":"http:\/\/m.baidu.com\/favicon.ico","search_uri":"https:\/\/m.baidu.com\/s?from=1012852r&word={searchTerms}","encoding":"UTF-8","suggest_uri":"http:\/\/suggestion.baidu.com\/su?p=3&wd={searchTerms}","extra":"v6","ic_search_engine":"http:\/\/f4.market.mi-img.com\/download\/Browser\/a015b692-1c93-44ef-8b5d-471fbfd3df98","ic_search_logo":"","miui_search_logo":"http:\/\/file.market.xiaomi.com\/downloa