OmarElGabry / miniPHP

     * @param  string   $email

     * @throws Exception If couldn't reset failed logins

     */

    private function resetFailedLogins($email){

        $database = Database::openConnection();

        $query = "UPDATE failed_logins SET last_failed_login = NULL, " .

                 "failed_login_attempts = 0 WHERE user_email = :user_email";

        $database->prepare($query);

        $database->bindValue(':user_email', $email);

        $result = $database->execute();

        if(!$result){

            throw new Exception("Couldn't reset failed logins for User Email " . $email);

        }

    }

    /**

     * What if user forgot his password?

     * @param  integer   $userId

     * @throws Exception  If couldn't reset password token

     */

    private function resetPasswordToken($userId){

        $database = Database::openConnection();

        $query = "UPDATE forgotten_passwords SET password_token = NULL, " .

                 "password_last_reset = NULL, forgotten_password_attempts = 0 ".

                 "WHERE user_id = :user_id LIMIT 1";

        $database->prepare($query);

        $database->bindValue(':user_id', $userId);

        $result = $database->execute();

        if(!$result){

            throw new Exception("Couldn't reset password token");

        }

    }

    /**

     * It checks if the token for email verification is valid or not.

     * @param boolean $isValid

     * @throws Exception If couldn't reset email verification token

     */

    public function resetEmailVerificationToken($userId, $isValid){

        $database = Database::openConnection();

        if($isValid){

            $query = "UPDATE users SET email_token = NULL, " .

                "email_last_verification = NULL, is_email_activated = 1 ".

                "WHERE id = :id LIMIT 1";

        }else{

            $query = "DELETE FROM users WHERE id = :id";

        }

        $database->prepare($query);

        $database->bindValue(':id', $userId);

        $result = $database->execute();

        if(!$result){

            throw new Exception("Couldn't reset email verification token");

        }

    }

    /**

     * Logout by removing the Session and Cookies.