Convert comments to answers?
hello, I have a webpage based on wordpress with a lot of posts and post’s comments (1000+ posts, 2000+ comments).
Is there any way to convert comments to answers?
comments are one the comments table on wordpress database.
I know that. what is your post_type? post?
yes, post_type is “post”
MAKE SURE TO KEEP A BACKUP OF YOUR SITE BEFORE RUNNING THIS.
Here is the simplest version of code. Add it to functions.php and refresh the page until all comments are gone. And make sure to remove the code afterward and run the recount in AnsPress tools.
<?php
global $wpdb;
$sql = "SELECT * FROM $wpdb->comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID) WHERE comment_approved = '1' AND comment_type = '' AND post_password = '' AND post_type='post' ORDER BY comment_date_gmt DESC LIMIT 100";
$comments = $wpdb->get_results( $sql );
if ( $comments ) {
foreach ( $comments as $c ) {
wp_insert_post( array(
'post_type' => 'answer',
'post_status' => 'publish',
'post_parent' => $c->comment_post_ID,
'post_content' => $c->comment_content,
'post_author' => $c->user_id,
) );
// Delete the comment after answer is created.
wp_delete_comment( $c->comment_ID, true );
}
}thanks for the answer, but i don’t know where to add the code
1) to wordpress’s functions.php
2) to my theme’s functions.php
3) to anspress’s function.php
please inform me about this: 1 or 2 or 3
Theme functions.php. wrap this inside a init hook. like:
add_action( ‘init’, function(){
// copy the codes from above to here.
});
what is post_type?