How can I automatically grant a badge when the user visits a link within the discourse forum? ex: https://myforum.example.com?special_access=true

I think there should be, but that would be a different query. :slight_smile: This one awards a badge for clicking on a specific link in a specific forum post. If you want to award a badge for a user visiting a particular topic I think it would be: SELECT DISTINCT tv.user_id, MIN(tv.viewed_at) gran…

[画像] JammyDodger: AND tl.url = 'https://meta.discourse.org/' Im assuming this needs to be replaced with the post URL including the ‘/1’?

That bit needs to be replaced with the link they’re clicking on within the post. And the post_id is the post in which the link is pasted/shared.

Oh I see, so there is no way to just grant the badge just by them visiting the post link?

Okk so I have it setup like so: [Screenshot 2023-08-30 100233] But when I visit the post in question (as an Admin), I do not get the badge. Am i don’t something wrong here?

As it needs the Update Daily trigger, it will be granted the next time the daily badge grant job runs. You can manually trigger Jobs::BadgeGrant from your /sidekiq/scheduler page if you want to speed it up to check.

[画像] JammyDodger: /sidekiq/scheduler How can I make it update instantly?

The only available triggers are: Update daily When a user edits or creates a post When a user is edited or created When a user acts on a post When a user is edited or created When a user changes trust level [image] To have a more instant badge granted, you would need to work within the confines…

[画像] JammyDodger: manually trigger Jobs::BadgeGrant I did this but still not been granted yet.

FWIW, it works for me. Have you enabled it? And have you made sure you have the correct topic number set? [enable badge]

Yes it’s enabled. Let me try on another profile. Maybe its because I am the admin. Secondly, are you just pasting the topic link into your browser?

リンク訪問時にバッジを付与

コミュニティデータとレポート

JammyDodger 2023 年 8 月 30 日午後 4:30 28

自動化スクリプト（下記参照）を使用します。グループ作成の一部として、それに自動的に付与される信頼レベルを指定できます。

これは自動化プラグインの一部です。

トピック		返信	表示
Custom badge query is not targeting posts Support	1	758	2019 年 1 月 2 日
Grant Custom Badge Upon Reading ToS Data & reporting sql-triggered-badge	7	244	2025 年 5 月 31 日
How to see that a Topic has earned a badge Feature	5	1680	2015 年 7 月 27 日
Badge based on link stats? Data & reporting sql-query	5	1255	2015 年 8 月 27 日
Linking badge sql to a topic id? Support sql-triggered-badge	3	88	2026 年 6 月 11 日

リンク訪問時にバッジを付与

関連トピック