If i reload page with my name in link (?u=username) 300 times, i’ll get this badge. How do secure it?

Well, I did it… Use Data Explorer Plugin. Create new query Use this query Execute and view the “clicks” on your topic Open that “topic” on new window, and repload that page with your user’s link a few times… such 10 times or less. Re-execute the query… do you see changes? (I do not.) Finish the test… check complete :wink: Ps, query’s list updated :rocket:

This query is like “Great share” badge. In Hot link different query. I’ll test it.

Ah… I don’t use English language right now on admin panel. What badge’s id is the “hot link” badge?

I don’t use it too)) 30 is like your query, 21 - hot link

What query is in this badge? https://meta.discourse.org/badges/29/hot-link

Here’s the query for the Hot Link badge lib/badge_queries.rb 5f64fd0a2 SELECT tl.user_id, post_id, current_timestamp granted_at FROM topic_links tl 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 tl.internal AND tl.clicks >= #{count} GROUP BY tl.user_id, tl.post_id

Tnx. And what query for this? https://meta.discourse.org/badges/21/nice-share

lib/badge_queries.rb 5f64fd0a2 SELECT views.user_id, i2.post_id, current_timestamp granted_at FROM ( SELECT i.user_id, MIN(i.id) i_id FROM incoming_links i JOIN badge_posts p on p.id = i.post_id WHERE i.user_id IS NOT NULL GROUP BY i.user_id,i.post_id HAVING COUNT(*) > #{count} ) as views JOIN incoming_links i2 ON i2.id = views.i_id

Thnx. My instance of discourse granted me this badge after reloading link with my username 25 times by myself, but meta.discourse.org didn’t. Why?

:face_with_monocle: Hmm… It was the same IP. I’ll try from another.

How to check the uniqueness of users in "hot link" badge?

Product Support

codinghorror (Jeff Atwood) July 5, 2018, 7:48pm 11

Probably an error in configuration where the correct user IP is not passed through on your site?

Topic		Replies	Views
Count at "Others with this badge" includes current user UX	3	844	July 2, 2018
Has anything changed on what qualifies for the "Nice share" badge? Bug badges	36	1381	December 22, 2025
Badge based on link stats? Data & reporting sql-query	5	1349	August 27, 2015
Grant Badge when user visits link Data & reporting sql-triggered-badge	26	1714	August 30, 2023
Custom badge query is not targeting posts Product Support	1	819	January 2, 2019

How to check the uniqueness of users in "hot link" badge?

Related topics