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个

[right]本站更新记录与bug反馈[/right]

积分: 15

      更新flarum至1.4，更新了以下扩展：

      • Upgrading blomstra/user-filter (0.1.1 => 0.1.4)
      • Upgrading clarkwinkelmann/flarum-ext-mass-actions (1.0.0 => 1.1.0)
      • Upgrading flarum/akismet (v1.2.0 => v1.4.0)
      • Upgrading flarum/approval (v1.2.0 => v1.4.0)
      • Upgrading flarum/bbcode (v1.2.0 => v1.4.0)
      • Upgrading flarum/core (v1.2.1 => v1.4.0)
      • Upgrading flarum/emoji (v1.2.0 => v1.4.0)
      • Upgrading flarum/flags (v1.2.0 => v1.4.0)
      • Upgrading flarum/lang-english (v1.2.0 => v1.4.0)
      • Upgrading flarum/lock (v1.2.0 => v1.4.0)
      • Upgrading flarum/markdown (v1.2.0 => v1.4.0)
      • Upgrading flarum/mentions (v1.2.0 => v1.4.0)
      • Upgrading flarum/nicknames (v1.2.0 => v1.4.0)
      • Upgrading flarum/pusher (v1.2.0 => v1.4.0)
      • Upgrading flarum/statistics (v1.2.0 => v1.4.0)
      • Upgrading flarum/sticky (v1.2.0 => v1.4.0)
      • Upgrading flarum/subscriptions (v1.2.0 => v1.4.0)
      • Upgrading flarum/suspend (v1.2.0 => v1.4.0)
      • Upgrading flarum/tags (v1.2.0 => v1.4.0)
      • Upgrading fof/bbcode-details (1.0.0 => 1.1.0)
      • Upgrading fof/best-answer (1.1.9 => 1.2.2)
      • Upgrading fof/byobu (1.1.4 => 1.1.6)
      • Upgrading fof/default-group (1.0.1 => 1.1.0)
      • Upgrading fof/drafts (1.1.1 => 1.1.2)
      • Upgrading fof/follow-tags (1.1.2 => 1.1.5)
      • Upgrading fof/gamification (1.3.5 => 1.4.5)
      • Upgrading fof/links (1.0.3 => 1.1.1)
      • Upgrading fof/mason (1.0.1 => 1.1.0)
      • Upgrading fof/masquerade (2.1.0 => 2.1.2)
      • Upgrading fof/merge-discussions (1.2.2 => 1.3.0)
      • Upgrading fof/nightmode (1.2.1 => 1.4.0)
      • Upgrading fof/polls (1.0.5 => 1.1.0)
      • Upgrading fof/prevent-necrobumping (1.0.1 => 1.1.0)
      • Upgrading fof/reactions (1.1.0 => 1.1.2)
      • Upgrading fof/socialprofile (1.1.1 => 1.1.4)
      • Upgrading fof/stopforumspam (1.2.0 => 1.2.1)
      • Upgrading fof/upload (1.2.0 => 1.2.3)
      • Upgrading fof/user-bio (1.0.2 => 1.1.0)
      • Upgrading fof/user-directory (1.2.2 => 1.2.3)
      • Upgrading ianm/follow-users (1.0.5 => 1.1.1)
      • Upgrading ianm/level-ranks (1.0.0 => 1.1.0)
      • Upgrading ianm/synopsis (1.2.0 => 1.2.1)
      • Upgrading justoverclock/user-pc-specs (0.1.5 => 0.1.6)
      • Upgrading justoverclock/users-map-location (0.1.2 => 0.1.6)
      • Upgrading swaggymacro/only-starter (0.6.3 => 0.6.4)
      • Upgrading the-turk/flarum-mathren (1.0.3 => 1.0.5)
      • Upgrading v17development/flarum-user-badges (v1.0.0 => v1.1.0)

      [right]本站更新记录与bug反馈[/right]

      积分: 15

      反馈

      这个是一个签名档或者说是小尾巴!

      积分: 18
        4 天 后

        更新了以下扩展：

        • Upgrading fof/best-answer (1.2.2 => 1.2.3)
        • Upgrading fof/sitemap (1.0.3 => 2.0.0)
        • Upgrading the-turk/flarum-diff (1.1.1 => 1.1.2)
        • Upgrading the-turk/flarum-stickiest (2.0.3 => 3.0.0)

        [right]本站更新记录与bug反馈[/right]

        积分: 15
        1 个月 后

        更新了以下扩展：

        • Upgrading clarkwinkelmann/flarum-ext-mass-actions (1.1.0 => 1.1.2)
        • Upgrading flarum/core (v1.4.0 => v1.4.1)
        • Upgrading flarum/statistics (v1.4.0 => v1.4.1)
        • Upgrading fof/analytics (1.0.0 => 1.1.0)
        • Upgrading fof/byobu (1.1.6 => 1.1.7)
        • Upgrading fof/follow-tags (1.1.5 => 1.1.6)
        • Upgrading fof/links (1.1.1 => 1.1.2)
        • Upgrading fof/masquerade (2.1.2 => 2.1.3)
        • Upgrading fof/merge-discussions (1.3.0 => 1.3.1)
        • Upgrading fof/nightmode (1.4.0 => 1.4.1)
        • Upgrading fof/sitemap (2.0.0 => 2.0.1)
        • Upgrading ianm/follow-users (1.1.1 => 1.2.0)
        • Upgrading the-turk/flarum-mathren (1.0.5 => 1.0.7)
        • Upgrading the-turk/flarum-stickiest (3.0.0 => 3.0.1)

        [right]本站更新记录与bug反馈[/right]

        积分: 15
        1 个月 后

        更新flarum至1.5，更新了以下扩展：

        • Upgrading flarum/core (v1.4.1 => v1.5.0)
        • Upgrading flarum/tags (v1.4.0 => v1.5.0)
        • Upgrading flarum/flags (v1.4.0 => v1.5.0)
        • Upgrading flarum/approval (v1.4.0 => v1.5.0)
        • Upgrading flarum/akismet (v1.4.0 => v1.5.0)
        • Upgrading flarum/emoji (v1.4.0 => v1.5.0)
        • Upgrading flarum/lang-english (v1.4.0 => v1.5.0)
        • Upgrading flarum/lock (v1.4.0 => v1.5.0)
        • Upgrading flarum/markdown (v1.4.0 => v1.5.0)
        • Upgrading flarum/mentions (v1.4.0 => v1.5.0)
        • Upgrading flarum/nicknames (v1.4.0 => v1.5.0)
        • Upgrading flarum/pusher (v1.4.0 => v1.5.0)
        • Upgrading flarum/statistics (v1.4.1 => v1.5.0)
        • Upgrading flarum/subscriptions (v1.4.0 => v1.5.0)
        • Upgrading flarum/suspend (v1.4.0 => v1.5.0)
        • Upgrading fof/gamification (1.4.5 => 1.5.0)
        • Upgrading fof/mason (1.1.0 => 1.2.0)
        • Upgrading fof/nightmode (1.4.1 => 1.5.0)
        • Upgrading fof/polls (1.1.0 => 1.2.0)
        • Upgrading justoverclock/discussion-info (0.1.2 => 0.1.5)
        • Upgrading flarum/bbcode (v1.4.0 => v1.5.0)
        • Upgrading flarum/sticky (v1.4.0 => v1.5.0)

        [right]本站更新记录与bug反馈[/right]

        积分: 15

        n0099 截止2022年10月7号，根据 @creeper568 的指示精神其要求我们立即停止通过腾讯云cdn服务加速对ugc图片的访问并在境内存储ugc图片的罪恶行径

        在irol的亲力而为下我们最终成功弃用了一切腾讯云服务

        [right]本站更新记录与bug反馈[/right]

        • Wien 回复了此帖
        积分: 15

            更换邮箱时 任何密码都是错误
            更改注册邮箱以实现另一邮箱账号登陆该账号
            需要管理员手动改动注册信息和登录信息并发放新密码才能更改邮箱吗 n0099

            彗星の如く現れた星の原石

            アイドルvtuberほしまちすいせい☄~

            すいちゃんは——今日もかわいい！

            No life must forced to stop

            积分: 18

                n0099 并没有 而是之前的邮箱是乱填的 本身就无法正常使用😢
                所以想换成一个能用的邮箱

                彗星の如く現れた星の原石

                アイドルvtuberほしまちすいせい☄~

                すいちゃんは——今日もかわいい！

                No life must forced to stop

                积分: 18
                  21 天 后

                  根据此前

                  n0099 根据四叶tg群与 @Wien 的讨论结果：

                  我以维也纳阁下推荐的 https://1024.day/d/59 为抓手
                  形成一套扔掉flarum默认的基于mysql fulltext index https://docs.flarum.org/extend/search/ 的方法论
                  打出了基于elasticsearch轻量级替代sonic的组合拳
                  赋能flarum那跟tg zulip一样烂的搜索
                  最终重新实现了在flarum自带的搜索中能搜到东西： https://n0099.net/v/?q=%E9%82%AA%E6%81%B6%E7%BB%84%E7%BB%87

                  但由于不知道是由于扩展flarum-sonic，还是其php通信sonic的依赖库ppshobi/psonic，还是sonic本身的问题
                  在扩展对sonic插入索引时遇到单条回复贴内容超长就会导致60s超时：
                  https://github.com/ganuonglachanh/flarum-sonic/issues/7#issuecomment-129727201

                  所以我只能暂时跳过了对这些极少数超长回复贴的索引：

                  也就意味着他们不可能被现在的flarum搜索给检索到

                  [right]本站更新记录与bug反馈[/right]

                  积分: 15

                    更新了以下扩展

                    • Upgrading flarum-lang/chinese-simplified (v1.1.1.1220 => v1.2.0)
                    • Upgrading flarum/statistics (v1.5.0 => v1.5.1)
                    • Upgrading fof/best-answer (1.2.3 => 1.2.4)
                    • Upgrading fof/follow-tags (1.1.6 => 1.1.7)
                    • Upgrading fof/gamification (1.5.0 => 1.6.1)
                    • Upgrading fof/polls (1.2.0 => 1.2.1)
                    • Upgrading fof/profile-image-crop (1.0.1 => 1.1.0)
                    • Upgrading fof/reactions (1.1.2 => 1.1.3)
                    • Upgrading fof/stopforumspam (1.2.1 => 1.2.2)
                    • Upgrading fof/user-bio (1.1.0 => 1.1.1)

                    n0099

                    n0099 对于此问题我已致电该扩展repo的有关人士催促其进行一个包流程的发布： https://github.com/FriendsOfFlarum/profile-image-crop/pull/17#issuecomment-1296220944
                    世界名画：她同意了

                    [right]本站更新记录与bug反馈[/right]

                    积分: 15
                        1 个月 后
                        6 个月 后