$res_memb = db_query("SELECT users.realname,users.user_id,users.user_name,user_group.admin_flags " . "FROM users,user_group " . "WHERE users.user_id=user_group.user_id " . "AND user_group.group_id={$group_id}");
print '<TABLE WIDTH="100%" BORDER="0">
';
while ($row_memb = db_fetch_array($res_memb)) {
if ($row_memb['admin_flags'] == 'A') {
$img = "trash-x.png";
} else {
$img = "trash.png";
}
if ($is_admin) {
$button = '<INPUT TYPE="IMAGE" NAME="DELETE" SRC="/images/ic/' . $img . '" HEIGHT="16" WIDTH="16" BORDER="0">';
} else {
$button = ' ';
}
print '
<FORM ACTION="' . $PHP_SELF . '" METHOD="POST"><INPUT TYPE="HIDDEN" NAME="func" VALUE="rmuser">' . '<INPUT TYPE="HIDDEN" NAME="rm_id" VALUE="' . $row_memb['user_id'] . '">' . '<INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '">' . '<TR><TD ALIGN="MIDDLE">' . $button . '</TD></FORM>' . '<TD><A href="/users/' . $row_memb['user_name'] . '/">' . $row_memb['realname'] . '</A>' . is_project_donor($row_memb['user_id']) . is_user_donor($row_memb['user_id']) . req_user_donate($row_memb['user_id']) . '</TD></TR>';
}
print '</TABLE>
';
/*
Add member form
*/
if ($is_admin) {
echo '
<HR NOSHADE>
<FORM ACTION="' . $PHP_SELF . '" METHOD="POST">
<INPUT TYPE="hidden" NAME="func" VALUE="adduser">
<INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '">
<TABLE WIDTH="100%" BORDER="0">
<TR><TD><B>Unix Name:</B></TD><TD><INPUT TYPE="TEXT" NAME="form_unix_name" SIZE=10 VALUE=""></TD></TR>
<TR><TD COLSPAN="2" ALIGN="CENTER"><INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="Add User"></TD></TR></FORM>
print '</TABLE>
';
}
$HTML->box1_bottom();
echo '
</TD><TD> </TD><TD width=50%>';
/*
Show the members of this project
*/
$HTML->box1_top("Group Members");
$res_memb = db_query("SELECT users.realname,users.user_id,users.user_name " . "FROM users,user_group " . "WHERE users.user_id=user_group.user_id " . "AND user_group.group_id={$group_id}");
print '<TABLE WIDTH="100%" BORDER="0">
';
while ($row_memb = db_fetch_array($res_memb)) {
print '
<FORM ACTION="/foundry/' . $expl_pathinfo[2] . '/admin/" METHOD="POST"><INPUT TYPE="HIDDEN" NAME="func" VALUE="rmuser">' . '<INPUT TYPE="HIDDEN" NAME="rm_id" VALUE="' . $row_memb['user_id'] . '">' . '<TR><TD ALIGN="MIDDLE"><INPUT TYPE="IMAGE" NAME="DELETE" SRC="/images/ic/trash.png" HEIGHT="16" WIDTH="16" BORDER="0"></TD></FORM>' . '<TD><A href="/users/' . $row_memb['user_name'] . '/">' . $row_memb['realname'] . '</A>' . is_project_donor($row_memb['user_id']) . is_user_donor($row_memb['user_id']) . req_user_donate($row_memb['user_id']) . '</TD></TR>';
}
print '</TABLE>
';
echo '
<TR><TD colspan="2" align="center">
<BR>
<A href="/project/admin/userperms.php?group_id=' . $group_id . '">[Edit Member Permissions]</A>';
$HTML->box1_bottom();
echo '</TD></TR>
<TR valign=top><TD width=50%>';
/*
Tool admin pages
*/
$HTML->box1_top('Tool Admin');
echo "</h3>\n";
} else {
echo " in Status: {$status}</h3>\n";
}
$title_arr = array();
$title_arr[] = 'Login name';
$title_arr[] = 'Amount';
$title_arr[] = 'Status';
$title_arr[] = 'Date';
$title_arr[] = 'Comment';
$title_arr[] = 'Actions';
echo html_build_list_table_top($title_arr);
echo "\n";
for ($i = 0; $i < $rows; $i++) {
print '<tr bgcolor="' . html_get_alt_row_color($i) . '">';
print '<td valign="top"><a href="/users/' . db_result($res, $i, 'user_name') . '">' . db_result($res, $i, 'user_name') . '</a>' . is_project_donor(db_result($res, $i, 'user_id')) . is_user_donor(db_result($res, $i, 'user_id')) . req_user_donate(db_result($res, $i, 'user_id')) . '</td>';
print '<td valign="top" align="right">€' . db_result($res, $i, 'amount') . ',00</td>';
print '<td valign="top" align="middle">' . db_result($res, $i, 'status') . '</td>';
print '<td valign="top">' . date($sys_datefmt, db_result($res, $i, 'add_date')) . '</td>';
print '<td valign="top">' . db_result($res, $i, 'comment') . '</td>';
print '<td valign="top">';
print '<a href="?status=' . $status . '&action=approve&user_id=' . db_result($res, $i, 'user_id') . '&date=' . db_result($res, $i, 'add_date') . '&offset=' . $offset . '">[Approve]</a> ';
print '<a href="?status=' . $status . '&action=delete&user_id=' . db_result($res, $i, 'user_id') . '&date=' . db_result($res, $i, 'add_date') . '&offset=' . $offset . '">[Delete]</a> ';
print '<a href="?status=' . $status . '&action=pending&user_id=' . db_result($res, $i, 'user_id') . '&date=' . db_result($res, $i, 'add_date') . '&offset=' . $offset . '">[Pending]</a>';
print "</td></tr>\n";
}
print "</table>\n";
print '<table><tr><td>';
if ($offset != 0) {
print '<b><a href="?offset=' . ($offset - $donorsperpage) . '">' . html_image("images/t2.gif", "15", "15", array("border" => "0", "align" => "middle")) . ' Newer Donations</a></b>';
} else {
$no_rows = 1;
echo "<H2>No matches found for {$words}</H2>";
echo db_error();
// echo $sql;
} else {
if ($rows_returned > 25) {
$rows = 25;
}
echo "<H3>Search results for {$words}</H3><P>\n\n";
$title_arr = array();
$title_arr[] = 'User Name';
$title_arr[] = 'Real Name';
echo html_build_list_table_top($title_arr);
echo "\n";
for ($i = 0; $i < $rows; $i++) {
print "<TR BGCOLOR=\"" . html_get_alt_row_color($i) . "\"><TD><A HREF=\"/users/" . db_result($result, $i, 'user_name') . "/\">" . html_image("images/msg.gif", "10", "12", array("BORDER" => "0")) . db_result($result, $i, 'user_name') . "</A>" . is_project_donor(db_result($result, $i, 'user_id')) . is_user_donor(db_result($result, $i, 'user_id')) . req_user_donate(db_result($result, $i, 'user_id')) . "</TD>" . "<TD>" . db_result($result, $i, 'realname') . "</TD></TR>\n";
}
echo "</TABLE>\n";
}
} else {
if ($type_of_search == 'forums') {
/*
Query to search within forum messages
*/
$array = explode(" ", $words);
$words1 = implode($array, "%' {$crit} forum.body LIKE '%");
$words2 = implode($array, "%' {$crit} forum.subject LIKE '%");
$sql = "SELECT forum.msg_id,forum.subject,forum.date,users.user_name " . "FROM forum,users " . "WHERE users.user_id=forum.posted_by AND ((forum.body LIKE '%{$words1}%') " . "OR (forum.subject LIKE '%{$words2}%')) AND forum.group_forum_id='{$forum_id}' " . "GROUP BY msg_id,subject,date,user_name";
$result = db_query($sql, 26, $offset);
$rows = $rows_returned = db_numrows($result);
if (!$result || $rows < 1) {
<TD><B><?php print $user_id; ?> </B> ( <A HREF="/people/viewprofile.php?user_id=<?php print $user_id; ?> "><B>Skills Profile</B></A> )</TD> </TR> <TR valign=top> <TD>Login Name: </TD> <TD><B><?php print $user->getUnixName(); ?> </B><?php print is_project_donor($user_id) . is_user_donor($user_id) . req_user_donate($user_id); ?> </TD> </TR> <TR valign=top> <TD>Real Name: </TD> <TD><B><?php print $user->getRealName(); ?> </B></TD> </TR> <TR valign=top> <TD>DevCounter: </TD> <TD>
print 'People to fill ' . '<a href="/people/?group_id=' . $group_id . '">several ' . 'different positions</a>';
}
}
}
print '</TD><TD NoWrap VALIGN="top">';
// ########################### Developers on this project
echo $HTML->box1_top($Language->DEVELOPER_INFO);
if (db_numrows($res_admin) > 0) {
?>
<SPAN CLASS="develtitle"><?php
echo $Language->PROJECT_ADMINS;
?>
:</SPAN><BR>
<?php
while ($row_admin = db_fetch_array($res_admin)) {
print "<A href=\"/users/{$row_admin['user_name']}/\">{$row_admin['user_name']}</A>" . is_project_donor($row_admin[user_id]) . is_user_donor($row_admin[user_id]) . req_user_donate($row_admin[user_id]) . "<BR>";
}
?>
<HR WIDTH="100%" SIZE="1" NoShade>
<?php
}
?>
<SPAN CLASS="develtitle"><?php
echo $Language->DEVELOPERS;
?>
:</SPAN><BR>
<?php
//count of developers on this project
$res_count = db_query("SELECT user_id FROM user_group WHERE group_id={$group_id}");
print db_numrows($res_count);
?>
?>
</td>
</tr>
<?php
if (is_project_donor($user_id) != "") {
?>
<tr><td valign="top"><img src="/images/iconRedStar_16x16.png" alt="Project Donor" border="0" height="16" width="16"></td>
<td>The icon shown at left, a small red star, designates that this user has made a donation to projects.</td>
</tr>
<?php
}
if (is_user_donor($user_id) != "") {
?>
<tr><td valign="top"><img src="/images/iconYellowStar_16x16.png" alt="User Donor" border="0" height="16" width="16"></td>
<td>The icon shown at left, a small yellow star, designates that this user has made a donation to users.</td>
</tr>
<?php
}
if (req_user_donate($user_id) != "") {
?>
<tr><td valign="top"><img src="/images/iconTealStar_16x16.png" alt="User Donate" border="0" height="16" width="16">€</a></td>
<td>The icon shown at left, a small teal star with a € sign, designates that this user requests for donations.</td>
</tr>
<?php
}
?>
</tbody>
</table>
<?php
$HTML->footer(array());
if (db_numrows($res_new) > 20) {
$rows = 20;
} else {
$rows = db_numrows($res_new);
}
print "\t<p><TABLE width=100% cellpadding=0 cellspacing=0 border=0>";
for ($i = 0; $i < $rows; $i++) {
$row_new = db_fetch_array($res_new);
// don't show releases of projects without short description
// 2004-11-16 by helix
// avoid duplicates of different file types
// 2003-04-25 use release id instead of group id by helix
if ($row_new[short_description] && !$G_RELEASE["{$row_new['release_id']}"]) {
print "<TR valign=top>";
print "<TD colspan=2>";
print "<A href=\"/projects/{$row_new['unix_group_name']}/\"><B>{$row_new['group_name']}</B></A>" . req_project_donate($row_new[group_id]) . "\n</TD><TD nowrap><I>Released by: <A href=\"/users/{$row_new['user_name']}/\">" . "{$row_new['user_name']}</A></I>" . is_project_donor($row_new[user_id]) . is_user_donor($row_new[user_id]) . req_user_donate($row_new[user_id]) . "</TD></TR>\n";
print "<TR><TD>Module: {$row_new['module_name']}</TD>\n";
print "<TD>Version: {$row_new['release_version']}</TD>\n";
print "<TD>" . date("M d, h:iA", $row_new[release_date]) . "</TD>\n";
print "</TR>";
print "<TR valign=top>";
print "<TD colspan=2> <BR>";
if ($row_new[short_description]) {
print "<I>{$row_new['short_description']}</I>";
} else {
print "<I>This project has not submitted a description.</I>";
}
// print "<P>Release rating: ";
// print vote_show_thumbs($row_new[filerelease_id],2);
print "</TD>";
print '<TD align=center nowrap border=1>';
}
site_project_header(array('title' => "Project Member List", 'group' => $group_id, 'toptab' => 'memberlist'));
print '<P>If you would like to contribute to this project by becoming a developer,
contact one of the project admins, designated in bold text below.<br><br>';
// list members
// 2003-04-03 select only active users by helix
$query = "SELECT users.user_name AS user_name,users.user_id AS user_id," . "users.realname AS realname, users.add_date AS add_date, " . "user_group.admin_flags AS admin_flags, people_job_category.name AS role " . "FROM users,user_group,people_job_category " . "WHERE users.user_id=user_group.user_id AND user_group.group_id={$group_id} " . "AND user_group.member_role=people_job_category.category_id " . "AND users.status='A' " . "ORDER BY users.user_name";
$title_arr = array();
$title_arr[] = 'Developer';
$title_arr[] = 'Username';
$title_arr[] = 'Role/Position';
$title_arr[] = 'Email';
$title_arr[] = 'Skills';
echo html_build_list_table_top($title_arr);
$res_memb = db_query($query);
while ($row_memb = db_fetch_array($res_memb)) {
print "\t<tr>\n";
print "\t\t";
if (stristr($row_memb['admin_flags'], 'A')) {
print "\t\t<td><b><A href=\"/users/{$row_memb['user_name']}/\">{$row_memb['realname']}</A></b></td>\n";
} else {
print "\t\t<td>{$row_memb['realname']}</td>\n";
}
print "\t\t<td align=\"middle\"><A href=\"/users/{$row_memb['user_name']}/\">{$row_memb['user_name']}</A>" . is_project_donor($row_memb[user_id]) . is_user_donor($row_memb[user_id]) . req_user_donate($row_memb[user_id]) . "</td>\n";
print "\t\t<td align=\"middle\">{$row_memb['role']}</td>\n";
print "\t\t<td align=\"middle\"><A href=\"/sendmessage.php?touser="******"\">" . $row_memb['user_name'] . " at " . $GLOBALS['sys_users_host'] . "</td>\n";
print "\t\t<td align=\"middle\"><A href=\"/people/viewprofile.php?user_id=" . $row_memb['user_id'] . "\">View</a></td>\n";
print "\t<tr>\n";
}
print "\t</table>";
site_project_footer(array());