'; if ($retval == 0) { echo '
".htmlentities ($messages)."\r\n\r\n"; echo '
".htmlentities ($messages)."\r\n\r\n"; echo '
No suitable comments.
'; } function tidy_comment ($postid, $save, $input = 'wordpress', $output = 'wordpress', $short = false) { global $wpdb; // SQL to get one post $sql = $wpdb->prepare( "SELECT * FROM {$wpdb->comments} WHERE comment_ID=%d", $postid );; $result = $wpdb->get_row ($sql); if ($result) { if ($input == 'wordpress') $result->comment_content = wptexturize (wpautop ($result->comment_content)); $result->comment_content = stripslashes ($result->comment_content); $retval = tidy_text ($result->comment_content, $content, $messages, $output); if ($output == 'wordpress') $content = clean_pre ($content); $content = $wpdb->escape ($content); $sql = $wpdb->prepare( "UPDATE {$wpdb->comments} SET comment_content=%s WHERE comment_ID=%d", $content, $result->comment_ID ); $link = "#{$result->comment_ID}"; $single = ''; tidy_print_details ($retval, $result->comment_ID, $link, $messages, $single, $short); if (($retval == 0 || $retval == 1) && $save && strlen ($content) > 0) $wpdb->query ($sql); } } function tidy_post ($postid, $save, $input = 'wordpress', $output = 'wordpress', $short = false) { global $wpdb; // SQL to get one post $sql = $wpdb->prepare( "SELECT * FROM {$wpdb->posts} WHERE ID=%d", $postid ); $result = $wpdb->get_row ($sql); if ($result) { if ($input == 'wordpress') $result->post_content = wptexturize (wpautop ($result->post_content)); $result->post_content = stripslashes ($result->post_content); $retval = tidy_text ($result->post_content, $content, $messages, $output); if ($output == 'wordpress') $content = clean_pre ($content); $content = $wpdb->escape ($content); $sql = $wpdb->prepare( "UPDATE {$wpdb->posts} SET post_content=%s WHERE ID=%d", $content, $result->ID ); $link = "#{$result->ID}"; $single = ''; tidy_print_details ($retval, $result->ID, $link, $messages, $single, $short); if (($retval == 0 || $retval == 1) && $save && strlen ($content) > 0) $wpdb->query ($sql); } } function tidy_excerpt ($postid, $save, $input = 'wordpress', $output = 'wordpress', $short = false) { global $wpdb; // SQL to get one post $sql = $wpdb->prepare( "SELECT * FROM {$wpdb->posts} WHERE ID=%d", $postid ); $result = $wpdb->get_row ($sql); if ($result) { if ($input == 'wordpress') $result->post_excerpt = wptexturize (wpautop ($result->post_excerpt)); $result->post_excerpt = stripslashes ($result->post_excerpt); $retval = tidy_text ($result->post_excerpt, $content, $messages, $output); if ($output == 'wordpress') $content = clean_pre ($content); $content = $wpdb->escape ($content); $sql = $wpdb->prepare( "UPDATE {$wpdb->posts} SET post_excerpt=%s WHERE ID=%d", $content, $result->ID ); $link = "#{$result->ID}"; $single = ''; tidy_print_details ($retval, $result->ID, $link, $messages, $single, $short); if (($retval == 0 || $retval == 1) && $save && strlen ($content) > 0) $wpdb->query ($sql); } } function tidy_run_excerpts ($save, $input = 'wordpress', $output = 'wordpress', $offset, $max) { global $wpdb; // SQL to get all posts $sql = $wpdb->prepare( "SELECT * FROM {$wpdb->posts} WHERE post_excerpt != '' ORDER BY ID LIMIT %d,%d", $offset,$max ); $results = $wpdb->get_results ($sql); if (count ($results) > 0) { foreach ($results AS $result) { if ($input == 'wordpress') $result->post_excerpt = wptexturize (wpautop ($result->post_excerpt)); $result->post_excerpt = stripslashes ($result->post_excerpt); $link = "#{$result->ID}"; $single = ''; $retval = tidy_text ($result->post_excerpt, $content, $messages, $output); if ($output == 'wordpress') $content = clean_pre ($content); $content = $wpdb->escape ($content); $sql = $wpdb->prepare( "UPDATE {$wpdb->posts} SET post_excerpt=%s WHERE ID=%d", $content, $result->ID ); tidy_print_details ($retval, $result->ID, $link, $messages, $single); if (($retval == 0 || $retval == 1) && $save && strlen ($content) > 0) $wpdb->query ($sql); } } else echo 'No suitable posts.
'; } function tidy_run_pages ($save, $input = 'wordpress', $output = 'wordpress', $offset, $max) { global $wpdb; // SQL to get all posts $sql = $wpdb->prepare( "SELECT * FROM {$wpdb->posts} WHERE post_type='page' ORDER BY ID LIMIT %d,%d", $offset,$max ); $results = $wpdb->get_results ($sql); if (count ($results) > 0) { foreach ($results AS $result) { if ($input == 'wordpress') $result->post_content = wpautop ($result->post_content); $result->post_content = stripslashes ($result->post_content); $link = "{$result->ID}"; $single = ''; $retval = tidy_text ($result->post_content, $content, $messages, $output); if ($output == 'wordpress') $content = clean_pre ($content); $content = $wpdb->escape ($content); $sql = $wpdb->prepare( "UPDATE {$wpdb->posts} SET post_content=%s WHERE ID=%d", $content, $result->ID ); tidy_print_details ($retval, $result->ID, $link, $messages, $single); if (($retval == 0 || $retval == 1) && $save && strlen ($content) > 0) $wpdb->query ($sql); } } else echo 'No suitable posts.
'; } function tidy_run_posts ($save, $input = 'wordpress', $output = 'wordpress', $offset, $max) { global $wpdb; // SQL to get all posts $sql = $wpdb->prepare( "SELECT * FROM {$wpdb->posts} WHERE post_type='post' ORDER BY ID LIMIT %d,%d", $offset,$max ); $results = $wpdb->get_results ($sql); if (count ($results) > 0) { foreach ($results AS $result) { if ($input == 'wordpress') $result->post_content = wpautop ($result->post_content); $result->post_content = stripslashes ($result->post_content); $link = "{$result->ID}"; $single = ''; $retval = tidy_text ($result->post_content, $content, $messages, $output); if ($output == 'wordpress') $content = clean_pre ($content); $content = $wpdb->escape ($content); $sql = $wpdb->prepare( "UPDATE {$wpdb->posts} SET post_content=%s WHERE ID=%d", $content, $result->ID ); tidy_print_details ($retval, $result->ID, $link, $messages, $single); if (($retval == 0 || $retval == 1) && $save && strlen ($content) > 0) $wpdb->query ($sql); } } else echo 'No suitable posts.
'; } // Function performs a Tidy on some text by spawning a Tidy process (and not using the PHP Tidy Library) // Return: 0 - no warnings or errors // 1 - warnings // 2 - errors // 3 - failed (no tidy command etc) function tidy_text ($text, &$output, &$messages, $config) { // Determine which version of Tidy to use $machine = php_uname ('s'); if ($machine == 'Darwin') $tidy_command = 'tidy.osx'; else if ($machine == 'Windows') $tidy_command = 'tidy.exe'; else if ($machine == 'Linux') $tidy_command = 'tidy.linux'; else if ($machine == 'FreeBSD') $tidy_command = 'tidy.freebsd'; else return 3; $tidy_command = dirname (__FILE__)."/".$tidy_command; $tidy_command .= ' -config '.dirname (__FILE__)."/$config.config"; $tidy_head = ''; $tidy_head .= '