echo db_error();
} else {
$feedback .= ' JOB skill deleted successfully ';
}
} else {
$feedback .= ' JOB skill delete failed - wrong project_id ';
}
}
}
}
}
}
/*
Fill in the info to create a job
*/
people_header(array('title' => 'Edit a job for your project'));
//for security, include group_id
$sql = "SELECT * FROM people_job WHERE job_id='{$job_id}' AND group_id='{$group_id}'";
$result = db_query($sql);
if (!$result || db_numrows($result) < 1) {
echo db_error();
$feedback .= ' POSTING fetch FAILED ';
echo '<H2>No Such posting For This Project</H2>';
} else {
echo '
<H3>Select Required Skills</H3>
<P>
Now you can edit/change the list of skills attached to this posting.
Developers will be able to match their skills with your requirements.
<P>
All postings are automatically closed after two weeks.
<?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
<?php
//
// SourceForge: Breaking Down the Barriers to Open Source Development
// Copyright 1999-2000 (c) The SourceForge Crew
// http://sourceforge.net
//
// $Id: viewjob.php,v 1.2 2003/11/13 11:29:25 helix Exp $
require 'pre.php';
require '../people/people_utils.php';
if ($group_id && $job_id) {
/*
Fill in the info to create a job
*/
people_header(array('title' => 'View a Job'));
//for security, include group_id
$sql = "SELECT groups.group_name,people_job_category.name AS category_name," . "people_job_status.name AS status_name,people_job.title," . "people_job.description,people_job.date,users.user_name,users.user_id " . "FROM people_job,groups,people_job_status,people_job_category,users " . "WHERE people_job_category.category_id=people_job.category_id " . "AND people_job_status.status_id=people_job.status_id " . "AND users.user_id=people_job.created_by " . "AND groups.group_id=people_job.group_id " . "AND people_job.job_id='{$job_id}' AND people_job.group_id='{$group_id}'";
$result = db_query($sql);
if (!$result || db_numrows($result) < 1) {
echo db_error();
$feedback .= ' POSTING fetch FAILED ';
echo '<H2>No Such Posting For This Project</H2>';
} else {
echo '
<H2>' . db_result($result, 0, 'category_name') . ' wanted for ' . db_result($result, 0, 'group_name') . '</H2>
<P>
<TABLE BORDER="0" WIDTH="100%">
<TR><TD COLSPAN="2">
<B>' . db_result($result, 0, 'title') . '</B>
</TD></TR>
echo db_error();
} else {
$feedback .= _('JOB skill deleted successfully');
}
} else {
$feedback .= _('JOB skill delete failed - wrong project_id');
}
}
}
}
}
}
/*
Fill in the info to create a job
*/
people_header(array('title' => _('Edit Job')));
//for security, include group_id
$sql = "SELECT * FROM people_job WHERE job_id='{$job_id}' AND group_id='{$group_id}'";
$result = db_query($sql);
if (!$result || db_numrows($result) < 1) {
echo db_error();
$feedback .= _('POSTING fetch FAILED');
echo '<h2>' . _('No such posting for this project') . '</h2>';
} else {
echo _('<p>Now you can edit/change the list of skills attached to this posting. Developers will be able to match their skills with your requirements.</p><p>All postings are automatically closed after two weeks.</p>') . '
<p /><form action="' . getStringFromServer('PHP_SELF') . '" method="post">
<input type="hidden" name="group_id" value="' . $group_id . '" />
<input type="hidden" name="job_id" value="' . $job_id . '" />
<strong>' . _('Category') . '</strong><br />
' . people_job_category_box('category_id', db_result($result, 0, 'category_id')) . '
echo "\n<H2>" . $Language->getText('people_admin_index', 'no_skills_found') . "</H2>";
}
echo '
<P>
<H3>' . $Language->getText('people_utils', 'add_new_skill') . ':</H3>
<P>
<FORM ACTION="?" METHOD="POST">
<INPUT TYPE="HIDDEN" NAME="people_skills" VALUE="y">
<INPUT TYPE="HIDDEN" NAME="post_changes" VALUE="y">
<H4>' . $Language->getText('people_admin_index', 'new_skill_name') . ':</H4>
<INPUT TYPE="TEXT" NAME="skill_name" VALUE="" SIZE="15" MAXLENGTH="30"><BR>
<P>
<B><span class="highlight">' . $Language->getText('people_admin_index', 'once_added_no_delete') . '</span></B>
<P>
<INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="SUBMIT">
</FORM>';
people_footer(array());
} else {
/*
Show main page
*/
people_header(array('title' => $Language->getText('people_admin_index', 'people_skills_admin')));
echo '
<H2>' . $Language->getText('people_admin_index', 'people_skills_admin') . '</H2>';
echo "\n<h3><A HREF=\"?people_skills=1\">" . $Language->getText('people_admin_index', 'add_skills') . "</A></h3>";
echo "<p>" . $Language->getText('people_admin_index', 'add_new_skill_to_list') . "</p>";
people_footer(array());
}
} else {
exit_permission_denied();
}
*
* This file is part of GForge.
*
* GForge 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.
*
* GForge 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 GForge; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
require_once '../env.inc.php';
require_once $gfwww . 'include/pre.php';
require_once $gfwww . 'people/people_utils.php';
if (!$sys_use_people) {
exit_disabled();
}
$group_id = getIntFromRequest('group_id');
$job_id = getStringFromRequest('job_id');
people_header(array('title' => _('Help Wanted Latest Posts')));
echo '<p>';
$sql = "SELECT people_job.group_id,people_job.job_id,groups.group_name,groups.unix_group_name,people_job.title,people_job.post_date,people_job_category.name AS category_name " . "FROM people_job,people_job_category,groups " . "WHERE people_job.group_id=groups.group_id " . "AND people_job.category_id=people_job_category.category_id " . "AND people_job.status_id=1 " . "ORDER BY post_date DESC";
$result = db_query($sql, 30);
echo people_show_job_list($result) . '</p>';
people_footer(array());
?>
" METHOD="POST">
<INPUT TYPE="HIDDEN" NAME="people_skills" VALUE="y">
<INPUT TYPE="HIDDEN" NAME="post_changes" VALUE="y">
<H4>New Skill Name:</H4>
<INPUT TYPE="TEXT" NAME="skill_name" VALUE="" SIZE="15" MAXLENGTH="30"><BR>
<P>
<B><FONT COLOR="RED">Once you add a skill, it cannot be deleted</FONT></B>
<P>
<INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="SUBMIT">
</FORM>
<?php
people_footer(array());
} else {
/*
Show main page
*/
people_header(array('title' => 'People Administration'));
echo '
<H2>Help Wanted Administration</H2>';
echo '<P>
<A HREF="' . $PHP_SELF . '?people_cat=1">Add Job Categories</A><BR>';
// echo "\nAdd categories of bugs like, 'mail module','gant chart module','interface', etc<P>";
echo "\n<A HREF=\"{$PHP_SELF}?people_skills=1\">Add Job Skills</A><BR>";
// echo "\nAdd Groups of bugs like 'future requests','unreproducible', etc<P>";
people_footer(array());
}
}
} else {
exit_permission_denied();
}
$sql = "DELETE FROM people_skill_inventory WHERE user_id='" . user_getid() . "' AND skill_inventory_id='{$skill_inventory_id}'";
$result = db_query($sql);
if (!$result || db_affected_rows($result) < 1) {
$feedback .= ' ' . $Language->getText('people_editprofile', 'skill_delete_failed') . ' ';
echo db_error();
} else {
$feedback .= ' ' . $Language->getText('people_editprofile', 'skill_delete_ok') . ' ';
}
}
}
}
}
/*
Fill in the info to create a job
*/
people_header(array('title' => $Language->getText('people_editprofile', 'edit_your_profile')));
//for security, include group_id
$sql = "SELECT * FROM user WHERE user_id='" . user_getid() . "'";
$result = db_query($sql);
if (!$result || db_numrows($result) < 1) {
echo db_error();
$feedback .= ' ' . $Language->getText('people_editprofile', 'user_fetch_failed') . ' ';
echo '<H2>' . $Language->getText('people_editprofile', 'no_such_user') . '</H2>';
} else {
$csrfToken = $csrf->fetchHTMLInput();
echo '
<H2>' . $Language->getText('people_editprofile', 'edit_your_profile') . '</H2>
<P>
' . $Language->getText('people_editprofile', 'skill_explain') . '
<P>
<FORM ACTION="?" METHOD="POST">' . $csrfToken . '
<?php
//
// SourceForge: Breaking Down the Barriers to Open Source Development
// Copyright 1999-2000 (c) The SourceForge Crew
// http://sourceforge.net
//
//
require_once 'pre.php';
exit_error($Language->getText('include_exit', 'info'), $Language->getText('people', 'disabled'));
require '../people/people_utils.php';
if ($user_id) {
people_header(array('title' => $Language->getText('people_viewprofile', 'title')));
//for security, include group_id
$sql = "SELECT * FROM user WHERE user_id='{$user_id}'";
$result = db_query($sql);
if (!$result || db_numrows($result) < 1) {
echo db_error();
$feedback .= ' ' . $Language->getText('people_editprofile', 'edit_your_profile') . ' ';
echo '<H2>' . $Language->getText('people_editprofile', 'no_such_user') . '</H2>';
} else {
/*
profile set private
*/
if (db_result($result, 0, 'people_view_skills') != 1) {
echo '<H2>' . $Language->getText('people_viewprofile', 'set_private') . '</H2>';
people_footer(array());
exit;
}
echo '
<H3>' . $Language->getText('people_viewprofile', 'title') . '</H3>
<?php
//
// SourceForge: Breaking Down the Barriers to Open Source Development
// Copyright 1999-2000 (c) The SourceForge Crew
// http://sourceforge.net
//
// $Id: viewprofile.php,v 1.2 2003/11/13 11:29:25 helix Exp $
require 'pre.php';
require '../people/people_utils.php';
if ($user_id) {
/*
Fill in the info to create a job
*/
people_header(array('title' => 'View a User Profile'));
//for security, include group_id
$sql = "SELECT * FROM users WHERE user_id='{$user_id}'";
$result = db_query($sql);
if (!$result || db_numrows($result) < 1) {
echo db_error();
$feedback .= ' User fetch FAILED ';
echo '<H2>No Such User</H2>';
} else {
/*
profile set private
*/
if (db_result($result, 0, 'people_view_skills') != 1) {
echo '<H2>This User Has Set His/Her Profile to Private</H2>';
people_footer(array());
exit;
}
for ($i = 0; $i < $rows; $i++) {
echo '<input type="hidden" name="skill_delete[]" value="' . $skill_delete[$i] . '">';
}
echo '<input type="hidden" name="confirmMultiDelete" value="1" />';
echo '<input type="submit" name="MultiDelete" value="' . _('Confirm') . '" />';
echo '<input type="submit" name="MultiDeleteCancel" value="' . _('Cancel') . '" />';
echo '</form>';
people_footer(array());
}
return;
}
}
} elseif (getStringFromRequest('MultiDeleteCancel')) {
$feedback .= _('Skill deletion cancelled');
}
people_header(array('title' => _('Edit Your Profile')));
html_feedback_top($feedback);
//for security, include group_id
$sql = "SELECT * FROM users WHERE user_id='" . user_getid() . "'";
$result = db_query($sql);
if (!$result || db_numrows($result) < 1) {
echo db_error();
$feedback .= _('User fetch FAILED');
echo '<h2>' . _('No Such User') . '<h2>';
} else {
echo '
<h2>' . _('Edit Public Permissions') . '<h2>
<form action="' . getStringFromServer('PHP_SELF') . '" method="post">
' . _('The following option determines if others can see your skills. If they can\'t, you can still enter your skills.') . '
<p>
<strong>' . _('Publicly Viewable') . ':</strong><br />
<?php
//
// SourceForge: Breaking Down the Barriers to Open Source Development
// Copyright 1999-2000 (c) The SourceForge Crew
// http://sourceforge.net
//
// $Id: createjob.php,v 1.2 2003/11/13 11:29:25 helix Exp $
require 'pre.php';
require '../people/people_utils.php';
if ($group_id && user_ismember($group_id, 'A')) {
/*
Fill in the info to create a job
*/
people_header(array('title' => 'Create a job for your project'));
echo '
<H2>Create a New Job</H2>
<P>
Start by filling in the fields below. When you click continue, you
will be shown a list of skills and experience levels that this job requires.
<P>
<FORM ACTION="/people/editjob.php" METHOD="POST">
<INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '">
<B>Category:</B><BR>
' . people_job_category_box('category_id') . '
<P>
<B>Short Description:</B><BR>
<INPUT TYPE="TEXT" NAME="title" VALUE="" SIZE="40" MAXLENGTH="60">
<P>
<B>Long Description:</B><BR>
<TEXTAREA NAME="description" ROWS="10" COLS="60" WRAP="SOFT"></TEXTAREA>
