/** * Open a new session * * @param string $savePath Not used * @param string $name The session name (defaulty 'PHPSESSID') */ public function open($savePath, $name) { $this->db = App::db(); $this->table = DB::getFullTablename('Session'); // Update the session mtime if (App::request()->getCookies($name)) { SessionModel::getDbInstance()->update(SessionModel::getTable(), new DBExample(array('id' => App::request()->getCookies($name))), array('mtime' => time())); } // Clean expired sessions $this->gc(0); }
/** * V0.7.0 : Add the table UserOption */ public function v0_7_0() { App::db()->query('CREATE TABLE IF NOT EXISTS `' . DB::getFullTablename('UserOption') . '`( `userId` INT(11) NOT NULL DEFAULT 0, `userIp` VARCHAR(15) NOT NULL DEFAULT "", `plugin` VARCHAR(32) NOT NULL, `key` VARCHAR(64) NOT NULL, `value` VARCHAR(4096), UNIQUE INDEX(`userId`, `plugin`, `key`), UNIQUE INDEX(`userIp`, `plugin`, `key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;'); }