public function save(\App\User\User $user) { if (!$this->fetchByUsername($user->getUsername())) { $this->_connection->query("INSERT INTO `" . $this->_table . "` (`username`, `password`, `options`) VALUES (\n '" . $this->_connection->real_escape_string($user->getUsername()) . "',\n '" . $this->_connection->real_escape_string($user->getPassword()) . "',\n '" . $this->_connection->real_escape_string(json_encode($user->getOptions())) . "'\n )"); } else { $this->_connection->query("UPDATE `" . $this->_table . "` SET\n `password` = '" . $this->_connection->real_escape_string($user->getPassword()) . "',\n `options` = '" . $this->_connection->real_escape_string(json_encode($user->getOptions())) . "'\n WHERE id = " . $user->getId()); } return $this; }
protected function _deleteUserOptions(\App\User\User $user) { $dir = DOCUMENT_ROOT . DS . "var" . DS . "configs"; $filename = $dir . DS . "user_" . $user->getUsername() . ".json"; if (is_file($filename)) { unlink($filename); } return $this; }