Badge for total posts, and attendence

Data & reporting
1

How can I create badges that count totally posts of someone?
And a badge for days attendance (not consecutive)
Any idea?

2 Likes
2

Including

  • PM’s,
  • flags
  • deleted/hidden posts
  • categories that require logging in to view?

For someone who’s made 1,000 or more posts:

SELECT user_id, current_timestamp granted_at 
FROM posts  
GROUP BY user_id 
HAVING count(*) >= 1000

Triggered daily, don’t target posts.

To exclude those things listed in the bullet points, change from posts to from badge_posts

For visiting 365 days:

SELECT user_id, current_timestamp granted_at 
FROM user_visits  
GROUP BY user_id 
HAVING count(*) >= 365

Again, triggered daily, don’t target posts.

8 Likes
3

Cool man, really! Now I have all what I need

1 Like