<?php

[0] Fix | Delete

[1] Fix | Delete

namespace CookieAdmin;

[2] Fix | Delete

[3] Fix | Delete

if(!defined('COOKIEADMIN_VERSION') || !defined('ABSPATH')){

[4] Fix | Delete

die('Hacking Attempt');

[5] Fix | Delete

}

[6] Fix | Delete

[7] Fix | Delete

class Database{

[8] Fix | Delete

[9] Fix | Delete

static $wpdb = '';

[10] Fix | Delete

static $scanned_cookies_table = '';

[11] Fix | Delete

[12] Fix | Delete

static function activate(){

[13] Fix | Delete

[14] Fix | Delete

global $wpdb;

[15] Fix | Delete

[16] Fix | Delete

self::$wpdb = $wpdb;

[17] Fix | Delete

self::$scanned_cookies_table = esc_sql(self::$wpdb->prefix . 'cookieadmin_cookies');

[18] Fix | Delete

self::cookieadmin_create_tables();

[19] Fix | Delete

}

[20] Fix | Delete

[21] Fix | Delete

static function cookieadmin_create_tables() {

[22] Fix | Delete

[23] Fix | Delete

$charset_collate = self::$wpdb->get_charset_collate();

[24] Fix | Delete

$db_path = !defined('SITEPAD') ? ABSPATH . 'wp-admin/includes/upgrade.php' : ABSPATH . 'site-admin/includes/upgrade.php';

[25] Fix | Delete

require_once($db_path);

[26] Fix | Delete

[27] Fix | Delete

//Create scanned Cookies table

[28] Fix | Delete

$sql = "CREATE TABLE IF NOT EXISTS ".self::$scanned_cookies_table." (

[29] Fix | Delete

id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, -- Auto Increment ID

[30] Fix | Delete

cookie_name VARCHAR(100) NOT NULL, -- Cookie name (e.g., CookieConsent, td)

[31] Fix | Delete

category VARCHAR(50) DEFAULT NULL,

[32] Fix | Delete

description VARCHAR(500) DEFAULT NULL,

[33] Fix | Delete

domain VARCHAR(255) NOT NULL,

[34] Fix | Delete

path VARCHAR(255) NULL DEFAULT '/',

[35] Fix | Delete

expires DATETIME NULL DEFAULT NULL,

[36] Fix | Delete

max_age INT(11) NULL DEFAULT NULL,

[37] Fix | Delete

samesite VARCHAR(10) NULL DEFAULT NULL,

[38] Fix | Delete

secure TINYINT(1) NOT NULL DEFAULT 0,

[39] Fix | Delete

httponly TINYINT(1) NOT NULL DEFAULT 0,

[40] Fix | Delete

raw_name VARCHAR(255) NULL,

[41] Fix | Delete

edited TINYINT(1) NULL DEFAULT 0,

[42] Fix | Delete

patterns VARCHAR(255) NOT NULL DEFAULT '[]',

[43] Fix | Delete

scan_timestamp INT(11) NULL DEFAULT 0

[44] Fix | Delete

) {$charset_collate};";

[45] Fix | Delete

[46] Fix | Delete

dbDelta($sql);

[47] Fix | Delete

}

[48] Fix | Delete

}

[49] Fix | Delete

[50] Fix | Delete

[51] Fix | Delete

[52] Fix | Delete