You can use $wpdb to access any database you have access to (credentials for) so one site or the other could access its partner’s database or both could access a third database. It shouldn’t be hard but you will need to write most of the SQL to do it. If you are in a position … Read more
My guess is that this is the wrong hook for what you are trying to do, or you are using it incorrectly. A few notes: You are passing unvalidated data into a query. Please don’t do that. This… $town_b = $_POST[‘item_meta’][800];//Gets the value from the first field global $wpdb; $query = “SELECT County FROM wp_locations … Read more
What you are describing is not a Custom Post Type and what you want (or think you want) is not a custom post type. To push a CPT to its own separate table you’d have to interrupt core processes in a hundred places, and I am not even sure there are hooks enough to do … Read more
I think changing array keys is more of a PHP problem // Get entire array $plugin_options = get_option( ‘plugin_options’ ); $new_options = array(); if( isset( $plugin_options[‘ga_accountId’] ) ) $new_options[‘ga_account_id’] = $plugin_options[‘ga_accountId’]; // Update entire array update_option( ‘plugin_settings_general’, $new_options ); // Delte old array delete_option( ‘plugin_options’ ); Any end-user who might be using using your plugin’s … Read more
Copy all of the files to the new folder. For the database, you’ll need to use something like PHPMyAdmin to export the current database as a .SQL file. Edit the .SQL file you downloaded to remove the first statements specifying what database to use (it will be “USE database”). You’d then need to create a … Read more
I am working on redesigning a fairly high profile blog. I suggested the best way to do that, rather than mockups, is to just upload their wordpress export to a new WP install on domain. I periodically (twice a year or so) pull the database from our primary site and import into a dev site. … Read more
And I want to add an additional condition that the post be in a specific category. Any thoughts? JOINing on the taxonomy tables is complicated. Unless you have a good reason why you have to use SQL, don’t. Use WP_Query. $args = array( ‘post_type’ => $holder, ‘numberposts’ => -1, ‘post_status’ => array(‘publish’), ‘category_name’ => ‘cat-slug’, … Read more
If you look in the database in the $wpdb->postmeta table you will see a meta_key named _wp_old_slug. That is how WordPress tracks slug changes. By editing the database directly you bypassed the mechanisms that create that postmeta entry. You never want to edit the database directly if you can use WordPress Core functions instead. Attempting … Read more
ACF using milliseconds is not standard for timestamps, and nor is it useful. How much accuracy do you need? Bear in mind that converting to something like yyyymmdd will not accommodate timezones. If you have access to PHPMyAdmin (or similar) and know your way around SQL, running a quick query would probably be the easiest … Read more
Maybe you should try doing a fresh install of wordpress on your local computer and simply import your website using the wordpress.xml file created via Tools > Export. If you do that, you can take a good look at the wp_options table as this may give you a clue as to what might be going … Read more