Menu
▾
▴
[mxbb-commits] core/modules/mx_phpbb3blocks mx_statistics.php, 1.2, 1.3
|
From: FlorinCB <ory...@us...> - 2008-08-27 13:43:17
|
Update of /cvsroot/mxbb/core/modules/mx_phpbb3blocks In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv26377/mx_phpbb3blocks Modified Files: mx_statistics.php Log Message: some rewrites Index: mx_statistics.php =================================================================== RCS file: /cvsroot/mxbb/core/modules/mx_phpbb3blocks/mx_statistics.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** mx_statistics.php 27 Aug 2008 05:22:07 -0000 1.2 --- mx_statistics.php 27 Aug 2008 13:43:10 -0000 1.3 *************** *** 149,153 **** // Top posters SQL // ! $sql = "SELECT user_id, username, user_posts FROM " . USERS_TABLE . " WHERE user_id <> " . ANONYMOUS . " AND user_posts > 0 --- 149,153 ---- // Top posters SQL // ! $sql = "SELECT user_id, username, user_colour, user_posts, user_birthday FROM " . USERS_TABLE . " WHERE user_id <> " . ANONYMOUS . " AND user_posts > 0 *************** *** 162,165 **** --- 162,166 ---- $user_count = $db->sql_numrows($result); $user_data = $db->sql_fetchrowset($result); + $db->sql_freeresult($result); $percentage = 0; $bar_percent = 0; *************** *** 171,174 **** --- 172,177 ---- { do_math($firstcount, $user_data[$i]['user_posts'], $get_db_stats, $percentage, $bar_percent); + + $top_poster_profile = mx_get_username_string('full', $user_data[$i]['user_id'], $user_data[$i]['username'], $user_data[$i]['user_colour']); $template->assign_block_vars('users', array( *************** *** 176,182 **** "CLASS" => ( !( $i + 1 % 2 ) ) ? $theme['td_class2'] : $theme['td_class1'], "USERNAME" => $user_data[$i]['username'], "PERCENTAGE" => $percentage, "BAR" => $bar_percent, ! "URL" => mx_append_sid(PHPBB_URL . "profile.php?mode=viewprofile&u=" . $user_data[$i]['user_id']), "POSTS" => $user_data[$i]['user_posts']) ); --- 179,187 ---- "CLASS" => ( !( $i + 1 % 2 ) ) ? $theme['td_class2'] : $theme['td_class1'], "USERNAME" => $user_data[$i]['username'], + "USERCOLOR" => $user_data[$i]['user_colour'], "PERCENTAGE" => $percentage, "BAR" => $bar_percent, ! "POSTER_URL" => $top_poster_profile, ! "URL" => mx_append_sid(PHPBB_URL . "memberlist.php?mode=viewprofile&u=" . $user_data[$i]['user_id']), "POSTS" => $user_data[$i]['user_posts']) ); *************** *** 326,329 **** --- 331,335 ---- { $row = $db->sql_fetchrow($result); + $db->sql_freeresult($result); $version = $row['mysql_version']; *************** *** 411,416 **** $newest_user = $newest_userdata['username']; $newest_uid = $newest_userdata['user_id']; ! $sql = "SELECT user_regdate ! FROM " . USERS_TABLE . " WHERE user_id = " . $newest_userdata['user_id'] . " LIMIT 1"; --- 417,422 ---- $newest_user = $newest_userdata['username']; $newest_uid = $newest_userdata['user_id']; ! $sql = 'SELECT user_id, username, user_regdate, user_colour, user_birthday ! FROM ' . USERS_TABLE . " WHERE user_id = " . $newest_userdata['user_id'] . " LIMIT 1"; *************** *** 420,425 **** --- 426,434 ---- } $row = $db->sql_fetchrow($result); + $db->sql_freeresult($result); $newest_user_date = $row['user_regdate']; + $newest_user_profile = mx_get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']); //'<a href="' . mx_append_sid(PHPBB_URL . "usercp.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$newest_uid") . '">' . $newest_user . '</a>'; + // // Most Online data *************** *** 434,443 **** } $row = $db->sql_fetchrow($result); $most_users_date = ( $row['config_value'] > 0 ) ? phpBB2::create_date($board_config['default_dateformat'], $row['config_value'], $board_config['board_timezone']) : $lang['Not_available']; ! $row = $db->sql_fetchrow($result); $most_users = ( $row['config_value'] > 0 ) ? $row['config_value'] : $lang['Not_available']; $statistic_array = array($lang['Number_posts'], $lang['Posts_per_day'], $lang['Number_topics'], $lang['Topics_per_day'], $lang['Number_users'], $lang['Users_per_day'], $lang['Board_started'], $lang['Board_Up_Days'], $lang['Database_size'], $lang['Avatar_dir_size'], $lang['Latest_Reg_User_Date'], $lang['Latest_Reg_User'], $lang['Most_Ever_Online_Date'], $lang['Most_Ever_Online'], $lang['Gzip_compression']); ! $value_array = array($total_posts, $posts_per_day, $total_topics, $topics_per_day, $total_users, $users_per_day, $start_date, sprintf('%.2f', $boarddays), $dbsize, $avatar_dir_size, phpBB2::create_date($board_config['default_dateformat'], $newest_user_date, $board_config['board_timezone']), sprintf('<a href="' . mx_append_sid(PHPBB_URL . "profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$newest_uid") . '">' . $newest_user . '</a>'), $most_users_date, $most_users, ( $board_config['gzip_compress'] ) ? $lang['Enabled'] : $lang['Disabled']); // --- 443,453 ---- } $row = $db->sql_fetchrow($result); + $db->sql_freeresult($result); $most_users_date = ( $row['config_value'] > 0 ) ? phpBB2::create_date($board_config['default_dateformat'], $row['config_value'], $board_config['board_timezone']) : $lang['Not_available']; ! $most_users = ( $row['config_value'] > 0 ) ? $row['config_value'] : $lang['Not_available']; $statistic_array = array($lang['Number_posts'], $lang['Posts_per_day'], $lang['Number_topics'], $lang['Topics_per_day'], $lang['Number_users'], $lang['Users_per_day'], $lang['Board_started'], $lang['Board_Up_Days'], $lang['Database_size'], $lang['Avatar_dir_size'], $lang['Latest_Reg_User_Date'], $lang['Latest_Reg_User'], $lang['Most_Ever_Online_Date'], $lang['Most_Ever_Online'], $lang['Gzip_compression']); ! $value_array = array($total_posts, $posts_per_day, $total_topics, $topics_per_day, $total_users, $users_per_day, $start_date, sprintf('%.2f', $boarddays), $dbsize, $avatar_dir_size, phpBB2::create_date($board_config['default_dateformat'], $newest_user_date, $board_config['board_timezone']), sprintf($newest_user_profile), $most_users_date, $most_users, ( $board_config['gzip_compress'] ) ? $lang['Enabled'] : $lang['Disabled']); // |
