Great, thanks Watcha!
It'll remove the old ones too that's been deleted before or those need to be removed manually?
Ok i have a solution now, as it turns out you can't delete it in one place an then in the other, it will never work.
However i uploaded a new build 5608...
https://github.com/YAFNET/YAFNET-DNN/releases/tag/v2.1.2-5608 - soft deleting of user will unapprove them in yaf, and if you restore the account the user gets approved again
- hard deleting of a user in dnn will automatically delete the user in yaf
- deleting user from yaf is disabled always use dnn to delete a user.
Ok and to remove the remaining users from yaf which you have already deleted in yaf you have to run the following sql manually for each user
DECLARE @YafUserID int
SELECT @YafUserID = UserID FROM [{databaseOwner}].[{objectQualifier}User] WHERE Name = 'ENTERUSERNAMEHERE'
EXEC [{databaseOwner}].[{objectQualifier}user_delete] @YafUserID
Replace "ENTERUSERNAMEHERE" with the actually username you wish to delete
Edited by moderator
8 years ago
|
Reason: Not specified