Example #1
0
$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 = '&nbsp;';
    }
    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>&nbsp;</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">
	&nbsp;<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">&euro;' . 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 {
Example #4
0
         $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) {
Example #5
0
	<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">&euro;</a></td>
<td>The icon shown at left, a small teal star with a &euro; sign, designates that this user requests for donations.</td>
</tr>
<?php 
}
?>
</tbody>
</table>

<?php 
$HTML->footer(array());
Example #8
0
 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>&nbsp;<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>';
Example #9
0
}
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());