5 * Copyright 1999-2001 (c) VA Linux Systems
6 * Copyright 2002-2004 (c) GForge Team
7 * http://fusionforge.org/
9 * This file is part of FusionForge. FusionForge is free software;
10 * you can redistribute it and/or modify it under the terms of the
11 * GNU General Public License as published by the Free Software
12 * Foundation; either version 2 of the Licence, or (at your option)
15 * FusionForge is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 * GNU General Public License for more details.
20 * You should have received a copy of the GNU General Public License along
21 * with FusionForge; if not, write to the Free Software Foundation, Inc.,
22 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
25 require_once('../env.inc.php');
26 require_once $gfcommon.'include/pre.php';
27 require_once $gfwww.'people/people_utils.php';
29 if (!forge_get_config('use_people')) {
30 exit_disabled('home');
33 $group_id = getIntFromRequest('group_id');
34 $job_id = getIntFromRequest('job_id');
36 people_header(array('title'=>_('Help Wanted Latest Posts')));
41 $result=db_query_params('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
42 FROM people_job,people_job_category,groups
43 WHERE people_job.group_id=groups.group_id
44 AND people_job.category_id=people_job_category.category_id
45 AND people_job.status_id=1
46 ORDER BY post_date DESC',
48 echo people_show_job_list($result) . '</p>';
52 people_footer(array());