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
Voglio sapere come trasformare una query SQL in un’impostazione per badge. Voglio che gli utenti ricevano un badge ‘Nuovi Contributori’ quando effettuano il loro primo post.
ondrej
28 Febbraio 2025, 9:07pm
2
Ciao Copymonopoly,
Hai dato un’occhiata all’argomento qui sotto?