主题帖回复帖和回复帖楼中楼接口中的发帖人等级现在可能放在user_list[].level_id而非post_list[].level_id中
#216
Labels
discussion
discussion
Comments
|
当我没说 https://github.com/n0099/tbclient.protobuf/blob/12.51.7.1/proto/Post.proto 本来就没有 |
n0099
added a commit
to n0099/open-tbm
that referenced
this issue
Jul 27, 2024
…value of props with attribute `[NotMapped]` since b81b64a @ `ReplySaver.Save()` * partial revert b688071 @ `AuthorRevisionSaver.SaveAuthorExpGrade()` + prop `Parsed` like `AllAfter` before b81b64a * rename primary ctor param `existingAfterAndNewlyAdded` to `parsed` @ SaverChangeSet.cs * rename variable `existingPostsBeforeMerge` to `existingPostsBeforeSave` @ `PostSaver.Save()` @ c#/crawler
n0099
added a commit
to n0099/open-tbm
that referenced
this issue
Jul 27, 2024
…value of props with attribute `[NotMapped]` since b81b64a @ `ReplySaver.Save()` * partial revert b688071 @ `AuthorRevisionSaver.SaveAuthorExpGrade()` + prop `Parsed` like `AllAfter` before b81b64a * rename primary ctor param `existingAfterAndNewlyAdded` to `parsed` @ SaverChangeSet.cs * rename variable `existingPostsBeforeMerge` to `existingPostsBeforeSave` @ `PostSaver.Save()` @ c#/crawler
|
蛤？ |
|
我自己搞混了 https://en.wikipedia.org/wiki/Semipredicate_problem 从数据库读出来的实体类（ |
|
但在正义 DELETE FROM "tbmcr_authorExpGrade"
WHERE "authorExpGrade" = 0
AND to_timestamp("discoveredAt")::date BETWEEN '2024-07-12' AND '2024-07-27';删掉1m+行后在 SELECT to_timestamp("discoveredAt") AT TIME ZONE 'UTC+8', *
FROM "tbmcr_authorExpGrade" WHERE fid = 6087183 AND uid = 169860828
ORDER BY "discoveredAt" DESC;
WITH a AS (
SELECT COUNT(*) count, fid, uid, "triggeredBy",
to_timestamp(min("discoveredAt"))::date AS min_day,
to_timestamp(max("discoveredAt"))::date AS max_day
FROM "tbmcr_authorExpGrade"
WHERE "authorExpGrade" = 0
GROUP BY fid, uid, "triggeredBy"
)
SELECT *, max_day - min_day duration FROM a ORDER BY duration DESC;
SELECT COUNT(*), fid, "triggeredBy", to_timestamp(min("discoveredAt"))::date AS day
FROM "tbmcr_authorExpGrade"
WHERE "authorExpGrade" = 0
GROUP BY fid, "triggeredBy"
自 |
|
所以说这只是一种server glitch？ |
|
在我找到新的证据证明是我写错之前是的 |
|
找到了是 curl -s https://n0099.net/tbm/v1/client_tester.php\?type\=posts\&forum\=v\&pn\=1\&rn\=30\&client_version\=12.39 \
| jq -c '.user_list[] | { (.id | tostring): .level_id }'{"1447150457":null}
{"1402002589":null}
{"4543421180":null}
{"4468004397":null}
{"6675906847":null}
{"4875608415":null}
{"1733033498":null}
{"6328952342":null}
{"1520437512":null}
{"204338778":null}
{"614500188":null}
{"187991726":null}
{"6088061729":null}
{"5987746517":null}
{"23929304":null}
{"3819235464":null}
{"6683108031":null}
{"23313205":null}
{"2031944551":null}
{"5182522350":null}
{"2572256569":null}
{"563686252":null}
{"416729378":null}
{"4605592380":null}
{"3436707562":null}
{"6650816803":null}
{"774066515":null}https://n0099.net/tbm/v1/client_tester.php?type=posts&forum=v&pn=1&rn=30&client_version=12.40 curl -s https://n0099.net/tbm/v1/client_tester.php\?type\=posts\&forum\=v\&pn\=1\&rn\=30\&client_version\=12.40 \
| jq -c '.user_list[] | { (.id | tostring): .level_id }'{"1447150457":14}
{"1323283231":11}
{"6530439247":6}
{"5770533996":1}
{"84251189":5}
{"4543421180":11}
{"1512933272":11}
{"2651464622":14}
{"3031045165":9}
{"4501410938":5}
{"3511477459":10}
{"6647521408":1}
{"5819769370":11}
{"959590357":12}
{"5987746517":15}
{"4090680065":13}
{"6390588135":11}
{"1402002589":12}
{"6584763185":5}
{"1038770490":12}
{"5450747790":13}
{"5829220713":6}
{"771234994":10}
{"6328952342":14}
{"4474588442":12}
{"6411622419":7}
{"2888537466":1}
{"50860272":13}
{"1143534304":13} |
|
但 $ curl -s 'https://n0099.net/tbm/v1/client_tester.php?type=replies&tid=9098899860&pn=1&client_version=12.66.1.0' | jq -c '.user_list[] | { (.id | tostring): .level_id }'
{"243784075":15}
{"782010266":15}
{"20006581914068":null}
$ curl -s 'https://n0099.net/tbm/v1/client_tester.php?type=replies&tid=9098899860&pn=1&client_version=12.66.1.0' | jq -c '.user_list[] | { (.id | tostring): .level_id }'
{"243784075":15}
{"782010266":15}
{"6653138544":null}
$ curl -s 'https://n0099.net/tbm/v1/client_tester.php?type=replies&tid=9098899860&pn=1&client_version=12.66.1.0' | jq -c '.user_list[] | { (.id | tostring): .level_id }'
{"243784075":15}
{"782010266":15}
{"20006581941845":null}
$ curl -s 'https://n0099.net/tbm/v1/client_tester.php?type=replies&tid=9098899860&pn=1&client_version=12.66.1.0' | jq -c '.user_list[] | { (.id | tostring): .level_id }'
{"243784075":15}
{"782010266":15}
{"20006581932057":null}
$ curl -s 'https://n0099.net/tbm/v1/client_tester.php?type=replies&tid=9098899860&pn=1&client_version=12.66.1.0' | jq -c '.user_list[] | { (.id | tostring): .level_id }'
{"243784075":15}
{"782010266":15}
{"20006581941827":null}
$ curl -s 'https://n0099.net/tbm/v1/client_tester.php?type=replies&tid=9098899860&pn=1&client_version=12.66.1.0' | jq -c '.user_list[] | { (.id | tostring): .level_id }'
{"243784075":15}
{"782010266":15}
{"0":null}
$ curl -s 'https://n0099.net/tbm/v1/client_tester.php?type=replies&tid=9098899860&pn=1&client_version=12.66.1.0' | jq -c '.user_list[] | { (.id | tostring): .level_id }'
{"243784075":15}
{"782010266":15}
{"20002383684206":null}这主题帖里就两个用户但却有3个且第三个是随机的（大多数的 curl -s 'https://n0099.net/tbm/v1/client_tester.php?type=replies&tid=9098899860&pn=1&client_version=12.66.1.0' \
| jq '(.user_list[] | select(.level_id == null)) as $user | (.recom_ala_info | .user_info | .user_id) as $alauid | [(.recom_ala_info), ($user), ($alauid == $user.id)]'实际上是前 [
{
"live_id": 9477424228,
"description": "孤独的你和孤独的我刚刚好",
"live_from": 0,
"first_headline": "小姐姐萝莉音在线直播，精彩不容错过！",
"room_id": 9477424228,
"yy_ext": {
"feed_id": "16795871389423559215",
"sid": "1538441763",
"ssid": "1538441763",
"template_id": "33554534",
"yy_uid": "2954945485",
"is_yy_game": 0,
"stream_info": "{\"appid\":1296924150,\"cid\":1538441763,\"sid\":1538441763,\"wh_ratio\":\"368:640\",\"stream\":[{\"a_encoderType\":40,\"a_rate\":128,\"a_stream_name\":\"xa_1538441763_1538441763_0_0_0\",\"v_encoderType\":100,\"v_rate\":2000,\"v_stream_name\":\"xv_1538441763_1538441763_0_0_0\",\"pair\":2,\"extend\":{\"gearInfo\":\"{\\\"name\\\":\\\"高清\\\",\\\"seq\\\":200,\\\"gear\\\":2}\",\"line_infos\":\"{\\\"line_addrs\\\":[{\\\"line_seq\\\":6,\\\"reason\\\":\\\"cache\\\",\\\"cdn_info\\\":{\\\"url_id\\\":404,\\\"url_type\\\":1,\\\"url\\\":\\\"http://bd-flv.baizhanlive.com/live/1296924150_xv_1538441763_1538441763_0_0_0-1296924150_xa_1538441763_1538441763_0_0_0-0-0-0-0-0-1723237292976433.flv?codec=orig\\\\u0026appid=1296924150\\\\u0026rts_tk=f6ffcbdc5a3007e405e49c5fba1f9f23\\\\u0026secret=5b5f95d70e2897b2f23be31ffe1ac12c\\\\u0026t=1723330920\\\\u0026stream_key=1296924150_xv_1538441763_1538441763_0_0_0\\\\u0026r_stream_key=1296924150_xa_1538441763_1538441763_0_0_0\\\\u0026channelid=1538441763\\\\u0026mtk=1\\\\u0026line_seq=6\\\\u0026cp_id=4\\\\u0026rts=1\\\\u0026ctx=eyJydHNfYXV0aCI6MiwiZGVmX3Bhc3MiOjF9\\\\u0026r=cache\\\",\\\"is_p2p\\\":1,\\\"json\\\":\\\"{\\\\\\\"audio_only_flag\\\\\\\":\\\\\\\"\\\\\\\\u0026only-audio=1\\\\\\\\u0026audio-only=1\\\\\\\"}\\\",\\\"report_json\\\":\\\"{\\\\\\\"reason\\\\\\\":\\\\\\\"cache\\\\\\\"}\\\"},\\\"weight\\\":100,\\\"stage\\\":\\\"1723237292976433\\\"}],\\\"line_list\\\":[{\\\"line_seq\\\":4,\\\"line_print_name\\\":\\\"线路4\\\",\\\"line_print_sort\\\":4},{\\\"line_seq\\\":6,\\\"line_type\\\":1,\\\"line_print_name\\\":\\\"线路6\\\",\\\"line_print_sort\\\":6}]}\",\"stage\":\"1723237292976433\",\"mix_token\":\"AraDw8g0Sff9zoAQaq40fg==\",\"mix_ver\":\"1723237302202606\"}},{\"a_encoderType\":40,\"a_rate\":128,\"a_stream_name\":\"xa_1538441763_1538441763_0_0_0\",\"v_encoderType\":100,\"v_rate\":600,\"v_stream_name\":\"xv_1538441763_1538441763_0_1_0\",\"pair\":3,\"extend\":{\"gearInfo\":\"{\\\"name\\\":\\\"流畅\\\",\\\"seq\\\":100,\\\"gear\\\":1}\",\"line_infos\":\"{\\\"line_addrs\\\":[{\\\"line_seq\\\":6,\\\"reason\\\":\\\"cache\\\",\\\"cdn_info\\\":{\\\"url_id\\\":404,\\\"url_type\\\":1,\\\"url\\\":\\\"http://bd-flv.baizhanlive.com/live/1296924150_xv_1538441763_1538441763_0_1_0-1296924150_xa_1538441763_1538441763_0_0_0-0-0-0-0-0-1723237292976433.flv?codec=orig\\\\u0026appid=1296924150\\\\u0026rts_tk=b044cadcfa167aca53ab798d02a79ed6\\\\u0026secret=14c32859e59a3226e70d8fd2807c737c\\\\u0026t=1723330920\\\\u0026stream_key=1296924150_xv_1538441763_1538441763_0_1_0\\\\u0026r_stream_key=1296924150_xa_1538441763_1538441763_0_0_0\\\\u0026channelid=1538441763\\\\u0026line_seq=6\\\\u0026cp_id=4\\\\u0026mtk=1\\\\u0026rts=1\\\\u0026ctx=eyJydHNfYXV0aCI6MiwiZGVmX3Bhc3MiOjF9\\\\u0026r=cache\\\",\\\"is_p2p\\\":1,\\\"json\\\":\\\"{\\\\\\\"audio_only_flag\\\\\\\":\\\\\\\"\\\\\\\\u0026only-audio=1\\\\\\\\u0026audio-only=1\\\\\\\"}\\\",\\\"report_json\\\":\\\"{\\\\\\\"reason\\\\\\\":\\\\\\\"cache\\\\\\\"}\\\"},\\\"weight\\\":100,\\\"stage\\\":\\\"1723237292976433\\\"}],\\\"line_list\\\":[{\\\"line_seq\\\":4,\\\"line_print_name\\\":\\\"线路4\\\",\\\"line_print_sort\\\":4},{\\\"line_seq\\\":6,\\\"line_type\\\":1,\\\"line_print_name\\\":\\\"线路6\\\",\\\"line_print_sort\\\":6}]}\",\"stage\":\"1723237292976433\",\"mix_token\":\"AraDw8g0Sff9zoAQaq40fg==\",\"mix_ver\":\"1723237302202606\"}}],\"extend\":{\"layout\":\"[{\\\"mic\\\":0,\\\"uid\\\":2954945485}]\",\"uid64\":\"2954945485\"},\"liveChannelInfo\":{\"isOfficial\":0,\"avatar\":\"http://downhdlogo.yy.com/hdlogo/640640/640/640/94/2954945485/u2954945485ZNYl1i-.jpg\",\"nick\":{\"2\":\"静静jjang\",\"13\":\"静静jjang\",\"3\":\"静静jjang\",\"4\":\"静静jjang\",\"5\":\"静静jjang\",\"6\":\"静静jjang\",\"10\":\"静静jjang\"}}}"
},
"cover": "https://lpfm2-cover-static.myzhiniu.com/cover/934576852/2e558cf4b1044966b4672ca18be95b54.png?x-bce-process=image/resize,m_fill,w_720,h_404/quality,q_80",
"live_type": 3,
"third_room_id": "",
"third_live_type": "",
"pb_display_type": 1,
"dislike_info": [
{
"dislike_id": 401,
"extra": "{\"show_text\":\"9124244603|6470214027|已经看过\"}",
"dislike_reason": "已经看过"
},
{
"dislike_reason": "低质广告",
"dislike_id": 402,
"extra": "{\"show_text\":\"9124244603|6470214027|低质广告\"}"
},
{
"dislike_reason": "恐怖恶心",
"dislike_id": 403,
"extra": "{\"show_text\":\"9124244603|6470214027|恐怖恶心\"}"
},
{
"extra": "{\"show_text\":\"9124244603|6470214027|屏蔽该主播\"}",
"dislike_reason": "屏蔽该主播",
"dislike_id": 404
}
],
"audience_count": 404,
"live_status": 1,
"router_type": "",
"second_headline": "超萌主播人美歌甜，点我看看吧～",
"user_info": {
"portrait": "",
"live_status": 1,
"user_id": 6470214027,
"user_name": "静静jjang"
},
"cover_wide": "https://lpfm2-cover-static.myzhiniu.com/cover/934576852/2e558cf4b1044966b4672ca18be95b54.png?x-bce-process=image/resize,m_fill,w_720,h_404/quality,q_80"
},
{
"ala_info": {
"live_status": 1
},
"ala_live_info": {
"live_status": 1,
"live_from": 0,
"third_room_id": "",
"router_type": "",
"third_live_type": "",
"room_id": 9477424228,
"live_id": 9477424228,
"live_type": 3
},
"id": 6470214027,
"portrait": "tb.1.248440ba.t0aAXPcWotQjz1XxQtG7ZA",
"has_concerned": 0
},
true
]直接特征是 curl -s 'https://n0099.net/tbm/v1/client_tester.php?type=replies&tid=9044981332&pn=1&client_version=12.66.1.0' \
| jq '.user_list[] | [(.level_id), (.ala_info | .live_status), (.ala_live_info | .live_status)]'[
1,
1,
1
]但在其本人发帖中 |
git clone --branch tbclient https://github.com/n0099/tbclient.protobuf
grep -r live_status tbclient.protobuf/protohttps://github.com/n0099/tbclient.protobuf/blame/12.51.7.1/proto/AlaLiveInfo.proto#L31 |
|
tl;dr: 这就像是不久前的 #210 (comment) SELECT COUNT(*) FROM tbmc_user u
WHERE NOT EXISTS(SELECT 1 FROM "tbmc_latestReplier" WHERE uid = u.uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f17019292_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f17019292_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f17019292_thread" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f19871743_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f19871743_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f19871743_thread" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f2265748_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f2265748_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f2265748_thread" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f228500_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f228500_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f228500_thread" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f23546288_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f23546288_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f23546288_thread" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f25459979_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f25459979_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f25459979_thread" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f26066262_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f26066262_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f26066262_thread" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f27278534_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f27278534_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f27278534_thread" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f27497591_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f27497591_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f27497591_thread" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f27546680_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f27546680_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f27546680_thread" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f3255599_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f3255599_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f3255599_thread" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f4734432_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f4734432_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f4734432_thread" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f6087183_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f6087183_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f6087183_thread" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f78579_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f78579_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f78579_thread" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f898666_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f898666_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f898666_thread" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f97650_reply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f97650_subReply" WHERE "authorUid" = uid)
AND NOT EXISTS(SELECT 1 FROM "tbmc_f97650_thread" WHERE "authorUid" = uid); |
n0099
added a commit
to n0099/open-tbm
that referenced
this issue
Aug 10, 2024
…` following b372f22 to fix lumina37/aiotieba#216 (comment) @ derived classes of `BaseCrawler<,>` * fix lumina37/aiotieba#216 (comment) @ `ReplyCrawlFacade.OnPostParse()` @ crawler * update path of protoBuf codegen files @ TbClient.csproj @ tbclient @ c# $ git submodule update --remote
n0099
added a commit
to n0099/open-tbm
that referenced
this issue
Aug 10, 2024
…` following b372f22 to fix lumina37/aiotieba#216 (comment) @ derived classes of `BaseCrawler<,>` * fix lumina37/aiotieba#216 (comment) @ `ReplyCrawlFacade.OnPostParse()` @ crawler * update path of protoBuf codegen files @ TbClient.csproj @ tbclient @ c# $ git submodule update --remote
Closed
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
https://tieba.baidu.com/p/9105338452
https://n0099.net/tbm/v1/client_tester.php?type=replies&tid=9105338452&pn=1&client_version=12.62.1.0
https://web.archive.org/web/20240726153335/https://n0099.net/tbm/v1/client_tester.php?type=replies&tid=9105338452&pn=1&client_version=12.62.1.0
从
2024-07-12开始似乎是特定于某些tid的（在某些tid上一直复现而某些一直不能）
https://github.com/n0099/tbclient.protobuf/blob/12.51.7.1/proto/User.proto#L72
The text was updated successfully, but these errors were encountered: