//Start deep stats
//zaher1988
$timesearch = time() - $mybb->settings['wolcutoffmins']*60;
$query = $db->query("SELECT uid FROM ".TABLE_PREFIX."sessions WHERE time>'$timesearch' ORDER BY time DESC");
$users_count = 0;
$guest_count = 0;
while($on_line = $db->fetch_array($query))
{
if($on_line['uid'] == 0)
{
$guest_count++;
}
else
{
$users_count++;
}
}
$total_online = $users_count + $guest_count;
$oneday_timesearch = time() - (60*60*24);
$query = $db->query("SELECT sid FROM ".TABLE_PREFIX."sessions WHERE time>'$oneday_timesearch'");
$today_online = $db->num_rows($query);
//Forum stats
$stats = $cache->read("stats");
if(!$stats['lastusername'])
{
$newestmember = "no-one";
}
else
{
$newestmember = build_profile_link($stats['lastusername'], $stats['lastuid']);
}
$total_posts = my_number_format($stats['numposts']);
$total_threads = my_number_format($stats['numthreads']);
$total_users = my_number_format($stats['numusers']);
//Posts today
$total_posts_today = $db->num_rows($db->query("SELECT * FROM ".TABLE_PREFIX."posts WHERE dateline>'$oneday_timesearch'"));
$onehour_timesearch = time() - (60*60);
$total_posts_lasthour = $db->num_rows($db->query("SELECT * FROM ".TABLE_PREFIX."posts WHERE dateline>'$onehour_timesearch'"));