User criteria/trophy for adding thread tags

I've just had a guy spend a couple hours tagging yesterday and then again today on my forum. He's doing a great job and I'm so grateful. I want to be able to reward him somehow for that.
 
This is all one guy. We're a small forum, so it means a lot. I'd give him a trophy manually, but I always regret manual actions like that later, and I want to show equal appreciation for the "slow and steady" taggers as well.

upload_2016-1-20_13-3-14.webp

upload_2016-1-20_13-4-4.webp
upload_2016-1-20_13-5-6.webp
 
That's awesome. This thread is a great model of positive developer interaction.

For anyone else, I found the following SQL helpful for manually identifying users who tag a lot. It provides a count of the number of times a user has added a tag that is still in the database.
Code:
SELECT * , count( add_user_id )
FROM `xf_tag_content`
WHERE 1
GROUP BY add_user_id
ORDER BY count( add_user_id ) DESC
LIMIT 0 , 30

I applied it by clicking on the SQL tab of the xf_tag_content table from within phpMyAdminand got the following:
upload_2016-1-21_15-2-16.webp
 
Back
Top Bottom