只读模式是否会阻止用户获得奉献者徽章？

Benjamin_D · 2021 年7 月 21 日 11:27

嗨！
我认为不会，只要用户仍然访问只读论坛，我就没找到任何理由说明会出问题。"start" 似乎仅与用户相关。

lib/badge_queries.rb

1472e47aa


      
          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

我记得用户标签页中的“最后访问”列在只读模式下依然有效，所以我的猜测是：你没问题

话题		回复	浏览量
See how many days straight we've been on the forums Feature	4	833	2023 年8 月 15 日
'Seen in last X days' badge? Data & reporting sql-triggered-badge	12	268	2016 年8 月 26 日
How do I check a badge's status midway to it being awarded? Support	2	1397	2019 年7 月 31 日
Devotee Badge Issue! Bug	17	1230	2021 年7 月 8 日
Fake aficionado Bug	9	1016	2018 年10 月 25 日

只读模式是否会阻止用户获得奉献者徽章？

相关话题