| Server IP : 103.48.194.25 / Your IP : 216.73.216.74 Web Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.33 System : Linux VMHostDefault 3.10.0-1160.42.2.el7.x86_64 #1 SMP Tue Sep 7 14:49:57 UTC 2021 x86_64 User : sieuthimay ( 1016) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/sieuthimayasia.com/public_html/wp-content/plugins/wp-smtp/inc/Logger/ |
Upload File : |
<?php
namespace WPSMTP\Logger;
class Table {
public static function get_name(): string {
global $wpdb;
return $wpdb->prefix . 'wpsmtp_logs';
}
public static function install(): void {
global $wpdb;
$table_name = self::get_name();
$collate = $wpdb->get_charset_collate();
$sql = "CREATE TABLE `{$table_name}` (
`mail_id` INT NOT NULL AUTO_INCREMENT,
`connection_id` VARCHAR(32) NULL,
`timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`to` VARCHAR(200) NOT NULL DEFAULT '0',
`from_email` VARCHAR(200) NOT NULL DEFAULT '',
`from_name` VARCHAR(200) NOT NULL DEFAULT '',
`subject` VARCHAR(200) NOT NULL DEFAULT '0',
`message` TEXT NULL,
`headers` TEXT NULL,
`content_type` VARCHAR(32) NOT NULL DEFAULT 'text/plain',
`error` TEXT NULL,
PRIMARY KEY (`mail_id`)
) {$collate};";
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
dbDelta( $sql );
}
}