#108 Migrate askfedora Badged to discourse
Closed: Invalid 2 years ago by ankursinha. Opened 2 years ago by hhlp.

The goals is migrate the current fedora Badged from askfedora to discurse... (open news, view default badged in discourse, define equivalent, hot to set it , etc...)


Metadata Update from @hhlp:
- Issue marked as depending on: #91

2 years ago

a badged can awared in the following form :

             * Automatic (defined or programing)
             * Manual
             * by group

an example of a programing badged :

A badge for 10 accepted answers
SELECT id user_id, current_timestamp granted_at
FROM users
WHERE id  IN (
       SELECT p1.user_id 
       FROM post_custom_fields pc
       JOIN badge_posts p1 ON p1.id = pc.post_id
       JOIN topics t1 ON p1.topic_id = t1.id
       WHERE p1.user_id <> t1.user_id AND 
                    name = 'is_accepted_answer' AND 
                    value IS NOT NULL AND
            p1.user_id IN (
                   SELECT user_id 
                   FROM posts 
                   WHERE :backfill OR  p1.id IN (:post_ids)
            )
        GROUP BY p1.user_id
        HAVING COUNT(*) > 9
)

Note : Badge SQL can no longer be edited by default -> https://meta.discourse.org/t/badge-sql-can-no-longer-be-edited-by-default/47894

Another Discousion :

https://meta.discourse.org/t/customizing-text-content-badges-to-points/60175?u=mikechristopher
https://meta.discourse.org/t/feature-proposal-improved-badge-granting-workflow/58631
https://meta.discourse.org/t/how-can-i-add-new-badges/68427
https://meta.discourse.org/t/creating-new-badge/58130
https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978
https://meta.discourse.org/t/grant-a-badge-to-individual-users-manually/29426?source_topic_id=50946
https://meta.discourse.org/t/how-to-set-up-the-picture-of-badge-grant-a-badge-to-individual-users-manually/54293
https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978?source_topic_id=50946
https://meta.discourse.org/t/how-do-i-make-my-own-badge-query/50946
https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978/5
https://meta.discourse.org/t/discourse-new-user-guide/96331
https://meta.discourse.org/t/triggered-custom-badge-queries/19336
https://meta.discourse.org/t/grant-a-badge-to-individual-users-manually/29426
https://meta.discourse.org/t/automatically-grant-a-badge-for-all-members-of-a-group/18147
https://meta.discourse.org/badges
https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978/4
https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978/17
https://meta.discourse.org/t/badge-sql-can-no-longer-be-edited-by-default/47894
https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978/35
https://meta.discourse.org/t/what-cool-badge-queries-have-you-come-up-with/18978/38

Metadata Update from @hhlp:
- Issue assigned to hhlp

2 years ago

Metadata Update from @hhlp:
- Issue tagged with: S: Needs-comment, S: Next-meeting, T: Idea, T: Task

2 years ago

Metadata Update from @ankursinha:
- Issue untagged with: S: Next-meeting
- Issue tagged with: C: AskFedora, S: Future-meeting

2 years ago

Metadata Update from @ankursinha:
- Issue unmarked as depending on: #106
- Issue unmarked as depending on: #91

2 years ago

Metadata Update from @ankursinha:
- Issue close_status updated to: Invalid
- Issue status updated to: Closed (was: Open)

2 years ago

Login to comment on this ticket.

Metadata