4 * Project Members Information
6 * SourceForge: Breaking Down the Barriers to Open Source Development
7 * Copyright 1999-2001 (c) VA Linux Systems
8 * http://sourceforge.net
15 require_once('pre.php');
17 if (!$group_id && $form_grp) {
18 $group_id = $form_grp;
21 site_project_header(array('title'=>"Project Member List",'group'=>$group_id,'toptab'=>'memberlist'));
23 print $Language->getText('project_memberlist', 'joining');
27 SELECT users.user_name AS user_name,users.user_id AS user_id,
28 users.realname AS realname, users.add_date AS add_date,
29 user_group.admin_flags AS admin_flags,
30 people_job_category.name AS role
31 FROM users,user_group,people_job_category
32 WHERE users.user_id=user_group.user_id
33 AND user_group.group_id='$group_id'
34 AND user_group.member_role=people_job_category.category_id
36 ORDER BY users.user_name
41 $title_arr[]='Developer';
42 $title_arr[]='Username';
43 $title_arr[]='Role/Position';
45 $title_arr[]='Skills';
47 echo html_build_list_table_top ($title_arr);
49 $res_memb = db_query($query);
50 while ( $row_memb=db_fetch_array($res_memb) ) {
53 if ( trim($row_memb[admin_flags])=='A' ) {
54 print "\t\t<td><b><A href=\"/users/$row_memb[user_name]/\">$row_memb[realname]</A></b></td>\n";
56 print "\t\t<td>$row_memb[realname]</td>\n";
58 print "\t\t<td align=\"middle\"><A href=\"/users/$row_memb[user_name]/\">$row_memb[user_name]</A></td>\n";
59 print "\t\t<td align=\"middle\">$row_memb[role]</td>\n";
60 print "\t\t<td align=\"middle\"><A href=\"/sendmessage.php?touser=".$row_memb['user_id'].
61 "\">".$row_memb['user_name']." at users.".$GLOBALS['sys_users_host']."</td>\n";
62 print "\t\t<td align=\"middle\"><A href=\"/people/viewprofile.php?user_id=".
63 $row_memb['user_id']."\">View</a></td>\n";
68 site_project_footer(array());