function wppa_delete_photo($photo)
{
global $wppa_supported_audio_extensions;
global $wppa_supported_video_extensions;
global $wpdb;
$photoinfo = $wpdb->get_row($wpdb->prepare('SELECT * FROM `' . WPPA_PHOTOS . '` WHERE `id` = %s', $photo), ARRAY_A);
// Get album
$album = $photoinfo['album'];
// Get filename
$filename = $photoinfo['filename'];
// Delete multimedia files
if (wppa_is_multi($photo)) {
$mmfile = wppa_strip_ext(wppa_get_photo_path($photo));
$allsup = array_merge($wppa_supported_audio_extensions, $wppa_supported_video_extensions);
foreach ($allsup as $mmext) {
if (is_file($mmfile . '.' . $mmext)) {
@unlink($mmfile . '.' . $mmext);
}
}
}
// Delete fullsize image
$file = wppa_get_photo_path($photo);
$file = wppa_fix_poster_ext($file, $photo);
if (is_file($file)) {
unlink($file);
}
// Delete thumbnail image
$file = wppa_get_thumb_path($photo);
$file = wppa_fix_poster_ext($file, $photo);
if (is_file($file)) {
unlink($file);
}
// Delete sourcefile
wppa_delete_source($filename, $album);
// Delete index
wppa_index_remove('photo', $photo);
// Delete db entries
$wpdb->query($wpdb->prepare('DELETE FROM `' . WPPA_PHOTOS . '` WHERE `id` = %s LIMIT 1', $photo));
$wpdb->query($wpdb->prepare('DELETE FROM `' . WPPA_RATING . '` WHERE `photo` = %s', $photo));
$wpdb->query($wpdb->prepare('DELETE FROM `' . WPPA_COMMENTS . '` WHERE `photo` = %s', $photo));
$wpdb->query($wpdb->prepare('DELETE FROM `' . WPPA_IPTC . '` WHERE `photo` = %s', $photo));
$wpdb->query($wpdb->prepare('DELETE FROM `' . WPPA_EXIF . '` WHERE `photo` = %s', $photo));
wppa_flush_treecounts($album);
wppa_flush_upldr_cache('photoid', $photo);
// Delete from cloud
if (wppa_cdn('admin') == 'cloudinary') {
wppa_delete_from_cloudinary($photo);
}
}
function wppa_import_photos($delp = false, $dela = false, $delz = false, $delv = false, $delu = false, $delc = false, $delf = false)
{
global $wpdb;
global $warning_given;
global $wppa_supported_photo_extensions;
global $wppa_supported_video_extensions;
global $wppa_supported_audio_extensions;
$warning_given = false;
// Get this users current source directory setting
$user = wppa_get_user();
$source_type = get_option('wppa_import_source_type_' . $user, 'local');
if ($source_type == 'remote') {
wppa('is_remote', true);
}
$source = get_option('wppa_import_source_' . $user, WPPA_DEPOT_PATH);
$depot = WPPA_ABSPATH . $source;
// Filesystem
$depoturl = get_bloginfo('wpurl') . '/' . $source;
// url
// See what's in there
$files = wppa_get_import_files();
// First extract zips if our php version is ok
$idx = '0';
$zcount = 0;
if (PHP_VERSION_ID >= 50207) {
foreach ($files as $zipfile) {
if (isset($_POST['file-' . $idx])) {
$ext = strtolower(substr(strrchr($zipfile, "."), 1));
if ($ext == 'zip') {
$err = wppa_extract($zipfile, $delz);
if ($err == '0') {
$zcount++;
}
}
// if ext = zip
}
// if isset
$idx++;
}
// foreach
}
// Now see if albums must be created
$idx = '0';
$acount = 0;
foreach ($files as $album) {
if (isset($_POST['file-' . $idx])) {
$ext = strtolower(substr(strrchr($album, "."), 1));
if ($ext == 'amf') {
$name = '';
$desc = '';
$aord = '0';
$parent = '0';
$porder = '0';
$owner = '';
$handle = fopen($album, "r");
if ($handle) {
$buffer = fgets($handle, 4096);
while (!feof($handle)) {
$tag = substr($buffer, 0, 5);
$len = strlen($buffer) - 6;
// substract 5 for label and one for eol
$data = substr($buffer, 5, $len);
switch ($tag) {
case 'name=':
$name = $data;
break;
case 'desc=':
$desc = wppa_txt_to_nl($data);
break;
case 'aord=':
if (is_numeric($data)) {
$aord = $data;
}
break;
case 'prnt=':
if ($data == __('--- none ---', 'wp-photo-album-plus')) {
$parent = '0';
} elseif ($data == __('--- separate ---', 'wp-photo-album-plus')) {
$parent = '-1';
} else {
$prnt = wppa_get_album_id($data);
if ($prnt != '') {
$parent = $prnt;
} else {
$parent = '0';
wppa_warning_message(__('Unknown parent album:', 'wp-photo-album-plus') . ' ' . $data . ' ' . __('--- none --- used.', 'wp-photo-album-plus'));
}
}
break;
case 'pord=':
if (is_numeric($data)) {
$porder = $data;
}
break;
case 'ownr=':
$owner = $data;
break;
}
$buffer = fgets($handle, 4096);
}
// while !foef
fclose($handle);
if (wppa_get_album_id($name) != '') {
wppa_warning_message('Album already exists ' . stripslashes($name));
if ($dela) {
unlink($album);
}
} else {
$id = basename($album);
$id = substr($id, 0, strpos($id, '.'));
$id = wppa_create_album_entry(array('id' => $id, 'name' => stripslashes($name), 'description' => stripslashes($desc), 'a_order' => $aord, 'a_parent' => $parent, 'p_order_by' => $porder, 'owner' => $owner));
if ($id === false) {
wppa_error_message(__('Could not create album.', 'wp-photo-album-plus'));
} else {
//$id = wppa_get_album_id( $name );
wppa_set_last_album($id);
wppa_index_add('album', $id);
wppa_ok_message(__('Album #', 'wp-photo-album-plus') . ' ' . $id . ': ' . stripslashes($name) . ' ' . __('Added.', 'wp-photo-album-plus'));
if ($dela) {
unlink($album);
}
$acount++;
wppa_clear_cache();
wppa_flush_treecounts($id);
}
// album added
}
// album did not exist
}
// if handle ( file open )
}
// if its an album
}
// if isset
$idx++;
}
// foreach file
// Now the photos
$idx = '0';
$pcount = '0';
$totpcount = '0';
// find album id
if (isset($_POST['cre-album'])) {
// use album ngg gallery name for ngg conversion
$album = wppa_get_album_id(strip_tags($_POST['cre-album']));
if (!$album) {
// the album does not exist yet, create it
$name = strip_tags($_POST['cre-album']);
$desc = sprintf(__('This album has been converted from ngg gallery %s', 'wp-photo-album-plus'), $name);
$uplim = '0/0';
// Unlimited not to destroy the conversion process!!
$album = wppa_create_album_entry(array('name' => $name, 'description' => $desc, 'upload_limit' => $uplim));
if ($album === false) {
wppa_error_message(__('Could not create album.', 'wp-photo-album-plus') . '<br/>Query = ' . $query);
wp_die('Sorry, cannot continue');
}
}
} elseif (isset($_POST['wppa-photo-album'])) {
$album = $_POST['wppa-photo-album'];
} else {
$album = '0';
}
// Report starting process
wppa_ok_message(__('Processing files, please wait...', 'wp-photo-album-plus') . ' ' . __('If the line of dots stops growing or your browser reports Ready, your server has given up. In that case: try again', 'wp-photo-album-plus') . ' <a href="' . wppa_dbg_url(get_admin_url() . 'admin.php?page=wppa_import_photos') . '">' . __('here.', 'wp-photo-album-plus') . '</a>');
// Do them all
foreach (array_keys($files) as $file_idx) {
$unsanitized_path_name = $files[$file_idx];
$file = $files[$file_idx];
wppa_is_wppa_tree($file);
// Sets wppa( 'is_wppa_tree' )
if (isset($_POST['use-backup']) && is_file($file . '_backup')) {
$file = $file . '_backup';
}
$file = wppa_sanitize_file_name($file);
if (isset($_POST['file-' . $idx]) || wppa('ajax')) {
if (wppa('is_wppa_tree')) {
if (wppa('ajax')) {
wppa('ajax_import_files', basename(wppa_compress_tree_path($file)));
}
} else {
if (wppa('ajax')) {
wppa('ajax_import_files', basename($file));
}
}
$ext = strtolower(substr(strrchr($file, "."), 1));
$ext = str_replace('_backup', '', $ext);
if (in_array($ext, $wppa_supported_photo_extensions)) {
// See if a metafile exists
//$meta = substr( $file, 0, strlen( $file ) - 3 ).'pmf';
$meta = wppa_strip_ext($unsanitized_path_name) . '.PMF';
if (!is_file($meta)) {
$meta = wppa_strip_ext($unsanitized_path_name) . '.pmf';
}
// find all data: name, desc, porder form metafile
if (is_file($meta)) {
$alb = wppa_get_album_id(wppa_get_meta_album($meta));
$name = wppa_get_meta_name($meta);
$desc = wppa_txt_to_nl(wppa_get_meta_desc($meta));
$porder = wppa_get_meta_porder($meta);
$linkurl = wppa_get_meta_linkurl($meta);
$linktitle = wppa_get_meta_linktitle($meta);
} else {
$alb = $album;
// default album
$name = '';
// default name
$desc = '';
// default description
$porder = '0';
// default p_order
$linkurl = '';
$linktitle = '';
}
// If there is a video or audio with the same name, this is the poster.
$is_poster = wppa_file_is_in_album(wppa_strip_ext(basename($file)) . '.xxx', $alb);
if ($is_poster) {
// Delete possible poster sourcefile
wppa_delete_source(basename($file), $alb);
// Remove possible existing posters, the file-extension may be different as before
$old_photo = wppa_strip_ext(wppa_get_photo_path($is_poster));
$old_thumb = wppa_strip_ext(wppa_get_thumb_path($is_poster));
foreach ($wppa_supported_photo_extensions as $pext) {
if (is_file($old_photo . '.' . $pext)) {
unlink($old_photo . '.' . $pext);
}
if (is_file($old_thumb . '.' . $pext)) {
unlink($old_thumb . '.' . $pext);
}
}
// Clear sizes on db
wppa_update_photo(array('thumbx' => '0', 'thumby' => '0', 'photox' => '0', 'photoy' => '0'));
// Make new files
$bret = wppa_make_the_photo_files($file, $is_poster, strtolower(wppa_get_ext(basename($file))));
if ($bret) {
// Success
if (wppa('ajax')) {
wppa('ajax_import_files_done', true);
}
wppa_save_source($file, basename($file), $alb);
wppa_make_o1_source($is_poster);
$pcount++;
$totpcount += $bret;
if ($delp) {
unlink($file);
}
} else {
// Failed
if (!wppa('ajax')) {
wppa_error_message('Failed to add poster for item ' . $is_poster);
}
if ($delf) {
unlink($file);
}
}
} elseif (isset($_POST['wppa-update'])) {
if (wppa('is_wppa_tree')) {
$tmp = explode('/wppa/', $file);
$name = str_replace('/', '', $tmp[1]);
}
$iret = wppa_update_photo_files($unsanitized_path_name, $name);
if ($iret) {
if (wppa('ajax')) {
wppa('ajax_import_files_done', true);
}
$pcount++;
$totpcount += $iret;
if ($delp) {
unlink($unsanitized_path_name);
}
} else {
if ($delf) {
unlink($unsanitized_path_name);
}
}
} else {
if (is_numeric($alb) && $alb != '0') {
if (wppa('is_wppa_tree')) {
$tmp = explode('/wppa/', $file);
$id = str_replace('/', '', $tmp[1]);
$name = $id;
} else {
$id = basename($file);
}
if (wppa_switch('void_dups') && wppa_file_is_in_album($id, $alb)) {
wppa_warning_message(sprintf(__('Photo %s already exists in album %s. (1)', 'wp-photo-album-plus'), $id, $alb));
wppa('ajax_import_files_error', __('Duplicate', 'wp-photo-album-plus'));
if ($delf) {
unlink($file);
}
} else {
$id = substr($id, 0, strpos($id, '.'));
if (!is_numeric($id) || !wppa_is_id_free('photo', $id)) {
$id = 0;
}
if (wppa_insert_photo($unsanitized_path_name, $alb, stripslashes($name), stripslashes($desc), $porder, $id, stripslashes($linkurl), stripslashes($linktitle))) {
if (wppa('ajax')) {
wppa('ajax_import_files_done', true);
}
$pcount++;
if ($delp) {
unlink($unsanitized_path_name);
if (is_file($meta)) {
unlink($meta);
}
}
} else {
wppa_error_message(__('Error inserting photo', 'wp-photo-album-plus') . ' ' . basename($file) . '.');
if ($delf) {
unlink($unsanitized_path_name);
}
}
}
} else {
wppa_error_message(sprintf(__('Error inserting photo %s, unknown or non existent album.', 'wp-photo-album-plus'), basename($file)));
}
}
// Insert
}
}
$idx++;
if ($source_type == 'remote') {
unset($files[$file_idx]);
}
if (wppa_is_time_up()) {
wppa_warning_message(sprintf(__('Time out. %s photos imported. Please restart this operation.', 'wp-photo-album-plus'), $pcount));
wppa_set_last_album($album);
if ($source_type == 'remote') {
update_option('wppa_import_source_url_found_' . $user, $files);
}
return;
}
}
// foreach $files
if ($source_type == 'remote') {
update_option('wppa_import_source_url_found_' . $user, $files);
}
// Now the dirs to album imports
$idx = '0';
$dircount = '0';
global $photocount;
$photocount = '0';
$iret = true;
foreach ($files as $file) {
if (basename($file) != '.' && basename($file) != '..' && (isset($_POST['file-' . $idx]) || isset($_GET['continue']))) {
if (is_dir($file)) {
$iret = wppa_import_dir_to_album($file, '0');
if (wppa_is_time_up() && wppa_switch('auto_continue')) {
wppa('continue', 'continue');
}
$dircount++;
}
}
$idx++;
if ($iret == false) {
break;
}
// Time out
}
// Now the video files
$videocount = '0';
$alb = isset($_POST['wppa-video-album']) ? $_POST['wppa-video-album'] : '0';
if (wppa('ajax') && !$alb) {
wppa('ajax_import_files_error', __('Unknown album', 'wp-photo-album-plus'));
} else {
foreach (array_keys($files) as $idx) {
$file = $files[$idx];
if (isset($_POST['file-' . $idx]) || wppa('ajax')) {
if (wppa('ajax')) {
wppa('ajax_import_files', wppa_sanitize_file_name(basename($file)));
}
/* */
$ext = strtolower(substr(strrchr($file, "."), 1));
if (in_array($ext, $wppa_supported_video_extensions)) {
if (is_numeric($alb) && $alb != '0') {
// Do we have this filename with ext xxx in this album?
$filename = wppa_strip_ext(basename($file)) . '.xxx';
$id = wppa_file_is_in_album($filename, $alb);
// Or maybe the poster is already there
foreach ($wppa_supported_photo_extensions as $pext) {
if (!$id) {
$id = wppa_file_is_in_album(str_replace('xxx', $pext, $filename), $alb);
}
}
// This filename already exists: is the poster. Fix the filename in the photo info
if ($id) {
$fname = wppa_get_photo_item($id, 'filename');
$fname = wppa_strip_ext($fname) . '.xxx';
// Fix filename and ext in photo info
wppa_update_photo(array('id' => $id, 'filename' => $fname, 'ext' => 'xxx'));
}
// Add new entry
if (!$id) {
$id = wppa_create_photo_entry(array('album' => $alb, 'filename' => $filename, 'ext' => 'xxx', 'name' => wppa_strip_ext($filename)));
wppa_flush_treecounts($alb);
}
// Add video filetype
$newpath = wppa_strip_ext(wppa_get_photo_path($id)) . '.' . $ext;
$fs = filesize($file);
if ($fs > 1024 * 1024 * 64 || $delv) {
// copy fails for files > 64 Mb
// Remove old version if already exists
if (is_file($newpath)) {
unlink($newpath);
}
rename($file, $newpath);
} else {
copy($file, $newpath);
}
if (wppa('ajax')) {
wppa('ajax_import_files_done', true);
}
// Make sure ext is set to xxx after adding video to an existing poster
wppa_update_photo(array('id' => $id, 'ext' => 'xxx'));
// Book keeping
$videocount++;
} else {
wppa_error_message(sprintf(__('Error inserting video %s, unknown or non existent album.', 'wp-photo-album-plus'), basename($file)));
}
}
}
}
}
// Now the audio files
$audiocount = '0';
$alb = isset($_POST['wppa-audio-album']) ? $_POST['wppa-audio-album'] : '0';
if (wppa('ajax') && !$alb) {
wppa('ajax_import_files_error', __('Unknown album', 'wp-photo-album-plus'));
} else {
foreach (array_keys($files) as $idx) {
$file = $files[$idx];
if (isset($_POST['file-' . $idx]) || wppa('ajax')) {
if (wppa('ajax')) {
wppa('ajax_import_files', wppa_sanitize_file_name(basename($file)));
}
$ext = strtolower(substr(strrchr($file, "."), 1));
if (in_array($ext, $wppa_supported_audio_extensions)) {
if (is_numeric($alb) && $alb != '0') {
// Do we have this filename with ext xxx in this album?
$filename = wppa_strip_ext(basename($file)) . '.xxx';
$id = wppa_file_is_in_album($filename, $alb);
// Or maybe the poster is already there
foreach ($wppa_supported_photo_extensions as $pext) {
if (!$id) {
$id = wppa_file_is_in_album(str_replace('xxx', $pext, $filename), $alb);
}
}
// This filename already exists: is the poster. Fix the filename in the photo info
if ($id) {
$fname = wppa_get_photo_item($id, 'filename');
$fname = wppa_strip_ext($fname) . '.xxx';
// Fix filename and ext in photo info
wppa_update_photo(array('id' => $id, 'filename' => $fname, 'ext' => 'xxx'));
}
// Add new entry
if (!$id) {
$id = wppa_create_photo_entry(array('album' => $alb, 'filename' => $filename, 'ext' => 'xxx', 'name' => wppa_strip_ext($filename)));
wppa_flush_treecounts($alb);
}
// Add audio filetype
$newpath = wppa_strip_ext(wppa_get_photo_path($id)) . '.' . $ext;
copy($file, $newpath);
if ($delu) {
unlink($file);
}
if (wppa('ajax')) {
wppa('ajax_import_files_done', true);
}
// Make sure ext is set to xxx after adding audio to an existing poster
wppa_update_photo(array('id' => $id, 'ext' => 'xxx'));
// Book keeping
$audiocount++;
} else {
wppa_error_message(sprintf(__('Error inserting audio %s, unknown or non existent album.', 'wp-photo-album-plus'), basename($file)));
}
}
}
}
}
// The csv files. NOT with ajax
$csvcount = wppa_get_csvcount($files);
if ($csvcount) {
$csvcount = '0';
if (!wppa('ajax')) {
if (is_array($files)) {
// Make sure the feature is on
if (!wppa_switch('custom_fields')) {
wppa_update_option('wppa_custom_fields', 'yes');
echo '<b>' . __('Custom datafields enabled', 'wp-photo-album-plus') . '</b><br />';
}
// Get the captions we already have
$cust_labels = array();
for ($i = '0'; $i < '10'; $i++) {
$cust_labels[$i] = wppa_opt('custom_caption_' . $i);
}
// Process the files
$photos_processed_csv = '0';
$photos_skipped_csv = '0';
$is_db_table = false;
$tables = array(WPPA_ALBUMS, WPPA_PHOTOS, WPPA_RATING, WPPA_COMMENTS, WPPA_IPTC, WPPA_EXIF, WPPA_INDEX, WPPA_SESSION);
foreach (array_keys($files) as $idx) {
$this_skipped = '0';
$file = $files[$idx];
if (isset($_POST['file-' . $idx]) || isset($_GET['continue'])) {
$ext = strtolower(wppa_get_ext($file));
if ($ext == 'csv') {
// See if it is a db table
foreach (array_keys($tables) as $idx) {
$table_name = str_replace($wpdb->prefix, '', $tables[$idx]);
if (strpos($file, $table_name . '.csv') !== false) {
$is_db_table = $tables[$idx];
// Only administrators may do this
if (!current_user_can('administrator')) {
wppa_error_messgae(__('Only administrators are allowed to import db table data.', 'wp-photo-album-plus'));
return;
}
}
}
if ($is_db_table) {
echo '<b>' . __('Processing db table', 'wp-photo-album-plus') . ' ' . $is_db_table . '</b><br />';
wppa_log('dbg', __('Processing db table', 'wp-photo-album-plus') . ' ' . $is_db_table);
} else {
echo '<b>' . __('Processing', 'wp-photo-album-plus') . ' ' . basename($file) . '</b><br />';
wppa_log('dbg', __('Processing', 'wp-photo-album-plus') . ' ' . basename($file));
}
// Copy the file to a temp file
$tempfile = dirname($file) . '/temp.csv';
copy($file, $tempfile);
// Open file
$handle = fopen($tempfile, "rt");
if (!$handle) {
wppa_error_message(__('Can not open file. Can not continue. (1)', 'wp-photo-album-plus'));
return;
}
$write_handle = fopen($file, "wt");
if (!$write_handle) {
wppa_error_message(__('Can not open file. Can not continue. (2)', 'wp-photo-album-plus'));
return;
}
// Read header
$header = fgets($handle, 4096);
if (!$header) {
wppa_error_message(__('Can not read header. Can not continue.', 'wp-photo-album-plus'));
fclose($handle);
return;
}
fputs($write_handle, $header);
echo __('Read header:', 'wp-photo-album-plus') . ' ' . $header . '<br />';
// Is it a db table?
if ($is_db_table) {
// Functions for inserting db table data
$entry_functions = array(WPPA_ALBUMS => 'wppa_create_album_entry', WPPA_PHOTOS => 'wppa_create_photo_entry', WPPA_RATING => 'wppa_create_rating_entry', WPPA_COMMENTS => 'wppa_create_comments_entry', WPPA_IPTC => 'wppa_create_iptc_entry', WPPA_EXIF => 'wppa_create_exif_entry', WPPA_INDEX => 'wppa_create_index_entry');
// Interprete and verify header. All fields from .csv MUST be in table fields, else fail
$csv_fields = str_getcsv($header);
$db_fields = $wpdb->get_results("DESCRIBE `" . $is_db_table . "`", ARRAY_A);
foreach ($csv_fields as $csv_field) {
$ok = false;
foreach ($db_fields as $db_field) {
if ($db_field['Field'] === $csv_field) {
$ok = true;
}
}
if (!$ok) {
wppa_error_message('Field ' . $csv_field . ' not found in db table ' . $is_db_table . ' description');
wppa_error_message(__('Invalid header. Can not continue.', 'wp-photo-album-plus'));
fclose($handle);
return;
}
}
// Now process the lines
while (!feof($handle)) {
$dataline = fgets($handle, 16 * 4096);
if ($dataline) {
$data_arr = str_getcsv($dataline);
// Embedded newlines?
while (count($csv_fields) > count($data_arr) && !feof($handle)) {
// Assume continue after embedded linebreak
$dataline .= "\n" . fgets($handle, 16 * 4096);
$data_arr = str_getcsv($dataline);
}
reset($data_arr);
$id = trim(current($data_arr));
if (wppa_is_int($id) && $id > '0') {
wppa_dbg_msg('Processing id ' . $id);
$existing_data = $wpdb->get_row("SELECT * FROM `" . $is_db_table . "` WHERE `id` = {$id}", ARRAY_A);
// If entry exists:
// 1. save existing data,
// 2. remove entry,
if ($existing_data) {
$data = $existing_data;
$wpdb->query("DELETE FROM `" . $is_db_table . "` WHERE `id` = {$id}");
}
// Entry does not / no longer exist, add csv data to data array
foreach (array_keys($csv_fields) as $key) {
if (isset($data_arr[$key])) {
$data[$csv_fields[$key]] = $data_arr[$key];
}
}
// Insert 'new' entry
if (isset($entry_functions[$is_db_table])) {
$iret = call_user_func_array($entry_functions[$is_db_table], array($data));
if ($iret) {
$photos_processed_csv++;
} else {
// Write back to original file
fputs($write_handle, $dataline);
$photos_skipped_csv++;
$this_skipped++;
}
} else {
wppa_error_message('Table ' . $is_db_table . 'not supported');
return;
}
} else {
wppa_error_message('Id field not positive numeric: ' . $id);
// Write back to original file
fputs($write_handle, $dataline);
$photos_skipped_csv++;
$this_skipped++;
}
}
// Time up?
if (wppa_is_time_up() && wppa_switch('auto_continue')) {
wppa('continue', 'continue');
// Copy rest of file back to original
while (!feof($handle)) {
$temp = fgets($handle, 16 * 4096);
fputs($write_handle, $temp);
}
}
}
} else {
// Interprete header
$captions = str_getcsv($header);
if (!is_array($captions) || count($captions) < '2') {
wppa_error_message(__('Invalid header. Can not continue.', 'wp-photo-album-plus'));
fclose($handle);
return;
}
foreach (array_keys($captions) as $key) {
if ($key == '0') {
if (!in_array(strtolower(trim($captions['0'])), array('name', 'photoname', 'filename'))) {
wppa_error_message(__('Invalid header. First item must be \'name\', \'photoname\' or \'filename\'', 'wp-photo-album-plus'));
fclose($handle);
return;
}
} elseif (!in_array($captions[$key], $cust_labels)) {
if (!in_array('', $cust_labels)) {
wppa_error_message(__('All available custom data fields are in use. There is no space for', 'wp-photo-album-plus') . ' ' . $captions[$key]);
fclose($handle);
return;
}
// Add a new caption
$i = '0';
while ($cust_labels[$i]) {
$i++;
}
$cust_labels[$i] = $captions[$key];
wppa_update_option('wppa_custom_caption_' . $i, $cust_labels[$i]);
wppa_update_option('wppa_custom_visible_' . $i, 'yes');
wppa_log('dbg', sprintf(__('New caption %s added.', 'wp-photo-album-plus'), $cust_labels[$i]));
}
}
// Find the correlation between caption index and custom data index.
$pointers = array();
for ($i = '1'; $i < count($captions); $i++) {
for ($j = '0'; $j < '10'; $j++) {
if ($captions[$i] == $cust_labels[$j]) {
$pointers[$j] = $i;
}
}
}
// Now process the lines
while (!feof($handle)) {
$dataline = fgets($handle, 4096);
if ($dataline) {
wppa_log('dbg', __('Read data:', 'wp-photo-album-plus') . ' ' . trim($dataline));
$data_arr = str_getcsv($dataline);
foreach (array_keys($data_arr) as $i) {
if (!seems_utf8($data_arr[$i])) {
$data_arr[$i] = utf8_encode($data_arr[$i]);
}
}
$search = $data_arr[0];
switch (strtolower($captions[0])) {
case 'photoname':
$photos = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `name` = %s", $data_arr[0]), ARRAY_A);
break;
case 'filename':
$photos = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `filename` = %s", $data_arr[0]), ARRAY_A);
break;
case 'name':
$photos = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `name` = %s OR `filename` = %s", $data_arr[0], $data_arr[0]), ARRAY_A);
break;
}
if ($photos) {
foreach ($photos as $photo) {
$cust_data = $photo['custom'] ? unserialize($photo['custom']) : array('', '', '', '', '', '', '', '', '', '');
foreach (array_keys($pointers) as $p) {
$cust_data[$p] = wppa_sanitize_custom_field($data_arr[$pointers[$p]]);
}
wppa_update_photo(array('id' => $photo['id'], 'custom' => serialize($cust_data)));
$photos_processed_csv++;
}
wppa_log('dbg', 'Processed: ' . $data_arr[0]);
} else {
wppa_log('dbg', 'Could not find: ' . $data_arr[0]);
// Write back to original file
fputs($write_handle, $dataline);
$photos_skipped_csv++;
$this_skipped++;
}
echo '.';
}
// Time up?
if (wppa_is_time_up() && wppa_switch('auto_continue')) {
wppa('continue', 'continue');
// Copy rest of file back to original
while (!feof($handle)) {
$temp = fgets($handle, 4096);
fputs($write_handle, $temp);
}
}
}
}
fclose($handle);
fclose($write_handle);
$csvcount++;
// Remove tempfile
unlink($tempfile);
// Remove orig file
if (!$this_skipped && !wppa_is_time_up()) {
unlink($file);
}
}
}
}
}
}
}
wppa_ok_message(__('Done processing files.', 'wp-photo-album-plus'));
if ($pcount == '0' && $acount == '0' && $zcount == '0' && $dircount == '0' && $photocount == '0' && $videocount == '0' && $audiocount == '0' && $csvcount == '0') {
wppa_warning_message(__('No files to import.', 'wp-photo-album-plus'));
} else {
$msg = '';
if ($zcount) {
$msg .= $zcount . ' ' . __('Zipfiles extracted.', 'wp-photo-album-plus') . ' ';
}
if ($acount) {
$msg .= $acount . ' ' . __('Albums created.', 'wp-photo-album-plus') . ' ';
}
if ($dircount) {
$msg .= $dircount . ' ' . __('Directory to album imports.', 'wp-photo-album-plus') . ' ';
}
if ($photocount) {
$msg .= ' ' . sprintf(__('With total %s photos.', 'wppa', 'wp-photo-album-plus'), $photocount) . ' ';
}
if ($pcount) {
if (isset($_POST['wppa-update'])) {
$msg .= $pcount . ' ' . __('Photos updated', 'wp-photo-album-plus');
if ($totpcount != $pcount) {
$msg .= ' ' . sprintf(__('to %s locations', 'wp-photo-album-plus'), $totpcount);
}
$msg .= '.';
} else {
$msg .= $pcount . ' ' . __('single photos imported.', 'wp-photo-album-plus') . ' ';
}
}
if ($videocount) {
$msg .= $videocount . ' ' . __('Videos imported.', 'wp-photo-album-plus');
}
if ($audiocount) {
$msg .= $audiocount . ' ' . __('Audios imported.', 'wp-photo-album-plus');
}
if ($csvcount) {
$msg .= $csvcount . ' ' . __('CSVs imported,', 'wp-photo-album-plus') . ' ' . $photos_processed_csv . ' ' . __('items processed.', 'wp-photo-album-plus') . ' ' . $photos_skipped_csv . ' ' . __('items skipped.', 'wp-photo-album-plus');
}
wppa_ok_message($msg);
wppa_set_last_album($album);
}
}
