load("stats");
addnav($lang->nav_stats);
$stats = $cache->read("stats");
if($stats['numthreads'] < 1 || $stats['numposts'] < 1)
{
error($lang->not_enough_info_stats);
}
$plugins->run_hooks("stats_start");
$repliesperthread = mynumberformat(round((($stats['numposts'] - $stats['numthreads']) / $stats['numthreads']), 2));
$postspermember = mynumberformat(round(($stats['numposts'] / $stats['numusers']), 2));
// Get number of days since board start (might need improvement)
$query = $db->query("SELECT regdate FROM ".TABLE_PREFIX."users ORDER BY regdate LIMIT 1");
$result = $db->fetch_array($query);
$days = (time() - $result['regdate']) / 86400;
// Get "per day" things
$postsperday = mynumberformat(round(($stats['numposts'] / $days), 2));
$threadsperday = mynumberformat(round(($stats['numthreads'] / $days), 2));
$membersperday = mynumberformat(round(($stats['numusers'] / $days), 2));
// Get forum permissions
$unviewableforums = getunviewableforums();
if($unviewableforums)
{
$fidnot = " AND fid NOT IN ($unviewableforums)";
}
// Most replied-to threads
$query = $db->query("SELECT tid, subject, replies FROM ".TABLE_PREFIX."threads WHERE 1=1 $fidnot ORDER BY replies DESC LIMIT 0, ".$mybb->settings[statslimit]);
while($thread = $db->fetch_array($query))
{
$thread['subject'] = htmlspecialchars_uni(stripslashes(dobadwords($thread['subject'])));
$numberbit = mynumberformat($thread['replies']);
$numbertype = $lang->replies;
eval("\$mostreplies .= \"".$templates->get("stats_thread")."\";");
}
// Most viewed threads
$query = $db->query("SELECT tid, subject, views FROM ".TABLE_PREFIX."threads WHERE 1=1 $fidnot ORDER BY views DESC LIMIT 0, ".$mybb->settings[statslimit]);
while($thread = $db->fetch_array($query))
{
$thread['subject'] = htmlspecialchars_uni(stripslashes(dobadwords($thread['subject'])));
$numberbit = mynumberformat($thread['views']);
$numbertype = $lang->views;
eval("\$mostviews .= \"".$templates->get("stats_thread")."\";");
}
// Top forum
$query = $db->query("SELECT fid, name, threads, posts FROM ".TABLE_PREFIX."forums WHERE 1=1 $fidnot AND type='f' ORDER BY posts DESC LIMIT 1");
$forum = $db->fetch_array($query);
if(!$forum['posts'])
{
$topforum = $lang->none;
$topforumposts = $lang->no;
$topforumthreads = $lang->no;
}
else
{
$forum['name'] = htmlspecialchars_uni(stripslashes($forum['name']));
$topforum = "$forum[name]";
$topforumposts = $forum['posts'];
$topforumthreads = $forum['threads'];
}
// Today's top poster
$timesearch = time() - 86400;
$query = $db->query("SELECT u.uid, u.username, COUNT(*) AS poststoday FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."users u ON (p.uid=u.uid) WHERE p.dateline > $timesearch GROUP BY p.uid ORDER BY poststoday DESC LIMIT 1");
$user = $db->fetch_array($query);
if(!$user['poststoday'])
{
$topposter = $lang->nobody;
$topposterposts = $lang->no_posts;
}
else
{
if(!$user['uid'])
{
$topposter = $lang->guest;
}
else
{
$topposter = "$user[username]";
}
$topposterposts = $user['poststoday'];
}
// What percent of members have posted?
$query = $db->query("SELECT COUNT(*) FROM ".TABLE_PREFIX."users WHERE postnum > 0");
$posters = $db->result($query, 0);
$havepostedpercent = round((($posters / $stats['numusers']) * 100), 2) . "%";
$lang->todays_top_poster = sprintf($lang->todays_top_poster, $topposter, mynumberformat($topposterposts));
$lang->popular_forum = sprintf($lang->popular_forum, $topforum, mynumberformat($topforumposts), mynumberformat($topforumthreads));
$stats['numposts'] = mynumberformat($stats['numposts']);
$stats['numthreads'] = mynumberformat($stats['numthreads']);
$stats['numusers'] = mynumberformat($stats['numusers']);
eval("\$stats = \"".$templates->get("stats")."\";");
$plugins->run_hooks("stats_end");
outputpage($stats);
?>