Verhindert der schreibgeschützte Modus, dass Benutzer die Devotee-Auszeichnung erhalten?

Benjamin_D · 21. Juli 2021 um 11:27

Hi!
I’d say no, as I didn’t find any reason why it would, as long as the user still visit the read-only forum. "start" seems to be only user related

github.com

discourse/discourse/blob/1472e47aae5bfdfb6fd9abfe89beb186c751f514/lib/badge_queries.rb#L253-L273

    
      
          def self.consecutive_visits(days)
            <<~SQL
              WITH consecutive_visits AS (
                SELECT user_id
                     , visited_at
                     , visited_at - (DENSE_RANK() OVER (PARTITION BY user_id ORDER BY visited_at))::int s
                  FROM user_visits
              ), visits AS (
                SELECT user_id
                     , MIN(visited_at) "start"
                     , DENSE_RANK() OVER (PARTITION BY user_id ORDER BY s) "rank"
                  FROM consecutive_visits
              GROUP BY user_id, s
                HAVING COUNT(*) >= #{days}
              )
              SELECT user_id
                   , "start" + interval '#{days} days' "granted_at"
                FROM visits
               WHERE "rank" = 1
            SQL
          end

And I remember that the “last seen” column of the users tab was alive even in read-only mode, so my guess is you’re in the clear

Thema		Antworten	Aufrufe
'Seen in last X days' badge? Data & reporting sql-triggered-badge	12	177	26. August 2016
Fake aficionado Bug	10	943	29. Oktober 2018
How can I see how many days in a row I visited the forum? Support	3	1701	25. Oktober 2018
How do I check a badge's status midway to it being awarded? Support	3	1281	31. Juli 2019
Can not get Reader Badge Bug badges	5	1658	30. Januar 2015

Verhindert der schreibgeschützte Modus, dass Benutzer die Devotee-Auszeichnung erhalten?

Verwandte Themen