source: trunk/admin/picture_modify.php @ 3390

Last change on this file since 3390 was 3390, checked in by plg, 15 years ago

merge r3389 from branch 2.0 to trunk

bug 1022 fixed: a photo can be associateed to no category (now that a photo
can have NULL as storage_category_id, it's possible to have no associated
category), the admin/picture_modify doesn't break anymore.

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