| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768 |
- <?php
- class FreshRSS_UserDAO extends Minz_ModelPdo {
- public function createUser($insertDefaultFeeds = false) {
- require_once(APP_PATH . '/SQL/install.sql.' . $this->pdo->dbType() . '.php');
- try {
- $sql = SQL_CREATE_TABLES . SQL_CREATE_TABLE_ENTRYTMP . SQL_CREATE_TABLE_TAGS;
- $ok = $this->pdo->exec($sql) !== false; //Note: Only exec() can take multiple statements safely.
- if ($ok && $insertDefaultFeeds) {
- $default_feeds = FreshRSS_Context::$system_conf->default_feeds;
- $stm = $this->pdo->prepare(SQL_INSERT_FEED);
- foreach ($default_feeds as $feed) {
- $parameters = [
- ':url' => $feed['url'],
- ':name' => $feed['name'],
- ':website' => $feed['website'],
- ':description' => $feed['description'],
- ];
- $ok &= ($stm && $stm->execute($parameters));
- }
- }
- } catch (Exception $e) {
- Minz_Log::error('Error while creating database for user: ' . $e->getMessage());
- }
- if ($ok) {
- return true;
- } else {
- $info = empty($stm) ? $this->pdo->errorInfo() : $stm->errorInfo();
- Minz_Log::error(__METHOD__ . ' error: ' . $info[2]);
- return false;
- }
- }
- public function deleteUser() {
- if (defined('STDERR')) {
- fwrite(STDERR, 'Deleting SQL data for user “' . $this->current_user . "”…\n");
- }
- require_once(APP_PATH . '/SQL/install.sql.' . $this->pdo->dbType() . '.php');
- $ok = $this->pdo->exec(SQL_DROP_TABLES) !== false;
- if ($ok) {
- return true;
- } else {
- $info = $stm == null ? $this->pdo->errorInfo() : $stm->errorInfo();
- Minz_Log::error(__METHOD__ . ' error: ' . $info[2]);
- return false;
- }
- }
- public static function exists($username) {
- return is_dir(USERS_PATH . '/' . $username);
- }
- public static function touch($username = '') {
- if (!FreshRSS_user_Controller::checkUsername($username)) {
- $username = Minz_Session::param('currentUser', '_');
- }
- return touch(USERS_PATH . '/' . $username . '/config.php');
- }
- public static function mtime($username) {
- return @filemtime(USERS_PATH . '/' . $username . '/config.php');
- }
- }
|