Tip: Get list of users that have posted to your forum lately

Question

You can do a plugin if you like, or just open phpmysql and do the following mysql operation:

SELECT handle,written
FROM `qa_users`
WHERE written > NOW() - INTERVAL 12 HOUR
ORDER BY written DESC

which gives you an ordered list of all users that have written something in your forum within the last 12 hours.

Cheers,
Kai

Comments

Thank you Kai.