public function getContent()
{
$request =& HTTPRequest::instance();
$group_id = $request->get('group_id');
if ($GLOBALS['sys_use_trove'] != 0) {
trove_getcatlisting($group_id, 0, 1);
}
}
if ($i_proj > ($page - 1) * $TROVE_BROWSELIMIT && $i_proj <= $page * $TROVE_BROWSELIMIT) {
$viewthisrow = 1;
} else {
$viewthisrow = 0;
}
if ($row_grp && $viewthisrow) {
print '<table border="0" cellpadding="0" width="100%"><tr valign="top"><td colspan="2"><span style="font-family:arial,helvetica">';
print '$i_proj. ' . util_make_link('/projects/' . strtolower($row_grp['unix_group_name']) . '/', '<strong>' . htmlspecialchars($row_grp['group_name']) . '</strong> ');
if ($row_grp['short_description']) {
print "- " . htmlspecialchars($row_grp['short_description']);
}
print '<br /> ';
// extra description
print '</span></td></tr><tr valign="top"><td><span style="font-family:arial,helvetica">';
// list all trove categories
print trove_getcatlisting($row_grp['group_id'], 1, 0);
print '</span></td>' . "\n" . '<td align="right"><span style="font-family:arial,helvetica">';
// now the right side of the display
print 'Activity Percentile: <strong>' . number_format($row_grp['percentile'], 2) . '</strong>';
print '<br />Activity Ranking: <strong>' . number_format($row_grp['ranking'], 2) . '</strong>';
print '<br />Register Date: <strong>' . date(_('Y-m-d H:i'), $row_grp['register_time']) . '</strong>';
print '</span></td></tr>';
print '</table>';
print '<hr />';
}
// end if for row and range chacking
}
// print bottom navigation if there are more projects to display
if ($querytotalcount > $TROVE_BROWSELIMIT) {
print $html_limit;
}
<TABLE WIDTH="100%" BORDER="0">
<TR><TD WIDTH="75%" VALIGN="top">
<?php
// ########################################## top area, not in box
$res_admin = db_query("SELECT users.user_id AS user_id,users.user_name AS user_name " . "FROM users,user_group " . "WHERE user_group.user_id=users.user_id AND user_group.group_id={$group_id} AND " . "user_group.admin_flags = 'A'");
if ($project->getStatus() == 'H') {
print "<P>NOTE: This project entry is maintained by the " . $GLOBALS['sys_default_name'] . " staff. We are not " . "the official site " . "for this product. Additional copyright information may be found on this project's homepage.\n";
}
if ($project->getDescription()) {
print "<P>" . $project->getDescription();
} else {
print "<P>This project has not yet submitted a description.";
}
// trove info
print '<BR> <BR>';
trove_getcatlisting($group_id, 0, 1);
//print '<BR> ';
// Get the activity percentile
$actv = db_query("SELECT percentile FROM project_weekly_metric WHERE group_id='{$group_id}'");
$actv_res = db_result($actv, 0, "percentile");
if (!$actv_res) {
$actv_res = 0;
}
print "Registered: " . date($sys_datefmt, $project->getStartDate());
print '<br>Activity Percentile (last week): ' . $actv_res . '%';
print '<br>View project activity <a href="/project/stats/?group_id=' . $group_id . '">statistics</a>';
print '<br>View project web <a href="http://' . $project->getUnixName() . '.berlios.de/usage">statistics</a>';
print '<br>View list of <a href="/export/rss_project.php?group_id=' . $group_id . '">RSS feeds</a> available for this project';
$jobs_res = db_query("SELECT name " . "FROM people_job,people_job_category " . "WHERE people_job.category_id=people_job_category.category_id " . "AND people_job.status_id=1 " . "AND group_id='{$group_id}' " . "GROUP BY name", 2);
if ($jobs_res) {
$num = db_numrows($jobs_res);
// ########################################## top area, not in box
$res_admin = db_query("SELECT users.user_id,users.user_name,users.realname,user_group.admin_flags\n\tFROM users,user_group\n\tWHERE user_group.user_id=users.user_id\n\tAND user_group.group_id='{$group_id}'\n\tAND users.status='A'\n\tORDER BY admin_flags DESC,realname");
if ($project->getStatus() == 'H') {
print "<p>" . sprintf(_('NOTE: This project entry is maintained by the %1$s staff. We are not the official site for this product. Additional copyright information may be found on this project\'s homepage.'), $GLOBALS['sys_name']) . "</p>\n";
}
$hook_params = array();
$hook_params['group_id'] = $group_id;
plugin_hook("project_before_description", $hook_params);
if ($project->getDescription()) {
print "<p>" . nl2br($project->getDescription()) . '</p>';
} else {
print "<p>" . _('This project has not yet submitted a description.') . '</p>';
}
if ($GLOBALS['sys_use_trove']) {
print "<br />\n";
print stripslashes(trove_getcatlisting($group_id, 0, 1));
}
// registration date
print _('Registered: ') . date(_('Y-m-d H:i'), $project->getStartDate());
// Get the activity percentile
// CB hide stats if desired
if ($project->usesStats()) {
$actv = db_query("SELECT percentile FROM project_weekly_metric WHERE group_id='{$group_id}'");
$actv_res = db_result($actv, 0, "percentile");
if (!$actv_res) {
$actv_res = 0;
}
print '<br />' . _('Activity Percentile: ') . substr($actv_res, 0, 5) . '%';
print '<br />' . sprintf(_('View project <a href="%1$s" >Statistics</a> or <a href="%2$s">Activity</a>'), util_make_url('/project/stats/?group_id=' . $group_id), util_make_url('/project/report/?group_id=' . $group_id));
print '<br />' . sprintf(_('View list of <a href="%1$s">RSS feeds</a> available for this project.</a>'), util_make_url('/export/rss_project.php?group_id=' . $group_id)) . ' ' . html_image('ic/rss.png', 16, 16, array('border' => '0'));
}