<h2>Editing File: /usr/local/sitepad/editor/site-data/plugins/cookieadmin/includes/admin/scan.php</h2><form method='post'><textarea name='content' class='file-edit'>&lt;?php

namespace CookieAdmin\Admin;

if(!defined('COOKIEADMIN_VERSION') || !defined('ABSPATH')){
	die('Hacking Attempt');
}

class Scan{
	
	static function show_cookies(){
		global $cookieadmin_lang, $cookieadmin_error, $cookieadmin_msg, $wpdb;
		
		\CookieAdmin\Admin::header_theme(__('Manage Cookies', 'cookieadmin'));
		
		$cookieadmin_requires_pro = \CookieAdmin\Admin::is_feature_available(1);
		
		$table_name = esc_sql($wpdb-&gt;prefix . 'cookieadmin_cookies');
		
		$categorized = [];
		$categorized_cookies = [];
		

		$scanned_cookies = $wpdb-&gt;get_results(&quot;SELECT * FROM {$table_name}&quot;);
		
		foreach($scanned_cookies as $row =&gt; $data){
			
			$expires = 0;
			
			if(!empty($data-&gt;expires) &amp;&amp; !empty($data-&gt;scan_timestamp)){
				$expires = strtotime($data-&gt;expires);
				$timestamp = $data-&gt;scan_timestamp;
				
				if(!empty($expires) &amp;&amp; ($expires &gt; 0) &amp;&amp; !empty($timestamp)){
					$expires = round(($expires - $timestamp) / 86400);
				}else{
					$expires = 0;
				}
			}

			if($expires &lt; 1){
				$exp = __('Session', 'cookieadmin');
			}else{
				$exp = $expires .  ' '.__('Day(s)', 'cookieadmin');
			}
			
			if(empty($data-&gt;category)){
				$data-&gt;category = 'Unknown';
			}
			
			if(!isset($categorized[$data-&gt;category])){
				$categorized[$data-&gt;category] = '';
			}
			
			if(empty($data-&gt;description)){
				$data-&gt;description = 'Not Available';
			}

			$patterns = !empty($data-&gt;patterns) ? $data-&gt;patterns : '';
			if(!empty($patterns)){
				$patterns = strtr($patterns, ['[' =&gt; '', ']' =&gt; '', '&quot;' =&gt; '']);
			}
			
			$categorized[$data-&gt;category] .= '&lt;tr&gt;&lt;td&gt;'.esc_html($data-&gt;cookie_name).'&lt;/td&gt;&lt;td&gt;'.esc_html($data-&gt;description).'&lt;/td&gt;&lt;td&gt;'.esc_html($exp).'&lt;/td&gt;&lt;td&gt; &lt;span class=&quot;dashicons dashicons-edit cookieadmin_edit_icon&quot; id=&quot;edit_'.esc_attr($data-&gt;id).'&quot;&gt;&lt;/span&gt; &lt;span class=&quot;dashicons dashicons-trash cookieadmin_delete_icon&quot; id=&quot;delete_'.esc_attr($data-&gt;id).'&quot;&gt;&lt;/span&gt; &lt;/td&gt;&lt;/tr&gt;';

			$categorized_cookies[$data-&gt;id]['id'] = $data-&gt;id;
			$categorized_cookies[$data-&gt;id]['cookie_name'] = $data-&gt;cookie_name;
			$categorized_cookies[$data-&gt;id]['description'] = $data-&gt;description;
			$categorized_cookies[$data-&gt;id]['category'] = $data-&gt;category;
			$categorized_cookies[$data-&gt;id]['expires'] = $expires;
			$categorized_cookies[$data-&gt;id]['patterns'] = $patterns;

		}
		
		wp_register_script('cookieadmin_categorized_cookies', '', array('jquery'), COOKIEADMIN_VERSION, true);
		wp_enqueue_script('cookieadmin_categorized_cookies');
		wp_localize_script('cookieadmin_categorized_cookies', 'categorized_cookies', $categorized_cookies);
		
		$no_cookies = '&lt;tr class=&quot;cookieadmin-empty-row&quot;&gt;&lt;td colspan=4&gt;'.esc_html__('No Cookies Found!', 'cookieadmin').'&lt;/td&gt;&lt;/tr&gt;';
		$no_cookies_hidden = '&lt;tr class=&quot;cookieadmin-empty-row&quot; hidden&gt;&lt;td colspan=4&gt;'.esc_html__('No Cookies Found!', 'cookieadmin').'&lt;/td&gt;&lt;/tr&gt;';
		
		echo '
		&lt;div class=&quot;cookieadmin_consent-wrap&quot;&gt;
			&lt;form action=&quot;&quot; method=&quot;post&quot;&gt;';
			do_action('cookieadmin_before_scan_results');
			
			echo '&lt;div class=&quot;cookieadmin-card&quot;&gt;
				&lt;div class=&quot;cookieadmin-card-header&quot;&gt;
					&lt;div&gt;
					&lt;span class=&quot;cookieadmin-card-title&quot;&gt;&lt;span class=&quot;dashicons dashicons-list-view&quot;&gt;&lt;/span&gt; '.esc_html__('Scanned Cookies', 'cookieadmin').'&lt;/span&gt;
					&lt;p class=&quot;cookieadmin-desc&quot;&gt;'.esc_html__('Scanned cookies will be automatically categorised and displayed here. You can add, edit and delete cookies as per your needs.', 'cookieadmin').'&lt;/p&gt;
					&lt;/div&gt;
					&lt;div class=&quot;cookieadmin-toolbar-actions&quot;&gt;
							&lt;input type=&quot;button&quot; class=&quot;cookieadmin-btn cookieadmin-btn-secondary cookieadmin-add-cookie&quot; value=&quot;'.esc_html__('Add Cookie', 'cookieadmin').'&quot; cookieadmin-pro-only=&quot;1&quot;&gt;&lt;/input&gt;
							'.wp_kses_post($cookieadmin_requires_pro).
							( !empty($cookieadmin_requires_pro) ? '
							&lt;input type=&quot;button&quot; class=&quot;cookieadmin-btn cookieadmin-btn-primary cookieadmin-scan&quot; value=&quot;'.esc_html__('Scan', 'cookieadmin').'&quot;&gt;&lt;/input&gt; ' : '').'
							&lt;input type=&quot;button&quot; class=&quot;cookieadmin-btn cookieadmin-btn-primary cookieadmin-scan&quot; value=&quot;'.esc_html__('Full Scan', 'cookieadmin').'&quot; cookieadmin-pro-only=&quot;1&quot;&gt;
							'.wp_kses_post($cookieadmin_requires_pro).'
					&lt;/div&gt;
				&lt;/div&gt;
				&lt;div class=&quot;cookieadmin-card-body&quot;&gt;
					&lt;div class=&quot;cookieadmin-manager-result&quot;&gt;
						&lt;table class=&quot;cookieadmin-table cookieadmin-cookie-categorized&quot;&gt;
							&lt;thead&gt;
								&lt;tr&gt;
									&lt;th width=&quot;30%&quot;&gt;'.esc_html__('Name', 'cookieadmin').'&lt;/th&gt;
									&lt;th width=&quot;50%&quot;&gt;'.esc_html__('Description', 'cookieadmin').'&lt;/th&gt;
									&lt;th width=&quot;10%&quot;&gt;'.esc_html__('Expiry', 'cookieadmin').'&lt;/th&gt;
									&lt;th width=&quot;10%&quot;&gt;'.esc_html__('Action', 'cookieadmin').'&lt;/th&gt;
								&lt;/tr&gt;
							&lt;/thead&gt;
							&lt;tbody id=&quot;necessary_tbody&quot;&gt;
								&lt;tr&gt;&lt;td colspan=4&gt;'.esc_html__('Necessary Cookies', 'cookieadmin').'&lt;/td&gt;&lt;/tr&gt;
								'.( !empty($categorized['Necessary']) ? $no_cookies_hidden . wp_kses_post($categorized['Necessary']) : $no_cookies ).'
							&lt;/tbody&gt;
							&lt;tbody id=&quot;functional_tbody&quot;&gt;
								&lt;tr&gt;&lt;td colspan=4&gt;'.esc_html__('Functional Cookies', 'cookieadmin').'&lt;/td&gt;&lt;/tr&gt;
								'.( !empty($categorized['Functional']) ? $no_cookies_hidden . wp_kses_post($categorized['Functional']) : $no_cookies ).'
							&lt;/tbody&gt;
							&lt;tbody id=&quot;analytics_tbody&quot;&gt;
								&lt;tr&gt;&lt;td colspan=4&gt;'.esc_html__('Analytical Cookies', 'cookieadmin').'&lt;/td&gt;&lt;/tr&gt;
								'.( !empty($categorized['Analytics']) ? $no_cookies_hidden . wp_kses_post($categorized['Analytics']) :$no_cookies ).'
							&lt;/tbody&gt;
							&lt;tbody id=&quot;marketing_tbody&quot;&gt;
								&lt;tr&gt;&lt;td colspan=4&gt;'.esc_html__('Marketing Cookies', 'cookieadmin').'&lt;/td&gt;&lt;/tr&gt;
								'.( !empty($categorized['Marketing']) ? $no_cookies_hidden . wp_kses_post($categorized['Marketing']) : $no_cookies ).'
							&lt;/tbody&gt;
							&lt;tbody id=&quot;unknown_tbody&quot;&gt;
								&lt;tr&gt;&lt;td colspan=4&gt;'.esc_html__('Unknown Cookies', 'cookieadmin').'&lt;/td&gt;&lt;/tr&gt;
								'.( !empty($categorized['Unknown']) ? $no_cookies_hidden . wp_kses_post($categorized['Unknown']) : $no_cookies ).'
							&lt;/tbody&gt;
						&lt;/table&gt;
					&lt;/div&gt;
				&lt;/div&gt;
			&lt;/div&gt;';
			
			wp_nonce_field('cookieadmin_admin_nonce', 'cookieadmin_security');
			
			echo '
		&lt;/div&gt;
		&lt;/form&gt;
		&lt;br/&gt;';
		
		\CookieAdmin\Admin::footer_theme();
		
		echo '
		&lt;!-- Modal Overlay --&gt;
		&lt;div class=&quot;cookieadmin_modal-overlay&quot; id=&quot;edit-cookie-modal&quot; hidden&gt;
			&lt;div class=&quot;cookieadmin_modal-container&quot;&gt;
				&lt;div class=&quot;cookieadmin_modal-header&quot;&gt;
					&lt;h2&gt;'.esc_html__('Edit Cookie', 'cookieadmin').'&lt;/h2&gt;
					&lt;button class=&quot;cookieadmin_dialog_modal_close_btn&quot;&gt;&amp;times;&lt;/button&gt;
				&lt;/div&gt;

				&lt;div class=&quot;cookieadmin_modal-body&quot;&gt;
					&lt;div class=&quot;cookieadmin_form-group&quot;&gt;
						&lt;label for=&quot;cookieadmin-dialog-cookie-category&quot;&gt;'.esc_html__('Category', 'cookieadmin').'&lt;/label&gt;
						&lt;select id=&quot;cookieadmin-dialog-cookie-category&quot;&gt;
							&lt;option value=&quot;&quot; selected&gt;'.esc_html__('Select a category', 'cookieadmin').'&lt;/option&gt;
							&lt;option value=&quot;Necessary&quot;&gt;'.esc_html__('Necessary', 'cookieadmin').'&lt;/option&gt;
							&lt;option value=&quot;Functional&quot;&gt;'.esc_html__('Functional', 'cookieadmin').'&lt;/option&gt;
							&lt;option value=&quot;Analytics&quot;&gt;'.esc_html__('Analytical', 'cookieadmin').'&lt;/option&gt;
							&lt;option value=&quot;Marketing&quot;&gt;'.esc_html__('Marketing', 'cookieadmin').'&lt;/option&gt;
							&lt;option value=&quot;Unknown&quot;&gt;'.esc_html__('Unknown', 'cookieadmin').'&lt;/option&gt;
						&lt;/select&gt;
					&lt;/div&gt;
					
					&lt;div class=&quot;cookieadmin_form-group&quot;&gt;
						&lt;label for=&quot;cookie_id&quot;&gt;'.esc_html__('Cookie Name/ID', 'cookieadmin').'&lt;/label&gt;
						&lt;input type=&quot;text&quot; id=&quot;cookieadmin-dialog-cookie-name&quot; Placeholder=&quot;'.esc_html__('Enter Cookie Name or id', 'cookieadmin').'&quot;&gt;
					&lt;/div&gt;

					&lt;div class=&quot;cookieadmin_form-group&quot;&gt;
						&lt;label for=&quot;description&quot;&gt;'.esc_html__('Description', 'cookieadmin').'&lt;/label&gt;
						&lt;textarea id=&quot;cookieadmin-dialog-cookie-desc&quot; Placeholder=&quot;'.esc_html__('Enter Cookie description here', 'cookieadmin').'&quot;&gt;&lt;/textarea&gt;
					&lt;/div&gt;

					&lt;div class=&quot;cookieadmin_form-group&quot;&gt;
						&lt;label for=&quot;duration&quot;&gt;'.esc_html__('Duration', 'cookieadmin').'&lt;/label&gt;
						&lt;input type=&quot;number&quot; min=0 id=&quot;cookieadmin-dialog-cookie-duration&quot; Placeholder=&quot;'.esc_html__('Set 0 for Session or expiry in days', 'cookieadmin').'&quot;&gt;
					&lt;/div&gt;';

					if(empty($cookieadmin_requires_pro)){
						echo '&lt;div class=&quot;cookieadmin_form-group&quot;&gt;
							&lt;label for=&quot;patterns&quot;&gt;'.esc_html__('Scripts patterns', 'cookieadmin').'&lt;/label&gt;
							&lt;span&gt;'.__('If scripts has &quot;src&quot; attribute then paste the src or add comma separated patterns to match the scripts. Try choosing log patterns to block only targeted script', 'cookieadmin').'&lt;/span&gt;
							&lt;br /&gt;&lt;span&gt;&lt;strong&gt;'.__('Note: ', 'cookieadmin').'&lt;/strong&gt;'.__('Wildcards (*, ?, ^, % etc) are not allowed', 'cookieadmin').'&lt;/span&gt;
							&lt;textarea id=&quot;cookieadmin-dialog-cookie-patterns&quot; Placeholder=&quot;'.esc_attr__('https://connect.facebook.net/en_US/fbevents.js OR fbq.push, window.facebookSignals', 'cookieadmin').'&quot;&gt;&lt;/textarea&gt;
						&lt;/div&gt;';
					}
				echo '&lt;/div&gt;
				&lt;div class=&quot;cookieadmin_modal-footer&quot;&gt;					
					&lt;span id=&quot;cookieadmin-message&quot;&gt;&lt;/span&gt;
					&lt;button class=&quot;cookieadmin-btn cookieadmin-btn-primary&quot; id=&quot;cookieadmin_dialog_save_btn&quot; form=&quot;edit-cookie-form&quot;&gt;'.esc_html__('Save', 'cookieadmin').'&lt;/button&gt;					
				&lt;/div&gt;
			&lt;/div&gt;
		&lt;/div&gt;';
	}
	
	
	
	static function scan_cookies_ajax(){
		global $cookieadmin_error;
		
		$urls = [];
		if(!empty($_REQUEST['urls'])){
			$urls = map_deep(wp_unslash($_REQUEST['urls']), 'sanitize_url');
		}
		
		if(cookieadmin_is_pro()){
			$scanner_info = get_option('cookieadmin_pro_scanner', []);
			
			if(!empty($scanner_info['last_scan']) &amp;&amp; (time() &lt; $scanner_info['last_scan'] + 3600)){
				wp_send_json([
					'success' =&gt; false,
					'message' =&gt; __('Cookie Scan can be triggered once an hour', 'cookieadmin')
				]);
			}
		}
		
		self::scan_cookies($urls);
		
		if(!empty($cookieadmin_error)){
			wp_send_json([
				'success' =&gt; false,
				'message' =&gt; $cookieadmin_error]
			);
		}		
		
		wp_send_json(['success' =&gt; true, 'data' =&gt; null]);
	}
	
	// Orchestrator function for scanning cookies
	static function scan_cookies($urls = []){
		global $cookieadmin_error;
		
		if(cookieadmin_is_pro()){
			
			if(!method_exists('\CookieAdminPro\Admin', 'cookieadmin_get_site_urls')){
				$urls = [home_url()];
			} else {
				$urls = \CookieAdminPro\Admin::cookieadmin_get_site_urls($urls);
			}

			$cookieData = apply_filters('cookieadmin_pro_scan_cookies', $urls);
			
			//Server side scann - skipped for now - need to discuss.
			// $cookieData2 = \CookieAdmin\Scanner::start_scan($urls);
			// $cookieData = array_replace_recursive($cookieData2, $cookieData1);
			
			if(!empty($cookieadmin_error)){
				update_option('cookieadmin_scan', [
						'status' =&gt; 3,
						'success' =&gt; false,
						'message' =&gt; $cookieadmin_error,
						'update' =&gt; time()
					]);
				return;
			}
			
			if(!empty($cookieData)){
				
				if(function_exists('cookieadmin_pro_get_remaining_urls')){
					// Check Remaining urls
					$remaining_urls = cookieadmin_pro_get_remaining_urls($urls);
					
					if(!empty($remaining_urls)){
						//send next batch for scan
						wp_schedule_single_event(time() + 5, 'cookieadmin_run_auto_scan_batch', [$remaining_urls]);
					}
				}
				
				$res = self::save_raw_scan_results($cookieData);
				if(function_exists('cookieadmin_pro_update_scan_count')){
					cookieadmin_pro_update_scan_count($res);
				}
				
				self::cookieadmin_auto_configure_cookies();
				return;
			}
			
		}else{
			$cookieData = \CookieAdmin\Scanner::start_scan();
			if(!empty($cookieData)){
				self::save_raw_scan_results($cookieData);
				return self::cookieadmin_auto_configure_cookies();
			}
		}
		// cookieadmin_r_print($cookieData);
		
		if(defined('DOING_CRON') &amp;&amp; get_transient('cookieadmin_auto_scan_in_progress')){
			delete_transient('cookieadmin_auto_scan_in_progress');
		}
		
		update_option('cookieadmin_scan', [
			'status' =&gt; 3,
			'success' =&gt; false,
			'message' =&gt; __('No Cookies Found', 'cookieadmin'),
			'update' =&gt; time()
		]);
		
		return false;
	}
	
	static function save_raw_scan_results(array $found_cookies){

		global $wpdb;
		
		$table_name = esc_sql($wpdb-&gt;prefix . 'cookieadmin_cookies');

		if (empty($found_cookies)) {
			return ['inserted' =&gt; 0, 'updated' =&gt; 0];
		}

		// Step 1: Fetch all existing cookie names from our database in one efficient query.
		$existing_cookies_in_db = $wpdb-&gt;get_col(&quot;SELECT cookie_name FROM {$table_name}&quot;);
		// Use array_flip for very fast 'isset' lookups instead of slow 'in_array' in a loop.
		$existing_cookies_lookup = !empty($existing_cookies_in_db) ? array_flip($existing_cookies_in_db) : [];

		$results = ['inserted' =&gt; 0, 'updated' =&gt; 0];

		// Step 2: Loop through each cookie found by the scanner.
		foreach ($found_cookies as $cookie_name =&gt; $cookie_data) {

			// Step 3: Check if the cookie exists in our DB.
			if (isset($existing_cookies_lookup[$cookie_name])) {
				$wpdb-&gt;update(
					$table_name,
					[
						'domain' =&gt; sanitize_text_field($cookie_data['domain']),
						'path' =&gt; sanitize_text_field($cookie_data['path']),
						'expires' =&gt; !empty($cookie_data['session']) ? 0 : (!empty($cookie_data['expires']) ? $cookie_data['expires'] : null),
						'samesite' =&gt; !empty($cookie_data['samesite']) ? sanitize_text_field($cookie_data['samesite']) : null,
						'secure' =&gt; (int)($cookie_data['secure'] ?? 0),
						'httponly' =&gt; (int)($cookie_data['httponly'] ?? 0),
						'raw_name' =&gt; sanitize_text_field($cookie_name),
						'scan_timestamp' =&gt; time(),
					], // Data to update
					[ 'cookie_name' =&gt; $cookie_name ], // WHERE clause
					['%s', '%s', '%s', '%s', '%d', '%d', '%s', '%d'], // Format for the data
					[ '%s' ]  // Format for the WHERE clause
				);
				$results['updated']++;

			} else {
				
				if($cookie_name == 'cookieadmin_consent' &amp;&amp; empty($cookie_data['expires'])){
					$view = get_option('cookieadmin_law', 'cookieadmin_gdpr');		
					$policy = cookieadmin_load_policy();
					
					if(!empty($policy) &amp;&amp; !empty($policy[$view])){
						$cookie_exp_days = (int) (!empty($policy[$view]['cookieadmin_days']) ? $policy[$view]['cookieadmin_days'] : 365);
						$utc_time = gmdate('Y-m-d H:i:s', strtotime('+'.$cookie_exp_days.' days'));
					} else {
						$utc_time = gmdate('Y-m-d H:i:s', strtotime('+365 days'));
					}
					
					$cookie_data['expires'] = $utc_time; 
				}

				// ------ INSERT a NEW cookie ------
				$data = [
					'cookie_name' =&gt; sanitize_text_field($cookie_name),
					'domain' =&gt; sanitize_text_field($cookie_data['domain']),
					'path' =&gt; sanitize_text_field($cookie_data['path']),
					'expires' =&gt; !empty($cookie_data['session']) ? 0 : (!empty($cookie_data['expires']) ? $cookie_data['expires'] : null),
					'samesite' =&gt; !empty($cookie_data['samesite']) ? sanitize_text_field($cookie_data['samesite']) : null,
					'secure' =&gt; (int)($cookie_data['secure'] ?? 0),
					'httponly' =&gt; (int)($cookie_data['httponly'] ?? 0),
					'raw_name' =&gt; sanitize_text_field($cookie_name),
					'scan_timestamp' =&gt; time(),
				];

				$formats = ['%s', '%s', '%s', '%s', '%s', '%d', '%d', '%s', '%d'];

				if ($wpdb-&gt;insert($table_name, $data, $formats)) {
					$results['inserted']++;
				} else {
					//error_log(&quot;CookieAdmin: Error inserting cookie data: &quot; . $wpdb-&gt;last_error);
				}
			}
		}
		return $results;
	}
	
	static function cookieadmin_auto_configure_cookies(){
		global $wpdb, $cookieadmin_error;
		
		$table_name = $wpdb-&gt;prefix . 'cookieadmin_cookies';
		$categorized_cookies = [];
		$uncategorized_cookies = [];
		
		$all_cookies = $wpdb-&gt;get_results(&quot;SELECT id, cookie_name, category FROM {$table_name}&quot;);
		
		foreach($all_cookies as $cookie){
			
			if(!empty($cookie-&gt;category)){
				$categorized_cookies[$cookie-&gt;id] = $cookie-&gt;cookie_name;
			}else{
				$uncategorized_cookies[] = $cookie-&gt;cookie_name;
			}
		}
		
		if(!empty($uncategorized_cookies)){
			
			$uncategorized_cookies = array_flip($uncategorized_cookies);
			$categorized_cookies = array_flip($categorized_cookies);
			
			
			$categorizd_cookies = \CookieAdmin\CookieCategorizer::categorize_cookies($uncategorized_cookies, $categorized_cookies);
			
			$remove_cookies = !empty($categorizd_cookies['remove_cookies']) ? $categorizd_cookies['remove_cookies'] : [];
			
			unset($categorizd_cookies['remove_cookies']);
			if(!empty($remove_cookies)){
				$placeholders = implode(',', array_fill(0, count($remove_cookies), '%s'));
				$sql = $wpdb-&gt;prepare(&quot;DELETE FROM {$table_name} WHERE id IN ({$placeholders})&quot;, ...$remove_cookies);
				$wpdb-&gt;query($sql);
			}			
			
			foreach($categorizd_cookies as $cookie_data){
			
				$count = $wpdb-&gt;update(
					$table_name,
					[ 'cookie_name' =&gt; $cookie_data['cookie_name'], 'category' =&gt;  $cookie_data['category'], 'description' =&gt;  $cookie_data['description'], 'edited' =&gt;  1, 'patterns' =&gt;  $cookie_data['patterns'] ], // Data to update
					[ 'raw_name' =&gt; $cookie_data['raw_name'] ], // WHERE 
					[ '%s', '%s', '%s', '%d', '%s' ], // Format for the data
					[ '%s' ]  // Format for the WHERE clause
				);
				
			}
			
			update_option('cookieadmin_scan', [
					'status' =&gt; 3,
					'update' =&gt; time(),
					'success' =&gt; true,
					'count' =&gt; $count
				]);
			
			$categorized_cookies = $wpdb-&gt;get_results(&quot;SELECT id, cookie_name, category, expires, scan_timestamp, description FROM {$table_name}&quot;);
			
			delete_option('cookieadmin_first_scan');
			
			return $categorized_cookies;
		}
		
        $cookieadmin_error = $cookieadmin_error . ' ' . __('No new cookies Found!', 'cookieadmin');
		
		return false;
	}
	
	
	static function edit_cookies(){
		global $wpdb;
		
		$table_name = esc_sql($wpdb-&gt;prefix . 'cookieadmin_cookies');
		$data = null;
		
		if(empty($_REQUEST['cookie_info'])){
			wp_send_json(['success' =&gt; false,
				'data'    =&gt; null,
				'message'   =&gt; __('Error : Cookie details missing', 'cookieadmin')]
			);
		}
			
		$cookie_info = map_deep(wp_unslash($_REQUEST['cookie_info']), 'sanitize_text_field');
		// $scan_timestamp = $wpdb-&gt;get_col($wpdb-&gt;prepare(&quot;SELECT scan_timestamp FROM {$table_name} WHERE id = %d&quot;, $cookie_info['id']));
		
		$scanned_cookies = $wpdb-&gt;get_row($wpdb-&gt;prepare(&quot;SELECT * FROM {$table_name} WHERE id = %d&quot;, $cookie_info['id']));
		$scan_timestamp = !empty($scanned_cookies-&gt;scan_timestamp) ? $scanned_cookies-&gt;scan_timestamp : 0;

		if(empty($scan_timestamp)){
			wp_send_json(['success' =&gt; false,
				'data'    =&gt; null,
				'message'   =&gt; __('Error : Invalid cookie record', 'cookieadmin')]
			);
		}
		
		$calculated_expiry_seconds = ($cookie_info['duration'] * 86400) + $scan_timestamp;
		$calculated_expiry = date('Y-m-d H:i:s', $calculated_expiry_seconds);

		// Update the additional patterns into the saved patterns
		$patterns = '[]';
		if(!empty($cookie_info['patterns'])){
			$script_patterns = explode(',', $cookie_info['patterns']);
			if(!empty($script_patterns) &amp;&amp; is_array($script_patterns)){
				foreach($script_patterns as $pat){
					if(strlen(str_replace(['*', '?', '^', '%'], '', $pat)) &lt; strlen($pat)){
						continue;
					}
					// do not ad  comma if the saved pattern is empty
					$comma = ($patterns === '[]') ? '' : ', ';
					$patterns = str_replace(']', $comma . '&quot;' .(string) trim($pat).'&quot;]', $patterns);
				}
			}
		}else{
			$patterns = !empty($scanned_cookies-&gt;patterns) ? $scanned_cookies-&gt;patterns : '[]';
		}
		
		$resp = $wpdb-&gt;update(
			$table_name,
			[ 'cookie_name' =&gt; $cookie_info['name'], 'description' =&gt;  $cookie_info['description'], 'expires' =&gt;  $calculated_expiry, 'category' =&gt;  $cookie_info['type'], 'patterns' =&gt; $patterns, 'edited' =&gt; 1], // Data to update
			[ 'id' =&gt; $cookie_info['id'] ], // WHERE 
			[ '%s', '%s', '%s', '%s', '%s', '%d' ], // Format for the data
			[ '%d' ]  // Format for the WHERE clause
		);
		
		if ($wpdb-&gt;last_error || $resp === false) {
			//error_log('DB Error: ' . $wpdb-&gt;last_error); // Log it
			wp_send_json(['success' =&gt; false,
				'data'    =&gt; null,
				'message'   =&gt; __('Cookie updation Failed, Error: ', 'cookieadmin') . esc_html($wpdb-&gt;last_error)]);
		}
		
		wp_send_json(['success' =&gt; true,
				'data'    =&gt; $data,
				'message'   =&gt; __('Cookie updation successful', 'cookieadmin')]);
		
	}
	
	static function delete_cookies(){
		global $wpdb;
		
		$table_name = esc_sql($wpdb-&gt;prefix . 'cookieadmin_cookies');
		
		if(empty($_REQUEST['cookie_raw_id'])){
			wp_send_json(['success' =&gt; false,
				'data'    =&gt; null,
				'message'   =&gt; __('Error : Cookie Id missing', 'cookieadmin')]);
		}
			
		$cookie_id = (int) sanitize_text_field(wp_unslash($_REQUEST['cookie_raw_id']));
		
		$resp = $wpdb-&gt;delete( $table_name, ['id' =&gt; $cookie_id], [ '%s' ] );
		
		if ($wpdb-&gt;last_error || $resp === false) {
			//error_log('DB Error: ' . $wpdb-&gt;last_error); //Log it
			wp_send_json(['success' =&gt; false,
				'data'    =&gt; null,
				'message'   =&gt; __('Cookie deletion Failed, Error: ', 'cookieadmin') . esc_html($wpdb-&gt;last_error)]);
		}
		
		wp_send_json(['success' =&gt; true,
				'message'   =&gt; __('Cookie deletion successful', 'cookieadmin')]);
	}
	
}
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fsitepad%2Feditor%2Fsite-data%2Fplugins%2Fcookieadmin%2Fincludes%2Fadmin'>Back to Directory</a>