private function regUser() { $sql = "INSERT INTO users (firstname, lastname, email, pass, reg_date)\n VALUES ('{$this->firstname}', '{$this->lastname}', '{$this->email}', '{$this->password}', '{$this->dateTime}');"; $query = $this->_db_connect->query($sql); if ($query === false) { parent::regError(); $this->showMessage("No se ha podido registrar el usuario, vuelva a intentarlo más tarde."); $this->closeConnect(); return false; } $this->closeConnect(); return true; }
private function check() { $sql = "SELECT u.id, u.firstname, u.lastname, u.email, u.password, u.profile_img FROM users u WHERE email = '" . $this->email . "'"; $query = $this->_db_connect->query($sql); if (!$query) { parent::regError(); $this->showMessage($this->getTextLang("generic_error")); $this->closeConnect(); return false; } elseif ($query->num_rows == 0) { $this->showMessage($this->getTextLang("log_user_not_exist")); $this->closeConnect(); return false; } else { if ($row = $query->fetch_assoc()) { if (password_verify($this->pass, $row['password'])) { $_SESSION['user'] = array(); $_SESSION['user']['id'] = $row['id']; $_SESSION['user']['name'] = $row['firstname']; $_SESSION['user']['lastname'] = $row['lastname']; $_SESSION['user']['img'] = $row['profile_img']; $_SESSION['user']['email'] = $row['email']; } else { $this->showMessage("La contraseña no es válida"); $this->closeConnect(); return false; } } else { parent::regError(); $this->showMessage($this->getTextLang("generic_error")); $this->closeConnect(); return false; } } $this->closeConnect(); return true; }
/** * @return bool * * Actualiza los campos relacionados con los datos. * Comprueba que el email nueva cumpla con los requisitos establecidos. * */ private function update() { if (!preg_match("/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,3})\$/", $this->email)) { $this->emailFail = "Campo de 'Email' no cumple con los estandars."; return false; } // Establece la conexión a la BD. parent::connect(); $this->_sql = "UPDATE users SET nombre = '" . $this->nombre . "', email = '" . $this->email . "', firma = '" . $this->firma . "', avatar = '" . $this->avatar . "' WHERE id = " . $_SESSION['user']['id'] . ";"; $query = parent::$_db_connect->query($this->_sql); if ($query === false) { parent::regError(); parent::showMessage("No se ha podido actualizar los datos."); return false; } return true; }