metasync / includes / class-metasync-common.php

class-metasync-common.php in Search Atlas SEO – OTTO AI SEO Automation for WordPress 2.6.16, at includes/class-metasync-common.php

254 lines 7.0 KB

Raw Download Zip

1	<?php
2
3	/**
4	* The database operations for the 404 error monitor.
5	*
6	* @since 1.0.0
7	* @package Metasync
8	* @subpackage Metasync/404-monitor
9	* @author Engineering Team <support@searchatlas.com>
10	*/
11	class Metasync_Common
12	{
13	/**
14	* Sanitize a array with urls and text field.
15	* @param $data Pass a Array.
16	*/
17	public function sanitize_array($data)
18	{
19	// Ensure $data is always an array from the start
20	if (!is_array($data)) {
21	$data = (array) $data;
22	}
23
24	foreach ($data as $key => $value) {
25	if (is_array($value) && !empty($value)) {
26	$data[$key] = $this->sanitize_array($value);
27	} else {
28	if ($value) {
29	// Ensure $value is a string before processing
30	if (!is_string($value) && !is_numeric($value)) {
31	$value = (string) $value;
32	}
33
34	if (filter_var($value, FILTER_VALIDATE_URL)) {
35	$data[$key] = sanitize_url($value);
36	} else {
37	$data[$key] = sanitize_text_field($value);
38	}
39	}
40	}
41	}
42	return $data;
43	}
44
45	/**
46	* Get post by post name.
47	* @param $attachment_name Attachment name will be string.
48	*/
49	public function get_attachment_by_name($attachment_name)
50	{
51	global $wpdb;
52	$post = $wpdb->get_row(
53	$wpdb->prepare(
54	"SELECT * FROM $wpdb->posts WHERE `post_name` = %s and `post_type` = 'attachment' LIMIT 1",
55	$attachment_name
56	)
57	);
58	return get_post($post);
59	}
60
61	public function get_permalink_from_url($url)
62	{
63	$parse_url = wp_parse_url($url);
64	$path = isset($parse_url['path']) ? $parse_url['path'] : '';
65	return end(array_diff(explode('/', $path), array('')));
66	}
67
68	/**
69	* Get file name from a URL.
70	* @param $url Valid URL as string.
71	*/
72	public function get_file_name_by_url($url)
73	{
74	if (stripos($url, "https://cdn.midjourney.com/") !== false) {
75	return pathinfo(str_replace("/", "_", parse_url($url, PHP_URL_PATH) ?? ''), PATHINFO_FILENAME);
76	} elseif (stripos($url, "https://drive.google.com/") !== false) {
77	$parse_url = wp_parse_url($url);
78	$args = [];
79	wp_parse_str($parse_url['query'], $args);
80	return $args['id'];
81	} else {
82	return pathinfo(parse_url($url, PHP_URL_PATH), PATHINFO_FILENAME);
83	}
84	}
85
86	public function allowedDownloadSources($url)
87	{
88	return false;
89	$allowed_sources = array(
90	"https://storage.googleapis.com",
91	"https://drive.google.com"
92	);
93	foreach ($allowed_sources as $source) {
94	if (stripos($url, $source) !== false)
95	return true;
96	}
97	return false;
98	}
99
100	public function get_media_id_from_url($url) {
101	global $wpdb;
102
103	// Search for any attachment matching the URL
104	$query = $wpdb->prepare("
105	SELECT ID
106	FROM $wpdb->posts
107	WHERE post_type = 'attachment'
108	AND guid = %s
109	LIMIT 1
110	", $url);
111
112	$attachment_id = $wpdb->get_var($query);
113
114	// Return the attachment ID if found, otherwise return false
115	return $attachment_id ? intval($attachment_id) : false;
116	}
117	/**
118	* Upload image to media library if URL is valid.
119	* @param $url Valid URL.
120	* add title to the image default value value is empty string
121	*/
122	public function upload_image_by_url($url,$alt='',$title_text='')
123	{
124	require_once(ABSPATH . "/wp-load.php");
125	require_once(ABSPATH . "/wp-admin/includes/image.php");
126	require_once(ABSPATH . "/wp-admin/includes/file.php");
127	require_once(ABSPATH . "/wp-admin/includes/media.php");
128
129	$tmp = download_url($url);
130	if (is_wp_error($tmp)){
131	$attachment_id = $this->get_media_id_from_url($url);
132	error_log($attachment_id);
133	return $attachment_id;
134	}
135
136	$filename = $this->get_file_name_by_url($url);
137	// $filename = pathinfo($url, PATHINFO_FILENAME);
138	// eliminating query params from file name
139	$filename = explode("?", $filename)[0];
140	$extension = pathinfo($url, PATHINFO_EXTENSION);
141
142	if (!$extension \|\| strlen($extension) > 4) {
143	// fileinfo extension is not always enabled on shared hosts — guard the call
144	// and fall back to WordPress's extension-based detection.
145	if (function_exists('mime_content_type')) {
146	$mime = mime_content_type($tmp);
147	} else {
148	$filetype = wp_check_filetype(basename($url));
149	$mime = $filetype['type'] ?? false;
150	}
151	$mime = is_string($mime) ? sanitize_mime_type($mime) : false;
152
153	$mime_extensions = array(
154	'image/jpe' => 'jpe',
155	'image/jpg' => 'jpg',
156	'image/jpeg' => 'jpeg',
157	'image/gif' => 'gif',
158	'image/png' => 'png',
159	'image/webp' => 'webp'
160	);
161
162	if (isset($mime_extensions[$mime])) {
163	$extension = $mime_extensions[$mime];
164	} else {
165	// Safely delete temporary file if it exists
166	if (file_exists($tmp)) {
167	unlink($tmp);
168	}
169	return false;
170	}
171	}
172
173	$args = array(
174	'name' => "$filename.$extension",
175	/*
176	Generate a sanitized post_name by replacing double dashes with a single dash
177	and appending the file extension with a hyphen
178	*/
179	'post_name' => str_replace('--', '-', $filename ?? '') ."-".$extension,
180	'tmp_name' => $tmp,
181	);
182
183	$get_attachment = $this->get_attachment_by_name($args['post_name']);
184
185
186	# remove if null logic check on 11 march 2025 for issue 264 and merge request 320
187	if (empty($get_attachment)) {
188	$attachment_id = media_handle_sideload($args, 0, $args['name']);
189	update_post_meta($attachment_id, '_wp_attachment_image_alt', $alt);
190	// check if the title is empty or not if it's has title update the title
191	if($title_text !== ''){
192	wp_update_post(
193	array (
194	'ID' => $attachment_id,
195	'post_title' => $title_text
196	)
197	);
198	}
199	$attach_data = wp_generate_attachment_metadata(
200	$attachment_id,
201	wp_get_original_image_path($attachment_id)
202	);
203	wp_update_attachment_metadata($attachment_id, $attach_data);
204
205	// Safely delete temporary file if it exists
206	if (file_exists($tmp)) {
207	unlink($tmp);
208	}
209
210	if (is_wp_error($attachment_id)) return false;
211	return $attachment_id;
212	} else {
213	// check if the title attribute is set on the image tag and then update the title
214	if($title_text !== ''){
215	wp_update_post(
216	array (
217	'ID' => $get_attachment->ID,
218	'post_title' => $title_text
219	)
220	);
221	}
222	// update the alt attribute in the image
223	update_post_meta($get_attachment->ID, '_wp_attachment_image_alt', $alt);
224	return $get_attachment->ID;
225	}
226	}
227	/**
228	* Check if Gutenberg is enabled as the default page editor
229	*/
230	protected function is_gutenberg_enabled() {
231	$current_screen = get_current_screen();
232	return method_exists($current_screen, 'is_block_editor') && $current_screen->is_block_editor();
233	}
234	/**
235	* Check if Elementor is active
236	*/
237	protected function is_elementor_active() {
238	return class_exists('Elementor\Plugin') && \Elementor\Plugin::$instance->preview->is_preview_mode();
239	}
240	/**
241	* Check if Gutenberg is enabled or Elementor is active
242	*/
243	public static function check_default_page_editor() {
244	$instance = new self();
245	if ($instance->is_gutenberg_enabled()) {
246	return 'gutenberg';
247	} elseif ($instance->is_elementor_active()) {
248	return 'elementor';
249	} else {
250	return 'neither';
251	}
252	}
253	}
254