how do i find out who's tagging a thread?

[sanfrancisco]

guys i've been facing some tag abuse. right now i see no way to see who tagged a thread. any way to find this out?

[Dismounted]

One of the "tag" tables in the database keeps this information.

[sanfrancisco]

seems like its two - there's one table that just has tag id and the content, another that has the tag id and member id. which means to find out who tagged it i need to find the correct tagid from the first table, link it to the member id in the 2nd table, and finally link the memberid to username either within the forums or using the database.

there must be an easier way?!

[Dismounted]

SELECT u.username
FROM tag AS tag
LEFT JOIN tagthread AS tagt ON (tagt.tagid = tag.tagid)
LEFT JOIN user AS u ON (tagt.userid = u.userid)
WHERE tag.tagtext = 'X'
AND tagt.threadid = 1
Replace 1 with the thread id and X with the tag text.

[sanfrancisco]

so there really isn't some simple plugin / vbulletin option that allows this?? sql queries can only be run by the admin, not by moderators as far as i know...

[theOZer]

It's already there in vB!
Read thru this thread at vB.com:
http://www.vbulletin.com/forum/showthread.php?t=277441
Click a tagged thread, click on Edit Tags, mouse over the current tag(s).