Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. <?php
  2. require_once('wp-load.php');
  3.  
  4. $res = $wpdb->get_results("SELECT post_id, meta_value FROM $wpdb->postmeta WHERE meta_key = 'blogger_permalink'");
  5. $wpdb->print_error();
  6.  
  7. foreach ($res as $row){
  8. $slug = explode("/",$row->meta_value);
  9. $slug = explode(".",$slug[3]);
  10.  
  11. $wpdb->query("UPDATE $wpdb->posts SET post_name ='" . $slug[0] . "' WHERE ID = $row->post_id");
  12. $wpdb->print_error();
  13. }
  14.  
  15. echo "DONE";
  16. ?>