[flash=,:1i1ykqrk]http://www.apota.co.uk/mrc/stuff/stats.jpg[/flash:1i1ykqrk]
Here is the original script
- Code: Select all
#-----[ OPEN ]------------------------------------------#index.php ##-----[ FIND ]------------------------------------------# // Start add - Last visit MOD 'USERS_TODAY_LIST' => $users_today_list, ##-----[ AFTER ADD ]------------------------------------------# 'L_ONLINE_MEMBERS' => $lang['Online_Members_P'], ##-----[ OPEN ]------------------------------------------#portal.php ##-----[ FIND ]------------------------------------------#// End session management ##-----[ AFTER ADD ]------------------------------------------#color_groups_setup_list_portal(); ##-----[ FIND ]------------------------------------------#// End add - Last visit MOD ##-----[ AFTER ADD ]------------------------------------------#{$today_registered_users = 0;$yesterday_registered_users = 0; $today_time = time();$yesterday_time = $today_time - 86400; $day = create_date('d', $yesterday_time, $userdata['user_timezone']);$month = create_date('m', $yesterday_time, $userdata['user_timezone']);$year = create_date('Y', $yesterday_time, $userdata['user_timezone']); $y_day_from = strtotime($year.'-'.$month.'-'.$day.' 00:00:00'); $day = create_date('d', $today_time, $userdata['user_timezone']);$month = create_date('m', $today_time, $userdata['user_timezone']);$year = create_date('Y', $today_time, $userdata['user_timezone']); $t_day_from = strtotime($year.'-'.$month.'-'.$day.' 00:00:00'); $sql = "SELECT count(distinct user_id) as total_users FROM " . USERS_TABLE . " WHERE user_regdate >= $y_day_from AND user_regdate < $t_day_from AND user_id <ANONYMOUS>sql_query($sql) ){ message_die(GENERAL_ERROR, 'Could not get yesterday registered users', '', __LINE__, __FILE__, $sql);} while ( $row = $db->sql_fetchrow($result) ){ $yesterday_registered_users = $row['total_users'];} $db->sql_freeresult($result); $sql = "SELECT count(distinct user_id) as total_users FROM " . USERS_TABLE . " WHERE user_regdate >= $t_day_from AND user_id <ANONYMOUS>sql_query($sql) ){ message_die(GENERAL_ERROR, 'Could not get yesterday registered users', '', __LINE__, __FILE__, $sql);} while ( $row = $db->sql_fetchrow($result) ){ $today_registered_users = $row['total_users'];} $db->sql_freeresult($result);} ##-----[ FIND ]------------------------------------------#// End add - Photo Album Block $template->assign_vars(array( ##-----[ AFTER ADD ]------------------------------------------# // Live Statistik on Portal 'P_NEWEST_USER' => sprintf($lang['Newest_user_plus'], '<a>', $newest_user, '</a>'), 'TODAY_USERS' => $today_registered_users, 'P_TOTAL_USERS' => $total_users, 'YESTERDAY_USERS' => $yesterday_registered_users, 'GUESTS_ONLINE' => $guests_online, 'REGGED_ONLINE' => $logged_visible_online, 'P_TOTAL_POSTS' => $total_posts, 'L_LIVE_STATS' => $lang['Live_Statistics'], 'L_MEMBERS' => $lang['Top_Member'], 'L_LATEST' => $lang['Latest_Member'], 'L_NEW_TODAY' => $lang['New_Today'], 'L_NEW_YESTERDAY' => $lang['New_Yesterday'], 'L_MEMBERS_OVERALL' => $lang['Members_Overall'], 'L_ONLINE_NOW' => $lang['Online_Now'], 'L_GUESTS' => $lang['Guests_P'], 'L_STATS' => $lang['Box_Stats'], 'L_USER_RECORD' => $lang['User_Record'], 'L_TOTAL_POSTS' => $lang['Total_Posts'], 'L_ONLINE_MEMBERS' => $lang['Online_Members_P'], 'RECORD_USERS_P' => sprintf($board_config['record_online_users'], create_date($board_config['default_dateformat'], $board_config['record_online_date'], $board_config['board_timezone'])), 'ONLINE_USERLIST_P' => $online_userlist, ##-----[ OPEN ]------------------------------------------#page_header.php ##-----[ FIND ]------------------------------------------# // Start replacement - Topic in Who is online MOD if ($plus_config['index_layout'] == 'index_body_plus.tpl') { $online_userlist = $online_userlist; } else { $online_userlist = $lang['Registered_users'].' ' . $online_userlist; } // End replacement - Topic in Who is online MOD ##-----[ REPLACE, WITH ]------------------------------------------# // Start replacement - Topic in Who is online MOD /* if ($plus_config['index_layout'] == 'index_body_plus.tpl') { $online_userlist = $online_userlist; } else { $online_userlist = $lang['Registered_users'].' ' . $online_userlist; } */ $online_userlist = $online_userlist; // End replacement - Topic in Who is online MOD ##-----[ OPEN ]------------------------------------------#includes/functions_color_groups.php ##-----[ FIND ]------------------------------------------#function color_group_colorize_name($user_id, $no_profile = false) ##-----[ BEFORE, ADD ]------------------------------------------#function color_groups_setup_list_portal(){ global $lang, $template, $db, $plus_config; $sql = 'SELECT * FROM ' . COLOR_GROUPS_TABLE . ' WHERE hidden = 0 ORDER BY order_num ASC'; if (!$result = $db->sql_query($sql)) message_die(GENERAL_ERROR, $lang['Error_Group_Table'], '', __LINE__, __FILE__, $sql); $list = ''; { while ($row = $db->sql_fetchrow($result)) { $list .= ' [ <span>' . $row['group_name'] . '</span> ] <br>'; } } $template->assign_var('COLOR_GROUPS_LIST', $list);} ##-----[ OPEN ]------------------------------------------#index_body.tpl ##-----[ FIND ]------------------------------------------#{LOGGED_IN_USER_LIST}</span></td> ##-----[ REPLACE, WITH ]------------------------------------------#{L_ONLINE_MEMBERS}: {LOGGED_IN_USER_LIST}</span></td> ##-----[ OPEN ]------------------------------------------#portal_body.tpl ##-----[ FIND ]------------------------------------------## Add somewhere or after#<table><tr><td><img></td><td><img></td><td><img></td></tr></table><br> ##-----[ AFTER ADD ]------------------------------------------#<table><tr><th>{L_LIVE_STATS}</th></tr><tr><td><img> <strong><span>{L_MEMBERS}:</span></strong><br><img> <span>{L_LATEST}: {P_NEWEST_USER}<br><img> {L_NEW_TODAY}: <strong>{TODAY_USERS}</strong><br><img> {L_NEW_YESTERDAY}: <strong>{YESTERDAY_USERS}</strong><br><img> {L_MEMBERS_OVERALL}: <strong>{P_TOTAL_USERS}</span></strong><br></td></tr><tr><td><img> <strong><span>{L_ONLINE_NOW}:</span></strong><br><img> <span>{L_GUESTS}: <strong>{GUESTS_ONLINE}</strong><br><img> {L_MEMBERS}: <strong>{REGGED_ONLINE}</strong></span></td></tr><tr><td><img> <strong><span> {L_STATS}:</span></strong><br><span>{L_USER_RECORD}: <strong>{RECORD_USERS_P}</strong><br>{L_TOTAL_POSTS}: <strong>{P_TOTAL_POSTS}</strong><br>{GOOGLE_VISIT_COUNTER}<br></span></td></tr><tr><td><img> <strong><span> {L_ONLINE_MEMBERS}:</span></strong><br><span>{ONLINE_USERLIST_P}</span></td></tr><tr><td><span>{COLOR_GROUPS_LIST}</span></td></tr></table><table><tr><td><img></td><td><img></td><td><img></td></tr></table><br> ##-----[ FIND ]------------------------------------------## If "Who is Online" box still installed#{LOGGED_IN_USER_LIST}<br><br> ##-----[ REPLACE, WITH ]------------------------------------------#<b>{L_ONLINE_MEMBERS}</b></b>: {LOGGED_IN_USER_LIST}<br><br> ##-----[ SAVE/CLOSE ALL FILES ]------------------------------------------## EoM
Here's what I tried
- Code: Select all
<php>sql_query($sql) ){ message_die(GENERAL_ERROR, 'Could not get yesterday registered users', '', __LINE__, __FILE__, $sql);} while ( $row = $db->sql_fetchrow($result) ){ $yesterday_registered_users = $row['total_users'];} $db->sql_freeresult($result); $sql = "SELECT count(distinct user_id) as total_users FROM " . USERS_TABLE . " WHERE user_regdate >= $t_day_from AND user_id <ANONYMOUS>sql_query($sql) ){ message_die(GENERAL_ERROR, 'Could not get yesterday registered users', '', __LINE__, __FILE__, $sql);} while ( $row = $db->sql_fetchrow($result) ){ $today_registered_users = $row['total_users'];} $db->sql_freeresult($result);}$template->assign_vars(array('P_NEWEST_USER' => sprintf($lang['Newest_user_plus'], '<a>', $newest_user, '</a>'),'L_ONLINE_MEMBERS' => $lang['Online_Members_P'], 'TODAY_USERS' => $today_registered_users, 'P_TOTAL_USERS' => $total_users, 'YESTERDAY_USERS' => $yesterday_registered_users, 'GUESTS_ONLINE' => $guests_online, 'REGGED_ONLINE' => $logged_visible_online, 'P_TOTAL_POSTS' => $total_posts, 'L_LIVE_STATS' => $lang['Live_Statistics'], 'L_MEMBERS' => $lang['Top_Member'], 'L_LATEST' => $lang['Latest_Member'], 'L_NEW_TODAY' => $lang['New_Today'], 'L_NEW_YESTERDAY' => $lang['New_Yesterday'], 'L_MEMBERS_OVERALL' => $lang['Members_Overall'], 'L_ONLINE_NOW' => $lang['Online_Now'], 'L_GUESTS' => $lang['Guests_P'], 'L_STATS' => $lang['Box_Stats'], 'L_USER_RECORD' => $lang['User_Record'], 'L_TOTAL_POSTS' => $lang['Total_Posts'], 'L_ONLINE_MEMBERS' => $lang['Online_Members_P'], 'RECORD_USERS_P' => sprintf($board_config['record_online_users'], create_date($board_config['default_dateformat'], $board_config['record_online_date'], $board_config['board_timezone'])), 'ONLINE_USERLIST_P' => $online_userlist) ); // Start replacement - Topic in Who is online MOD /* if ($plus_config['index_layout'] == 'index_body_plus.tpl') { $online_userlist = $online_userlist; } else { $online_userlist = $lang['Registered_users'].' ' . $online_userlist; } */ $online_userlist = $online_userlist; // End replacement - Topic in Who is online MOD function color_groups_setup_list_portal(){ global $lang, $template, $db, $plus_config; $sql = 'SELECT * FROM ' . COLOR_GROUPS_TABLE . ' WHERE hidden = 0 ORDER BY order_num ASC'; if (!$result = $db->sql_query($sql)) message_die(GENERAL_ERROR, $lang['Error_Group_Table'], '', __LINE__, __FILE__, $sql); $list = ''; { while ($row = $db->sql_fetchrow($result)) { $list .= ' [ <span>' . $row['group_name'] . '</span> ] <br>'; } } $template->assign_var('COLOR_GROUPS_LIST', $list);} } imp_live_stats_func(); ?>
Please help