source: trunk/admin/picture_modify.php @ 6052

Last change on this file since 6052 was 6025, checked in by plg, 14 years ago

bug 1637: make the privacy level the same everywher, use "who can see this photo?"
instead of "minimum privacy level".

  • Property svn:eol-style set to LF
File size: 12.0 KB
RevLine 
[61]1<?php
[362]2// +-----------------------------------------------------------------------+
[2297]3// | Piwigo - a PHP based picture gallery                                  |
4// +-----------------------------------------------------------------------+
[5196]5// | Copyright(C) 2008-2010 Piwigo Team                  http://piwigo.org |
[2297]6// | Copyright(C) 2003-2008 PhpWebGallery Team    http://phpwebgallery.net |
7// | Copyright(C) 2002-2003 Pierrick LE GALL   http://le-gall.net/pierrick |
8// +-----------------------------------------------------------------------+
9// | This program is free software; you can redistribute it and/or modify  |
10// | it under the terms of the GNU General Public License as published by  |
11// | the Free Software Foundation                                          |
12// |                                                                       |
13// | This program is distributed in the hope that it will be useful, but   |
14// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
15// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
16// | General Public License for more details.                              |
17// |                                                                       |
18// | You should have received a copy of the GNU General Public License     |
19// | along with this program; if not, write to the Free Software           |
20// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
21// | USA.                                                                  |
22// +-----------------------------------------------------------------------+
[61]23
[575]24if(!defined("PHPWG_ROOT_PATH"))
[509]25{
[825]26  die('Hacking attempt!');
[509]27}
[825]28
[1072]29include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
30
[825]31// +-----------------------------------------------------------------------+
[1072]32// | Check Access and exit when user status is not ok                      |
33// +-----------------------------------------------------------------------+
34check_status(ACCESS_ADMINISTRATOR);
35
[5195]36check_input_parameter('image_id', $_GET, false, PATTERN_ID);
37check_input_parameter('cat_id', $_GET, false, PATTERN_ID);
38
[1072]39// +-----------------------------------------------------------------------+
[825]40// |                          synchronize metadata                         |
41// +-----------------------------------------------------------------------+
42
[1085]43if (isset($_GET['sync_metadata']) and !is_adviser())
[825]44{
45  $query = '
46SELECT path
47  FROM '.IMAGES_TABLE.'
48  WHERE id = '.$_GET['image_id'].'
49;';
[4325]50  list($path) = pwg_db_fetch_row(pwg_query($query));
[825]51  update_metadata(array($_GET['image_id'] => $path));
52
53  array_push($page['infos'], l10n('Metadata synchronized from file'));
54}
55
[61]56//--------------------------------------------------------- update informations
[825]57
[61]58// first, we verify whether there is a mistake on the given creation date
[825]59if (isset($_POST['date_creation_action'])
60    and 'set' == $_POST['date_creation_action'])
[61]61{
[5288]62  if (!is_numeric($_POST['date_creation_year'])
63    or !checkdate(
64          $_POST['date_creation_month'],
65          $_POST['date_creation_day'],
66          $_POST['date_creation_year'])
[825]67    )
[575]68  {
[5021]69    array_push($page['errors'], l10n('wrong date'));
[575]70  }
[61]71}
[825]72
[1571]73if (isset($_POST['submit']) and count($page['errors']) == 0 and !is_adviser())
[61]74{
[825]75  $data = array();
76  $data{'id'} = $_GET['image_id'];
77  $data{'name'} = $_POST['name'];
78  $data{'author'} = $_POST['author'];
[2090]79  $data['level'] = $_POST['level'];
[61]80
[825]81  if ($conf['allow_html_descriptions'])
82  {
83    $data{'comment'} = @$_POST['description'];
84  }
[61]85  else
[825]86  {
87    $data{'comment'} = strip_tags(@$_POST['description']);
88  }
[61]89
[825]90  if (isset($_POST['date_creation_action']))
91  {
92    if ('set' == $_POST['date_creation_action'])
93    {
94      $data{'date_creation'} = $_POST['date_creation_year']
95                                 .'-'.$_POST['date_creation_month']
96                                 .'-'.$_POST['date_creation_day'];
97    }
98    else if ('unset' == $_POST['date_creation_action'])
99    {
100      $data{'date_creation'} = '';
101    }
102  }
[61]103
[825]104  mass_updates(
105    IMAGES_TABLE,
106    array(
107      'primary' => array('id'),
108      'update' => array_diff(array_keys($data), array('id'))
109      ),
110    array($data)
111    );
112
[5188]113  // time to deal with tags
[5067]114  $tag_ids = array();
115  if (isset($_POST['tags']))
116  {
[5188]117    $tag_ids = get_fckb_tag_ids($_POST['tags']);
[5067]118  }
[5188]119  set_tags($tag_ids, $_GET['image_id']);
[1119]120
[825]121  array_push($page['infos'], l10n('Picture informations updated'));
[635]122}
123// associate the element to other categories than its storage category
124if (isset($_POST['associate'])
125    and isset($_POST['cat_dissociated'])
[1571]126    and count($_POST['cat_dissociated']) > 0
127    and !is_adviser()
128  )
[635]129{
[1121]130  associate_images_to_categories(
131    array($_GET['image_id']),
132    $_POST['cat_dissociated']
[1065]133    );
[635]134}
135// dissociate the element from categories (but not from its storage category)
136if (isset($_POST['dissociate'])
137    and isset($_POST['cat_associated'])
[1571]138    and count($_POST['cat_associated']) > 0
139    and !is_adviser()
140  )
[635]141{
[575]142  $query = '
143DELETE FROM '.IMAGE_CATEGORY_TABLE.'
144  WHERE image_id = '.$_GET['image_id'].'
[1121]145    AND category_id IN ('.implode(',', $_POST['cat_associated']).')
[635]146';
147  pwg_query($query);
[1609]148
[635]149  update_category($_POST['cat_associated']);
[61]150}
[640]151// elect the element to represent the given categories
152if (isset($_POST['elect'])
153    and isset($_POST['cat_dismissed'])
[1571]154    and count($_POST['cat_dismissed']) > 0
155    and !is_adviser()
156  )
[640]157{
158  $datas = array();
159  foreach ($_POST['cat_dismissed'] as $category_id)
160  {
161    array_push($datas,
162               array('id' => $category_id,
163                     'representative_picture_id' => $_GET['image_id']));
164  }
165  $fields = array('primary' => array('id'),
166                  'update' => array('representative_picture_id'));
167  mass_updates(CATEGORIES_TABLE, $fields, $datas);
168}
169// dismiss the element as representant of the given categories
170if (isset($_POST['dismiss'])
171    and isset($_POST['cat_elected'])
[1571]172    and count($_POST['cat_elected']) > 0
173    and !is_adviser()
174  )
[640]175{
176  set_random_representant($_POST['cat_elected']);
177}
[61]178
[5067]179// tags
180$query = '
181SELECT
182    tag_id,
[5188]183    name AS tag_name
[5067]184  FROM '.IMAGE_TAG_TABLE.' AS it
185    JOIN '.TAGS_TABLE.' AS t ON t.id = it.tag_id
186  WHERE image_id = '.$_GET['image_id'].'
187;';
[5188]188$tags = get_fckb_taglist($query);
[5067]189
[61]190// retrieving direct information about picture
[575]191$query = '
[825]192SELECT *
193  FROM '.IMAGES_TABLE.'
194  WHERE id = '.$_GET['image_id'].'
[575]195;';
[4325]196$row = pwg_db_fetch_assoc(pwg_query($query));
[345]197
[2575]198$storage_category_id = null;
199if (!empty($row['storage_category_id']))
200{
201  $storage_category_id = $row['storage_category_id'];
202}
203
[1092]204$image_file = $row['file'];
[635]205
[825]206// +-----------------------------------------------------------------------+
207// |                             template init                             |
208// +-----------------------------------------------------------------------+
209
[817]210$template->set_filenames(
211  array(
[2530]212    'picture_modify' => 'picture_modify.tpl'
[817]213    )
214  );
215
[2227]216$template->assign(
[825]217  array(
[5067]218    'tags' => $tags,
[825]219    'U_SYNC' =>
[2304]220        get_root_url().'admin.php?page=picture_modify'.
[825]221        '&amp;image_id='.$_GET['image_id'].
222        (isset($_GET['cat_id']) ? '&amp;cat_id='.$_GET['cat_id'] : '').
[1004]223        '&amp;sync_metadata=1',
[1092]224
[825]225    'PATH'=>$row['path'],
[1092]226
[1609]227    'TN_SRC' => get_thumbnail_url($row),
[1092]228
[825]229    'NAME' =>
230      isset($_POST['name']) ?
231        stripslashes($_POST['name']) : @$row['name'],
[1092]232
[825]233    'DIMENSIONS' => @$row['width'].' * '.@$row['height'],
[1092]234
[825]235    'FILESIZE' => @$row['filesize'].' KB',
[1092]236
[3122]237    'REGISTRATION_DATE' => format_date($row['date_available']),
[1092]238
[825]239    'AUTHOR' => isset($_POST['author']) ? $_POST['author'] : @$row['author'],
[1092]240
[825]241    'DESCRIPTION' =>
[1861]242      htmlspecialchars( isset($_POST['description']) ?
243        stripslashes($_POST['description']) : @$row['comment'] ),
[1092]244
[825]245    'F_ACTION' =>
[2304]246        get_root_url().'admin.php'
[825]247        .get_query_string_diff(array('sync_metadata'))
248    )
249  );
250
[1883]251if ($row['has_high'] == 'true')
252{
[2227]253  $template->assign(
254    'HIGH_FILESIZE',
255    isset($row['high_filesize'])
[1883]256        ? $row['high_filesize'].' KB'
[2227]257        : l10n('unknown')
[1883]258    );
259}
260
[2090]261// image level options
[2227]262$selected_level = isset($_POST['level']) ? $_POST['level'] : $row['level'];
263$template->assign(
[2090]264    array(
[6025]265      'level_options'=> get_privacy_level_options(),
[2227]266      'level_options_selected' => array($selected_level)
267    )
268  );
[2090]269
[825]270// creation date
271unset($day, $month, $year);
272
273if (isset($_POST['date_creation_action'])
274    and 'set' == $_POST['date_creation_action'])
275{
276  foreach (array('day', 'month', 'year') as $varname)
277  {
278    $$varname = $_POST['date_creation_'.$varname];
279  }
280}
281else if (isset($row['date_creation']) and !empty($row['date_creation']))
282{
283  list($year, $month, $day) = explode('-', $row['date_creation']);
284}
285else
286{
287  list($year, $month, $day) = array('', 0, 0);
288}
[2227]289
290
291$month_list = $lang['month'];
292$month_list[0]='------------';
293ksort($month_list);
[1092]294
[2227]295$template->assign(
296    array(
297      'DATE_CREATION_DAY_VALUE' => $day,
298      'DATE_CREATION_MONTH_VALUE' => $month,
299      'DATE_CREATION_YEAR_VALUE' => $year,
300      'month_list' => $month_list,
301      )
302    );
303
[825]304$query = '
305SELECT category_id, uppercats
306  FROM '.IMAGE_CATEGORY_TABLE.' AS ic
307    INNER JOIN '.CATEGORIES_TABLE.' AS c
308      ON c.id = ic.category_id
309  WHERE image_id = '.$_GET['image_id'].'
310;';
311$result = pwg_query($query);
312
[4325]313while ($row = pwg_db_fetch_assoc($result))
[825]314{
315  $name =
316    get_cat_display_name_cache(
317      $row['uppercats'],
[2227]318      get_root_url().'admin.php?page=cat_modify&amp;cat_id=',
[825]319      false
320      );
[1092]321
[825]322  if ($row['category_id'] == $storage_category_id)
323  {
[2227]324    $template->assign('STORAGE_CATEGORY', $name);
[825]325  }
326  else
327  {
[2227]328    $template->append('related_categories', $name);
[825]329  }
330}
331
332// jump to link
333//
334// 1. find all linked categories that are reachable for the current user.
335// 2. if a category is available in the URL, use it if reachable
336// 3. if URL category not available or reachable, use the first reachable
337//    linked category
338// 4. if no category reachable, no jumpto link
339
340$query = '
341SELECT category_id
342  FROM '.IMAGE_CATEGORY_TABLE.'
343  WHERE image_id = '.$_GET['image_id'].'
344;';
[1082]345
[825]346$authorizeds = array_diff(
347  array_from_query($query, 'category_id'),
[1082]348  explode(
349    ',',
350    calculate_permissions($user['id'], $user['status'])
351    )
[825]352  );
353
354if (isset($_GET['cat_id'])
355    and in_array($_GET['cat_id'], $authorizeds))
356{
[1503]357  $url_img = make_picture_url(
[1082]358    array(
359      'image_id' => $_GET['image_id'],
[1092]360      'image_file' => $image_file,
[1861]361      'category' => $cache['cat_names'][ $_GET['cat_id'] ],
[1082]362      )
363    );
[825]364}
365else
366{
367  foreach ($authorizeds as $category)
368  {
[1503]369    $url_img = make_picture_url(
[1082]370      array(
371        'image_id' => $_GET['image_id'],
[1092]372        'image_file' => $image_file,
[1861]373        'category' => $cache['cat_names'][ $category ],
[1082]374        )
375      );
[825]376    break;
377  }
378}
379
380if (isset($url_img))
381{
[2227]382  $template->assign( 'U_JUMPTO', $url_img );
[825]383}
[1092]384
[61]385// associate to another category ?
[635]386$query = '
387SELECT id,name,uppercats,global_rank
388  FROM '.CATEGORIES_TABLE.'
389    INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id = category_id
[2575]390  WHERE image_id = '.$_GET['image_id'];
391if (isset($storage_category_id))
392{
393  $query.= '
394    AND id != '.$storage_category_id;
395}
396$query.= '
[635]397;';
[2227]398display_select_cat_wrapper($query, array(), 'associated_options');
[635]399
400$result = pwg_query($query);
[3390]401$associateds = array(-1);
[2575]402if (isset($storage_category_id))
403{
404  array_push($associateds, $storage_category_id);
405}
[4325]406while ($row = pwg_db_fetch_assoc($result))
[345]407{
[635]408  array_push($associateds, $row['id']);
[345]409}
[635]410$query = '
411SELECT id,name,uppercats,global_rank
412  FROM '.CATEGORIES_TABLE.'
413  WHERE id NOT IN ('.implode(',', $associateds).')
414;';
[2227]415display_select_cat_wrapper($query, array(), 'dissociated_options');
[809]416
[640]417// representing
418$query = '
419SELECT id,name,uppercats,global_rank
420  FROM '.CATEGORIES_TABLE.'
421  WHERE representative_picture_id = '.$_GET['image_id'].'
422;';
[2227]423display_select_cat_wrapper($query, array(), 'elected_options');
[640]424
425$query = '
426SELECT id,name,uppercats,global_rank
427  FROM '.CATEGORIES_TABLE.'
[809]428  WHERE representative_picture_id != '.$_GET['image_id'].'
429    OR representative_picture_id IS NULL
[640]430;';
[2227]431display_select_cat_wrapper($query, array(), 'dismissed_options');
[817]432
[61]433//----------------------------------------------------------- sending html code
[817]434
[509]435$template->assign_var_from_handle('ADMIN_CONTENT', 'picture_modify');
[362]436?>
Note: See TracBrowser for help on using the repository browser.