public function update() { DB::query("\r\n UPDATE users\r\n INNER JOIN roles\r\n ON roles.id = users.role_id\r\n SET users.username='******', " . (!empty($this->password) ? "password='******', " : "") . "users.avatar='" . DB::esc($this->avatar) . "',\r\n users.role_id=roles.id" . "WHERE users.id=" . DB::esc($this->id) . (empty($this->role) ? "AND roles.id=" . DS::esc($this . role_id) : "AND roles.name='" . DS::esc($this . role_id) . "'")); }