[basketmen]

(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


Science and mathematics category





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

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;

}

}