| 0,0 → 1,149 |
|---|
| <?php |
| // +-----------------------------------------------------------------------+ |
| // | PhpWebGallery - a PHP based picture gallery | |
| // | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net | |
| // | Copyright (C) 2003-2005 PhpWebGallery Team - http://phpwebgallery.net | |
| // +-----------------------------------------------------------------------+ |
| // | branch : BSF (Best So Far) |
| // | file : $RCSfile: waiting.php,v $ |
| // | last update : $Date: 2005/01/16 17:31:18 $ |
| // | last modifier : $Author: plg $ |
| // | revision : $Revision: 1.18 $ |
| // +-----------------------------------------------------------------------+ |
| // | 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 | |
| // | | |
| // | 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., 59 Temple Place - Suite 330, Boston, MA 02111-1307, | |
| // | USA. | |
| // +-----------------------------------------------------------------------+ |
| if( !defined("PHPWG_ROOT_PATH") ) |
| { |
| die ("Hacking attempt!"); |
| } |
| include_once( PHPWG_ROOT_PATH.'admin/include/isadmin.inc.php'); |
| //--------------------------------------------------------------------- updates |
| if ( isset( $_POST['submit'] ) ) |
| { |
| $query = 'SELECT * FROM '.WAITING_TABLE; |
| $query.= " WHERE validated = 'false';"; |
| $result = pwg_query( $query ); |
| while ( $row = mysql_fetch_array( $result ) ) |
| { |
| $key = 'validate-'.$row['id']; |
| if ( isset( $_POST[$key] ) ) |
| { |
| if ( $_POST[$key] == 'true' ) |
| { |
| // The uploaded element was validated, we have to set the |
| // "validated" field to "true" |
| $query = 'UPDATE '.WAITING_TABLE; |
| $query.= " SET validated = 'true'"; |
| $query.= ' WHERE id = '.$row['id']; |
| $query.= ';'; |
| pwg_query( $query ); |
| } |
| else |
| { |
| // The uploaded element was refused, we have to delete its reference |
| // in the database and to delete the element as well. |
| $query = 'DELETE FROM '.WAITING_TABLE; |
| $query.= ' WHERE id = '.$row['id']; |
| $query.= ';'; |
| pwg_query( $query ); |
| // deletion of the associated files |
| $dir = get_complete_dir( $row['storage_category_id'] ); |
| unlink( $dir.$row['file'] ); |
| if (isset($row['tn_ext']) and $row['tn_ext'] != '' ) |
| { |
| $thumbnail = $conf['prefix_thumbnail']; |
| $thumbnail.= get_filename_wo_extension( $row['file'] ); |
| $thumbnail.= '.'.$row['tn_ext']; |
| $url = $dir.'thumbnail/'.$thumbnail; |
| unlink( $url ); |
| } |
| } |
| } |
| } |
| } |
| |
| //----------------------------------------------------- template initialization |
| $template->set_filenames(array('waiting'=>'admin/waiting.tpl')); |
| $template->assign_vars(array( |
| 'L_WAITING_CONFIRMATION'=>$lang['waiting_update'], |
| 'L_AUTHOR'=>$lang['author'], |
| 'L_THUMBNAIL'=>$lang['thumbnail'], |
| 'L_DATE'=>$lang['date'], |
| 'L_FILE'=>$lang['file'], |
| 'L_CATEGORY'=>$lang['category'], |
| 'L_SUBMIT'=>$lang['submit'], |
| 'L_RESET'=>$lang['reset'], |
| 'L_DELETE'=>$lang['delete'], |
| |
| 'F_ACTION'=>add_session_id(str_replace( '&', '&', $_SERVER['REQUEST_URI'] )) |
| )); |
| |
| //-------------------------------------------------------- confirmation message |
| if (isset($_POST['submit'])) |
| { |
| $template->assign_block_vars('confirmation' ,array()); |
| } |
| //---------------------------------------------------------------- form display |
| $cat_names = array(); |
| $query = 'SELECT * FROM '.WAITING_TABLE; |
| $query.= " WHERE validated = 'false'"; |
| $query.= ' ORDER BY storage_category_id'; |
| $query.= ';'; |
| $result = pwg_query( $query ); |
| $i = 0; |
| while ( $row = mysql_fetch_array( $result ) ) |
| { |
| if ( !isset( $cat_names[$row['storage_category_id']] ) ) |
| { |
| $cat = get_cat_info( $row['storage_category_id'] ); |
| $cat_names[$row['storage_category_id']] = array(); |
| $cat_names[$row['storage_category_id']]['dir'] = |
| PHPWG_ROOT_PATH.get_complete_dir( $row['storage_category_id'] ); |
| $cat_names[$row['storage_category_id']]['display_name'] = |
| get_cat_display_name($cat['name']); |
| } |
| $preview_url = PHPWG_ROOT_PATH.$cat_names[$row['storage_category_id']]['dir'].$row['file']; |
| $class='row1'; |
| if ( $i++ % 2== 0 ) $class='row2'; |
| |
| $template->assign_block_vars('picture' ,array( |
| 'WAITING_CLASS'=>$class, |
| 'CATEGORY_IMG'=>$cat_names[$row['storage_category_id']]['display_name'], |
| 'ID_IMG'=>$row['id'], |
| 'DATE_IMG'=>format_date( $row['date'], 'unix', true ), |
| 'FILE_IMG'=>$row['file'], |
| 'PREVIEW_URL_IMG'=>$preview_url, |
| 'UPLOAD_EMAIL'=>$row['mail_address'], |
| 'UPLOAD_USERNAME'=>$row['username'] |
| )); |
| |
| // is there an existing associated thumnail ? |
| if ( !empty( $row['tn_ext'] )) |
| { |
| $thumbnail = $conf['prefix_thumbnail']; |
| $thumbnail.= get_filename_wo_extension( $row['file'] ); |
| $thumbnail.= '.'.$row['tn_ext']; |
| $url = $cat_names[$row['storage_category_id']]['dir']; |
| $url.= 'thumbnail/'.$thumbnail; |
| |
| $template->assign_block_vars('picture.thumbnail' ,array( |
| 'PREVIEW_URL_TN_IMG'=>$url, |
| 'FILE_TN_IMG'=>$thumbnail |
| )); |
| } |
| } |
| //----------------------------------------------------------- sending html code |
| $template->assign_var_from_handle('ADMIN_CONTENT', 'waiting'); |
| ?> |