| 0,0 → 1,207 |
|---|
| <?php |
| // +-----------------------------------------------------------------------+ |
| // | PhpWebGallery - a PHP based picture gallery | |
| // | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net | |
| // | Copyright (C) 2003-2005 PhpWebGallery Team - http://phpwebgallery.net | |
| // +-----------------------------------------------------------------------+ |
| // | branch : BSF (Best So Far) |
| // | file : $RCSfile: functions_metadata.php,v $ |
| // | last update : $Date: 2005/02/13 12:49:52 $ |
| // | last modifier : $Author: plg $ |
| // | revision : $Revision: 1.16 $ |
| // +-----------------------------------------------------------------------+ |
| // | 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. | |
| // +-----------------------------------------------------------------------+ |
| |
| include_once(PHPWG_ROOT_PATH.'/include/functions_metadata.inc.php'); |
| |
| function get_sync_iptc_data($file) |
| { |
| global $conf; |
| |
| $map = $conf['use_iptc_mapping']; |
| $datefields = array('date_creation', 'date_available'); |
| |
| $iptc = get_iptc_data($file, $map); |
| |
| foreach ($iptc as $pwg_key => $value) |
| { |
| if (in_array($pwg_key, $datefields)) |
| { |
| if (preg_match('/(\d{4})(\d{2})(\d{2})/', $value, $matches)) |
| { |
| $iptc[$pwg_key] = $matches[1].'-'.$matches[2].'-'.$matches[3]; |
| } |
| } |
| } |
| |
| if (isset($iptc['keywords'])) |
| { |
| // keywords separator is the comma, nothing else. Allowed characters in |
| // keywords : [A-Za-z0-9], "-" and "_". All other characters will be |
| // considered as separators |
| $iptc['keywords'] = preg_replace('/[^\w-]+/', ',', $iptc['keywords']); |
| $iptc['keywords'] = preg_replace('/^,+|,+$/', '', $iptc['keywords']); |
| } |
| |
| return $iptc; |
| } |
| |
| function update_metadata($files) |
| { |
| global $conf; |
| |
| if (!defined('CURRENT_DATE')) |
| { |
| define('CURRENT_DATE', date('Y-m-d')); |
| } |
| |
| $datas = array(); |
| |
| foreach ($files as $id => $file) |
| { |
| $data = array(); |
| $data['id'] = $id; |
| $data['filesize'] = floor(filesize($file)/1024); |
| |
| if ($image_size = @getimagesize($file)) |
| { |
| $data['width'] = $image_size[0]; |
| $data['height'] = $image_size[1]; |
| } |
| |
| if ($conf['use_exif']) |
| { |
| if (!function_exists('read_exif_data')) |
| { |
| die('Exif extension not available, admin should disable exif use'); |
| } |
| |
| if ($exif = @read_exif_data($file)) |
| { |
| if (isset($exif['DateTime'])) |
| { |
| preg_match('/^(\d{4}).(\d{2}).(\d{2})/',$exif['DateTime'],$matches); |
| $data['date_creation'] = $matches[1].'-'.$matches[2].'-'.$matches[3]; |
| } |
| } |
| } |
| |
| if ($conf['use_iptc']) |
| { |
| $iptc = get_sync_iptc_data($file); |
| if (count($iptc) > 0) |
| { |
| foreach (array_keys($iptc) as $key) |
| { |
| $data[$key] = addslashes($iptc[$key]); |
| } |
| } |
| } |
| |
| $data['date_metadata_update'] = CURRENT_DATE; |
| |
| array_push($datas, $data); |
| } |
| |
| if (count($datas) > 0) |
| { |
| $update_fields = array('filesize','width','height','date_metadata_update'); |
| if ($conf['use_exif']) |
| { |
| array_push($update_fields, 'date_creation'); |
| } |
| if ($conf['use_iptc']) |
| { |
| $update_fields = array_merge($update_fields, |
| array_keys($conf['use_iptc_mapping'])); |
| } |
| |
| $fields = array('primary' => array('id'), |
| 'update' => array_unique($update_fields)); |
| mass_updates(IMAGES_TABLE, $fields, $datas); |
| } |
| } |
| |
| /** |
| * returns an array associating element id (images.id) with its complete |
| * path in the filesystem |
| * |
| * @param int id_uppercat |
| * @param boolean recursive ? |
| * @param boolean only newly added files ? |
| * @return array |
| */ |
| function get_filelist($category_id = '', $recursive = false, $only_new = false) |
| { |
| // filling $cat_ids : all categories required |
| $cat_ids = array(); |
| |
| $query = ' |
| SELECT id |
| FROM '.CATEGORIES_TABLE.' |
| WHERE site_id = 1 |
| AND dir IS NOT NULL'; |
| if (is_numeric($category_id)) |
| { |
| if ($recursive) |
| { |
| $query.= ' |
| AND uppercats REGEXP \'(^|,)'.$category_id.'(,|$)\' |
| '; |
| } |
| else |
| { |
| $query.= ' |
| AND id = '.$category_id.' |
| '; |
| } |
| } |
| $query.= ' |
| ;'; |
| $result = pwg_query($query); |
| while ($row = mysql_fetch_array($result)) |
| { |
| array_push($cat_ids, $row['id']); |
| } |
| |
| if (count($cat_ids) == 0) |
| { |
| return array(); |
| } |
| |
| $files = array(); |
| |
| $query = ' |
| SELECT id, path |
| FROM '.IMAGES_TABLE.' |
| WHERE storage_category_id IN ('.implode(',', $cat_ids).')'; |
| if ($only_new) |
| { |
| $query.= ' |
| AND date_metadata_update IS NULL |
| '; |
| } |
| $query.= ' |
| ;'; |
| $result = pwg_query($query); |
| while ($row = mysql_fetch_array($result)) |
| { |
| $files[$row['id']] = $row['path']; |
| } |
| |
| return $files; |
| } |
| ?> |