Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
We have some pretty heavy integration, and something I'd like to do is to be able to disable a member via SQL.
We can maintain they're record via sql, but I cant see anything immediately obvious in regards to disabling their account.
I'd like to avoid deleting the account if possible.
Something like this:
;WITH DataProp as (SELECT pd.*
FROM cmsPropertyData as pd
JOIN cmsPropertyType as pt ON pt.Id = pd.propertytypeid AND pt.Alias = 'umbracoMemberApproved'
WHERE contentNodeId = ( SELECT Id
WHERE text LIKE '%your member name%' ))
UPDATE DataProp SET dataInt = 0
The part dataInt = 0 sets the property Is Approved to false, if you want to approve the member, set this to 1.
dataInt = 0
I now do a search on text for getting the right Member, you should be able to change this and pass the id of the member if you have this at your end:
WHERE Id = YourId
Hope this helps!
You absoultey beautiful person.
No problem, glad it solved your problem!
Have a nice day.
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted