SKM - Who Tagged?

[briansol]

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 :D

[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

[briansol]

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.

Bug:



Prefixes fixed. thanks for reporting.

[redlabour]

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]

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! :)


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. :cool:

[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 :)

[jw00dy]

Great mod, thanks for sharing.

[TheLab]

Great mod thanks :)

I have a minor problem though, the link is not showing on the admincp and i have to browse to the specific php file to get access to the mod.

[briansol]

You should see it in the stats and logs Group heading.

You may need to refresh the left frame (or completely close out of your browser and re-load the ACP).

If you still don't see it, re-ftp the /includes/xml/ folder. That xml file in there is what adds the link to the left nav.

[TheLab]

If you still don't see it, re-ftp the /includes/xml/ folder. That xml file in there is what adds the link to the left nav.

Yeap that worked. Cheers :up: