//
// Attempt to set up the include path, to fix problems with relative includes
-//require_once('../env.inc.php');
-//require_once('pre.php');
require_once $gfcommon.'include/FusionForge.class.php';
require_once $gfcommon.'include/tag_cloud.php';
function show_features_boxes() {
- GLOBAL $HTML,$sys_use_ratings,$sys_use_frs;
+ GLOBAL $HTML,$sys_use_ratings,$sys_use_frs,$sys_use_project_tags;
- $return = '';
- $return .= $HTML->boxTop(_('Tag Cloud'));
- $return .= '<center>';
- $return .= tag_cloud();
- $return .= '</center>';
- $return .= $HTML->boxMiddle(sprintf(_('%1$s Statistics'), $GLOBALS['sys_name']),0);
+ plugin_hook ("features_boxes_top", array());
+ $return = '<h2 class="skip">' . _('Features Boxes') . '</h2>';
+
+ if ($sys_use_project_tags) {
+ $return .= $HTML->boxTop(_('Tag Cloud'), 'Tag_Cloud');
+ $return .= tag_cloud();
+ $return .= $HTML->boxMiddle(sprintf(_('%1$s Statistics'), $GLOBALS['sys_name']), 'Forge_Statistics');
+ } else {
+ $return .= $HTML->boxTop(sprintf(_('%1$s Statistics'), $GLOBALS['sys_name']), 'Forge_Statistics');
+ }
$return .= show_sitestats();
if ($sys_use_frs) {
- $return .= $HTML->boxMiddle(_('Top Project Downloads'));
+ $return .= $HTML->boxMiddle(_('Top Project Downloads'), 'Top_Projects_Downloads');
$return .= show_top_downloads();
}
if ($sys_use_ratings) {
- $return .= $HTML->boxMiddle(_('Highest Ranked Users'));
+ $return .= $HTML->boxMiddle(_('Highest Ranked Users'), 'Highest_Ranked_Users');
$return .= show_highest_ranked_users();
}
- $return .= $HTML->boxMiddle(_('Most Active This Week'));
+ $return .= $HTML->boxMiddle(_('Most Active This Week'), 'Most_Active_This_Week');
$return .= show_highest_ranked_projects();
- $return .= $HTML->boxMiddle(_('Recently Registered Projects'));
+ $return .= $HTML->boxMiddle(_('Recently Registered Projects'), 'Recently_Registered_Projects');
$return .= show_newest_projects();
- $return .= $HTML->boxBottom(0);
+ $return .= $HTML->boxBottom();
+ plugin_hook ("features_boxes_bottom", array());
return $return;
}
$month = date("Ym",time()-(2*3600*24));
$day = date("d",time()-(2*3600*24));
- $res_topdown = db_query("
+ $return = '' ;
+
+ $res_topdown = db_query_params ('
SELECT groups.group_id,
groups.group_name,
groups.unix_group_name,
frs_dlstats_grouptotal_vw.downloads
FROM frs_dlstats_grouptotal_vw,groups
WHERE
- frs_dlstats_grouptotal_vw.group_id=groups.group_id AND groups.is_public='1' and groups.status='A'
+ frs_dlstats_grouptotal_vw.group_id=groups.group_id AND groups.is_public=1 and groups.status=$1
ORDER BY downloads DESC
- ", 10, 0, SYS_DB_STATS);
+ ',
+ array ('A'),
+ 10);
// echo db_error();
if (db_numrows($res_topdown) == 0) {
return _('No Stats Available');
}
// print each one
- $return = "";
while ($row_topdown = db_fetch_array($res_topdown)) {
- if ($row_topdown['downloads'] > 0)
- $return .= '(' . number_format($row_topdown['downloads']) . ')'
- . util_make_link_g ($row_topdown['unix_group_name'],$row_topdown['group_id'],$row_topdown['group_name'])
- . "<br />\n";
+ if ($row_topdown['downloads'] > 0) {
+ $t_downloads = number_format($row_topdown['downloads']);
+ $t_prj_link = util_make_link_g ($row_topdown['unix_group_name'], $row_topdown['group_id'], $row_topdown['group_name']);
+
+ $return .= '<tr>';
+ $return .= '<td class="width-stat-col1">' . $t_downloads . '</td>';
+ $return .= '<td>' . $t_prj_link . '</td>';
+ $return .= '</tr>';
+ }
}
- $return .= '<div align="center">'.util_make_link ('/top/',_('More')).'</div>';
-
+ if ( $return != "" ) {
+ /* MFaure: test required to deal with a special case encountered on zforge by 20091204 */
+ $t_return = $return;
+ $return = '<table summary="">' . $t_return . "</table>\n";
+ }
+ $return .= '<div class="align-center">' . util_make_link ('/top/', _('All the ranking'), array('class' => 'dot-link')) . '</div>';
+
return $return;
}
function stats_getprojects_active_public() {
- $res_count = db_query("SELECT count(*) AS count FROM groups WHERE status='A' AND is_public=1");
+ $res_count = db_query_params ('SELECT count(*) AS count FROM groups WHERE status=$1 AND is_public=1',
+ array ('A'));
if (db_numrows($res_count) > 0) {
$row_count = db_fetch_array($res_count);
return $row_count['count'];
}
function stats_getprojects_total() {
- $res_count = db_query("SELECT count(*) AS count FROM groups WHERE status='A' OR status='H'");
+ $res_count = db_query_params ('SELECT count(*) AS count FROM groups WHERE status=$1 OR status=$2',
+ array('A',
+ 'H'));
if (db_numrows($res_count) > 0) {
$row_count = db_fetch_array($res_count);
return $row_count['count'];
}
function stats_getpageviews_total() {
- $res_count = db_query("SELECT SUM(site_views) AS site, SUM(subdomain_views) AS subdomain FROM stats_site");
+ $res_count = db_query_params ('SELECT SUM(site_views) AS site, SUM(subdomain_views) AS subdomain FROM stats_site',
+ array());
if (db_numrows($res_count) > 0) {
$row_count = db_fetch_array($res_count);
return ($row_count['site'] + $row_count['subdomain']);
}
function stats_downloads_total() {
- $res_count = db_query("SELECT SUM(downloads) AS downloads FROM stats_site");
+ $res_count = db_query_params ('SELECT SUM(downloads) AS downloads FROM stats_site',
+ array());
if (db_numrows($res_count) > 0) {
$row_count = db_fetch_array($res_count);
return $row_count['downloads'];
function show_sitestats() {
global $sys_use_trove;
$gforge = new FusionForge();
- $return = _('Hosted Projects').': ';
+ $return = '<p>';
+ $return .= _('Hosted Projects').': ';
if ($sys_use_trove) {
$return .= '<a href="softwaremap/full_list.php">';
}
if ($sys_use_trove) {
$return .= '</a>';
}
- $return .= '<br />'._('Registered Users').': <strong>'.
- number_format($gforge->getNumberOfActiveUsers()).'</strong>';
+ $return .= "</p><p>";
+ $return .= _('Registered Users').': <strong>'.number_format($gforge->getNumberOfActiveUsers()).'</strong>';
+ $return .= "</p>\n";
return $return;
}
function show_newest_projects() {
- $sql = "SELECT group_id,unix_group_name,group_name,register_time FROM groups " .
- "WHERE is_public=1 AND status='A' AND type_id=1 AND register_time > 0 " .
- "ORDER BY register_time DESC";
- $res_newproj = db_query($sql,10);
+ $res_newproj = db_query_params ('SELECT group_id,unix_group_name,group_name,register_time FROM groups WHERE is_public=1 AND status=$1 AND type_id=1 AND register_time > 0 ORDER BY register_time DESC', array ('A'), 10);
$return = '';
if (!$res_newproj || db_numrows($res_newproj) < 1) {
return _('No Stats Available')." ".db_error();
} else {
+
+ $return .= '<table summary="">' . "\n";
while ( $row_newproj = db_fetch_array($res_newproj) ) {
- $return .= "<strong>(" . date(_('m/d'),$row_newproj['register_time']) . ")</strong> "
- . util_make_link_g ($row_newproj['unix_group_name'],$row_newproj['group_id'],$row_newproj['group_name'])
- .'<br />';
+
+ $t_prj_date = date(_('m/d'),$row_newproj['register_time']);
+ $t_prj_link = util_make_link_g ($row_newproj['unix_group_name'],$row_newproj['group_id'],$row_newproj['group_name']);
+
+ $return .= "<tr>";
+ $return .= '<td class="width-stat-col1">' . $t_prj_date . "</td>";
+ $return .= '<td>' . $t_prj_link . '</td>';
+ $return .= "</tr>\n";
}
+ $return .= '</table>';
}
- $return .= '<div align="center">'.util_make_link ('/softwaremap/full_list.php','[ '._('More').' ]').'</div>';
+ $return .= '<div class="align-center">'.util_make_link ('/softwaremap/full_list.php', _('All newest projects'), array('class' => 'dot-link')).'</div>';
return $return;
}
function show_highest_ranked_users() {
//select out the users information to show the top users on the site
- $sql="SELECT users.user_name,users.user_id,users.realname,user_metric.metric
- FROM user_metric,users
- WHERE users.user_id=user_metric.user_id AND user_metric.ranking < 11 AND users.status != 'D'
- ORDER BY ranking ASC";
- $res=db_query($sql);
+ $res = db_query_params ('SELECT users.user_name,users.user_id,users.realname,user_metric.metric FROM user_metric,users WHERE users.user_id=user_metric.user_id AND user_metric.ranking < 11 AND users.status != $1 ORDER BY ranking ASC',
+ array ('D')) ;
$rows=db_numrows($res);
if (!$res || $rows<1) {
return _('No Stats Available').db_error();
.'<br />';
}
}
- $return .= '<div align="center">'.util_make_link ('/top/topusers.php','[ '._('More').' ]').'</div>';
+ $return .= '<div class="align-center">'.util_make_link ('/top/topusers.php', _('All users'), array('class' => 'dot-link')).'</div>';
return $return;
}
function show_highest_ranked_projects() {
- $sql="SELECT groups.group_name,groups.unix_group_name,groups.group_id,".
- "project_weekly_metric.ranking,project_weekly_metric.percentile ".
- "FROM groups,project_weekly_metric ".
- "WHERE groups.group_id=project_weekly_metric.group_id ".
- "AND groups.is_public=1 ".
- "AND groups.type_id=1 ".
- "AND groups.status != 'D' ".
- "AND groups.use_stats=1 ".
- "ORDER BY ranking ASC";
- $result=db_query($sql,20);
+ $result = db_query_params ('SELECT groups.group_name,groups.unix_group_name,groups.group_id,project_weekly_metric.ranking,project_weekly_metric.percentile FROM groups,project_weekly_metric WHERE groups.group_id=project_weekly_metric.group_id AND groups.is_public=1 AND groups.type_id=1 AND groups.status != $1 AND groups.use_stats=1 ORDER BY ranking ASC',
+ array ('D'),
+ 20);
if (!$result || db_numrows($result) < 1) {
return _('No Stats Available')." ".db_error();
} else {
- $return='';
+ $return = '<table summary="">';
while ($row=db_fetch_array($result)) {
- $return .= '<strong>('.number_format(substr($row['percentile'],0,5),1).'%)</strong> '
- .util_make_link_g ($row['unix_group_name'],$row['group_id'],$row['group_name'])
- .'<br />';
+ $t_prj_activity = number_format(substr($row['ranking'],0,5),0);
+ $t_prj_link = util_make_link_g ($row['unix_group_name'],$row['group_id'],$row['group_name']);
+
+ $return .= "<tr>";
+ $return .= '<td class="width-stat-col1">'. $t_prj_activity . "</td>";
+ $return .= '<td>' . $t_prj_link . '</td>';
+ $return .= "</tr>\n";
}
- $return .= '<div align="center">'
- .util_make_link ('/top/mostactive.php?type=week','[ '._('More').' ]')
- .'</div>';
+ $return .= "</table>";
+ $return .= '<div class="align-center">' . util_make_link ('/top/mostactive.php?type=week', _('All project activities'), array('class' => 'dot-link')) . '</div>';
+
}
return $return;
}