Sets the table prefix for the WordPress tables.
| public set_prefix ( string $prefix, boolean $set_table_names = true ) : string | WP_Error | ||
| $prefix | string | Alphanumeric name for the new prefix. |
| $set_table_names | boolean | Optional. Whether the table names, e.g. wpdb::$posts, should be updated or not. |
| return | string | WP_Error | Old prefix or WP_Error on error |
private static function staticInitialization()
{
self::$testConfig = TestConfig::createDefaultConfig();
self::$wpAutomation = new WpAutomation(self::$testConfig->testSite, self::$testConfig->wpCliVersion);
$yamlDir = self::$wpAutomation->getPluginsDir() . '/versionpress/.versionpress';
$schemaFile = $yamlDir . '/schema.yml';
$shortcodeFile = $yamlDir . '/shortcodes.yml';
/** @var $wp_db_version */
require self::$wpAutomation->getAbspath() . '/wp-includes/version.php';
if (!function_exists('get_shortcode_regex')) {
require_once self::$wpAutomation->getAbspath() . '/wp-includes/shortcodes.php';
}
self::$schemaInfo = new DbSchemaInfo([$schemaFile], self::$testConfig->testSite->dbTablePrefix, $wp_db_version);
$rawTaxonomies = self::$wpAutomation->runWpCliCommand('taxonomy', 'list', ['format' => 'json', 'fields' => 'name']);
$taxonomies = array_column(json_decode($rawTaxonomies, true), 'name');
$dbHost = self::$testConfig->testSite->dbHost;
$dbUser = self::$testConfig->testSite->dbUser;
$dbPassword = self::$testConfig->testSite->dbPassword;
$dbName = self::$testConfig->testSite->dbName;
$dbPrefix = self::$testConfig->testSite->dbTablePrefix;
self::$database = new \mysqli($dbHost, $dbUser, $dbPassword, $dbName);
self::$wpdb = new \wpdb($dbUser, $dbPassword, $dbName, $dbHost);
self::$wpdb->set_prefix($dbPrefix);
self::$vp_database = new Database(self::$wpdb);
$shortcodesInfo = new ShortcodesInfo([$shortcodeFile]);
self::$vpidRepository = new VpidRepository(self::$vp_database, self::$schemaInfo);
self::$shortcodesReplacer = new ShortcodesReplacer($shortcodesInfo, self::$vpidRepository);
$vpdbPath = self::$wpAutomation->getVpdbDir();
$tableSchemaRepository = new TableSchemaStorage(self::$vp_database, $vpdbPath . '/.schema');
self::$storageFactory = new StorageFactory($vpdbPath, self::$schemaInfo, self::$vp_database, $taxonomies, null, $tableSchemaRepository);
require self::$wpAutomation->getPluginsDir() . '/versionpress/.versionpress/hooks.php';
self::defineGlobalVariables();
}
public function set_prefix($prefix, $set_table_names = true)
{
if (function_exists('currheap') && false !== currheap()) {
$alt_db_prefix = 'tmp_' . currheap() . '_';
$prefix = $prefix . $alt_db_prefix;
// wp_tmp_{_alt_heap}_
}
// set up the prefix globally and set up all the tables
parent::set_prefix($prefix, $set_table_names);
if (function_exists('currheap') && false !== currheap()) {
// bail out early if wordpress isn't installed
// check if siteurl is available
$siteurl = $this->get_var("SELECT option_value FROM {$this->options} WHERE option_name='siteurl'");
header('X-Siteurl:' . $this->options);
if (null === $siteurl) {
// it's not, let's bail out...
// clear the alt_heap cookie
setcookie('_alt_heap', '', 0, '/');
// reload the page
// Note: wp_redirect isn't set yet, so we do it manually
$request_uri = $_SERVER['REQUEST_URI'];
header('Location:' . $request_uri);
http_response_code(302);
exit;
}
}
}
function __construct($parent)
{
global $cache_db, $wpdb, $table_prefix;
$this->advance_cache_tpl = plugin_dir_path(dirname(__FILE__)) . 'advanced_cache_tpl/advanced-cache.tpl';
$this->regex_include_tpl = plugin_dir_path(dirname(__FILE__)) . 'advanced_cache_tpl/regex_include.tpl';
$this->parent = $parent;
if (defined('CACHE_DB_NAME') && defined('CACHE_DB_USER') && defined('CACHE_DB_PASSWORD') && defined('CACHE_DB_HOST')) {
$cache_db = new wpdb(CACHE_DB_USER, CACHE_DB_PASSWORD, CACHE_DB_NAME, CACHE_DB_HOST);
$cache_db->set_prefix($table_prefix);
} else {
$cache_db = $wpdb;
}
if (is_admin()) {
add_action('admin_menu', array($this, 'add_setting_menu'));
add_action('load-wp-sitemanager_page_wp-sitemanager-cache', array($this, 'update_cache_setting'));
// add_action( 'theme_switcher/device_updated' , array( $this, 'clear_all_cache' ) );
add_action('theme_switcher/device_updated', array($this, 'generate_advanced_cache_file'));
// add_action( 'theme_switcher/device_group_updated' , array( $this, 'clear_all_cache' ) );
add_action('theme_switcher/device_group_updated', array($this, 'generate_advanced_cache_file'));
add_action('transition_post_status', array($this, 'post_publish_clear_cache'), 10, 3);
// add_action( 'delete_term' , array( $this, 'clear_all_cache' ) );
// add_action( 'edited_term' , array( $this, 'clear_all_cache' ) );
// add_action( 'deleted_user' , array( $this, 'clear_all_cache' ) );
// add_action( 'profile_update' , array( $this, 'clear_all_cache' ) );
} else {
add_action('init', array($this, 'buffer_start'));
// add_action( 'template_redirect' , array( $this, 'check_vars' ) );
}
add_action('init', array($this, 'check_installed'));
// add_action( 'transition_comment_status' , array( $this, 'transition_comment_status' ), 10, 3 );
// add_action( 'comment_post' , array( $this, 'new_comment' ), 10, 2 );
}
/**
* Creates a connection and returns it
* @return Instance of WPDB
*/
private function createConnection()
{
if (!empty($this->connectionConfig)) {
//TO DO: Use the provided connection config
$connectionConfig = $this->connectionConfig;
$password = $this->decryptString($connectionConfig['password']);
$newWpdb = new wpdb($connectionConfig['user'], $password, $connectionConfig['name'], $connectionConfig['hostname']);
$newWpdb->set_prefix($connectionConfig['base_prefix']);
return $newWpdb;
} else {
global $wpdb;
return $wpdb;
}
}
public function prepare_deleteOrphanedMenuItems()
{
$dbHost = self::$testConfig->testSite->dbHost;
$dbUser = self::$testConfig->testSite->dbUser;
$dbPassword = self::$testConfig->testSite->dbPassword;
$dbName = self::$testConfig->testSite->dbName;
$wpdb = new \wpdb($dbUser, $dbPassword, $dbName, $dbHost);
$wpdb->set_prefix(self::$testConfig->testSite->dbTablePrefix);
$deleteOrphanedFilesSeconds = Reverter::DELETE_ORPHANED_POSTS_SECONDS;
$database = new Database($wpdb);
$database->query($wpdb->prepare("UPDATE {$database->postmeta} SET meta_value = meta_value - {$deleteOrphanedFilesSeconds} " . "WHERE meta_key='_menu_item_orphaned' ORDER BY meta_id DESC LIMIT 1", []));
$pluginsDir = self::$wpAutomation->getPluginsDir();
$updateConfigArgs = ['VERSIONPRESS_GUI', 'html', 'require' => $pluginsDir . '/versionpress/src/Cli/vp-internal.php'];
self::$wpAutomation->runWpCliCommand('vp-internal', 'update-config', $updateConfigArgs);
}
<?php
//store global post object to retrieve at end
global $post;
$post_bu = $post;
// db vars defined in wp-config
// create a new wpdb object with external db connection
$gcmaz_wpdb = new wpdb(DB_USER_SRCH, DB_PASSWORD_SRCH, DB_NAME_SRCH, DB_HOST_SRCH);
//set table names prefix
$gcmaz_wpdb->set_prefix(DB_SRCH_PREFIX);
//show errors
//echo ("<h1>SHOW DB ERRORS ON</h1>");
//$wpdb->show_errors();
//$gcmaz_wpdb->show_errors();
/*********************************
* INITIALIZE VARS
********************************/
// since 2 queries, possible total number is 2x this
$rows_to_return = 100;
// DEFINE OUR RESULTS PER PAGE FOR PAGINATION
$results_per_page = 12;
// STATION RELATED VARS
$station_name = "103.7 The Eagle";
$pages_to_ignore_gcmaz = array(1882, 1881, 1880, 1879, 1878, 1877, 1846, 1845, 15);
$pages_to_ignore_local = array(50);
/************************************
* GET SEARCH TERMS AND PREPARE SQL STATEMENT
* I. create an array of search terms
* II. define and remove stop words
* III. compose sql statement of search terms
* IV. call the search function or return no results
/**
* Checks if some tables with the given prefix exist in the database
*
* @param string $dbUser
* @param string $dbPassword
* @param string $dbName
* @param string $dbHost
* @param string $dbPrefix
* @return bool
*/
private function someWpTablesExist($dbUser, $dbPassword, $dbName, $dbHost, $dbPrefix)
{
$wpdb = new \wpdb($dbUser, $dbPassword, $dbName, $dbHost);
$wpdb->set_prefix($dbPrefix);
$tables = $wpdb->get_col("SHOW TABLES LIKE '{$dbPrefix}_%'");
$wpTables = array_intersect($tables, $wpdb->tables());
return count($wpTables) > 0;
}
/**
* In multisite mode WordPress uses site domain to work out which blog to show. Domains are stored in the database.
* However, domains will be different for different SitePush versions of a site, so this won't work unless
* we make sure the database has the right domains for the right sites.
*
* This method makes sure the database has the correct domains in place.
*
* @requires domain map file (path set in options)
*/
private function fix_multisite_domains()
{
$sitepush_domain_map = parse_ini_file($this->options->domain_map_conf, TRUE);
if ($this->dry_run) {
$this->add_result("Fixing destination domains for multisite (not done because this is a dry run)", 2);
return FALSE;
} else {
$this->add_result("Fixing destination domains for multisite", 2);
}
//create a new WPDB object for the database we are pushing to
$db_dest = $this->options->get_db_params_for_site($this->dest);
$dest_host = empty($db_dest['host']) ? DB_HOST : $db_dest['host'];
$spdb = new wpdb($db_dest['user'], $db_dest['pw'], $db_dest['name'], $dest_host);
//set up $spdb properties
global $table_prefix;
$spdb->set_prefix($table_prefix);
$sitepush_replace_urls = $sitepush_domain_map[$this->dest];
$sitepush_replace_urls = array_unique($sitepush_replace_urls);
//remove any duplicates
unset($sitepush_domain_map[$this->dest]);
$sitepush_search_sites = array_keys($sitepush_domain_map);
$blogs = $spdb->get_results("SELECT blog_id FROM {$spdb->blogs}", ARRAY_A);
//cycle through each domain for this site
foreach ($sitepush_replace_urls as $site_id => $sitepush_replace_url) {
//cycle through each sitepush site
foreach ($sitepush_search_sites as $sitepush_search_site) {
$sitepush_search_url = empty($sitepush_domain_map[$sitepush_search_site][$site_id]) ? '' : $sitepush_domain_map[$sitepush_search_site][$site_id];
if (!$sitepush_search_url) {
continue;
}
//domain wasn't specified for that site
//update domain in wp_site
$spdb->query($spdb->prepare("UPDATE {$spdb->site} SET domain = %s WHERE domain = %s", array($sitepush_replace_url, $sitepush_search_url)));
//update domain in wp_sitemeta
$spdb->query($spdb->prepare("UPDATE {$spdb->sitemeta} SET meta_value = REPLACE(meta_value, %s, %s) WHERE meta_key = 'siteurl'", array($sitepush_search_url, $sitepush_replace_url)));
//update domain in wp_blogs
$spdb->query($spdb->prepare("UPDATE {$spdb->blogs} SET domain = %s WHERE domain = %s", array($sitepush_replace_url, $sitepush_search_url)));
//update domain in main wp_options
$spdb->query($spdb->prepare("UPDATE {$spdb->base_prefix}options SET option_value = REPLACE(option_value, %s, %s) WHERE option_name = 'siteurl' OR option_name = 'home' OR option_name = 'fileupload_url' ", array($sitepush_search_url, $sitepush_replace_url)));
//update domain in wp_options for each site
foreach ($blogs as $blog_id) {
$spdb->query($spdb->prepare("UPDATE {$spdb->base_prefix}{$blog_id['blog_id']}_options SET option_value = REPLACE(option_value, %s, %s) WHERE option_name = 'siteurl' OR option_name = 'home' OR option_name = 'fileupload_url' ", array($sitepush_search_url, $sitepush_replace_url)));
}
}
}
}
