| @@ -1,36 +1,52 @@ | ||
| 1 | 1 | <?php |
| 2 | -/** | |
| 3 | - * Import Users plugin file. | |
| 4 | - * | |
| 5 | - * Copyright (C) 2010-2020, Smackcoders Inc - info@smackcoders.com | |
| 6 | - */ | |
| 2 | +/****************************************************************************************** | |
| 3 | + * Copyright (C) Smackcoders. - All Rights Reserved under Smackcoders Proprietary License | |
| 4 | + * Unauthorized copying of this file, via any medium is strictly prohibited | |
| 5 | + * Proprietary and confidential | |
| 6 | + * You can contact Smackcoders at email address info@smackcoders.com. | |
| 7 | + *******************************************************************************************/ | |
| 7 | 8 | |
| 8 | 9 | namespace Smackcoders\SMUSERS; |
| 9 | 10 | |
| 10 | 11 | if ( ! defined( 'ABSPATH' ) ) |
| 11 | - exit; // Exit if accessed directly | |
| 12 | +exit; // Exit if accessed directly | |
| 12 | 13 | |
| 13 | 14 | class MediaHandling{ |
| 14 | - private static $instance=null,$smack_instance; | |
| 15 | - public $header_array,$core_instance; | |
| 15 | + private static $instance=null; | |
| 16 | + public $header_array; | |
| 16 | 17 | public $value_array; |
| 17 | 18 | |
| 18 | 19 | public function __construct(){ |
| 19 | 20 | |
| 20 | - include_once(ABSPATH . 'wp-admin/includes/image.php'); | |
| 21 | + require_once(ABSPATH.'wp-load.php'); | |
| 22 | + require_once(ABSPATH . 'wp-admin/includes/image.php'); | |
| 23 | + require_once(ABSPATH . 'wp-admin/includes/file.php'); | |
| 21 | 24 | add_action('wp_ajax_image_options', array($this , 'imageOptions')); |
| 22 | 25 | add_action('wp_ajax_delete_image' , array($this , 'deleteImage')); |
| 26 | + add_action('wp_ajax_media_report' , array($this , 'mediaReport')); | |
| 23 | 27 | } |
| 24 | 28 | |
| 25 | - public static function imageOptions(){ | |
| 26 | - check_ajax_referer('smack-ultimate-csv-importer', 'securekey'); | |
| 27 | - $media_settings['media_handle_option'] = sanitize_text_field($_POST['media_handle_option']); | |
| 28 | - $media_settings['use_ExistingImage'] = sanitize_text_field($_POST['use_ExistingImage']); | |
| 29 | - $media_settings['enable_postcontent_image'] = sanitize_text_field($_POST['postContent_image_option']); | |
| 29 | + public static function imageOptions(){ | |
| 30 | + $media_settings['use_ExistingImage'] = $_POST['use_ExistingImage']; | |
| 31 | + $media_settings['overwriteImage'] = $_POST['overwriteImage']; | |
| 32 | + $media_settings['title'] = $_POST['title']; | |
| 33 | + $media_settings['caption'] = $_POST['caption']; | |
| 34 | + $media_settings['alttext'] = $_POST['alttext']; | |
| 35 | + $media_settings['description'] = $_POST['description']; | |
| 36 | + $media_settings['file_name'] = $_POST['file_name']; | |
| 37 | + $media_settings['thumbnail'] = $_POST['thumbnail']; | |
| 38 | + $media_settings['media_handle_option'] = $_POST['media_handle_option']; | |
| 39 | + $media_settings['medium'] = $_POST['medium']; | |
| 40 | + $media_settings['medium_large'] = $_POST['medium_large']; | |
| 41 | + $media_settings['large'] = $_POST['large']; | |
| 42 | + $media_settings['custom'] = $_POST['custom']; | |
| 43 | + $media_settings['custom_slug'] = $_POST['custom_slug']; | |
| 44 | + $media_settings['custom_slug'] = $_POST['custom_width']; | |
| 45 | + $media_settings['custom_height'] = $_POST['custom_height']; | |
| 30 | 46 | $image_info = array( |
| 31 | - 'media_settings' => $media_settings | |
| 32 | - ); | |
| 47 | + 'media_settings' => $media_settings | |
| 48 | + ); | |
| 33 | 49 | update_option( 'smack_image_options', $image_info ); |
| 34 | 50 | $result['success'] = 'true'; |
| 35 | 51 | echo wp_json_encode($result); |
| 36 | 52 | wp_die(); |
| @@ -37,8 +53,9 @@ | ||
| 37 | 53 | } |
| 38 | 54 | public static function getInstance() { |
| 39 | 55 | if (MediaHandling::$instance == null) { |
| 40 | 56 | MediaHandling::$instance = new MediaHandling; |
| 57 | + //MediaHandling::$instance->featured_image(); | |
| 41 | 58 | return MediaHandling::$instance; |
| 42 | 59 | } |
| 43 | 60 | return MediaHandling::$instance; |
| 44 | 61 | } |
| @@ -43,10 +60,9 @@ | ||
| 43 | 60 | return MediaHandling::$instance; |
| 44 | 61 | } |
| 45 | 62 | |
| 46 | 63 | public function deleteImage(){ |
| 47 | - check_ajax_referer('smack-ultimate-csv-importer', 'securekey'); | |
| 48 | - $image = sanitize_text_field($_POST['image']); | |
| 64 | + $image = $_POST['image']; | |
| 49 | 65 | $media_dir = wp_get_upload_dir(); |
| 50 | 66 | $names = glob($media_dir['path'].'/'.'*.*'); |
| 51 | 67 | foreach($names as $values){ |
| 52 | 68 | if (strpos($values, $image) !== false) { |
| @@ -56,180 +72,105 @@ | ||
| 56 | 72 | $result['success'] = 'true'; |
| 57 | 73 | echo wp_json_encode($result); |
| 58 | 74 | wp_die(); |
| 59 | 75 | } |
| 60 | - public function media_handling($img_url , $post_id , $data_array = null,$module = null, $image_type = null ,$hash_key = null,$templatekey = null,$header_array=null,$value_array=null,$indexs=null,$acf_wpname_element=null,$acf_image_meta=null){ | |
| 76 | + public function media_handling($img_url , $post_id , $data_array = null ,$module = null, $image_type = null ,$hash_key = null, $header_array = null , $value_array = null){ | |
| 61 | 77 | $encodedurl = urlencode($img_url); |
| 62 | 78 | $img_url = urldecode($encodedurl); |
| 63 | - $url = parse_url($img_url); | |
| 64 | - if($hash_key == null) | |
| 65 | - $hash_key = ""; | |
| 66 | 79 | $media_handle = get_option('smack_image_options'); |
| 67 | - if(isset($url['scheme']) && $url['scheme'] == 'http' || $url['scheme'] == 'https' ){ | |
| 68 | - $image_name = basename($img_url); | |
| 69 | - $image_title = sanitize_file_name( pathinfo( $image_name, PATHINFO_FILENAME ) ); | |
| 70 | - }else{ | |
| 71 | - $image_title=preg_replace('/\\.[^.\\s]{3,4}$/', '', $img_url); | |
| 72 | - } | |
| 80 | + $image_name = basename($img_url); | |
| 81 | + $image_title = sanitize_file_name( pathinfo( $image_name, PATHINFO_FILENAME ) ); | |
| 73 | 82 | global $wpdb; |
| 74 | - if($media_handle['media_settings']['use_ExistingImage'] == 'true'){ | |
| 75 | - if(is_numeric($img_url)){ | |
| 76 | - $attach_id=$img_url; | |
| 77 | - if(!empty($data_array['featured_image'])) { | |
| 78 | - set_post_thumbnail( $post_id, $attach_id ); | |
| 83 | + | |
| 84 | + if($media_handle['media_settings']['media_handle_option'] == 'true'){ | |
| 85 | + if($media_handle['media_settings']['use_ExistingImage'] == 'true'){ | |
| 86 | + $guid_url = $img_url; | |
| 87 | + $attachment_id = $wpdb->get_results("select ID from {$wpdb->prefix}posts where guid = '$guid_url'" ,ARRAY_A); | |
| 88 | + if(!empty($attachment_id)){ | |
| 89 | + foreach($attachment_id as $value){ | |
| 90 | + $attach_id = $value['ID']; | |
| 91 | + if(!wp_get_attachment_url($attach_id)){ | |
| 92 | + $attach_id = $this->image_function($img_url , $post_id , $data_array, '', 'use_existing_image',$header_array , $value_array ); | |
| 93 | + } | |
| 94 | + } | |
| 79 | 95 | } |
| 80 | - return $attach_id; | |
| 96 | + else{ | |
| 97 | + $attach_id = $this->image_function($img_url , $post_id , $data_array , '', 'use_existing_image',$header_array , $value_array); | |
| 98 | + } | |
| 81 | 99 | } |
| 82 | - else{ | |
| 83 | - $attachment_id = $wpdb->get_results( | |
| 84 | - $wpdb->prepare( | |
| 85 | - "SELECT ID FROM {$wpdb->prefix}posts WHERE post_type = 'attachment' AND guid LIKE %s", | |
| 86 | - '%' . $wpdb->esc_like( $image_title ) . '%' | |
| 87 | - ), | |
| 88 | - ARRAY_A | |
| 89 | - ); | |
| 90 | - | |
| 91 | - } | |
| 92 | - if(is_array($attachment_id) && !empty($attachment_id[0]['ID']) && $image_type != 'Featured'){ | |
| 93 | - $table_name = $wpdb->prefix . 'smackcsv_file_events'; | |
| 94 | - $post_title = $wpdb->get_var( | |
| 95 | - $wpdb->prepare( | |
| 96 | - "SELECT post_title FROM {$wpdb->prefix}posts WHERE ID = %d AND post_status != 'trash'", | |
| 97 | - absint( $post_id ) | |
| 98 | - ) | |
| 99 | - ); | |
| 100 | - $file_name = $wpdb->get_var( | |
| 101 | - $wpdb->prepare( | |
| 102 | - "SELECT file_name FROM $table_name WHERE hash_key = %s", | |
| 103 | - $hash_key | |
| 104 | - ) | |
| 105 | - ); | |
| 106 | - $shortcode_table = $wpdb->prefix . "ultimate_csv_importer_shortcode_manager"; | |
| 107 | - $attach_id = $attachment_id[0]['ID']; | |
| 108 | - $check_id = $wpdb->get_results( | |
| 109 | - $wpdb->prepare( | |
| 110 | - "SELECT ID FROM {$wpdb->prefix}posts WHERE ID = %d AND post_title ='image-failed' AND post_type = 'attachment' AND guid LIKE %s", | |
| 111 | - absint( $attach_id ), | |
| 112 | - '%' . $wpdb->esc_like( $image_title ) . '%' | |
| 113 | - ), | |
| 114 | - ARRAY_A | |
| 115 | - ); | |
| 116 | - if(!empty($check_id)){ | |
| 117 | - $failed_ids = $wpdb->get_results( | |
| 118 | - $wpdb->prepare( | |
| 119 | - "SELECT * FROM {$wpdb->prefix}ultimate_csv_importer_shortcode_manager WHERE post_id = %d AND media_id = %d", | |
| 120 | - absint( $post_id ), | |
| 121 | - absint( $attach_id ) | |
| 122 | - ) | |
| 123 | - ); | |
| 124 | - if(!empty($failed_ids) && $failed_ids[0]->post_id != $post_id){ | |
| 125 | - $attach_id = $check_id[0]['ID'];; | |
| 126 | - $insert_status = $wpdb->insert($shortcode_table, | |
| 127 | - array( | |
| 128 | - 'post_id' => $post_id, | |
| 129 | - 'post_title' => $post_title, | |
| 130 | - 'image_shortcode' => $image_type.'_image__'.$acf_wpname_element, | |
| 131 | - 'media_id' => $attach_id, | |
| 132 | - 'original_image' => $img_url, | |
| 133 | - 'indexs' => $indexs, | |
| 134 | - 'image_meta' => $acf_image_meta, | |
| 135 | - 'hash_key' => $hash_key, | |
| 136 | - 'import_type' => $module, | |
| 137 | - 'file_name' => $file_name | |
| 138 | - ), | |
| 139 | - array('%d','%s','%s','%d','%s','%d','%s','%s','%s','%s') | |
| 140 | - ); | |
| 141 | - if($insert_status){ | |
| 142 | - $this->store_failed_image_ids($attach_id); | |
| 143 | - } | |
| 144 | - | |
| 145 | - }elseif(($failed_ids[0]->post_id == $post_id) && ($check_id[0]['ID'] == $failed_ids[0]->media_id)){ | |
| 146 | - $attach_id = $check_id[0]['ID']; | |
| 147 | - $insert_status = $wpdb->insert($shortcode_table, | |
| 148 | - array( | |
| 149 | - 'post_id' => $post_id, | |
| 150 | - 'post_title' => $post_title, | |
| 151 | - 'image_shortcode' => $image_type.'_image__'.$acf_wpname_element, | |
| 152 | - 'media_id' => $attach_id, | |
| 153 | - 'original_image' => $img_url, | |
| 154 | - 'indexs' => $indexs, | |
| 155 | - 'image_meta' => $acf_image_meta, | |
| 156 | - 'hash_key' => $hash_key, | |
| 157 | - 'import_type' => $module, | |
| 158 | - 'file_name' => $file_name | |
| 159 | - ), | |
| 160 | - array('%d','%s','%s','%d','%s','%d','%s','%s','%s','%s') | |
| 161 | - ); | |
| 162 | - if($insert_status){ | |
| 163 | - $this->store_failed_image_ids($attach_id); | |
| 164 | - } | |
| 100 | + elseif($media_handle['media_settings']['overwriteImage'] == 'true'){ | |
| 101 | + $get_id = $wpdb->get_results("SELECT ID FROM {$wpdb->prefix}posts WHERE post_title = '$image_title' AND post_type = 'attachment' limit 1"); | |
| 102 | + if(!empty($get_id)){ | |
| 103 | + foreach($get_id as $value){ | |
| 104 | + $attach_id = $value->ID; | |
| 105 | + $this->overwrite($attach_id , $img_url); | |
| 106 | + if(!empty($data_array['featured_image'])) { | |
| 107 | + set_post_thumbnail( $post_id, $attach_id ); | |
| 165 | 108 | } |
| 166 | - elseif(empty($failed_ids) ){ | |
| 167 | - $insert_status = $wpdb->insert($shortcode_table, | |
| 168 | - array( | |
| 169 | - 'post_id' => $post_id, | |
| 170 | - 'post_title' => $post_title, | |
| 171 | - 'image_shortcode' => $image_type.'_image__'.$acf_wpname_element, | |
| 172 | - 'media_id' => $attach_id, | |
| 173 | - 'original_image' => $img_url, | |
| 174 | - 'indexs'=>$indexs, | |
| 175 | - 'hash_key' => $hash_key, | |
| 176 | - 'import_type' => $module, | |
| 177 | - 'file_name' => $file_name, | |
| 178 | - ), | |
| 179 | - array('%d','%s','%s','%d','%s','%d','%s','%s','%s') | |
| 180 | - ); | |
| 181 | - if($insert_status){ | |
| 182 | - $this->store_failed_image_ids($attach_id); | |
| 183 | - } | |
| 184 | - } | |
| 185 | - | |
| 186 | - //return $attach_id; | |
| 187 | - } | |
| 109 | + } | |
| 110 | + } | |
| 111 | + else{ | |
| 112 | + $attach_id = $this->image_function($img_url , $post_id , $data_array,'','',$header_array , $value_array); | |
| 113 | + } | |
| 188 | 114 | } |
| 189 | 115 | else{ |
| 190 | - $attach_id = $this->image_function($img_url , $post_id , $data_array,'','use_existing_image',$header_array,$value_array); | |
| 116 | + $attach_id = $this->image_function($img_url , $post_id , $data_array,'','',$header_array , $value_array); | |
| 191 | 117 | } |
| 192 | - | |
| 193 | 118 | } |
| 194 | 119 | else{ |
| 195 | - $img_url = is_array($img_url) ? implode(',', array_filter($img_url)) : $img_url; | |
| 196 | - $hash_key = is_array($hash_key) ? implode(',', array_filter($hash_key)) : $hash_key; | |
| 197 | - $templatekey = is_array($templatekey) ? implode(',', array_filter($templatekey)) : $templatekey; | |
| 198 | - $module = is_array($module) ? implode(',', array_filter($module)) : $module; | |
| 199 | - $image_type = is_array($image_type) ? implode(',', array_filter($image_type)) : $image_type; | |
| 200 | - $img_url = esc_sql($img_url); | |
| 201 | - $hash_key = esc_sql($hash_key); | |
| 202 | - $templatekey = esc_sql($templatekey); | |
| 203 | - $module = esc_sql($module); | |
| 204 | - $image_type = esc_sql($image_type); | |
| 205 | - | |
| 206 | - $attach_id = $this->image_function($img_url, $post_id, $data_array,'','',$header_array,$value_array); | |
| 207 | - // if ($attach_id != null) { | |
| 208 | - // global $wpdb; | |
| 209 | - // $image_table = $wpdb->prefix . "ultimate_csv_importer_media"; | |
| 210 | - // $wpdb->query($wpdb->prepare("INSERT INTO $image_table (image_url, attach_id, post_id, hash_key, templatekey, module, image_type, status) VALUES (%s, %d, %d, %s, %s, %s, %s, 'Completed')",$img_url,$attach_id,$post_id,$hash_key,$templatekey,$module,$image_type)); | |
| 211 | - // } | |
| 120 | + $guid_url = $img_url; | |
| 121 | + $attachment_id = $wpdb->get_results("select ID from {$wpdb->prefix}posts where guid = '$guid_url'" ,ARRAY_A); | |
| 212 | 122 | |
| 123 | + if(!empty($attachment_id)){ | |
| 124 | + | |
| 125 | + foreach($attachment_id as $value){ | |
| 126 | + $attach_id = $value['ID']; | |
| 127 | + if($_wp_attachment_metadata = get_post_meta($attach_id, '_wp_attachment_metadata', true)){ | |
| 128 | + // When an attachment is available on Media and not has attachment link | |
| 129 | + if(!is_array($_wp_attachment_metadata)){ | |
| 130 | + $attach_id = $this->image_function($img_url , $post_id , $data_array,'','',$header_array , $value_array); | |
| 131 | + } | |
| 132 | + } | |
| 133 | + //set_post_thumbnail( $post_id, $attach_id ); | |
| 134 | + } | |
| 135 | + } | |
| 213 | 136 | } |
| 214 | 137 | return $attach_id; |
| 215 | 138 | } |
| 216 | 139 | |
| 140 | + public function mediaReport(){ | |
| 141 | + global $wpdb; | |
| 142 | + $list_of_images = $wpdb->get_results("select * from {$wpdb->prefix}ultimate_csv_importer_media GROUP BY `hash_key`,`image_type` ",ARRAY_A); | |
| 143 | + foreach( $list_of_images as $list_key => $list_val ) | |
| 144 | + { | |
| 145 | + if(!empty($list_val['hash_key'])){ | |
| 146 | + $file_name = $wpdb->get_results("select file_name from {$wpdb->prefix}smackcsv_file_events where hash_key = '{$list_val['hash_key']}'",ARRAY_A); | |
| 147 | + } | |
| 148 | + $filename[$list_key]= $file_name[0]['file_name']; | |
| 149 | + $module[$list_key] = $list_val['module']; | |
| 150 | + $image_type[$list_key] = $list_val['image_type']; | |
| 151 | + $image_status[$list_key] = $list_val['status']; | |
| 152 | + $number_of_images = $wpdb->get_results("select image_url from {$wpdb->prefix}ultimate_csv_importer_media where hash_key = '{$list_val['hash_key']}' and image_type = '{$image_type[$list_key]}' ",ARRAY_A); | |
| 153 | + $count[$list_key] = count($number_of_images); | |
| 154 | + } | |
| 155 | + $response['file_name'] = $filename ; | |
| 156 | + $response['module'] = $module ; | |
| 157 | + $response['count'] = $count; | |
| 158 | + $response['image_type'] = $image_type; | |
| 159 | + $response['status'] = $image_status; | |
| 160 | + echo wp_json_encode($response); | |
| 161 | + wp_die(); | |
| 162 | + } | |
| 163 | + | |
| 217 | 164 | public function image_function($f_img , $post_id , $data_array = null,$option_name = null, $use_existing_image = false,$header_array = null , $value_array = null){ |
| 218 | - | |
| 165 | + | |
| 219 | 166 | global $wpdb; |
| 220 | - $f_img = urldecode($f_img); | |
| 221 | - // $image = explode("?", $f_img); | |
| 222 | - // $f_img=$image[0]; | |
| 223 | 167 | $media_handle = get_option('smack_image_options'); |
| 224 | - if(!empty($header_array) && !empty($value_array) ){ | |
| 225 | - $media_settings = array_combine($header_array,$value_array); | |
| 226 | - } | |
| 168 | + $media_settings = array_combine($header_array,$value_array); | |
| 227 | 169 | if(isset($media_handle['media_settings']['alttext'])) { |
| 228 | - $alttext ['_wp_attachment_image_alt'] = isset($media_settings[$media_handle['media_settings']['alttext']]) ? $media_settings[$media_handle['media_settings']['alttext']] :''; | |
| 170 | + $alttext ['_wp_attachment_image_alt'] = $media_settings[$media_handle['media_settings']['alttext']]; | |
| 229 | 171 | } |
| 230 | - | |
| 231 | - if(preg_match_all('/\b(?:(?:https?|http|ftp|file):\/\/|www\.|ftp\.)[-A-Z0-9+&@#\/%=~_|$?!:,.]*[A-Z0-9+&@#\/%=~_|$]/i', $f_img , $matchedlist, PREG_PATTERN_ORDER)) { | |
| 172 | + if(preg_match_all('/\b(?:(?:https?|?:http?|ftp|file):\/\/|www\.|ftp\.)[-A-Z0-9+&@#\/%=~_|$?!:,.]*[A-Z0-9+&@#\/%=~_|$]/i', $f_img , $matchedlist, PREG_PATTERN_ORDER)) { | |
| 232 | 173 | $f_img = $f_img; |
| 233 | 174 | } |
| 234 | 175 | else{ |
| 235 | 176 | $media_dir = wp_get_upload_dir(); |
| @@ -239,20 +180,18 @@ | ||
| 239 | 180 | $f_img = $media_dir['url'].'/'.$f_img; |
| 240 | 181 | } |
| 241 | 182 | } |
| 242 | 183 | } |
| 243 | - | |
| 244 | 184 | $image_name = pathinfo($f_img); |
| 245 | - //if(!empty($media_handle['media_settings']['file_name'])){ | |
| 246 | - //$file_type = wp_check_filetype( $f_img, null ); | |
| 247 | - //$ext = '.'. $file_type['ext']; | |
| 248 | - // if(!empty($media_settings[$media_handle['media_settings']['file_name']])){ | |
| 249 | - // $fimg_name = $media_settings[$media_handle['media_settings']['file_name']].$ext; | |
| 250 | - // } | |
| 251 | - //} | |
| 252 | - //else{ | |
| 185 | + if(!empty($media_handle['media_settings']['file_name'])){ | |
| 186 | + $file_type = wp_check_filetype( $f_img, null ); | |
| 187 | + $ext = '.'. $file_type['ext']; | |
| 188 | + $fimg_name = $media_settings[$media_handle['media_settings']['file_name']].$ext; | |
| 189 | + } | |
| 190 | + else{ | |
| 253 | 191 | $fimg_name = $image_name['basename']; |
| 254 | - //} | |
| 192 | + } | |
| 193 | + | |
| 255 | 194 | $file_type = wp_check_filetype( $fimg_name, null ); |
| 256 | 195 | if($use_existing_image){ |
| 257 | 196 | if(empty($file_type['ext'])){ |
| 258 | 197 | $fimg_name = @basename($f_img); |
| @@ -258,14 +197,10 @@ | ||
| 258 | 197 | $fimg_name = @basename($f_img); |
| 259 | 198 | $fimg_name = str_replace(' ', '-', trim($fimg_name)); |
| 260 | 199 | $fimg_name = preg_replace('/[^a-zA-Z0-9._\-\s]/', '', $fimg_name); |
| 261 | 200 | } |
| 262 | - $attachment_id = $wpdb->get_var( | |
| 263 | - $wpdb->prepare( | |
| 264 | - "SELECT ID FROM ".$wpdb->prefix."posts WHERE post_type = 'attachment' AND guid LIKE %s", | |
| 265 | - '%' . $wpdb->esc_like( $fimg_name ) | |
| 266 | - ) | |
| 267 | - ); | |
| 201 | + $attachment_id = $wpdb->get_var("SELECT ID FROM ".$wpdb->prefix."posts WHERE post_type = 'attachment' AND guid LIKE '%$fimg_name'"); | |
| 202 | + | |
| 268 | 203 | if($attachment_id){ |
| 269 | 204 | if(!empty($data_array['featured_image'])){ |
| 270 | 205 | set_post_thumbnail( $post_id, $attachment_id ); |
| 271 | 206 | return $attachment_id; |
| @@ -275,20 +210,12 @@ | ||
| 275 | 210 | } |
| 276 | 211 | } |
| 277 | 212 | |
| 278 | 213 | $attachment_title = sanitize_file_name( pathinfo( $fimg_name, PATHINFO_FILENAME ) ); |
| 279 | - $file_type = wp_check_filetype( $fimg_name, null ); | |
| 280 | 214 | $dir = wp_upload_dir(); |
| 281 | 215 | $dirname = date('Y') . '/' . date('m'); |
| 282 | - $uploads_use_yearmonth = get_option('uploads_use_yearmonth_folders'); | |
| 283 | - if($uploads_use_yearmonth == 1){ | |
| 284 | - $uploaddir_paths = $dir ['basedir'] . '/' . $dirname ; | |
| 285 | - $uploaddir_url = $dir ['baseurl'] . '/' . $dirname; | |
| 286 | - } | |
| 287 | - else{ | |
| 288 | - $uploaddir_paths = $dir ['basedir']; | |
| 289 | - $uploaddir_url = $dir ['baseurl']; | |
| 290 | - } | |
| 216 | + $uploaddir_paths = $dir ['basedir'] . '/' . $dirname ; | |
| 217 | + $uploaddir_url = $dir ['baseurl'] . '/' . $dirname; | |
| 291 | 218 | $f_img = str_replace(" ","%20",$f_img); |
| 292 | 219 | if(empty($file_type['ext'])){ |
| 293 | 220 | $fimg_name = @basename($f_img); |
| 294 | 221 | $fimg_name = str_replace(' ', '-', trim($fimg_name)); |
| @@ -294,25 +221,13 @@ | ||
| 294 | 221 | $fimg_name = str_replace(' ', '-', trim($fimg_name)); |
| 295 | 222 | $fimg_name = preg_replace('/[^a-zA-Z0-9._\-\s]/', '', $fimg_name); |
| 296 | 223 | } |
| 297 | 224 | if ($uploaddir_paths != "" && $uploaddir_paths) { |
| 298 | - if (strpos($fimg_name, ' ') !== false) { | |
| 299 | - $fimg_name = str_replace(' ', '-', $fimg_name); | |
| 300 | - $fimg_name = preg_replace('/[^a-zA-Z0-9._\-\s]/', '', $fimg_name); | |
| 301 | - } | |
| 302 | 225 | $uploaddir_path = $uploaddir_paths . "/" . $fimg_name; |
| 303 | 226 | } |
| 304 | - | |
| 305 | - if($file_type['ext'] == 'jpeg'){ | |
| 306 | - $response = wp_safe_remote_get($f_img, array( 'timeout' => 30)); | |
| 307 | - }else{ | |
| 308 | - $response = wp_safe_remote_get($f_img, array( 'timeout' => 10)); | |
| 309 | - } | |
| 310 | - if(is_wp_error($response)) { | |
| 311 | - return null; | |
| 312 | - } | |
| 313 | - $rawdata = wp_remote_retrieve_body($response); | |
| 314 | - | |
| 227 | + //Removed curl and added wordpress http api | |
| 228 | + $response = wp_remote_get($f_img, array( 'timeout' => 10)); | |
| 229 | + $rawdata = wp_remote_retrieve_body($response); | |
| 315 | 230 | $http_code = wp_remote_retrieve_response_code($response); |
| 316 | 231 | if($http_code == 404){ |
| 317 | 232 | return null; |
| 318 | 233 | } |
| @@ -317,291 +232,423 @@ | ||
| 317 | 232 | return null; |
| 318 | 233 | } |
| 319 | 234 | |
| 320 | 235 | if ( $http_code != 200 && strpos( $rawdata, 'Not Found' ) != 0 ) { |
| 321 | - return null; | |
| 236 | + $rawdata = null; | |
| 322 | 237 | } |
| 323 | - if(is_plugin_active('exmage-wp-image-links/exmage-wp-image-links.php')){ | |
| 324 | - $guid =$fimg_name; | |
| 325 | - } | |
| 326 | 238 | if ($rawdata == false) { |
| 327 | 239 | return null; |
| 328 | 240 | } else { |
| 329 | - if(is_plugin_active('exmage-wp-image-links/exmage-wp-image-links.php')){ | |
| 330 | - $link = new \EXMAGE_WP_IMAGE_LINKS; | |
| 331 | - $postID = $link->add_image($data_array['featured_image'],$value); | |
| 332 | - wp_update_post(array( | |
| 333 | - 'ID' => $postID['id'], | |
| 334 | - 'post_title' => $data_array['title'], | |
| 335 | - 'post_content' => $data_array['description'], | |
| 336 | - 'post_excerpt' => $data_array['caption'] | |
| 337 | - )); | |
| 338 | - // if($postID['id'] != null && isset($data_array['alt_text'])){ | |
| 339 | - //update_post_meta($postID['id'], '_wp_attachment_image_alt', $data_array['alt_text']); | |
| 340 | - //} | |
| 341 | - } | |
| 342 | - else{ | |
| 343 | - if (file_exists($uploaddir_path)) { | |
| 344 | - $i = 1; | |
| 345 | - $exist = true; | |
| 346 | - while($exist){ | |
| 347 | - $fimg_name = $attachment_title . "-" . $i . "." . $file_type['ext']; | |
| 348 | - $uploaddir_path = $uploaddir_paths . "/" . $fimg_name; | |
| 349 | 241 | |
| 350 | - if (file_exists($uploaddir_path)) { | |
| 351 | - $i = $i + 1; | |
| 352 | - } | |
| 353 | - else{ | |
| 354 | - $exist = false; | |
| 355 | - } | |
| 242 | + if (file_exists($uploaddir_path)) { | |
| 243 | + $i = 1; | |
| 244 | + $exist = true; | |
| 245 | + while($exist){ | |
| 246 | + $fimg_name = $attachment_title . "-" . $i . "." . $file_type['ext']; | |
| 247 | + $uploaddir_path = $uploaddir_paths . "/" . $fimg_name; | |
| 248 | + | |
| 249 | + if (file_exists($uploaddir_path)) { | |
| 250 | + $i = $i + 1; | |
| 356 | 251 | } |
| 252 | + else{ | |
| 253 | + $exist = false; | |
| 254 | + } | |
| 357 | 255 | } |
| 358 | - $fp = fopen($uploaddir_path, 'x'); | |
| 359 | - fwrite($fp, $rawdata); | |
| 360 | - fclose($fp); | |
| 361 | 256 | } |
| 257 | + | |
| 258 | + $fp = fopen($uploaddir_path, 'x'); | |
| 259 | + fwrite($fp, $rawdata); | |
| 260 | + fclose($fp); | |
| 362 | 261 | } |
| 363 | 262 | if(empty($file_type['type'])){ |
| 364 | 263 | $file_type['type'] = 'image/jpeg'; |
| 365 | 264 | } |
| 366 | - if(is_plugin_active('exmage-wp-image-links/exmage-wp-image-links.php')){ | |
| 367 | - $guids =$data_array['featured_image']; | |
| 265 | + $post_info = array( | |
| 266 | + 'guid' => $uploaddir_url . "/" . $fimg_name, | |
| 267 | + 'post_mime_type' => $file_type['type'], | |
| 268 | + 'post_title' => $attachment_title, | |
| 269 | + 'post_content' => '', | |
| 270 | + 'post_status' => 'inherit', | |
| 271 | + ); | |
| 272 | + //unset( $post_info['ID'] ); | |
| 273 | + $attach_id = wp_insert_attachment( $post_info,$uploaddir_path, $post_id ); | |
| 274 | + $attach_data = wp_generate_attachment_metadata( $attach_id, $uploaddir_path ); | |
| 275 | + wp_update_attachment_metadata( $attach_id, $attach_data ); | |
| 276 | + if($media_handle['media_settings']['thumbnail'] = 'true') { | |
| 277 | + $thumbnail_width = get_option('thumbnail_size_w'); | |
| 278 | + $thumbnail_height = get_option('thumbnail_size_h'); | |
| 279 | + $metadata = wp_get_attachment_metadata($attach_id); | |
| 280 | + $metadata['width'] = $thumbnail_width; | |
| 281 | + $metadata['height'] = $thumbnail_height; | |
| 282 | + wp_update_attachment_metadata($attach_id,$metadata); | |
| 368 | 283 | } |
| 369 | - else{ | |
| 370 | - $guids=$uploaddir_url . "/" . $fimg_name; | |
| 284 | + elseif($media_handle['media_settings']['medium_'] = 'true'){ | |
| 285 | + $medium_width = get_option('medium_size_w'); | |
| 286 | + $medium_height = get_option('medium_size_h'); | |
| 287 | + $metadata = wp_get_attachment_metadata($attach_id); | |
| 288 | + $metadata['width'] = $medium_width; | |
| 289 | + $metadata['height'] = $medium_height; | |
| 290 | + wp_update_attachment_metadata($attach_id,$metadata); | |
| 371 | 291 | } |
| 372 | - if(!empty($data_array['title'])){ | |
| 373 | - $attachment_title = $data_array['title']; | |
| 374 | - }else{ | |
| 375 | - $attachment_title = str_replace('-', ' ', $attachment_title); | |
| 292 | + elseif($media_handle['media_settings']['medium_large'] = 'true') { | |
| 293 | + $medium_large_width = get_option('medium_large_size_w'); | |
| 294 | + $medium_large_height = get_option('medium_large_size_h'); | |
| 295 | + //add_image_size( 'medium_large', $medium_large_width, $medium_large_height, true ); | |
| 296 | + $metadata = wp_get_attachment_metadata($attach_id); | |
| 297 | + $metadata['width'] = $medium_large_width; | |
| 298 | + $metadata['height'] = $medium_large_height; | |
| 299 | + wp_update_attachment_metadata($attach_id,$metadata); | |
| 376 | 300 | } |
| 377 | - $post_info = array( | |
| 378 | - 'guid' => $guids, | |
| 379 | - 'post_mime_type' => $file_type['type'], | |
| 380 | - 'post_title' => $attachment_title, | |
| 381 | - 'post_content' => '', | |
| 382 | - 'post_status' => 'inherit', | |
| 383 | - ); | |
| 384 | - if(!is_plugin_active('exmage-wp-image-links/exmage-wp-image-links.php')){ | |
| 385 | - $attach_id = wp_insert_attachment( $post_info,$uploaddir_path, $post_id ); | |
| 386 | - $attach_data = wp_generate_attachment_metadata( $attach_id, $uploaddir_path ); | |
| 387 | - wp_update_attachment_metadata( $attach_id, $attach_data ); | |
| 301 | + elseif($media_handle['media_settings']['large'] = 'true'){ | |
| 302 | + $large_width = get_option('large_size_w'); | |
| 303 | + $large_height = get_option('large_size_h'); | |
| 304 | + $metadata = wp_get_attachment_metadata($attach_id); | |
| 305 | + $metadata['width'] = $large_width; | |
| 306 | + $metadata['height'] = $large_height; | |
| 307 | + wp_update_attachment_metadata($attach_id,$metadata); | |
| 388 | 308 | } |
| 389 | - | |
| 309 | + if(isset($media_handle['media_settings']['description'])){ | |
| 310 | + $media_handle['media_settings']['description'] = $media_settings[$media_handle['media_settings']['description']]; | |
| 311 | + } | |
| 312 | + if(isset($media_handle['media_settings']['caption'])){ | |
| 313 | + $media_handle['media_settings']['caption'] = $media_settings[$media_handle['media_settings']['caption']]; | |
| 314 | + } | |
| 315 | + if(isset($media_handle['media_settings']['title'])){ | |
| 316 | + $media_handle['media_settings']['title'] = $media_settings[$media_handle['media_settings']['title']]; | |
| 317 | + } | |
| 318 | + if(isset($media_handle['media_settings']['caption']) || isset($media_handle['media_settings']['description'])){ | |
| 319 | + wp_update_post(array( | |
| 320 | + 'ID' =>$attach_id, | |
| 321 | + 'post_content' =>$media_handle['media_settings']['description'], | |
| 322 | + 'post_excerpt' =>$media_handle['media_settings']['caption'] | |
| 323 | + )); | |
| 324 | + } | |
| 325 | + if(isset($media_handle['media_settings']['title'])){ | |
| 326 | + wp_update_post(array( | |
| 327 | + 'ID' =>$attach_id, | |
| 328 | + 'post_title' =>$media_handle['media_settings']['title'] | |
| 329 | + )); | |
| 330 | + } | |
| 331 | + if($attach_id != null && isset($alttext['_wp_attachment_image_alt'])){ | |
| 332 | + update_post_meta($attach_id, '_wp_attachment_image_alt', $alttext['_wp_attachment_image_alt']); | |
| 333 | + } | |
| 390 | 334 | if(!empty($data_array['featured_image'])) { |
| 391 | 335 | set_post_thumbnail( $post_id, $attach_id ); |
| 392 | 336 | } |
| 337 | + delete_option( $option_name ); | |
| 393 | 338 | return $attach_id; |
| 394 | 339 | } |
| 395 | 340 | |
| 396 | - public function get_filename_path($image_url){ | |
| 397 | - $image_name = pathinfo($image_url); | |
| 398 | - $fimg_name = $image_name['basename']; | |
| 399 | - $fimg_name_without_ext = $image_name['filename']; | |
| 400 | - if(empty($fimg_name_without_ext)){ | |
| 401 | - $fimg_name_without_ext = $fimg_name; | |
| 341 | + | |
| 342 | + public function image_import($data_array){ | |
| 343 | + if(isset($data_array['alt_text'])) { | |
| 344 | + $alttext ['_wp_attachment_image_alt'] = $data_array['alt_text']; | |
| 345 | + } | |
| 346 | + if(preg_match("http", $data_array['featured_image'])) { | |
| 347 | + $f_img = $data_array['featured_image']; | |
| 348 | + } | |
| 349 | + else{ | |
| 350 | + $media_dir = wp_get_upload_dir(); | |
| 351 | + $names = glob($media_dir['path'].'/'.'*.*'); | |
| 352 | + $f_img = $data_array['featured_image']; | |
| 353 | + foreach($names as $values){ | |
| 354 | + if (strpos($values, $f_img) !== false) { | |
| 355 | + $f_img = $media_dir['url'].'/'.$f_img; | |
| 356 | + } | |
| 357 | + } | |
| 358 | + } | |
| 359 | + $image_name = pathinfo($f_img); | |
| 360 | + $fimg_name = $image_name['basename']; | |
| 361 | + $attachment_title = sanitize_file_name( pathinfo( $fimg_name, PATHINFO_FILENAME ) ); | |
| 362 | + $file_type = wp_check_filetype( $fimg_name, null ); | |
| 363 | + $dir = wp_upload_dir(); | |
| 364 | + $dirname = date('Y') . '/' . date('m'); | |
| 365 | + $uploaddir_paths = $dir ['basedir'] . '/' . $dirname ; | |
| 366 | + $uploaddir_url = $dir ['baseurl'] . '/' . $dirname; | |
| 367 | + $f_img = str_replace(" ","%20",$f_img); | |
| 368 | + if ($uploaddir_paths != "" && $uploaddir_paths) { | |
| 369 | + $uploaddir_path = $uploaddir_paths . "/" . $fimg_name; | |
| 370 | + } | |
| 371 | + if(empty($file_type['type'])){ | |
| 372 | + $file_type['type'] = 'image/jpeg'; | |
| 373 | + } | |
| 374 | + //Removed curl and added wordpress http api | |
| 375 | + $post_info = array( | |
| 376 | + 'guid' => $uploaddir_url . "/" . $fimg_name, | |
| 377 | + 'post_mime_type' => $file_type['type'], | |
| 378 | + 'post_title' => $attachment_title, | |
| 379 | + 'post_content' => '', | |
| 380 | + 'post_status' => 'inherit', | |
| 381 | + ); | |
| 382 | + unset( $post_info['ID'] ); | |
| 383 | + $attach_id = wp_insert_attachment( $post_info,$uploaddir_path ); | |
| 384 | + $attach_data = wp_generate_attachment_metadata( $attach_id, $uploaddir_path ); | |
| 385 | + wp_update_attachment_metadata( $attach_id, $attach_data ); | |
| 386 | + wp_update_post(array( | |
| 387 | + 'ID' => $attach_id, | |
| 388 | + 'post_title' => $data_array['file_name'], | |
| 389 | + 'post_content' => $data_array['description'], | |
| 390 | + 'post_excerpt' => $data_array['caption'] | |
| 391 | + )); | |
| 392 | + if($attach_id != null && isset($alttext['_wp_attachment_image_alt'])){ | |
| 393 | + update_post_meta($attach_id, '_wp_attachment_image_alt', $alttext['_wp_attachment_image_alt']); | |
| 394 | + } | |
| 395 | + return $attach_id; | |
| 396 | + } | |
| 397 | + | |
| 398 | + | |
| 399 | + function overwrite($post_id , $img_url){ | |
| 400 | + | |
| 401 | + global $wpdb; | |
| 402 | + $sql = "SELECT post_mime_type FROM {$wpdb->prefix}posts WHERE ID = $post_id"; | |
| 403 | + list($current_filetype) = $wpdb->get_row($sql, ARRAY_N); | |
| 404 | + $current_filename = wp_get_attachment_url($post_id); | |
| 405 | + | |
| 406 | + $current_guid = $current_filename; | |
| 407 | + $current_filename = substr($current_filename, (strrpos($current_filename, "/") + 1)); | |
| 408 | + | |
| 409 | + $ID = $post_id; | |
| 410 | + | |
| 411 | + //$current_file = get_attached_file($ID, apply_filters( 'emr_unfiltered_get_attached_file', true )); | |
| 412 | + $current_file = get_attached_file($ID); | |
| 413 | + $current_path = substr($current_file, 0, (strrpos($current_file, "/"))); | |
| 414 | + $current_file = preg_replace("|(?<!:)/{2,}|", "/", $current_file); | |
| 415 | + $current_filename = basename($current_file); | |
| 416 | + $current_metadata = wp_get_attachment_metadata( $post_id ); | |
| 417 | + | |
| 418 | + // $original_file_perms = fileperms($current_file) & 0777; | |
| 419 | + | |
| 420 | + $data = file_get_contents($img_url); | |
| 421 | + | |
| 422 | + $new_filename = basename($img_url); | |
| 423 | + $file_type = wp_check_filetype( $new_filename, null ); | |
| 424 | + $new_filetype = $file_type["type"]; | |
| 425 | + if(empty($new_filetype['ext'])){ | |
| 426 | + $new_filename = @basename($img_url); | |
| 427 | + $new_filename = str_replace(' ', '-', trim($new_filename)); | |
| 428 | + $new_filename = preg_replace('/[^a-zA-Z0-9._\-\s]/', '', $new_filename); | |
| 429 | + } | |
| 430 | + if(empty($new_filetype)){ | |
| 431 | + $new_filetype = 'image/jpeg'; | |
| 432 | + } | |
| 433 | + | |
| 434 | + $original_file_perms = fileperms($current_file) & 0777; | |
| 435 | + | |
| 436 | + $this->emr_delete_current_files( $current_file, $current_metadata , $post_id ); | |
| 437 | + | |
| 438 | + $new_filename = wp_unique_filename( $current_path, $new_filename ); | |
| 439 | + $new_file = $current_path . "/" . $new_filename; | |
| 440 | + file_put_contents($new_file, $data); | |
| 441 | + | |
| 442 | + @chmod($current_file, $original_file_perms); | |
| 443 | + | |
| 444 | + $new_filetitle = preg_replace('/\.[^.]+$/', '', basename($new_file)); | |
| 445 | + $new_guid = str_replace($current_filename, $new_filename, $current_guid); | |
| 446 | + | |
| 447 | + $post_date = gmdate( 'Y-m-d H:i:s' ); | |
| 448 | + | |
| 449 | + $sql = $wpdb->prepare( | |
| 450 | + "UPDATE {$wpdb->prefix}posts SET post_title = '$new_filetitle', post_name = '$new_filetitle', guid = '$new_guid', post_mime_type = '$new_filetype', post_date = '$post_date', post_date_gmt = '$post_date' WHERE ID = %d;", | |
| 451 | + $post_id | |
| 452 | + ); | |
| 453 | + $wpdb->query($sql); | |
| 454 | + | |
| 455 | + | |
| 456 | + $sql = $wpdb->prepare( | |
| 457 | + "SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE meta_key = '_wp_attached_file' AND post_id = %d;", | |
| 458 | + $post_id | |
| 459 | + ); | |
| 460 | + | |
| 461 | + $old_meta_name = $wpdb->get_row($sql, ARRAY_A); | |
| 462 | + $old_meta_name = $old_meta_name["meta_value"]; | |
| 463 | + | |
| 464 | + // Make new postmeta _wp_attached_file | |
| 465 | + $new_meta_name = str_replace($current_filename, $new_filename, $old_meta_name); | |
| 466 | + $sql = $wpdb->prepare( | |
| 467 | + "UPDATE {$wpdb->prefix}postmeta SET meta_value = '$new_meta_name' WHERE meta_key = '_wp_attached_file' AND post_id = %d;", | |
| 468 | + $post_id | |
| 469 | + ); | |
| 470 | + $wpdb->query($sql); | |
| 471 | + | |
| 472 | + $new_metadata = wp_generate_attachment_metadata( $post_id, $new_file ); | |
| 473 | + wp_update_attachment_metadata( $post_id, $new_metadata ); | |
| 474 | + | |
| 475 | + | |
| 476 | + | |
| 477 | + $current_base_url = $this->emr_get_match_url( $current_guid ); // .wp-contet.uplodas/ dae name without ext | |
| 478 | + | |
| 479 | + $sql = $wpdb->prepare( | |
| 480 | + "SELECT ID, post_content FROM {$wpdb->prefix}posts WHERE post_status = 'publish' AND post_content LIKE %s;", | |
| 481 | + '%' . $current_base_url . '%' | |
| 482 | + ); | |
| 483 | + | |
| 484 | + | |
| 485 | + $rs = $wpdb->get_results( $sql, ARRAY_A ); | |
| 486 | + | |
| 487 | + $number_of_updates = 0; | |
| 488 | + | |
| 489 | + | |
| 490 | + if ( ! empty( $rs ) ) { | |
| 491 | + $search_urls = $this->emr_get_file_urls( $current_guid, $current_metadata ); | |
| 492 | + $replace_urls = $this->emr_get_file_urls( $new_guid, $new_metadata ); | |
| 493 | + $replace_urls = $this->emr_normalize_file_urls( $search_urls, $replace_urls ); | |
| 494 | + | |
| 495 | + foreach ( $rs AS $rows ) { | |
| 496 | + | |
| 497 | + $number_of_updates = $number_of_updates + 1; | |
| 498 | + | |
| 499 | + // replace old URLs with new URLs. | |
| 500 | + $post_content = $rows["post_content"]; | |
| 501 | + | |
| 502 | + $post_content = addslashes( str_replace( $search_urls, $replace_urls, $post_content ) ); | |
| 503 | + | |
| 504 | + $sql = $wpdb->prepare( | |
| 505 | + "UPDATE {$wpdb->prefix}posts SET post_content = '$post_content' WHERE ID = %d;", | |
| 506 | + $rows["ID"] | |
| 507 | + ); | |
| 508 | + | |
| 509 | + $wpdb->query( $sql ); | |
| 402 | 510 | } |
| 403 | - $file_type = wp_check_filetype( $fimg_name, null ); | |
| 404 | - if(empty($file_type['ext'])){ | |
| 405 | - $fimg_name = @basename($image_url); | |
| 406 | - $fimg_name = str_replace(' ', '-', trim($fimg_name)); | |
| 407 | - $fimg_name = preg_replace('/[^a-zA-Z0-9._\-\s]/', '', $fimg_name); | |
| 408 | - } | |
| 511 | + } | |
| 512 | + update_attached_file( $post_id, $new_file ); | |
| 409 | 513 | |
| 410 | - if (strstr($image_url, 'https://drive.google.com')){ | |
| 411 | - preg_match('/[?&]id=([^&]+)/', $image_url, $matches); | |
| 412 | - $fimg_name = isset($matches[1]) ? $matches[1] : basename($image_url); | |
| 514 | + } | |
| 515 | + | |
| 516 | + | |
| 517 | + function emr_delete_current_files( $current_file, $metadta = null , $post_id ) { | |
| 518 | + // Delete old file | |
| 519 | + | |
| 520 | + // Find path of current file | |
| 521 | + $current_path = substr($current_file, 0, (strrpos($current_file, "/"))); | |
| 522 | + | |
| 523 | + // Check if old file exists first | |
| 524 | + if (file_exists($current_file)) { | |
| 525 | + // Now check for correct file permissions for old file | |
| 526 | + clearstatcache(); | |
| 527 | + if (is_writable($current_file)) { | |
| 528 | + // Everything OK; delete the file | |
| 529 | + unlink($current_file); | |
| 413 | 530 | } |
| 414 | - $dir = wp_upload_dir(); | |
| 415 | - $dirname = date('Y') . '/' . date('m'); | |
| 416 | - $uploads_use_yearmonth = get_option('uploads_use_yearmonth_folders'); | |
| 417 | - if($uploads_use_yearmonth == 1){ | |
| 418 | - $uploaddir_paths = $dir ['basedir'] . '/' . $dirname ; | |
| 419 | - $uploaddir_url = $dir ['baseurl'] . '/' . $dirname; | |
| 531 | + else { | |
| 532 | + // File exists, but has wrong permissions. Let the user know. | |
| 533 | + printf( esc_html__('The file %1$s can not be deleted by the web server, most likely because the permissions on the file are wrong.'), $current_file); | |
| 534 | + exit; | |
| 420 | 535 | } |
| 421 | - else{ | |
| 422 | - $uploaddir_paths = $dir ['basedir']; | |
| 423 | - $uploaddir_url = $dir ['baseurl']; | |
| 536 | + } | |
| 537 | + | |
| 538 | + // Delete old resized versions if this was an image | |
| 539 | + $suffix = substr($current_file, (strlen($current_file)-4)); | |
| 540 | + $prefix = substr($current_file, 0, (strlen($current_file)-4)); | |
| 541 | + | |
| 542 | + if (strtolower($suffix) === ".pdf") { | |
| 543 | + $prefix .= "-pdf"; | |
| 544 | + $suffix = ".jpg"; | |
| 545 | + } | |
| 546 | + | |
| 547 | + $imgAr = array(".png", ".gif", ".jpg", ".jpeg"); | |
| 548 | + if (in_array($suffix, $imgAr)) { | |
| 549 | + // It's a png/gif/jpg based on file name | |
| 550 | + // Get thumbnail filenames from metadata | |
| 551 | + if ( empty( $metadata ) ) { | |
| 552 | + $metadata = wp_get_attachment_metadata( $post_id ); | |
| 424 | 553 | } |
| 425 | - if ($uploaddir_paths != "" && $uploaddir_paths) { | |
| 426 | - $uploaddir_path = $uploaddir_paths . "/" . $fimg_name; | |
| 554 | + // var_dump($metadata);exit; | |
| 555 | + | |
| 556 | + if (is_array($metadata)) { // Added fix for error messages when there is no metadata (but WHY would there not be? I don't know…) | |
| 557 | + foreach($metadata["sizes"] AS $thissize) { | |
| 558 | + // Get all filenames and do an unlink() on each one; | |
| 559 | + $thisfile = $thissize["file"]; | |
| 560 | + // Create array with all old sizes for replacing in posts later | |
| 561 | + $oldfilesAr[] = $thisfile; | |
| 562 | + // Look for files and delete them | |
| 563 | + if (strlen($thisfile)) { | |
| 564 | + $thisfile = $current_path . "/" . $thissize["file"]; | |
| 565 | + if (file_exists($thisfile)) { | |
| 566 | + unlink($thisfile); | |
| 567 | + } | |
| 568 | + } | |
| 569 | + } | |
| 427 | 570 | } |
| 428 | 571 | |
| 429 | - return ['uploaddir_path' => $uploaddir_path,'uploaddir_url' => $uploaddir_url,'fimg_name' => $fimg_name]; | |
| 572 | + } | |
| 430 | 573 | } |
| 431 | - public function image_meta_table_entry($line_number ,$post_values, $post_id ,$acf_wpname_element, $acf_csv_name, $hash_key, $plugin,$get_import_type,$templatekey = null,$gmode = null,$header_array = null, $value_array = null,$imgformat = null,$typecct = null,$indexs=null){ | |
| 432 | - global $wpdb; | |
| 433 | - $table_name = $wpdb->prefix . 'smackcsv_file_events'; | |
| 434 | - $file_name = $wpdb->get_var( | |
| 435 | - $wpdb->prepare( | |
| 436 | - "SELECT file_name FROM $table_name WHERE hash_key = %s", | |
| 437 | - $hash_key | |
| 438 | - ) | |
| 439 | - ); | |
| 440 | - $post_title = $wpdb->get_var( | |
| 441 | - $wpdb->prepare( | |
| 442 | - "SELECT post_title FROM {$wpdb->prefix}posts WHERE ID = %d AND post_status != 'trash'", | |
| 443 | - absint( $post_id ) | |
| 444 | - ) | |
| 445 | - ); | |
| 446 | - $failed_ids = $wpdb->get_results( | |
| 447 | - $wpdb->prepare( | |
| 448 | - "SELECT post_title,post_id,image_shortcode,media_id,original_image FROM {$wpdb->prefix}ultimate_csv_importer_shortcode_manager WHERE image_shortcode ='Featured_image_' AND post_id = %d AND original_image = %s", | |
| 449 | - absint( $post_id ), | |
| 450 | - $acf_csv_name | |
| 451 | - ) | |
| 452 | - ); | |
| 453 | - //$core_instance = CoreFieldsImport::getInstance(); | |
| 454 | - //$core_instance = new WooCommerceCoreImport; | |
| 455 | - $shortcode_table = $wpdb->prefix . "ultimate_csv_importer_shortcode_manager"; | |
| 456 | - | |
| 457 | - $get_path_values = $this->get_filename_path($acf_csv_name); | |
| 458 | - $uploaddir_path = isset($get_path_values['uploaddir_path']) ? $get_path_values['uploaddir_path'] : ''; | |
| 459 | - $uploaddir_url = isset($get_path_values['uploaddir_url']) ? $get_path_values['uploaddir_url'] : ''; | |
| 460 | - $fimg_name = isset($get_path_values['fimg_name']) ? $get_path_values['fimg_name'] : ''; | |
| 461 | - $file_type = 'image/jpeg'; | |
| 462 | - if(isset($post_id) && !empty($acf_csv_name) ){ | |
| 463 | - | |
| 464 | - /************* custom image functionality ***********/ | |
| 465 | - if(strpos($plugin, 'jetengine_') !== false ){ | |
| 466 | - $image_meta_value = array( | |
| 467 | - 'headerarray' => $header_array, | |
| 468 | - 'valuearray' => $value_array, | |
| 469 | - 'tablename' => $typecct, | |
| 470 | - 'returnformat' => $imgformat | |
| 471 | - ); | |
| 472 | - $acf_image_meta =json_encode($image_meta_value); | |
| 473 | - } | |
| 474 | - $acf_image_meta = isset($acf_image_meta) ? $acf_image_meta : null; | |
| 475 | - $attach_id = $this->media_handling($acf_csv_name, $post_id, $post_values,$get_import_type,$plugin,$hash_key,'',$header_array,$value_array,$indexs,$acf_wpname_element,$acf_image_meta); | |
| 476 | - $failed_id = $wpdb->get_results( | |
| 477 | - $wpdb->prepare( | |
| 478 | - "SELECT post_title,post_id,image_shortcode,media_id,original_image FROM {$wpdb->prefix}ultimate_csv_importer_shortcode_manager WHERE post_id = %d AND original_image = %s AND image_shortcode = %s", | |
| 479 | - absint( $post_id ), | |
| 480 | - $acf_csv_name, | |
| 481 | - $plugin . '_image__' . $acf_wpname_element | |
| 482 | - ) | |
| 483 | - ); | |
| 484 | - if(!empty($attach_id)){ | |
| 485 | - $this->store_image_ids($attach_id ); //store the image id | |
| 486 | - return $attach_id; | |
| 487 | - } | |
| 488 | - elseif(empty($attach_id) || !empty($failed_id) || empty($failed_id)){ | |
| 489 | - if(empty($failed_id)){ | |
| 490 | - $post_info = array( | |
| 491 | - 'guid' => $uploaddir_url . "/" . $fimg_name, | |
| 492 | - 'post_mime_type' => $file_type, | |
| 493 | - 'post_title' => 'image-failed', | |
| 494 | - 'post_content' => '', | |
| 495 | - 'post_status' => 'inherit', | |
| 496 | - 'post_author' => isset($post_values['author']) ? $post_values['author'] : '' | |
| 497 | - ); | |
| 498 | - $attach_id = wp_insert_attachment( $post_info,$uploaddir_path, $post_id ); | |
| 499 | - } | |
| 500 | - elseif($failed_id[0]->original_image != $acf_csv_name){ | |
| 501 | - $post_info = array( | |
| 502 | - 'guid' => $uploaddir_url . "/" . $fimg_name, | |
| 503 | - 'post_mime_type' => $file_type, | |
| 504 | - 'post_title' => 'image-failed', | |
| 505 | - 'post_content' => '', | |
| 506 | - 'post_status' => 'inherit', | |
| 507 | - 'post_author' => $post_values['author'] | |
| 508 | - ); | |
| 509 | - $attach_id = wp_insert_attachment( $post_info,$uploaddir_path, $post_id ); | |
| 510 | - } | |
| 511 | - elseif(($failed_id[0]->image_shortcode == 'Featured_image_') && ($failed_id[0]->original_image == $acf_csv_name)){ | |
| 512 | - $post_info = array( | |
| 513 | - 'guid' => $uploaddir_url . "/" . $fimg_name, | |
| 514 | - 'post_mime_type' => $file_type, | |
| 515 | - 'post_title' => 'image-failed', | |
| 516 | - 'post_content' => '', | |
| 517 | - 'post_status' => 'inherit', | |
| 518 | - 'post_author' => $post_values['author'] | |
| 519 | - ); | |
| 520 | - $attach_id = wp_insert_attachment( $post_info,$uploaddir_path, $post_id ); | |
| 521 | - } | |
| 522 | - if(empty($failed_id)){ | |
| 523 | - $insert_status = $wpdb->insert($shortcode_table, | |
| 524 | - array( | |
| 525 | - 'post_id' => $post_id, | |
| 526 | - 'post_title' => $post_title, | |
| 527 | - 'image_shortcode' => $plugin.'_image__'.$acf_wpname_element, | |
| 528 | - 'media_id' => $attach_id, | |
| 529 | - 'original_image' => $acf_csv_name, | |
| 530 | - 'indexs' => $indexs, | |
| 531 | - 'image_meta' => $acf_image_meta, | |
| 532 | - 'hash_key' => $hash_key, | |
| 533 | - 'import_type' => $get_import_type, | |
| 534 | - 'file_name' => $file_name | |
| 535 | - ), | |
| 536 | - array('%d','%s','%s','%d','%s','%d','%s','%s','%s','%s') | |
| 537 | - ); | |
| 538 | - if($insert_status){ | |
| 539 | - $this->store_image_ids($attach_id);//store number of image ids | |
| 540 | - $this->store_failed_image_ids($attach_id);//store failed image ids | |
| 541 | - } | |
| 542 | - } | |
| 543 | - else{ | |
| 544 | - $media_id = $failed_id[0]->media_id; | |
| 545 | - $attachment_id = $wpdb->get_results( | |
| 546 | - $wpdb->prepare( | |
| 547 | - "SELECT ID FROM {$wpdb->prefix}posts WHERE ID = %d AND post_title ='image-failed' AND post_type = 'attachment' AND guid LIKE %s", | |
| 548 | - absint( $media_id ), | |
| 549 | - '%' . $wpdb->esc_like( $fimg_name ) . '%' | |
| 550 | - ), | |
| 551 | - ARRAY_A | |
| 552 | - ); | |
| 553 | - $attach_id= $attachment_id[0]['ID']; | |
| 554 | - } | |
| 555 | - return isset($attach_id) ? $attach_id : ''; | |
| 556 | - }else{ | |
| 557 | - $attachment_id = $wpdb->get_results( | |
| 558 | - $wpdb->prepare( | |
| 559 | - "SELECT ID FROM {$wpdb->prefix}posts WHERE post_title ='image-failed' AND post_type = 'attachment' AND guid LIKE %s", | |
| 560 | - '%' . $wpdb->esc_like( $fimg_name ) . '%' | |
| 561 | - ), | |
| 562 | - ARRAY_A | |
| 563 | - ); | |
| 564 | - } | |
| 565 | - return $attach_id; | |
| 574 | + | |
| 575 | + function emr_get_match_url($url) { | |
| 576 | + $url = $this->emr_remove_scheme($url); | |
| 577 | + $url = $this->emr_maybe_remove_query_string($url); | |
| 578 | + $url = $this->emr_remove_size_from_filename($url, true); | |
| 579 | + $url = $this->emr_remove_domain_from_filename($url); | |
| 580 | + | |
| 581 | + return $url; | |
| 582 | + } | |
| 583 | + | |
| 584 | + function emr_remove_scheme( $url ) { | |
| 585 | + return preg_replace( '/^(?:http|https):/', '', $url ); | |
| 586 | + } | |
| 587 | + | |
| 588 | + function emr_maybe_remove_query_string( $url ) { | |
| 589 | + $parts = explode( '?', $url ); | |
| 590 | + | |
| 591 | + return reset( $parts ); | |
| 592 | + } | |
| 593 | + | |
| 594 | + function emr_remove_size_from_filename( $url, $remove_extension = false ) { | |
| 595 | + $url = preg_replace( '/^(\S+)-[0-9]{1,4}x[0-9]{1,4}(\.[a-zA-Z0-9\.]{2,})?/', '$1$2', $url ); | |
| 596 | + | |
| 597 | + if ( $remove_extension ) { | |
| 598 | + $ext = pathinfo( $url, PATHINFO_EXTENSION ); | |
| 599 | + $url = str_replace( ".$ext", '', $url ); | |
| 566 | 600 | } |
| 601 | + | |
| 602 | + return $url; | |
| 567 | 603 | } |
| 568 | - public function store_image_ids($attach_id){ | |
| 569 | - //get number of images count | |
| 570 | - $stored_ids = get_option('total_attachment_ids', ''); | |
| 571 | - $att_id = $attach_id; | |
| 572 | - if ($stored_ids === '') { | |
| 573 | - add_option('total_attachment_ids', serialize(array($att_id))); | |
| 574 | - $stored_ids = unserialize(get_option('total_attachment_ids', '')); | |
| 575 | - } else { | |
| 576 | - $get_stored_ids = unserialize(get_option('total_attachment_ids', '')); | |
| 577 | - if (is_array($get_stored_ids) && !empty($att_id)) { | |
| 578 | - $att_id = is_array($att_id) ? $att_id : array($att_id); | |
| 579 | - $stored_ids = array_merge($get_stored_ids,$att_id); | |
| 580 | - } else { | |
| 581 | - $stored_ids = $att_id; | |
| 582 | - } | |
| 583 | - update_option('total_attachment_ids', serialize($stored_ids)); | |
| 584 | - $stored_ids = unserialize(get_option('total_attachment_ids', '')); | |
| 585 | - } | |
| 604 | + | |
| 605 | + function emr_remove_domain_from_filename($url) { | |
| 606 | + // Holding place for possible future function | |
| 607 | + $url = str_replace($this->emr_remove_scheme(get_bloginfo('url')), '', $url); | |
| 608 | + return $url; | |
| 586 | 609 | } |
| 587 | - public function store_failed_image_ids($attach_id){ | |
| 588 | - //get number of failed images count | |
| 589 | - $stored_ids = get_option('failed_attachment_ids', ''); | |
| 590 | - $att_id = $attach_id; | |
| 591 | - if ($stored_ids === '') { | |
| 592 | - add_option('failed_attachment_ids', serialize(array($att_id))); | |
| 593 | - $stored_ids = unserialize(get_option('failed_attachment_ids', '')); | |
| 594 | - } else { | |
| 595 | - $get_stored_ids = unserialize(get_option('failed_attachment_ids', '')); | |
| 596 | - if (is_array($get_stored_ids) && !empty($att_id)) { | |
| 597 | - $att_id = is_array($att_id) ? $att_id : array($att_id); | |
| 598 | - $stored_ids = array_merge($get_stored_ids,$att_id); | |
| 599 | - } else { | |
| 600 | - $stored_ids = $att_id; | |
| 601 | - } | |
| 602 | - update_option('failed_attachment_ids', serialize($stored_ids)); | |
| 603 | - $stored_ids = unserialize(get_option('failed_attachment_ids', '')); | |
| 610 | + | |
| 611 | + | |
| 612 | + function emr_get_file_urls( $guid, $metadata ) { | |
| 613 | + $urls = array(); | |
| 614 | + | |
| 615 | + $guid = $this->emr_remove_scheme( $guid ); | |
| 616 | + $guid= $this->emr_remove_domain_from_filename($guid); | |
| 617 | + | |
| 618 | + $urls['guid'] = $guid; | |
| 619 | + | |
| 620 | + if ( empty( $metadata ) ) { | |
| 621 | + return $urls; | |
| 622 | + } | |
| 623 | + | |
| 624 | + $base_url = dirname( $guid ); | |
| 625 | + | |
| 626 | + if ( ! empty( $metadata['file'] ) ) { | |
| 627 | + $urls['file'] = trailingslashit( $base_url ) . wp_basename( $metadata['file'] ); | |
| 628 | + } | |
| 629 | + | |
| 630 | + if ( ! empty( $metadata['sizes'] ) ) { | |
| 631 | + foreach ( $metadata['sizes'] as $key => $value ) { | |
| 632 | + $urls[ $key ] = trailingslashit( $base_url ) . wp_basename( $value['file'] ); | |
| 604 | 633 | } |
| 634 | + } | |
| 635 | + | |
| 636 | + return $urls; | |
| 605 | 637 | } |
| 606 | 638 | |
| 607 | -} | |
| 639 | + function emr_normalize_file_urls( $old, $new ) { | |
| 640 | + $result = array(); | |
| 641 | + | |
| 642 | + if ( empty( $new['guid'] ) ) { | |
| 643 | + return $result; | |
| 644 | + } | |
| 645 | + | |
| 646 | + $guid = $new['guid']; | |
| 647 | + | |
| 648 | + foreach ( $old as $key => $value ) { | |
| 649 | + $result[ $key ] = empty( $new[ $key ] ) ? $guid : $new[ $key ]; | |
| 650 | + } | |
| 651 | + | |
| 652 | + return $result; | |
| 653 | + } | |
| 654 | +} | |
