All users from my websites had been permanently deleted, these users had a re-occuring payment via paypal. Each Payment would send a notification to the website, extending a expiry date for the subscription role on that user. The Unique identifier is the "UserID".
Once a user is deleted the UserID is gone. I can create a user via SQL scipt below - I then update DBO.profile, DBO.userprofile, DBO.Userportal,DBO.Userroles. - which shows the profile in DNN. But when I try to login to a user - i'm having password Issues. Any help is much appricated!!!!
SET IDENTITY_INSERT dbo.Users ON
INSERT INTO dbo.Users (UserID, Username, FirstName, LastName, IsSuperUser, AffiliateId, Email, DisplayName, UpdatePassword, LastIPAddress, IsDeleted, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate, PasswordResetToken, PasswordResetExpiration)
VALUES ( 01, '[email protected]', 'name', 'name', 0, NULL, '[email protected]', 'Name', 0, NULL, 0, 1, NULL, 1, NULL, NULL, NULL);Go
SET IDENTITY_INSERT dbo.Users OFF
How do I set a password or send a password reset link for a user created via SQL? Is there another table i am missing?