piterator-org / luogu-discussion-archive

洛谷讨论存档
https://lglg.top
GNU Affero General Public License v3.0
27 stars 4 forks source link

不知为何,在查看某用户的回帖时,会显示错误的帖子标题 #13

Closed GitPinkRabbit closed 11 months ago

GitPinkRabbit commented 11 months ago

image

该帖子(https://lglg.top/726518)实际上的标题是《【百枚NOI奖牌】洛谷省选计划,助梦 NOI 2024》,被错误显示为《kkkwcnm》。

复现:访问 https://lglg.top/user/936417/replies

GitPinkRabbit commented 11 months ago

实际上,我利用大管理员权限查后台发现,洛谷所有帖子,包括所有已删除帖子和所有团队内部帖子,均没有标题为《kkkwcnm》的帖子。这究竟是怎么一回事呢

wxh06 commented 11 months ago
luogu_discussion_archive=# SELECT "time", "until", "title", "authorId", "forumSlug" FROM "public"."PostSnapshot" WHERE "postId" = 726518;
          time           |          until          |                   title                    | authorId | forumSlug
-------------------------+-------------------------+--------------------------------------------+----------+-----------
 2023-11-20 05:03:33.116 | 2023-12-13 00:56:53.393 | 【百枚NOI奖牌】洛谷省选计划,助梦 NOI 2024 |      397 | academics
 2023-11-19 04:10:47.082 | 2023-11-19 14:11:40.284 | 【百枚NOI奖牌】洛谷省选计划,助梦 NOI 2024 |      397 | academics
 2023-11-07 05:35:13.84  | 2023-11-18 14:18:26.139 | 【百枚NOI奖牌】洛谷省选计划,助梦 NOI 2024 |      397 | academics
 2023-11-06 05:50:28.259 | 2023-11-06 05:50:28.259 | kkkwcnm                                    |  1098213 | P3920
(4 rows)

可以看出这篇帖子本来是《kkkwcnm》,被使用非常规手段改成《【百枚NOI奖牌】洛谷省选计划,助梦 NOI 2024》的。

GitPinkRabbit commented 11 months ago

6

eventlOwOp commented 10 months ago

6