Thread: Statistics Modifications - Cyb - Moderating Stats
View Single Post
  #60  
Old 09-12-2008, 08:21 PM
Blind Guardian's Avatar
Blind Guardian Blind Guardian is offline
 
Join Date: Mar 2004
Location: South Carolina
Posts: 40
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01153 seconds
  • Memory Usage 1,765KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete