Administrative and Maintenance Tools - SKM - Who Tagged?

Hello,

This is my first publicly released mod here at .org. Please be kind if there are bugs/missing things. I will fix ASAP.

This is a simple product that let's you easily see who tagged what words on what thread. It may come in handy for dealing with profanity or spamming of the tag system.

I've built and tested this around 3.7.2. It MIGHT work on .1 and .0 but has not been tested. Obviously it won't work on 3.6.x because tags didn't exist then.

this is a very basic mod. There is no searching of any kind. It simply displays all, ordered by latest thread ID DESC in a nice paginated display.

Features:
No template edits of any kind
1 product
0 plugins
2 files
1 phrase

0 extra queries in normal forums. Only runs in admin panel when you run it so there are no performance issues to worry about.
Paginated results to ease the load on your server (or, if you have thousands of tags...)

Please mark installed if you use it.

I will offer limited support for a couple days, but long term this won't be supported.

-------------------------------------------------------------------
UPDATE: 7.31.2008

Version 1.5.0

Adding on to the initial release, 1.5.0 now supports a couple more look up features.
Both tags and users are now linked, offering a lookup by a particular phrase or username.
Additionally, there are plain text searches for looking up by tag or userid without having to find a thread that they tagged first.

Additionally, a couple code tweaks were performed for performance/speed/server usage.

I also placed a 3.7.2 min version on the product. If you want to try it on lesser versions, feel free, but you will have to edit the product XML and remove that condition.

The interface is nearly the same, other than there is now a 'landing page' to select one of the options first.
New screens added!

Please be sure to download the latest, 1.5.0. I am leaving up the original for now.

[briansol]

Originally Posted by dimab

I'm assuming that this works with tags that have already been created in the past? That is that this data is already in the system to begin with?

correct. the sample post was simply made in my test enviro to show.

Originally Posted by redlabour

Bug:

Prefixes fixed. thanks for reporting.

[redlabour]

Originally Posted by briansol

Prefixes fixed. thanks for reporting.

Bug still not fixed:

Datenbankfehler in vBulletin 3.7.2:

Invalid SQL:

		SELECT COUNT(*) AS total
		FROM vb3_ tagthread t
		LEFT OUTER JOIN vb3_user u ON u.userid = t.userid
		LEFT OUTER JOIN vb3_tag g ON t.tagid = g.tagid;

MySQL-Fehler  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't
		LEFT OUTER JOIN vb3_user u ON u.userid = t.userid
		LEFT OUTER JOIN vb3_tag ' at line 2
Fehler-Nr.    : 1064
Fehler-Zeit   : Wednesday, 30.07.2008 @ 23:10:50
Datum         : Wednesday, 30.07.2008 @ 23:10:50
Skript        : http://www.MYDOMAIN.de/forum/admincp/skm_whotagged.php
Referrer      : http://www.MYDOMAIN.de/forum/admincp/index.php?do=nav
IP-Adresse    : MYIP
Benutzername  : MYUSERNAME
Klassenname   : vB_Database_MySQLi
MySQL-Version : 5.0.51

Are you sure that you mean : vb3_ tagthread and not vb3_tagthread ???

And be please so kind an use the Mailnotification if you release Updates to Hacks.

[briansol]

Whoops. missed one. Sorry, I don't use prefixes so i didn't have anything to test against and had a space typo.

New package uploaded.

Also, I do have this set to email notification... you should have gotten one

[redlabour]

Originally Posted by briansol

Whoops. missed one. Sorry, I don't use prefixes so i didn't have anything to test against and had a space typo.

New package uploaded.

Works now!

Originally Posted by briansol

Also, I do have this set to email notification... you should have gotten one

No sorry - i did get the normal Mailnotification for new Posts in this Thread - but it did not get any Updatenotification for the last or this Update.

[briansol]

Andre, check your spam filters. I just checked my mail (as i also clicked install on this) and I received notification.

[briansol]

Hello all,

I just posted v 1.5.0 which adds several new features

[briansol]

New Screen Shots added

[MissKalunji]

thanks i needed that will be testing soon

[PoetJA-1975]

Excellent Modification = just what I was looking for.
Thanx so much for the sharing

Jacquii.

[briansol]

Thanks Jacquii. Enjoy