6 * SourceForge: Breaking Down the Barriers to Open Source Development
7 * Copyright 1999-2001 (c) VA Linux Systems
8 * http://sourceforge.net
12 require_once $gfwww.'news/news_utils.php';
13 require_once $gfwww.'include/trove.php';
14 require_once $gfwww.'include/project_summary.php';
15 require_once $gfcommon.'include/tag_cloud.php';
17 $title = _('Project Info');
19 site_project_header(array('title'=>$title,'group'=>$group_id,'toptab'=>'home'));
22 // ########################################### end top area
27 <table width="100%" border="0">
29 <td width="80%" valign="top">
32 // ########################################## top area, not in box
34 $res_admin = db_query("SELECT users.user_id,users.user_name,users.realname,user_group.admin_flags
36 WHERE user_group.user_id=users.user_id
37 AND user_group.group_id='$group_id'
39 ORDER BY admin_flags DESC,realname");
41 if ($project->getStatus() == 'H') {
42 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";
45 $hook_params = array () ;
46 $hook_params['group_id'] = $group_id ;
47 plugin_hook ("project_before_description",$hook_params) ;
49 if ($project->getDescription()) {
50 print "<p>" . nl2br($project->getDescription()) . '</p>';
52 print "<p>" . _('This project has not yet submitted a description.') . '</p>';
58 if ($GLOBALS['sys_use_project_tags']) {
59 $list_tag = list_project_tag($group_id);
61 print '<p>' . _('Tags').': '. $list_tag . '</p>';
64 $project =& group_get_object($group_id);
65 $perm =& $project->getPermission(session_get_user());
66 if ($perm->isAdmin()) {
67 print '<p><a href="/project/admin/editgroupinfo.php?group_id=' . $group_id . '" >' . _('No tag defined for this project') . '</a>.</p>';
70 print '<p>' . _('No tag defined for this project') . '</p>';
75 if($GLOBALS['sys_use_trove']) {
77 print stripslashes(trove_getcatlisting($group_id,0,1,1));
81 print(_('Registered: ') . date(_('Y-m-d H:i'), $project->getStartDate()));
83 // Get the activity percentile
84 // CB hide stats if desired
85 if ($project->usesStats()) {
86 $actv = db_query("SELECT ranking FROM project_weekly_metric WHERE group_id='$group_id'");
87 $actv_res = db_result($actv,0,"ranking");
91 print '<br />'.sprintf (_('Activity Ranking: %d'). $actv_res) ;
92 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));
93 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'));
96 if($GLOBALS['sys_use_people']) {
97 $jobs_res = db_query("SELECT name
98 FROM people_job,people_job_category
99 WHERE people_job.category_id=people_job_category.category_id
100 AND people_job.status_id=1
101 AND group_id='$group_id'
104 $num=db_numrows($jobs_res);
106 print '<br /><br />';
108 ngettext('HELP WANTED: This project is looking for a <a href="%1$s">"%2$s"</a>.',
109 'HELP WANTED: This project is looking for people to fill <a href="%1$s">several different positions</a>.',
111 util_make_url ('/people/?group_id='.$group_id),
112 db_result($jobs_res,0,"name"));
116 $hook_params = array () ;
117 $hook_params['group_id'] = $group_id ;
118 plugin_hook ("project_after_description",$hook_params) ;
122 <td nowrap="nowrap" valign="top" width="20%">
126 // ########################### Developers on this project
128 echo $HTML->boxTop(_('Developer Info'));
130 if (db_numrows($res_admin) > 0) {
133 <span class="develtitle"><?php echo _('Project Admins'); ?>:</span><br />
135 $started_developers = false;
136 while ($row_admin = db_fetch_array($res_admin)) {
137 if (trim($row_admin['admin_flags']) != 'A' && !$started_developers) {
138 $started_developers=true;
139 echo '<span class="develtitle">'. _('Developers').':</span><br />';
141 echo util_make_link_u ($row_admin['user_name'],$row_admin['user_id'],$row_admin['realname']).'<br />';
144 <hr width="100%" size="1" />
151 <p><?php echo util_make_link ('/project/memberlist.php?group_id='.$group_id,'['._('View Members').']'); ?></p>
152 <p><?php echo util_make_link ('/project/request.php?group_id='.$group_id,'['._('Request to join').']'); ?></p>
155 echo $HTML->boxBottom();
166 // ############################# File Releases
168 // CB hide FRS if desired
169 if ($project->usesFRS()) {
170 echo $HTML->boxTop(_('Latest File Releases'));
171 $unix_group_name = $project->getUnixName();
174 <table cellspacing="1" cellpadding="5" width="100%" border="0">
176 <td style="text-align:left">
179 <td style="text-align:center">
182 <td style="text-align:center">
185 <td style="text-align:center">
186 '._('Notes').' / '._('Monitor').'
188 <td style="text-align:center">
194 // Members of projects can see all packages
195 // Non-members can only see public packages
197 if (session_loggedin()) {
198 if (user_ismember($group_id) || user_ismember(1,'A')) {
201 $pub_sql=' AND frs_package.is_public=1 ';
204 $pub_sql=' AND frs_package.is_public=1 ';
207 $sql="SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date
208 FROM frs_package,frs_release
209 WHERE frs_package.package_id=frs_release.package_id
210 AND frs_package.group_id='$group_id'
211 AND frs_release.status_id=1
213 ORDER BY frs_package.package_id,frs_release.release_date DESC";
215 $res_files = db_query($sql);
216 $rows_files=db_numrows($res_files);
217 if (!$res_files || $rows_files < 1) {
220 echo '<tr><td colspan="5"><strong>'._('This Project Has Not Released Any Files').'</strong></td></tr>';
224 This query actually contains ALL releases of all packages
225 We will test each row and make sure the package has changed before printing the row
227 for ($f=0; $f<$rows_files; $f++) {
228 if (db_result($res_files,$f,'package_id')==db_result($res_files,($f-1),'package_id')) {
229 //same package as last iteration - don't show this release
231 $rel_date = getdate(db_result($res_files,$f,'release_date'));
233 <tr style="text-align:center">
234 <td style="text-align:left">
235 <strong>' . db_result($res_files,$f,'package_name'). '</strong></td>';
236 // Releases to display
237 print '<td>'.db_result($res_files,$f,'release_name') .'
239 <td>' . $rel_date["month"] . ' ' . $rel_date["mday"] . ', ' . $rel_date["year"] . '</td>
240 <td><a href="'.util_make_url ('/frs/shownotes.php?group_id=' . $group_id . '&release_id=' . db_result($res_files,$f,'release_id')) . '">';
241 echo html_image('ic/manual16c.png','15','15',array('alt'=>_('Release Notes')));
242 echo '</a> - <a href="'.util_make_url ('/frs/monitor.php?filemodule_id=' . db_result($res_files,$f,'package_id') . '&group_id='.$group_id.'&start=1').'">';
243 echo html_image('ic/mail16d.png','15','15',array('alt'=>_('Monitor this package')));
246 <td>'.util_make_link ('/frs/?group_id=' . $group_id . '&release_id=' . db_result($res_files,$f,'release_id'),_('Download')).'</td></tr>';
252 <div style="text-align:center">
253 <?php echo util_make_link ('/frs/?group_id='.$group_id,'['._('View All Project Files').']'); ?>
256 echo $HTML->boxBottom();
261 <table width="100%" border="0" cellpadding="0" cellspacing="0">
263 <td valign="top" width="50%">
267 // ############################## PUBLIC AREAS
268 echo $HTML->boxTop(_('Public Areas'));
270 // ################# Homepage Link
272 print '<a href="http://' . $project->getHomePage() . '">';
273 print html_image('ic/home16b.png','20','20',array('alt'=>_('Home Page')));
274 print ' '._('Project Home Page').'</a>';
276 // ################## ArtifactTypes
278 // CB hide tracker if desired
279 if ($project->usesTracker()) {
280 print '<hr size="1" /><a href="'.util_make_url ('/tracker/?group_id='.$group_id).'">';
281 print html_image('ic/tracker20g.png','20','20',array('alt'=>_('Tracker')));
282 print _('Tracker').'</a>';
284 $result=db_query("SELECT agl.*,aca.count,aca.open_count
285 FROM artifact_group_list agl
286 LEFT JOIN artifact_counts_agg aca USING (group_artifact_id)
287 WHERE agl.group_id='$group_id'
289 ORDER BY group_artifact_id ASC");
291 $rows = db_numrows($result);
293 if (!$result || $rows < 1) {
294 echo '<br /><em>'._('There are no public trackers available').'</em>';
298 for ($j = 0; $j < $rows; $j++) {
300 print util_make_link ('/tracker/?atid='. db_result($result, $j, 'group_artifact_id') . '&group_id='.$group_id.'&func=browse',db_result($result, $j, 'name')) . ' ' ;
301 .sprintf(ngettext('(<strong>%1$s</strong> open / <strong>%2$s</strong> total)', '(<strong>%1$s</strong> open / <strong>%2$s</strong> total)', (int) db_result($result, $j, 'open_count')), (int) db_result($result, $j, 'open_count'), (int) db_result($result, $j, 'count')) .'<br />'.
302 db_result($result, $j, 'description');
309 // ################## forums
311 if ($project->usesForum()) {
312 print '<hr size="1" /><a href="'.util_make_url ('/forum/?group_id='.$group_id).'">';
313 print html_image('ic/forum20g.png','20','20',array('alt'=>_('Forums')));
314 print ' '._('Public Forums').'</a> ( ';
315 $messages_count = project_get_public_forum_message_count($group_id);
316 $forums_count = project_get_public_forum_count($group_id);
317 printf(ngettext("<strong>%d</strong> message","<strong>%d</strong> messages",$messages_count),$messages_count);
319 printf(ngettext("<strong>%d</strong> forum","<strong>%d</strong> forums",$forums_count),$forums_count);
323 // ##################### Doc Manager
325 if ($project->usesDocman()) {
328 <a href="'.util_make_url ('/docman/?group_id='.$group_id).'">';
329 print html_image('ic/docman16b.png','20','20',array('alt'=>_('Docs')));
330 print ' '._('DocManager: Project Documentation').'</a>';
333 // ##################### Mailing lists
335 if ($project->usesMail()) {
336 print '<hr size="1" /><a href="'.util_make_url ('/mail/?group_id='.$group_id).'">';
337 print html_image('ic/mail16b.png','20','20',array('alt'=>_('Lists')));
338 print ' '._('Mailing Lists').'</a>';
339 $n = project_get_mail_list_count($group_id);
340 printf(ngettext('(<strong>%1$s</strong> public mailing list)', '(<strong>%1$s</strong> public mailing lists)', $n), $n);
343 // ##################### Task Manager
345 if ($project->usesPm()) {
346 print '<hr size="1" /><a href="'.util_make_url ('/pm/?group_id='.$group_id).'">';
347 print html_image('ic/taskman20g.png','20','20',array('alt'=>_('Tasks')));
348 print ' '._('Task Manager').'</a>';
349 $sql="SELECT * FROM project_group_list WHERE group_id='$group_id' AND is_public=1";
350 $result = db_query ($sql);
351 $rows = db_numrows($result);
352 if (!$result || $rows < 1) {
353 echo '<br /><em>'._('There are no public subprojects available').'</em>';
356 for ($j = 0; $j < $rows; $j++) {
358 print util_make_link ('/pm/task.php?group_project_id='.db_result($result, $j, 'group_project_id').'&group_id='.$group_id.'&func=browse',db_result($result, $j, 'project_name'));
365 // ######################### Surveys
367 if ($project->usesSurvey()) {
368 print '<hr size="1" /><a href="'.util_make_url ('/survey/?group_id='.$group_id).'">';
369 print html_image('ic/survey16b.png','20','20',array('alt'=>_('Surveys')));
370 print " "._('Surveys')."</a>";
371 echo ' ( <strong>'. project_get_survey_count($group_id) .'</strong> '._('surveys').' )';
374 // ######################### SCM
376 if ($project->usesSCM()) {
377 print '<hr size="1" /><a href="'.util_make_url ('/scm/?group_id='.$group_id).'">';
378 print html_image('ic/cvs16b.png','20','20',array('alt'=>_('SCM')));
379 print " "._('SCM Repository')."</a>";
383 SELECT sum(commits) AS commits,sum(adds) AS adds
385 WHERE group_id='$group_id'
386 ", -1, 0, SYS_DB_STATS);
387 $cvs_commit_num = db_result($result,0,0);
388 $cvs_add_num = db_result($result,0,1);
389 if (!$cvs_commit_num) {
396 $hook_params = array () ;
397 $hook_params['group_id'] = $group_id ;
398 plugin_hook ("scm_stats", $hook_params) ;
401 // ######################### Plugins
403 $hook_params = array ();
404 $hook_params['group_id'] = $group_id;
405 plugin_hook ("project_public_area", $hook_params);
407 // ######################## AnonFTP
409 // CB hide FTP if desired
410 if ($project->usesFTP()) {
411 if ($project->isActive()) {
412 print '<hr size="1" />';
413 print '<a href="ftp://' . $project->getUnixName() . '.' . $GLOBALS['sys_default_domain'] . '/pub/'. $project->getUnixName() .'/">';
414 print html_image('ic/ftp16b.png','20','20',array('alt'=>_('Anonymous FTP Space')));
415 print _('Anonymous FTP Space')."</a>";
420 plugin_hook("cal_link_group",$group_id);
421 echo $HTML->boxBottom();
423 if ($project->usesNews()) {
428 <td width="15"> </td>
429 <td valign="top" width="50%">
432 // ############################# Latest News
434 echo $HTML->boxTop(_('Latest News'));
436 echo news_show_latest($group_id,10,false);
438 echo $HTML->boxBottom();
442 // Linked projects (hierarchy)
445 plugin_hook('project_home_link',$group_id);
454 site_project_footer(array());
458 // c-file-style: "bsd"