changelog

找出所有只设置了子tag但没有设置parent tag的orpha tag状态的主题帖的sql：

SET @parentTagID = 15;
SELECT DISTINCT discussion_id FROM prefix_discussion_tag AS A WHERE discussion_id IN (SELECT discussion_id FROM `prefix_discussion_tag` WHERE tag_id IN (SELECT id FROM prefix_tags WHERE parent_id = @parentTagID)) AND NOT EXISTS (SELECT 1 FROM prefix_discussion_tag WHERE discussion_id = A.discussion_id AND tag_id = @parentTagID) ORDER BY discussion_id ASC;

安装以下扩展：

• swaggymacro/only-starter
• justoverclock/custom-header
• nomiscz/flarum-ext-auth-steam
• clarkwinkelmann/flarum-ext-mass-actions
• justoverclock/users-map-location
• littlecxm/flarum-reply-to-see
• blomstra/user-filter
• justoverclock/user-pc-specs
• clarkwinkelmann/flarum-ext-shadow-ban
• itnt/flarum-uitab

更新了以下扩展：

• Upgrading afrux/forum-stats-widget (v0.1.0 => v0.1.1)
• Upgrading afrux/forum-widgets-core (v0.1.6 => v0.1.7)
• Upgrading afrux/online-users-widget (v0.1.5 => v0.1.6)
• Upgrading afrux/top-posters-widget (v0.1.3 => v0.1.4)
• Upgrading antoinefr/flarum-ext-money (v1.1.0 => v1.2.0)
• Upgrading askvortsov/flarum-pwa (v3.1.1 => v3.1.3)
• Upgrading clarkwinkelmann/catch-the-fish (1.1.2 => 1.1.3)
• Upgrading flarum/core (v1.2.0 => v1.2.1)
• Upgrading fof/best-answer (1.1.8 => 1.1.9)
• Upgrading fof/byobu (1.1.1 => 1.1.4)
• Upgrading fof/drafts (1.0.3 => 1.1.1)
• Upgrading fof/follow-tags (1.1.1 => 1.1.2)
• Upgrading fof/gamification (1.3.3 => 1.3.5)
• Upgrading fof/linguist (1.0.3 => 1.0.4)
• Upgrading fof/merge-discussions (1.2.1 => 1.2.2)
• Upgrading fof/nightmode (1.2.0 => 1.2.1)
• Upgrading fof/pages (1.0.1 => 1.0.4)
• Upgrading fof/reactions (1.0.4 => 1.1.0)
• Upgrading fof/upload (1.1.0 => 1.2.0)
• Upgrading malago/flarum-achievements (0.5.4 => 0.5.5)
• Upgrading michaelbelgium/flarum-discussion-views (v7.1.2 => v7.1.3)
• Upgrading michaelbelgium/flarum-profile-views (v6.0.1 => v8.0.2)

启用了扩展katosdev/signature，可在 https://n0099.net/v/settings/signature 设置回复帖签名档 n0099 Wien
禁用了扩展zerosonesfun/flarum-ext-chords
删除了扩展flarum/likes（目前使用的是fof/gamification） n0099

n0099 todo：等待 https://github.com/katosdev/signature-OLD/pull/8 merge后更新扩展katosdev/signature

长期以来未提及的一个本站特征：

n0099 本论坛服务端会在用户上传图片至服务端后再将服务端上的图片压缩为有损webp格式（参数-m 6 -sharp_yuv -q 80）并将文件上传至腾讯云oss，然后网页前端会请求腾讯云cdn的url以获取对应腾讯云上的图片，而不是服务端上的原图片。因此所有用户上传的所有图片都流入了位于中国的数据中心，并可能接受腾讯云对数据进行的有关审查。但请放心服务端上传图片时并未携带任何其他论坛内的元数据（如坛内上传用户名，发在什么帖子下），因此使用本论坛的图片上传者不太可能会被审查波及到

n0099 应定期执行的删除b站链接tracing参数的php：

$telemetryParamNames = ['spm_id_from', 'seid', 'utm_', 'spm', 'share_source'];
$telemetryParamNamesRegex = join('|', $telemetryParamNames);
$sql = $pdo->prepare('SELECT id, discussion_id, number, content FROM prefix_posts WHERE content REGEXP ?');
$sql->execute([$telemetryParamNamesRegex]);
$posts = $sql->fetchAll();
foreach ($posts as $post) {
    ['id' => $id, 'discussion_id' => $discussionId, 'number' => $number, 'content' => $content] = $post;
    echo "removing following querystrings which contains telemetry params for https://n0099.net/v/d/{$discussionId}/{$number}\n";
    $matches = [];
    preg_match_all('/\/?\?(.*?)(<|">)/', $content, $matches, PREG_SET_ORDER);
    echo '    ' . join("\n    ", (array_map(fn($i) => $i[1], array_filter($matches, fn($i) => $i[2] === '">')))) . "\n";
    if (count($matches) === 0) continue;

    $content = preg_replace_callback('/\/?\?(.*?)(<|">)/',  fn($m) =>
        preg_match("/{$telemetryParamNamesRegex}/", $content, $_matches) === 1 ? $m[2] : $m[0], $content);
    $sql2 = $pdo->prepare('UPDATE prefix_posts SET content = ? WHERE id = ?');
    $sql2->execute([$content, $id]);
    if ($sql2->rowCount() !== 1) {
        echo "update for {$id} https://n0099.net/v/d/{$discussionId}/{$number} failed";
    }
}

2022-07-22：清理了23个

Monoid1989 位于梨木利亚（永恒休眠）
当viewport宽度>422px时就会这样
我已经向上游扩展提了pr https://github.com/FriendsOfFlarum/best-answer/pull/68，请等待他们merge然后发布新版本最后我更新扩展
已发布 https://github.com/FriendsOfFlarum/best-answer/releases/tag/1.2.3