Edit File by line

<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* Subscribers DB Handler

[2] Fix | Delete

[3] Fix | Delete

* @package PUM

[4] Fix | Delete

[5] Fix | Delete

[6] Fix | Delete

// Exit if accessed directly

[7] Fix | Delete

[8] Fix | Delete

/*******************************************************************************

[9] Fix | Delete

[10] Fix | Delete

******************************************************************************/

[11] Fix | Delete

[12] Fix | Delete

if ( ! defined( 'ABSPATH' ) ) {

[13] Fix | Delete

exit;

[14] Fix | Delete

}

[15] Fix | Delete

[16] Fix | Delete

/**

[17] Fix | Delete

* PUM_Subscribers Class

[18] Fix | Delete

[19] Fix | Delete

class PUM_DB_Subscribers extends PUM_Abstract_Database {

[20] Fix | Delete

[21] Fix | Delete

/**

[22] Fix | Delete

* The name of our database table

[23] Fix | Delete

[24] Fix | Delete

public $table_name = 'pum_subscribers';

[25] Fix | Delete

[26] Fix | Delete

/**

[27] Fix | Delete

* The version of our database table

[28] Fix | Delete

[29] Fix | Delete

public $version = 20200917;

[30] Fix | Delete

[31] Fix | Delete

/**

[32] Fix | Delete

* The name of the primary column

[33] Fix | Delete

[34] Fix | Delete

public $primary_key = 'ID';

[35] Fix | Delete

[36] Fix | Delete

/**

[37] Fix | Delete

* Get columns and formats

[38] Fix | Delete

[39] Fix | Delete

public function get_columns() {

[40] Fix | Delete

return [

[41] Fix | Delete

'ID' => '%d',

[42] Fix | Delete

'uuid' => '%s',

[43] Fix | Delete

'popup_id' => '%d',

[44] Fix | Delete

'email_hash' => '%s',

[45] Fix | Delete

'email' => '%s',

[46] Fix | Delete

'name' => '%s',

[47] Fix | Delete

'fname' => '%s',

[48] Fix | Delete

'lname' => '%s',

[49] Fix | Delete

'user_id' => '%d',

[50] Fix | Delete

'consent_args' => '%s',

[51] Fix | Delete

'consent' => '%s',

[52] Fix | Delete

'created' => '%s',

[53] Fix | Delete

];

[54] Fix | Delete

}

[55] Fix | Delete

[56] Fix | Delete

/**

[57] Fix | Delete

* Get default column values

[58] Fix | Delete

[59] Fix | Delete

public function get_column_defaults() {

[60] Fix | Delete

return [

[61] Fix | Delete

'uuid' => '',

[62] Fix | Delete

'popup_id' => 0,

[63] Fix | Delete

'email_hash' => '',

[64] Fix | Delete

'email' => '',

[65] Fix | Delete

'name' => '',

[66] Fix | Delete

'fname' => '',

[67] Fix | Delete

'lname' => '',

[68] Fix | Delete

'user_id' => 0,

[69] Fix | Delete

'consent_args' => '',

[70] Fix | Delete

'consent' => 'no',

[71] Fix | Delete

'created' => current_time( 'mysql', 0 ),

[72] Fix | Delete

];

[73] Fix | Delete

[74] Fix | Delete

}

[75] Fix | Delete

[76] Fix | Delete

/**

[77] Fix | Delete

* Create the table

[78] Fix | Delete

[79] Fix | Delete

public function create_table() {

[80] Fix | Delete

[81] Fix | Delete

global $wpdb;

[82] Fix | Delete

[83] Fix | Delete

if ( ! function_exists( 'dbDelta' ) ) {

[84] Fix | Delete

require_once ABSPATH . 'wp-admin/includes/upgrade.php';

[85] Fix | Delete

}

[86] Fix | Delete

[87] Fix | Delete

$charset_collate = $wpdb->get_charset_collate();

[88] Fix | Delete

[89] Fix | Delete

/**

[90] Fix | Delete

* - [x] You must put each field on its own line in your SQL statement.

[91] Fix | Delete

* - [x] You must have two spaces between the words PRIMARY KEY and the definition of your primary key.

[92] Fix | Delete

* - [x] You must use the key word KEY rather than its synonym INDEX and you must include at least one KEY.

[93] Fix | Delete

* - [x] KEY must be followed by a SINGLE SPACE then the key name then a space then open parenthesis with the field name then a closed parenthesis.

[94] Fix | Delete

* - [x] You must not use any apostrophes or backticks around field names.

[95] Fix | Delete

* - [x] Field types must be all lowercase.

[96] Fix | Delete

* - [x] SQL keywords, like CREATE TABLE and UPDATE, must be uppercase.

[97] Fix | Delete

* - [x] You must specify the length of all fields that accept a length parameter. int(11), for example.

[98] Fix | Delete

[99] Fix | Delete

$sql = 'CREATE TABLE ' . $this->table_name() . " (

[100] Fix | Delete

ID bigint(20) NOT NULL AUTO_INCREMENT,

[101] Fix | Delete

email_hash varchar(32) NOT NULL,

[102] Fix | Delete

popup_id bigint(20) NOT NULL,

[103] Fix | Delete

user_id bigint(20) NOT NULL,

[104] Fix | Delete

email varchar(191) NOT NULL,

[105] Fix | Delete

name varchar(255) NOT NULL,

[106] Fix | Delete

fname varchar(255) NOT NULL,

[107] Fix | Delete

lname varchar(255) NOT NULL,

[108] Fix | Delete

uuid varchar(255) NOT NULL,

[109] Fix | Delete

consent varchar(255) NOT NULL,

[110] Fix | Delete

consent_args longtext NOT NULL,

[111] Fix | Delete

created datetime NOT NULL,

[112] Fix | Delete

PRIMARY KEY (ID),

[113] Fix | Delete

KEY email (email),

[114] Fix | Delete

KEY user_id (user_id),

[115] Fix | Delete

KEY popup_id (popup_id),

[116] Fix | Delete

KEY email_hash (email_hash)

[117] Fix | Delete

) $charset_collate;";

[118] Fix | Delete

[119] Fix | Delete

$results = dbDelta( $sql );

[120] Fix | Delete

[121] Fix | Delete

// Strip prefix to ensure it doesn't leak unintentionally.

[122] Fix | Delete

$results = str_replace( $wpdb->prefix, '', implode( ',', $results ) );

[123] Fix | Delete

[124] Fix | Delete

pum_log_message( 'Subscriber table results: ' . $results );

[125] Fix | Delete

[126] Fix | Delete

$previous_error = $wpdb->last_error; // The show tables query will erase the last error. So, record it now in case we need it.

[127] Fix | Delete

if ( $wpdb->get_var( "SHOW TABLES LIKE '{$this->table_name()}'" ) !== $this->table_name() ) {

[128] Fix | Delete

pum_log_message( "Subscriber table exists check failed! Last error from wpdb: " . str_replace( $wpdb->prefix, '', $previous_error ) );

[129] Fix | Delete

}

[130] Fix | Delete

[131] Fix | Delete

update_option( $this->table_name . '_db_version', $this->version );

[132] Fix | Delete

}

[133] Fix | Delete

[134] Fix | Delete

public function get_by_email( $email = '' ) {

[135] Fix | Delete

[136] Fix | Delete

}

[137] Fix | Delete

[138] Fix | Delete

[139] Fix | Delete

public function query( $args = [], $return_type = 'OBJECT' ) {

[140] Fix | Delete

global $wpdb;

[141] Fix | Delete

[142] Fix | Delete

$args = wp_parse_args(

[143] Fix | Delete

$args,

[144] Fix | Delete

[

[145] Fix | Delete

'fields' => '*',

[146] Fix | Delete

'page' => null,

[147] Fix | Delete

'limit' => null,

[148] Fix | Delete

'offset' => null,

[149] Fix | Delete

's' => null,

[150] Fix | Delete

'orderby' => null,

[151] Fix | Delete

'order' => null,

[152] Fix | Delete

]

[153] Fix | Delete

);

[154] Fix | Delete

[155] Fix | Delete

$columns = $this->get_columns();

[156] Fix | Delete

[157] Fix | Delete

$fields = $args['fields'];

[158] Fix | Delete

[159] Fix | Delete

if ( '*' === $fields ) {

[160] Fix | Delete

$fields = array_keys( $columns );

[161] Fix | Delete

} else {

[162] Fix | Delete

$fields = explode( ',', $args['fields'] );

[163] Fix | Delete

$fields = array_map( 'trim', $fields );

[164] Fix | Delete

$fields = array_map( 'sanitize_text_field', $fields );

[165] Fix | Delete

}

[166] Fix | Delete

[167] Fix | Delete

$select_fields = implode( '`, `', $fields );

[168] Fix | Delete

[169] Fix | Delete

// Begin building query.

[170] Fix | Delete

$query = "SELECT `$select_fields` FROM {$this->table_name()}";

[171] Fix | Delete

[172] Fix | Delete

// Set up $values array for wpdb::prepare

[173] Fix | Delete

$values = [];

[174] Fix | Delete

[175] Fix | Delete

// Define an empty WHERE clause to start from.

[176] Fix | Delete

$where = 'WHERE 1=1';

[177] Fix | Delete

[178] Fix | Delete

// Build search query.

[179] Fix | Delete

if ( $args['s'] && ! empty( $args['s'] ) ) {

[180] Fix | Delete

[181] Fix | Delete

$search = wp_unslash( trim( $args['s'] ) );

[182] Fix | Delete

[183] Fix | Delete

$search_where = [];

[184] Fix | Delete

[185] Fix | Delete

foreach ( $columns as $key => $type ) {

[186] Fix | Delete

if ( in_array( $key, $fields ) ) {

[187] Fix | Delete

if ( '%s' === $type || ( '%d' === $type && is_numeric( $search ) ) ) {

[188] Fix | Delete

$values[] = '%' . $wpdb->esc_like( $search ) . '%';

[189] Fix | Delete

$search_where[] = "`$key` LIKE '%s'";

[190] Fix | Delete

}

[191] Fix | Delete

}

[192] Fix | Delete

}

[193] Fix | Delete

[194] Fix | Delete

if ( ! empty( $search_where ) ) {

[195] Fix | Delete

$where .= ' AND (' . join( ' OR ', $search_where ) . ')';

[196] Fix | Delete

}

[197] Fix | Delete

}

[198] Fix | Delete

[199] Fix | Delete

$query .= " $where";

[200] Fix | Delete

[201] Fix | Delete

if ( ! empty( $args['orderby'] ) ) {

[202] Fix | Delete

$query .= ' ORDER BY %s';

[203] Fix | Delete

$values[] = wp_unslash( trim( $args['orderby'] ) );

[204] Fix | Delete

[205] Fix | Delete

switch ( $args['order'] ) {

[206] Fix | Delete

case 'asc':

[207] Fix | Delete

case 'ASC':

[208] Fix | Delete

$query .= ' ASC';

[209] Fix | Delete

break;

[210] Fix | Delete

case 'desc':

[211] Fix | Delete

case 'DESC':

[212] Fix | Delete

default:

[213] Fix | Delete

$query .= ' DESC';

[214] Fix | Delete

break;

[215] Fix | Delete

}

[216] Fix | Delete

}

[217] Fix | Delete

[218] Fix | Delete

if ( ! empty( $args['limit'] ) ) {

[219] Fix | Delete

$query .= ' LIMIT %d';

[220] Fix | Delete

$values[] = absint( $args['limit'] );

[221] Fix | Delete

}

[222] Fix | Delete

[223] Fix | Delete

// Pagination.

[224] Fix | Delete

if ( $args['page'] >= 1 ) {

[225] Fix | Delete

$args['offset'] = ( $args['page'] * $args['limit'] ) - $args['limit'];

[226] Fix | Delete

}

[227] Fix | Delete

[228] Fix | Delete

if ( ! empty( $args['offset'] ) ) {

[229] Fix | Delete

$query .= ' OFFSET %d';

[230] Fix | Delete

$values[] = absint( $args['offset'] );

[231] Fix | Delete

}

[232] Fix | Delete

[233] Fix | Delete

if ( strpos( $query, '%s' ) || strpos( $query, '%d' ) ) {

[234] Fix | Delete

$query = $wpdb->prepare( $query, $values );

[235] Fix | Delete

}

[236] Fix | Delete

[237] Fix | Delete

return $wpdb->get_results( $query, $return_type );

[238] Fix | Delete

}

[239] Fix | Delete

[240] Fix | Delete

/**

[241] Fix | Delete

* @param $args

[242] Fix | Delete

[243] Fix | Delete

* @return int

[244] Fix | Delete

[245] Fix | Delete

public function total_rows( $args ) {

[246] Fix | Delete

$args['limit'] = null;

[247] Fix | Delete

$args['offset'] = null;

[248] Fix | Delete

$args['page'] = null;

[249] Fix | Delete

[250] Fix | Delete

$results = $this->query( $args );

[251] Fix | Delete

[252] Fix | Delete

return $results ? count( $results ) : 0;

[253] Fix | Delete

}

[254] Fix | Delete

}

[255] Fix | Delete

[256] Fix | Delete