'; print ' '; while ( $row = db_fetch_array($res) ) { print ' '; } print ' '; } function stats_trove_cat_to_name( $trovecatid ) { $res = db_query(" SELECT fullpath FROM trove_cat WHERE trove_cat_id = '$trovecatid'"); if ( $row = db_fetch_array($res) ) { return $row["fullpath"]; } else { return " ( $trovecatid $Language->getString('stats_site_utils','returned_no_category')) "; } } function stats_generate_trove_grouplist( $trovecatid ) { $results = array(); $res = db_query(" SELECT * FROM trove_group_link WHERE trove_cat_id='$trovecatid'"); print db_error( $res ); $i = 0; while ( $row = db_fetch_array($res) ) { $results[$i++] = $row["group_id"]; } return $results; } function stats_site_projects_form( $report='last_30', $orderby = 'downloads', $projects = 0, $trovecat = 0 ) { global $Language; print '
' . "\n"; } /** * New function to separate out the SQL so it may be reused in other * potential reports. * */ function stats_site_project_result( $report, $orderby, $projects, $trove ) { // // Determine if we are looking at ALL projects, // a trove category, or a specific list // $grp_str=''; /* if ($trove == '-2') { //do a query of ALL groups $grp_str=''; } elseif ($trove == '-1') { //do a query of just a specific list of passed in groups $grp_str=" AND g.group_id IN (" . $projects . ") "; } else { //do a query of $grp_str=" AND EXISTS (SELECT group_id FROM trove_group_link WHERE trove_cat_id ='$trove' AND g.group_id=trove_group_link.group_id) "; } */ if (!$orderby) { $orderby = "group_name"; } if ($report == 'last_30') { $sql = "SELECT g.group_id, g.group_name, SUM(s.downloads) AS downloads, SUM(s.site_views) AS site_views, SUM(s.subdomain_views) AS subdomain_views, SUM(s.msg_posted) AS msg_posted, SUM(s.bugs_opened) AS bugs_opened, SUM(s.bugs_closed) AS bugs_closed, SUM(s.support_opened) AS support_opened, SUM(s.support_closed) AS support_closed, SUM(s.patches_opened) AS patches_opened, SUM(s.patches_closed) AS patches_closed, SUM(s.tasks_opened) AS tasks_opened, SUM(s.tasks_closed) AS tasks_closed, SUM(s.cvs_checkouts) AS cvs_checkouts, SUM(s.cvs_commits) AS cvs_commits, SUM(s.cvs_adds) AS cvs_adds FROM stats_project_vw s, groups g WHERE s.group_id = g.group_id $grp_str GROUP BY g.group_id, g.group_name ORDER BY $orderby DESC "; } else { $sql = "SELECT g.group_id, g.group_name, s.downloads, s.site_views, s.subdomain_views, s.msg_posted, s.bugs_opened, s.bugs_closed, s.support_opened, s.support_closed, s.patches_opened, s.patches_closed, s.tasks_opened, s.tasks_closed, s.cvs_checkouts, s.cvs_commits, s.cvs_adds FROM stats_project_all_vw s, groups g WHERE s.group_id = g.group_id $grp_str ORDER BY $orderby DESC "; } return db_query( $sql, 30, 0, SYS_DB_STATS); } function stats_site_projects( $report, $orderby, $projects, $trove ) { global $Language; $i=0; $offset=0; $trove_cat=0; $res=stats_site_project_result( $report, $orderby, $projects, $trove ); // if there are any rows, we have valid data (or close enough). if ( db_numrows( $res ) > 1 ) { ?>getText('stats_site_utils','group_name'); ?> | getText('stats_site_utils','page_views'); ?> | getText('stats_site_utils','downloads'); ?> | getText('stats_site_utils','bugs'); ?> | getText('stats_site_utils','support'); ?> | getText('stats_site_utils','patches'); ?> | getText('stats_site_utils','all_trkr'); ?> | getText('stats_site_utils','tasks'); ?> | getText('stats_site_utils','cvs'); ?> | ||||||||
getText('stats_site_utils','site'); ?> | getText('stats_site_utils','subdomain'); ?> | getText('stats_site_utils','total'); ?> | getText('stats_site_utils','opn'); ?> | getText('stats_site_utils','cls'); ?> | getText('stats_site_utils','opn'); ?> | getText('stats_site_utils','cls'); ?> | getText('stats_site_utils','opn'); ?> | getText('stats_site_utils','cls'); ?> | getText('stats_site_utils','opn'); ?> | getText('stats_site_utils','cls'); ?> | getText('stats_site_utils','opn'); ?> | getText('stats_site_utils','cls'); ?> | getText('stats_site_utils','cos'); ?> | getText('stats_site_utils','comms'); ?> | getText('stats_site_utils','adds'); ?> | ' . ($i + 1) . '. ' . $row["group_name"] . ' | ' . '' . number_format( $row["site_views"],0 ) . ' | ' . '' . number_format( $row["subdomain_views"],0 ) . ' | ' . '' . number_format( $row["downloads"],0 ) . ' | ' . '' . number_format( $row["bugs_opened"],0 ) . ' | ' . '' . number_format( $row["bugs_closed"],0 ) . ' | ' . '' . number_format( $row["support_opened"],0 ) . ' | ' . '' . number_format( $row["support_closed"],0 ) . ' | ' . '' . number_format( $row["patches_opened"],0 ) . ' | ' . '' . number_format( $row["patches_closed"],0 ) . ' | ' . '' . number_format( $row["artifacts_opened"],0 ) . ' | ' . '' . number_format( $row["artifacts_closed"],0 ) . ' | ' . '' . number_format( $row["tasks_opened"],0 ) . ' | ' . '' . number_format( $row["tasks_opened"],0 ) . ' | ' . '' . number_format( $row["cvs_checkouts"],0 ) . ' | ' . '' . number_format( $row["cvs_commits"],0 ) . ' | ' . '' . number_format( $row["cvs_adds"],0 ) . ' | ' . '' . "\n"; $i++; $sum = stats_util_sum_array( $sum, $row ); } ?>
getText('stats_site_utils','statistics_for_the_past_days',array($valid_days)); ?>
getText('stats_site_utils','day'); ?> | getText('stats_site_utils','site_views'); ?> | getText('stats_site_utils','subdomain_views'); ?> | getText('stats_site_utils','downloads'); ?> | getText('stats_site_utils','bugs'); ?> | getText('stats_site_utils','support'); ?> | getText('stats_site_utils','patches'); ?> | getText('stats_site_utils','tasks'); ?> | getText('stats_site_utils','cvs'); ?> | ' . gmstrftime("%d %b %Y", mktime(0,0,1,substr($row["month"],4,2),$row["day"],substr($row["month"],0,4)) ) . ' | ' . '' . number_format( $row["site_page_views"],0 ) . ' | ' . '' . number_format( $row["subdomain_views"],0 ) . ' | ' . '' . number_format( $row["downloads"],0 ) . ' | ' . '' . number_format($row["bugs_opened"],0) . " (" . number_format($row["bugs_closed"],0) . ') | ' . '' . number_format($row["support_opened"],0) . " (" . number_format($row["support_closed"],0) . ') | ' . '' . number_format($row["patches_opened"],0) . " (" . number_format($row["patches_closed"],0) . ') | ' . '' . number_format($row["tasks_opened"],0) . " (" . number_format($row["tasks_closed"],0) . ') | ' . '' . number_format($row["cvs_checkouts"],0) . " (" . number_format($row["cvs_commits"],0) . ') | ' . '' . "\n"; } ?>
getText('stats_site_utils','statistics_for_the_past_months',array($valid_months)); ?>
getText('stats_site_utils','month'); ?>Month | getText('stats_site_utils','site_views'); ?> | getText('stats_site_utils','subdomain_views'); ?> | getText('stats_site_utils','downloads'); ?> | getText('stats_site_utils','bugs'); ?> | getText('stats_site_utils','support'); ?> | getText('stats_site_utils','patches'); ?> | getText('stats_site_utils','all_trkr'); ?> | getText('stats_site_utils','tasks'); ?> | getText('stats_site_utils','cvs'); ?> | ' . $row['month'] . ' | ' . '' . number_format( $row["site_page_views"],0 ) . ' | ' . '' . number_format( $row["subdomain_views"],0 ) . ' | ' . '' . number_format( $row["downloads"],0 ) . ' | ' . '' . number_format($row["bugs_opened"],0) . " (" . number_format($row["bugs_closed"],0) . ') | ' . '' . number_format($row["support_opened"],0) . " (" . number_format($row["support_closed"],0) . ') | ' . '' . number_format($row["patches_opened"],0) . " (" . number_format($row["patches_closed"],0) . ') | ' . '' . number_format($row["artifacts_opened"],0) . " (" . number_format($row["artifacts_closed"],0) . ') | ' . '' . number_format($row["tasks_opened"],0) . " (" . number_format($row["tasks_closed"],0) . ') | ' . '' . number_format($row["cvs_checkouts"],0) . " (" . number_format($row["cvs_commits"],0) . ') | ' . '' . "\n"; } ?>
getText('stats_site_utils','current_statistic_all_time'); ?>
getText('stats_site_utils','site_views'); ?> | getText('stats_site_utils','subdomain_views'); ?> | getText('stats_site_utils','downloads'); ?> | getText('stats_site_utils','developers'); ?> | getText('stats_site_utils','projects'); ?> |