<?php
/**
 * 应用引导：配置、会话、数据库、错误兜底、插件加载
 */

// mbstring 兼容层必须先加载，避免虚拟主机缺少扩展时直接 fatal。
require_once __DIR__ . '/compat.php';

define('APP_ROOT', dirname(__DIR__));
define('APP_VERSION', '6.25.232');
// 在线升级手工上传接口只允许绑定该邮箱的超级管理员使用。
if (!defined('UPGRADE_OWNER_EMAIL')) {
    define('UPGRADE_OWNER_EMAIL', '210255270@qq.com');
}

// 统一时区（可在 config.php 中覆盖：'timezone' => 'Asia/Shanghai'）
date_default_timezone_set('Asia/Shanghai');

// 上传目录默认禁止执行 PHP。老站点升级后若缺少 .htaccess，这里会自动补上；
// 写入失败时保留原状，木卫守护会继续报告并给出修复入口。
$kmUploadsDir = APP_ROOT . '/uploads';
$kmUploadsGuard = "# 上传目录禁止执行 PHP\n<FilesMatch \"\.(php|phtml|phar|php[0-9])$\">\n  <IfModule mod_authz_core.c>\n    Require all denied\n  </IfModule>\n  <IfModule !mod_authz_core.c>\n    Order allow,deny\n    Deny from all\n  </IfModule>\n</FilesMatch>\n";
if (is_dir($kmUploadsDir)) {
    $kmUploadsHtaccess = $kmUploadsDir . '/.htaccess';
    $kmUploadsOld = is_file($kmUploadsHtaccess) ? (string) @file_get_contents($kmUploadsHtaccess) : '';
    // 旧版写法含 Require / Options，Apache 2.2 或 AllowOverride 受限时会 500；只迁移可识别的旧版内容。
    if (!is_file($kmUploadsHtaccess) || (strpos($kmUploadsOld, 'Require all denied') !== false && strpos($kmUploadsOld, 'IfModule') === false)) {
        @file_put_contents($kmUploadsHtaccess, $kmUploadsGuard, LOCK_EX);
    }
}

// ---------- 错误兜底：任何异常都给出「重新加载」页面 ----------
error_reporting(E_ALL);
ini_set('display_errors', '0');
ini_set('log_errors', '1');
@ini_set('error_log', APP_ROOT . '/data/php-error.log');

function app_fatal_page($message, $detail = '')
{
    if (!headers_sent()) {
        http_response_code(503);
        header('Content-Type: text/html; charset=utf-8');
    }
    $safe = htmlspecialchars($message, ENT_QUOTES, 'UTF-8');
    $det = htmlspecialchars($detail, ENT_QUOTES, 'UTF-8');
    echo <<<HTML
<!DOCTYPE html><html lang="zh-CN"><head><meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>页面加载失败 · 木漏茶室</title>
<style>
body{margin:0;min-height:100vh;display:flex;align-items:center;justify-content:center;
background:radial-gradient(900px 500px at 20% 0%,#fff,#eaf5fc 60%,#dbeaf6);color:#2b4a5e;
font-family:-apple-system,"PingFang SC","Microsoft YaHei",sans-serif;padding:24px}
.card{position:fixed;inset:0;z-index:2147483647;display:flex;flex-direction:column;align-items:center;justify-content:center;
background:radial-gradient(900px 500px at 20% 0%,#fff,#eaf5fc 60%,#dbeaf6);padding:34px 24px;text-align:center;
box-sizing:border-box;overflow:auto}
.snow{width:52px;height:52px;margin:0 auto 14px}
h1{font-size:17px;font-weight:600;margin:0 0 10px;letter-spacing:.06em}
p{font-size:13px;color:#7692a5;line-height:1.9;margin:0 0 20px}
button{border:0;border-radius:14px;padding:13px 30px;background:linear-gradient(135deg,#a5cfe8,#6fa8ce);
color:#fff;font-size:14px;letter-spacing:.1em;cursor:pointer;box-shadow:0 12px 26px rgba(110,160,200,.35)}
pre{text-align:left;background:#f6fbfe;border:1px dashed #d5e7f4;border-radius:12px;padding:12px;
font-size:11px;color:#88a1b2;white-space:pre-wrap;word-break:break-all;margin-top:18px;max-height:30vh;overflow:auto;
width:min(460px,100%);box-sizing:border-box}
</style></head><body><div class="card">
<svg class="snow" viewBox="0 0 64 64" fill="none" stroke="#8fbcd8" stroke-width="2"><g stroke-linecap="round">
<path d="M32 6v52M10 19l44 26M54 19L10 45"/><path d="M32 14l-5 5M32 14l5 5M32 50l-5-5M32 50l5-5"/><circle cx="32" cy="32" r="5" fill="#eaf5fb"/></g></svg>
<h1>{$safe}</h1><p>霜雪落定，页面暂时没有回应。<br>可尝试重新加载，或稍后再来。</p>
<button onclick="location.reload()">重新加载</button>
<pre>{$det}</pre></div></body></html>
HTML;
    exit;
}

set_exception_handler(function ($e) {
    app_fatal_page('页面加载失败', $e->getMessage() . ' @ ' . basename($e->getFile()) . ':' . $e->getLine());
});
register_shutdown_function(function () {
    $err = error_get_last();
    if ($err && in_array($err['type'], [E_ERROR, E_PARSE, E_CORE_ERROR, E_COMPILE_ERROR], true)) {
        app_fatal_page('页面加载失败', $err['message'] . ' @ ' . basename($err['file']) . ':' . $err['line']);
    }
});

// ---------- 会话 ----------
if (session_status() !== PHP_SESSION_ACTIVE) {
    // 勾选“永久免登录”后，服务端会话也不能因默认 24 分钟 GC 被提前清理。
    @ini_set('session.gc_maxlifetime', '315360000');
    // 共享主机默认 session 目录不可写时，改用站点 data/sessions 或系统临时目录。
    if (function_exists('km_session_prepare')) { km_session_prepare(); }
    session_name('komorebi_sid');
    // 默认保留 30 天；苹果 Safari 对“会话 Cookie”回收较激进，避免刷新或切后台后掉登录。
    // 只按真实 HTTPS/443 判断；不信任 X-Forwarded-Proto，避免 HTTP 访问被误设 Secure Cookie 后登录态直接丢失。
    $kmHttps = (!empty($_SERVER['HTTPS']) && strtolower((string) $_SERVER['HTTPS']) !== 'off')
        || ((int) ($_SERVER['SERVER_PORT'] ?? 0) === 443);
    session_set_cookie_params([
        'lifetime' => 30 * 86400,
        'path'     => '/',
        'secure'   => $kmHttps,
        'httponly' => true,
        'samesite' => 'Lax',
    ]);
    @session_start();
}

// ---------- 配置 ----------
$configFile = APP_ROOT . '/config.php';
if (!file_exists($configFile)) {
    $installer = APP_ROOT . '/install.php';
    $installTemplate = APP_ROOT . '/inc/install_dist.php';
    // 部分虚拟主机解压源码后会丢失根目录 install.php，导致跳转后直接 404。
    // 根目录可写时自动从受保护的安装模板还原入口；模板更新过（如刚升级）也同步刷新。
    if (is_file($installTemplate) && is_writable(APP_ROOT)) {
        if (!is_file($installer) || (int) @filemtime($installTemplate) > (int) @filemtime($installer)) {
            @copy($installTemplate, $installer);
        }
    }
    header('Location: install.php');
    exit;
}
$CONFIG = require $configFile;
if (!empty($CONFIG['timezone'])) {
    date_default_timezone_set($CONFIG['timezone']);
}
if (empty($CONFIG['installed'])) {
    $installer = APP_ROOT . '/install.php';
    $installTemplate = APP_ROOT . '/inc/install_dist.php';
    if (is_file($installTemplate) && is_writable(APP_ROOT)) {
        if (!is_file($installer) || (int) @filemtime($installTemplate) > (int) @filemtime($installer)) {
            @copy($installTemplate, $installer);
        }
    }
    header('Location: install.php');
    exit;
}

// 站点根路径（兼容子目录部署）
$scriptDir = rtrim(str_replace('\\', '/', dirname($_SERVER['SCRIPT_NAME'] ?? '/')), '/');
define('BASE_PATH', $scriptDir === '' ? '' : $scriptDir);

require_once __DIR__ . '/helpers.php';
require_once __DIR__ . '/i18n.php';
require_once __DIR__ . '/package_guard.php';
require_once __DIR__ . '/appearance.php';
require_once __DIR__ . '/holidays.php';
require_once __DIR__ . '/db.php';
require_once __DIR__ . '/presence.php';
require_once __DIR__ . '/auth.php';
require_once __DIR__ . '/totp.php';
require_once __DIR__ . '/mailer.php';
require_once __DIR__ . '/friends.php';
require_once __DIR__ . '/announcements.php';
require_once __DIR__ . '/official.php';
require_once __DIR__ . '/security_patch.php';
require_once __DIR__ . '/realtime_guard.php';
require_once __DIR__ . '/profile_visits.php';

// 在输出页头前固定 CSRF 令牌并写入持久 Cookie，避免表单渲染后才 setcookie 失效。
if (function_exists('csrf_token')) {
    csrf_token();
}

// 永久免登录：每次访问都续期登录 Cookie（浏览器通常会把 Cookie 有效期截到 400 天）
if (!empty($_SESSION['remember_until']) && function_exists('permanent_login_seconds')
    && (int) $_SESSION['remember_until'] > time() && !headers_sent()) {
    refresh_session_cookie(permanent_login_seconds());
} elseif (!empty($_SESSION['uid']) && function_exists('refresh_session_cookie') && !headers_sent()) {
    // 老登录态也升级为 30 天持久 Cookie，兼容苹果端。
    refresh_session_cookie(30 * 86400);
}


// ---------- 轻量结构升级（老站自动补列） ----------
function km_migrate()
{
    $cols = [
        ['reports', 'reject_reason', DB::$driver === 'sqlite' ? "TEXT DEFAULT ''" : 'TEXT'],
        ['reports', 'rejected_at', "VARCHAR(20) DEFAULT ''"],
        ['users', 'verify_style', "VARCHAR(20) DEFAULT ''"],
        ['users', 'verify_title', "VARCHAR(60) DEFAULT ''"],
        ['posts', 'netdisk_name', "VARCHAR(120) DEFAULT ''"],
        ['posts', 'netdisk_size', "VARCHAR(40) DEFAULT ''"],
        ['posts', 'netdisk_code', "VARCHAR(40) DEFAULT ''"],
        ['posts', 'ip', "VARCHAR(64) DEFAULT ''"],
        ['posts', 'top_at', "VARCHAR(20) DEFAULT ''"],
        ['posts', 'is_locked', 'INT DEFAULT 0'],
        ['posts', 'allow_save_media', 'INT DEFAULT 1'],
        ['posts', 'author_only', 'INT DEFAULT 0'],
        ['posts', 'attach_visibility', "VARCHAR(16) DEFAULT 'public'"],
        ['posts', 'attach_points', 'INT DEFAULT 0'],
        ['posts', 'netdisk_visibility', "VARCHAR(16) DEFAULT 'public'"],
        ['posts', 'netdisk_points', 'INT DEFAULT 0'],
        ['users', 'auth_token', "VARCHAR(64) DEFAULT ''"],
        ['users', 'auth_token_device', "VARCHAR(64) DEFAULT ''"],
        ['guard_devices', 'note', "VARCHAR(120) DEFAULT ''"],
        ['security_events', 'fingerprint', "VARCHAR(64) DEFAULT ''"],
        ['security_events', 'user_id', "INT DEFAULT 0"],
        ['users', 'qq_openid', "VARCHAR(64) DEFAULT ''"],
        ['users', 'qq_nickname', "VARCHAR(100) DEFAULT ''"],
        ['users', 'last_ip', "VARCHAR(64) DEFAULT ''"],
        ['users', 'last_ip_at', "VARCHAR(20) DEFAULT ''"],
        ['users', 'province', "VARCHAR(32) DEFAULT ''"],
        ['users', 'city', "VARCHAR(32) DEFAULT ''"],
        ['users', 'verify_paid', "INT DEFAULT 0"],
        ['users', 'verify_pending_type', "VARCHAR(32) DEFAULT ''"],
        ['users', 'verify_pending_style', "VARCHAR(20) DEFAULT ''"],
        ['users', 'verify_pending_title', "VARCHAR(60) DEFAULT ''"],
        ['users', 'verify_pending_info', "VARCHAR(255) DEFAULT ''"],
        ['users', 'nickname_changes', "INT DEFAULT 0"],
        ['users', 'avatar_changes', "INT DEFAULT 0"],
        ['users', 'profile_week', "VARCHAR(10) DEFAULT ''"],
        ['users', 'district', "VARCHAR(64) DEFAULT ''"],
        ['users', 'town', "VARCHAR(64) DEFAULT ''"],
        ['users', 'village', "VARCHAR(64) DEFAULT ''"],
        ['users', 'show_location', 'INT DEFAULT 1'],
        ['users', 'show_ip', 'INT DEFAULT 1'],
        ['users', 'comment_bubble', "VARCHAR(20) DEFAULT 'tea'"],
        ['users', 'ban_until', "VARCHAR(20) DEFAULT ''"],
        ['users', 'mute_until', "VARCHAR(20) DEFAULT ''"],
        ['moments', 'location', "VARCHAR(80) DEFAULT ''"],
        ['users', 'account_setup', 'INT DEFAULT 0'],
        ['users', 'is_official', 'INT DEFAULT 0'],
        ['users', 'is_installer_admin', 'INT DEFAULT 0'],
        ['users', 'can_rename_username', 'INT DEFAULT 0'],
        ['users', 'avatar_free_limit', 'INT DEFAULT 3'],
        ['users', 'avatar_unlimited', 'INT DEFAULT 0'],
        ['users', 'avatar_change_cost', 'INT DEFAULT 20'],
        ['users', 'username_free_limit', 'INT DEFAULT 0'],
        ['users', 'username_unlimited', 'INT DEFAULT 0'],
        ['users', 'username_change_cost', 'INT DEFAULT 50'],
        ['users', 'account_protected', 'INT DEFAULT 0'],
        ['users', 'feature_perms', DB::$driver === 'sqlite' ? "TEXT DEFAULT ''" : 'TEXT'],
        ['users', 'exp', 'INT DEFAULT 0'],
        ['drafts', 'kind', "VARCHAR(16) DEFAULT 'post'"],
        ['drafts', 'media_type', "VARCHAR(12) DEFAULT ''"],
        ['drafts', 'media_path', "VARCHAR(255) DEFAULT ''"],
        ['drafts', 'media_name', "VARCHAR(120) DEFAULT ''"],
        ['drafts', 'extra', 'TEXT'],
        ['users', 'profile_bg', "VARCHAR(255) DEFAULT ''"],
        ['users', 'profile_bg_blur', 'INT DEFAULT 0'],
        ['users', 'profile_bg_video', "VARCHAR(255) DEFAULT ''"],
        ['users', 'profile_frame', "VARCHAR(24) DEFAULT ''"],
        ['users', 'profile_visitor_count', 'INT DEFAULT 0'],
        ['users', 'login_fail_count', 'INT DEFAULT 0'],
        ['users', 'login_locked_until', "VARCHAR(20) DEFAULT ''"],
        ['guard_bans', 'ip_value', "VARCHAR(64) DEFAULT ''"],
        ['users', 'friend_reject_requests', 'INT DEFAULT 0'],
        ['users', 'friend_reject_broadcast', 'INT DEFAULT 0'],
        ['users', 'friend_reject_stranger_messages', 'INT DEFAULT 0'],
        ['attachments', 'lyrics', 'TEXT'],
        ['attachments', 'cover_path', "VARCHAR(255) DEFAULT ''"],
        ['attachments', 'matched_title', "VARCHAR(200) DEFAULT ''"],
        ['attachments', 'matched_artist', "VARCHAR(200) DEFAULT ''"],
        ['attachments', 'matched_at', "VARCHAR(20) DEFAULT ''"],
        ['moments', 'lyrics', 'TEXT'],
        ['moments', 'cover_path', "VARCHAR(255) DEFAULT ''"],
        ['moments', 'matched_title', "VARCHAR(200) DEFAULT ''"],
        ['moments', 'matched_artist', "VARCHAR(200) DEFAULT ''"],
        ['moments', 'matched_at', "VARCHAR(20) DEFAULT ''"],
        ['announcements', 'start_at', "VARCHAR(20) DEFAULT ''"],
        ['announcements', 'end_at', "VARCHAR(20) DEFAULT ''"],
        ['announcements', 'show_every_visit', 'INT DEFAULT 0'],
        ['announcements', 'allow_snooze', 'INT DEFAULT 0'],
        ['announcements', 'show_every_refresh', 'INT DEFAULT 0'],
        ['announcements', 'show_limit', 'INT DEFAULT 0'],
        ['announcements', 'banner_loop', 'INT DEFAULT 1'],
        ['announcements', 'banner_closable', 'INT DEFAULT 1'],
        ['extensions', 'sort', 'INT DEFAULT 0'],
        ['extensions', 'icon', "VARCHAR(255) DEFAULT ''"],
        ['quotes', 'sort', 'INT DEFAULT 0'],
        ['links', 'logo', "VARCHAR(255) DEFAULT ''"],
        ['posts', 'review_note', "VARCHAR(255) DEFAULT ''"],
        ['posts', 'reviewed_by', 'INT DEFAULT 0'],
        ['posts', 'reviewed_at', "VARCHAR(20) DEFAULT ''"],
        ['comments', 'parent_id', 'INT DEFAULT 0'],
        ['comments', 'status', 'INT DEFAULT 1'],
        ['moment_comments', 'parent_id', 'INT DEFAULT 0'],
        ['point_logs', 'ref_id', 'INT DEFAULT 0'],
        ['messages', 'type', "VARCHAR(12) DEFAULT 'text'"],
        ['messages', 'path', "VARCHAR(255) DEFAULT ''"],
        ['netdisk', 'bundle_code', "VARCHAR(16) DEFAULT ''"],
        ['netdisk', 'lyrics', 'TEXT'],
        ['netdisk', 'cover_path', "VARCHAR(255) DEFAULT ''"],
        ['netdisk', 'matched_title', "VARCHAR(200) DEFAULT ''"],
        ['netdisk', 'matched_artist', "VARCHAR(200) DEFAULT ''"],
        ['netdisk', 'matched_at', "VARCHAR(20) DEFAULT ''"],
        ['users', 'site_mute_until', "VARCHAR(20) DEFAULT ''"],
        ['users', 'site_mute_reason', "VARCHAR(255) DEFAULT ''"],
        ['users', 'plugin_access', "VARCHAR(20) DEFAULT 'all'"],
        ['users', 'email_verified', 'INT DEFAULT 0'],
        ['users', 'email_login_verify', 'INT DEFAULT 0'],
        ['users', 'totp_secret', "VARCHAR(255) DEFAULT ''"],
        ['users', 'totp_enabled', 'INT DEFAULT 0'],
        ['users', 'totp_backup_codes', 'TEXT'],
        ['users', 'initial_profile', 'TEXT'],
        ['users', 'storage_quota_mb', 'INT DEFAULT 0'],
        ['posts', 'tags', "VARCHAR(255) DEFAULT ''"],
        ['posts', 'publish_at', "VARCHAR(20) DEFAULT ''"],
        ['categories', 'moderators', "VARCHAR(255) DEFAULT ''"],
        ['notifications', 'link', "VARCHAR(255) DEFAULT ''"],
        ['notifications', 'payload', 'TEXT'],
        ['announcements', 'banner_width', 'INT DEFAULT 100'],
        ['announcements', 'banner_bubble', "VARCHAR(20) DEFAULT 'tea'"],
        ['announcements', 'banner_font', "VARCHAR(24) DEFAULT 'default'"],
        ['announcements', 'banner_font_file', "VARCHAR(255) DEFAULT ''"],
        ['announcements', 'banner_bg1', "VARCHAR(16) DEFAULT ''"],
        ['announcements', 'banner_bg2', "VARCHAR(16) DEFAULT ''"],
        ['announcements', 'banner_text', "VARCHAR(16) DEFAULT ''"],
        ['chat', 'voice_text', "VARCHAR(1000) DEFAULT ''"],
        ['moments', 'voice_text', "VARCHAR(1000) DEFAULT ''"],
        ['netdisk', 'folder_id', 'INT DEFAULT 0'],
        ['netdisk_folders', 'share_code', "VARCHAR(16) DEFAULT ''"],
        ['netdisk_folders', 'share_password', "VARCHAR(64) DEFAULT ''"],
        ['netdisk_folders', 'shared_at', "VARCHAR(20) DEFAULT ''"],
        ['post_views', 'view_count', 'INT DEFAULT 1'],
        ['post_views', 'last_viewed_at', "VARCHAR(20) DEFAULT ''"],
        ['gallery', 'size', 'BIGINT DEFAULT 0'],
        ['login_logs', 'device_id', "VARCHAR(64) DEFAULT ''"],
        ['login_logs', 'device_code', "VARCHAR(32) DEFAULT ''"],
        ['login_logs', 'address', "VARCHAR(255) DEFAULT ''"],
        ['extensions', 'url', "VARCHAR(255) DEFAULT ''"],
        ['extensions', 'owner_id', 'INT DEFAULT 0'],
    ];
    $addedColumns = [];
    foreach ($cols as $c) {
        list($table, $col, $def) = $c;
        try {
            if (DB::$driver === 'sqlite') {
                $found = false;
                foreach (DB::all('PRAGMA table_info(' . DB::table($table) . ')') as $row) {
                    if (($row['name'] ?? '') === $col) { $found = true; break; }
                }
                if (!$found) {
                    DB::run('ALTER TABLE ' . DB::table($table) . ' ADD COLUMN ' . $col . ' ' . $def);
                    $addedColumns[$table][$col] = true;
                }
            } else {
                $found = DB::val('SELECT COUNT(*) FROM information_schema.columns
                                  WHERE table_schema = DATABASE() AND table_name = ? AND column_name = ?',
                                 [DB::table($table), $col], 0);
                if (!$found) {
                    DB::run('ALTER TABLE ' . DB::table($table) . ' ADD COLUMN ' . $col . ' ' . $def);
                    $addedColumns[$table][$col] = true;
                }
            }
        } catch (Exception $e) {
            // 忽略：列已存在或无权限
        }
    }
    if (!empty($addedColumns['gallery']['size'])) {
        try {
            foreach (DB::all('SELECT id, path FROM ' . DB::table('gallery') . ' WHERE size <= 0 OR size IS NULL') as $g) {
                $rel = (string) ($g['path'] ?? '');
                if ($rel === '' || strpos($rel, 'uploads/') !== 0 && strpos($rel, 'storage/') !== 0) { continue; }
                $bytes = (int) @filesize(APP_ROOT . '/' . $rel);
                if ($bytes > 0) {
                    DB::update('gallery', ['size' => $bytes], 'id = ?', [(int) $g['id']]);
                }
            }
        } catch (Exception $e) {}
    }
    if (!empty($addedColumns['extensions']['icon'])) {
        try {
            DB::run('UPDATE ' . DB::table('extensions') . " SET sort = 0 WHERE slug = 'chat' AND sort = -1");
        } catch (Exception $e) {}
    }
    if (!empty($addedColumns['users']['account_setup'])) {
        try {
            DB::run("UPDATE " . DB::table('users') . " SET account_setup = 1 WHERE account_setup = 0 AND username LIKE 'guest\_%' ESCAPE '\\'");
        } catch (Exception $e) {
            // 忽略：个别数据库不支持 ESCAPE 写法时不影响新注册
        }
    }
    if (!empty($addedColumns['users']['exp'])) {
        try {
            DB::run('UPDATE ' . DB::table('users') . ' SET exp = points WHERE exp = 0');
        } catch (Exception $e) {
            // 忽略
        }
    }

    // v6.08 公告只保留弹窗与滚动横幅：旧“发帖卡片公告”统一归并为弹窗公告
    try {
        if (setting('km_announcement_kinds_v608', '0') !== '1') {
            DB::run('UPDATE ' . DB::table('announcements') . " SET kind = 'modal' WHERE kind = 'postcard'");
            set_setting('km_announcement_kinds_v608', '1');
        }
    } catch (Exception $e) {
        // 忽略：公告表不可用时不影响站点
    }

    // 图片采集扩展已下线，清理老库中的扩展记录
    try {
        DB::delete('extensions', 'slug = ?', ['collect']);
    } catch (Exception $e) {
    }

    // 积分 / 资料修改 / 红包表
    try {
        $newTables = [
            'point_logs' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INT DEFAULT 0, action VARCHAR(32) DEFAULT '', delta INT DEFAULT 0, note VARCHAR(255) DEFAULT '', ref_id INT DEFAULT 0, created_at VARCHAR(20) DEFAULT '')",
            'profile_changes' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INT DEFAULT 0, kind VARCHAR(16) DEFAULT '', created_at VARCHAR(20) DEFAULT '')",
            'red_packets' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, chat_id INT DEFAULT 0, sender_id INT DEFAULT 0, total INT DEFAULT 0, remaining INT DEFAULT 0, `count` INT DEFAULT 0, remaining_count INT DEFAULT 0, created_at VARCHAR(20) DEFAULT '')",
            'moments' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INT DEFAULT 0, content TEXT, media_type VARCHAR(12) DEFAULT '', media_path VARCHAR(255) DEFAULT '', media_name VARCHAR(120) DEFAULT '', location VARCHAR(80) DEFAULT '', status INT DEFAULT 1, created_at VARCHAR(20) DEFAULT '')",
            'moment_likes' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, moment_id INT DEFAULT 0, user_id INT DEFAULT 0, created_at VARCHAR(20) DEFAULT '')",
            'moment_comments' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, moment_id INT DEFAULT 0, user_id INT DEFAULT 0, content TEXT, created_at VARCHAR(20) DEFAULT '')",
            'friends' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INT DEFAULT 0, friend_id INT DEFAULT 0, remark VARCHAR(64) DEFAULT '', created_at VARCHAR(20) DEFAULT '', UNIQUE(user_id, friend_id))",
            'friend_requests' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, from_id INT DEFAULT 0, to_id INT DEFAULT 0, status VARCHAR(16) DEFAULT 'pending', created_at VARCHAR(20) DEFAULT '', UNIQUE(from_id, to_id))",
            'post_unlocks' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, post_id INT DEFAULT 0, user_id INT DEFAULT 0, kind VARCHAR(16) DEFAULT 'attach', points INT DEFAULT 0, created_at VARCHAR(20) DEFAULT '', UNIQUE(post_id, user_id, kind))",
            'post_read_rewards' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, post_id INT DEFAULT 0, user_id INT DEFAULT 0, day VARCHAR(10) DEFAULT '', reward INT DEFAULT 0, created_at VARCHAR(20) DEFAULT '', UNIQUE(post_id, user_id, day))",
            'security_events' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, kind VARCHAR(32) DEFAULT '', ip VARCHAR(64) DEFAULT '', identifier VARCHAR(128) DEFAULT '', fingerprint VARCHAR(64) DEFAULT '', user_id INT DEFAULT 0, created_at VARCHAR(20) DEFAULT '')",
            'guard_blocks' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, ip VARCHAR(64) DEFAULT '', reason VARCHAR(255) DEFAULT '', until INT DEFAULT 0, hits INT DEFAULT 0, created_at VARCHAR(20) DEFAULT '', updated_at VARCHAR(20) DEFAULT '', UNIQUE(ip))",
            'guard_devices' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, fingerprint VARCHAR(64) DEFAULT '', user_id INT DEFAULT 0, ip VARCHAR(64) DEFAULT '', ua VARCHAR(255) DEFAULT '', first_at VARCHAR(20) DEFAULT '', last_at VARCHAR(20) DEFAULT '', visits INT DEFAULT 0, note VARCHAR(120) DEFAULT '', UNIQUE(fingerprint))",
            'guard_bans' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, ban_type VARCHAR(16) DEFAULT '', ban_value VARCHAR(128) DEFAULT '', reason VARCHAR(255) DEFAULT '', created_by INT DEFAULT 0, created_at VARCHAR(20) DEFAULT '', hits INT DEFAULT 0, last_hit_at VARCHAR(20) DEFAULT '', UNIQUE(ban_type, ban_value))",
            'login_logs' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INT DEFAULT 0, username VARCHAR(64) DEFAULT '', nickname VARCHAR(64) DEFAULT '', ip VARCHAR(64) DEFAULT '', ua VARCHAR(255) DEFAULT '', result VARCHAR(16) DEFAULT '', reason VARCHAR(255) DEFAULT '', device_id VARCHAR(64) DEFAULT '', device_code VARCHAR(32) DEFAULT '', address VARCHAR(255) DEFAULT '', created_at VARCHAR(20) DEFAULT '')",
            'audit_logs' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, actor_id INT DEFAULT 0, action VARCHAR(64) DEFAULT '', detail VARCHAR(255) DEFAULT '', ip VARCHAR(64) DEFAULT '', created_at VARCHAR(20) DEFAULT '')",
            'blocked_users' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, blocker_id INT DEFAULT 0, blocked_id INT DEFAULT 0, created_at VARCHAR(20) DEFAULT '', UNIQUE(blocker_id, blocked_id))",
            'profile_visits' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, profile_user_id INT DEFAULT 0, visitor_id INT DEFAULT 0, visits INT DEFAULT 1, first_at VARCHAR(20) DEFAULT '', last_at VARCHAR(20) DEFAULT '', UNIQUE(profile_user_id, visitor_id))",
            'follows' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, follower_id INT DEFAULT 0, target_type VARCHAR(16) DEFAULT 'user', target_id INT DEFAULT 0, created_at VARCHAR(20) DEFAULT '', UNIQUE(follower_id, target_type, target_id))",
            'drafts' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INT DEFAULT 0, kind VARCHAR(16) DEFAULT 'post', title VARCHAR(120) DEFAULT '', content TEXT, cat_id INT DEFAULT 0, media_type VARCHAR(12) DEFAULT '', media_path VARCHAR(255) DEFAULT '', media_name VARCHAR(120) DEFAULT '', extra TEXT, updated_at VARCHAR(20) DEFAULT '')",
            'avatar_reviews' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INT DEFAULT 0, old_avatar VARCHAR(255) DEFAULT '', new_avatar VARCHAR(255) DEFAULT '', status INT DEFAULT 0, reason VARCHAR(255) DEFAULT '', reviewer_id INT DEFAULT 0, reviewed_at VARCHAR(20) DEFAULT '', auto_score INT DEFAULT 0, cost INT DEFAULT 0, created_at VARCHAR(20) DEFAULT '')",
            'announcements' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, title VARCHAR(160) DEFAULT '', content TEXT, kind VARCHAR(16) DEFAULT 'modal', status INT DEFAULT 1, start_at VARCHAR(20) DEFAULT '', end_at VARCHAR(20) DEFAULT '', speed INT DEFAULT 24, show_every_visit INT DEFAULT 0, show_every_refresh INT DEFAULT 0, show_limit INT DEFAULT 0, allow_snooze INT DEFAULT 0, banner_loop INT DEFAULT 1, banner_closable INT DEFAULT 1, author_id INT DEFAULT 0, created_at VARCHAR(20) DEFAULT '', updated_at VARCHAR(20) DEFAULT '')",
            'announcement_views' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, announcement_id INT DEFAULT 0, user_id INT DEFAULT 0, views INT DEFAULT 0, last_at VARCHAR(20) DEFAULT '', UNIQUE(announcement_id, user_id))",
            'card_bg_reviews' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INT DEFAULT 0, old_bg VARCHAR(255) DEFAULT '', old_bg_video VARCHAR(255) DEFAULT '', new_bg VARCHAR(255) DEFAULT '', new_bg_video VARCHAR(255) DEFAULT '', new_blur INT DEFAULT 0, status INT DEFAULT 0, reason VARCHAR(255) DEFAULT '', reviewer_id INT DEFAULT 0, reviewed_at VARCHAR(20) DEFAULT '', created_at VARCHAR(20) DEFAULT '')",
            'analytics_daily' => "(day VARCHAR(10) NOT NULL PRIMARY KEY, pv INT DEFAULT 0, uv INT DEFAULT 0, posts INT DEFAULT 0, comments INT DEFAULT 0)",
            'plugin_purchases' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INT DEFAULT 0, slug VARCHAR(40) DEFAULT '', price INT DEFAULT 0, created_at VARCHAR(20) DEFAULT '', UNIQUE(user_id, slug))",
            'netdisk_folders' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INT DEFAULT 0, name VARCHAR(120) DEFAULT '', created_at VARCHAR(20) DEFAULT '')",
            'deleted_accounts' => "(id INTEGER PRIMARY KEY AUTOINCREMENT, original_uid INT DEFAULT 0, username VARCHAR(64) DEFAULT '', nickname VARCHAR(64) DEFAULT '', email VARCHAR(128) DEFAULT '', role VARCHAR(16) DEFAULT 'user', snapshot TEXT, summary VARCHAR(255) DEFAULT '', avatar_archive VARCHAR(255) DEFAULT '', deleted_by INT DEFAULT 0, created_at VARCHAR(20) DEFAULT '', restored_at VARCHAR(20) DEFAULT '', restored_uid INT DEFAULT 0)",
            'user_ext_prefs' => "(user_id INT NOT NULL, extension_id INT NOT NULL, sort INT DEFAULT 0, hidden INT DEFAULT 0, updated_at VARCHAR(20) DEFAULT '', PRIMARY KEY (user_id, extension_id))",
        ];
        foreach ($newTables as $tname => $def) {
            $full = DB::table($tname);
            $exists = DB::$driver === 'sqlite'
                ? DB::val('SELECT COUNT(*) FROM sqlite_master WHERE type = ? AND name = ?', ['table', $full], 0)
                : DB::val('SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = ?', [$full], 0);
            if (!$exists) {
                if (DB::$driver === 'sqlite') {
                    DB::run('CREATE TABLE IF NOT EXISTS ' . $full . ' ' . $def);
                } else {
                    $mysqlDef = str_replace('INTEGER PRIMARY KEY AUTOINCREMENT', 'INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY', $def);
                    DB::run('CREATE TABLE IF NOT EXISTS ' . $full . ' ' . $mysqlDef . ' ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci');
                }
            }
        }
        foreach (['verify_cost' => '200', 'points_checkin' => '3', 'points_checkin_min' => '1', 'points_checkin_max' => '5', 'points_post' => '5', 'points_comment' => '2',
                  'points_post_limit' => '5', 'points_comment_limit' => '10', 'points_over_action' => 'none',
                  'name_change_limit' => '3',
                  'level_names' => '["初雪","霜华","白鹭","神里流","霜见"]', 'transfer_min' => '1',
                  'read_points_enable' => '1', 'read_points' => '1', 'read_points_limit' => '10',
                  'read_points_cap' => '10',
                  'points_like' => '1', 'points_like_limit' => '10', 'points_like_cap' => '10',
                  'points_fav' => '1', 'points_fav_limit' => '10', 'points_fav_cap' => '10',
                  'captcha_register' => '1', 'captcha_login_after' => '3', 'email_verify_required' => '0',
                  'sensitive_words' => '', 'sensitive_action' => 'replace',
                  'quota_netdisk_mb' => '0', 'quota_gallery_mb' => '0', 'quota_attachment_mb' => '0',
                  'seo_enable' => '1', 'pwa_enable' => '1', 'analytics_enable' => '1',
                  'scheduled_publish' => '1',
                  ] as $k => $v) {
            if (trim((string) setting($k, '')) === '') {
                set_setting($k, $v);
            }
        }
    } catch (Exception $e) {
        // 忽略
    }

    // v6.25.19：认证申请默认消耗调整为 200 积分（仅迁移旧默认值，保留管理员自定义值）
    try {
        if (setting('km_verify_cost_v62519', '0') !== '1') {
            $legacyVerifyCost = (int) setting('verify_cost', '200');
            if (in_array($legacyVerifyCost, [0, 50, 100], true)) {
                set_setting('verify_cost', '200');
            }
            set_setting('km_verify_cost_v62519', '1');
        }
    } catch (Exception $e) {
        // 忽略
    }

    // 内置扩展：缺行时补回并默认启用；源码下载中心默认启用
    try {
        $wtable = DB::table('extensions');
        $builtinDefaults = [
            ['gallery', '图床', '上传图片并生成外链 / Markdown / HTML 代码', 0, ''],
            ['netdisk', '网盘', '上传文件、分享提取码、在线预览与下载', 1, ''],
            ['chat', '聊天大厅', '登录用户实时聊天，支持图片与文件', 0, ''],
            ['links', '友情链接', '站点入口列表，管理员可维护', 4, ''],
            ['source', '木漏茶室源码下载中心', '浏览、复制、下载本站源码', 5, ''],
            ['world', '世界圈', '世界那么大，快来分享你的故事吧。', 2, ''],
            ['friends', '好友', '添加好友、备注与实时聊天', 3, ''],
            ['lanzou', '蓝奏云', '蓝奏云网盘入口，登录后管理文件', 6, 'https://www.lanzou.com/'],
        ];
        foreach ($builtinDefaults as $bd) {
            $exists = DB::val('SELECT COUNT(*) FROM ' . $wtable . ' WHERE slug = ?', [$bd[0]], 0);
            if (!$exists) {
                DB::run('INSERT INTO ' . $wtable . ' (slug, name, description, url, is_builtin, status, sort, created_at) VALUES (?,?,?,?,?,?,?,?)',
                    [$bd[0], $bd[1], $bd[2], $bd[4], 1, 1, $bd[3], now()]);
            } elseif ($bd[4] !== '') {
                DB::run('UPDATE ' . $wtable . ' SET url = ? WHERE slug = ? AND (url IS NULL OR url = ?)', [$bd[4], $bd[0], '']);
            }
        }
        // v6.25.191 下架免费音乐库：移除内置扩展入口
        if (setting('km_remove_music_library', '0') !== '1') {
            DB::run('DELETE FROM ' . $wtable . " WHERE slug = 'music' AND is_builtin = 1");
            set_setting('km_remove_music_library', '1');
        }
        // v6.17 下架钓鱼小游戏：清理旧扩展入口与游戏设置
        if (setting('km_remove_fishing_v617', '0') !== '1') {
            DB::run('DELETE FROM ' . $wtable . " WHERE slug = 'fishing'");
            foreach (['fishing_enable', 'fishing_multiplier', 'fishing_escape_rate', 'fishing_fish', 'km_fishing_bet_v606'] as $fishingKey) {
                DB::run('DELETE FROM ' . DB::table('settings') . ' WHERE skey = ?', [$fishingKey]);
            }
            set_setting('km_remove_fishing_v617', '1');
        }
        $worldRow = DB::one('SELECT description FROM ' . $wtable . " WHERE slug = 'world'");
        if ($worldRow && trim((string) $worldRow['description']) === '像朋友圈一样分享文字、图片、视频和语音') {
            DB::run('UPDATE ' . $wtable . " SET description = ? WHERE slug = 'world'", ['世界那么大，快来分享你的故事吧。']);
        }
        // 旧站点把默认扩展名「源码分享」升级为新的下载中心名称
        $sourceRow = DB::one('SELECT name FROM ' . $wtable . " WHERE slug = 'source'");
        if ($sourceRow && in_array(trim((string) $sourceRow['name']), ['源码分享', '源码'], true)) {
            DB::run('UPDATE ' . $wtable . " SET name = ? WHERE slug = 'source'", ['木漏茶室源码下载中心']);
        }
        // 取消聊天大厅的强制置顶：老库中 sort = -1 的聊天大厅归入普通排序
        try {
            DB::run('UPDATE ' . $wtable . " SET sort = 0 WHERE slug = 'chat' AND sort < 0");
        } catch (Exception $e) {}

        if (trim((string) setting('builtin_source_on', '')) !== '1') {
            DB::run('UPDATE ' . $wtable . " SET status = 1 WHERE slug = 'source'");
            set_setting('builtin_source_on', '1');
        }
    } catch (Exception $e) {
        // 忽略
    }

    // 阅读记录表（登录用户）
    try {
        $vtable = DB::table('post_views');
        $vexists = DB::$driver === 'sqlite'
            ? DB::val('SELECT COUNT(*) FROM sqlite_master WHERE type = ? AND name = ?', ['table', $vtable], 0)
            : DB::val('SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = ?', [$vtable], 0);
        if (!$vexists) {
            if (DB::$driver === 'sqlite') {
                DB::run('CREATE TABLE IF NOT EXISTS ' . $vtable . ' (id INTEGER PRIMARY KEY AUTOINCREMENT, post_id INT DEFAULT 0, user_id INT DEFAULT 0, created_at VARCHAR(20) DEFAULT \'\', UNIQUE(post_id, user_id))');
            } else {
                DB::run('CREATE TABLE IF NOT EXISTS ' . $vtable . " (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, post_id INT DEFAULT 0, user_id INT DEFAULT 0, created_at VARCHAR(20) DEFAULT '', view_count INT DEFAULT 1, last_viewed_at VARCHAR(20) DEFAULT '', UNIQUE KEY uniq_post_user (post_id, user_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci");
            }
        }
    } catch (Exception $e) {
        // 忽略
    }

    // 群语音通话
    try {
        $callTables = [
            'chat_calls' => ['id INTEGER PRIMARY KEY AUTOINCREMENT', 'host_id INT DEFAULT 0', "status VARCHAR(16) DEFAULT 'active'", "created_at VARCHAR(20) DEFAULT ''", "ended_at VARCHAR(20) DEFAULT ''"],
            'chat_call_members' => ['id INTEGER PRIMARY KEY AUTOINCREMENT', 'call_id INT DEFAULT 0', 'user_id INT DEFAULT 0', "status VARCHAR(16) DEFAULT 'joined'", "joined_at VARCHAR(20) DEFAULT ''"],
            'chat_signals' => ['id INTEGER PRIMARY KEY AUTOINCREMENT', 'call_id INT DEFAULT 0', 'from_id INT DEFAULT 0', 'to_id INT DEFAULT 0', "kind VARCHAR(16) DEFAULT ''", 'payload TEXT', "created_at VARCHAR(20) DEFAULT ''"],
        ];
        foreach ($callTables as $tname => $defs) {
            $full = DB::table($tname);
            $exists = DB::$driver === 'sqlite'
                ? DB::val('SELECT COUNT(*) FROM sqlite_master WHERE type = ? AND name = ?', ['table', $full], 0)
                : DB::val('SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = ?', [$full], 0);
            if (!$exists) {
                if (DB::$driver === 'sqlite') {
                    $sql = 'CREATE TABLE IF NOT EXISTS ' . $full . ' (' . implode(', ', $defs) . ($tname === 'chat_call_members' ? ', UNIQUE(call_id, user_id)' : '') . ')';
                } else {
                    $sql = 'CREATE TABLE IF NOT EXISTS ' . $full . ' (' . implode(', ', $defs) . ($tname === 'chat_call_members' ? ', UNIQUE KEY uniq_call_user (call_id, user_id)' : '') . ') ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';
                }
                DB::run($sql);
            }
        }
    } catch (Exception $e) {
        // 忽略
    }

    // 积分转账
    try {
        $ttable = DB::table('transfers');
        $texists = DB::$driver === 'sqlite'
            ? DB::val('SELECT COUNT(*) FROM sqlite_master WHERE type = ? AND name = ?', ['table', $ttable], 0)
            : DB::val('SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = ?', [$ttable], 0);
        if (!$texists) {
            if (DB::$driver === 'sqlite') {
                DB::run('CREATE TABLE IF NOT EXISTS ' . $ttable . " (id INTEGER PRIMARY KEY AUTOINCREMENT, from_id INT DEFAULT 0, to_id INT DEFAULT 0, amount INT DEFAULT 0, note VARCHAR(120) DEFAULT '', created_at VARCHAR(20) DEFAULT '')");
            } else {
                DB::run('CREATE TABLE IF NOT EXISTS ' . $ttable . " (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, from_id INT DEFAULT 0, to_id INT DEFAULT 0, amount INT DEFAULT 0, note VARCHAR(120) DEFAULT '', created_at VARCHAR(20) DEFAULT '') ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci");
            }
        }
        foreach (['points_checkin' => '3', 'points_post' => '5', 'points_comment' => '2', 'points_post_limit' => '5', 'points_comment_limit' => '10', 'points_over_action' => 'none', 'points_post_penalty' => '1', 'points_comment_penalty' => '1', 'verify_cost' => '200', 'profile_change_limit' => '3'] as $k => $v) {
            if (trim((string) setting($k, '')) === '') { set_setting($k, $v); }
        }
        foreach (['level_1_name' => '初雪', 'level_2_name' => '霜华', 'level_3_name' => '白鹭', 'level_4_name' => '神里流', 'level_5_name' => '霜见'] as $k => $v) {
            if (trim((string) setting($k, '')) === '') { set_setting($k, $v); }
        }
    } catch (Exception $e) {
        // 忽略
    }

    // 帖子 IP 属地：缓存表 + 默认显示设置
    try {
        $itable = DB::table('ip_locations');
        $iexists = DB::$driver === 'sqlite'
            ? DB::val('SELECT COUNT(*) FROM sqlite_master WHERE type = ? AND name = ?', ['table', $itable], 0)
            : DB::val('SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = ?', [$itable], 0);
        if (!$iexists) {
            if (DB::$driver === 'sqlite') {
                DB::run('CREATE TABLE IF NOT EXISTS ' . $itable . " (ip VARCHAR(64) NOT NULL PRIMARY KEY, region VARCHAR(64) DEFAULT '', city VARCHAR(64) DEFAULT '', district VARCHAR(64) DEFAULT '', street VARCHAR(64) DEFAULT '', addr VARCHAR(255) DEFAULT '', updated_at VARCHAR(20) DEFAULT '')");
            } else {
                DB::run('CREATE TABLE IF NOT EXISTS ' . $itable . " (ip VARCHAR(64) NOT NULL PRIMARY KEY, region VARCHAR(64) DEFAULT '', city VARCHAR(64) DEFAULT '', district VARCHAR(64) DEFAULT '', street VARCHAR(64) DEFAULT '', addr VARCHAR(255) DEFAULT '', updated_at VARCHAR(20) DEFAULT '') ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci");
            }
        } else {
            try { DB::run('ALTER TABLE ' . $itable . " ADD COLUMN addr VARCHAR(255) DEFAULT ''"); } catch (Exception $e) {}
            try { DB::run('ALTER TABLE ' . $itable . " ADD COLUMN district VARCHAR(64) DEFAULT ''"); } catch (Exception $e) {}
            try { DB::run('ALTER TABLE ' . $itable . " ADD COLUMN street VARCHAR(64) DEFAULT ''"); } catch (Exception $e) {}
        }
        foreach (['post_show_location' => '1', 'post_show_ip' => '1', 'post_ip_mask' => '1', 'post_ip_head' => '4', 'post_ip_tail' => '2', 'post_ip_stars' => '4'] as $k => $v) {
            if (trim((string) setting($k, '')) === '') {
                set_setting($k, $v);
            }
        }
    } catch (Exception $e) {
        // 忽略
    }

    // 毒鸡汤扩展：建表 + 初始句子 + 切换间隔
    try {
        $qtable = DB::table('quotes');
        $exists = DB::$driver === 'sqlite'
            ? DB::val('SELECT COUNT(*) FROM sqlite_master WHERE type = ? AND name = ?', ['table', $qtable], 0)
            : DB::val('SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = ?', [$qtable], 0);
        if (!$exists) {
            if (DB::$driver === 'sqlite') {
                DB::run('CREATE TABLE IF NOT EXISTS ' . $qtable . " (id INTEGER PRIMARY KEY AUTOINCREMENT, content VARCHAR(255) NOT NULL, source VARCHAR(32) DEFAULT 'manual', status INT DEFAULT 1, created_at VARCHAR(20) DEFAULT '')");
            } else {
                DB::run('CREATE TABLE IF NOT EXISTS ' . $qtable . " (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, content VARCHAR(255) NOT NULL, source VARCHAR(32) DEFAULT 'manual', status INT DEFAULT 1, created_at VARCHAR(20) DEFAULT '') ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci");
            }
        }
        if (!(int) DB::val('SELECT COUNT(*) FROM ' . $qtable, [], 0)) {
            $lines = quote_default_lines();
            $old = trim((string) setting('daily_quote', ''));
            if ($old !== '') {
                array_unshift($lines, $old);
            }
            foreach ($lines as $line) {
                DB::insert('quotes', ['content' => $line, 'source' => 'default', 'status' => 1, 'created_at' => date('Y-m-d H:i:s')]);
            }
        }
        if (trim((string) setting('quote_interval', '')) === '') {
            set_setting('quote_interval', '10');
        }
        // 旧版默认 300 秒过长，首次升级时改为 10 秒，之后以用户设置为准
        if (trim((string) setting('quote_interval_sec', '')) === '') {
            if ((int) setting('quote_interval', 10) >= 300) {
                set_setting('quote_interval', '10');
            }
            set_setting('quote_interval_sec', '1');
        }
    } catch (Exception $e) {
        // 忽略：建表失败不阻塞站点
    }

    // v5.88：首次升级时把旧默认「霜雪浅色」迁移为「默认主题 · 白底黑字」；之后尊重后台选择
    try {
        if (setting('theme_default_v588', '') !== '1') {
            $legacyTheme = trim((string) setting('theme_mode', ''));
            if ($legacyTheme === '' || $legacyTheme === 'light') {
                set_setting('theme_mode', 'default');
            }
            set_setting('theme_default_v588', '1');
        }
    } catch (Exception $e) {
        // 忽略：主题迁移失败不阻塞站点
    }
    // v6.05：向已升级站点追加内置主题「青岚 · 竹影」（仅追加一次，不覆盖用户自定义主题）
    try {
        if (setting('theme_qinglan_v605', '') !== '1') {
            $themeRaw = setting('site_theme_items', '');
            if ($themeRaw !== '') {
                $themeItems = json_decode($themeRaw, true);
                if (is_array($themeItems)) {
                    $hasQinglan = false;
                    foreach ($themeItems as $themeItem) {
                        if (is_array($themeItem) && (string) ($themeItem['key'] ?? '') === 'qinglan') { $hasQinglan = true; break; }
                    }
                    if (!$hasQinglan) {
                        $themeItems[] = ['key' => 'qinglan', 'name' => '青岚 · 竹影', 'fixed' => 0, 'builtin' => 1, 'css' => '', 'sort' => 130];
                        site_theme_save($themeItems);
                    }
                }
            }
            set_setting('theme_qinglan_v605', '1');
        }
    } catch (Exception $e) {
        // 忽略：主题迁移失败不阻塞站点
        // 忽略：主题迁移失败不阻塞站点
    }
    // v6.25.1：官方固定账号 101（唯一官方通知发送者；用户名不可改、不可删除、不可代登录）
    try {
        if (setting('km_official_account_v6251', '') !== '1') {
            $official = DB::one('SELECT * FROM ' . DB::table('users') . ' WHERE is_official = 1 LIMIT 1');
            if (!$official) {
                $existing = DB::one('SELECT * FROM ' . DB::table('users') . " WHERE username IN ('101','01') LIMIT 1");
                if ($existing) {
                    DB::update('users', [
                        'is_official' => 1,
                        'can_rename_username' => 0,
                        'username_free_limit' => 0,
                        'username_unlimited' => 0,
                        'verify_status' => 2,
                        'verified' => 1,
                        'verify_type' => 'official',
                        'verify_style' => 'gold',
                        'verify_title' => '官方账号',
                        'verify_info' => '木漏茶室官方通知账号',
                    ], 'id = ?', [(int) $existing['id']]);
                } else {
                    DB::insert('users', [
                        'username' => '101',
                        'password' => password_hash(bin2hex(random_bytes(16)), PASSWORD_DEFAULT),
                        'nickname' => '官方通知',
                        'avatar' => '',
                        'gender' => 'secret',
                        'email' => '',
                        'role' => 'user',
                        'status' => 1,
                        'points' => 0,
                        'streak' => 0,
                        'is_official' => 1,
                        'account_setup' => 0,
                        'can_rename_username' => 0,
                        'username_free_limit' => 0,
                        'username_unlimited' => 0,
                        'verified' => 1,
                        'verify_status' => 2,
                        'verify_type' => 'official',
                        'verify_style' => 'gold',
                        'verify_title' => '官方账号',
                        'verify_info' => '木漏茶室官方通知账号',
                        'created_at' => now(),
                    ]);
                }
            }
            set_setting('km_official_account_v6251', '1');
        }
    } catch (Exception $e) {
        // 忽略：官方账号创建失败不阻塞站点
    }

    // v6.25.28：官方固定账号用户名由 01 迁移为 101（仅一次，只改官方账号）
    try {
        if (setting('km_official_username_101', '') !== '1') {
            $official = DB::one('SELECT * FROM ' . DB::table('users') . ' WHERE is_official = 1 ORDER BY id ASC LIMIT 1');
            if ($official && (string) $official['username'] === '01') {
                $conflict = DB::one('SELECT id FROM ' . DB::table('users') . ' WHERE username = ? AND id <> ? LIMIT 1', ['101', (int) $official['id']]);
                if (!$conflict) {
                    DB::update('users', ['username' => '101'], 'id = ?', [(int) $official['id']]);
                }
            }
            set_setting('km_official_username_101', '1');
        }
    } catch (Exception $e) {
        // 忽略：官方账号改名失败不阻塞站点
    }

    // v6.25.98：彻底删除官方固定账号与官方通知，保留一份账号数据备份
    try {
        if (setting('km_official_removed_v62598', '') !== '1') {
            $official = DB::one('SELECT * FROM ' . DB::table('users') . " WHERE is_official = 1 OR username IN ('101','01') ORDER BY is_official DESC, id ASC LIMIT 1");
            if ($official) {
                $oid = (int) $official['id'];
                set_setting('km_official_removed_backup_v62598', json_encode($official, JSON_UNESCAPED_UNICODE));
                DB::delete('announcements', 'author_id = ?', [$oid]);
                DB::delete('notifications', 'from_id = ?', [$oid]);
                DB::delete('messages', 'from_id = ? OR to_id = ?', [$oid, $oid]);
                DB::delete('friends', 'user_id = ? OR friend_id = ?', [$oid, $oid]);
                DB::delete('comments', 'user_id = ?', [$oid]);
                $postIds = DB::all('SELECT id FROM ' . DB::table('posts') . ' WHERE user_id = ?', [$oid]);
                if ($postIds) {
                    $ids = array_map('intval', array_column($postIds, 'id'));
                    foreach ($ids as $pid) { DB::delete('comments', 'post_id = ?', [$pid]); }
                    DB::delete('posts', 'user_id = ?', [$oid]);
                }
                DB::delete('users', 'id = ?', [$oid]);
            }
            set_setting('km_official_account_v6251', '1');
            set_setting('km_official_removed_v62598', '1');
        }
    } catch (Throwable $e) {
        // 忽略：官方账号清理失败不阻塞站点
    }

    // v6.23：向已升级站点追加「白纱 / 红纱」婚礼主题（仅追加一次，不覆盖用户主题与排序）
    try {
        if (setting('theme_wedding_v623', '') !== '1') {
            $themeRaw = setting('site_theme_items', '');
            if ($themeRaw !== '') {
                $themeItems = json_decode($themeRaw, true);
                if (is_array($themeItems)) {
                    $existing = [];
                    foreach ($themeItems as $themeItem) {
                        if (is_array($themeItem)) { $existing[(string) ($themeItem['key'] ?? '')] = true; }
                    }
                    $weddingDefaults = [];
                    foreach (site_theme_defaults() as $themeDefault) {
                        if (in_array($themeDefault['key'], ['wedding_white', 'wedding_red'], true)) {
                            $weddingDefaults[$themeDefault['key']] = $themeDefault;
                        }
                    }
                    foreach (['wedding_white', 'wedding_red'] as $weddingKey) {
                        if (!isset($existing[$weddingKey]) && isset($weddingDefaults[$weddingKey])) {
                            $themeItems[] = $weddingDefaults[$weddingKey];
                        }
                    }
                    site_theme_save($themeItems);
                }
            }
            set_setting('theme_wedding_v623', '1');
        }
    } catch (Exception $e) {
        // 忽略：主题迁移失败不阻塞站点
    }
}

DB::init($CONFIG);
km_migrate();
// v6.25.229：mlcs.xnn.lol 的旧源码站已失联，自动切到本站可用的升级源，避免后台继续报“升级源不可用”。
try {
    $kmFeedHost = strtolower((string) ($_SERVER['HTTP_HOST'] ?? ''));
    $kmFeedHost = preg_replace('/:\d+$/', '', $kmFeedHost);
    $kmFeedHost = preg_replace('/^www\./', '', $kmFeedHost);
    if ($kmFeedHost === 'mlcs.xnn.lol' && setting('km_feed_self_v625229', '0') !== '1') {
        set_setting('upgrade_auto_feed_url', 'http://mlcs.xnn.lol/index.php?page=source&act=upgrade_meta');
        set_setting('upgrade_feed_url', '');
        set_setting('km_feed_self_v625229', '1');
        $kmFeedCache = APP_ROOT . '/storage/cache/upgrade_feed.json';
        if (is_file($kmFeedCache)) { @unlink($kmFeedCache); }
    }
} catch (Throwable $e) {
    // 升级源切换失败不阻塞站点
}
// v6.25.86：按用户要求移除旧的全站背景图；原值先备份，避免误删后无法找回。
try {
    if (setting('km_site_bg_removed_v62586', '0') !== '1') {
        $oldBg = trim((string) setting('site_bg_image', ''));
        if ($oldBg !== '') {
            set_setting('site_bg_image_backup_v62586', $oldBg);
            set_setting('site_bg_image', '');
        }
        set_setting('km_site_bg_removed_v62586', '1');
    }
} catch (Throwable $e) {
    // 背景清理失败不阻塞站点
}
if (function_exists('security_patch_maybe_auto')) { security_patch_maybe_auto(); }
// v6.25.22：标记部署页创建的管理员，并永久锁定其超级管理员身份。
try {
    if (setting('km_installer_admin_v6252', '') !== '1') {
        $installer = DB::one('SELECT id FROM ' . DB::table('users') . " WHERE role = 'superadmin' ORDER BY id ASC LIMIT 1");
        if ($installer) {
            DB::run('UPDATE ' . DB::table('users') . ' SET is_installer_admin = 1 WHERE id = ?', [(int) $installer['id']]);
        }
        set_setting('km_installer_admin_v6252', '1');
    }
} catch (Throwable $e) {
    // 忽略：标记失败不阻塞站点
}
// v6.25.150：全站只保留部署站长一个超级管理员，历史多余的超管降为管理员。
try {
    if (setting('km_single_superadmin_v625150', '') !== '1') {
        $ownerId = (int) DB::val('SELECT id FROM ' . DB::table('users') . " WHERE role = 'superadmin' AND is_installer_admin = 1 ORDER BY id ASC LIMIT 1", [], 0);
        if ($ownerId <= 0) {
            $ownerId = (int) DB::val('SELECT id FROM ' . DB::table('users') . " WHERE role = 'superadmin' ORDER BY id ASC LIMIT 1", [], 0);
        }
        if ($ownerId > 0) {
            DB::run('UPDATE ' . DB::table('users') . " SET role = 'admin' WHERE role = 'superadmin' AND id <> ?", [$ownerId]);
            audit_log('superadmin_single_owner', '保留 UID ' . $ownerId . '，其余超级管理员降为管理员');
        }
        set_setting('km_single_superadmin_v625150', '1');
    }
} catch (Throwable $e) {
    // 忽略：单超管治理失败不阻塞站点
}
if (empty($_SESSION['uid']) && function_exists('auth_token_try')) {
    // PHP 会话 Cookie 被清理时，用长期令牌恢复登录（主要照顾 iPhone Safari / PWA）。
    auth_token_try();
}
db_health_check();

// 源码部署统计：站外站点安装/升级后回传，下载中心验证并展示。
require_once __DIR__ . '/source_deploy.php';
if (basename((string) ($_SERVER['SCRIPT_NAME'] ?? '')) !== 'api.php') {
    source_deploy_bootstrap();
}

// 三端切换：带 view 参数访问时尽早写入 Cookie，保证后续页面沿用。
if (isset($_GET['device'])) {
    device_view_mode();
}

require_once __DIR__ . '/blackroom.php';
require_once __DIR__ . '/plugins.php';
plugins_boot();
realtime_guard_boot();
if (function_exists('post_publish_due')) { post_publish_due(); }
// 访问统计在 index.php 解析出当前页面后调用，避免后台请求被计入 PV
