Add badge for adding profile picture

[Steradiant (Maarten)]

It would be a very nice incentive for people to add a profile picture if they would be granted a first-steps-badge when they do it the first time.

[Moin]

Adding a profile picture is part of the Autobiographer badge:
https://meta.discourse.org/badges/9/autobiographer

[patrickemin]

Hi, I am not sure this works, I have 159 users who do not use the default avatar (from data explorer) and 16 only that got the Autobiographer badge. Shoul’dnt they be 159 with the badge ?

[Moin]

I said having an avatar is part of the badge.

How many of the 159 users added information about them in the “about me” field in their profile?

[patrickemin]

Got it, avatar and profile data are two different things, but that means that badge does not answer the initial query ?

[Moin]

Firstly, it was a hint that there is already a badge that can be triggered when uploading an avatar. So if you want to add your own SQL-triggered badge, you might want to disable it so that the user doesn’t receive two at once. Secondly, you can use the query for the badge as an example to create a badge just for saving the avatar.

@JammyDodger

Autobiographer

SELECT u.id user_id, CURRENT_TIMESTAMP granted_at
    FROM users u
    JOIN user_profiles up on u.id = up.user_id
    WHERE bio_raw IS NOT NULL AND LENGTH(TRIM(bio_raw)) > 10 AND
          uploaded_avatar_id IS NOT NULL AND
          (:backfill OR u.id IN (:user_ids) )

Run revocation query daily
Query targets posts
Trigger	When a user is edited or created

[patrickemin]

Very interesting source for querying, thanks !