This is possible, but you’re going to have to do a lot of custom work to get what you want. If you want all of your postmeta to come from and go to a separate database, you can use these filters: get_{$meta_type}_metadata – This filter is documented in wp-includes/meta.php. Returning a non-null value from this … Read more
It’s a little bit hard to guess, what exactly are you trying to achieve, because your code isn’t correct SQL, but… It looks like you want to select posts based on custom fields… So all you need to do is to use Meta_Query. $q = new WP_Query( array( ‘post_type’ => ‘post’, // <- or whatever … Read more
Modify your code like this. It should work now. What you did wrong is both $curQuarter & $curYear is php variable not a part POST. you can directly use them. <?php $curMonth = date(“m”, time()); $curQuarter = ceil($curMonth/3); $curQuarter = $curQuarter-1; $curYear = date(‘Y/m/d’, strtotime(‘-14 day’)); $curYear = date(‘Y’, strtotime($curYear)); if (!empty($_POST)) { global $wpdb; … Read more
You have 2 two problems here: – You can’t use $wpdb-> with custom tables because [postmeta, posts, …] are variables in the class $wpdb. – WHERE ‘id’= 2 is not correct WHERE id = 2 So it should work: global $wpdb; $table_name = “_customtable”; $retrieve_data = $wpdb->get_results( “SELECT * FROM $table_name WHERE id = 2” … Read more
OK, so your code can’t work, because you use $wpdb->delete incorrectly. Let’s take a look at Codex. $wpdb->delete takes 3 params (one is optional): $table (string) (required) Table name. Default: None $where (array) (required) A named array of WHERE clauses (in column -> value pairs). Multiple clauses will be joined with ANDs. Both $where columns … Read more
If you only want to empty the site of its content (posts, comments, terms, and meta) then there’s a wp-cli command for that: $ wp site empty Use the the –uploads parameter to delete all files in the uploads folder and –yes to skip the conformation. Warning: Remember to backup before testing! See the wp-cli … Read more
I’ve had great luck with scripting WP-CLI to install, setup and configure WordPress development, staging, and production sites. With it, you can automate nearly the entire process including the installation of specific plugins, the creation of menus, categories, and just about any WordPress configuration item. Obviously, this approach would require shell access and the installation … Read more
Look into MySQL Wildcards. The correct MySQL Query for your search should be WHERE tb_posts.post_content LIKE “%example.com%” You should also be sure that you only target published posts (in contrast to nav_menu_items, revisions etc). Expand your WHERE with this: AND tb_posts.post_type IN (‘post’,’page’,*All Posttypes you use additionally*) AND tb_posts.post_status=”publish” So your complete Query should look … Read more
May be you can start from custom post types–> custom metas? then create custom roles. You will be able to limit the access by roles.
It is true that this problem will need some extensive (and knowledgable) hands-on to fix. In general, though, I would disable all caching, including any that JetPack does use my hosting File access (or FTP) to edit/change htaccess change all credentials – WordPress, hosting, FTP, databases – resetting all passwords to different (and strong) reinstalling … Read more