| Server IP : 184.94.213.167 / Your IP :
216.73.216.174 [
Web Server : LiteSpeed System : Linux premium282.web-hosting.com 4.18.0-553.45.1.lve.el8.x86_64 #1 SMP Wed Mar 26 12:08:09 UTC 2025 x86_64 User : whatdo54321 ( 1549) PHP Version : 8.4.14 Disable Function : NONE Domains : 1 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/whatdo54321/y1.bedfun.store/wp-content/plugins/jet-reviews/includes/db/ |
Upload File : |
<?php
namespace Jet_Reviews\DB;
/**
* Database manager class
*/
// If this file is called directly, abort.
if ( ! defined( 'WPINC' ) ) {
die;
}
/**
* Define Base DB class
*/
class Manager {
/**
* A reference to an instance of this class.
*
* @since 1.0.0
* @var object
*/
private static $instance = null;
/**
* Returns the instance.
*
* @since 1.0.0
* @return object
*/
public static function get_instance() {
// If the single instance hasn't been set, set it now.
if ( null == self::$instance ) {
self::$instance = new self;
}
return self::$instance;
}
/**
* Constructor for the class
*/
public function __construct() {
self::init_db_required();
}
/**
* [wpdb description]
* @return [type] [description]
*/
public function wpdb() {
global $wpdb;
return $wpdb;
}
/**
* Return table name by key
*
* @param string $table table key.
* @return array|string
*/
public static function tables( $table = null, $return = 'all' ) {
global $wpdb;
$prefix = 'jet_';
$tables = array(
'reviews' => array(
'name' => $wpdb->prefix . $prefix . 'reviews',
'export_name' => $prefix . 'reviews',
'query' => "
id bigint(20) NOT NULL AUTO_INCREMENT,
post_id bigint(20),
post_type text,
author varchar(255),
date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
title text,
content longtext,
type_slug text,
rating_data longtext,
rating int,
likes bigint(20) DEFAULT 0 NOT NULL,
dislikes bigint(20) DEFAULT 0 NOT NULL,
approved varchar(20) DEFAULT 1 NOT NULL,
pinned varchar(20) DEFAULT 0 NOT NULL,
PRIMARY KEY (id)
",
),
'review_meta' => array(
'name' => $wpdb->prefix . $prefix . 'review_meta',
'export_name' => $prefix . 'review_meta',
'query' => "
id bigint(20) NOT NULL AUTO_INCREMENT,
review_id bigint(20),
meta_key varchar(255),
meta_value longtext,
PRIMARY KEY (id)
",
),
'review_types' => array(
'name' => $wpdb->prefix . $prefix . 'review_types',
'export_name' => $prefix . 'review_types',
'query' => "
id bigint(20) NOT NULL AUTO_INCREMENT,
name text,
slug varchar(255),
description longtext DEFAULT '' NOT NULL,
source varchar(255) DEFAULT 'default' NOT NULL,
fields longtext DEFAULT '' NOT NULL,
meta_data longtext DEFAULT '' NOT NULL,
PRIMARY KEY (id)
",
),
'review_comments' => array(
'name' => $wpdb->prefix . $prefix . 'review_comments',
'export_name' => $prefix . 'review_comments',
'query' => "
id bigint(20) NOT NULL AUTO_INCREMENT,
post_id bigint(20),
parent_id bigint(20),
review_id bigint(20),
author varchar(255),
content longtext,
date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
likes bigint(20) DEFAULT 0 NOT NULL,
dislikes bigint(20) DEFAULT 0 NOT NULL,
approved varchar(20),
PRIMARY KEY (id)
",
),
'review_guests' => array(
'name' => $wpdb->prefix . $prefix . 'review_guests',
'export_name' => $prefix . 'review_guests',
'query' => "
id bigint(20) NOT NULL AUTO_INCREMENT,
guest_id varchar(255),
name varchar(255),
mail varchar(255),
phone varchar(255),
meta_data longtext DEFAULT '' NOT NULL,
PRIMARY KEY (id)
",
)
);
if ( ! $table && 'all' === $return ) {
return $tables;
}
switch ( $return ) {
case 'all':
return isset( $tables[ $table ] ) ? $tables[ $table ] : false;
case 'name':
return isset( $tables[ $table ] ) ? $tables[ $table ]['name'] : false;
case 'query':
return isset( $tables[ $table ] ) ? $tables[ $table ]['query'] : false;
}
return false;
}
/**
* [init_db_required description]
* @return [type] [description]
*/
public static function init_db_required() {
self::create_all_tables();
self::add_default_data();
self::maybe_modify_tables();
}
/**
* Create all tables on activation
*
* @return [type] [description]
*/
public static function create_all_tables() {
global $wpdb;
$charset_collate = $wpdb->get_charset_collate();
foreach ( self::tables() as $table ) {
$table_name = $table['name'];
$table_query = $table['query'];
if ( $table_name !== $wpdb->get_var( "SHOW TABLES LIKE '$table_name'" ) ) {
$sql = "CREATE TABLE $table_name (
$table_query
) $charset_collate;";
require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
dbDelta( $sql );
}
}
}
/**
* [maybe_modify_tables description]
* @return [type] [description]
*/
public static function maybe_modify_tables() {
global $wpdb;
// Modify reviews table
$reviews_table_name = self::tables( 'reviews', 'name' );
$column_exist = self::table_column_exists( $reviews_table_name, 'source' );
if ( ! $column_exist ) {
$wpdb->query( "ALTER TABLE $reviews_table_name ADD source VARCHAR(255) NOT NULL DEFAULT 'post' AFTER id" );
}
$wpdb->query( "ALTER TABLE $reviews_table_name MODIFY COLUMN author VARCHAR(255)" );
// Modify review_comments table
$review_comments_table_name = self::tables( 'review_comments', 'name' );
$column_exist = self::table_column_exists( $review_comments_table_name, 'source' );
if ( ! $column_exist ) {
$wpdb->query( "ALTER TABLE $review_comments_table_name ADD source VARCHAR(255) NOT NULL DEFAULT 'post' AFTER id" );
}
$wpdb->query( "ALTER TABLE $review_comments_table_name MODIFY COLUMN author VARCHAR(255)" );
}
/**
* @param $table_name
* @param $column_name
*
* @return bool
*/
public static function table_column_exists( $table_name, $column_name ) {
global $wpdb;
$column = $wpdb->get_results( $wpdb->prepare(
"SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = %s AND TABLE_NAME = %s AND COLUMN_NAME = %s ",
DB_NAME, $table_name, $column_name
) );
if ( ! empty( $column ) ) {
return true;
}
return false;
}
/**
* [add_dafault_data description]
*/
public static function add_default_data() {
global $wpdb;
$prefix = 'jet_';
$query = $wpdb->replace( $wpdb->prefix . $prefix . 'review_types', array(
'id' => 1,
'name' => 'Default',
'slug' => 'default',
'description' => '',
'source' => 'default',
'fields' => maybe_serialize( array(
array(
'label' => 'Rating',
'step' => 1,
'max' => 5,
)
) ),
'meta_data' => '',
) );
}
/**
* Check if table is exists
*
* @param string $table Table name.
* @return boolean
*/
public function is_table_exists( $table = null ) {
global $wpdb;
$table_name = $this->tables( $table, 'name' );
if ( ! $table_name ) {
return false;
}
return ( $table_name === $wpdb->get_var( "SHOW TABLES LIKE '$table_name'" ) );
}
}