me_and: (Default)
[personal profile] me_and posting in [site community profile] dw_wiki

In case you ever want to do anything relating to the Make a suggestion page on a Dreamhack, I've recently gone through the process and written it up.

There are a few bits that are decidedly more hacky than I'd like, so it's definitely a thing that would benefit from others looking it over and making improvements, but it'll hopefully save other folk needing to go Perl diving for the details.

(no subject)

Date: 2016-02-21 05:25 pm (UTC)
denise: Image: Me, facing away from camera, on top of the Castel Sant'Angelo in Rome (Default)
From: [staff profile] denise
Quick as I run out the door

* It's the dw-suggestions comm that has to be paid, not the user posting the suggestion! (Trufax: the reason free users can post polls in paid comms is to make this work.)

* There's no way to mark an account's email address as validated from the console -- you do have to run the worker to send out the email. (Or, I think there's a way to query the db for the validation link and just visit that link directly, but I'm not sure how to do it.)

(no subject)

Date: 2016-02-22 10:02 am (UTC)
kaberett: Overlaid Mars & Venus symbols, with Swiss Army knife tools at other positions around the central circle. (Default)
From: [personal profile] kaberett
... [personal profile] azurelunatic got to it before I did, which led to me being very briefly very confused about why it was already correct.

(no subject)

Date: 2016-02-22 11:45 am (UTC)
sgsabbage: (Default)
From: [personal profile] sgsabbage
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?
Edited Date: 2016-02-22 11:45 am (UTC)

Profile

dw_wiki: Going to the wiki! (Default)
Dreamwidth Wiki Management

November 2016

S M T W T F S
  12345
6789101112
13141516171819
2021222324 2526
27282930   

Most Popular Tags

Page Summary

Style Credit

Expand Cut Tags

No cut tags