Tag Spam?

How do I see who has tagged items? I have users tagging stuff with profanity and its showing up in the Tag search.

Just go into your vbulletin options and ban swear words from tags

Code:

SELECT g.tagtext, u.username, concat('http://yoursite.com/showthread.php?t=', t.threadid) as threadid, FROM_UNIXTIME(t.dateline) FROM `tagthread` t
left outer join user u on 
u.userid = t.userid
left outer join tag g
on t.tagid = g.tagid
order by t.threadid desc
limit 30

obviously, add your table prefix if you use one
and replace yoursite.com with your domain and /forums if you have it.

run in phpmyadmin

i limited it to 30, as it can return a ton of rows. you can remove the limit 30, or even change it in sets like
limit 30, 30 to pull records 30-59

heh,
here:
SKM - Who Tagged? - vBulletin.org Forum

i made a product

Awesome! Thanks!!!