SOURCE DOWNLOAD

木漏茶室源码下载中心

整站 PHP 源码:可浏览文件、复制路径、下载单文件或打包 ZIP。

发布版本 v6.25.232 升级后自动生成独立源码包,下载中心只发送这份冻结包 已排除 config.php / 用户数据 / 上传文件 / 升级备份
komorebi-forum 183 个节点 · PHP 8.3.37 · 完整源码 ZIP 1.31 MB
下载完整源码 ZIP 源码包大小:1.31 MB 安装教程 作者主页 免费开源 免费下载 ↓
COMMUNITY DEPLOYMENTS

已经跑起来的木漏茶室

从源码下载中心下载、完成安装并回传验证的站外站点。每个站点只计 1 次部署下载量;已记录站点会实时读取名称、版本、Logo 与在线状态,本机、内网和证书异常站点无法完成回传。

实时检测
2 个站点已部署

已展示全部 2 个站点。

inc/db.php 3.6 KB · 发布包 v6.25.232
下载
<?php
/**
 * 轻量 PDO 封装(MySQL / SQLite 双驱动)
 */
class DB
{
    /** @var PDO */
    public static $pdo;
    public static $driver = 'mysql';
    public static $prefix = '';

    public static function init(array $config)
    {
        self::$driver = $config['driver'] === 'sqlite' ? 'sqlite' : 'mysql';
        self::$prefix = $config['prefix'] ?? '';

        try {
            if (self::$driver === 'sqlite') {
                $path = $config['sqlite_path'] ?? (APP_ROOT . '/data/komorebi.sqlite');
                $dir = dirname($path);
                if (!is_dir($dir)) {
                    @mkdir($dir, 0775, true);
                }
                self::$pdo = new PDO('sqlite:' . $path);
                self::$pdo->exec('PRAGMA journal_mode = WAL');
                self::$pdo->exec('PRAGMA busy_timeout = 5000');
            } else {
                $db = $config['db'];
                $dsn = 'mysql:host=' . $db['host'] . ';port=' . (int) $db['port'] . ';dbname=' . $db['database'] . ';charset=utf8mb4';
                self::$pdo = new PDO($dsn, $db['username'], $db['password']);
            }
            self::$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            self::$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
            self::$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
        } catch (PDOException $e) {
            app_fatal_page('数据加载失败', '数据库连接失败:' . $e->getMessage());
        }
    }

    public static function table($name)
    {
        return self::$prefix . $name;
    }

    public static function run($sql, array $params = [])
    {
        $stmt = self::$pdo->prepare($sql);
        $stmt->execute($params);
        return $stmt;
    }

    public static function all($sql, array $params = [])
    {
        return self::run($sql, $params)->fetchAll();
    }

    public static function one($sql, array $params = [])
    {
        $row = self::run($sql, $params)->fetch();
        return $row === false ? null : $row;
    }

    public static function val($sql, array $params = [], $default = null)
    {
        $v = self::run($sql, $params)->fetchColumn();
        return $v === false ? $default : $v;
    }

    public static function insert($table, array $data)
    {
        $cols = array_keys($data);
        $sql = 'INSERT INTO ' . self::table($table) . ' (' . implode(',', $cols) . ') VALUES ('
            . implode(',', array_fill(0, count($cols), '?')) . ')';
        self::run($sql, array_values($data));
        return (int) self::$pdo->lastInsertId();
    }

    public static function update($table, array $data, $where, array $whereParams = [])
    {
        $sets = [];
        foreach (array_keys($data) as $c) {
            $sets[] = $c . ' = ?';
        }
        $sql = 'UPDATE ' . self::table($table) . ' SET ' . implode(', ', $sets) . ' WHERE ' . $where;
        self::run($sql, array_merge(array_values($data), array_values($whereParams)));
    }

    public static function delete($table, $where, array $params = [])
    {
        self::run('DELETE FROM ' . self::table($table) . ' WHERE ' . $where, $params);
    }

    public static function count($table, $where = '1', array $params = [])
    {
        return (int) self::val('SELECT COUNT(*) FROM ' . self::table($table) . ' WHERE ' . $where, $params, 0);
    }
}

function db_health_check()
{
    try {
        DB::val('SELECT COUNT(*) FROM ' . DB::table('settings'));
    } catch (Exception $e) {
        app_fatal_page('数据加载失败', '数据表读取异常,请确认已安装并完成 install.php:' . $e->getMessage());
    }
}
主题