3Di wrote:I have it working. Feel free to post you file here or to PM it to me, I'll give it a shot, indeed.
Thanks. It appears someone fixed the code on the first post of this thread so I have given it another go, however, I now get an error:
Code: Select all
Parse error: syntax error, unexpected T_DOUBLE_ARROW in /home/www/webmatrEU/forum/includes/functions_activity_stats.php on line 110
I have looked through my file and that line (110) but cant see anything really obvious. Heres my code on the file i amended:
Code: Select all
<?php
/**
*
* @package phpBB3
* @author Highway of Life ( David Lewis ) http://startrekguide.com
* @version $Id$
* @copyright (c) 2008 Star Trek Guide Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/
/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
exit();
}
/**
* Display extra stats, activity over the last 24 hours for new users, posts and topics.
*
* @return bool
*/
function activity_mod()
{
global $template, $user, $auth;
$user->add_lang('mods/activity_stats');
// if the user is a bot, we won’t even process this function...
if ($user->data['is_bot'])
{
return false;
}
// obtain user activity data
$active_users = obtain_active_user_data();
// obtain posts/topics/new users activity
$activity = obtain_activity_data();
// 24 hour users online list, assign to the template block: lastvisit
$users_online = 0;
foreach ($active_users as $row)
{
if (!$row['user_viewonline'] && !$auth->acl_get('u_viewonline'))
{
// user does not have permission to view hidden users.
continue;
}
$users_online++;
$username_string = get_username_string((($row['user_type'] == USER_IGNORE) ? 'no_profile' : 'full'), $row['user_id'], $row['username'], $row['user_colour']);
$username_string = (!$row['user_viewonline']) ? '<em>' . $username_string . '</em>' : $username_string;
$template->assign_block_vars('lastvisit', array(
'USERNAME_FULL' => $username_string,
));
}
// assign the stats to the template.
$template->assign_vars(array(
'USERS_24HOUR_TOTAL' => sprintf($user->lang['USERS_24HOUR_TOTAL'], $users_online),
'24HOUR_TOPICS' => sprintf($user->lang['24HOUR_TOPICS'], $activity['topics']),
'24HOUR_POSTS' => sprintf($user->lang['24HOUR_POSTS'], $activity['posts']),
'24HOUR_USERS' => sprintf($user->lang['24HOUR_USERS'], $activity['users']),
));
return true;
}
/**
* Obtain an array of active users over the last 24 hours.
*
* @return array
*/
function obtain_active_user_data()
{
global $cache;
if (($active_users = $cache->get('_active_users')) === false)
{
global $db;
$active_users = array();
// grab a list of users who are currently online
// and users who have visited in the last 24 hours
$sql_ary = array(
'SELECT' => 'u.user_id, u.user_colour, u.username, u.user_type, u.user_allow_viewonline, s.session_viewonline',
'FROM' => array(USERS_TABLE => 'u'),
'LEFT_JOIN' => array(
array(
'FROM' => array(SESSIONS_TABLE => 's'),
'ON' => 's.session_user_id = u.user_id',
),
),
'WHERE' => 'u.user_lastvisit > ' . (time() - 86400) . ' OR s.session_user_id <> ' . ANONYMOUS,
'GROUP_BY' => 'u.user_id',
'ORDER_BY' => 'u.username_clean',
);
$result = $db->sql_query($db->sql_build_query('SELECT', $sql_ary));
while ($row = $db->sql_fetchrow($result))
{
'user_viewonline' => ($row['session_viewonline']) ? $row['session_viewonline'] : $row['user_allow_viewonline'],
'user_id' => $row['user_id'],
'user_type' => $row['user_type'],
'username' => $row['username'],
'user_colour' => $row['user_colour'],
);
}
$db->sql_freeresult($result);
// cache this data for 1 hour, this improves performance
$cache->put('_active_users', $active_users, 3600);
}
return $active_users;
}
/**
* obtained cached 24 hour activity data
*
* @return array
*/
function obtain_activity_data()
{
global $cache;
if (($activity = $cache->get('_activity_mod')) === false)
{
global $db;
// set interval to 24 hours ago
$interval = time() - 86400;
$activity = array();
// total new posts in the last 24 hours
$sql = 'SELECT COUNT(post_id) AS new_posts
FROM ' . POSTS_TABLE . '
WHERE post_time > ' . $interval;
$result = $db->sql_query($sql);
$activity['posts'] = $db->sql_fetchfield('new_posts');
$db->sql_freeresult($result);
// total new topics in the last 24 hours
$sql = 'SELECT COUNT(topic_id) AS new_topics
FROM ' . TOPICS_TABLE . '
WHERE topic_time > ' . $interval;
$result = $db->sql_query($sql);
$activity['topics'] = $db->sql_fetchfield('new_topics');
$db->sql_freeresult($result);
// total new users in the last 24 hours, counts inactive users as well
$sql = 'SELECT COUNT(user_id) AS new_users
FROM ' . USERS_TABLE . '
WHERE user_regdate > ' . $interval;
$result = $db->sql_query($sql);
$activity['users'] = $db->sql_fetchfield('new_users');
$db->sql_freeresult($result);
// cache this data for 1 hour, this improves performance
$cache->put('_activity_mod', $activity, 3600);
}
return $activity;
}
?>
One other question, can you force the cache to refresh on this mod so i can see the hidden users disappear once i have rectified this or do i need to wait 24 hours?
dont suppose you know how to sort the hidden users out?
