Would there be any way to run a badge query on number of clicks on a link? I find that users will click a link and it will be really popular, but the topic originator never gets any likes to the post (or far less than the number of clicks to the website). Any way to run a badge query on that?

That is a very good idea for a badge. Maybe we can slot that for 1.4, as we like to add at least one useful (encourages “good” behavior) badge each release.

https://meta.discourse.org/badges/124/popular-link SQL select l.user_id, post_id, min(l.created_at) granted_at from topic_links l join posts p on p.id = post_id and p.deleted_at IS NULL join topics t on t.id = p.topic_id and t.deleted_at IS NULL and t.archetype <> 'private_message' where not inter…

[画像] sam: min(l.created_at) granted_at If the badge is bronze, nobody’s ever going to receive a notification for that; the granted_at will be too old. You’re going to have to use row_number() to get the correct date for the badge.

These badges are now officiel :cow2: https://github.com/discourse/discourse/commit/d96531b1635b461b423a6a36a20299cf72ef0ed1

Badge based on link stats?

Community Building Data & reporting

codinghorror (Jeff Atwood) 2015 年 5 月 20 日午前 4:46 4

It is fine to wait, no need to rush badges.

トピック		返信	表示
Grant Badge when user visits link Data & reporting sql-triggered-badge	26	1590	2023 年 8 月 30 日
Created_at column in the incoming_links table Product Support	0	423	2021 年 11 月 22 日
Custom badge query is not targeting posts Product Support	1	792	2019 年 1 月 2 日
Make a badge for the answer with the most likes in a topic! Data & reporting sql-triggered-badge	4	3419	2016 年 3 月 29 日
Badge for popular topic Data & reporting sql-triggered-badge	5	413	2024 年 6 月 1 日

Badge based on link stats?

関連トピック