.'){kind=icon}
';
}
return $icons_grid;
}
// Admin notice to create consent table if missing when consent logs are enabled
static function table_missing_notice(){
if(!is_admin()) return;
// Only show on our plugin admin pages
$current_page = isset($_GET['page']) ? sanitize_text_field(wp_unslash($_GET['page'])) : '';
if(strpos($current_page, 'cookieadmin') === FALSE) {
return;
}
global $wpdb;
$table_name = $wpdb->prefix . 'cookieadmin_consents';
$exists = $wpdb->get_var($wpdb->prepare("SHOW TABLES LIKE %s", $table_name));
if($exists === $table_name){
return;
}
echo '';
echo '
';
}
//Add Main Menu
static function plugin_menu(){
}
static function show_settings($title = 'CookieAdmin Pro'){
}
static function cookieadmin_pro_table_exists($table_name) {
global $wpdb;
$query = $wpdb->prepare("SHOW TABLES LIKE %s", $table_name);
return $wpdb->get_var($query) === $table_name;
}
// Create Consent table via AJAX
static function create_consent_table() {
\CookieAdminPro\Database::activate();
wp_send_json_success(esc_html__('Consent table created', 'cookieadmin'));
}
static function show_consent_logs(){
global $cookieadmin_lang, $cookieadmin_error, $cookieadmin_msg;
\CookieAdmin\Admin::header_theme(__('Consent Logs', 'cookieadmin'));
$log_data = \CookieAdminPro\Admin::get_consent_logs();
$consent_logs = (!empty($log_data['logs']) ? $log_data['logs'] : array());
echo '
';
\CookieAdmin\Admin::footer_theme();
}
//Load Consent logs data from the database
static function get_consent_logs(){
global $wpdb;
if($_POST && count($_POST) > 0){
$nonce_slug = (wp_doing_ajax() ? 'cookieadmin_pro_admin_js_nonce' : 'cookieadmin_pro_admin_nonce');
check_admin_referer($nonce_slug, 'cookieadmin_pro_security');
}
if(!current_user_can('administrator')){
wp_send_json_error(array('message' => 'Sorry, but you do not have permissions to perform this action'));
}
$num_items = 0;
$table_name = esc_sql($wpdb->prefix . 'cookieadmin_consents');
$current_page = isset($_POST['current_page']) ? intval($_POST['current_page']) : 1;
if (!\CookieAdminPro\Admin::cookieadmin_pro_table_exists($table_name)) {
// wp_send_json_error(['message' => 'Table does not exist']);
return array();
}
// Get total number of logs
$total_consent_logs = (int) $wpdb->get_var("SELECT COUNT(*) FROM $table_name");
$logs_per_page = 25;
// Calculate max pages
$max_page = ceil($total_consent_logs / $logs_per_page);
$max_page = max(1, $max_page);
// Ensure current page is within valid range
if ($current_page > $max_page) {
$current_page = $max_page;
} elseif ($current_page < 1) {
$current_page = 1;
}
// Calculate pagination offset
$offset = ($current_page - 1) * $logs_per_page;
// Fetch paginated logs
$consent_logs = $wpdb->get_results(
$wpdb->prepare(
"SELECT * FROM $table_name ORDER BY id DESC LIMIT %d OFFSET %d",
$logs_per_page,
$offset
),
ARRAY_A
);
if(!empty($consent_logs)){
foreach($consent_logs as $lk => $log){
if(!empty($log['consent_status'])){
$_consent_status = json_decode($log['consent_status'], true)[0];
if($_consent_status == 'accept'){
$consent_logs[$lk]['consent_status_raw'] = 'accept';
$consent_logs[$lk]['consent_status'] = __('Accepted', 'cookieadmin');
}elseif($_consent_status == 'reject'){
$consent_logs[$lk]['consent_status_raw'] = 'reject';
$consent_logs[$lk]['consent_status'] = __('Rejected', 'cookieadmin');
}else{
$consent_logs[$lk]['consent_status_raw'] = 'partially_accepted';
$consent_logs[$lk]['consent_status'] = __('Partially Accepted', 'cookieadmin');
}
}
if(!empty($log['consent_time'])){
$consent_logs[$lk]['consent_time'] = cookieadmin_pro_human_readable_time($log['consent_time']);
}
if(!empty($log['user_ip'])){
$consent_logs[$lk]['user_ip'] = inet_ntop($log['user_ip']);
}
}
$num_items = count($consent_logs);
}
$min_items = $offset + 1;
$max_items = $min_items + ($num_items - 1);
$return = [
'logs' => $consent_logs,
'total_logs' => $total_consent_logs,
'logs_per_page' => $logs_per_page,
'current_page' => $current_page,
'total_pages' => $max_page,
'min_items' => $min_items,
'max_items' => $max_items
];
// Return logs as JSON response
if (defined('DOING_AJAX') && DOING_AJAX) {
wp_send_json_success($return);
}
// Return paginated data
return $return;
}
// Export Consent Logs from the Database
static function export_logs() {
global $wpdb;
$cookieadmin_export_type = !empty($_REQUEST['cookieadmin_export_type']) ? sanitize_text_field(wp_unslash($_REQUEST['cookieadmin_export_type'])) : '';
if(!empty($cookieadmin_export_type)){
if($cookieadmin_export_type == 'consent_logs'){
$table_name = esc_sql($wpdb->prefix . 'cookieadmin_consents');
//First will check if the table in the database exists or not?
if(!self::cookieadmin_pro_table_exists($table_name)){
echo -1;
echo esc_html__('Table does not exists', 'cookieadmin');
wp_die();
}
$logs = $wpdb->get_results("SELECT * FROM $table_name ORDER BY id DESC", ARRAY_A);
$filename = 'cookieadmin-consent-logs';
}
}
if(empty($logs)){
echo -1;
echo esc_html__('No data to export', 'cookieadmin');
wp_die();
}
header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename='.$filename.'.csv');
$allowed_fields = array('consent_id' => 'Consent Id', 'consent_status' => 'Consent Status', 'country' => 'Country', 'user_ip' => 'User IP (Anonymized)', 'consent_time' => 'Consent Time');
$file = fopen("php://output","w");
fputcsv($file, array_values($allowed_fields));
foreach($logs as $ik => $log){
if(!empty($log['consent_status'])){
$_consent_status = json_decode($log['consent_status'], true)[0];
if($_consent_status == 'accept'){
$log['consent_status'] = __('Accepted', 'cookieadmin');
}elseif($_consent_status == 'reject'){
$log['consent_status'] = __('Rejected', 'cookieadmin');
}else{
$log['consent_status'] = __('Partially Accepted', 'cookieadmin');
}
}
if(!empty($log['consent_time'])){
$log['consent_time'] = wp_date('M j Y g:i A T', $log['consent_time']);
}
if(!empty($log['user_ip'])){
$log['user_ip'] = inet_ntop($log['user_ip']);
}
$log['country'] = (!empty($log['country']) ? $log['country'] : '—');
$row = array();
foreach($allowed_fields as $ak => $av){
$row[$ak] = $log[$ak];
}
fputcsv($file, $row);
}
fclose($file);
wp_die();
}
static function version_notice(){
$type = '';
if(!empty($_REQUEST['type'])){
$type = sanitize_text_field(wp_unslash($_REQUEST['type']));
}
if(empty($type)){
wp_send_json_error(__('Unknow version difference type', 'cookieadmin'));
}
update_option('cookieadmin_version_'. $type .'_nag', time() + WEEK_IN_SECONDS);
wp_send_json_success();
}
static function dismiss_expired_licenses(){
update_option('softaculous_expired_licenses', time());
wp_send_json_success();
}
// Manual Add cookie feature for Admin
static function add_cookie(){
global $wpdb;
$table_name = esc_sql($wpdb->prefix . 'cookieadmin_cookies');
$data = null;
if(empty($_REQUEST['cookie_info'])){
wp_send_json([
'success' => false,
'data' => null,
'message' => __('Error : Cookie details missing', 'cookieadmin')]);
}
$cookie_info = map_deep(wp_unslash($_REQUEST['cookie_info']), 'sanitize_text_field' );
$scan_timestamp = time();
if(empty($cookie_info['duration'])){
$calculated_expiry = 0;
}else{
$calculated_expiry_seconds = ($cookie_info['duration'] * 86400) + $scan_timestamp;
$calculated_expiry = date('Y-m-d H:i:s', $calculated_expiry_seconds);
}
$data = [
'cookie_name' => $cookie_info['name'],
'category' => $cookie_info['type'],
'description' => $cookie_info['description'],
'domain' => wp_parse_url( home_url(), PHP_URL_HOST ),
'expires' => $calculated_expiry,
'scan_timestamp' => $scan_timestamp,
'edited' => 1
];
$formats = ['%s', '%s', '%s', '%s', '%s', '%d', '%d'];
$wpdb->insert($table_name, $data, $formats);
$data = $wpdb->insert_id;
if ($wpdb->last_error || $data === false) {
//error_log('DB Error: ' . $wpdb->last_error); // Log it
wp_send_json([
'success' => false,
'data' => null,
'message' => __('Cookie addition Failed, Error: ', 'cookieadmin') . esc_html($wpdb->last_error)
]);
}
wp_send_json([
'success' => true,
'data' => $data,
'message' => __('Cookie addition successful', 'cookieadmin')
]);
}
//Starts the consent logs deletion for ajax
static function consent_log_pruning_ajax(){
if(get_transient('cookieadmin_pruning_in_progress')){
wp_send_json([
'success' => false,
'message' => __('Deletion is already running in the background. You will be notified on completion.', 'cookieadmin')
]);
}
$consent_logs_expiry = !empty($_REQUEST['consent_logs_expiry']) ? absint(wp_unslash($_REQUEST['consent_logs_expiry'])) : 0;
if($consent_logs_expiry <= 0){
wp_send_json([
'success' => false,
'message' => __('Please set a valid logs expiry day(s) limit to start deleting.', 'cookieadmin')
]);
}
$retention_limit = time() - ($consent_logs_expiry * DAY_IN_SECONDS);
set_transient('cookieadmin_pruning_in_progress', 'true', 3600);
\CookieAdminPro\Cron::consent_log_pruning_batch($retention_limit);
wp_send_json([
'success' => false,
'message' => __('Deletion has started in the background. You will be notified on completion.', 'cookieadmin')
]);
}
static function cookieadmin_get_site_urls($urls = [], $limit = 10){
$limit = max(1, (int) $limit);
// Build representative URLs only if none provided
if(empty($urls)){
// 1. Homepage (mandatory)
$urls[] = home_url('/');
// 2. One static page (page.php)
$page = get_posts([
'post_type' => 'page',
'post_status' => 'publish',
'posts_per_page' => 1,
'fields' => 'ids',
'no_found_rows' => true
]);
if (!empty($page[0])) {
$urls[] = get_permalink($page[0]);
}
}
// Normalize, dedupe, limit
$urls = array_map('untrailingslashit', $urls);
$urls = array_values(array_unique($urls));
$urls = array_slice($urls, 0, $limit);
// Persist canonical scan set
update_option('cookieadmin_to_scan_urls', $urls);
return apply_filters('cookieadmin_scan_urls', $urls);
}
// Saves cookieadmin_settings settings for the Pro features.
static function save_settings($value, $old_value, $option){
global $cookieadmin, $cookieadmin_settings;
// If we are not saving any settings we simply return
if(empty($_REQUEST['cookieadmin_save_settings'])){
return $value;
}
check_admin_referer('cookieadmin_admin_nonce', 'cookieadmin_security');
if(!current_user_can('administrator')){
wp_die(__('Sorry, but you do not have permissions to perform this action', 'cookieadmin'));
}
if(empty($value)){
$value = [];
}
$cookieadmin_settings = $value;
$cookieadmin_settings['respect_gpc'] = !empty($_REQUEST['cookieadmin_respect_gpc']);
$cookieadmin_settings['gpc_message'] = !empty($_REQUEST['cookieadmin_gpc_message']) ? trim(sanitize_textarea_field(wp_unslash($_REQUEST['cookieadmin_gpc_message']))) : '';
$cookieadmin_settings['gpc_override_warning'] = !empty($_REQUEST['cookieadmin_gpc_override_warning']) ? trim(sanitize_textarea_field(wp_unslash($_REQUEST['cookieadmin_gpc_override_warning']))) : '';
if($cookieadmin_settings['gpc_message'] === $cookieadmin['gpc_message_default']){
unset($cookieadmin_settings['gpc_message']);
}
if($cookieadmin_settings['gpc_override_warning'] === $cookieadmin['gpc_override_warning_default']){
unset($cookieadmin_settings['gpc_override_warning']);
}
// Creating gpc.json if respect gpc was enabled.
if(!empty($cookieadmin_settings['respect_gpc']) && (empty($old_value) || empty($old_value['respect_gpc']))){
\CookieAdminPro\GPC::create_gpc_json_file();
}
// If GPC has been disable we will need to delete the gpc.json file
if(empty($cookieadmin_settings['respect_gpc']) && !empty($old_value) && !empty($old_value['respect_gpc'])){
$gpc_path = ABSPATH . '.well-known/gpc.json';
if(file_exists($gpc_path)){
unlink($gpc_path);
}
}
return $cookieadmin_settings;
}
}
'.esc_html__('The Consent table is missing. Consent Logs and Consent data cannot be saved.', 'cookieadmin').'
'; echo ''; echo '