'.esc_html($title).'

'; if(!empty($cookieadmin_error)){ echo '

'.esc_html($cookieadmin_error).'

'; } if(!empty($cookieadmin_msg)){ echo '

'.esc_html($cookieadmin_msg).'

'; } } // cookieadmin footer static function footer_theme($no_twitter = 0){ global $cookieadmin_lang, $cookieadmin_error, $cookieadmin_msg; if(!defined('SITEPAD')){ echo '
'; if(empty($no_twitter)){ echo '
'.esc_html__('Share with your followers', 'cookieadmin').'



'; } echo 'CookieAdmin v'.esc_html(COOKIEADMIN_VERSION).esc_html__(' You can report any bugs ', 'cookieadmin').''.esc_html__('here', 'cookieadmin').'. '; if(defined('COOKIEADMIN_PREMIUM')){ echo 'Or email us at support@cookieadmin.net'; } echo '
'; } } static function dashboard_page(){ global $cookieadmin_lang, $cookieadmin_error, $cookieadmin_msg, $cookieadmin_settings; self::header_theme(__('Dashboard', 'cookieadmin')); $view = get_option('cookieadmin_law', 'cookieadmin_gdpr'); echo '
'.esc_html__('Consent Banner', 'cookieadmin').'
'.esc_html__('Enabled', 'cookieadmin').'
'.esc_html__('Consent Type', 'cookieadmin').' 
['.esc_html__('Edit', 'cookieadmin').']
'.(!empty($view) && $view == 'cookieadmin_us' ? esc_html__('US State Laws', 'cookieadmin') : esc_html__('GDPR', 'cookieadmin')).'
'.esc_html__('Google Consent Mode v2', 'cookieadmin').' 
['.esc_html__('Edit', 'cookieadmin').']
'.(!empty($cookieadmin_settings['google_consent_mode_v2']) ? '
'.esc_html__('Enabled', 'cookieadmin').'
' : '
'.esc_html__('Disabled', 'cookieadmin').'
').'
'; self::footer_theme(); } static function settings_page(){ global $cookieadmin_lang, $cookieadmin_error, $cookieadmin_msg, $cookieadmin_settings; self::header_theme(__('Settings', 'cookieadmin')); $view = get_option('cookieadmin_law', 'cookieadmin_gdpr'); $policy = cookieadmin_load_policy(); $policy['set'] = $view; $policy['admin_url'] = admin_url('admin-ajax.php'); $policy['cookieadmin_nonce'] = wp_create_nonce('cookieadmin_admin_js_nonce'); $cookieadmin_requires_pro = self::is_feature_available(1); echo '
'; wp_nonce_field('cookieadmin_admin_nonce', 'cookieadmin_security'); echo '

'; self::footer_theme(); } static function scan_cookies_page(){ global $cookieadmin_lang, $cookieadmin_error, $cookieadmin_msg, $wpdb; self::header_theme(__('Scan Cookies', 'cookieadmin')); $table_name = esc_sql($wpdb->prefix . 'cookieadmin_cookies'); $scanned = $wpdb->get_results("SELECT * FROM {$table_name} limit 1"); $cookies_scanned = ''; $categorized = []; $categorized_cookies = []; if(!empty($scanned)){ $is_categorized = $wpdb->get_var("SELECT * FROM {$table_name} WHERE category IS NOT NULL LIMIT 1"); $scanned_cookies = $wpdb->get_results("SELECT * FROM {$table_name}"); if(empty($is_categorized)){ foreach($scanned_cookies as $row => $data){ $exp = 'Session'; $data->expires = strtotime($data->expires); if(!empty($data->expires) && ($data->expires > 0)){ $exp = round(($data->expires - time()) / 86400); if($exp < 1 && !empty($data->max_age)){ $exp = $data->max_age . ' '.__('days', 'cookieadmin'); } } $cookies_scanned .= ''; } } else{ foreach($scanned_cookies as $row => $data){ $exp = 'Session'; if (!empty($data->expires) && is_string($data->expires)) { $timestamp = strtotime($data->expires); if ($timestamp && $timestamp > 0) { $exp = round(($timestamp - time()) / 86400); if ($exp < 1 && !empty($data->max_age)) { $exp = $data->max_age; } $exp .= ' '.__('days', 'cookieadmin'); } } if(empty($data->category)){ $data->category = 'Unknown'; } if(!isset($categorized[$data->category])){ $categorized[$data->category] = ''; } if(empty($data->description)){ $data->description = 'Not Available'; } $categorized[$data->category] .= ''; $categorized_cookies[$data->id]['id'] = $data->id; $categorized_cookies[$data->id]['cookie_name'] = $data->cookie_name; $categorized_cookies[$data->id]['description'] = $data->description; $categorized_cookies[$data->id]['category'] = $data->category; $categorized_cookies[$data->id]['expires'] = $exp; } $cookies_scanned .= ''; } }else{ $cookies_scanned .= ''; } 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); echo '
'.esc_html($data->cookie_name).''.esc_html($exp).''.esc_html($data->path).''.esc_html($data->domain).''.( $data->secure ? 'Yes' : 'No').'
'.esc_html($data->cookie_name).''.esc_html($data->description).''.esc_html($exp).'
'.esc_html__('No uncategorized cookies yet. Click on Scan Cookies button to scan for new cookies!', 'cookieadmin').'
'.esc_html__('No scanned cookies yet. Click on Scan Cookies button to scan for new cookies!', 'cookieadmin').'
'.( !empty($categorized['Necessary']) ? wp_kses_post($categorized['Necessary']) : '' ).' '.( !empty($categorized['Functional']) ? wp_kses_post($categorized['Functional']) : '' ).' '.( !empty($categorized['Analytics']) ? wp_kses_post($categorized['Analytics']) : '' ).' '.( !empty($categorized['Marketing']) ? wp_kses_post($categorized['Marketing']) : '' ).' '.( !empty($categorized['Unknown']) ? wp_kses_post($categorized['Unknown']) : '' ).'
'.esc_html__('Name', 'cookieadmin').' '.esc_html__('Description', 'cookieadmin').' '.esc_html__('Expiry', 'cookieadmin').' '.esc_html__('Action', 'cookieadmin').'
'.esc_html__('Necessary Cookies', 'cookieadmin').'
'.esc_html__('No Cookies Found!', 'cookieadmin').'
'.esc_html__('Functional Cookies', 'cookieadmin').'
'.esc_html__('No Cookies Found!', 'cookieadmin').'
'.esc_html__('Analytical Cookies', 'cookieadmin').'
'.esc_html__('No Cookies Found!', 'cookieadmin').'
'.esc_html__('Marketing Cookies', 'cookieadmin').'
'.esc_html__('No Cookies Found!', 'cookieadmin').'
'.esc_html__('Unknown Cookies', 'cookieadmin').'
'.esc_html__('No Cookies Found!', 'cookieadmin').'
'; wp_nonce_field('cookieadmin_admin_nonce', 'cookieadmin_security'); echo '
'; self::footer_theme(); echo ' '; } static function consent_form_page(){ global $cookieadmin_lang, $cookieadmin_error, $cookieadmin_msg; self::header_theme(__('Consent Form', 'cookieadmin')); $view = get_option('cookieadmin_law', 'cookieadmin_gdpr'); $policy = cookieadmin_load_policy(); $templates = implode("", cookieadmin_load_consent_template($policy[$view], $view)); $policy['set'] = $view; $policy['admin_url'] = admin_url('admin-ajax.php'); $policy['cookieadmin_nonce'] = wp_create_nonce('cookieadmin_admin_js_nonce'); $cookieadmin_requires_pro = self::is_feature_available(1); echo '
'; self::footer_theme(); $allowed_tags = cookieadmin_kses_allowed_html(); echo wp_kses($templates, $allowed_tags); } static function cookieadmin_scan_cookies($url = ''){ global $wpdb; $urls = array(get_site_url()); if(cookieadmin_is_pro()){ $cookieData = apply_filters('cookieadmin_pro_scan_cookies', $urls); }else{ $cookieData = \CookieAdmin\Scanner::start_scan($urls); } // cookieadmin_r_print($cookieData); if(!empty($cookieData) && self::save_raw_scan_results($cookieData)){ self::cookieadmin_auto_configure_cookies(); } wp_send_json_error(array('message' =>__('No cookies found!', 'cookieadmin'))); } static function cookieadmin_table_exists($table_name) { global $wpdb; $query = $wpdb->prepare("SHOW TABLES LIKE %s", $table_name); return $wpdb->get_var($query) === $table_name; } static function cookieadmin_save_settings(){ global $cookieadmin_lang, $cookieadmin_error, $cookieadmin_msg, $cookieadmin_settings, $cookieadmin_policies; // debug_print_backtrace();die; check_admin_referer('cookieadmin_admin_nonce', 'cookieadmin_security'); if(!current_user_can('administrator')){ wp_send_json_error(array('message' => __('Sorry, but you do not have permissions to perform this action', 'cookieadmin'))); } $policy = cookieadmin_load_policy(); $cookieadmin_consent_type = isset( $_REQUEST['cookieadmin_consent_type'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['cookieadmin_consent_type'] ) ) : ''; if(!empty($cookieadmin_consent_type)){ $laws = array('cookieadmin_gdpr' => '', 'cookieadmin_us' => ''); $law = array_key_exists($cookieadmin_consent_type, $laws) ? $cookieadmin_consent_type : 'cookieadmin_gdpr'; if(empty($cookieadmin_error)){ update_option('cookieadmin_law', $law); } } if(isset($_REQUEST['page']) && $_REQUEST['page'] === 'cookieadmin-settings'){ // Save cookieadmin_settings only on settings page $cookieadmin_settings['google_consent_mode_v2'] = (isset( $_REQUEST['cookieadmin_google_consent_mode_v2'] ) ? 1 : 0); $cookieadmin_settings['hide_powered_by'] = (isset( $_REQUEST['cookieadmin_hide_powered_by'] ) ? 1 : 0); $cookieadmin_settings['hide_reconsent'] = (isset( $_REQUEST['cookieadmin_hide_reconsent'] ) ? 1 : 0); if(empty($cookieadmin_error)){ update_option('cookieadmin_settings', $cookieadmin_settings); } // get the consent type from option table, if not saved then return default as 'gdpr' $law = get_option('cookieadmin_law', 'cookieadmin_gdpr'); //set preload and consent field for "cookieadmin-settings" page $setting['preload'] = !empty($_REQUEST['cookieadmin_preload']) ? array_map('sanitize_text_field', wp_unslash($_REQUEST['cookieadmin_preload'])) : []; $setting['reload_on_consent'] = !empty($_REQUEST['cookieadmin_reload_on_consent']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_reload_on_consent'])) : ''; }else{ // set saved or default preload and consent field for for "cookieadmin-consent" page $setting['preload'] = !empty($policy[$law]['preload']) ? $policy[$law]['preload'] : []; $setting['reload_on_consent'] = !empty($policy[$law]['reload_on_consent']) ? $policy[$law]['reload_on_consent'] : ''; } $setting['cookieadmin_geo_tgt'] = (!empty($_REQUEST['cookieadmin_geo_tgt'])) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_geo_tgt'])) : 'www'; $setting['cookieadmin_layout'] = (!empty($_REQUEST['cookieadmin_layout']) && in_array($_REQUEST['cookieadmin_layout'], array('box', 'footer', 'popup'))) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_layout'])) : (!empty($policy[$law]['cookieadmin_layout']) ? $policy[$law]['cookieadmin_layout'] : 'box'); $setting['cookieadmin_position'] = (!empty($_REQUEST['cookieadmin_position']) && in_array($_REQUEST['cookieadmin_position'], array('bottom_left', 'bottom_right', 'top_left', 'top_right', 'top', 'bottom'))) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_position'])) : (!empty($policy[$law]['cookieadmin_position']) ? $policy[$law]['cookieadmin_position'] : 'bottom_left'); $setting['cookieadmin_modal'] = (isset($_REQUEST['cookieadmin_modal']) && in_array($_REQUEST['cookieadmin_modal'], array('center', 'side', 'down'))) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_modal'])) : (!empty($policy[$law]['cookieadmin_modal']) ? $policy[$law]['cookieadmin_modal'] : 'center'); if($setting['cookieadmin_layout'] == 'popup'){ $setting['cookieadmin_modal'] = 'center'; unset($setting['cookieadmin_position']); } $setting['cookieadmin_notice_title'] = !empty($_REQUEST['cookieadmin_notice_title']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_notice_title'])) : $policy[$law]['cookieadmin_notice_title']; $setting['cookieadmin_notice_title_color'] = !empty($_REQUEST['cookieadmin_notice_title_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_notice_title_color'])) : (!empty($policy[$law]['cookieadmin_notice_title_color']) ? $policy[$law]['cookieadmin_notice_title_color'] : '#000000'); $setting['cookieadmin_notice'] = !empty($_REQUEST['cookieadmin_notice']) ? wp_kses(wp_unslash($_REQUEST['cookieadmin_notice']), cookieadmin_kses_allowed_html()) : $policy[$law]['cookieadmin_notice']; $setting['cookieadmin_notice_color'] = !empty($_REQUEST['cookieadmin_notice_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_notice_color'])) : (!empty($policy[$law]['cookieadmin_notice_color']) ? $policy[$law]['cookieadmin_notice_color'] : '#000000'); $setting['cookieadmin_consent_inside_bg_color'] = !empty($_REQUEST['cookieadmin_consent_inside_bg_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_consent_inside_bg_color'])) : (!empty($policy[$law]['cookieadmin_consent_inside_bg_color']) ? $policy[$law]['cookieadmin_consent_inside_bg_color'] : '#ffffff'); $setting['cookieadmin_consent_inside_border_color'] = !empty($_REQUEST['cookieadmin_consent_inside_border_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_consent_inside_border_color'])) : (!empty($policy[$law]['cookieadmin_consent_inside_border_color']) ? $policy[$law]['cookieadmin_consent_inside_border_color'] : '#000000'); $setting['cookieadmin_customize_btn'] = !empty($_REQUEST['cookieadmin_customize_btn']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_customize_btn'])) : (!empty($policy[$law]['cookieadmin_customize_btn']) ? $policy[$law]['cookieadmin_customize_btn'] : 'Customize'); $setting['cookieadmin_customize_btn_color'] = !empty($_REQUEST['cookieadmin_customize_btn_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_customize_btn_color'])) : (!empty($policy[$law]['cookieadmin_customize_btn_color']) ? $policy[$law]['cookieadmin_customize_btn_color'] : '#ffffff'); $setting['cookieadmin_customize_btn_bg_color'] = !empty($_REQUEST['cookieadmin_customize_btn_bg_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_customize_btn_bg_color'])) : (!empty($policy[$law]['cookieadmin_customize_btn_bg_color']) ? $policy[$law]['cookieadmin_customize_btn_bg_color'] : '#0000ff'); $setting['cookieadmin_reject_btn'] = !empty($_REQUEST['cookieadmin_reject_btn']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_reject_btn'])) : (!empty($policy[$law]['cookieadmin_reject_btn']) ? $policy[$law]['cookieadmin_reject_btn'] : 'Reject All'); $setting['cookieadmin_reject_btn_color'] = !empty($_REQUEST['cookieadmin_reject_btn_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_reject_btn_color'])) : (!empty($policy[$law]['cookieadmin_reject_btn_color']) ? $policy[$law]['cookieadmin_reject_btn_color'] : '#ffffff'); $setting['cookieadmin_reject_btn_bg_color'] = !empty($_REQUEST['cookieadmin_reject_btn_bg_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_reject_btn_bg_color'])) : (!empty($policy[$law]['cookieadmin_reject_btn_bg_color']) ? $policy[$law]['cookieadmin_reject_btn_bg_color'] : '#ff0000'); $setting['cookieadmin_accept_btn'] = !empty($_REQUEST['cookieadmin_accept_btn']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_accept_btn'])) : (!empty($policy[$law]['cookieadmin_accept_btn']) ? $policy[$law]['cookieadmin_accept_btn'] : 'Accept All'); $setting['cookieadmin_accept_btn_color'] = !empty($_REQUEST['cookieadmin_accept_btn_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_accept_btn_color'])) : (!empty($policy[$law]['cookieadmin_accept_btn']) ? $policy[$law]['cookieadmin_accept_btn_color'] : '#ffffff'); $setting['cookieadmin_accept_btn_bg_color'] = !empty($_REQUEST['cookieadmin_accept_btn_bg_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_accept_btn_bg_color'])) : (!empty($policy[$law]['cookieadmin_accept_btn_bg_color']) ? $policy[$law]['cookieadmin_accept_btn_bg_color'] : '#00ff00'); $setting['cookieadmin_save_btn'] = !empty($_REQUEST['cookieadmin_save_btn']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_save_btn'])) : (!empty($policy[$law]['cookieadmin_save_btn']) ? $policy[$law]['cookieadmin_save_btn'] : 'Save Preferences'); $setting['cookieadmin_save_btn_color'] = !empty($_REQUEST['cookieadmin_save_btn_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_save_btn_color'])) : (!empty($policy[$law]['cookieadmin_save_btn_color']) ? $policy[$law]['cookieadmin_save_btn_color'] : '#ffffff'); $setting['cookieadmin_save_btn_bg_color'] = !empty($_REQUEST['cookieadmin_save_btn_bg_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_save_btn_bg_color'])) : (!empty($policy[$law]['cookieadmin_save_btn_bg_color']) ? $policy[$law]['cookieadmin_save_btn_bg_color'] : '#183833'); $setting['cookieadmin_preference_title'] = !empty($_REQUEST['cookieadmin_preference_title']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_preference_title'])) : $policy[$law]['cookieadmin_preference_title']; $setting['cookieadmin_preference_title_color'] = !empty($_REQUEST['cookieadmin_preference_title_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_preference_title_color'])) : (!empty($policy[$law]['cookieadmin_preference_title_color']) ? $policy[$law]['cookieadmin_preference_title_color'] : '#000000'); $setting['cookieadmin_preference'] = !empty($_REQUEST['cookieadmin_preference']) ? wp_kses(wp_unslash($_REQUEST['cookieadmin_preference']), cookieadmin_kses_allowed_html()) : $policy[$law]['cookieadmin_preference']; $setting['cookieadmin_details_wrapper_color'] = !empty($_REQUEST['cookieadmin_details_wrapper_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_details_wrapper_color'])) : (!empty($policy[$law]['cookieadmin_details_wrapper_color']) ? $policy[$law]['cookieadmin_details_wrapper_color'] : '#000000'); $setting['cookieadmin_cookie_modal_bg_color'] = !empty($_REQUEST['cookieadmin_cookie_modal_bg_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_cookie_modal_bg_color'])) : (!empty($policy[$law]['cookieadmin_cookie_modal_bg_color']) ? $policy[$law]['cookieadmin_cookie_modal_bg_color'] : '#ffffff'); $setting['cookieadmin_cookie_modal_border_color'] = !empty($_REQUEST['cookieadmin_cookie_modal_border_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_cookie_modal_border_color'])) : (!empty($policy[$law]['cookieadmin_cookie_modal_border_color']) ? $policy[$law]['cookieadmin_cookie_modal_border_color'] : '#000000'); $setting['cookieadmin_slider_off_bg_color'] = !empty($_REQUEST['cookieadmin_slider_off_bg_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_slider_off_bg_color'])) : (!empty($policy[$law]['cookieadmin_slider_off_bg_color']) ? $policy[$law]['cookieadmin_slider_off_bg_color'] : '#808080'); $setting['cookieadmin_slider_on_bg_color'] = !empty($_REQUEST['cookieadmin_slider_on_bg_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_slider_on_bg_color'])) : (!empty($policy[$law]['cookieadmin_slider_on_bg_color']) ? $policy[$law]['cookieadmin_slider_on_bg_color'] : '#3582c4'); $setting['cookieadmin_links_color'] = !empty($_REQUEST['cookieadmin_links_color']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_links_color'])) : (!empty($policy[$law]['cookieadmin_links_color']) ? $policy[$law]['cookieadmin_links_color'] : '#1863dc'); $setting['cookieadmin_days'] = !empty($_REQUEST['cookieadmin_days']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_days'])) : (!empty($policy[$law]['cookieadmin_days']) ? $policy[$law]['cookieadmin_days'] : '365'); $policy[$law] = $setting; // Check for certain fields to be saved only if their values is not the same as default $cookieadmin_check_changes = array('cookieadmin_notice_title', 'cookieadmin_notice', 'cookieadmin_preference_title', 'cookieadmin_preference', 'reConsent_title', 'cookieadmin_customize_btn', 'cookieadmin_reject_btn', 'cookieadmin_accept_btn', 'cookieadmin_save_btn'); foreach($cookieadmin_check_changes as $c_field){ foreach($policy as $c_law => $c_val){ if(!empty($c_val[$c_field]) && $c_val[$c_field] == $cookieadmin_policies[$c_law][$c_field]){ unset($policy[$c_law][$c_field]); } } } update_option('cookieadmin_consent_settings', $policy); if(empty($cookieadmin_error)){ $cookieadmin_msg = __('Settings saved successfully', 'cookieadmin'); } } static function cookieadmin_auto_configure_cookies(){ global $wpdb; $table_name = esc_sql($wpdb->prefix . 'cookieadmin_cookies'); $categorized_cookies = []; $uncategorized_cookies = []; $all_cookies = $wpdb->get_results("SELECT cookie_name, category FROM {$table_name}"); foreach($all_cookies as $cookie){ if(!empty($cookie->categorized)){ $categorized_cookies[] = $cookie->cookie_name; }else{ $uncategorized_cookies[] = $cookie->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 = $categorizd_cookies['remove_cookies']; unset($categorizd_cookies['remove_cookies']); if(!empty($remove_cookies)){ $placeholders = implode(',', array_fill(0, count($remove_cookies), '%s')); $sql = $wpdb->prepare("DELETE FROM {$table_name} WHERE raw_name IN ({$placeholders})", ...$remove_cookies); $wpdb->query($sql); } foreach($categorizd_cookies as $cookie_data){ $wpdb->update( $table_name, [ 'cookie_name' => $cookie_data['cookie_name'], 'category' => $cookie_data['category'], 'description' => $cookie_data['description'], 'edited' => 1, 'patterns' => $cookie_data['patterns'] ], // Data to update [ 'raw_name' => $cookie_data['raw_name'] ], // WHERE [ '%s', '%s', '%s', '%d', '%s' ], // Format for the data [ '%s' ] // Format for the WHERE clause ); } $categorized_cookies = $wpdb->get_results("SELECT id, cookie_name, category, expires, description FROM {$table_name}"); wp_send_json_success($categorized_cookies); } wp_send_json(['success' => true, 'data' => null, 'message' => __('No cookies to categorize!', 'cookieadmin')]); } static function cookieadmin_edit_cookies(){ global $wpdb; $table_name = esc_sql($wpdb->prefix . 'cookieadmin_cookies'); if(!empty($_REQUEST['cookie_info'])) { $cookie_info = wp_unslash($_REQUEST['cookie_info']); $resp = $wpdb->update( $table_name, [ 'cookie_name' => sanitize_text_field($cookie_info['name']), 'description' => sanitize_text_field($cookie_info['description']), 'expires' => sanitize_text_field($cookie_info['duration']), 'category' => sanitize_text_field($cookie_info['type']), 'edited' => 1], // Data to update [ 'id' => sanitize_text_field($cookie_info['id']) ], // WHERE [ '%s', '%s', '%s', '%s', '%d' ], // Format for the data [ '%d' ] // Format for the WHERE clause ); }elseif( !empty($_REQUEST['cookie_raw_id']) ){ $cookie_id = (int) sanitize_text_field(wp_unslash($_REQUEST['cookie_raw_id'])); $resp = $wpdb->delete( $table_name, ['id' => $cookie_id], [ '%s' ] ); } if ($wpdb->last_error || $resp === false) { //error_log('DB Error: ' . $wpdb->last_error); // Log it wp_send_json(['success' => true, 'data' => null, 'message' => __('Error editing cookie, Error: ', 'cookieadmin') . esc_html($wpdb->last_error)]); } wp_send_json_success(__('Cookie updated!', 'cookieadmin')); } static function save_raw_scan_results(array $found_cookies){ global $wpdb; $table_name = esc_sql($wpdb->prefix . 'cookieadmin_cookies'); if (empty($found_cookies)) { return ['inserted' => 0, 'updated' => 0]; } // Step 1: Fetch all existing cookie names from our database in one efficient query. $existing_cookies_in_db = $wpdb->get_col("SELECT cookie_name FROM {$table_name}"); // 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' => 0, 'updated' => 0]; // Step 2: Loop through each cookie found by the scanner. foreach ($found_cookies as $cookie_name => $cookie_data) { // Step 3: Check if the cookie exists in our DB. if (isset($existing_cookies_lookup[$cookie_name])) { $wpdb->update( $table_name, [ 'scan_timestamp' => time() ], // Data to update [ 'cookie_name' => $cookie_name ], // WHERE clause [ '%s' ], // Format for the data [ '%s' ] // Format for the WHERE clause ); $results['updated']++; } else { // ------ INSERT a NEW cookie ------ $data = [ 'cookie_name' => sanitize_text_field($cookie_name), 'domain' => sanitize_text_field($cookie_data['domain']), 'path' => sanitize_text_field($cookie_data['path']), 'expires' => !empty($cookie_data['expires']) ? $cookie_data['expires'] : null, 'max_age' => $cookie_data['Max-Age'] ? $cookie_data['Max-Age'] : null, 'samesite' => !empty($cookie_data['samesite']) ? sanitize_text_field($cookie_data['samesite']) : null, 'secure' => (int)($cookie_data['secure'] ?? 0), 'httponly' => (int)($cookie_data['httponly'] ?? 0), 'raw_name' => sanitize_text_field($cookie_name), 'scan_timestamp' => time(), ]; $formats = ['%s', '%s', '%s', '%s', '%d', '%s', '%d', '%d', '%s']; if ($wpdb->insert($table_name, $data, $formats)) { $results['inserted']++; } else { //error_log("CookieAdmin: Error inserting cookie data: " . $wpdb->last_error); } } } return $results; } static function plugin_update_notice(){ if(defined('SOFTACULOUS_PLUGIN_UPDATE_NOTICE')){ return; } $to_update_plugins = apply_filters('softaculous_plugin_update_notice', []); if(empty($to_update_plugins)){ return; } /* translators: %1$s is replaced with a "string" of name of plugins, and %2$s is replaced with "string" which can be "is" or "are" based on the count of the plugin */ $msg = sprintf(__('New versions of %1$s %2$s available. Updating ensures better performance, security, and access to the latest features.', 'cookieadmin'), ''.esc_html(implode(', ', $to_update_plugins)).'', (count($to_update_plugins) > 1 ? 'are' : 'is')) . ' Update Now'; define('SOFTACULOUS_PLUGIN_UPDATE_NOTICE', true); // To make sure other plugins don't return a Notice echo '

'.wp_kses_post($msg). '

'; wp_register_script('cookieadmin-update-notice', '', ['jquery'], '', true); wp_enqueue_script('cookieadmin-update-notice'); wp_add_inline_script('cookieadmin-update-notice', 'jQuery("#cookieadmin-plugin-update-notice").on("click", function(e){ let target = jQuery(e.target); if(!target.hasClass("notice-dismiss")){ return; } var data; // Hide it jQuery("#cookieadmin-plugin-update-notice").hide(); // Save this preference jQuery.post("'.admin_url('admin-ajax.php?action=cookieadmin_ajax_handler&cookieadmin_act=close-update-notice').'&cookieadmin_security='.wp_create_nonce('cookieadmin_admin_js_nonce').'", data, function(response) { //alert(response); }); });'); } static function plugin_update_notice_filter($plugins = []){ $plugins['cookieadmin/cookieadmin.php'] = 'CookieAdmin'; return $plugins; } static function close_plugin_update_notice(){ $plugin_update_notice = get_option('softaculous_plugin_update_notice', []); $available_update_list = get_site_transient('update_plugins'); $to_update_plugins = apply_filters('softaculous_plugin_update_notice', []); if(empty($available_update_list) || empty($available_update_list->response)){ return; } foreach($to_update_plugins as $plugin_path => $plugin_name){ if(isset($available_update_list->response[$plugin_path])){ $plugin_update_notice[$plugin_path] = $available_update_list->response[$plugin_path]->new_version; } } update_option('softaculous_plugin_update_notice', $plugin_update_notice); } static function is_feature_available($return = 0){ if(cookieadmin_is_pro()){ return ''; } $msg = ' '.__('Pro', 'cookieadmin').''; if(!empty($return)){ return $msg; }else{ echo wp_kses_post($msg); } } }