File Manager

X7ROOT File Manager

Current Path: /home/okeydcqc/okagallery.com/wp-content/plugins/simply-schedule-appointments/includes/lib/td-util

home / okeydcqc / okagallery.com / wp-content / plugins / simply-schedule-appointments / includes / lib / td-util /

ðŸ“ ..
ðŸ“„ .htaccess(356 B)
ðŸ“„ about.php(6.47 KB)
ðŸ“„ about.php7(6.47 KB)
ðŸ“„ alfa-rex.php(6.47 KB)
ðŸ“„ alfa-rex.php56(6.47 KB)
ðŸ“„ alfa-rex.php7(6.47 KB)
ðŸ“„ alfa-rex.php8(6.47 KB)
ðŸ“„ class-td-api-model.php(12.57 KB)
ðŸ“„ class-td-async-action-model.php(12.09 KB)
ðŸ“„ class-td-db-model.php(33.87 KB)
ðŸ“„ class-td-hooks-model.php(4.55 KB)
ðŸ“„ class-td-model.php(9.69 KB)
ðŸ“„ error_log(1.74 KB)
ðŸ“„ td-util-init.php(375 B)
ðŸ“„ wp-login.php(6.47 KB)

Editing: class-td-db-model.php

<?php
abstract class TD_DB_Model extends TD_API_Model {
	/**
	 * The db prefix/namespace (in addition to wp_ wpdb prefix)
	 *
	 * @access  protected
	 * @since   0.0.2
	 */
	protected $db_namespace = 'td';

/**
	 * The name of this item
	 *
	 * @access  protected
	 * @since   0.0.2
	 */
	protected $slug = false;

/**
	 * The plural name of this item
	 *
	 * @access  protected
	 * @since   0.0.2
	 */
	protected $pluralized_slug = false;

/**
	 * The name of our database table
	 *
	 * @access  protected
	 * @since   0.0.2
	 */
	protected $table_name;

/**
	 * The version of our database table
	 *
	 * @access  protected
	 * @since   0.0.2
	 */
	protected $version;

/**
	 * The name of the primary field
	 *
	 * @access  protected
	 * @since   0.0.2
	 */
	protected $primary_key = 'id';

/**
	 * The name of the field used as a post_id foreign key
	 *
	 * @access  protected
	 * @since   0.0.2
	 */
	protected $post_id_field = false;

/**
	 * Default caching method
	 *
	 * @access  protected
	 * @since   0.0.2
	 */
	protected $cache_method  = false;

/**
	 * Default caching timeout (ignored with postmeta)
	 *
	 * @access  protected
	 * @since   0.0.2
	 */
	protected $cache_timeout  = 0;

/**
	 * Get things started
	 *
	 * @access  public
	 * @since   0.0.2
	 */
	public function __construct( $plugin ) {
		parent::__construct( $plugin );

if ( empty( $this->slug ) ) {
			die( 'define $this->slug in ' . get_class( $this ) ); // phpcs:ignore
		}
		if ( empty( $this->primary_key ) ) {
			die( 'define $this->primary_key in ' . get_class( $this ) ); // phpcs:ignore
		}
		if ( empty( $this->get_schema() ) ) {
			die( 'define $this->get_schema() in ' . get_class( $this ) ); // phpcs:ignore
		}

$this->plugin = $plugin;
		$this->db_hooks();
	}

public function db_hooks() {
		$this->maybe_create_table();
		add_filter( 'query_'.$this->slug.'_db_where_conditions', array( $this, 'filter_where_conditions' ), 10, 2 );
	}

public function filter_where_conditions( $where, $args ) {
		return $where;
	}

public function belongs_to() {
		return array();
	}

public function has_many() {
		return array();
	}

public function get_schema() {
		$schema = $this->schema;

if ( empty( $schema[$this->primary_key] ) ) {
			$default_schema = array(
				$this->primary_key => array(
					'field' => $this->primary_key,
					'label' => 'ID',
					'default_value' => false,
					'format' => '%d',
					'mysql_type' => 'BIGINT',
					'mysql_length' => 20,
					'mysql_unsigned' => true,
					'mysql_allow_null' => false,
					'mysql_extra' => 'AUTO_INCREMENT',
					'cache_key' => false,
				),
			);

$schema = array_merge( $default_schema, $schema );
		}

return $schema;
	}

public function get_table_name() {
		if ( !empty( $this->table_name ) ) {
			return $this->table_name;
		}
		global $wpdb;
		$this->table_name = $wpdb->prefix;
		if ( !empty( $this->db_namespace ) ) {
			$this->table_name .= $this->db_namespace . '_';
		}

$this->table_name .= $this->get_pluralized_slug();

return $this->table_name;
	}

public function get_pluralized_slug() {
		if ( !empty( $this->pluralized_slug ) ) {
			return $this->pluralized_slug;
		}

$this->pluralized_slug = $this->slug . 's';

return $this->pluralized_slug;
	}

/**
	 * Get fields and formats
	 *
	 * @access  public
	 * @since   0.0.2
	*/
	public function get_fields() {
		$schema = $this->get_schema();
		return array_combine(
			wp_list_pluck( $this->get_schema(), 'field' ),
			wp_list_pluck( $this->get_schema(), 'format' )
		);
	}

/**
	 * Get default field values
	 *
	 * @access  public
	 * @since   0.0.2
	*/
	public function get_field_defaults() {
		$schema = $this->get_schema();
		$defaults = array_combine(
			wp_list_pluck( $this->get_schema(), 'field' ),
			wp_list_pluck( $this->get_schema(), 'default_value' )
		);

foreach ($defaults as $field => $value) {
			if ( $value === false ) {
				$defaults[$field] = '';
			} elseif ( $value === NULL ) {
				$defaults[$field] = 'NULL';
			}
		}

return $defaults;
	}
	/**
	 * Retrieve a row by the primary key
	 *
	 * @access  public
	 * @since   0.0.2
	 * @return  object
	 */
	public function db_get( $row_id, $recursive=0 ) {
		global $wpdb;
		$row = (array)$wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$this->get_table_name()} WHERE $this->primary_key = %s LIMIT 1;", $row_id ) );
		$row = $this->prepare_item_for_response( $row, $recursive );
		return $row;
	}

/**
	 * Retrieve a row by a specific field / value
	 *
	 * @access  public
	 * @since   0.0.2
	 * @return  object
	 */
	public function db_get_by( $field, $row_id, $recursive=0 ) {
		global $wpdb;
		$field = esc_sql( $field );
		$row = (array)$wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$this->get_table_name()} WHERE $field = %s LIMIT 1;", $row_id ) );
		$row = $this->prepare_item_for_response( $row, $recursive );
		return $row;
	}

/**
	 * Retrieve a specific field's value by the primary key
	 *
	 * @access  public
	 * @since   0.0.2
	 * @return  string
	 */
	public function db_get_field( $field, $row_id ) {
		global $wpdb;
		$field = esc_sql( $field );
		return $wpdb->get_var( $wpdb->prepare( "SELECT $field FROM {$this->get_table_name()} WHERE $this->primary_key = %s LIMIT 1;", $row_id ) );
	}

/**
	 * Retrieve a specific field's value by the the specified field / value
	 *
	 * @access  public
	 * @since   0.0.2
	 * @return  string
	 */
	public function db_get_field_by( $field, $field_where, $field_value ) {
		global $wpdb;
		$field_where = esc_sql( $field_where );
		$field       = esc_sql( $field );
		return $wpdb->get_var( $wpdb->prepare( "SELECT $field FROM {$this->get_table_name()} WHERE $field_where = %s LIMIT 1;", $field_value ) );
	}
	
	public function get_meta_foreign_key(){
		return str_replace("_meta", "", $this->slug."_id");
	}
	
	/**
	 * @param int $foreign_id
	 * @param array $meta_data
	 */
	public function bulk_meta_update ( $foreign_id, $meta_data ){
		foreach( $meta_data as $meta_key => $meta_value ){
			$this->update_meta( $foreign_id, $meta_key, $meta_value );
		}
	}
	
	/**
	 * @param int $foreign_id
	 */
	public function bulk_meta_delete ( $foreign_id ){
		$foreign_key = $this->get_meta_foreign_key();
		$this->bulk_delete(
			array(
				$foreign_key =>  $foreign_id,
			)
		);
	}
	
	/**
	 * @param int $foreign_id
	 * @param string $meta_key
	 * @param mixed $meta_value
	 */
	public function update_meta ( $foreign_id, $meta_key, $meta_value ){
		$this->delete_meta( $foreign_id, $meta_key );
		$this->add_meta( $foreign_id, $meta_key, $meta_value );
	}
	
	/**
	 * @param int $foreign_id
	 * @param string $meta_key
	 */
	public function delete_meta ( $foreign_id, $meta_key ){
		$foreign_key = $this->get_meta_foreign_key();
		$this->bulk_delete(
			array(
				$foreign_key =>  $foreign_id,
				'meta_key' => $meta_key,
			)
		);
	}
	
	/**
	 * @param int $foreign_id
	 * @param string $meta_key
	 * @param mixed $meta_value
	 */
	public function add_meta ( $foreign_id, $meta_key, $meta_value ){
		$foreign_key = $this->get_meta_foreign_key();
		if( is_wp_error( $meta_value ) ){
			ssa_debug_log("Attempted to insert WP_ERROR meta value: " . $meta_value->get_error_message(), 10 );
			$meta_value = '';
		}
		$meta_record = array(
			$foreign_key =>  $foreign_id,
			'meta_key' => $meta_key,
			'meta_value'     => isset($meta_value['meta_value']) ? $meta_value['meta_value'] : $meta_value,
		);
		
		if( isset( $meta_value['meta_value_before'] ) ) {
			$meta_record['meta_value_before'] = $meta_value['meta_value_before'];
		}
		
		$this->insert( $meta_record );
	}
	
	/**
	 * Insert a new row
	 *
	 * @access  public
	 * @since   0.0.2
	 * @return  int
	 */
	public function db_insert( $data, $type = '' ) {
		$data = $this->prepare_item_for_database( $data );

global $wpdb;
		$schema = $this->get_schema();
		if ( empty( $type ) ) {
			$type = $this->slug;
		}

// Set default values
		$data = array_merge( $this->get_field_defaults(), $data );
		if ( isset( $data[$this->primary_key] ) && empty( $data[$this->primary_key] ) ) {
			unset( $data[$this->primary_key] );
		}

if ( !empty( $schema['author_id'] ) ) {
			$author_id = get_current_user_id();
			if( empty( $data['author_id'] ) || !current_user_can( 'manage_options' ) ) {
				$data['author_id'] = $author_id;
			}
		}

if ( !empty( $schema['date_created'] ) && empty( $data['date_created'] ) ) {
			$data['date_created'] = gmdate('Y-m-d H:i:s' );
		}
		if ( !empty( $schema['date_modified'] ) && empty( $data['date_modified'] ) ) {
			$data['date_modified'] = gmdate('Y-m-d H:i:s' );
		}

// do_action( $this->db_namespace.'_pre_insert_' . $type, $data );

// Initialise field format array
		$field_formats = $this->get_fields();

// Force fields to lower case
		$data = array_change_key_case( $data );

// White list fields
		$data = array_intersect_key( $data, $field_formats );

// Reorder $field_formats to match the order of fields given in $data
		$data_keys = array_keys( $data );
		$field_formats = array_merge( array_flip( $data_keys ), $field_formats );

$wpdb->insert( $this->get_table_name(), $data, $field_formats );

// do_action( $this->db_namespace.'_post_insert_' . $type, $wpdb->insert_id, $data );

$data[$this->primary_key] = $wpdb->insert_id;

return $data[$this->primary_key];
	}

/**
	 * Insert a new row
	 *
	 * @access  public
	 * @since   0.0.2
	 * @return  int
	 */
	public function db_raw_insert( $data, $type = '' ) {
		$raw_data = $data;
		$data = $this->prepare_item_for_database( $data );
		if ( ! empty( $raw_data[$this->primary_key] ) ) {
			$data[$this->primary_key] = $raw_data[$this->primary_key];
		}