「新規コントリビューター」のバッジを作成できますか？

[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クエリをバッジ設定に変換する方法を知りたいです。ユーザーが最初の投稿をしたときに「新規貢献者」バッジを受け取るようにしたいです。

[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…