RegistrationModel::verifyNewUser PHP Method

verifyNewUser() public static method

checks the email/verification code combination and set the user's activation status to true in the database
public static verifyNewUser ( integer $user_id, string $user_activation_verification_code ) : boolean
$user_id integer user id
$user_activation_verification_code string verification token
return boolean success status
    public static function verifyNewUser($user_id, $user_activation_verification_code)
    {
        $database = DatabaseFactory::getFactory()->getConnection();
        $sql = "UPDATE users SET user_active = 1, user_activation_hash = NULL\n                WHERE user_id = :user_id AND user_activation_hash = :user_activation_hash LIMIT 1";
        $query = $database->prepare($sql);
        $query->execute(array(':user_id' => $user_id, ':user_activation_hash' => $user_activation_verification_code));
        if ($query->rowCount() == 1) {
            Session::add('feedback_positive', Text::get('FEEDBACK_ACCOUNT_ACTIVATION_SUCCESSFUL'));
            return true;
        }
        Session::add('feedback_negative', Text::get('FEEDBACK_ACCOUNT_ACTIVATION_FAILED'));
        return false;
    }

Usage Example

Exemplo n.º 1
0
 /**
  * Verify user after activation mail link opened
  * @param int $user_id user's id
  * @param string $user_activation_verification_code user's verification token
  */
 public function verify($user_id, $user_activation_verification_code)
 {
     if (isset($user_id) && isset($user_activation_verification_code)) {
         RegistrationModel::verifyNewUser($user_id, $user_activation_verification_code);
         $this->View->render('register/verify');
     } else {
         Redirect::to('login/index');
     }
 }
All Usage Examples Of RegistrationModel::verifyNewUser