source: branches/2.6/admin/picture_modify.php @ 27713

Revision 27713, 13.1 KB checked in by plg, 6 years ago (diff)

feature 3014: new trigger picture_modify_before_update

  • Property svn:eol-style set to LF
RevLine 
[61]1<?php
[362]2// +-----------------------------------------------------------------------+
[8728]3// | Piwigo - a PHP based photo gallery                                    |
[2297]4// +-----------------------------------------------------------------------+
[26461]5// | Copyright(C) 2008-2014 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
[13077]39// represent
40$query = '
41SELECT id
42  FROM '.CATEGORIES_TABLE.'
43  WHERE representative_picture_id = '.$_GET['image_id'].'
44;';
45$represent_options_selected = array_from_query($query, 'id');
46
[1072]47// +-----------------------------------------------------------------------+
[8764]48// |                             delete photo                              |
49// +-----------------------------------------------------------------------+
50
51if (isset($_GET['delete']))
52{
53  check_pwg_token();
54
55  delete_elements(array($_GET['image_id']), true);
[16334]56  invalidate_user_cache();
[8764]57
58  // where to redirect the user now?
59  //
60  // 1. if a category is available in the URL, use it
61  // 2. else use the first reachable linked category
62  // 3. redirect to gallery root
63
[9943]64  if (isset($_GET['cat_id']) and !empty($_GET['cat_id']))
[8764]65  {
66    redirect(
67      make_index_url(
68        array(
69          'category' => get_cat_info($_GET['cat_id'])
70          )
71        )
72      );
73  }
74
75  $query = '
76SELECT category_id
77  FROM '.IMAGE_CATEGORY_TABLE.'
78  WHERE image_id = '.$_GET['image_id'].'
79;';
80
81  $authorizeds = array_diff(
82    array_from_query($query, 'category_id'),
83    explode(',', calculate_permissions($user['id'], $user['status']))
84    );
[25975]85
[8764]86  foreach ($authorizeds as $category_id)
87  {
88    redirect(
89      make_index_url(
90        array(
91          'category' => get_cat_info($category_id)
92          )
93        )
94      );
95  }
96
97  redirect(make_index_url());
98}
99
100// +-----------------------------------------------------------------------+
[825]101// |                          synchronize metadata                         |
102// +-----------------------------------------------------------------------+
103
[8126]104if (isset($_GET['sync_metadata']))
[825]105{
[12831]106  sync_metadata(array( intval($_GET['image_id'])));
[25018]107  $page['infos'][] = l10n('Metadata synchronized from file');
[825]108}
109
[61]110//--------------------------------------------------------- update informations
[825]111
[61]112// first, we verify whether there is a mistake on the given creation date
[825]113if (isset($_POST['date_creation_action'])
114    and 'set' == $_POST['date_creation_action'])
[61]115{
[5288]116  if (!is_numeric($_POST['date_creation_year'])
117    or !checkdate(
118          $_POST['date_creation_month'],
119          $_POST['date_creation_day'],
120          $_POST['date_creation_year'])
[825]121    )
[575]122  {
[25018]123    $page['errors'][] = l10n('wrong date');
[575]124  }
[61]125}
[825]126
[8126]127if (isset($_POST['submit']) and count($page['errors']) == 0)
[61]128{
[825]129  $data = array();
130  $data{'id'} = $_GET['image_id'];
131  $data{'name'} = $_POST['name'];
132  $data{'author'} = $_POST['author'];
[2090]133  $data['level'] = $_POST['level'];
[61]134
[825]135  if ($conf['allow_html_descriptions'])
136  {
137    $data{'comment'} = @$_POST['description'];
138  }
[61]139  else
[825]140  {
141    $data{'comment'} = strip_tags(@$_POST['description']);
142  }
[61]143
[13077]144  if (!empty($_POST['date_creation_year']))
[825]145  {
[13077]146    $data{'date_creation'} =
147      $_POST['date_creation_year']
148      .'-'.$_POST['date_creation_month']
[20531]149      .'-'.$_POST['date_creation_day']
150      .' '.$_POST['date_creation_time'];
[825]151  }
[13077]152  else
153  {
154    $data{'date_creation'} = null;
155  }
[61]156
[27713]157  $data = trigger_change('picture_modify_before_update', $data);
158 
[25019]159  single_update(
[825]160    IMAGES_TABLE,
[25019]161    $data,
162    array('id' => $data['id'])
[825]163    );
164
[5188]165  // time to deal with tags
[5067]166  $tag_ids = array();
[11220]167  if (!empty($_POST['tags']))
[5067]168  {
[11039]169    $tag_ids = get_tag_ids($_POST['tags']);
[5067]170  }
[5188]171  set_tags($tag_ids, $_GET['image_id']);
[1119]172
[13077]173  // association to albums
[17980]174  if (!isset($_POST['associate']))
175  {
176    $_POST['associate'] = array();
177  }
[13077]178  move_images_to_categories(array($_GET['image_id']), $_POST['associate']);
[1609]179
[25975]180  invalidate_user_cache();
181
[13077]182  // thumbnail for albums
183  if (!isset($_POST['represent']))
[640]184  {
[13077]185    $_POST['represent'] = array();
[640]186  }
[25975]187
[13077]188  $no_longer_thumbnail_for = array_diff($represent_options_selected, $_POST['represent']);
189  if (count($no_longer_thumbnail_for) > 0)
190  {
191    set_random_representant($no_longer_thumbnail_for);
192  }
193
194  $new_thumbnail_for = array_diff($_POST['represent'], $represent_options_selected);
195  if (count($new_thumbnail_for) > 0)
196  {
197    $query = '
198UPDATE '.CATEGORIES_TABLE.'
199  SET representative_picture_id = '.$_GET['image_id'].'
200  WHERE id IN ('.implode(',', $new_thumbnail_for).')
201;';
202    pwg_query($query);
203  }
204
205  $represent_options_selected = $_POST['represent'];
[25975]206
[25018]207  $page['infos'][] = l10n('Photo informations updated');
[640]208}
[61]209
[5067]210// tags
211$query = '
212SELECT
[11853]213    id,
214    name
[5067]215  FROM '.IMAGE_TAG_TABLE.' AS it
216    JOIN '.TAGS_TABLE.' AS t ON t.id = it.tag_id
217  WHERE image_id = '.$_GET['image_id'].'
218;';
[11039]219$tag_selection = get_taglist($query);
[5067]220
[11039]221$query = '
222SELECT
[11853]223    id,
224    name
[11039]225  FROM '.TAGS_TABLE.'
226;';
[12259]227$tags = get_taglist($query, false);
[11039]228
[61]229// retrieving direct information about picture
[575]230$query = '
[825]231SELECT *
232  FROM '.IMAGES_TABLE.'
233  WHERE id = '.$_GET['image_id'].'
[575]234;';
[4325]235$row = pwg_db_fetch_assoc(pwg_query($query));
[345]236
[2575]237$storage_category_id = null;
238if (!empty($row['storage_category_id']))
239{
240  $storage_category_id = $row['storage_category_id'];
241}
242
[1092]243$image_file = $row['file'];
[635]244
[825]245// +-----------------------------------------------------------------------+
246// |                             template init                             |
247// +-----------------------------------------------------------------------+
248
[817]249$template->set_filenames(
250  array(
[2530]251    'picture_modify' => 'picture_modify.tpl'
[817]252    )
253  );
254
[13077]255$admin_url_start = $admin_photo_base_url.'-properties';
[8764]256$admin_url_start.= isset($_GET['cat_id']) ? '&amp;cat_id='.$_GET['cat_id'] : '';
257
[2227]258$template->assign(
[825]259  array(
[11039]260    'tag_selection' => $tag_selection,
[5067]261    'tags' => $tags,
[8764]262    'U_SYNC' => $admin_url_start.'&amp;sync_metadata=1',
263    'U_DELETE' => $admin_url_start.'&amp;delete=1&amp;pwg_token='.get_pwg_token(),
[1092]264
[825]265    'PATH'=>$row['path'],
[1092]266
[12796]267    'TN_SRC' => DerivativeImage::thumb_url($row),
[1092]268
[825]269    'NAME' =>
270      isset($_POST['name']) ?
271        stripslashes($_POST['name']) : @$row['name'],
[1092]272
[13077]273    'TITLE' => render_element_name($row),
274
[825]275    'DIMENSIONS' => @$row['width'].' * '.@$row['height'],
[1092]276
[825]277    'FILESIZE' => @$row['filesize'].' KB',
[1092]278
[3122]279    'REGISTRATION_DATE' => format_date($row['date_available']),
[1092]280
[6714]281    'AUTHOR' => htmlspecialchars(
282      isset($_POST['author'])
283        ? stripslashes($_POST['author'])
284        : @$row['author']
285      ),
[1092]286
[825]287    'DESCRIPTION' =>
[1861]288      htmlspecialchars( isset($_POST['description']) ?
289        stripslashes($_POST['description']) : @$row['comment'] ),
[1092]290
[825]291    'F_ACTION' =>
[2304]292        get_root_url().'admin.php'
[825]293        .get_query_string_diff(array('sync_metadata'))
294    )
295  );
296
[13077]297$added_by = 'N/A';
298$query = '
299SELECT '.$conf['user_fields']['username'].' AS username
300  FROM '.USERS_TABLE.'
301  WHERE '.$conf['user_fields']['id'].' = '.$row['added_by'].'
302;';
303$result = pwg_query($query);
304while ($user_row = pwg_db_fetch_assoc($result))
305{
[13084]306  $row['added_by'] = $user_row['username'];
[13077]307}
308
[13084]309$intro_vars = array(
[25005]310  'file' => l10n('Original file : %s', $row['file']),
311  'add_date' => l10n('Posted %s on %s', time_since($row['date_available'], 'year'), format_date($row['date_available'], false, false)),
312  'added_by' => l10n('Added by %s', $row['added_by']),
[13084]313  'size' => $row['width'].'&times;'.$row['height'].' pixels, '.sprintf('%.2f', $row['filesize']/1024).'MB',
[25005]314  'stats' => l10n('Visited %d times', $row['hit']),
315  'id' => l10n('Numeric identifier : %d', $row['id']),
[13077]316  );
317
318if ($conf['rate'] and !empty($row['rating_score']))
319{
320  $query = '
321SELECT
322    COUNT(*)
323  FROM '.RATE_TABLE.'
324  WHERE element_id = '.$_GET['image_id'].'
325;';
[13084]326  list($row['nb_rates']) = pwg_db_fetch_row(pwg_query($query));
[25975]327
[13086]328  $intro_vars['stats'].= ', '.sprintf(l10n('Rated %d times, score : %.2f'), $row['nb_rates'], $row['rating_score']);
[13077]329}
330
[13084]331$template->assign('INTRO', $intro_vars);
[13077]332
[25975]333
[13038]334if (in_array(get_extension($row['path']),$conf['picture_ext']))
335{
336  $template->assign('U_COI', get_root_url().'admin.php?page=picture_coi&amp;image_id='.$_GET['image_id']);
337}
338
[2090]339// image level options
[2227]340$selected_level = isset($_POST['level']) ? $_POST['level'] : $row['level'];
341$template->assign(
[2090]342    array(
[6025]343      'level_options'=> get_privacy_level_options(),
[2227]344      'level_options_selected' => array($selected_level)
345    )
346  );
[2090]347
[825]348// creation date
349unset($day, $month, $year);
350
351if (isset($_POST['date_creation_action'])
352    and 'set' == $_POST['date_creation_action'])
353{
[20531]354  foreach (array('day', 'month', 'year', 'time') as $varname)
[825]355  {
356    $$varname = $_POST['date_creation_'.$varname];
357  }
358}
359else if (isset($row['date_creation']) and !empty($row['date_creation']))
360{
[20531]361  list($year, $month, $day) = explode('-', substr($row['date_creation'],0,10));
362  $time = substr($row['date_creation'],11);
[825]363}
364else
365{
366  list($year, $month, $day) = array('', 0, 0);
[20531]367  $time = '00:00:00';
[825]368}
[2227]369
370
371$month_list = $lang['month'];
372$month_list[0]='------------';
373ksort($month_list);
[1092]374
[2227]375$template->assign(
376    array(
[24946]377      'DATE_CREATION_DAY_VALUE' => (int)$day,
378      'DATE_CREATION_MONTH_VALUE' => (int)$month,
[2227]379      'DATE_CREATION_YEAR_VALUE' => $year,
[20531]380      'DATE_CREATION_TIME_VALUE' => $time,
[2227]381      'month_list' => $month_list,
382      )
383    );
384
[825]385$query = '
386SELECT category_id, uppercats
387  FROM '.IMAGE_CATEGORY_TABLE.' AS ic
388    INNER JOIN '.CATEGORIES_TABLE.' AS c
389      ON c.id = ic.category_id
390  WHERE image_id = '.$_GET['image_id'].'
391;';
392$result = pwg_query($query);
393
[4325]394while ($row = pwg_db_fetch_assoc($result))
[825]395{
396  $name =
397    get_cat_display_name_cache(
398      $row['uppercats'],
[25425]399      get_root_url().'admin.php?page=album-'
[825]400      );
[1092]401
[825]402  if ($row['category_id'] == $storage_category_id)
403  {
[2227]404    $template->assign('STORAGE_CATEGORY', $name);
[825]405  }
406  else
407  {
[2227]408    $template->append('related_categories', $name);
[825]409  }
410}
411
412// jump to link
413//
414// 1. find all linked categories that are reachable for the current user.
415// 2. if a category is available in the URL, use it if reachable
416// 3. if URL category not available or reachable, use the first reachable
417//    linked category
418// 4. if no category reachable, no jumpto link
419
420$query = '
421SELECT category_id
422  FROM '.IMAGE_CATEGORY_TABLE.'
423  WHERE image_id = '.$_GET['image_id'].'
424;';
[1082]425
[825]426$authorizeds = array_diff(
427  array_from_query($query, 'category_id'),
[1082]428  explode(
429    ',',
430    calculate_permissions($user['id'], $user['status'])
431    )
[825]432  );
433
434if (isset($_GET['cat_id'])
435    and in_array($_GET['cat_id'], $authorizeds))
436{
[1503]437  $url_img = make_picture_url(
[1082]438    array(
439      'image_id' => $_GET['image_id'],
[1092]440      'image_file' => $image_file,
[1861]441      'category' => $cache['cat_names'][ $_GET['cat_id'] ],
[1082]442      )
443    );
[825]444}
445else
446{
447  foreach ($authorizeds as $category)
448  {
[1503]449    $url_img = make_picture_url(
[1082]450      array(
451        'image_id' => $_GET['image_id'],
[1092]452        'image_file' => $image_file,
[1861]453        'category' => $cache['cat_names'][ $category ],
[1082]454        )
455      );
[825]456    break;
457  }
458}
459
460if (isset($url_img))
461{
[2227]462  $template->assign( 'U_JUMPTO', $url_img );
[825]463}
[1092]464
[13077]465// associate to albums
[635]466$query = '
[13077]467SELECT id
[635]468  FROM '.CATEGORIES_TABLE.'
469    INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON id = category_id
[13077]470  WHERE image_id = '.$_GET['image_id'].'
[635]471;';
[13077]472$associate_options_selected = array_from_query($query, 'id');
[635]473
474$query = '
475SELECT id,name,uppercats,global_rank
476  FROM '.CATEGORIES_TABLE.'
477;';
[13077]478display_select_cat_wrapper($query, $associate_options_selected, 'associate_options');
479display_select_cat_wrapper($query, $represent_options_selected, 'represent_options');
[809]480
[61]481//----------------------------------------------------------- sending html code
[817]482
[509]483$template->assign_var_from_handle('ADMIN_CONTENT', 'picture_modify');
[362]484?>
Note: See TracBrowser for help on using the repository browser.