| <?php |
| |
|
|
| class Settings { |
| private $db = null; |
| private $defaultSettings = [ |
| 'site_name' => 'MoeNote', |
| 'site_description' => 'A simple online note that focuses on safe sharing.', |
| 'data_directory' => '/var/www/html/data/', |
| 'db_path' => '/var/www/html/data/notes.db', |
| 'favicon_path' => '/favicon.png', |
| 'max_expire_time' => 31536000, |
| ]; |
| |
| public function __construct() { |
| $this->initializeDatabase(); |
| } |
| |
| private function initializeDatabase() { |
| |
| $dataDir = dirname($this->defaultSettings['db_path']); |
| if (!file_exists($dataDir)) { |
| if (!mkdir($dataDir, 0777, true)) { |
| throw new Exception('无法创建数据目录，请检查权限'); |
| } |
| |
| |
| $htaccess = $dataDir . '/.htaccess'; |
| if (!file_exists($htaccess)) { |
| $htaccess_content = "Require all denied\n"; |
| $htaccess_content .= "Options -Indexes\n"; |
| file_put_contents($htaccess, $htaccess_content); |
| } |
| |
| |
| $index_html = $dataDir . '/index.html'; |
| if (!file_exists($index_html)) { |
| file_put_contents($index_html, '<!DOCTYPE html><html><head><title>403 Forbidden</title></head><body><h1>403 Forbidden</h1></body></html>'); |
| } |
| } |
| |
| |
| $this->db = new SQLite3($this->defaultSettings['db_path']); |
| |
| |
| $this->db->exec(' |
| CREATE TABLE IF NOT EXISTS settings ( |
| key TEXT PRIMARY KEY, |
| value TEXT |
| ) |
| '); |
| |
| $this->db->exec(' |
| CREATE TABLE IF NOT EXISTS notes ( |
| uuid TEXT PRIMARY KEY, |
| content TEXT, |
| created_at INTEGER, |
| expires_at INTEGER, |
| max_views INTEGER DEFAULT 0, |
| current_views INTEGER DEFAULT 0, |
| is_markdown INTEGER DEFAULT 0, |
| is_encrypted INTEGER DEFAULT 0 |
| ) |
| '); |
| |
| |
| $this->db->exec(' |
| CREATE TABLE IF NOT EXISTS files ( |
| code TEXT PRIMARY KEY, -- 提取码 |
| filename TEXT, -- 原始文件名 |
| filepath TEXT, -- 存储路径 |
| content TEXT, -- 文本内容（如果是文本类型） |
| type TEXT, -- 类型：file 或 text |
| created_at INTEGER, -- 创建时间 |
| expires_at INTEGER, -- 过期时间 |
| max_downloads INTEGER DEFAULT 0, -- 最大下载/查看次数 |
| current_downloads INTEGER DEFAULT 0 -- 当前下载/查看次数 |
| ) |
| '); |
| |
| |
| foreach ($this->defaultSettings as $key => $value) { |
| $stmt = $this->db->prepare('INSERT OR IGNORE INTO settings (key, value) VALUES (:key, :value)'); |
| $stmt->bindValue(':key', $key, SQLITE3_TEXT); |
| $stmt->bindValue(':value', $value, SQLITE3_TEXT); |
| $stmt->execute(); |
| } |
| } |
| |
| public function getSetting($key, $default = null) { |
| try { |
| $stmt = $this->db->prepare('SELECT value FROM settings WHERE key = :key'); |
| $stmt->bindValue(':key', $key, SQLITE3_TEXT); |
| $result = $stmt->execute(); |
| |
| if ($row = $result->fetchArray(SQLITE3_ASSOC)) { |
| return $row['value']; |
| } |
| } catch (Exception $e) { |
| |
| } |
| |
| return isset($this->defaultSettings[$key]) ? $this->defaultSettings[$key] : $default; |
| } |
| |
| public function setSetting($key, $value) { |
| $stmt = $this->db->prepare('INSERT OR REPLACE INTO settings (key, value) VALUES (:key, :value)'); |
| $stmt->bindValue(':key', $key, SQLITE3_TEXT); |
| $stmt->bindValue(':value', $value, SQLITE3_TEXT); |
| return $stmt->execute(); |
| } |
| |
| public function getDefaultSettings() { |
| return $this->defaultSettings; |
| } |
| } |
|
|
