source: branches/2.6/admin/history.php @ 27693

Last change on this file since 27693 was 27693, checked in by rvelices, 10 years ago

Merged -r27692 from trunk to branch 2.6:
fix preg_replace_callback from -r26972

  • Property svn:eol-style set to LF
File size: 18.5 KB
RevLine 
[1727]1<?php
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// +-----------------------------------------------------------------------+
[1727]23
24/**
25 * Display filtered history lines
26 */
27
28// +-----------------------------------------------------------------------+
29// |                              functions                                |
30// +-----------------------------------------------------------------------+
31
32// +-----------------------------------------------------------------------+
33// |                           initialization                              |
34// +-----------------------------------------------------------------------+
35
36if (!defined('PHPWG_ROOT_PATH'))
37{
38  die('Hacking attempt!');
39}
40
41include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
[1881]42include_once(PHPWG_ROOT_PATH.'admin/include/functions_history.inc.php');
[1727]43
44if (isset($_GET['start']) and is_numeric($_GET['start']))
45{
46  $page['start'] = $_GET['start'];
47}
48else
49{
50  $page['start'] = 0;
51}
52
[1844]53$types = array('none', 'picture', 'high', 'other');
54
[5576]55$display_thumbnails = array('no_display_thumbnail' => l10n('No display'),
56                            'display_thumbnail_classic' => l10n('Classic display'),
57                            'display_thumbnail_hoverbox' => l10n('Hoverbox display')
58  );
59
[1727]60// +-----------------------------------------------------------------------+
61// | Check Access and exit when user status is not ok                      |
62// +-----------------------------------------------------------------------+
63
64check_status(ACCESS_ADMINISTRATOR);
65
66// +-----------------------------------------------------------------------+
67// | Build search criteria and redirect to results                         |
68// +-----------------------------------------------------------------------+
69
[1892]70$page['errors'] = array();
[1727]71$search = array();
72
73if (isset($_POST['submit']))
74{
75  // dates
76  if (!empty($_POST['start_year']))
77  {
78    $search['fields']['date-after'] = sprintf(
79      '%d-%02d-%02d',
80      $_POST['start_year'],
81      $_POST['start_month'],
82      $_POST['start_day']
83      );
84  }
85
86  if (!empty($_POST['end_year']))
87  {
88    $search['fields']['date-before'] = sprintf(
89      '%d-%02d-%02d',
90      $_POST['end_year'],
91      $_POST['end_month'],
92      $_POST['end_day']
93      );
94  }
95
[2157]96  if (empty($_POST['types']))
97  {
98    $search['fields']['types'] = $types;
99  }
100  else
101  {
102    $search['fields']['types'] = $_POST['types'];
103  }
[1890]104
105  $search['fields']['user'] = $_POST['user'];
[1892]106
107  if (!empty($_POST['image_id']))
108  {
109    $search['fields']['image_id'] = intval($_POST['image_id']);
110  }
[2245]111
[1892]112  if (!empty($_POST['filename']))
113  {
114    $search['fields']['filename'] = str_replace(
115      '*',
116      '%',
[4325]117      pwg_db_real_escape_string($_POST['filename'])
[1892]118      );
119  }
120
[14688]121  if (!empty($_POST['ip']))
122  {
123    $search['fields']['ip'] = str_replace(
124      '*',
125      '%',
126      pwg_db_real_escape_string($_POST['ip'])
127      );
128  }
129
[1992]130  $search['fields']['display_thumbnail'] = $_POST['display_thumbnail'];
131  // Display choise are also save to one cookie
[5576]132  if (!empty($_POST['display_thumbnail'])
133      and isset($display_thumbnails[$_POST['display_thumbnail']]))
134  {
135    $cookie_val = $_POST['display_thumbnail'];
136  }
137  else
138  {
139    $cookie_val = null;
140  }
[14688]141
[5576]142  pwg_set_cookie_var('display_thumbnail', $cookie_val, strtotime('+1 month') );
[1992]143
[1892]144  // TODO manage inconsistency of having $_POST['image_id'] and
145  // $_POST['filename'] simultaneously
[2245]146
[1727]147  if (!empty($search))
148  {
149    // register search rules in database, then they will be available on
150    // thumbnails page and picture page.
151    $query ='
152INSERT INTO '.SEARCH_TABLE.'
153  (rules)
154  VALUES
155  (\''.serialize($search).'\')
156;';
157    pwg_query($query);
158
[4892]159    $search_id = pwg_db_insert_id(SEARCH_TABLE);
[2245]160
[1727]161    redirect(
162      PHPWG_ROOT_PATH.'admin.php?page=history&search_id='.$search_id
163      );
164  }
165  else
166  {
[25018]167    $page['errors'][] = l10n('Empty query. No criteria has been entered.');
[1727]168  }
169}
170
171// +-----------------------------------------------------------------------+
172// |                             template init                             |
173// +-----------------------------------------------------------------------+
174
[2530]175$template->set_filename('history', 'history.tpl');
[1727]176
[1881]177// TabSheet initialization
178history_tabsheet();
179
[2245]180$template->assign(
[1727]181  array(
[5920]182    'U_HELP' => get_root_url().'admin/popuphelp.php?page=history',
[2245]183    'F_ACTION' => get_root_url().'admin.php?page=history'
[1727]184    )
185  );
186
187// +-----------------------------------------------------------------------+
188// |                             history lines                             |
189// +-----------------------------------------------------------------------+
190
191if (isset($_GET['search_id'])
192    and $page['search_id'] = (int)$_GET['search_id'])
193{
194  // what are the lines to display in reality ?
195  $query = '
196SELECT rules
197  FROM '.SEARCH_TABLE.'
198  WHERE id = '.$page['search_id'].'
199;';
[4325]200  list($serialized_rules) = pwg_db_fetch_row(pwg_query($query));
[1727]201
202  $page['search'] = unserialize($serialized_rules);
203
[1890]204  if (isset($_GET['user_id']))
205  {
206    if (!is_numeric($_GET['user_id']))
207    {
208      die('user_id GET parameter must be an integer value');
209    }
210
211    $page['search']['fields']['user'] = $_GET['user_id'];
[2157]212
[1890]213    $query ='
214INSERT INTO '.SEARCH_TABLE.'
215  (rules)
216  VALUES
217  (\''.serialize($page['search']).'\')
218;';
219    pwg_query($query);
220
[4892]221    $search_id = pwg_db_insert_id(SEARCH_TABLE);
[2245]222
[1890]223    redirect(
224      PHPWG_ROOT_PATH.'admin.php?page=history&search_id='.$search_id
225      );
226  }
227
[2157]228  $data = trigger_event('get_history', array(), $page['search'], $types);
229  usort($data, 'history_compare');
[1727]230
[2157]231  $page['nb_lines'] = count($data);
[1727]232
[1883]233  $history_lines = array();
234  $user_ids = array();
[1929]235  $username_of = array();
[1883]236  $category_ids = array();
237  $image_ids = array();
[14688]238  $has_tags = false;
[2157]239
240  foreach ($data as $row)
[1727]241  {
242    $user_ids[$row['user_id']] = 1;
243
244    if (isset($row['category_id']))
245    {
246      $category_ids[$row['category_id']] = 1;
247    }
248
249    if (isset($row['image_id']))
250    {
251      $image_ids[$row['image_id']] = 1;
252    }
253
[1891]254    if (isset($row['tag_ids']))
255    {
[14688]256      $has_tags = true;
[1891]257    }
258
[14688]259    $history_lines[] = $row;
[1727]260  }
261
262  // prepare reference data (users, tags, categories...)
263  if (count($user_ids) > 0)
264  {
265    $query = '
266SELECT '.$conf['user_fields']['id'].' AS id
267     , '.$conf['user_fields']['username'].' AS username
268  FROM '.USERS_TABLE.'
269  WHERE id IN ('.implode(',', array_keys($user_ids)).')
270;';
271    $result = pwg_query($query);
272
273    $username_of = array();
[4325]274    while ($row = pwg_db_fetch_assoc($result))
[1727]275    {
[4304]276      $username_of[$row['id']] = stripslashes($row['username']);
[1727]277    }
278  }
279
280  if (count($category_ids) > 0)
281  {
282    $query = '
283SELECT id, uppercats
284  FROM '.CATEGORIES_TABLE.'
285  WHERE id IN ('.implode(',', array_keys($category_ids)).')
286;';
287    $uppercats_of = simple_hash_from_query($query, 'id', 'uppercats');
288
289    $name_of_category = array();
[2245]290
[1727]291    foreach ($uppercats_of as $category_id => $uppercats)
292    {
293      $name_of_category[$category_id] = get_cat_display_name_cache(
294        $uppercats
295        );
296    }
297  }
298
299  if (count($image_ids) > 0)
300  {
301    $query = '
[1883]302SELECT
303    id,
304    IF(name IS NULL, file, name) AS label,
305    filesize,
[1991]306    file,
307    path,
[12796]308    representative_ext
[1727]309  FROM '.IMAGES_TABLE.'
310  WHERE id IN ('.implode(',', array_keys($image_ids)).')
311;';
[1883]312    // $label_of_image = simple_hash_from_query($query, 'id', 'label');
313    $label_of_image = array();
314    $filesize_of_image = array();
[1991]315    $file_of_image = array();
316    $path_of_image = array();
[12796]317    $representative_ext_of_image = array();
[1991]318
[1883]319    $result = pwg_query($query);
[4325]320    while ($row = pwg_db_fetch_assoc($result))
[1883]321    {
[27239]322      $label_of_image[ $row['id'] ] = trigger_event('render_element_description', $row['label']);
[1883]323
324      if (isset($row['filesize']))
325      {
326        $filesize_of_image[ $row['id'] ] = $row['filesize'];
327      }
328
[1991]329      $file_of_image[ $row['id'] ] = $row['file'];
330      $path_of_image[ $row['id'] ] = $row['path'];
[12796]331      $representative_ext_of_image[ $row['id'] ] = $row['representative_ext'];
[1883]332    }
[1727]333  }
[1891]334
[14688]335  if ($has_tags > 0)
[1891]336  {
337    $query = '
338SELECT
339    id,
[23151]340    name, url_name
[14688]341  FROM '.TAGS_TABLE;
[26999]342
343    global $name_of_tag; // used for preg_replace
[23151]344    $name_of_tag = array();
345    $result = pwg_query($query);
346    while ($row=pwg_db_fetch_assoc($result))
347    {
[26649]348      $name_of_tag[ $row['id'] ] = '<a href="'.make_index_url( array('tags'=>array($row))).'">'.trigger_event("render_tag_name", $row['name'], $row).'</a>';
[23151]349    }
[1891]350  }
[2245]351
[1727]352  $i = 0;
[1883]353  $first_line = $page['start'] + 1;
354  $last_line = $page['start'] + $conf['nb_logs_page'];
[1727]355
[1893]356  $summary['total_filesize'] = 0;
357  $summary['guests_IP'] = array();
[1883]358
[1727]359  foreach ($history_lines as $line)
360  {
[16282]361    if (isset($line['image_type']) and $line['image_type'] == 'high')
[1883]362    {
[16282]363      if (isset($filesize_of_image[$line['image_id']]))
[1883]364      {
[16282]365        $summary['total_filesize'] += $filesize_of_image[$line['image_id']];
[1883]366      }
367    }
[1893]368
369    if ($line['user_id'] == $conf['guest_id'])
370    {
371      if (!isset($summary['guests_IP'][ $line['IP'] ]))
372      {
373        $summary['guests_IP'][ $line['IP'] ] = 0;
374      }
[2245]375
[1893]376      $summary['guests_IP'][ $line['IP'] ]++;
377    }
[2245]378
[1883]379    $i++;
[2245]380
[1883]381    if ($i < $first_line or $i > $last_line)
382    {
383      continue;
384    }
[1890]385
386    $user_string = '';
387    if (isset($username_of[$line['user_id']]))
388    {
389      $user_string.= $username_of[$line['user_id']];
390    }
391    else
392    {
393      $user_string.= $line['user_id'];
394    }
395    $user_string.= '&nbsp;<a href="';
396    $user_string.= PHPWG_ROOT_PATH.'admin.php?page=history';
397    $user_string.= '&amp;search_id='.$page['search_id'];
398    $user_string.= '&amp;user_id='.$line['user_id'];
399    $user_string.= '">+</a>';
[1891]400
401    $tags_string = '';
402    if (isset($line['tag_ids']))
403    {
[26999]404      $tags_string = preg_replace_callback(
405        '/(\d+)/',
[27693]406        create_function('$m', 'global $name_of_tag; return isset($name_of_tag[$m[1]]) ? $name_of_tag[$m[1]] : $m[1];'),
[1891]407        str_replace(
408          ',',
409          ', ',
410          $line['tag_ids']
411          )
412        );
413    }
[1896]414
415    $image_string = '';
416    if (isset($line['image_id']))
417    {
418      $picture_url = make_picture_url(
419        array(
420          'image_id' => $line['image_id'],
421          )
422        );
[1992]423
[9808]424      if (isset($file_of_image[$line['image_id']]))
425      {
426        $element = array(
427          'id' => $line['image_id'],
428          'file' => $file_of_image[$line['image_id']],
429          'path' => $path_of_image[$line['image_id']],
[12796]430          'representative_ext' => $representative_ext_of_image[$line['image_id']],
[9808]431          );
432        $thumbnail_display = $page['search']['fields']['display_thumbnail'];
433      }
434      else
435      {
436        $thumbnail_display = 'no_display_thumbnail';
437      }
[1992]438
439      $image_title = '('.$line['image_id'].')';
440
[1896]441      if (isset($label_of_image[$line['image_id']]))
442      {
[1992]443        $image_title.= ' '.$label_of_image[$line['image_id']];
[1896]444      }
445      else
446      {
[1992]447        $image_title.= ' unknown filename';
[1896]448      }
[1992]449
450      $image_string = '';
451
[9808]452      switch ($thumbnail_display)
[1992]453      {
454        case 'no_display_thumbnail':
455        {
456          $image_string= '<a href="'.$picture_url.'">'.$image_title.'</a>';
457          break;
458        }
459        case 'display_thumbnail_classic':
460        {
461          $image_string =
462            '<a class="thumbnail" href="'.$picture_url.'">'
[12796]463            .'<span><img src="'.DerivativeImage::thumb_url($element)
[1992]464            .'" alt="'.$image_title.'" title="'.$image_title.'">'
465            .'</span></a>';
466          break;
467        }
468        case 'display_thumbnail_hoverbox':
469        {
470          $image_string =
471            '<a class="over" href="'.$picture_url.'">'
[12796]472            .'<span><img src="'.DerivativeImage::thumb_url($element)
[1992]473            .'" alt="'.$image_title.'" title="'.$image_title.'">'
474            .'</span>'.$image_title.'</a>';
475          break;
476        }
477      }
[1896]478    }
[2245]479
480    $template->append(
481      'search_results',
[1727]482      array(
483        'DATE'      => $line['date'],
484        'TIME'      => $line['time'],
[1890]485        'USER'      => $user_string,
[1727]486        'IP'        => $line['IP'],
[1896]487        'IMAGE'     => $image_string,
[1844]488        'TYPE'      => $line['image_type'],
[1727]489        'SECTION'   => $line['section'],
490        'CATEGORY'  => isset($line['category_id'])
[1821]491          ? ( isset($name_of_category[$line['category_id']])
492                ? $name_of_category[$line['category_id']]
493                : 'deleted '.$line['category_id'] )
[1727]494          : '',
[1891]495        'TAGS'       => $tags_string,
[1727]496        )
497      );
498  }
[1883]499
[1893]500  $summary['nb_guests'] = 0;
501  if (count(array_keys($summary['guests_IP'])) > 0)
502  {
503    $summary['nb_guests'] = count(array_keys($summary['guests_IP']));
504
505    // we delete the "guest" from the $username_of hash so that it is
506    // avoided in next steps
507    unset($username_of[ $conf['guest_id'] ]);
508  }
[2245]509
[1893]510  $summary['nb_members'] = count($username_of);
511
512  $member_strings = array();
513  foreach ($username_of as $user_id => $user_name)
514  {
515    $member_string = $user_name.'&nbsp;<a href="';
[2245]516    $member_string.= get_root_url().'admin.php?page=history';
[1893]517    $member_string.= '&amp;search_id='.$page['search_id'];
518    $member_string.= '&amp;user_id='.$user_id;
519    $member_string.= '">+</a>';
520
521    $member_strings[] = $member_string;
522  }
[2245]523
524  $template->assign(
525    'search_summary',
[1883]526    array(
[1932]527      'NB_LINES' => l10n_dec(
528        '%d line filtered', '%d lines filtered',
[1893]529        $page['nb_lines']
530        ),
[16282]531      'FILESIZE' => $summary['total_filesize'] != 0 ? ceil($summary['total_filesize']/1024).' MB' : '',
[1932]532      'USERS' => l10n_dec(
533        '%d user', '%d users',
[1893]534        $summary['nb_members'] + $summary['nb_guests']
535        ),
536      'MEMBERS' => sprintf(
[1932]537        l10n_dec('%d member', '%d members', $summary['nb_members']).': %s',
[25005]538        implode(', ', $member_strings)
[1893]539        ),
[1932]540      'GUESTS' => l10n_dec(
541        '%d guest', '%d guests',
[1893]542        $summary['nb_guests']
543        ),
[1883]544      )
545    );
[26999]546
547  unset($name_of_tag);
[1727]548}
549
550// +-----------------------------------------------------------------------+
551// |                            navigation bar                             |
552// +-----------------------------------------------------------------------+
553
554if (isset($page['search_id']))
555{
556  $navbar = create_navigation_bar(
[2245]557    get_root_url().'admin.php'.get_query_string_diff(array('start')),
[1727]558    $page['nb_lines'],
559    $page['start'],
560    $conf['nb_logs_page']
561    );
562
[3172]563  $template->assign('navbar', $navbar);
[1727]564}
565
566// +-----------------------------------------------------------------------+
567// |                             filter form                               |
568// +-----------------------------------------------------------------------+
569
570$form = array();
571
572if (isset($page['search']))
573{
574  if (isset($page['search']['fields']['date-after']))
575  {
576    $tokens = explode('-', $page['search']['fields']['date-after']);
[2245]577
[1727]578    $form['start_year']  = (int)$tokens[0];
579    $form['start_month'] = (int)$tokens[1];
580    $form['start_day']   = (int)$tokens[2];
581  }
582
583  if (isset($page['search']['fields']['date-before']))
584  {
585    $tokens = explode('-', $page['search']['fields']['date-before']);
[1817]586
587    $form['end_year']  = (int)$tokens[0];
588    $form['end_month'] = (int)$tokens[1];
589    $form['end_day']   = (int)$tokens[2];
[1727]590  }
[1817]591
[1844]592  $form['types'] = $page['search']['fields']['types'];
[1890]593
594  if (isset($page['search']['fields']['user']))
595  {
596    $form['user'] = $page['search']['fields']['user'];
597  }
598  else
599  {
600    $form['user'] = null;
601  }
[1892]602
603  $form['image_id'] = @$page['search']['fields']['image_id'];
604  $form['filename'] = @$page['search']['fields']['filename'];
[14688]605  $form['ip'] = @$page['search']['fields']['ip'];
[1992]606
607  $form['display_thumbnail'] = @$page['search']['fields']['display_thumbnail'];
[1727]608}
609else
610{
611  // by default, at page load, we want the selected date to be the current
612  // date
613  $form['start_year']  = $form['end_year']  = date('Y');
614  $form['start_month'] = $form['end_month'] = date('n');
615  $form['start_day']   = $form['end_day']   = date('j');
[1844]616  $form['types'] = $types;
[1992]617  // Hoverbox by default
618  $form['display_thumbnail'] =
[5576]619    pwg_get_cookie_var('display_thumbnail', 'no_display_thumbnail');
[1727]620}
621
622
[2245]623$month_list = $lang['month'];
624$month_list[0]='------------';
625ksort($month_list);
626
627$template->assign(
[1727]628  array(
[2245]629    'IMAGE_ID' => @$form['image_id'],
630    'FILENAME' => @$form['filename'],
[14688]631    'IP' => @$form['ip'],
[2245]632
633    'month_list' => $month_list,
634
635    'START_DAY_SELECTED' => @$form['start_day'],
636    'START_MONTH_SELECTED' => @$form['start_month'],
[1727]637    'START_YEAR' => @$form['start_year'],
[2245]638
639    'END_DAY_SELECTED' => @$form['end_day'],
640    'END_MONTH_SELECTED' => @$form['end_month'],
[1727]641    'END_YEAR'   => @$form['end_year'],
642    )
643  );
[1817]644
[2245]645$template->assign(
[1844]646    array(
[2245]647      'type_option_values' => $types,
648      'type_option_selected' => $form['types']
[1890]649    )
650  );
651
[2245]652
[1890]653$query = '
654SELECT
655    '.$conf['user_fields']['id'].' AS id,
656    '.$conf['user_fields']['username'].' AS username
657  FROM '.USERS_TABLE.'
658  ORDER BY username ASC
659;';
[2245]660$template->assign(
661  array(
662    'user_options' => simple_hash_from_query($query, 'id','username'),
663    'user_options_selected' => array(@$form['user'])
664  )
665);
[1890]666
[5576]667$template->assign('display_thumbnails', $display_thumbnails);
668$template->assign('display_thumbnail_selected', $form['display_thumbnail']);
[1890]669
[1727]670// +-----------------------------------------------------------------------+
671// |                           html code display                           |
672// +-----------------------------------------------------------------------+
673
674$template->assign_var_from_handle('ADMIN_CONTENT', 'history');
[2245]675?>
Note: See TracBrowser for help on using the repository browser.