<?php

[0] Fix | Delete

[1] Fix | Delete

namespace CookieAdminPro;

[2] Fix | Delete

[3] Fix | Delete

if(!defined('COOKIEADMIN_PRO_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 $consent_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::$consent_table = esc_sql(self::$wpdb->prefix . 'cookieadmin_consents');

[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 Consent table

[28] Fix | Delete

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

[29] Fix | Delete

id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,

[30] Fix | Delete

consent_id VARCHAR(128) NOT NULL UNIQUE, -- Designed to store up to 128 characters for future expansion

[31] Fix | Delete

user_ip VARBINARY(16) DEFAULT NULL, -- For storing anonymized IP (IPv4 or IPv6)

[32] Fix | Delete

consent_time INT NOT NULL,

[33] Fix | Delete

country VARCHAR(150) DEFAULT NULL, -- Full country name

[34] Fix | Delete

browser TEXT DEFAULT NULL, -- Browser User agent string

[35] Fix | Delete

domain VARCHAR(255) DEFAULT NULL, -- Domain from which consent was submitted

[36] Fix | Delete

consent_status VARCHAR(50) NOT NULL -- Stores 'accepted', 'rejected', 'partially accepted', etc.

[37] Fix | Delete

) {$charset_collate};";

[38] Fix | Delete

[39] Fix | Delete

dbDelta($sql);

[40] Fix | Delete

}

[41] Fix | Delete

}

[42] Fix | Delete

[43] Fix | Delete

[44] Fix | Delete

[45] Fix | Delete