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]

reserved...

[Michael Biddle]

Line the columns up Brian

[briansol]

I can't find a single setting that works across all columns on print_cells_row(); nor is there any documentation about the function anywhere...

any suggestions?

[Michael Biddle]

$page_button = "skm_whotagged.phpp?" . $vbulletin->session->vars['sessionurl'];

Shouldnt that be .php?

[briansol]

yup, fixing now

[briansol]

fixed.

pls re-download if you downloaded before this post.

[briansol]

"You currently have this modification tagged."

what does that mean?

[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?

[redlabour]

Bug:

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_ ta' at line 2
Fehler-Nr.    : 1064
Fehler-Zeit   : Wednesday, 30.07.2008 @ 16:40:48
Datum         : Wednesday, 30.07.2008 @ 16:40:48
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