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)
-   -   Statistics Modifications - Cyb - Moderating Stats (https://vborg.vbsupport.ru/showthread.php?t=177951)

PGAmerica 08-12-2008 10:59 PM

Quote:

Originally Posted by PGAmerica (Post 1595559)
Can somebody please tell me how to manually add this to my navbar template? I just need to know the exact code to add.

Is there any help to my problem?

Xenofox 08-12-2008 11:13 PM

Am i the only one who sees no infractions when limiting the time of the reports, instead of all time.?

PGAmerica 08-15-2008 02:30 PM

Is there any support for this mod at all?

KURTZ 08-15-2008 02:34 PM

Quote:

Originally Posted by PGAmerica (Post 1599279)
Is there any support for this mod at all?

i think not mate ... this hack is still glitched ...

smirkley 08-25-2008 01:47 PM

Cyb, like this mod alot.

Hoping at your convenience, that it could be fixed where admins, smods, and mods, are all included by the selector to show stats.

I have played with the settings, but am unable to get the mods, currently appointed, and their stats, to show up yet.

Thanks in advance.

Blind Guardian 08-26-2008 11:05 PM

Quote:

Originally Posted by Xenofox (Post 1597356)
Am i the only one who sees no infractions when limiting the time of the reports, instead of all time.?

No, you're not. I have the same issue, and had come here to try and find a solution myself.

Glancing at the code, I'd think it's a problem with the query not specifying the dateline properly, but I haven't tried tweaking the query to see if I can fix it yet.

Code:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' $cybmodstats_timeperiod ");
It might be that $cybmodstats_timeperiod is pulling from the mod log, and not the infaction log?

Blind Guardian 09-04-2008 01:25 AM

So no one has any input on why limiting the number of days shown breaks the infraction totals?

EDIT: Nevermind, I fixed the bad query myself.

mrcrx 09-07-2008 07:25 PM

Quote:

Originally Posted by Blind Guardian (Post 1614051)
So no one has any input on why limiting the number of days shown breaks the infraction totals?

EDIT: Nevermind, I fixed the bad query myself.


Can you share how you fixed it? I really dont know where to start.

Blind Guardian 09-12-2008 08:21 PM

Under "Cyb - Moderating Stats - MN" in the Plugin Manager, I changed this:

Code:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' $cybmodstats_timeperiod ");
To this:

Code:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' AND dateline > $fromtime");
The problem was that the "$cybmodstats_timeperiod" being called in the query for the infractions was appending a "moderatorlog." prefix onto the "dateline" row, meaning it wasn't there in the infactions table. Removing it just pulls the regular dateline from that table and it works.

This will probably break the option to disable the time limitation on the logs, but I don't need that so it was the quickest fix for me.

What I'm currently trying to work out is why all of a sudden the "moderator posts in their own forums" fields are gone. Those were useful.

Valter 09-12-2008 09:13 PM

Quote:

Originally Posted by Blind Guardian (Post 1620746)
Code:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' AND $cybmodstats_timeperiod > $fromtime");

This is not part of my hack.

Here is original query:
Code:

$cybmodstats_get_infr = $vbulletin->db->query_read("SELECT whoadded, points, dateline FROM " . TABLE_PREFIX . "infraction WHERE whoadded='".$cybmodlogstat['userid']."' $cybmodstats_timeperiod ");


All times are GMT. The time now is 11:04 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.01233 seconds
  • Memory Usage 1,744KB
  • 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
  • (5)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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