vb.org Archive - Administrative and Maintenance Tools - SKM

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)

- - Administrative and Maintenance Tools - SKM - Who Tagged? (https://vborg.vbsupport.ru/showthread.php?t=186714)

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.

Line the columns up Brian :)

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?

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

Shouldnt that be .php?

fixed.

pls re-download if you downloaded before this post.

"You currently have this modification tagged."

what does that mean?

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?

Bug:

Code:

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

Quote:

Originally Posted by dimab (Post 1587432)

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.

Quote:

Originally Posted by redlabour (Post 1587438)

Bug:

Prefixes fixed. thanks for reporting.

Quote:

Originally Posted by briansol (Post 1587583)

Prefixes fixed. thanks for reporting.

Bug still not fixed:

Code:

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.

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

Quote:

Originally Posted by briansol (Post 1587750)

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

Quote:

Originally Posted by briansol (Post 1587750)

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:

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

Hello all,

I just posted v 1.5.0 which adds several new features :)

New Screen Shots added :)

thanks i needed that will be testing soon

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

Jacquii.

Thanks Jacquii. Enjoy :)

Great mod, thanks for sharing.

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.

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.

Quote:

Originally Posted by briansol (Post 1645360)

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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01953 seconds Memory Usage 1,767KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (24)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: