As per the WordPress documentation you cannot connect to another DB using wpdb. https://codex.wordpress.org/Class_Reference/wpdb You best bet is to connect to the DB separately.
If you suspect content-specific issue, I’d first try to start with clean site and set of test content instead ( official Theme Unit Test data for example). If processing content is indeed at fault this is quite unusual issue. If you can narrow it down to specific function it might be possible to build some … Read more
I think you will need to include some type of WP core file into the save.php file (I could be wrong). Since this file isn’t being called specifically by your plugin (or WP for that matter), it won’t have all of the variables that WP has to offer. Try adding this to the top of … Read more
Use switch_to_blog( $new_blog_id ) instead. You can find the function in wp-includes/ms-blogs.php. Update $wpdb->set_blog_id() doesn’t change the global variable $blog_id which is returned by get_current_blog_id(). switch_to_blog() does change the global variable.
This a php syntax error, try: foreach($last_updated_comment as $key => $last_comment_date){ print_r( $last_comment_date ); echo “<br /><br />”; }
I personally try to stay away from mysql queries when I can use WordPress functions to achieve the same thing. You could try using get_users, Is this what you are trying to achieve: <?php $blogusers = get_users(‘meta_value=Referral’); foreach ($blogusers as $user) { echo $user->user_email; } ?> Untested. But that should display every user with a … Read more
I know I probably can’t see the full picture, but in the excerpt you provided isn’t globalizing $post. global $wpdb, $post; $short = $wpdb->get_var(“SELECT url FROM $wpdb->prefix.’tweet_url’ WHERE post_id = ‘$post->ID’ “);
Nevermind, I was complicating this whole process because I wasn’t thinking about just using get_post_meta(). add_action(‘draft_to_publish’,’gcpl_draft_to_published’); function gcpl_draft_to_published($post){ $exp_processed = get_post_meta($post->ID, ‘_expiration-date-processed’, true); // check if the custom field has a value if($exp_processed != ”) { delete_post_meta($post->ID, ‘_expiration-date-processed’); } }
First you need permission to make changes in db of www.wordpress.domain.com. So for this you have to add the ip of wwww.wordpress.domain.com to www.doamin.com so that they allow to make changes. After that just make a function which allow you to connect to that server and make changes. The query for this is $pwd = … Read more
Well, after looking at the other tables I had created successfully, only difference was the description column. Apparently WordPress or MySQL doesn’t like that as a column name and somehow has it reserved. So, after renaming it, the table was created fine. Hope this helps someone else in the same boat.