| 1 |
<?php |
| 2 |
|
| 3 |
namespace CookieAdmin; |
| 4 |
|
| 5 |
if(!defined('COOKIEADMIN_VERSION') || !defined('ABSPATH')){ |
| 6 |
die('Hacking Attempt'); |
| 7 |
} |
| 8 |
|
| 9 |
class Database{ |
| 10 |
|
| 11 |
static $wpdb = ''; |
| 12 |
static $scanned_cookies_table = ''; |
| 13 |
|
| 14 |
static function activate(){ |
| 15 |
|
| 16 |
global $wpdb; |
| 17 |
|
| 18 |
self::$wpdb = $wpdb; |
| 19 |
self::$scanned_cookies_table = esc_sql(self::$wpdb->prefix . 'cookieadmin_cookies'); |
| 20 |
self::cookieadmin_create_tables(); |
| 21 |
} |
| 22 |
|
| 23 |
static function cookieadmin_create_tables() { |
| 24 |
|
| 25 |
$charset_collate = self::$wpdb->get_charset_collate(); |
| 26 |
$db_path = !defined('SITEPAD') ? ABSPATH . 'wp-admin/includes/upgrade.php' : ABSPATH . 'site-admin/includes/upgrade.php'; |
| 27 |
require_once($db_path); |
| 28 |
|
| 29 |
//Create scanned Cookies table |
| 30 |
$sql = "CREATE TABLE IF NOT EXISTS ".self::$scanned_cookies_table." ( |
| 31 |
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, -- Auto Increment ID |
| 32 |
cookie_name VARCHAR(100) NOT NULL, -- Cookie name (e.g., CookieConsent, td) |
| 33 |
category VARCHAR(50) DEFAULT NULL, |
| 34 |
description VARCHAR(500) DEFAULT NULL, |
| 35 |
domain VARCHAR(255) NOT NULL, |
| 36 |
path VARCHAR(255) NULL DEFAULT '/', |
| 37 |
expires DATETIME NULL DEFAULT NULL, |
| 38 |
max_age INT(11) NULL DEFAULT NULL, |
| 39 |
samesite VARCHAR(10) NULL DEFAULT NULL, |
| 40 |
secure TINYINT(1) NOT NULL DEFAULT 0, |
| 41 |
httponly TINYINT(1) NOT NULL DEFAULT 0, |
| 42 |
raw_name VARCHAR(255) NULL, |
| 43 |
edited TINYINT(1) NULL DEFAULT 0, |
| 44 |
patterns VARCHAR(255) NOT NULL DEFAULT '[]', |
| 45 |
scan_timestamp INT(11) NULL DEFAULT 0 |
| 46 |
) {$charset_collate};"; |
| 47 |
|
| 48 |
dbDelta($sql); |
| 49 |
} |
| 50 |
} |
| 51 |
|
| 52 |
|
| 53 |
|
