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

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个

    积分: 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)
      积分: 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)
        积分: 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)
        积分: 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)
        积分: 15

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

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

        • 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搜索给检索到

            积分: 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
            世界名画:她同意了

            积分: 15
            1 个月 后