get_cat_info($_GET['cat_id']) ) ) ); } $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'])) ); foreach ($authorizeds as $category_id) { redirect( make_index_url( array( 'category' => get_cat_info($category_id) ) ) ); } redirect(make_index_url()); } // +-----------------------------------------------------------------------+ // | synchronize metadata | // +-----------------------------------------------------------------------+ if (isset($_GET['sync_metadata'])) { sync_metadata(array( intval($_GET['image_id']))); 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 (!is_numeric($_POST['date_creation_year']) or !checkdate( $_POST['date_creation_month'], $_POST['date_creation_day'], $_POST['date_creation_year']) ) { array_push($page['errors'], l10n('wrong date')); } } if (isset($_POST['submit']) and count($page['errors']) == 0) { $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 (!empty($_POST['date_creation_year'])) { $data{'date_creation'} = $_POST['date_creation_year'] .'-'.$_POST['date_creation_month'] .'-'.$_POST['date_creation_day'] .' '.$_POST['date_creation_time']; } else { $data{'date_creation'} = null; } mass_updates( IMAGES_TABLE, array( 'primary' => array('id'), 'update' => array_diff(array_keys($data), array('id')) ), array($data) ); // time to deal with tags $tag_ids = array(); if (!empty($_POST['tags'])) { $tag_ids = get_tag_ids($_POST['tags']); } set_tags($tag_ids, $_GET['image_id']); // association to albums if (!isset($_POST['associate'])) { $_POST['associate'] = array(); } move_images_to_categories(array($_GET['image_id']), $_POST['associate']); // thumbnail for albums if (!isset($_POST['represent'])) { $_POST['represent'] = array(); } $no_longer_thumbnail_for = array_diff($represent_options_selected, $_POST['represent']); if (count($no_longer_thumbnail_for) > 0) { set_random_representant($no_longer_thumbnail_for); } $new_thumbnail_for = array_diff($_POST['represent'], $represent_options_selected); if (count($new_thumbnail_for) > 0) { $query = ' UPDATE '.CATEGORIES_TABLE.' SET representative_picture_id = '.$_GET['image_id'].' WHERE id IN ('.implode(',', $new_thumbnail_for).') ;'; pwg_query($query); } $represent_options_selected = $_POST['represent']; array_push($page['infos'], l10n('Photo informations updated')); } // tags $query = ' SELECT id, name FROM '.IMAGE_TAG_TABLE.' AS it JOIN '.TAGS_TABLE.' AS t ON t.id = it.tag_id WHERE image_id = '.$_GET['image_id'].' ;'; $tag_selection = get_taglist($query); $query = ' SELECT id, name FROM '.TAGS_TABLE.' ;'; $tags = get_taglist($query, false); // retrieving direct information about picture $query = ' SELECT * FROM '.IMAGES_TABLE.' WHERE id = '.$_GET['image_id'].' ;'; $row = pwg_db_fetch_assoc(pwg_query($query)); $storage_category_id = null; if (!empty($row['storage_category_id'])) { $storage_category_id = $row['storage_category_id']; } $image_file = $row['file']; // +-----------------------------------------------------------------------+ // | template init | // +-----------------------------------------------------------------------+ $template->set_filenames( array( 'picture_modify' => 'picture_modify.tpl' ) ); $admin_url_start = $admin_photo_base_url.'-properties'; $admin_url_start.= isset($_GET['cat_id']) ? '&cat_id='.$_GET['cat_id'] : ''; $template->assign( array( 'tag_selection' => $tag_selection, 'tags' => $tags, 'U_SYNC' => $admin_url_start.'&sync_metadata=1', 'U_DELETE' => $admin_url_start.'&delete=1&pwg_token='.get_pwg_token(), 'PATH'=>$row['path'], 'TN_SRC' => DerivativeImage::thumb_url($row), 'NAME' => isset($_POST['name']) ? stripslashes($_POST['name']) : @$row['name'], 'TITLE' => render_element_name($row), 'DIMENSIONS' => @$row['width'].' * '.@$row['height'], 'FILESIZE' => @$row['filesize'].' KB', 'REGISTRATION_DATE' => format_date($row['date_available']), 'AUTHOR' => htmlspecialchars( isset($_POST['author']) ? stripslashes($_POST['author']) : @$row['author'] ), 'DESCRIPTION' => htmlspecialchars( isset($_POST['description']) ? stripslashes($_POST['description']) : @$row['comment'] ), 'F_ACTION' => get_root_url().'admin.php' .get_query_string_diff(array('sync_metadata')) ) ); $added_by = 'N/A'; $query = ' SELECT '.$conf['user_fields']['username'].' AS username FROM '.USERS_TABLE.' WHERE '.$conf['user_fields']['id'].' = '.$row['added_by'].' ;'; $result = pwg_query($query); while ($user_row = pwg_db_fetch_assoc($result)) { $row['added_by'] = $user_row['username']; } $intro_vars = array( 'file' => l10n('Original file : %s', $row['file']), 'add_date' => l10n('Posted %s on %s', time_since($row['date_available'], 'year'), format_date($row['date_available'], false, false)), 'added_by' => l10n('Added by %s', $row['added_by']), 'size' => $row['width'].'×'.$row['height'].' pixels, '.sprintf('%.2f', $row['filesize']/1024).'MB', 'stats' => l10n('Visited %d times', $row['hit']), 'id' => l10n('Numeric identifier : %d', $row['id']), ); if ($conf['rate'] and !empty($row['rating_score'])) { $query = ' SELECT COUNT(*) FROM '.RATE_TABLE.' WHERE element_id = '.$_GET['image_id'].' ;'; list($row['nb_rates']) = pwg_db_fetch_row(pwg_query($query)); $intro_vars['stats'].= ', '.sprintf(l10n('Rated %d times, score : %.2f'), $row['nb_rates'], $row['rating_score']); } $template->assign('INTRO', $intro_vars); if (in_array(get_extension($row['path']),$conf['picture_ext'])) { $template->assign('U_COI', get_root_url().'admin.php?page=picture_coi&image_id='.$_GET['image_id']); } // image level options $selected_level = isset($_POST['level']) ? $_POST['level'] : $row['level']; $template->assign( array( 'level_options'=> get_privacy_level_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', 'time') as $varname) { $$varname = $_POST['date_creation_'.$varname]; } } else if (isset($row['date_creation']) and !empty($row['date_creation'])) { list($year, $month, $day) = explode('-', substr($row['date_creation'],0,10)); $time = substr($row['date_creation'],11); } else { list($year, $month, $day) = array('', 0, 0); $time = '00:00:00'; } $month_list = $lang['month']; $month_list[0]='------------'; ksort($month_list); $template->assign( array( 'DATE_CREATION_DAY_VALUE' => (int)$day, 'DATE_CREATION_MONTH_VALUE' => (int)$month, 'DATE_CREATION_YEAR_VALUE' => $year, 'DATE_CREATION_TIME_VALUE' => $time, '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 = pwg_db_fetch_assoc($result)) { $name = get_cat_display_name_cache( $row['uppercats'], get_root_url().'admin.php?page=album-', 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 albums $query = ' SELECT id FROM '.CATEGORIES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id = category_id WHERE image_id = '.$_GET['image_id'].' ;'; $associate_options_selected = array_from_query($query, 'id'); $query = ' SELECT id,name,uppercats,global_rank FROM '.CATEGORIES_TABLE.' ;'; display_select_cat_wrapper($query, $associate_options_selected, 'associate_options'); display_select_cat_wrapper($query, $represent_options_selected, 'represent_options'); //----------------------------------------------------------- sending html code $template->assign_var_from_handle('ADMIN_CONTENT', 'picture_modify'); ?>