wp-fix-post-permalinks.php

wp-fix-post-permalinks.php

<?php
global $wpdb;

$threads = $wpdb->get_results("SELECT ID, post_title, post_name FROM wp_posts WHERE post_type = 'topic'");

foreach($threads as $thread){
  $sanitized_title = sanitize_title($thread->post_title);
  $id = $thread->ID;

  $wpdb->query("UPDATE wp_posts SET post_name = '$sanitized_title' WHERE ID = $id");
}