vb.org Archive

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)

briansol 07-29-2008 09:00 PM

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 07-30-2008 03:29 AM

reserved...

Michael Biddle 07-30-2008 03:37 AM

Line the columns up Brian :)

briansol 07-30-2008 03:46 AM

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 07-30-2008 03:52 AM

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

Shouldnt that be .php?

briansol 07-30-2008 04:01 AM

yup, fixing now :D

briansol 07-30-2008 04:05 AM

fixed.

pls re-download if you downloaded before this post.

briansol 07-30-2008 04:49 AM

"You currently have this modification tagged."

what does that mean?

dimab 07-30-2008 12:27 PM

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 07-30-2008 12:37 PM

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



All times are GMT. The time now is 02:31 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01619 seconds
  • Memory Usage 1,737KB
  • 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
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete