// Static so we don't call plugin_basename on every plugin row. Thanks to Joost de Valk's WordPress SEO for this code.

static $this_plugin;

if( empty( $this_plugin ) )

$this_plugin = dirname( plugin_basename( __FILE__ ) ) . '/fix-duplicates.php';

if ( $file == $this_plugin ) {

$settings_link = '<a href="' . admin_url( 'admin.php?page=fix_duplicates' ) . '">Settings</a>';

array_unshift( $links, $settings_link );

}

return $links;

// if it's not one of our pages, let's bail

if ( ( ! isset( $_GET[ 'post_type' ] ) || ! $_GET[ 'post_type' ] == 'fix_dups_redirects' ) && ! stristr ( $hook, 'fix_duplicates' ) )

return;

// register and enqueue our stylesheets and scripts as necessary

$fix_duplicates_options = get_option( 'fix_duplicates_options' );

wp_register_style( 'fix_duplicates_admin_css', plugins_url( '/includes/fix-duplicates.css', __FILE__ ), false, $fix_duplicates_options[ 'version' ] );

wp_enqueue_style( 'fix_duplicates_admin_css' );

wp_enqueue_script( 'fix_duplicates_admin_js', plugins_url( '/includes/fix-duplicates.js', __FILE__ ), array( 'jquery' ), $fix_duplicates_options[ 'version' ] );

// can't easily move to the external CSS file because of the PHP included to get the correct URL

// if not one of our pages, don't include the scripts

if ( ! isset( $_GET[ 'page' ] ) || ! stristr ( $_GET[ 'page' ] , 'fix_duplicates' ) )

return;

?>

<!-- Start Fix Duplicates plugin additions -->

<style type="text/css" media>

.row-actions {

color:#444;

}

</style>

<!-- End Fix Duplicates plugin additions -->

<?php

// check the nonce if we've got any URL parameters set (apart from page which is always set)

if ( count( $_GET ) > 1 && ! check_admin_referer( 'fix_duplicates_main_form_nonce' ) )

wp_die( 'Sorry, you cannot access this page directly' );

// if we have any POST items, call the functions to process it

if ( count( $_POST ) && check_admin_referer( 'fix_duplicates_main_form_nonce' ) )

fix_duplicates_process_post_actions();

// deal with trashing individual items.

if ( isset( $_GET[ 'action' ] ) && esc_html( $_GET[ 'action' ] ) == 'duplicate_trash_individual' )

fix_duplicates_process_trash_individual( absint( $_GET[ 'post' ] ), absint( $_GET[ 'redirect' ] ) );

// get the options

$fix_duplicates_options = get_option( 'fix_duplicates_options' );

// get the list of custom post types, excluding revisions, attachments, nav_menu_item and our redirection CPT (we use this below)

$fix_duplicates_post_types = get_post_types( array( 'show_ui' => true ), 'objects' );

if ( isset( $fix_duplicates_post_types[ 'fix_dups_redirects' ] ) )

unset( $fix_duplicates_post_types[ 'fix_dups_redirects' ] );

// set up the database details

global $wpdb;

$tablename = $wpdb->prefix . 'posts';

// setup variable based on mode URL parameter

if ( isset( $_GET[ 'mode' ] ) && esc_html( $_GET[ 'mode' ] ) ) {

$current_mode = esc_html( $_GET[ 'mode' ] );

}

else {

$current_mode = 'list';

}

// setup variable and SQL string based on post type URL variable.

if ( isset( $_GET[ 'post_type' ] ) && esc_html( $_GET[ 'post_type' ] ) ) {

$post_type = esc_html( $_GET[ 'post_type' ] );

$post_type_string = $wpdb->prepare( "$tablename.post_type = %s", $post_type );

}

else {

$post_type = 0;

$post_type_string_array = array();

foreach ( $fix_duplicates_post_types as $key => $value ) {

$post_type_string_array[] = $wpdb->prepare( "$tablename.post_type = '%s'", $key );

}

$post_type_string = '(' . implode( $post_type_string_array, ' OR ' ) . ')';

}

// setup variable and SQL string based on search term URL parameter (note %% required for LIKE when wpdb->prepare is used)

if ( isset( $_GET[ 's' ] ) && esc_html( $_GET[ 's' ] ) ) {

$fix_duplicates_search_term = esc_html( $_GET[ 's' ] );

$fix_duplicates_search_string = $wpdb->prepare( " AND $tablename.post_title LIKE %s", '%' . like_escape( $fix_duplicates_search_term ) . '%' );

}

else {

$fix_duplicates_search_term = '';

$fix_duplicates_search_string = '';

}

// setup variable and SQL string based on show draft parameter

if ( isset( $_GET[ 'show_drafts' ] ) && esc_html( $_GET[ 'show_drafts' ] ) == 1 ) {

$fix_duplicates_show_drafts = 1;

$fix_duplicates_show_drafts_string = "( $tablename.post_status ='publish' OR $tablename.post_status ='draft' )";

}

else {

$fix_duplicates_show_drafts = 0;

$fix_duplicates_show_drafts_string = "$tablename.post_status ='publish'";

}

// Get the number of duplicate titles

$fix_duplicates_count_query =

"SELECT COUNT(post_title) FROM (

SELECT post_title FROM $tablename

WHERE $post_type_string $fix_duplicates_search_string AND $fix_duplicates_show_drafts_string

GROUP BY post_title HAVING COUNT(*)>1

) AS t";

$fix_duplicates_result_count = $wpdb->get_var( $fix_duplicates_count_query );

// deal with pagination (needs to happen after we have total results, but before we query for individual entries)

if ( isset( $_GET[ 'no' ] ) && absint( $_GET[ 'no' ] ) ) {

$numtoshow = absint( $_GET[ 'no' ] );

}

else {

$numtoshow = 20;

}

// using intval instead of absint as we don't want it to be absolute (we will make negative numbers page 1)

if ( isset( $_GET[ 'pageno' ] ) && intval( $_GET[ 'pageno' ] ) ) {

$page = intval( $_GET[ 'pageno' ] );

// deal with page numbers below 1 (make them page 1)

if ( $page < 1 ) {

$page = 1;

}

// deal with page numbers over the maximum (make them the last page)

elseif ( ( $page - 1 ) * $numtoshow >= $fix_duplicates_result_count ) {

$page = ceil( $fix_duplicates_result_count / $numtoshow );

}

// calculate offset now that the page number has been normalised

$offset = ( $page - 1 ) * $numtoshow;

}

else {

$page = 1;

$offset = 0;

}

$total_pages = ceil( $fix_duplicates_result_count / $numtoshow );

// get the duplicates from the DB

$fix_duplicates_query =

"SELECT t1.* FROM $tablename AS t1 INNER JOIN (

SELECT post_title FROM $tablename

WHERE $post_type_string $fix_duplicates_search_string AND $fix_duplicates_show_drafts_string

GROUP BY post_title HAVING COUNT(*)>1 LIMIT $offset, $numtoshow

) AS t2

ON t1.post_title = t2.post_title

WHERE " . str_replace( $tablename, 't1', $post_type_string ) . " AND " . str_replace( $tablename, 't1', $fix_duplicates_show_drafts_string ) . "

ORDER BY t1.post_title, t1.post_date DESC";

$fix_duplicates_result = $wpdb->get_results( $fix_duplicates_query, ARRAY_A );

// get the number of individual posts that are duplicates

$fix_duplicates_count_individual_query =

"SELECT COUNT(*) FROM $tablename AS t1 INNER JOIN (

SELECT post_title FROM $tablename

WHERE $post_type_string $fix_duplicates_search_string AND $fix_duplicates_show_drafts_string

GROUP BY post_title HAVING COUNT(*)>1

) AS t2

ON t1.post_title = t2.post_title

WHERE " . str_replace( $tablename, 't1', $post_type_string ) . " AND " . str_replace( $tablename, 't1', $fix_duplicates_show_drafts_string );

$fix_duplicates_result_count_individual = $wpdb->get_var( $fix_duplicates_count_individual_query );

// if there are no duplicates, tell them (but don't worry for search results as it will tell them there are 0 titles)

if ( $fix_duplicates_result_count == 0 && empty( $fix_duplicates_search_term ) ) {

echo '<div id="message" class="updated"><p><strong>GREAT NEWS: There are no duplicate posts!</strong></p></div>';

}

// should never occur

else if ( count( $fix_duplicates_result ) == 0 && $fix_duplicates_result_count > 0 ) {

echo '<div id="message" class="updated"><p><strong>ERROR: Page number out of range!</strong></p></div>';

}

// Drop to HTML to create page.

/*

Rolling our own table that uses core styles so it fits with the rest of Admin.

Not using wp_list_table because Andrew Nacin says plugins shouldn't use it (http://wpengineer.com/2426/wp_list_table-a-step-by-step-guide/#comment-9617)

In hindsight that was a mistake as this will probably face many of the same issues - if the Admin styles change I'll need to update this - but gets none of the advantages

*/

?>

<div class="wrap">

<h2><img style="vertical-align:middle;margin-right:12px;" src="<?php echo plugins_url( '/images/fix-duplicates-icon-32.png', __FILE__ ); ?>" alt="Fix Duplicates icon" />Fix Duplicates - Duplicate Entries</h2>

<div id="poststuff">

<div class="stuffbox">

<div class="inside">

<!-- Display information about search and or filter, with number of entries found -->

<div class="fix-duplicates-results">

<?php // If it's a search or page type filter (or both), tell them what the query was and give them the option to clear ?>

<?php if( ! empty( $fix_duplicates_search_term ) || ! empty( $post_type ) ) : ?>

<div class="fix-duplicates-results-search">

<span>

<?php if( ! empty( $fix_duplicates_search_term ) ) echo 'Search results for "' . $fix_duplicates_search_term . '"'; ?>

<?php if( ! empty( $fix_duplicates_search_term ) && ! empty( $post_type ) ) echo ' and '; ?>

<?php if( ! empty( $post_type ) ) echo 'Post type of ' . $post_type; ?>

</span>

<a class="fix-duplicates-results-clear" href="<?php echo esc_url( remove_query_arg( array( 's', 'post_type', 'pageno', 'no' ) ) ); ?>">Clear</a>

</div>

<?php endif; ?>

<div class="fix-duplicates-results-count">

<?php echo $fix_duplicates_result_count; ?> duplicate titles (<?php echo $fix_duplicates_result_count_individual; ?> individual entries)

</div>

</div>

<!-- Top navigation area -->

<div class="tablenav top">

<!-- Form: Form to search and or filter the results -->

<form id="fix-duplicates-main-form" action="" method="GET">

<!-- Form: Hidden fields for the form --> <?php // nonce code is before closing </form> ?>

<input type="hidden" name="page" value="fix_duplicates" />

<input type="hidden" id="mode" name="mode" value="<?php echo $current_mode; ?>" />

<?php if ( $numtoshow ) : ?><input type="hidden" name="no" value="<?php echo $numtoshow; ?>" /><?php endif; ?>

<!-- Form: Search box -->

<p class="search-box">

<label class="screen-reader-text" for="post-search-input">Search Duplicates:</label>

<input type="search" id="post-search-input" name="s" value="<?php echo $fix_duplicates_search_term; ?>" />

<input type="submit" name="" id="search-submit" class="button" value="Search Duplicates" />

</p>

<!-- Form: Post Type Filter-->

<div class="fix-duplicates-post-type-filter alignleft actions">

<select name="post_type">

<option <?php if ( $post_type === 0 ) echo 'selected="selected" '; ?>value="0">All post types</option>

<?php

// add custom post types to the options (using the array we got above)

foreach ( $fix_duplicates_post_types as $key => $value ) {

echo "\t\t\t\t" . '<option value="'. $key . '"';

if ( $post_type === $key ) echo ' selected="selected"';

echo '>'. $value->label . '</option>' . "\n";

}

?>

</select>

<label>&nbsp;<input type="checkbox" id="show_drafts" name="show_drafts" value="1" <?php if ( $fix_duplicates_show_drafts ) echo 'checked="checked" class="drafts_showing" '; ?>/> Show drafts</label>&nbsp;

<input type="submit" name="" id="post-type-submit" class="button-secondary" value="Filter Posts" />

</div>

<!-- Form: Paging controls -->

<?php // mostly links except 'jump to page'; using WordPress functions to build the links ?>

<div class='tablenav-pages<?php if ( $total_pages <= 1 ) echo ' one-page'; ?>'>

<span class="displaying-num"><?php echo $fix_duplicates_result_count; ?></span>

<span class="pagination-links">

<a class="first-page<?php if ( $total_pages > 1 && $page == 1 ) echo ' disabled'; ?>" title="Go to the first page" href="<?php echo esc_url( wp_nonce_url( add_query_arg( array( 'mode' => $current_mode, 'pageno' => '1', '_wpnonce' => false ) ), 'fix_duplicates_main_form_nonce' ) ); ?>">&laquo;</a>

<a class="prev-page<?php if ( $total_pages > 1 && $page == 1 ) echo ' disabled'; ?>" title="Go to the previous page" href="<?php echo esc_url( wp_nonce_url( add_query_arg( array( 'mode' => $current_mode, 'pageno' => $page - 1, '_wpnonce' => false ) ), 'fix_duplicates_main_form_nonce' ) ); ?>">&lsaquo;</a>

<span class="paging-input"><input class="current-page" title="Current page" type="text" name="pageno" value="<?php echo $page; ?>" size="1" /> of <span class="total-pages"><?php echo $total_pages; ?></span></span>

<input type="submit" name="" id="go-to-page" class="button-secondary hidden" value="Go to" />

<a class="next-page<?php if ( $total_pages > 1 && $page == $total_pages ) echo ' disabled'; ?>" title="Go to the next page" href="<?php echo esc_url( wp_nonce_url( add_query_arg( array( 'mode' => $current_mode, 'pageno' => $page + 1, '_wpnonce' => false ) ), 'fix_duplicates_main_form_nonce' ) ); ?>">&rsaquo;</a>

<a class="last-page<?php if ( $total_pages > 1 && $page == $total_pages ) echo ' disabled'; ?>" title="Go to the last page" href="<?php echo esc_url( wp_nonce_url( add_query_arg( array( 'mode' => $current_mode, 'pageno' => $total_pages, '_wpnonce' => false ) ), 'fix_duplicates_main_form_nonce' ) ); ?>">&raquo;</a>

</span>

</div>

<!-- Form: Show titles or show entries? -->

<div class="view-switch">

<?php // build the mode selector, creating links and showing the correct icon, etc. JavaScript is used elsewhere to supplement switching.

$modes = array(

'list' => __( 'List View' ),

'expanded' => __( 'Expanded' )

);

foreach ( $modes as $mode => $title ) {

$class = ( $current_mode == $mode ) ? 'class="current"' : '';

echo "<a id='fd-view-switch-$mode' href='" . esc_url( add_query_arg( 'mode', $mode ) ) . "' $class><img id='view-switch-$mode' src='" . esc_url( includes_url( 'images/blank.gif' ) ) . "' width='20' height='20' title='$title' alt='$title' /></a>\n";

}

?>

</div>

<!-- Form: nonce for security purposes -->

<?php // false because wp_http_referer is added recursively, making the URL too long. I don't use it anyway. ?>

<?php wp_nonce_field( 'fix_duplicates_main_form_nonce', '_wpnonce', false ); ?>

</form>

<!-- Form: End form to search and or filter the results -->

<!-- Form: Form for bulk actions etc -->

<form id="fix-duplicates-bulk-form" class="fix-duplicates-bulk-form" action="" method="POST">

<div class="alignleft actions">

<select name='action'>

<option value='-1' selected='selected'>Bulk Actions</option>

<option value='trash'>Trash Selected</option>

</select>

<input type="submit" name="" id="doaction" class="button-secondary action" value="Apply" />

</div>

<br class="clear" />

</div>

<!-- End top navigation area -->

<!-- Top extra buttons area -->

<div class="fix-duplicates-top-buttons tablenav top">

<fieldset>

<strong>Trash:</strong>

<label class="fix-duplicate-lhs"><input id="duplicate_entry_delete_all" name="duplicate_entry_delete_all" type="radio" value="0" /> All </label>

<label class="fix-duplicate-rhs"><input id="duplicate_entry_delete_below" name="duplicate_entry_delete_all" type="radio" value="1" checked="checked" /> All listed below </label>

</fieldset>

<fieldset>

<strong>And Keep:</strong>

<label class="fix-duplicate-lhs"><input name="duplicate_entry_keep_all" type="radio" value="0" checked="checked" /> Oldest </label>

<label class="fix-duplicate-rhs"><input name="duplicate_entry_keep_all" type="radio" value="1" /> Newest</label>

</fieldset>

<?php

$fix_duplicates_redirect_bulk_checkbox_string = '

<fieldset class="fix-duplicates-disabled" readonly="readonly" title="Pro version is required for the redirection feature" >

<strong>Redirect:</strong>

<label class="fix-duplicate-rhs"><input disabled="disabled" type="checkbox" id="duplicate_entry_redirect_all" name="duplicate_entry_redirect_all" value="1" /> Redirect deleted items to the kept item</label>

</fieldset>

';

echo apply_filters( 'fix_duplicates_redirect_bulk_checkbox_string', $fix_duplicates_redirect_bulk_checkbox_string );

?>

<label><input type="submit" id="duplicate_entry_all_apply" name="duplicate_entry_all_apply" class="button-secondary action" value="Apply" /></label>

</div>

<div id="duplicate_entry_warning" class="fix-duplicates-warning">

<p>Choosing 'All' should be used with care. Note the following:

<ul>

<li>This will take a long time. Do not close the window until it's complete.</li>

<li>The delete may time out and not complete. You may need to run it multiple times.</li>

<li>This will delete the posts directly, bypassing the Trash.</li>

<li>This will not redirect the deleted posts.</li>

<li>This will not delete duplicates with exactly the same date and time.</li>

</ul>

</p>

</div>

<div id="duplicate_entry_redirect_warning" class="fix-duplicates-warning">

<p>Items will not be redirected if the target is not published (ie if it has a status of draft).</p>

</div>

<!-- End extra buttons area -->

<!-- Table listing the duplicates -->

<table class="wp-list-table widefat fixed posts" cellspacing="0">

<!-- Table headers -->

<thead>

<tr>

<th scope="col" id="cb" class="manage-column column-cb check-column"><input type="checkbox" /></th>

<th scope="col" id="title" class="manage-column column-title">Title</th>

<th scope="col" id="post_id" class="manage-column column-post_id">ID</th>

<th scope="col" id="author" class="manage-column column-author">Author</th>

<th scope="col" id="categories" class="manage-column column-categories">Categories</th>

<th scope="col" id="words" class="manage-column column-words">Words</th>

<th scope="col" id="comments" class="manage-column column-comments num"><span class="vers"><img alt="Comments" src="<?php echo esc_url( admin_url( 'images/comment-grey-bubble.png' ) ); ?>" /></span></th>

<?php do_action( 'fix_duplicates_th' ); ?>

<th scope="col" id="date" class="manage-column column-date sortable asc">Last Modified</th>

</tr>

</thead>

<?php

// variable used group duplicate titles together

$fix_duplicates_group_no = 1;

// Start loop for each duplicate item (individual entries, we group them below by adding a control row for the first duplicate)

foreach ( $fix_duplicates_result as $key => $value ) :

// if this title doesn't match previous row's title, we're on to a new duplicate, so start a new tbody and add summary / control row

if ( !empty( $fix_duplicates_result[ $key-1 ][ 'post_title' ] ) && trim( strtolower( $fix_duplicates_result[ $key-1 ][ 'post_title' ] ) ) != trim( strtolower( $value[ 'post_title' ] ) ) ) :

?>

<tbody id="fix-duplicates-group-<?php echo $fix_duplicates_group_no; ?>">

<!-- Summary row showing the duplicate title rather than individual entries -->

<tr id="duplicate-control-<?php echo $fix_duplicates_group_no; ?>" class="fixed-duplicates-control" valign="top">

<td scope="row" class="check-column" <?php echo apply_filters( 'fix_duplicates_columns_colspan', 'colspan="8"' ); ?>><strong><?php echo $value[ 'post_title' ]; ?></strong>

<?php

// Work out the count by looping through the results. Also store all entries for this title for deletion and for redirection

$count = 0;

$fix_duplicates_this_duplicate_array = array();

$fix_duplicates_this_redirect_array = array();

foreach ( $fix_duplicates_result as $key2 => $value2 ) {

if ( trim( strtolower( $fix_duplicates_result[ $key2 ][ 'post_title' ] ) ) == trim( strtolower( $value[ 'post_title' ] ) ) ) {

$fix_duplicates_this_duplicate_array[] = $fix_duplicates_result[ $key2 ][ 'ID' ];

$count++;

if ( $value2[ 'post_status' ] == 'publish' )

$fix_duplicates_this_redirect_array[] = $fix_duplicates_result[ $key2 ][ 'ID' ];

}

}

echo '<span class="fix-duplicates-post-number">(' . $count . ' posts <span class="fix-duplicates-more-less">&uarr;</span>)</span>';

?>

<!-- Summary row actions which appear on hover -->

<div class="row-actions">

<fieldset>

<strong>Keep:</strong>

<label class="fix-duplicate-lhs"><input id="duplicate_entry_keep_<?php echo $fix_duplicates_group_no; ?>_oldest" name="duplicate_entry_keep[<?php echo $fix_duplicates_group_no; ?>]" type="radio" value="0" checked="checked" /> Oldest </label>

<label class="fix-duplicate-rhs"><input id="duplicate_entry_keep_<?php echo $fix_duplicates_group_no; ?>_newest" name="duplicate_entry_keep[<?php echo $fix_duplicates_group_no; ?>]" type="radio" value="1" /> Newest</label>

</fieldset>

<?php

$fix_duplicates_redirect_control_checkbox_string = '

<fieldset class="fix-duplicates-disabled" readonly="readonly" title="Pro version is required for the redirection feature" >

<strong>Redirect:</strong>

<label class="fix-duplicate-rhs"><input disabled="disabled" type="checkbox" id="duplicate_entry_redirect_' . $fix_duplicates_group_no . '" name="duplicate_entry_redirect[' . $fix_duplicates_group_no . ']" value="1" /> Redirect deleted items to the kept item</label>

</fieldset>

';

$fix_duplicates_redirect_control_checkbox_array = apply_filters( 'fix_duplicates_redirect_control_checkbox_string', array( 'string' => $fix_duplicates_redirect_control_checkbox_string, 'group_no' => $fix_duplicates_group_no ) );

echo $fix_duplicates_redirect_control_checkbox_array[ 'string' ];

?>

<input id="duplicate_entry_items_to_delete_<?php echo $fix_duplicates_group_no; ?>" name="duplicate_entry_items_to_delete[<?php echo $fix_duplicates_group_no; ?>]" type="hidden" value="<?php echo implode( '+', $fix_duplicates_this_duplicate_array ); ?>" />

<label class="fix-duplicate-lhs"><input type="submit" id="duplicate_entry_apply_<?php echo $fix_duplicates_group_no; ?>" name="duplicate_entry_apply_<?php echo $fix_duplicates_group_no; ?>" class="button-secondary action" value="Apply" /></label>

</div>

</td>

</tr>

<!-- End summary row showing the duplicate title rather than individual entries -->

<?php

$fix_duplicates_group_no ++;

endif; // end of special stuff for first row / new duplicate.

// Next, we list the individual duplicate title. This happens for all entries whether first row or not (we're still in the loop).

?>

<!-- Individual title -->

<tr id="post-<?php echo absint( $value[ 'ID' ] ); ?>" class="duplicate-group-<?php echo $fix_duplicates_group_no - 1; ?>" valign="top">

<th scope="row" class="check-column"><input type="checkbox" name="post[]" value="<?php echo absint( $value[ 'ID' ] ); ?>" /></th>

<td class="post-title page-title column-title">

<strong>

<a class="row-title" href="<?php echo admin_url( 'post.php?post=' . absint( $value[ 'ID' ] ) . '&amp;action=edit' ); ?>" title="Edit &#8220;<?php echo $value[ 'post_title' ]; ?>&#8221;"><?php echo $value[ 'post_title' ]; ?></a>

<?php if( $value[ 'post_status' ] != 'publish' ) : ?>

- <span class='post-state'><?php echo $value[ 'post_status' ]; ?></span>

<?php endif; ?>

</strong>

<div class="row-actions">

<span class="trash"><a id="trash-<?php echo absint( $value[ 'ID' ] ); ?>" class="submitdelete" title="Move this item to the Trash" href="<?php echo esc_url( wp_nonce_url( add_query_arg( array( 'action' => 'duplicate_trash_individual', 'post' => absint( $value[ 'ID' ] ), 'redirect' => false, '_wpnonce' => false ) ), 'fix_duplicates_main_form_nonce' ) ); ?>">Trash</a></span> |

<?php

// build the string to put out for individual redirect links

$fix_duplicates_redirect_individual_links_string = '';

// if this is not the newest, add the redirect to the newest post, assuming there is at least one in the array

if ( $fix_duplicates_this_redirect_array[0] != absint( $value[ 'ID' ] ) && count( $fix_duplicates_this_redirect_array ) ) {

$fix_duplicates_redirect_individual_links_string .= '

<span class="trash"><span class="fix-duplicates-disabled" title="Pro version is required for the redirection feature">Redirect to ' . $fix_duplicates_this_redirect_array[0] . '</span></span> | ';

}

// if this is not the oldest, add the redirect to the oldest post, assuming there are more than one in the array

if ( end( array_values( $fix_duplicates_this_redirect_array ) ) != absint( $value[ 'ID' ] ) && count( $fix_duplicates_this_redirect_array ) > 1 ) {

$fix_duplicates_redirect_individual_links_string .= '

<span class="trash"><span class="fix-duplicates-disabled" title="Pro version is required for the redirection feature">Redirect to ' . end( array_values( $fix_duplicates_this_redirect_array ) ) . '</span></span> | ';

}

// apply filters

$fix_duplicates_redirect_individual_links_array = apply_filters( 'fix_duplicates_redirect_individual_links_string', array( 'string' => $fix_duplicates_redirect_individual_links_string, 'this_id' => absint( $value[ 'ID' ] ), 'dup_array' => $fix_duplicates_this_redirect_array ) );

echo $fix_duplicates_redirect_individual_links_array[ 'string' ];

?>

<span class='view'><a href="<?php echo get_permalink( absint( $value[ 'ID' ] ) ); ?>" rel="permalink">View</a></span>

</div>

</td>

<td class="post_id column-post_id"><?php echo absint( $value[ 'ID' ] ); ?></td>

<td class="author column-author"><a href="edit.php?post_type=post&#038;author=<?php echo $value[ 'post_author' ]; ?>"><?php the_author_meta( 'display_name', $value[ 'post_author' ] ); ?></a></td>

<td class="categories column-categories">

<?php

$fix_duplicates_category_array = get_the_category( absint( $value[ 'ID' ] ) );

if ( $fix_duplicates_category_array ) {

foreach( $fix_duplicates_category_array as $fix_duplicates_cat_key => $fix_duplicates_cat ) {

echo '<a href="' . esc_url( 'edit.php?category_name=' . $fix_duplicates_cat->slug ) . '">' . esc_html( $fix_duplicates_cat->name ) . '</a>';

if ( count( $fix_duplicates_category_array ) > $fix_duplicates_cat_key + 1 ) echo ', ';

}

}

?>

</td>

<td class="words column-words"><?php echo str_word_count( strip_tags( $value[ 'post_content' ] ) ); ?></td>

<td class="comments column-comments">

<div class="post-com-count-wrapper">

<a href="<?php echo admin_url( 'edit-comments.php?p=' . absint( $value[ 'ID' ] ) ); ?>" title='<?php echo number_format_i18n( get_pending_comments_num( absint( $value[ 'ID' ] ) ) ); ?> pending' class='post-com-count'><span class='comment-count'><?php echo number_format_i18n( get_comments_number( absint( $value[ 'ID' ] ) ) ); ?></span></a>

</div>

</td>

<?php do_action( 'fix_duplicates_td' ); ?>

<td class="date column-date"><abbr title="<?php echo $value[ 'post_date' ]; ?>"><?php echo $value[ 'post_date' ]; ?></abbr></td>

</tr>

<!-- End individual title -->

<?php

// if this title doesn't match next row's title, close the tbody

if ( !empty( $fix_duplicates_result[ $key + 1 ][ 'post_title' ] ) && trim( strtolower( $fix_duplicates_result[ $key + 1 ][ 'post_title' ] ) ) != trim( strtolower( $value[ 'post_title' ] ) ) ) : ?>

</tbody>

<?php endif;

endforeach;

?>

</table>

<!-- End table listing the duplicates -->

<!-- Bottom navigation area -->

<div class="tablenav bottom">

<div class="alignleft actions">

<select name='action2'>

<option value='-1' selected='selected'>Bulk Actions</option>

<option value='trash'>Trash Selected</option>

</select>

<input type="submit" name="" id="doaction2" class="button-secondary action" value="Apply" />

</div>

<!-- Form: nonce for security purposes -->

<?php // false because wp_http_referer is added recursively, making the URL too long. I don't use it anyway. ?>

<?php wp_nonce_field( 'fix_duplicates_main_form_nonce', '_wpnonce', false ); ?>

<!-- Form: End the bulk action form -->

</form>

<!-- Form: Paging controls -->

<?php // mostly links except 'jump to page'; using WordPress functions to build the links ?>

<div class='tablenav-pages<?php if ( $total_pages <= 1 ) echo ' one-page'; ?>'>

<span class="displaying-num"><?php echo $fix_duplicates_result_count; ?></span>

<span class="pagination-links">

<a class="first-page<?php if ( $total_pages > 1 && $page == 1 ) echo ' disabled'; ?>" title="Go to the first page" href="<?php echo esc_url( wp_nonce_url( add_query_arg( array( 'mode' => $current_mode, 'pageno' => '1', '_wpnonce' => false ) ), 'fix_duplicates_main_form_nonce' ) ); ?>">&laquo;</a>

<a class="prev-page<?php if ( $total_pages > 1 && $page == 1 ) echo ' disabled'; ?>" title="Go to the previous page" href="<?php echo esc_url( wp_nonce_url( add_query_arg( array( 'mode' => $current_mode, 'pageno' => $page - 1, '_wpnonce' => false ) ), 'fix_duplicates_main_form_nonce' ) ); ?>">&lsaquo;</a>

<span class="paging-input"><?php echo $page; ?> of <?php echo $total_pages; ?></span>

<a class="next-page<?php if ( $total_pages > 1 && $page == $total_pages ) echo ' disabled'; ?>" title="Go to the next page" href="<?php echo esc_url( wp_nonce_url( add_query_arg( array( 'mode' => $current_mode, 'pageno' => $page + 1, '_wpnonce' => false ) ), 'fix_duplicates_main_form_nonce' ) ); ?>">&rsaquo;</a>

<a class="last-page<?php if ( $total_pages > 1 && $page == $total_pages ) echo ' disabled'; ?>" title="Go to the last page" href="<?php echo esc_url( wp_nonce_url( add_query_arg( array( 'mode' => $current_mode, 'pageno' => $total_pages, '_wpnonce' => false ) ), 'fix_duplicates_main_form_nonce' ) ); ?>">&raquo;</a>

</span>

</div>

<br class="clear" />

</div>

<!-- End bottom navigation area -->

</div> <!-- class="inside" -->

</div> <!-- class="stuffbox" -->

<?php fix_duplicates_admin_asides(); ?>

</div> <!-- end id="poststuff" -->

<?php fix_duplicates_admin_footer(); ?>

</div> <!-- end class="wrap" -->

<?php

// check the nonce if we've got any URL parameters set (apart from page which is always set)

if ( ! check_admin_referer( 'fix_duplicates_main_form_nonce', 'wp_nonce' ) )

wp_die( 'Sorry, you cannot access this page directly' );

// Process the form POST actions by looping through them

fix_duplicates_process_post_actions();

die();

// check the nonce if we've got any URL parameters set (apart from page which is always set)

if ( ! check_admin_referer( 'fix_duplicates_main_form_nonce', 'wp_nonce' ) )

wp_die( 'Sorry, you cannot access this page directly' );

// Process the form POST actions by looping through them

fix_duplicates_process_trash_individual( absint( $_POST[ 'post' ] ), absint( $_POST[ 'redirect' ] ) );

die();

if ( wp_trash_post( $fix_duplicates_id_to_delete ) ) {

// if the premium plugin is present and redirection is requested, process the redirects

if ( ! empty ( $fix_duplicates_id_to_redirect ) && function_exists( 'fix_duplicates_redirection_process_save' ) ) {

$message = fix_duplicates_redirection_process_save( $fix_duplicates_id_to_delete, $fix_duplicates_id_to_redirect );

echo '<div id="message" class="updated"><p><strong>SUCCESS: The following item was moved to the <a href="' . admin_url( 'edit.php?post_status=trash' ) . '">Trash</a>: ' . $fix_duplicates_id_to_delete . $message . '</strong></p></div>';

}

else {

echo '<div id="message" class="updated"><p><strong>SUCCESS: The following item was moved to the <a href="' . admin_url( 'edit.php?post_status=trash' ) . '">Trash</a>: ' . $fix_duplicates_id_to_delete . '</strong></p></div>';

}

}

else {

echo '<div id="message" class="updated"><p><strong>ERROR: The following item was NOT deleted: ' . $fix_duplicates_id_to_delete . ' - please try again</strong></p></div>';

}

// arrays to record items to delete, items deleted and items redirected

$fix_duplicates_items_to_process = array();

$fix_duplicates_deleted_items = array();

$fix_duplicates_redirection_message = '';

// if we have $_POST['post'] set and either action or action2, then this is the bulk trash action

if ( !empty( $_POST[ 'post' ] ) && is_array( $_POST[ 'post' ] ) && ( esc_html( $_POST[ 'action' ] == 'trash' ) || esc_html( $_POST[ 'action2' ] == 'trash' ) ) ) {

// set the $fix_duplicates_items_to_process array to sanitized post array

$fix_duplicates_items_to_process = array_map( 'absint', $_POST[ 'post' ] );

// loop through the array of items to delete and delete them (recording their id to report as deleted)

foreach ( $fix_duplicates_items_to_process as $value ) {

if ( wp_trash_post( $value ) ) {

$fix_duplicates_deleted_items[] = $value;

}

}

}

// else if $_POST['duplicate_entry_all_apply'] is set, then this the bulk "Trash, keep and redirect" action

elseif ( esc_html( $_POST[ 'duplicate_entry_all_apply' ] ) ) {

// if this is set to one, then we are deleting all on this page

if ( absint( $_POST[ 'duplicate_entry_delete_all' ] ) ) {

foreach ( $_POST[ 'duplicate_entry_items_to_delete' ] as $key => $value ) {

// get the items to delete

$fix_duplicates_keep_newest = absint( $_POST[ 'duplicate_entry_keep_all' ] );

$fix_duplicates_items_to_process = explode( '+', esc_html( $value ) );

// call function to trash and redirect these

$fix_duplicates_redirect_please = 0;

if(!empty($_POST[ 'duplicate_entry_redirect_all' ])){

$fix_duplicates_redirect_please = absint( $_POST[ 'duplicate_entry_redirect_all' ] );

}

$fix_duplicates_delete_return_array = fix_duplicates_trash_and_redirect( $fix_duplicates_items_to_process, $fix_duplicates_keep_newest, $fix_duplicates_redirect_please );

$fix_duplicates_deleted_items = array_merge( $fix_duplicates_delete_return_array[0], $fix_duplicates_deleted_items );

}

}

// else we are deleting all duplicates via MySQL

else {

// set up the database details

global $wpdb;

$tablename = $wpdb->prefix . 'posts';

// get the list of custom post types, excluding revisions, attachments and nav_menu_item

$fix_duplicates_post_types = get_post_types( array( 'show_ui' => true ), 'objects' );

if ( isset( $fix_duplicates_post_types[ 'fix_dups_redirects' ] ) )

unset( $fix_duplicates_post_types[ 'fix_dups_redirects' ] );

// build the string

$post_type_string_array = array();

foreach ( $fix_duplicates_post_types as $key => $value ) {

$post_type_string_array[] = "$tablename.post_type = '$key'";

}

$post_type_string = '(' . implode( $post_type_string_array, ' OR ' ) . ')';

// set up whether we are using MAX (Newest) or MIN (oldest)

if ( absint( $_POST[ 'duplicate_entry_keep_all' ] ) ) {

$fix_duplicates_query_maxmin = 'MAX';

}

else {

$fix_duplicates_query_maxmin = 'MIN';

}

// delete the duplicates from the DB

$fix_duplicates_query =

"DELETE t1.* FROM $tablename AS t1 INNER JOIN (

SELECT post_title, $fix_duplicates_query_maxmin( $tablename.post_date ) AS minmax_date FROM $tablename

WHERE $post_type_string AND ( $tablename.post_status ='publish' OR $tablename.post_status ='draft' )

GROUP BY post_title HAVING COUNT(*)>1

) AS t2

ON (t1.post_title = t2.post_title AND t1.post_date <> t2.minmax_date)

WHERE " . str_replace( $tablename, 't1', $post_type_string ) . " AND t1.post_status ='publish' OR t1.post_status ='draft'";

$fix_duplicates_result = $wpdb->get_results( $fix_duplicates_query, ARRAY_A );

echo '<div id="message" class="updated"><p><strong>SUCCESS: The Delete All option has completed.</strong></p></div>';

}

}

// else it's from control row Apply and we have to loop through to see which one we're dealing with

else {

// loop through all the POST actions and work out what we're dealing with

foreach( $_POST as $key => $value ) {

// if this POST item is from an apply button

if ( stristr( esc_html( $key ), 'duplicate_entry_apply_' ) ) {

// get the number that apply was clicked for (slightly different for Ajax)

if ( strtolower( esc_html( $value ) ) == 'apply' ) {

$fix_duplicates_apply_no = absint( str_replace( esc_html( 'duplicate_entry_apply_' ), '', $key ) );

}

else {

$fix_duplicates_apply_no = absint( $value );

}

// get the details for that number

$fix_duplicates_keep_newest = absint( $_POST[ 'duplicate_entry_keep' ][ $fix_duplicates_apply_no ] );

$fix_duplicates_items_to_process = explode( '+', esc_html( $_POST[ 'duplicate_entry_items_to_delete' ][ $fix_duplicates_apply_no ] ) );

// call function to trash and redirect these

$fix_duplicates_redirect_please = absint( $_POST[ 'duplicate_entry_redirect' ][ $fix_duplicates_apply_no ] );

$fix_duplicates_delete_return_array = fix_duplicates_trash_and_redirect( $fix_duplicates_items_to_process, $fix_duplicates_keep_newest, $fix_duplicates_redirect_please );

$fix_duplicates_deleted_items = $fix_duplicates_delete_return_array[0];

$fix_duplicates_redirection_message = $fix_duplicates_delete_return_array[1];

}

}

}

// report on the items deleted

if ( count( $fix_duplicates_deleted_items ) == 0 ) {

echo '<div id="message" class="updated"><p><strong>ERROR: There are no duplicate entries to delete.</strong></p></div>';

}

else {

echo '<div id="message" class="updated"><p><strong>SUCCESS: The following items were moved to the <a href="' . admin_url( 'edit.php?post_status=trash' ) . '">Trash</a>: ' . implode( ', ', $fix_duplicates_deleted_items ) . $fix_duplicates_redirection_message . '</strong></p></div>';

}

// if they want to keep newest, remove the first item from the array, otherwise remove the last

if ( $fix_duplicates_keep_newest ) {

$fix_duplicate_redirect_target = array_shift( $fix_duplicates_items_to_process );

}

else {

$fix_duplicate_redirect_target = array_pop( $fix_duplicates_items_to_process );

}

// loop through the items to be deleted and delete them (recording their id to report as deleted)

$fix_duplicates_deleted_items = array();

$fix_duplicates_redirect_message = '';

foreach ( $fix_duplicates_items_to_process as $value ) {

if ( wp_trash_post( $value ) ) {

$fix_duplicates_deleted_items[] = $value;

// if the premium plugin is present and redirection is requested, process the redirects // NEED TO CREATE THIS AND WORK OUT WHAT TO PASS TO THEM

if ( function_exists( 'fix_duplicates_redirection_process_save' ) && $fix_duplicates_redirect_please ) {

$fix_duplicates_redirect_message = fix_duplicates_redirection_process_save( $value, $fix_duplicate_redirect_target );

}

}

}

// return the array of items deleted and the redirect success message

return array( $fix_duplicates_deleted_items, $fix_duplicates_redirect_message );

?>

<!-- Asides -->

<div class="fix-duplicates-asides">

<?php if ( ! function_exists( 'fix_duplicates_redirection_process_save' ) ) : ?>

<div class="fix-duplicates-aside">

<h2>Buy Pro Extensions</h2>

<p>Buy the following extensions (more coming soon):</p>

<ul>

<li><a target="_blank" href="http://scratch99.com/products/fix-duplicates/redirection/">Redirect duplicates for better SEO</li>

</ul>

<p><a class="fix-duplicates-buy-now" target="_blank" href="http://scratch99.com/products/fix-duplicates/#extensions">Buy extensions now!</a>.</p>

</div>

<?php endif; ?>

<div class="fix-duplicates-aside">

<h2>Get Help</h2>

<ul>

<li><a target="_blank" href="http://scratch99.com/products/fix-duplicates/documentation/">Read the documentation</a></li>

<li><a target="_blank" href="http://scratch99.com/products/fix-duplicates/#support">Learn about the support options</a></li>

</ul>

</div>

<div class="fix-duplicates-aside">

<h2>Support the plugin</h2>

<div class="facebook-widget">

<div id="fb-root"></div>

<script>(function(d, s, id) {

var js, fjs = d.getElementsByTagName(s)[0];

if (d.getElementById(id)) return;

js = d.createElement(s); js.id = id;

js.src = "//connect.facebook.net/en_GB/all.js#xfbml=1";

fjs.parentNode.insertBefore(js, fjs);

}(document, 'script', 'facebook-jssdk'));</script>

<div class="fb-like" data-href="http://scratch99.com/products/fix-duplicates/" data-send="false" data-layout="button_count" data-width="44" data-show-faces="false"></div>

</div>

<div class="twitter-widget">

<a href="https://twitter.com/share" class="twitter-share-button" data-url="http://scratch99.com/products/fix-duplicates/" data-text="I'm using the Fix Duplicates plugin for WordPress by @Scratch99Design -" data-count="none" data-hashtags="duplicates,WordPress">Tweet</a>

<script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src="//platform.twitter.com/widgets.js";fjs.parentNode.insertBefore(js,fjs);}}(document,"script","twitter-wjs");</script>

</div>

<!-- Place this tag where you want the +1 button to render. -->

<div class="g-plusone" data-size="medium" data-annotation="none" data-href="http://scratch99.com/products/fix-duplicates/"></div>

<!-- Place this tag after the last +1 button tag. -->

<script type="text/javascript">

(function() {

var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true;

po.src = 'https://apis.google.com/js/plusone.js';

var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s);

})();

</script>

</div>

<div class="fix-duplicates-aside">

<h2>Hire me!</h2>

<p>Scratch99 Design provides rock-solid professional services, including:

<ul>

<li>WordPress development / consultation</li>

<li>Website optimisation</li>

<li>Content strategy advice</li>

<li>Other web related services</li>

</ul>

<a target="_blank" href="http://scratch99.com/services/">Contact me</a> for more information.

</p>

</div>

</div> <!-- class="stuffbox" -->

<?php