vb.org Archive - Show Thread Enhancements

(In forumdisplay) Top helpers by each forum, not Top helpers from all forum

Please help how to make Top Helpers on forumdisplay will showing Top helpers by each forum, not Top helpers from all forum, thats how looks like yahoo answer

like this health category in yahoo answer, and the top contributor
https://vborg.vbsupport.ru/external/2010/06/7.jpg

Science and mathematics category
https://vborg.vbsupport.ru/external/2010/06/8.jpg

please can you make little edit just for that or give a clue, we really need it to make like yahoo answer

i believe its in 'Answer Forums - Transform Forumdisplay' plugin

i already try add the red code below (The Top Helpers part code), by looking the code in blue (The stats code is by each forum, not all forum)

but its not right, get error, please help or give a clue to make this work, this is to make this mod better, like yahoo answer

Quote:

if($foruminfo[g_answer_forum]){

// Set cutoff date if once is applied
$af_cutoff = $vbulletin->options['answers_forums_cutoff_date'];

// Filter answers?
if($_REQUEST['show_answers'] == '1'){
$hook_query_where .= " AND thread.g_answer_forum_answer != '0' AND thread.dateline > '" . $af_cutoff . "'";
} elseif($_REQUEST['show_answers'] == '0'){
$hook_query_where .= "AND thread.g_answer_forum_answer = '0' AND thread.dateline > '" . $af_cutoff . "'";
}

// Stats
if($vbulletin->options['answers_forums_enable_stats']){
// An option is enabled, so show the right column
$show[right_column] = 1;

$total_answers = $vbulletin->db->query_first("SELECT count(threadid) AS total FROM " . TABLE_PREFIX . "thread WHERE forumid = " . $foruminfo['forumid'] . " AND g_answer_forum_answer != '0'");
$total_not_answered = $vbulletin->db->query_first("SELECT count(threadid) AS total FROM " . TABLE_PREFIX . "thread WHERE forumid = " . $foruminfo['forumid'] . " AND g_answer_forum_answer = '0' AND dateline > '" . $af_cutoff . "'");

if(!$total_not_answered['total']){ $total_not_answered['total'] = 0; }
$answers_forum['total_answered'] = $total_answers['total'];
$answers_forum['total_not_answered'] = $total_not_answered['total'];

if($total_answers['total']){

$answers_forum['total_answered_percent'] = round($total_answers['total'] / ($total_answers['total'] + $total_not_answered['total']) * 100);

} else {

$answers_forum['total_answered_percent'] = 0;

}
}

// Recently Answered
if($vbulletin->options['answers_forums_enable_recently_answered']){
// An option is enabled, so show the right column
$show[right_column] = 1;

// Recently answered questions
$answered_threads = $vbulletin->db->query_read("SELECT thread.threadid, thread.title, post.dateline, thread.postuserid, thread.postusername, answer_post.userid AS answer_userid, answer_post.username AS answer_username
FROM " . TABLE_PREFIX . "thread AS thread
LEFT JOIN " . TABLE_PREFIX . "post as post ON(post.postid = thread.lastpostid)
LEFT JOIN " . TABLE_PREFIX . "post as answer_post ON(answer_post.postid = thread.g_answer_forum_answer)
WHERE forumid = " . $foruminfo['forumid'] . " AND g_answer_forum_answer != '0' AND thread.dateline > '" . $af_cutoff . "'
ORDER BY post.dateline DESC
LIMIT 15
");

while($thread = $vbulletin->db->fetch_array($answered_threads)){
eval('$answers_forum_threads .= "' . fetch_template("answer_forums_answeredbit") . '";');
}
}

// Top helpers
if($vbulletin->options['answers_forums_enable_top_helpers']){
// An option is enabled, so show the right column
$show[right_column] = 1;

// Users with most answers IE: Our Top Helpers
$top_helpers_get = $vbulletin->db->query_read("SELECT userid, username, forum_answers FROM " . TABLE_PREFIX . "user WHERE forumid = " . $foruminfo['forumid'] . " ORDER BY forum_answers DESC LIMIT 10");

while($helper = $vbulletin->db->fetch_array($top_helpers_get)){
eval('$top_helpers .= "' . fetch_template("answer_forums_helperbit") . '";');
}
}

// Any enabled features to show?
if($show[right_column]){

// Wrap the forumdisplay with the new info
eval('$header .= "' . fetch_template("answer_forums_head") . '";');
eval('$answer_forums_foot .= "' . fetch_template("answer_forums_foot") . '";');
$footer = $answer_forums_foot . $footer;

}

}

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01350 seconds Memory Usage 1,762KB 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_quote_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 (12)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
Messages: