query('SELECT '.$tpid.'t.tid,t.views,t.replies,'.$pref.'username as musername,'.$pref.'subject,'.$pref.'dateline,'.$pref.'uid,u.usergroup,u.username,u.displaygroup
FROM '.TABLE_PREFIX.'threads t'.$lj.' LEFT JOIN '.TABLE_PREFIX.'users u ON(u.uid='.$pref.'uid)
WHERE '.$pref.'fid '.$options['fids_format'].' ('.$fids.')'.$unviewwhere.' AND t.visible=1'.$visiblepost.' AND t.closed NOT LIKE "moved|%"
ORDER BY '.$pref.$options['order_by'].' '.$options['order_dir'].'
LIMIT 0,'.intval($options['limit']).'
');
if($db->num_rows($query)){
while($data = $db->fetch_array($query)){
if(!$data['username']) $data['username'] = $data['musername'];
if(!$data['uid']){
$data['author'] = format_name($data['username'],1,1);
}else{
$data['author'] = build_profile_link(format_name($data['username'],$data['usergroup'],$data['displaygroup']),$data['uid']);
}
$data['views'] = my_number_format($data['views']);
$data['replies'] = my_number_format($data['replies']);
$data['tpdate'] = my_date($mybb->settings['dateformat'],$data['dateline']);
$data['tptime'] = my_date($mybb->settings['timeformat'], $data['dateline']);
$data['tpsubject'] = htmlspecialchars_uni($data['subject']);
if(intval($options['maxchars']) > 0 && my_strlen($data['subject']) > intval($options['maxchars'])){
$data['tpsubject'] = htmlspecialchars_uni(my_substr($data['subject'],0,intval($options['maxchars'])).'...');
}
$data['subject'] = htmlspecialchars_uni($data['subject']);
$data['tplink'] = ''.$data['tpsubject'].'';
if(empty($options['childtemplate'])){
$eachdata .= ''.$data[$format[0]].''.$data[$format[1]].'
';
}else{
eval('$$options[\'childtemplate\'] .= "'.$templates->get(trim($options['childtemplate'])).'";');
}
}
}else{
$eachdata = 'There is no stats available
';
}
if(empty($options['maintemplate'])){
$mn_tp_load_data = '| '.$options['title'].' |
| '.$eachdata.' |
';
}else{
eval('$mn_tp_load_data = "'.$templates->get(trim($options['maintemplate'])).'";');
}
return $mn_tp_load_data;
}
}
function mn_tp_load_tplink($type,$tid,$pid=''){
global $mybb;
switch($type){
case 'threads':
$tplink = $mybb->settings['bburl'].'/'.get_thread_link(intval($tid));
break;
case 'posts':
$tplink = $mybb->settings['bburl'].'/'.get_post_link(intval($pid),intval($tid)).'#pid'.intval($pid);
break;
}
return $tplink;
}
?>