sgsabbage: (0)
sgsabbage ([personal profile] sgsabbage) wrote in [site community profile] dw_wiki 2016-02-22 11:45 am (UTC)

Yup! For anyone who needs to do so, it can be done directly in the DB with:

UPDATE user SET status='A' WHERE userid=[user's id]

Or just ignore the WHERE statement and authenticate all of your users at once.

The valid statuses that I've been able to find are:
N - Not authenticated (default)
T - Transitioning (i.e. the user has previously been authenticated but has changed their email address and so needs to re-authenticate)
A - Authenticated

It'd probably be useful to put this in the wiki somewhere, maybe http://wiki.dreamwidth.net/wiki/index.php/Database_Table:_user, but I am unsure of the format, or if this is the appropriate place?

Post a comment in response:

This account has disabled anonymous posting.
If you don't have an account you can create one now.
HTML doesn't work in the subject.
More info about formatting