File "class.db.functions.php"
Full Path: /home/aiclgcwq/photonindustriespvt.com/wp-content/plugins/duplicator/installer/dup-installer/classes/database/class.db.functions.php
File size: 25.55 KB
MIME-type: text/x-php
Charset: utf-8
<?php
/**
* Database functions
*
* Standard: PSR-2
*
* @package SC\DUPX\DB
* @link http://www.php-fig.org/psr/psr-2/
*/
defined('ABSPATH') || defined('DUPXABSPATH') || exit;
use Duplicator\Installer\Core\Params\Descriptors\ParamDescDatabase;
use Duplicator\Installer\Utils\Log\Log;
use Duplicator\Installer\Core\Params\PrmMng;
use Duplicator\Installer\Core\Params\Descriptors\ParamDescUsers;
use Duplicator\Libs\Snap\SnapDB;
class DUPX_DB_Functions
{
/**
*
* @var self
*/
protected static $instance = null;
/** @var \mysqli connection */
private $dbh = null;
/** @var float */
protected $timeStart = 0;
/**
* current data connection
*
* @var array connection
*/
private $dataConnection = null;
/**
* list of supported engine types
*
* @var array
*/
private $engineData = null;
/**
* supported charset and collation data
*
* @var array
*/
private $charsetData = null;
/**
* default charset in dwtabase connection
*
* @var string
*/
private $defaultCharset = null;
/** @var int */
private $rename_tbl_log = 0;
private function __construct()
{
$this->timeStart = DUPX_U::getMicrotime();
}
/**
*
* @return self
*/
public static function getInstance()
{
if (is_null(self::$instance)) {
self::$instance = new self();
}
return self::$instance;
}
/**
* Returns mysqli handle
*
* @param array|null $customConnection
*
* @return mysqli|null
*/
public function dbConnection($customConnection = null)
{
if (!is_null($this->dbh)) {
return $this->dbh;
}
$paramsManager = PrmMng::getInstance();
if (is_null($customConnection)) {
if (!DUPX_Validation_manager::isValidated()) {
throw new Exception('Installer isn\'t validated');
}
$dbhost = $paramsManager->getValue(PrmMng::PARAM_DB_HOST);
$dbname = $paramsManager->getValue(PrmMng::PARAM_DB_NAME);
$dbuser = $paramsManager->getValue(PrmMng::PARAM_DB_USER);
$dbpass = $paramsManager->getValue(PrmMng::PARAM_DB_PASS);
} else {
$dbhost = $customConnection['dbhost'];
$dbname = $customConnection['dbname'];
$dbuser = $customConnection['dbuser'];
$dbpass = $customConnection['dbpass'];
}
$dbflag = $paramsManager->getValue(PrmMng::PARAM_DB_FLAG);
if ($dbflag === DUPX_DB::DB_CONNECTION_FLAG_NOT_SET) {
$dbh = self::checkFlagsDbConnection($dbhost, $dbuser, $dbpass, $dbname);
$dbflag = $paramsManager->getValue(PrmMng::PARAM_DB_FLAG);
} else {
$dbh = DUPX_DB::connect($dbhost, $dbuser, $dbpass, $dbname, $dbflag);
}
if ($dbh != false) {
$this->dbh = $dbh;
$this->dataConnection = array(
'dbhost' => $dbhost,
'dbname' => $dbname,
'dbuser' => $dbuser,
'dbpass' => $dbpass,
'dbflag' => $dbflag
);
} else {
$dbConnError = (mysqli_connect_error()) ? 'Error: ' . mysqli_connect_error() : 'Unable to Connect';
$msg = "Unable to connect with the following parameters:<br/>"
. "HOST: " . Log::v2str($dbhost) . "\n"
. "DBUSER: " . Log::v2str($dbuser) . "\n"
. "DATABASE: " . Log::v2str($dbname) . "\n"
. "MESSAGE: " . $dbConnError;
Log::error($msg);
}
if (is_null($customConnection)) {
$db_max_time = mysqli_real_escape_string($this->dbh, $GLOBALS['DB_MAX_TIME']);
DUPX_DB::mysqli_query($this->dbh, "SET wait_timeout = " . mysqli_real_escape_string($this->dbh, $db_max_time));
DUPX_DB::setCharset($this->dbh, $paramsManager->getValue(PrmMng::PARAM_DB_CHARSET), $paramsManager->getValue(PrmMng::PARAM_DB_COLLATE));
}
return $this->dbh;
}
/**
* Check flags dbconnection
*
* @param string $dbhost
* @param string $dbuser
* @param string $dbpass
* @param string $dbname
*
* @return bool|mysqli
*/
protected static function checkFlagsDbConnection($dbhost, $dbuser, $dbpass, $dbname = null)
{
$paramsManager = PrmMng::getInstance();
$wpConfigFalgsVal = $paramsManager->getValue(PrmMng::PARAM_WP_CONF_MYSQL_CLIENT_FLAGS);
$isLocalhost = $dbhost == "localhost";
if (($dbh = DUPX_DB::connect($dbhost, $dbuser, $dbpass, $dbname)) != false) {
$dbflag = DUPX_DB::MYSQLI_CLIENT_NO_FLAGS;
$wpConfigFalgsVal['inWpConfig'] = false;
$wpConfigFalgsVal['value'] = array();
} elseif (!$isLocalhost && ($dbh = DUPX_DB::connect($dbhost, $dbuser, $dbpass, $dbname, MYSQLI_CLIENT_SSL)) != false) {
$dbflag = MYSQLI_CLIENT_SSL;
$wpConfigFalgsVal['inWpConfig'] = true;
$wpConfigFalgsVal['value'] = array(MYSQLI_CLIENT_SSL);
} elseif (
!$isLocalhost &&
defined("MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT") &&
// phpcs:ignore PHPCompatibility.Constants.NewConstants.mysqli_client_ssl_dont_verify_server_certFound
($dbh = DUPX_DB::connect($dbhost, $dbuser, $dbpass, $dbname, MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT)) != false
) {
// phpcs:ignore PHPCompatibility.Constants.NewConstants.mysqli_client_ssl_dont_verify_server_certFound
$dbflag = MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT;
$wpConfigFalgsVal['inWpConfig'] = true;
// phpcs:ignore PHPCompatibility.Constants.NewConstants.mysqli_client_ssl_dont_verify_server_certFound
$wpConfigFalgsVal['value'] = array(MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT);
} else {
$dbflag = DUPX_DB::MYSQLI_CLIENT_NO_FLAGS;
}
$paramsManager->setValue(PrmMng::PARAM_DB_FLAG, $dbflag);
$paramsManager->setValue(PrmMng::PARAM_WP_CONF_MYSQL_CLIENT_FLAGS, $wpConfigFalgsVal);
$paramsManager->save();
return $dbh;
}
/**
* close db connection if is open
*/
public function closeDbConnection()
{
if (!is_null($this->dbh)) {
mysqli_close($this->dbh);
$this->dbh = null;
$this->dataConnection = null;
$this->charsetData = null;
$this->defaultCharset = null;
}
}
public function getDefaultCharset()
{
if (is_null($this->defaultCharset)) {
$this->dbConnection();
// SHOW VARIABLES LIKE "character_set_database"
if (($result = DUPX_DB::mysqli_query($this->dbh, "SHOW VARIABLES LIKE 'character_set_database'")) === false) {
throw new Exception('SQL ERROR:' . mysqli_error($this->dbh));
}
if ($result->num_rows != 1) {
throw new Exception('DEFAULT CHARSET NUMBER NOT VALID NUM ' . $result->num_rows);
}
while ($row = $result->fetch_array()) {
$this->defaultCharset = $row[1];
}
$result->free();
}
return $this->defaultCharset;
}
/**
*
* @param string $charset
*
* @return string|bool // false if charset don't exists
*/
public function getDefaultCollateOfCharset($charset)
{
$this->getCharsetAndCollationData();
return isset($this->charsetData[$charset]) ? $this->charsetData[$charset]['defCollation'] : false;
}
/**
* @return array list of supported MySQL engine data\
*/
public function getEngineData()
{
if (is_null($this->engineData)) {
$this->dbConnection();
if (($result = DUPX_DB::mysqli_query($this->dbh, "SHOW ENGINES")) === false) {
throw new Exception('SQL ERROR:' . mysqli_error($this->dbh));
}
$this->engineData = array();
while ($row = $result->fetch_array()) {
if ($row[1] !== "YES" && $row[1] !== "DEFAULT") {
continue;
}
$this->engineData[] = array(
"name" => $row[0],
"isDefault" => $row[1] === "DEFAULT"
);
}
}
return $this->engineData;
}
/**
* @return array list of supported MySQL engine names
*/
public function getSupportedEngineList()
{
return array_map(function ($engine) {
return $engine["name"];
}, $this->getEngineData());
}
/**
* @return string the default MySQL engine of the database
*/
public function getDefaultEngine()
{
foreach ($this->engineData as $engine) {
if ($engine["isDefault"]) {
return $engine["name"];
}
}
return $this->engineData[0]["name"];
}
/**
*
* @return array
*/
public function getCharsetAndCollationData()
{
if (is_null($this->charsetData)) {
$this->dbConnection();
if (($result = DUPX_DB::mysqli_query($this->dbh, "SHOW COLLATION")) === false) {
throw new Exception('SQL ERROR:' . mysqli_error($this->dbh));
}
while ($row = $result->fetch_array()) {
$collation = $row[0];
$charset = $row[1];
$default = filter_var($row[3], FILTER_VALIDATE_BOOLEAN);
$compiled = filter_var($row[4], FILTER_VALIDATE_BOOLEAN);
if (!$compiled) {
continue;
}
if (!isset($this->charsetData[$charset])) {
$this->charsetData[$charset] = array(
'defCollation' => false,
'collations' => array()
);
}
$this->charsetData[$charset]['collations'][] = $collation;
if ($default) {
$this->charsetData[$charset]['defCollation'] = $collation;
}
}
$result->free();
ksort($this->charsetData);
foreach (array_keys($this->charsetData) as $charset) {
sort($this->charsetData[$charset]['collations']);
}
}
return $this->charsetData;
}
/**
*
* @return string[]
*/
public function getCharsetsList()
{
return array_keys($this->getCharsetAndCollationData());
}
/**
*
* @return string[]
*/
public function getCollationsList()
{
$result = array();
foreach ($this->getCharsetAndCollationData() as $charsetInfo) {
$result = array_merge($result, $charsetInfo['collations']);
}
return array_unique($result);
}
public function getRealCharsetByParam()
{
$this->getCharsetAndCollationData();
//$sourceCharset = DUPX_ArchiveConfig::getInstance()->getWpConfigDefineValue('DB_CHARSET', '');
$sourceCharset = PrmMng::getInstance()->getValue(PrmMng::PARAM_DB_CHARSET);
return (array_key_exists($sourceCharset, $this->charsetData) ? $sourceCharset : $this->getDefaultCharset());
}
public function getRealCollateByParam()
{
$this->getCharsetAndCollationData();
$charset = $this->getRealCharsetByParam();
//$sourceCollate = DUPX_ArchiveConfig::getInstance()->getWpConfigDefineValue('DB_COLLATE', '');
$sourceCollate = PrmMng::getInstance()->getValue(PrmMng::PARAM_DB_COLLATE);
return (strlen($sourceCollate) == 0 || !in_array($sourceCollate, $this->charsetData[$charset]['collations'])) ?
$this->getDefaultCollateOfCharset($charset) :
$sourceCollate;
}
/**
*
* @param null|string $prefix
*
* @return string
*/
public static function getOptionsTableName($prefix = null)
{
if (is_null($prefix)) {
$prefix = PrmMng::getInstance()->getValue(PrmMng::PARAM_DB_TABLE_PREFIX);
}
return $prefix . 'options';
}
/**
*
* @param null|string $prefix
*
* @return string
*/
public static function getPostsTableName($prefix = null)
{
if (is_null($prefix)) {
$prefix = PrmMng::getInstance()->getValue(PrmMng::PARAM_DB_TABLE_PREFIX);
}
return $prefix . 'posts';
}
/**
*
* @param null|string $prefix
*
* @return string
*/
public static function getUserTableName($prefix = null)
{
if (is_null($prefix)) {
$prefix = PrmMng::getInstance()->getValue(PrmMng::PARAM_DB_TABLE_PREFIX);
}
return $prefix . 'users';
}
/**
*
* @param null|string $prefix
*
* @return string
*/
public static function getUserMetaTableName($prefix = null)
{
if (is_null($prefix)) {
$prefix = PrmMng::getInstance()->getValue(PrmMng::PARAM_DB_TABLE_PREFIX);
}
return $prefix . 'usermeta';
}
/**
*
* @param null|string $prefix
*
* @return string
*/
public static function getPackagesTableName($prefix = null)
{
if (is_null($prefix)) {
$prefix = PrmMng::getInstance()->getValue(PrmMng::PARAM_DB_TABLE_PREFIX);
}
return $prefix . 'duplicator_packages';
}
/**
*
* @param string $userLogin
*
* @return boolean return true if user login name exists in users table
*/
public function checkIfUserNameExists($userLogin)
{
if (!$this->tablesExist(self::getUserTableName())) {
return false;
}
$query = 'SELECT ID FROM `' . mysqli_real_escape_string($this->dbh, self::getUserTableName()) . '` '
. 'WHERE user_login="' . mysqli_real_escape_string($this->dbh, $userLogin) . '"';
if (($result = DUPX_DB::mysqli_query($this->dbh, $query)) === false) {
throw new Exception('SQL ERROR:' . mysqli_error($this->dbh));
}
return ($result->num_rows > 0);
}
public function userPwdReset($userId, $newPassword)
{
$tableName = mysqli_real_escape_string($this->dbh, self::getUserTableName());
$query = 'UPDATE `' . $tableName . '` '
. 'SET `user_pass` = MD5("' . mysqli_real_escape_string($this->dbh, $newPassword) . '") '
. 'WHERE `' . $tableName . '`.`ID` = ' . $userId;
if (($result = DUPX_DB::mysqli_query($this->dbh, $query)) === false) {
throw new Exception('SQL ERROR:' . mysqli_error($this->dbh));
} else {
return true;
}
}
/**
* return true if all tables passed in list exists
*
* @param string|array $tables
*/
public function tablesExist($tables)
{
$this->dbConnection();
if (is_scalar($tables)) {
$tables = array($tables);
}
$dbName = mysqli_real_escape_string($this->dbh, $this->dataConnection['dbname']);
$dbh = $this->dbh;
$escapedTables = array_map(function ($table) use ($dbh) {
return "'" . mysqli_real_escape_string($dbh, $table) . "'";
}, $tables);
$sql = 'SHOW TABLES FROM `' . $dbName . '` WHERE `Tables_in_' . $dbName . '` IN (' . implode(',', $escapedTables) . ')';
if (($result = DUPX_DB::mysqli_query($this->dbh, $sql)) === false) {
return false;
}
return $result->num_rows === count($tables);
}
/**
* Get table replace names from regex pattern
*
* @param string[] $tableList
* @param string $pattern regex search string
* @param string $replacement regex replace string
*
* @return array [
* [
* 'old' => string
* 'new' => string
* ]
* ]
*/
protected static function getTablesReplaceList($tableList, $pattern, $replacement)
{
$result = array();
if (count($tableList) == 0) {
return $result;
}
sort($tableList);
$newNames = $tableList;
foreach ($tableList as $index => $oldName) {
$newName = substr(preg_replace($pattern, $replacement, $oldName), 0, 64); // Truncate too long table names
$nSuffix = 1;
while (in_array($newName, $newNames)) {
$suffix = '_' . base_convert($nSuffix, 10, 36);
$newName = substr($newName, 0, -strlen($suffix)) . $suffix;
$nSuffix++;
}
$newNames[$index] = $newName;
$result[] = array(
'old' => $oldName,
'new' => $newName
);
}
return $result;
}
/**
*
* @param type $newPrefix
* @param type $options
*/
public function pregReplaceTableName($pattern, $replacement, $options = array())
{
$this->dbConnection();
$options = array_merge(array(
'exclude' => array(), // exclude table list,
'prefixFilter' => false,
'regexFilter' => false, // filter tables with regexp
'notRegexFilter' => false, // filter tables with not regexp
'regexTablesDropFkeys' => false,
'copyTables' => array() // tables that needs to be copied instead of renamed
), $options);
$escapedDbName = mysqli_real_escape_string($this->dbh, PrmMng::getInstance()->getValue(PrmMng::PARAM_DB_NAME));
$tablesIn = 'Tables_in_' . $escapedDbName;
$where = ' WHERE TRUE';
if ($options['prefixFilter'] !== false) {
$where .= ' AND `' . $tablesIn . '` NOT REGEXP "^' . mysqli_real_escape_string($this->dbh, SnapDB::quoteRegex($options['prefixFilter'])) . '.+"';
}
if ($options['regexFilter'] !== false) {
$where .= ' AND `' . $tablesIn . '` REGEXP "' . mysqli_real_escape_string($this->dbh, $options['regexFilter']) . '"';
}
if ($options['notRegexFilter'] !== false) {
$where .= ' AND `' . $tablesIn . '` NOT REGEXP "' . mysqli_real_escape_string($this->dbh, $options['notRegexFilter']) . '"';
}
if (($tablesList = DUPX_DB::queryColumnToArray($this->dbh, 'SHOW TABLES FROM `' . $escapedDbName . '`' . $where)) === false) {
Log::error('SQL ERROR:' . mysqli_error($this->dbh));
}
if (is_array($options['exclude'])) {
$tablesList = array_diff($tablesList, $options['exclude']);
}
$this->rename_tbl_log = 0;
if (count($tablesList) == 0) {
return;
}
$replaceList = self::getTablesReplaceList($tablesList, $pattern, $replacement);
DUPX_DB::mysqli_query($this->dbh, "SET FOREIGN_KEY_CHECKS = 0;");
foreach ($replaceList as $replace) {
$table = $replace['old'];
$newName = $replace['new'];
if (in_array($table, $options['copyTables'])) {
$this->copyTable($table, $newName, true);
} else {
$this->renameTable($table, $newName, true);
}
$this->rename_tbl_log++;
}
if ($options['regexTablesDropFkeys'] !== false) {
Log::info('DROP FOREING KEYS');
$this->dropForeignKeys($options['regexTablesDropFkeys']);
}
DUPX_DB::mysqli_query($this->dbh, "SET FOREIGN_KEY_CHECKS = 1;");
}
/**
*
* @param string $tableNamePatten
*
* @return array
*/
public function getForeinKeysData($tableNamePatten = false)
{
$this->dbConnection();
//SELECT CONSTRAINT_NAME FROM information_schema.table_constraints WHERE `CONSTRAINT_TYPE` = 'FOREIGN KEY AND constraint_schema = 'temp_db_test_1234' AND `TABLE_NAME` = 'renamed''
$escapedDbName = mysqli_real_escape_string($this->dbh, PrmMng::getInstance()->getValue(PrmMng::PARAM_DB_NAME));
$escapePattenr = mysqli_real_escape_string($this->dbh, $tableNamePatten);
$where = " WHERE `CONSTRAINT_TYPE` = 'FOREIGN KEY' AND constraint_schema = '" . $escapedDbName . "'";
if ($tableNamePatten !== false) {
$where .= " AND `TABLE_NAME` REGEXP '" . $escapePattenr . "'";
}
if (($result = DUPX_DB::mysqli_query($this->dbh, "SELECT TABLE_NAME as tableName, CONSTRAINT_NAME as fKeyName FROM information_schema.table_constraints " . $where)) === false) {
Log::error('SQL ERROR:' . mysqli_error($this->dbh));
}
return $result->fetch_all(MYSQLI_ASSOC);
}
/**
*
* @param string $tableNamePatten
*
* @return boolean
*/
public function dropForeignKeys($tableNamePatten = false)
{
foreach ($this->getForeinKeysData($tableNamePatten) as $fKeyData) {
$escapedTableName = mysqli_real_escape_string($this->dbh, $fKeyData['tableName']);
$escapedFKeyName = mysqli_real_escape_string($this->dbh, $fKeyData['fKeyName']);
if (DUPX_DB::mysqli_query($this->dbh, 'ALTER TABLE `' . $escapedTableName . '` DROP CONSTRAINT `' . $escapedFKeyName . '`') === false) {
Log::error('SQL ERROR:' . mysqli_error($this->dbh));
}
}
return true;
}
public function copyTable($existing_name, $new_name, $delete_if_conflict = false)
{
$this->dbConnection();
return DUPX_DB::copyTable($this->dbh, $existing_name, $new_name, $delete_if_conflict);
}
public function renameTable($existing_name, $new_name, $delete_if_conflict = false)
{
$this->dbConnection();
return DUPX_DB::renameTable($this->dbh, $existing_name, $new_name, $delete_if_conflict);
}
public function dropTable($name)
{
$this->dbConnection();
return DUPX_DB::dropTable($this->dbh, $name);
}
/**
*
* @param string $prefix
*
* @return boolean
*/
public function getAdminUsers($prefix)
{
$escapedPrefix = mysqli_real_escape_string($this->dbh, $prefix);
$userTable = mysqli_real_escape_string($this->dbh, $this->getUserTableName($prefix));
$userMetaTable = mysqli_real_escape_string($this->dbh, $this->getUserMetaTableName($prefix));
$sql = 'SELECT `' . $userTable . '`.`id` AS id, `' . $userTable . '`.`user_login` AS user_login FROM `' . $userTable . '` '
. 'INNER JOIN `' . $userMetaTable . '` ON ( `' . $userTable . '`.`id` = `' . $userMetaTable . '`.`user_id` ) '
. 'WHERE `' . $userMetaTable . '`.`meta_key` = "' . $escapedPrefix . 'capabilities" AND `' . $userMetaTable . '`.`meta_value` LIKE "%\"administrator\"%" '
. 'ORDER BY user_login ASC';
if (($queryResult = DUPX_DB::mysqli_query($this->dbh, $sql)) === false) {
return false;
}
$result = array();
while ($row = $queryResult->fetch_assoc()) {
$result[] = $row;
}
return $result;
}
/**
* Returns the Duplicator version if it exists, otherwise false
*
* @param $prefix
*
* @return false|string Duplicator version
*/
public function getDuplicatorVersion($prefix)
{
$optionsTable = self::getOptionsTableName($prefix);
$sql = "SELECT `option_value` FROM `{$optionsTable}` WHERE `option_name` = 'duplicator_version_plugin'";
if (($queryResult = DUPX_DB::mysqli_query($this->dbh, $sql)) === false || $queryResult->num_rows === 0) {
return false;
}
$row = $queryResult->fetch_row();
return $row[0];
}
/**
* Return ustat identifier
*
* @param string $prefix table prefix
*
* @return string ustat identifier
*/
public function getUstatIdentifier($prefix)
{
$optionsTable = self::getOptionsTableName($prefix);
$sql = "SELECT `option_value` FROM `{$optionsTable}` WHERE `option_name` = 'duplicator_plugin_data_stats'";
if (($queryResult = DUPX_DB::mysqli_query($this->dbh, $sql)) === false || $queryResult->num_rows === 0) {
return '';
}
$dataStat = $queryResult->fetch_row();
$dataStat = json_decode($dataStat[0], true);
return isset($dataStat['identifier']) ? $dataStat['identifier'] : '';
}
/**
*
* @param int $userId
* @param null|string $prefix
*
* @return boolean
*/
public function updatePostsAuthor($userId, $prefix = null)
{
$this->dbConnection();
//UPDATE `i5tr4_posts` SET `post_author` = 7 WHERE TRUE
$postsTable = mysqli_real_escape_string($this->dbh, $this->getPostsTableName($prefix));
$sql = 'UPDATE `' . $postsTable . '` SET `post_author` = ' . ((int) $userId) . ' WHERE TRUE';
Log::info('EXECUTE QUERY ' . $sql);
if (($result = DUPX_DB::mysqli_query($this->dbh, $sql)) === false) {
return false;
}
return true;
}
/**
*
* @return string[] Array of tables to be excluded
*/
public static function getExcludedTables()
{
$excludedTables = array();
if (ParamDescUsers::getUsersMode() !== ParamDescUsers::USER_MODE_OVERWRITE) {
$overwriteData = PrmMng::getInstance()->getValue(PrmMng::PARAM_OVERWRITE_SITE_DATA);
$excludedTables[] = self::getUserTableName($overwriteData['table_prefix']);
$excludedTables[] = self::getUserMetaTableName($overwriteData['table_prefix']);
}
return $excludedTables;
}
}