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

pkulkov · July 3, 2018, 12:26pm

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

SidV · July 3, 2018, 1:00pm

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

Ps, query’s list updated

pkulkov · July 3, 2018, 2:10pm

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

SidV · July 3, 2018, 3:02pm

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

pkulkov · July 3, 2018, 3:11pm

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

pkulkov · July 5, 2018, 10:29am

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

zogstrip · July 5, 2018, 10:35am

Here’s the query for the Hot Link badge

github.com/discourse/discourse

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

pkulkov · July 5, 2018, 12:24pm

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

mikechristopher · July 5, 2018, 12:43pm

github.com/discourse/discourse

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

pkulkov · July 5, 2018, 1:02pm

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?

codinghorror · July 5, 2018, 7:48pm

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

pkulkov · July 5, 2018, 9:36pm

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

pkulkov · July 9, 2018, 5:59pm

Looks like this is it. From another IP badge not granted

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

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

AI-generated summary

Related topics