I manage to work my problem. For those who seek the same answer, just run this query INSERT INTO wp_postmeta (post_id, meta_key, meta_value) SELECT wp_posts.ID, ‘video_desc’, ‘Description here’ FROM wp_posts WHERE wp_posts.post_status=”publish”;
You could try something like this. DELETE FROM wp_users WHERE ID in ( 5506, 5507,… ); Make sure to try it on a staging area first and backup your database.
For any other readers I’d like to add in advance that this only really makes sense if you are kind of creating drafts or templates or whatever you want to call it that will be changed later on. Otherwise you’ll at least deal with SEO penalties due to duplicate content. Unfortunately this functionality isn’t part … Read more
s_ha_dum’s answer prompted me to look into this a little further. I checked the users in the database. It turns out that the dropdown list in Posts -> Edit is using the Display Name, not the User Login, as I had expected. So, the problem was not that WordPress was functioning incorrectly, but that my … Read more
Try something like this: $pages = get_posts(); $page_ids_to_swap_the_template = array( 1, 2, 3, etc… ); foreach ( $pages as $page ) { if ( in_array( $page->ID, $page_ids_to_swap_the_template ) ) { update_post_meta( $page->ID, ‘_wp_page_template’, ‘new_template.php’ ); } }
You can loop through all the woo-commerce products and delete them along with their attachment(images).. $args = array( ‘post_type’ => ‘product’, … ); $loop = new WP_Query( $args ); while ( $loop->have_posts() ) : $loop->the_post(); ?> <?php wp_delete_post( $loop->post->ID ); wp_delete_attachment( $loop->post->attachment_id ); ?> <?php endwhile; ?>
Fastest way in my opinion would be to apply filter on the_content with preg_replace_callback to find media URLs and replace them with anything else, like attachment pages. Attachment ID is available as part of <img> class value as well as wp:image attribute in Gutenberg comment. So you just need some smart regexp to match each … Read more
I found this plugin: batch categories plugin. I don’t know anything about it, but it looks like it meets your needs
Maybe this tutorial at wpengineer will help: WP_List_Table – a step by step guide: Bulk actions
You already have your updateYoutube() function. Edit it to insert a new post. Very generally: function updateYoutube( $videocode ){ global $conn; $run = $conn->query(“SELECT `ID` FROM `youtubetable` WHERE `ID` = ‘$videocode'”); if ($run->num_rows > 0) return false; else { if ($conn->query(“INSERT INTO youtubetable (`ID`) VALUES (‘$videocode’)”) === TRUE) { // ################################# // NOTE: The following … Read more