Example #1
0
    $res = db_query("\n                SELECT *\n                FROM prweb_vhost\n                WHERE vhostid='{$vhostid}'\n        ");
    $row = db_fetch_array($res);
    $res_vh = db_query("\n\t\tSELECT vhost_name\n\t\tFROM prweb_vhost\n\t\tWHERE vhost_name='" . $row['vhost_name'] . "'\n\t\tAND vhostid!='{$vhostid}'\n\t\tAND state='1'\n\t");
    if ($res_vh && db_numrows($res_vh) < 1) {
        $res_up = db_query("\n\t\t\tUPDATE prweb_vhost\n\t\t\tSET state='1'\n\t\t\tWHERE vhostid='{$vhostid}'\n\t\t\tAND group_id='{$group_id}'\n\t\t");
        if (!$res_up || db_affected_rows($res_up) < 1) {
            $feedback .= "Could not update Virtual Host entry:" . db_error();
        } else {
            $feedback .= "Virtual Host undeleted";
            $group->addHistory('Virtual Host ' . $row['vhost_name'] . ' Undeleted', '');
        }
    } else {
        $feedback .= "Virtual Hostname already in use - " . $row['vhost_name'];
    }
}
project_admin_header(array('title' => 'Editing Virtual Host Info', 'group' => $group_id, 'pagename' => 'project_admin_vhost', 'sectionvals' => array(group_getname($group_id))));
?>

<h2>Virtual Host Admin</h2>

<h3>Add New Virtual Host</h3>
<p>
To add a new virtual host - simply point a <b>CNAME</b> for <i>yourhost.org</i> at
<b>www.<?php 
echo $GLOBALS['sys_default_domain'];
?>
</b>. <?php 
echo $GLOBALS['sys_default_name'];
?>
 does not currently host mail (i.e. cannot be an MX)
or DNS</b>.  
                        /*
                        	Add a user to this project
                        	They don't need unix access
                        */
                        if (!$foundry->addUser($form_unix_name)) {
                            $feedback .= $foundry->getErrorMessage();
                        } else {
                            $feedback = ' User Added Successfully ';
                        }
                    }
                }
            }
        }
    }
}
project_admin_header(array('title' => group_getname($group_id) . " - Foundry Admin", 'group' => $group_id));
/*
	Show the list of member projects
*/
echo '<TABLE width=100% cellpadding=2 cellspacing=2 border=0>
<TR valign=top><TD width=50%>';
$HTML->box1_top("Featured Projects");
$sql = "SELECT groups.group_name,groups.unix_group_name,groups.group_id,foundry_preferred_projects.rank " . "FROM groups,foundry_preferred_projects " . "WHERE foundry_preferred_projects.group_id=groups.group_id " . "AND foundry_preferred_projects.foundry_id='{$group_id}' " . "ORDER BY rank ASC";
$res_grp = db_query($sql);
$rows = db_numrows($res_grp);
if (!$res_grp || $rows < 1) {
    echo 'No Projects';
    echo db_error();
} else {
    print '<TABLE WIDTH="100%" BORDER="0">
';
Example #3
0
<?php

//
// SourceForge: Breaking Down the Barriers to Open Source Development
// Copyright 1999-2000 (c) The SourceForge Crew
// http://sourceforge.net
//
// $Id: index.php,v 1.2 2003/11/13 11:29:25 helix Exp $
require 'pre.php';
require '../people/people_utils.php';
people_header(array('title' => 'Help Wanted System'));
if ($group_id) {
    echo '<H3>Project Help Wanted for ' . group_getname($group_id) . '</H3>
	<P>
	Here is a list of positions available for this project.
	<P>';
    echo people_show_project_jobs($group_id);
} else {
    if ($category_id) {
        echo '<H3>Projects looking for ' . people_get_category_name($category_id) . '</H3>
		<P>
		Click job titles for more detailed descriptions.
		<P>';
        echo people_show_category_jobs($category_id);
    } else {
        echo '
	<H3>Projects Needing Help</H3>
	The ' . $GLOBALS['sys_default_name'] . ' Project Help Wanted board is for non-commercial, project
	volunteer openings. Commercial use is prohibited.
	<P>
	Project listings remain live for two weeks, or until closed by the
Example #4
0
		<TR>
			<TD  COLSPAN="3">
				<B>The following tables show which statuses, technicians, and categories you can include in your filter.
			</TD>
		</TR>
		<TR>
			<TD  VALIGN="TOP"><?php 
    ShowResultSet($result, "Bug Techs for " . group_getname($group_id));
    ?>
</TD>
			<TD  VALIGN="TOP"><?php 
    ShowResultSet($result2, "Bug Statuses");
    ?>
</TD>
			<TD  VALIGN="TOP"><?php 
    ShowResultSet($result3, "Bug Categories for " . group_getname($group_id));
    ?>
</TD>
		<TR>
		<TR>
			<TD  VALIGN="TOP"><?php 
    ShowResultSet($result4, "Bug Resolutions");
    ?>
</TD>
			<TD  VALIGN="TOP"><?php 
    ShowResultSet($result5, "Bug Groups");
    ?>
</TD>
			<TD>&nbsp;</TD>
		</TR>
	</TABLE>
Example #5
0
}
$pluginname = 'taskboard';
$group_id = getStringFromRequest('group_id');
if (!$group_id) {
    exit_error(_('Cannot Process your request : No ID specified'), 'home');
} else {
    $group = group_get_object($group_id);
    if (!$group) {
        exit_no_group();
    }
    if (!$group->usesPlugin($pluginname)) {
        //check if the group has the plugin active
        exit_error(sprintf(_('First activate the %s plugin through the Project\'s Admin Interface'), $pluginname), 'home');
    }
    $taskboard = new TaskBoardHtml($group);
    $taskboard->header(array('title' => 'Taskboard for ' . $group->getPublicName(), 'pagename' => "Taskboard", 'sectionvals' => array(group_getname($group_id)), 'group' => $group_id));
    if ($taskboard->isError()) {
        exit_error($taskboard->getErrorMessage());
    } else {
        if (count($taskboard->getUsedTrackersIds()) == 0) {
            exit_error(_('Choose at least one tracker for using with taskboard.'));
        }
        $columns = $taskboard->getColumns();
        $user_stories_tracker = $taskboard->getUserStoriesTrackerID();
        $columns_number = count($columns) + ($user_stories_tracker ? 1 : 0);
        $column_width = intval(100 / $columns_number);
        ?>

<div id="messages" class="warning" style="display: none;"></div>
<br/>
Example #6
0
patch_header(array('title' => 'Modify a Patch'));
$sql = "SELECT * FROM patch WHERE patch_id='{$patch_id}' AND group_id='{$group_id}'";
$result = db_query($sql);
if (db_numrows($result) > 0) {
    echo '
	<H2>[ Patch #' . $patch_id . ' ] ' . db_result($result, 0, 'summary') . '</H2>';
    echo '
	<FORM ACTION="' . $PHP_SELF . '" METHOD="POST" enctype="multipart/form-data">
	<INPUT TYPE="HIDDEN" NAME="func" VALUE="postmodpatch">
	<INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '">
	<INPUT TYPE="HIDDEN" NAME="patch_id" VALUE="' . $patch_id . '">

	<TABLE WIDTH="100%">
	<TR>
		<TD><B>Submitted By:</B><BR>' . user_getname(db_result($result, 0, 'submitted_by')) . '</TD>
		<TD><B>Group:</B><BR>' . group_getname($group_id) . '</TD>
	</TR>

	<TR>
		<TD><B>Date Submitted:</B><BR>
		' . date($sys_datefmt, db_result($result, 0, 'open_date')) . '
		</TD>
		<TD><FONT SIZE="-1">
		<INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="Submit Changes">
		</TD>
	</TR>

	<TR>
		<TD><B>Category:</B><BR>';
    echo patch_category_box($group_id, 'patch_category_id', db_result($result, 0, 'patch_category_id'));
    echo '
Example #7
0
// $Id: index.php,v 1.3 2004/01/13 13:15:24 helix Exp $
require 'pre.php';
require '../forum/forum_utils.php';
if ($group_id) {
    forum_header(array('title' => 'Forums for ' . group_getname($group_id)));
    if (user_isloggedin() && user_ismember($group_id)) {
        $public_flag = '0,1';
    } else {
        $public_flag = '1';
    }
    $sql = "SELECT g.group_forum_id,g.forum_name, g.description, count(*) as total " . " FROM forum_group_list g " . " LEFT JOIN forum f USING (group_forum_id) " . " WHERE g.group_id='{$group_id}' AND g.is_public IN ({$public_flag})" . " group by g.group_forum_id, g.forum_name, g.description";
    //echo "<p>$sql\n";
    $result = db_query($sql);
    $rows = db_numrows($result);
    if (!$result || $rows < 1) {
        echo '<H1>No forums found for ' . group_getname($group_id) . '</H1>';
        echo db_error();
        forum_footer(array());
        exit;
    }
    echo '<H2>Discussion Forums</H2>
		<P>Choose a forum and you can browse, search, and post messages.<P>';
    /*
    	Put the result set (list of forums for this group) into a column with folders
    */
    for ($j = 0; $j < $rows; $j++) {
        echo '<A HREF="forum.php?forum_id=' . db_result($result, $j, 'group_forum_id') . '">' . html_image("images/ic/cfolder15.png", "15", "13", array("BORDER" => "0")) . '&nbsp;' . db_result($result, $j, 'forum_name') . '</A> ';
        //message count
        echo '(' . db_result($result, $j, 'total') . ' msgs)';
        echo "<BR>\n";
        echo db_result($result, $j, 'description') . '<P>';
Example #8
0
if (!$offset || $offset < 0 || !is_numeric($offset)) {
    $offset = 0;
}
if (!$limit || $limit < 0 || $limit > 50 || !is_numeric($limit)) {
    $limit = 50;
}
$result = db_query($sql, $limit + 1, $offset);
$rows = db_numrows($result);
$more = 0;
if ($rows > $limit) {
    $rows = $limit;
    $more = 1;
}
if ($rows < 1) {
    if ($group_id) {
        echo '<h2>' . sprintf(_('No News Found For %s'), group_getname($group_id)) . '</h2>';
    } else {
        echo '<h2>' . _('No News Found') . '</h2>';
    }
    echo '
		<p>' . _('No items were found') . '</p>';
    echo db_error();
} else {
    echo '<table width="100%" border="0">
		<tr><td valign="top">';
    for ($j = 0; $j < $rows; $j++) {
        echo '
		<a href="' . util_make_url('/forum/forum.php?forum_id=' . db_result($result, $j, 'forum_id')) . '">' . html_image("ic/cfolder15.png", "15", "13", array("border" => "0")) . ' &nbsp;' . stripslashes(db_result($result, $j, 'summary')) . '</a> ';
        echo '
		<br />';
    }
Example #9
0
require '../mail/mail_utils.php';
if ($group_id) {
    mail_header(array('title' => 'Mailing Lists for ' . group_getname($group_id)));
    if (user_isloggedin() && user_ismember($group_id)) {
        $public_flag = '0,1';
    } else {
        $public_flag = '1';
    }
    echo '
		<H2>Mailing Lists for ' . group_getname($group_id) . '</H2>';
    $sql = "SELECT * FROM mail_group_list WHERE group_id='{$group_id}' AND is_public IN ({$public_flag})";
    $result = db_query($sql);
    $rows = db_numrows($result);
    if (!$result || $rows < 1) {
        echo '
			<H1>No Lists found for ' . group_getname($group_id) . '</H1>';
        echo '
			<P>Project administrators use the admin link to request mailing lists.';
        $HTML->footer(array());
        exit;
    }
    echo "<P>Mailing lists provided via a " . $GLOBALS['sys_default_name'] . " version of " . "<A href=\"http://www.list.org\">GNU Mailman</A>. " . "Thanks to the Mailman and <A href=\"http://www.python.org\">Python</A> " . "crews for excellent software.";
    echo "<P>Choose a list to browse, search, and post messages.<P>\n";
    /*
    	Put the result set (list of mailing lists for this group) into a column with folders
    */
    echo "<table WIDTH=\"100%\" border=0>\n" . "<TR><TD VALIGN=\"TOP\">\n";
    for ($j = 0; $j < $rows; $j++) {
        echo '<A HREF="https://' . $GLOBALS['sys_lists_host'];
        if (db_result($result, $j, 'is_public') == 1) {
            echo '/pipermail/';
Example #10
0
function html_a_group($grp)
{
    print '<A /project/?group_id=' . $grp . '>' . group_getname($grp) . '</A>';
}
Example #11
0
<?php

//
// BerliOS: Fostering Open Source Development
// Copyright 2000-20040 (c) The BerliOS Crew
// http://www.berlios.de
//
// $Id $
require 'pre.php';
require '../wiki/wiki_utils.php';
if ($group_id) {
    wiki_header(array('title' => 'Wikis for ' . group_getname($group_id)));
    echo '
		<H2>Wikis for ' . group_getname($group_id) . '</H2>';
    echo '<p>' . html_image("images/ic/cfolder15.png", "15", "13", array("BORDER" => "0")) . '&nbsp;' . '<a href="http://openfacts.berlios.de/index-en.phtml?title=' . urlencode(group_getname($group_id)) . '">English</a>';
    echo '<p>' . html_image("images/ic/cfolder15.png", "15", "13", array("BORDER" => "0")) . '&nbsp;' . '<a href="http://openfacts.berlios.de/index.phtml?title=' . urlencode(group_getname($group_id)) . '">Deutsch</a>';
    echo '<p>' . html_image("images/ic/cfolder15.png", "15", "13", array("BORDER" => "0")) . '&nbsp;' . '<a href="http://openfacts.berlios.de/index-es.phtml?title=' . urlencode(group_getname($group_id)) . '">Español</a>';
    wiki_footer(array());
} else {
    exit_no_group();
}
Example #12
0
        global $group_id;
        $rows = db_numrows($result);
        $cols = db_numfields($result);
        $title_arr = array();
        $title_arr[] = 'Survey ID';
        $title_arr[] = 'Survey Title';
        echo html_build_list_table_top($title_arr);
        for ($j = 0; $j < $rows; $j++) {
            echo "<tr BGCOLOR=\"" . html_get_alt_row_color($j) . "\">\n";
            echo "<TD><A HREF=\"survey.php?group_id={$group_id}&survey_id=" . db_result($result, $j, "survey_id") . "\">" . sprintf("%06d", db_result($result, $j, "survey_id")) . "</A></TD>";
            for ($i = 1; $i < $cols; $i++) {
                printf("<TD WIDTH=\"99%%\">%s</TD>\n", db_result($result, $j, $i));
            }
            echo "</tr>";
        }
        echo "</table>";
        //</TD></TR></TABLE>");
    }
    $sql = "SELECT survey_id,survey_title FROM surveys WHERE group_id='{$group_id}' AND is_active='1'";
    $result = db_query($sql);
    if (!$result || db_numrows($result) < 1) {
        echo "<H2>This Group Has No Active Surveys</H2>";
        echo db_error();
    } else {
        echo "<H2>Surveys for " . group_getname($group_id) . "</H2>";
        ShowResultsGroupSurveys($result);
    }
    survey_footer(array());
} else {
    exit_no_group();
}
Example #13
0
                if (!$result || db_affected_rows($result) < 1) {
                    echo db_error();
                    $feedback .= ' ERROR doing update ';
                } else {
                    $feedback .= ' NewsByte Updated. ';
                }
            }
            /*
            	Show the list_queue
            */
            $approve = '';
            $list_queue = 'y';
        }
    }
    project_admin_header(array('title' => group_getname($group_id) . ' - Foundry NewsBytes Admin', 'group' => $group_id));
    echo '<h2>Foundry: ' . group_getname($group_id) . ' - NewsByte Admin<h2>
';
    if ($approve) {
        /*
        	Show the submit form
        */
        $sql = "SELECT groups.unix_group_name,groups.group_name," . "news_bytes.* " . "FROM news_bytes,groups WHERE id='{$id}' " . "AND news_bytes.group_id = groups.group_id ";
        $result = db_query($sql);
        if (db_numrows($result) < 1) {
            exit_error('Error', 'Error - not found');
        }
        echo '
		<H3>Approve a NewsByte</H3>
		<P>
		<FORM ACTION="' . $PHP_SELF . '" METHOD="POST">
		<INPUT TYPE="HIDDEN" NAME="news_id" VALUE="' . db_result($result, 0, 'id') . '">
Example #14
0
    } else {
        /*
        	Just browse the bugs in this group
        */
        $sql = "SELECT bug.group_id,bug.priority,bug.bug_id,bug.summary,bug.date,users.user_name AS submitted_by," . "user2.user_name AS assigned_to_user," . "bug.category_id," . "bug.bug_group_id," . "bug_category.category_name," . "bug_group.group_name," . "bug_status.status_name " . "FROM bug,bug_category,bug_group,bug_status,users,users user2 " . "WHERE users.user_id=bug.submitted_by " . "AND bug.status_id <> '3' " . "AND user2.user_id=bug.assigned_to " . "AND bug_category.bug_category_id=bug.category_id " . "AND bug_group.bug_group_id=bug.bug_group_id " . "AND bug_status.status_id=bug.status_id " . "AND bug.group_id='{$group_id}' " . "AND bug_id!='100'" . $order_by;
        //       		echo "<p>Group Query: $sql\n";
    }
} else {
    /*
    	Use the query from the form post
    */
    $sql = "SELECT bug.group_id,bug.priority,bug.bug_id,bug.summary,bug.date,users.user_name AS submitted_by," . "user2.user_name AS assigned_to_user," . "bug.category_id," . "bug.bug_group_id," . "bug_category.category_name," . "bug_group.group_name," . "bug_status.status_name " . "FROM bug,bug_category,bug_group,bug_status,users,users user2 " . "WHERE users.user_id=bug.submitted_by " . " {$status_str} {$assigned_str} {$bug_group_str} {$category_str} " . "AND user2.user_id=bug.assigned_to " . "AND bug_category.bug_category_id=bug.category_id " . "AND bug_group.bug_group_id=bug.bug_group_id " . "AND bug_status.status_id=bug.status_id " . "AND bug.group_id='{$group_id}' " . "AND bug_id!='100'" . $order_by;
    //	echo "<p>Form Query: $sql\n";
}
$result = db_query($sql, 51, $offset);
if ($result && db_numrows($result) > 0) {
    echo "<h3>{$statement}</H3>";
    //create a new $set string to be used for next/prev button
    if ($set == 'custom') {
        $set .= '&_assigned_to=' . $_assigned_to . '&_status=' . $_status . '&_category=' . $_category . '&_bug_group=' . $_bug_group;
    }
    show_buglist($result, $offset, $set);
    echo '<P>* Denotes Bugs > 30 Days Old';
    show_priority_colors_key();
    $url = "/bugs/?group_id={$group_id}&set={$set}&order=";
    echo '<P>Click a column heading to sort by that column, or <A HREF="' . $url . 'priority">Sort by Priority</A>';
} else {
    echo "<H3>{$statement}</H3>\n\n\t\t<H2>No Matching Bugs Found for " . group_getname($group_id) . " or filters too restrictive</H2>";
    echo db_error();
}
bug_footer(array());
Example #15
0
            $feedback .= "Operation failed. Password and Password Confirm are not the same";
        }
    } else {
        $feedback .= "Operation failed. Password less than 8 characters";
    }
}
if ($deletedbconfirm) {
    //schedule for deletion
    $res = db_query("\n\t\tUPDATE prdb_dbs \n\t\tSET state=3 \n\t\tWHERE dbid='{$dbid}'\n\t\tAND group_id='{$group_id}'\n\t");
    if (!$res || db_affected_rows($res) < 1) {
        $feedback .= 'Cannot delete database: ' . db_error();
    } else {
        $feedback .= "Database scheduled for deletion";
    }
}
project_admin_header(array('title' => 'Editing Database Info', 'group' => $group_id, 'pagename' => 'project_admin_database', 'sectionvals' => array(group_getname($group_id))));
if ($deletedb == 1) {
    print "<hr><b><center><font color=\"red\">Click to confirm deletion of DB {$dbname}</font> [ <a href=\"" . $PHP_SELF . "?deletedbconfirm=1&group_id=" . $group_id . "&dbid={$dbid}\">CONFIRM DELETE</a> ] </center></b> <hr>";
}
print "<H2>Database Admin</H2>\n";
$res_db = db_query("\n\tSELECT * \n\tFROM prdb_types \n\tWHERE dbsoftware NOT IN (\n\t\tSELECT dbsoftware \n\t\tFROM prdb_dbs,prdb_types \n\t\tWHERE dbtypeid=dbtype \n\t\tAND group_id={$group_id}\n\t\tAND state IN (1,2,3,4)\n\t)\n");
if (db_numrows($res_db) > 0) {
    print '
		<h3>Add New Database</h3>
		<p>
		<i>Clicking on "create" will schedule the creation of the database, and email the
		details to the project administrators.</i>

		<p>
		<b>Database Type:</b>
		<p>
Example #16
0
<?php

//
// SourceForge: Breaking Down the Barriers to Open Source Development
// Copyright 1999-2000 (c) The SourceForge Crew
// http://sourceforge.net
//
// $Id: index.php,v 1.2 2004/01/13 13:15:25 helix Exp $
require 'pre.php';
require 'screenshots_utils.php';
if ($group_id) {
    screenshots_header(array('title' => 'Screenshots'));
    echo "<h2>Screenshots</h2>\n";
    $sql = "SELECT id,description FROM db_images WHERE group_id='{$group_id}'";
    $result = db_query($sql);
    $rows = db_numrows($result);
    if ($rows < 1) {
        echo "<h2>No Screenshots Found";
        echo " For " . group_getname($group_id) . "</h2>\n";
    } else {
        for ($j = 0; $j < $rows; $j++) {
            echo '
			<a href="/dbimage.php?id=' . db_result($result, $j, 'id') . '">' . '<img src="/images/ic/frame_image.png" border="0"> ' . db_result($result, $j, 'description') . '</a>';
            echo '<br>
			';
        }
    }
    screenshots_footer(array());
} else {
    exit_no_group();
}
Example #17
0
    $result = db_query("SELECT users.user_id AS user_id,users.user_name AS user_name,users.realname AS realname,users.email AS email,users.status AS status " . "FROM users,user_group " . "WHERE users.user_id=user_group.user_id AND " . "user_group.group_id={$group_id} {$where_status} ORDER BY users.user_name");
    show_users_list($result, $status, $user_name_search);
    /*
            	Show a form so a user can be added to this group
    */
    ?>
	<hr>
	<P>
	<form action="<?php 
    echo $PHP_SELF;
    ?>
" method="post">
	<input type="HIDDEN" name="action" VALUE="add_to_group">
	<input name="user_id" type="TEXT" value="">
	<p>
	Add User to Group (<?php 
    print group_getname($group_id);
    ?>
):
	<br>
	<input type="HIDDEN" name="group_id" VALUE="<?php 
    print $group_id;
    ?>
">
	<p>
	<input type="submit" name="Submit" value="Submit">
	</form>

	<?php 
}
$HTML->footer(array());
Example #18
0
    echo '
		<H2>Submit News For ' . group_getname($group_id) . '</H2>
		<P>
		You can post news about your project if you are an admin on your project. 
		You may also post "help wanted" notes if your project needs help.
		<P>
		All posts <B>for your project</B> will appear instantly on your project 
		summary page. Posts that are of special interest to the community will 
		have to be approved by a member of the news team before they will appear 
		on the ' . $GLOBALS['sys_default_name'] . ' home page.
		<P>
		You may include URLs, but not HTML in your submissions.
		<P>
		URLs that start with http:// are made clickable.
		<P>
		<FORM ACTION="' . $PHP_SELF . '" METHOD="POST">
		<INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '">
		<B>For Project: ' . group_getname($group_id) . '</B>
		<INPUT TYPE="HIDDEN" NAME="post_changes" VALUE="y">
		<P>
		<B>Subject:</B><BR>
		<INPUT TYPE="TEXT" NAME="summary" VALUE="" SIZE="30" MAXLENGTH="60">
		<P>
		<B>Details:</B><BR>
		<TEXTAREA NAME="details" ROWS="5" COLS="50" WRAP="SOFT"></TEXTAREA><BR>
		<INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="SUBMIT">
		</FORM>';
    news_footer(array());
} else {
    exit_not_logged_in();
}
Example #19
0
    /*
    	Feature Requests for this User
    */
    $last_group = 0;
    echo $HTML->box1_middle('My Feature Requests', false, false);
    $sql = "SELECT groups.group_name,feature.group_id,feature.feature_id,feature.priority,feature.summary \n\t\tFROM feature,groups \n\t\tWHERE feature.feature_status_id = '1' \n\t\tAND (feature.assigned_to='" . user_getid() . "' \n\t\tOR feature.submitted_by='" . user_getid() . "') \n\t\tAND groups.group_id=feature.group_id \n\t\tORDER BY groups.group_name ASC";
    $result = db_query($sql, 100);
    $rows = db_numrows($result);
    if (!$result || $rows < 1) {
        echo '
		<TR><TD COLSPAN="2"><B>No open feature requests are assigned to you or were submitted by you</B></TD></TR>';
    } else {
        for ($i = 0; $i < $rows; $i++) {
            if (db_result($result, $i, 'group_id') != $last_group) {
                echo '
				<TR><TD COLSPAN="2"><B><A HREF="/feature/?group_id=' . db_result($result, $i, 'group_id') . '">' . group_getname(db_result($result, $i, 'group_id')) . '</A></TD></TR>';
            }
            echo '
			<TR BGCOLOR="' . get_priority_color(db_result($result, $i, 'priority')) . '"><TD><A HREF="/feature/?func=detailfeature&group_id=' . db_result($result, $i, 'group_id') . '&feature_id=' . db_result($result, $i, 'feature_id') . '">' . sprintf("%06d", db_result($result, $i, 'feature_id')) . '</A></TD>' . '<TD WIDTH="99%">' . stripslashes(db_result($result, $i, 'summary')) . '</TD></TR>';
            $last_group = db_result($result, $i, 'group_id');
        }
    }
    /*
    	Forums that are actively monitored
    */
    $last_group = 0;
    echo $HTML->box1_middle('Monitored Forums', false, false);
    $sql = "SELECT groups.group_name,groups.group_id,forum_group_list.group_forum_id,forum_group_list.forum_name " . "FROM groups,forum_group_list,forum_monitored_forums " . "WHERE groups.group_id=forum_group_list.group_id " . "AND forum_group_list.group_forum_id=forum_monitored_forums.forum_id " . "AND forum_monitored_forums.user_id='" . user_getid() . "' ORDER BY group_name DESC";
    $result = db_query($sql);
    $rows = db_numrows($result);
    if (!$result || $rows < 1) {
Example #20
0
<?php

//
// SourceForge: Breaking Down the Barriers to Open Source Development
// Copyright 1999-2000 (c) The SourceForge Crew
// http://sourceforge.net
//
// $Id: index.php,v 1.4 2004/01/13 13:15:25 helix Exp $
require 'pre.php';
require '../pm/pm_utils.php';
if ($group_id) {
    pm_header(array('title' => 'Projects for ' . group_getname($group_id)));
    if (user_isloggedin() && user_ismember($group_id)) {
        $public_flag = '0,1';
    } else {
        $public_flag = '1';
    }
    $sql = "SELECT * FROM project_group_list WHERE group_id='{$group_id}' AND is_public IN ({$public_flag})";
    $result = db_query($sql);
    $rows = db_numrows($result);
    if (!$result || $rows < 1) {
        echo "<H1>No Subprojects Found</H1>";
        echo "<P>\n\t\t\t<B>No subprojects have been set up, or you cannot view them.<P><FONT COLOR=RED>The Admin for this project " . "will have to set up projects using the admin page</FONT></B>";
        pm_footer(array());
        exit;
    }
    echo '
		<H2>Subprojects and Tasks</H2>
		<P>
		Choose a Subproject and you can browse/edit/add tasks to it.
		<P>';
Example #21
0
        if ($approve) {
            /*
            	Show the submit form
            */
            $sql = "SELECT groups.unix_group_name,news_bytes.* " . "FROM news_bytes,groups WHERE id='{$id}' " . "AND news_bytes.group_id=groups.group_id ";
            $result = db_query($sql);
            if (db_numrows($result) < 1) {
                exit_error('Error', 'Error - not found');
            }
            echo '
		<H3>Approve a NewsByte</H3>
		<P>
		<FORM ACTION="' . $PHP_SELF . '" METHOD="POST">
		<INPUT TYPE="HIDDEN" NAME="for_group" VALUE="' . db_result($result, 0, 'group_id') . '">
		<INPUT TYPE="HIDDEN" NAME="id" VALUE="' . db_result($result, 0, 'id') . '">
		<B>Submitted for group:</B> <a href="/projects/' . strtolower(db_result($result, 0, 'unix_group_name')) . '/">' . group_getname(db_result($result, 0, 'group_id')) . '</a><BR>
		<B>Submitted by:</B> ' . user_getname(db_result($result, 0, 'submitted_by')) . '<BR>
		<INPUT TYPE="HIDDEN" NAME="approve" VALUE="y">
		<INPUT TYPE="HIDDEN" NAME="post_changes" VALUE="y">
		<INPUT TYPE="RADIO" NAME="status" VALUE="1"> Approve For Front Page<BR>
		<INPUT TYPE="RADIO" NAME="status" VALUE="0"> Do Nothing<BR>
		<INPUT TYPE="RADIO" NAME="status" VALUE="2" CHECKED> Delete<BR>
		<B>Subject:</B><BR>
		<INPUT TYPE="TEXT" NAME="summary" VALUE="' . db_result($result, 0, 'summary') . '" SIZE="30" MAXLENGTH="60"><BR>
		<B>Details:</B><BR>
		<TEXTAREA NAME="details" ROWS="5" COLS="50" WRAP="SOFT">' . db_result($result, 0, 'details') . '</TEXTAREA><BR>
		<INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="SUBMIT">
		</FORM>';
        } else {
            /*
            	Show list of waiting news items
Example #22
0
 *
 * FusionForge is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published
 * by the Free Software Foundation; either version 2 of the License,
 * or (at your option) any later version.
 *
 * FusionForge is distributed in the hope that it will be useful, but
 * WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License along
 * with this program; if not, write to the Free Software Foundation, Inc.,
 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
 */
$taskboard->header(array('title' => 'Taskboard for ' . $group->getPublicName() . ' : Administration : Trackers configuration', 'pagename' => _('Trackers confoguration'), 'sectionvals' => array(group_getname($group_id)), 'group' => $group_id));
global $group_id, $HTML;
$atf = $taskboard->TrackersAdapter->getArtifactTypeFactory();
if (!$atf || !is_object($atf) || $atf->isError()) {
    exit_error(_('Could Not Get ArtifactTypeFactory'));
}
$at_arr = $atf->getArtifactTypes();
if ($at_arr === false || !count($at_arr)) {
    exit_error(_('There Are No Trackers Defined For This Project'));
}
$trackers_selected = array();
$trackers_bgcolor = array();
$release_field = '';
$release_field_tracker = 1;
$estimated_cost_field = $plugins_taskboard_estimated_cost_field_init;
$remaining_cost_field = $plugins_taskboard_remaining_cost_field_init;
Example #23
0
        }
    } else {
        if ($func == 'rmuser') {
            /*
            	remove a user from this portal
            */
            if (!$project->removeUser($rm_id)) {
                $feedback .= $project->getErrorMessage();
            } else {
                $feedback = ' User Removed Successfully ';
            }
        }
    }
}
$project->clearError();
project_admin_header(array('title' => "Project Admin: " . group_getname($group_id), 'group' => $group_id));
/*
	Show top box listing trove and other info
*/
echo '<TABLE width=100% cellpadding=2 cellspacing=2 border=0>
<TR valign=top><TD width=50%>';
$HTML->box1_top("Misc. Project Information");
print '&nbsp;
<BR>
Short Description: ' . db_result($res_grp, 0, 'short_description') . '
<P>
Homepage Link: <B>' . db_result($res_grp, 0, 'homepage') . '</B>
<P align=center>
<A HREF="http://' . $GLOBALS['sys_cvs_host'] . '/cvstarballs/' . db_result($res_grp, 0, 'unix_group_name') . '-cvsroot.tar.gz">[ Download Your Nightly CVS Tree Tarball ]</A>
<P>
Example #24
0
function menu_foundry($grp)
{
    global $HTML, $Language;
    $unix_name = strtolower(group_getunixname($grp));
    $HTML->menuhtml_top('Foundry: ' . group_getname($grp));
    $HTML->menu_entry('/foundry/' . $unix_name . '/', $Language->FOUNDRY_SUMMARY);
    $HTML->menu_entry('/forum/?group_id=' . $grp, $Language->DISCUSSION_FORUMS);
    $HTML->menu_entry('/mail/?group_id=' . $grp, $Language->MAILING_LISTS);
    $HTML->menu_entry('/news/?group_id=' . $grp, $Language->NEWS);
    print '<P>';
    $HTML->menu_entry('/foundry/' . $unix_name . '/admin/', $Language->FOUNDRY_ADMIN);
    $HTML->menuhtml_bottom();
}
Example #25
0
    } elseif ($type == 'admin') {
        $group = group_get_object($id);
        if (!$group) {
            exit_error("Invalid Project", "Inexistent Project");
        }
        if (!$group->usesPlugin($pluginname)) {
            //check if the group has the MediaWiki plugin active
            exit_error("Error", "First activate the {$pluginname} plugin through the Project's Admin Interface");
        }
        $userperm = $group->getPermission($user);
        //we´ll check if the user belongs to the group
        if (!$userperm->IsMember()) {
            exit_error("Access Denied", "You are not a member of this project");
        }
        //only project admin can access here
        if ($userperm->isAdmin()) {
            mediawiki_Project_Header(array('title' => $pluginname . ' Project Plugin!', 'pagename' => "{$pluginname}", 'sectionvals' => array(group_getname($id))));
            // DO THE STUFF FOR THE PROJECT ADMINISTRATION PART HERE
            echo "We are in the Project MediaWiki plugin <font color=\"#ff0000\">ADMINISTRATION</font> <br>";
            echo "Greetings from planet " . $world;
            // $world comes from the config file in /etc
        } else {
            exit_error("Access Denied", "You are not a project Admin");
        }
    }
}
site_project_footer(array());
// Local Variables:
// mode: php
// c-file-style: "bsd"
// End:
Example #26
0
 */
require_once $gfwww . 'include/pre.php';
require_once $gfwww . 'project/admin/project_admin_utils.php';
if (!$sys_use_project_vhost) {
    exit_disabled();
}
session_require(array('group' => $group_id, 'admin_flags' => 'A'));
$group =& group_get_object($group_id);
if (!$group || !is_object($group)) {
    exit_error('Error', 'Error creating group object');
} else {
    if ($group->isError()) {
        exit_error('ERROR', $group->getErrorMessage());
    }
}
project_admin_header(array('title' => _('Project quota manager'), 'group' => $group->getID(), 'pagename' => 'project_admin_quotas', 'sectionvals' => array(group_getname($group_id))));
?>

<h4><?php 
echo _('Project quota manager');
?>
</h4>

<?php 
$quotas = array();
$SQL = "SELECT SUM(octet_length(data)) as size, SUM(octet_length(data_words)) as size1, count(*) as nb ";
$SQL .= "FROM doc_data ";
$SQL .= "WHERE group_id = '{$group_id}' ";
$res_db = db_query($SQL);
$q = array();
$q["name"] = _('Documents');
Example #27
0
// $Id: add_support.php,v 1.2 2003/11/13 11:29:27 helix Exp $
support_header(array('title' => 'Submit a Support Request'));
echo '
	<P>
	<H2>Submit A Support Request</H2>
	<P>
	<B>Fill out the form below.</B> Fill in complete information and make sure 
	you include enough info that someone will be able to help you.
	<P>
	If you are requesting something that could affect security, <B>YOU MUST BE LOGGED IN</B>.
	<P>
	<FORM ACTION="' . $PHP_SELF . '" METHOD="POST" enctype="multipart/form-data">
	<INPUT TYPE="HIDDEN" NAME="func" VALUE="postaddsupport">
	<INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '">
	<TABLE>
	<TR><TD VALIGN="TOP" COLSPAN="2"><B>For Project:</B><BR>' . group_getname($group_id) . '</TD></TR>
	<TR><TD VALIGN="TOP" COLSPAN="2"><B>Category:</B><BR>';
echo support_category_box($group_id, 'support_category_id');
?>
	</TD></TR>

	<TR><TD COLSPAN="2"><B>Summary:</B><BR>
		<INPUT TYPE="TEXT" NAME="summary" SIZE="35" MAXLENGTH="40">
	</TD></TR>

	<TR><TD COLSPAN="2">
		<B>Detailed Description:</B>
		<P>
		<TEXTAREA NAME="details" ROWS="30" COLS="55" WRAP="HARD"></TEXTAREA>
	</TD></TR>
Example #28
0
<?php

require $DOCUMENT_ROOT . '/news/news_utils.php';
require 'features_boxes.php';
require 'cache.php';
//we already know $foundry is set up from the master page
$HTML->header(array('title' => group_getname($group_id) . ' - Foundry', 'group' => $group_id));
echo '<h2>Foundry: ' . group_getname($group_id) . '<h2>
';
echo '	<table cellspacing="0" cellpadding="5" border="0" width="100%">
	      <tr>
		<td align="left" valign="top">
';
echo html_dbimage($foundry->getLogoImageID());
echo '<p>
';
echo $foundry->getFreeformHTML1();
echo '<p>
';
/*
	News that was selected for display by the portal
	News items are chosen froma list of news in subprojects
*/
$HTML->box1_top('Foundry News', '#f4f5f7');
echo news_foundry_latest($group_id);
$HTML->box1_bottom();
/*
	Message Forums
*/
echo '<P>
';
Example #29
0
 $group = group_get_object($id);
 if (!$group) {
     exit_error(_('Invalid Project'), _('Inexistent Project'));
 }
 if (!$group->usesPlugin($pluginname)) {
     //check if the group has the plugin active
     exit_error("Error", "First activate the {$pluginname} plugin through the Project's Admin Interface");
 }
 $userperm = $group->getPermission($user);
 //we'll check if the user belongs to the group
 if (!$userperm->IsMember()) {
     exit_error(_('Access Denied'), _('You are not a member of this project'));
 }
 //only project admin can access here
 if ($userperm->isAdmin()) {
     wiki_Project_Header(array('title' => "Configuration for your project's Wiki", 'pagename' => "{$pluginname}", 'sectionvals' => array(group_getname($id))));
     $wc = new WikiConfig($id);
     print "\n<h1>" . _("Configuration for your project's Wiki") . "</h1>\n";
     print "<table>\n";
     print "<tr>\n";
     print "<td>\n";
     print "<fieldset>\n";
     print "<legend>" . _('Wiki Configuration') . "</legend>\n";
     print "<form action=\"/plugins/wiki/wikiadmin.php\" method=\"post\">\n";
     print "<input type=\"hidden\" name=\"id\" value=\"{$id}\" />\n";
     print "<input type=\"hidden\" name=\"pluginname\" value=\"{$pluginname}\" />\n";
     print "<input type=\"hidden\" name=\"type\" value=\"admin_post\" />\n";
     print '<table class="listing">';
     print "\n<thead>\n<tr>\n<th>" . _("Parameter") . "</th>" . "<th>" . _("Value") . "</th>\n" . "</tr>\n</thead>\n";
     foreach ($wc->getWikiConfigNames() as $c) {
         $checked = $wc->getWikiConfig($c) ? ' checked="checked"' : '';
Example #30
0
<?php

//
// SourceForge: Breaking Down the Barriers to Open Source Development
// Copyright 1999-2000 (c) The SourceForge Crew
// http://sourceforge.net
//
// $Id: mail_nav.php,v 1.2 2003/11/13 11:29:24 helix Exp $
echo "\n\n<TABLE BORDER=0 WIDTH=\"100%\">" . "\n<TR><TD NOWRAP>";
echo "<A HREF=\"/project/?group_id={$group_id}\">" . html_image("images/ic/ofolder15.png", "15", "13", array("BORDER" => "0")) . " &nbsp; " . group_getname($group_id) . " Home Page</A><BR>";
echo " &nbsp; &nbsp; <A HREF=\"/mail/?group_id={$group_id}\">" . html_image("images/ic/ofolder15.png", "15", "13", array("BORDER" => "0")) . " &nbsp; Mailing Lists</A><BR>";
if ($is_admin_page) {
    echo " &nbsp; &nbsp; &nbsp; &nbsp; <A HREF=\"/survey/admin/?group_id={$group_id}\">" . html_image("images/ic/ofolder15.png", "15", "13", array("BORDER" => "0")) . " &nbsp; Administration</A>";
}
echo "</TD></TR>";
echo "\n</TABLE>\n";