source: extensions/properties_mass_update/admin_update.php @ 15624

<?php
// +-----------------------------------------------------------------------+
// | Piwigo - a PHP based picture gallery                                  |
// +-----------------------------------------------------------------------+
// | Copyright(C) 2012     Pierrick LE GALL    http://le-gall.net/pierrick |
// +-----------------------------------------------------------------------+
// | This program is free software; you can redistribute it and/or modify  |
// | it under the terms of the GNU General Public License as published by  |
// | the Free Software Foundation                                          |
// |                                                                       |
// | This program is distributed in the hope that it will be useful, but   |
// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
// | General Public License for more details.                              |
// |                                                                       |
// | You should have received a copy of the GNU General Public License     |
// | along with this program; if not, write to the Free Software           |
// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
// | USA.                                                                  |
// +-----------------------------------------------------------------------+

if( !defined("PHPWG_ROOT_PATH") )
{
  die ("Hacking attempt!");
}

include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
include_once(PHPWG_ROOT_PATH.'admin/include/functions_upload.inc.php');

$admin_base_url = get_root_url().'admin.php?page=plugin-properties_mass_update-update';

// +-----------------------------------------------------------------------+
// | Check Access and exit when user status is not ok                      |
// +-----------------------------------------------------------------------+

check_status(ACCESS_ADMINISTRATOR);

// +-----------------------------------------------------------------------+
// |                                actions                                |
// +-----------------------------------------------------------------------+

if (isset($_FILES) and !empty($_FILES['update']))
{
  $starttime = get_moment();
  
  if (UPLOAD_ERR_OK == $_FILES['update']['error'])
  {
    if ('text/plain' == $_FILES['update']['type'])
    {
      $text_file = $_FILES['update']['tmp_name'];
    }
    else
    {
      array_push($page['errors'], l10n('Wrong file, please select a plain text file'));
    }

    if (isset($text_file))
    {
      $raw = file_get_contents($text_file);
      $raw_lines = explode("\n", $raw);
      
      $query = 'SELECT file FROM '.IMAGES_TABLE.';';
      $existing_files = hash_from_query($query, 'file');
            
      $updates = array();
      $update_files = array();
      $missing_files = array();
      
      foreach ($raw_lines as $raw_line)
      {
        if (!preg_match('/^([^\t]+)\t+(.*)$/', $raw_line, $matches))
        {
          continue;
        }
        
        // in case the same file is defined twice, we only save the first occurence
        if (isset($update_files[$matches[1]]) or isset($missing_files[$matches[1]]))
        {
          continue;
        }

        if (isset($existing_files[$matches[1]]))
        {        
          $update_files[$matches[1]] = true;
        }
        else
        {
          $missing_files[$matches[1]] = true;
          continue;
        }
        
        array_push(
          $updates,
          array(
            'file' => pwg_db_real_escape_string($matches[1]),
            'comment' => pwg_db_real_escape_string($matches[2]), // TODO right trim
            )
          );
      }
      
      mass_updates(
        IMAGES_TABLE,
          array(
            'primary' => array('file'),
            'update' => array('comment'),
          ),
          $updates
        );

      $endtime = get_moment();
      $elapsed = ($endtime - $starttime);

      array_push(
        $page['infos'],
        sprintf(
          l10n('%d photos updated'),
          count($updates)
          )
        );
      
      if (count($missing_files) > 0)
      {
        array_push(
          $page['errors'],
          sprintf(
            l10n('%d photos are missing in Piwigo: %s'),
            count($missing_files),
            implode(', ', array_keys($missing_files))
            )
          );
      }
    }
  }
  else
  {
    array_push($page['errors'], $_FILES['mascarille_update']['error']);
  }
}

// +-----------------------------------------------------------------------+
// | form options                                                          |
// +-----------------------------------------------------------------------+

// image level options
$selected_level = isset($_POST['level']) ? $_POST['level'] : 0;
$template->assign(
    array(
      'level_options'=> get_privacy_level_options(),
      'level_options_selected' => array($selected_level)
    )
  );
?>