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
Quero saber como transformar uma consulta SQL em uma configuração de emblema. Quero que os usuários recebam um emblema de ‘Novos Contribuintes’ quando fizerem sua primeira postagem.
ondrej
Fevereiro 28, 2025, 9:07pm
2
Olá Copymonopoly,
Você já deu uma olhada neste tópico abaixo?