WebCollab --------------------------------------- This program 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. This program 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., 675 Mass Ave, Cambridge, MA 02139, USA. Function: --------- Lists files assigned to a task */ //security check if(! defined('UID' ) ) { die('Direct file access not permitted' ); } if(! ADMIN ) { error('Access denied', 'This feature is only for admins' ); } include_once(BASE.'includes/time.php' ); $content = ''; //get the files from this task $q = db_query('SELECT '.PRE.'files.id AS id, '.PRE.'files.filename AS filename, '.PRE.'files.uploaded AS uploaded, '.PRE.'files.size AS size, '.PRE.'files.description AS description, '.PRE.'files.uploader AS uploader, '.PRE.'tasks.id AS task_id, '.PRE.'tasks.name AS task_name, '.PRE.'users.id AS userid, '.PRE.'users.fullname AS username FROM '.PRE.'files LEFT JOIN '.PRE.'tasks ON ('.PRE.'files.taskid='.PRE.'tasks.id) LEFT JOIN '.PRE.'users ON ('.PRE.'users.id='.PRE.'files.uploader) ORDER BY task_name' ); $content .= "\n"; //show them for($i=0 ; $row = @db_fetch_array($q, $i ) ; ++$i ) { if($i > 0 ) { //not the first line, need to add a divider $content .= "\n"; } //file part $content .= "\n". "\n". //user part "\n"; //show description if( $row['description'] != '' ) { $content .= "\n"; } //blank line to end $content .= "\n"; } $content .= "

".$lang['task'].":	". "".$row['task_name']."". "
".$lang['file']."	". "".$row['filename']."". " (".nice_size($row['size'] ).") ". //delete option "[".$lang['del']."]
".$lang['uploader']."	".$row['username']." (".nicetime( $row['uploaded'] ).")
".$lang['description'].":	".nl2br($row['description'])."

\n"; if($i == 0 ) { //no files found in database $content = $lang['no_files']."\n"; new_box($lang['manage_files'], $content ); } else { //show found content new_box( $lang['manage_files'], $content ); } ?>