• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

User criteria/trophy for adding thread tags

ForestForTrees

Well-known member
#6
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.
 

ForestForTrees

Well-known member
#7
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.png

upload_2016-1-20_13-4-4.png
upload_2016-1-20_13-5-6.png
 

ForestForTrees

Well-known member
#14
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.png