‘새로운 기여자’ 배지를 만들 수 있나요?

[copymonopoly]

Can I find out who are 'new contributors'?

In a forum in the early stages of growth, it feels handy to know who has recently made their first post. If I happen to see it, it has a little banner box. But if I don’t see that, is there any way to find the post? (The Admin interface tells me that there has been a new contributor.) I’ve looked in all recently updated threads and don’t see the box. Can I search for all users with only 1 post? Or all users with only a few posts?

SELECT username
FROM users u
JOIN user_stats us
ON u.id = us.user_id
WHERE us.first_post_created_at BETWEEN :start_date::date 
AND :end_date::date

SQL 쿼리를 배지 설정으로 변환하는 방법을 알고 싶습니다. 사용자가 첫 게시글을 작성할 때 ‘New Contributors’ 배지를 받을 수 있도록 설정하고 싶습니다.

[ondrej]

Copymonopoly님,

아래 주제를 확인해 보셨나요?

Enable Badge SQL

This guide explains how to enable Badge SQL in Discourse and discusses the associated security and performance risks. Required user level: Administrator Enabling Badge SQL can pose security and performance risks. To maintain security and performance integrity, as of Discourse 1.6, the ability for administrators to edit badge SQL directly is disabled by default. The two primary concerns around enabling Badge SQL are: Security: Allowing direct SQL…