diff options
Diffstat (limited to '')
| -rw-r--r-- | BSF/admin/picture_modify.php | 437 |
1 files changed, 0 insertions, 437 deletions
diff --git a/BSF/admin/picture_modify.php b/BSF/admin/picture_modify.php deleted file mode 100644 index 2fbaf901b..000000000 --- a/BSF/admin/picture_modify.php +++ /dev/null @@ -1,437 +0,0 @@ -<?php -// +-----------------------------------------------------------------------+ -// | Piwigo - a PHP based picture gallery | -// +-----------------------------------------------------------------------+ -// | Copyright(C) 2008 Piwigo Team http://piwigo.org | -// | Copyright(C) 2003-2008 PhpWebGallery Team http://phpwebgallery.net | -// | Copyright(C) 2002-2003 Pierrick LE GALL http://le-gall.net/pierrick | -// +-----------------------------------------------------------------------+ -// | 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/functions.php'); - -// +-----------------------------------------------------------------------+ -// | Check Access and exit when user status is not ok | -// +-----------------------------------------------------------------------+ -check_status(ACCESS_ADMINISTRATOR); - -// +-----------------------------------------------------------------------+ -// | synchronize metadata | -// +-----------------------------------------------------------------------+ - -if (isset($_GET['sync_metadata']) and !is_adviser()) -{ - $query = ' -SELECT path - FROM '.IMAGES_TABLE.' - WHERE id = '.$_GET['image_id'].' -;'; - list($path) = mysql_fetch_row(pwg_query($query)); - update_metadata(array($_GET['image_id'] => $path)); - - array_push($page['infos'], l10n('Metadata synchronized from file')); -} - -//--------------------------------------------------------- update informations - -// first, we verify whether there is a mistake on the given creation date -if (isset($_POST['date_creation_action']) - and 'set' == $_POST['date_creation_action']) -{ - if (!checkdate( - $_POST['date_creation_month'], - $_POST['date_creation_day'], - $_POST['date_creation_year']) - ) - { - array_push($page['errors'], l10n('err_date')); - } -} - -if (isset($_POST['submit']) and count($page['errors']) == 0 and !is_adviser()) -{ - $data = array(); - $data{'id'} = $_GET['image_id']; - $data{'name'} = $_POST['name']; - $data{'author'} = $_POST['author']; - $data['level'] = $_POST['level']; - - if ($conf['allow_html_descriptions']) - { - $data{'comment'} = @$_POST['description']; - } - else - { - $data{'comment'} = strip_tags(@$_POST['description']); - } - - if (isset($_POST['date_creation_action'])) - { - if ('set' == $_POST['date_creation_action']) - { - $data{'date_creation'} = $_POST['date_creation_year'] - .'-'.$_POST['date_creation_month'] - .'-'.$_POST['date_creation_day']; - } - else if ('unset' == $_POST['date_creation_action']) - { - $data{'date_creation'} = ''; - } - } - - mass_updates( - IMAGES_TABLE, - array( - 'primary' => array('id'), - 'update' => array_diff(array_keys($data), array('id')) - ), - array($data) - ); - - set_tags( - isset($_POST['tags']) ? $_POST['tags'] : array(), - $_GET['image_id'] - ); - - array_push($page['infos'], l10n('Picture informations updated')); -} -// associate the element to other categories than its storage category -if (isset($_POST['associate']) - and isset($_POST['cat_dissociated']) - and count($_POST['cat_dissociated']) > 0 - and !is_adviser() - ) -{ - associate_images_to_categories( - array($_GET['image_id']), - $_POST['cat_dissociated'] - ); -} -// dissociate the element from categories (but not from its storage category) -if (isset($_POST['dissociate']) - and isset($_POST['cat_associated']) - and count($_POST['cat_associated']) > 0 - and !is_adviser() - ) -{ - $query = ' -DELETE FROM '.IMAGE_CATEGORY_TABLE.' - WHERE image_id = '.$_GET['image_id'].' - AND category_id IN ('.implode(',', $_POST['cat_associated']).') -'; - pwg_query($query); - - update_category($_POST['cat_associated']); -} -// elect the element to represent the given categories -if (isset($_POST['elect']) - and isset($_POST['cat_dismissed']) - and count($_POST['cat_dismissed']) > 0 - and !is_adviser() - ) -{ - $datas = array(); - foreach ($_POST['cat_dismissed'] as $category_id) - { - array_push($datas, - array('id' => $category_id, - 'representative_picture_id' => $_GET['image_id'])); - } - $fields = array('primary' => array('id'), - 'update' => array('representative_picture_id')); - mass_updates(CATEGORIES_TABLE, $fields, $datas); -} -// dismiss the element as representant of the given categories -if (isset($_POST['dismiss']) - and isset($_POST['cat_elected']) - and count($_POST['cat_elected']) > 0 - and !is_adviser() - ) -{ - set_random_representant($_POST['cat_elected']); -} - -// retrieving direct information about picture -$query = ' -SELECT * - FROM '.IMAGES_TABLE.' - WHERE id = '.$_GET['image_id'].' -;'; -$row = mysql_fetch_array(pwg_query($query)); - -$storage_category_id = $row['storage_category_id']; -$image_file = $row['file']; - -// tags -$query = ' -SELECT tag_id - FROM '.IMAGE_TAG_TABLE.' - WHERE image_id = '.$_GET['image_id'].' -;'; -$selected_tags = array_from_query($query, 'tag_id'); - -// +-----------------------------------------------------------------------+ -// | template init | -// +-----------------------------------------------------------------------+ - -$template->set_filenames( - array( - 'picture_modify' => 'admin/picture_modify.tpl' - ) - ); - -$all_tags = get_all_tags(); - -if (count($all_tags) > 0) -{ - $tag_selection = get_html_tag_selection( - $all_tags, - 'tags', - $selected_tags - ); -} -else -{ - $tag_selection = - '<p>'. - l10n('No tag defined. Use Administration>Pictures>Tags'). - '</p>'; -} - -$template->assign( - array( - 'U_SYNC' => - get_root_url().'admin.php?page=picture_modify'. - '&image_id='.$_GET['image_id']. - (isset($_GET['cat_id']) ? '&cat_id='.$_GET['cat_id'] : ''). - '&sync_metadata=1', - - 'PATH'=>$row['path'], - - 'TN_SRC' => get_thumbnail_url($row), - - 'NAME' => - isset($_POST['name']) ? - stripslashes($_POST['name']) : @$row['name'], - - 'DIMENSIONS' => @$row['width'].' * '.@$row['height'], - - 'FILESIZE' => @$row['filesize'].' KB', - - 'REGISTRATION_DATE' => - format_date($row['date_available'], 'mysql_datetime', false), - - 'AUTHOR' => isset($_POST['author']) ? $_POST['author'] : @$row['author'], - - 'TAG_SELECTION' => $tag_selection, - - 'DESCRIPTION' => - htmlspecialchars( isset($_POST['description']) ? - stripslashes($_POST['description']) : @$row['comment'] ), - - 'F_ACTION' => - get_root_url().'admin.php' - .get_query_string_diff(array('sync_metadata')) - ) - ); - -if ($row['has_high'] == 'true') -{ - $template->assign( - 'HIGH_FILESIZE', - isset($row['high_filesize']) - ? $row['high_filesize'].' KB' - : l10n('unknown') - ); -} - -// image level options -$tpl_options = array(); -foreach ($conf['available_permission_levels'] as $level) -{ - $tpl_options[$level] = l10n( sprintf('Level %d', $level) ).' ('.$level.')'; -} -$selected_level = isset($_POST['level']) ? $_POST['level'] : $row['level']; -$template->assign( - array( - 'level_options'=> $tpl_options, - 'level_options_selected' => array($selected_level) - ) - ); - -// creation date -unset($day, $month, $year); - -if (isset($_POST['date_creation_action']) - and 'set' == $_POST['date_creation_action']) -{ - foreach (array('day', 'month', 'year') as $varname) - { - $$varname = $_POST['date_creation_'.$varname]; - } -} -else if (isset($row['date_creation']) and !empty($row['date_creation'])) -{ - list($year, $month, $day) = explode('-', $row['date_creation']); -} -else -{ - list($year, $month, $day) = array('', 0, 0); -} - - -$month_list = $lang['month']; -$month_list[0]='------------'; -ksort($month_list); - -$template->assign( - array( - 'DATE_CREATION_DAY_VALUE' => $day, - 'DATE_CREATION_MONTH_VALUE' => $month, - 'DATE_CREATION_YEAR_VALUE' => $year, - 'month_list' => $month_list, - ) - ); - -$query = ' -SELECT category_id, uppercats - FROM '.IMAGE_CATEGORY_TABLE.' AS ic - INNER JOIN '.CATEGORIES_TABLE.' AS c - ON c.id = ic.category_id - WHERE image_id = '.$_GET['image_id'].' -;'; -$result = pwg_query($query); - -while ($row = mysql_fetch_array($result)) -{ - $name = - get_cat_display_name_cache( - $row['uppercats'], - get_root_url().'admin.php?page=cat_modify&cat_id=', - false - ); - - if ($row['category_id'] == $storage_category_id) - { - $template->assign('STORAGE_CATEGORY', $name); - } - else - { - $template->append('related_categories', $name); - } -} - -// jump to link -// -// 1. find all linked categories that are reachable for the current user. -// 2. if a category is available in the URL, use it if reachable -// 3. if URL category not available or reachable, use the first reachable -// linked category -// 4. if no category reachable, no jumpto link - -$query = ' -SELECT category_id - FROM '.IMAGE_CATEGORY_TABLE.' - WHERE image_id = '.$_GET['image_id'].' -;'; - -$authorizeds = array_diff( - array_from_query($query, 'category_id'), - explode( - ',', - calculate_permissions($user['id'], $user['status']) - ) - ); - -if (isset($_GET['cat_id']) - and in_array($_GET['cat_id'], $authorizeds)) -{ - $url_img = make_picture_url( - array( - 'image_id' => $_GET['image_id'], - 'image_file' => $image_file, - 'category' => $cache['cat_names'][ $_GET['cat_id'] ], - ) - ); -} -else -{ - foreach ($authorizeds as $category) - { - $url_img = make_picture_url( - array( - 'image_id' => $_GET['image_id'], - 'image_file' => $image_file, - 'category' => $cache['cat_names'][ $category ], - ) - ); - break; - } -} - -if (isset($url_img)) -{ - $template->assign( 'U_JUMPTO', $url_img ); -} - -// associate to another category ? -$query = ' -SELECT id,name,uppercats,global_rank - FROM '.CATEGORIES_TABLE.' - INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id = category_id - WHERE image_id = '.$_GET['image_id'].' - AND id != '.$storage_category_id.' -;'; -display_select_cat_wrapper($query, array(), 'associated_options'); - -$result = pwg_query($query); -$associateds = array($storage_category_id); -while ($row = mysql_fetch_array($result)) -{ - array_push($associateds, $row['id']); -} -$query = ' -SELECT id,name,uppercats,global_rank - FROM '.CATEGORIES_TABLE.' - WHERE id NOT IN ('.implode(',', $associateds).') -;'; -display_select_cat_wrapper($query, array(), 'dissociated_options'); - -// representing -$query = ' -SELECT id,name,uppercats,global_rank - FROM '.CATEGORIES_TABLE.' - WHERE representative_picture_id = '.$_GET['image_id'].' -;'; -display_select_cat_wrapper($query, array(), 'elected_options'); - -$query = ' -SELECT id,name,uppercats,global_rank - FROM '.CATEGORIES_TABLE.' - WHERE representative_picture_id != '.$_GET['image_id'].' - OR representative_picture_id IS NULL -;'; -display_select_cat_wrapper($query, array(), 'dismissed_options'); - -//----------------------------------------------------------- sending html code - -$template->assign_var_from_handle('ADMIN_CONTENT', 'picture_modify'); -?> |