/**
* Hook into admin AJAX to delete a link
*
* @todo write method
*
* @access public
* @return void
*/
public function run()
{
// Check nonce
check_ajax_referer(RP4WP_Constants::NONCE_AJAX, 'nonce');
try {
// Parent
if (!isset($_POST['parent'])) {
throw new Exception('Parent not set');
}
// Parent and post types
$parent = sanitize_text_field($_POST['parent']);
// Check if user is allowed to do this
if (!current_user_can('edit_posts')) {
return;
}
// Related post manager
$related_post_manager = new RP4WP_Related_Post_Manager();
// Remove linked related posts
$related_post_manager->remove_linked_posts($parent);
// Add the post types
$ptm = new RP4WP_Post_Type_Manager();
// get children of parent
$children = $ptm->get_installed_post_type($parent);
// Related word manager
$word_manager = new RP4WP_Related_Word_Manager();
// always delete parent words
$word_manager->delete_words_by_post_type($parent);
// check if there are children
if (count($children) > 0) {
// loop
foreach ($children as $child) {
// delete children words
$word_manager->delete_words_by_post_type($child);
}
}
// Redirect to setup reinstall
$redirect = true;
// Success response
$response = array('result' => 'success', 'redirect' => $redirect);
} catch (Exception $e) {
// Failure response
$response = array('result' => 'failure', 'redirect' => false, 'error' => $e->getMessage());
}
// Send response
wp_send_json($response);
}
public function run()
{
// Check nonce
check_ajax_referer(RP4WP_Constants::NONCE_AJAX, 'nonce');
// Get the PPR
$ppr = isset($_POST['ppr']) ? $_POST['ppr'] : 25;
// Check if Post Type is set
if (!isset($_POST['pt'])) {
echo 'No Post Type set!';
exit;
}
if (!isset($_POST['linked_pt_cur'])) {
echo 'No linked_pt_cur set!';
exit;
}
// Post Type
$post_type = $_POST['pt'];
// Current index of linked posts
$linked_pt_cur = $_POST['linked_pt_cur'];
// Get the available post types
$ptm = new RP4WP_Post_Type_Manager();
// Get children
$pt_children = $ptm->get_installed_post_type($post_type);
// Adding parent post type to the 'to be linked' array
array_unshift($pt_children, $post_type);
// Check if the current linked post type exists
if (!isset($pt_children[$linked_pt_cur])) {
echo 'Linked post type not set';
exit;
}
// Related Post Manager
$related_word_manager = new RP4WP_Related_Word_Manager();
// Save words
$related_word_manager->save_all_words($pt_children[$linked_pt_cur], $ppr);
// Get uncached post count
$uncached_post_count = $related_word_manager->get_uncached_post_count($pt_children[$linked_pt_cur]);
// Echo the uncached posts
echo $uncached_post_count;
exit;
}
/**
* Prepare the items
*/
public function prepare_items()
{
// Get current view
$view = $this->get_current_view();
// Check if we're in the related view
if ('related' == $view) {
$this->is_related = true;
}
// Set table properties
$columns = $this->get_columns();
$hidden = array();
$sortable = $this->get_sortable_columns();
$this->_column_headers = array($columns, $hidden, $sortable);
// pagination and sorting
$screen = get_current_screen();
$per_page = absint(get_user_meta(get_current_user_id(), $screen->get_option('per_page', 'option'), true));
$per_page = $per_page > 0 ? $per_page : 20;
$paged = absint(isset($_GET['paged']) ? $_GET['paged'] : 1);
$orderby = isset($_GET['orderby']) ? $_GET['orderby'] : 'title';
$order = isset($_GET['order']) ? $_GET['order'] : 'asc';
// views
$this->views();
// Set search
if (null !== $this->search) {
add_filter('posts_where', array($this, 'filter_posts_where'));
}
// Get Data
$this->data = array();
// Get posts
if ('all' == $view) {
// Post Type Manager
$pt_manager = new RP4WP_Post_Type_Manager();
// Get linked posts
$linked_post_types = $pt_manager->get_installed_post_type($this->post_type);
// posts
$posts = array();
// the posts query
$post_query = new WP_Query(array('post_type' => $linked_post_types, 'posts_per_page' => $per_page, 'paged' => $paged, 'suppress_filters' => false, 'orderby' => $orderby, 'order' => $order, 'post_status' => apply_filters('rp4wp_manual_link_post_statuses', array('publish', 'private'))));
// Format data for table
if ($post_query->have_posts()) {
while ($post_query->have_posts()) {
$posts[] = $post_query->next_post();
}
}
} else {
$rpm = new RP4WP_Related_Post_Manager();
$parent = intval($_GET['rp4wp_parent']);
$posts = $rpm->get_related_posts($parent, $this->post_type, 25);
}
// Format data for table
if (count($posts) > 0) {
foreach ($posts as $post) {
// Related results only contain ID to keep query fast. Rather have an extra query per post on manual linking than a much heavier query for all linking.
if (!isset($post->post_title)) {
$post = get_post($post->ID);
}
$this->data[] = array('ID' => $post->ID, 'title' => $post->post_title, 'post_type' => $post->post_type);
}
}
// Remove search filter
remove_filter('posts_where', array($this, 'filter_posts_where'));
// Pagination only for all view
if ('all' == $view) {
$this->set_pagination_args(array('total_items' => $post_query->found_posts, 'per_page' => $per_page));
}
// Set items
$this->items = $this->data;
}
/**
* The screen content
*
* @since 1.0.0
* @access public
*/
public function content()
{
// Check nonce
$installer_nonce = isset($_GET['rp4wp_nonce']) ? $_GET['rp4wp_nonce'] : '';
if (!wp_verify_nonce($installer_nonce, RP4WP_Constants::NONCE_INSTALL)) {
wp_die('Woah! It looks like something else tried to run the Related Posts for WordPress installation wizard! We were able to stop them, nothing was lost. Please report this incident at <a href="http://wordpress.org/support/plugin/related-posts-for-wp" target="_blank">our forums.</a>');
}
// The steps
$steps = array(1 => __('Welcome', 'related-posts-for-wp'), 2 => __('Caching Posts', 'related-posts-for-wp'), 3 => __('Linking Posts', 'related-posts-for-wp'), 4 => __('Finished', 'related-posts-for-wp'));
// What's the current step?
$cur_step = intval(isset($_GET['step']) ? $_GET['step'] : 1);
// Set the post type in var
$post_type = esc_html(isset($_GET['pt']) ? $_GET['pt'] : '');
// Check if the post type is set
if ($cur_step > 1 && empty($post_type)) {
wp_die(sprintf(__('Missing post type parameter, please report this incident via %sour website%s.', 'related-posts-for-wp'), '<a href="https://www.relatedpostsforwp.com/support/" target="_blank">', '</a>'));
}
// Try to create the cache table if we're in step 1 and this is a multisite
if (1 == $cur_step && is_multisite()) {
require_once plugin_dir_path(RP4WP_PLUGIN_FILE) . 'includes/installer-functions.php';
rp4wp_premium_create_db_table();
}
// Check installer resume options
if (2 == $cur_step) {
// Add is installing site option
add_option(RP4WP_Constants::OPTION_IS_INSTALLING, $post_type);
// Get current linked post type
$linked_pt_cur = absint(isset($_GET['cur']) ? $_GET['cur'] : 0);
// Get the available post types
$ptm = new RP4WP_Post_Type_Manager();
$linked_pt_count = count($ptm->get_installed_post_type($post_type));
} elseif (4 == $cur_step) {
// Installer is done, remove the option
delete_option(RP4WP_Constants::OPTION_IS_INSTALLING);
}
?>
<div class="wrap">
<h2>Related Posts for WordPress <?php
_e('Installation', 'related-posts-for-wp');
?>
</h2>
<ul class="install-steps">
<?php
foreach ($steps as $step => $label) {
echo "<li id='step-bar-" . $step . "'" . ($cur_step == $step ? " class='step-bar-active'" : "") . "><span>" . $step . '. ' . $label . "</span></li>" . PHP_EOL;
}
?>
</ul>
<br class="clear" />
<h3><?php
echo $steps[$cur_step];
?>
</h3>
<?php
echo "<div class='rp4wp-step rp4wp-step-" . $cur_step . "' rel='" . $cur_step . "'>";
// Hidden fields
echo "<input type='hidden' id='rp4wp_admin_url' value='" . admin_url() . "' />" . PHP_EOL;
// Echo the post type & total posts when post type is set
if (!empty($post_type)) {
echo "<input type='hidden' id='rp4wp_post_type' value='" . $post_type . "' />" . PHP_EOL;
echo "<input type='hidden' id='rp4wp_total_posts' value='" . wp_count_posts($post_type)->publish . "' />" . PHP_EOL;
}
// Echo the amount of linked post types
if (isset($linked_pt_count)) {
echo "<input type='hidden' id='linked_pt_count' value='" . $linked_pt_count . "' />" . PHP_EOL;
}
// Echo the current linked post type
if (isset($linked_pt_cur)) {
echo "<input type='hidden' id='linked_pt_cur' value='" . $linked_pt_cur . "' />" . PHP_EOL;
}
// Echo the nonce
if (!empty($installer_nonce)) {
echo "<input type='hidden' id='rp4wp_nonce' value='" . $installer_nonce . "' />" . PHP_EOL;
}
// AJAX nonce
echo '<input type="hidden" name="rp4wp-ajax-nonce" id="rp4wp-ajax-nonce" value="' . wp_create_nonce(RP4WP_Constants::NONCE_AJAX) . '" />';
switch ($cur_step) {
case 1:
?>
<p><?php
_e('Thank you for choosing Related Posts for WordPress!', 'related-posts-for-wp');
?>
</p>
<p><?php
_e("Below you'll find your post types available for installation, by installing a post type we'll set up a cache and offer you the ability to automatic link (custom) posts. To install a post type, simply click the 'Install Post Type' button.", 'related-posts-for-wp');
?>
</p>
<h3>Post Types</h3>
<?php
// Get the available post types
$ptm = new RP4WP_Post_Type_Manager();
// Get installed post types
$installed_post_types = $ptm->get_installed_post_types();
// Available post types
$available_post_types = $ptm->get_available_post_types();
echo '<input type="hidden" id="rp4wp-availabe_post_types" value="' . implode(',', array_keys($available_post_types)) . '" />';
echo '<table cellpadding="0" cellspacing="0" border="0" class="rp4wp-table-pt-overview">' . PHP_EOL;
echo "<tr>" . PHP_EOL;
echo "<th>" . __('Post Type', 'related-posts-for-wp') . "</th>" . PHP_EOL;
echo "<th>" . __('Related to Post Types', 'related-posts-for-wp') . "</th>" . PHP_EOL;
echo "<th> </th>" . PHP_EOL;
echo "</tr>" . PHP_EOL;
// Da loop
if (count($available_post_types) > 0) {
foreach ($available_post_types as $pt_key => $pt_label) {
$is_active = false;
if (isset($installed_post_types[$pt_key]) && count($installed_post_types[$pt_key]) > 0) {
$is_active = true;
}
echo '<tr rel="' . $pt_key . '" ' . (!$is_active ? 'class="inactive"' : '') . '>';
echo '<td class="rp4wp-parent">' . $pt_label . '</td>' . PHP_EOL;
echo '<td class="rp4wp-children">';
echo '<ul>' . PHP_EOL;
if ($is_active) {
foreach ($installed_post_types[$pt_key] as $linked_pt) {
echo '<li id="' . $linked_pt . '"><span>' . $available_post_types[$linked_pt] . '</span></li>' . PHP_EOL;
}
}
echo '</ul>' . PHP_EOL;
echo '</td>' . PHP_EOL;
echo '<td class="rp4wp-button">';
echo '<div class="rp4wp-buttons-wrap">' . PHP_EOL;
echo '<a href="javascript:;" class="button button-primary rp4wp-btn-edit rp4wp-has-tip" title="' . __('Edit this post type', 'related-posts-for-wp') . '" rel="edit"></a>';
echo '</div>' . PHP_EOL;
echo '</td>' . PHP_EOL;
echo '</tr>';
}
}
echo '</table>' . PHP_EOL;
break;
case 2:
// Echo current uncached posts
$related_word_manager = new RP4WP_Related_Word_Manager();
// amount of posts needs caching
$posts_todo = $related_word_manager->get_uncached_post_count($post_type);
echo "<input type='hidden' id='rp4wp_posts_todo' value='" . $posts_todo . "' />" . PHP_EOL;
?>
<p><?php
_e('Thank you for choosing Related Posts for WordPress!', 'related-posts-for-wp');
?>
</p>
<p><?php
_e('Before you can start using Related Posts for WordPress we need to cache your current posts.', 'related-posts-for-wp');
?>
</p>
<p><?php
_e("This is a one time process which might take some time now, depending on the amount of posts you have, but will ensure your website's performance when using the plugin.", 'related-posts-for-wp');
?>
</p>
<p style="font-weight: bold;"><?php
_e('Do NOT close this window, wait for this process to finish and this wizard to take you to the next step.', 'related-posts-for-wp');
?>
</p>
<div id="progress-container">
<div id="progressbar"></div>
<p>Todo: <span id="progress-todo"><?php
echo $posts_todo;
?>
</span></p>
<p>Done: <span id="progress-done">0</span></p>
</div>
<?php
break;
case 3:
// Echo current unlinked posts
$related_post_manager = new RP4WP_Related_Post_Manager();
// amount of posts need linking
$posts_todo = $related_post_manager->get_unlinked_post_count($post_type);
echo "<input type='hidden' id='rp4wp_posts_todo' value='" . $posts_todo . "' />" . PHP_EOL;
// Get the automatic linking post amount
$alpa = 3;
if (isset(RP4WP()->settings['general_' . $post_type])) {
$alpa = RP4WP()->settings['general_' . $post_type]->get_option('automatic_linking_post_amount');
}
// get the post age
// Get the automatic linking post amount
$max_post_age = 0;
if (isset(RP4WP()->settings['general_' . $post_type])) {
$max_post_age = RP4WP()->settings['general_' . $post_type]->get_option('max_post_age');
}
?>
<p style="font-weight: bold;"><?php
_e('Great! All your posts were successfully cached!', 'related-posts-for-wp');
?>
</p>
<p><?php
_e("You can let me link your posts, based on what I think is related, to each other. And don't worry, if I made a mistake at one of your posts you can easily correct this by editing it manually!", 'related-posts-for-wp');
?>
</p>
<p><?php
_e('Want me to start linking posts to each other? Fill in the amount of related posts each post should have and click on the "Link now" button. Rather link your posts manually? Click "Skip linking".', 'related-posts-for-wp');
?>
</p>
<p style="font-weight: bold;"><?php
_e('Do NOT close this window if you click the "Link now" button, wait for this process to finish and this wizard to take you to the next step.', 'related-posts-for-wp');
?>
</p>
<br class="clear"/>
<div class="rp4wp-install-link-box">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td><label for="rp4wp_related_posts_amount"><?php
_e('Amount of related posts:', 'related-posts-for-wp');
?>
</label></td>
<td><input class="form-input-tip" type="text" id="rp4wp_related_posts_amount" value="<?php
echo $alpa;
?>
" /></td>
<td class="rp4pw-install-step3-table-desc"><?php
printf(__('The amount of related items per %s', 'related-posts-for-wp'), $post_type);
?>
</td>
</tr>
<tr>
<td><label for="rp4wp_related_posts_age"><?php
_e('Maximum Post Age:', 'related-posts-for-wp');
?>
</label></td>
<td><input class="form-input-tip" type="text" id="rp4wp_related_posts_age" value="<?php
echo $max_post_age;
?>
"/></td>
<td class="rp4pw-install-step3-table-desc"><?php
printf(__('The maximum age in days of %s that will be linked. (0 = unlimited)', 'related-posts-for-wp'), $post_type);
?>
</td>
</tr>
<tr>
<td> </td>
<td colspan="2" class="rp4pw-install-step3-table-buttons">
<a href="javascript:;" class="button button-primary button-large rp4wp-link-now-btn" id="rp4wp-link-now"><?php
_e('Link now', 'related-posts-for-wp');
?>
</a>
<a href="<?php
echo admin_url(sprintf('?page=rp4wp_install&step=4&pt=%s&&rp4wp_nonce=%s', $post_type, wp_create_nonce(RP4WP_Constants::NONCE_INSTALL)));
?>
" class="button"><?php
_e('Skip linking', 'related-posts-for-wp');
?>
</a>
</td>
</tr>
</table>
</div>
<br class="clear"/>
<div id="progress-container">
<div id="progressbar"></div>
<p>Todo: <span id="progress-todo"><?php
echo $posts_todo;
?>
</span></p>
<p>Done: <span id="progress-done">0</span></p>
</div>
<?php
break;
case 4:
?>
<p><?php
_e("That's it, you're good to go!", 'related-posts-for-wp');
?>
</p>
<p><?php
printf(__('Thanks again for using Related Posts for WordPress and if you have any questions be sure to ask them at the %sWordPress.org forums.%s', 'related-posts-for-wp'), '<a href="http://wordpress.org/support/plugin/related-posts-for-wp" target="_blank">', '</a>');
?>
</p>
<p>
<a href="<?php
echo admin_url(sprintf('?page=rp4wp_install&rp4wp_nonce=%s', wp_create_nonce(RP4WP_Constants::NONCE_INSTALL)));
?>
"
class="button button-primary"><?php
_e('Click here to return to step 1', 'related-posts-for-wp');
?>
</a>
</p>
<p>
<?php
$local_settings = (array) RP4WP()->settings;
$first_setting = array_shift($local_settings);
echo '<a href="' . admin_url('options-general.php?page=' . $first_setting->get_page()) . '" class="button button-primary">' . __('Click here to go to the settings page', 'related-posts-for-wp') . '</a>';
?>
</p>
<?php
}
?>
</div>
</div>
<?php
}
/**
* Hook into admin AJAX to delete a link
*
* @access public
* @return void
*/
public function run()
{
// Check nonce
check_ajax_referer(RP4WP_Constants::NONCE_AJAX, 'nonce');
try {
// Parent
if (!isset($_POST['parent'])) {
throw new Exception('Parent not set');
}
// Parent and post types
$parent = sanitize_text_field($_POST['parent']);
$post_types = array_map('sanitize_text_field', isset($_POST['post_types']) ? $_POST['post_types'] : array());
// Check if user is allowed to do this
if (!current_user_can('edit_posts')) {
return;
}
// Related post manager
$related_post_manager = new RP4WP_Related_Post_Manager();
// Remove linked related posts
$related_post_manager->remove_linked_posts($parent);
// Add the post types
$ptm = new RP4WP_Post_Type_Manager();
// Check if we're adding or removing
if (count($post_types) > 0) {
// Add the post type
$ptm->add_post_type($parent, $post_types);
// Let's go0oo
$redirect = true;
} else {
// get children of parent
$children = $ptm->get_installed_post_type($parent);
// Remove post type
$ptm->remove_post_type($parent);
// Related word manager
$word_manager = new RP4WP_Related_Word_Manager();
// check if parent is used as child in any other relations
if (false === $ptm->is_post_type_used($parent)) {
// delete word cache of parent
$word_manager->delete_words_by_post_type($parent);
}
// check if there are children
if (count($children) > 0) {
// loop
foreach ($children as $child) {
// check if this child post type is used in any other relation
if (false === $ptm->is_post_type_used($child)) {
// delete words
$word_manager->delete_words_by_post_type($child);
}
}
}
// No redirect needed
$redirect = false;
}
// Success response
$response = array('result' => 'success', 'redirect' => $redirect);
} catch (Exception $e) {
// Failure response
$response = array('result' => 'failure', 'redirect' => false, 'error' => $e->getMessage());
}
// Send response
wp_send_json($response);
}
/**
* Get related posts by post id and post type
*
* @param int $post_id
* @param String $post_type
* @param int $limit
*
* @return array
*/
public function get_related_posts($post_id, $post_type, $limit = -1)
{
global $wpdb;
// Post Type Manager
$ptm = new RP4WP_Post_Type_Manager();
// Int y'all
$post_id = intval($post_id);
// Related post types
$related_post_types = $ptm->get_installed_post_type($post_type);
// Only continue of we've got > 1 related post type
if (0 === count($related_post_types)) {
return array();
}
// Format the related post types
$formatted_post_types = "( '" . implode("','", esc_sql($related_post_types)) . "' )";
// Get max post age
$max_post_age = 0;
if (isset(RP4WP::get()->settings['general_' . $post_type])) {
// set the correct options from step 3
$max_post_age = intval(RP4WP::get()->settings['general_' . $post_type]->get_option('max_post_age'));
}
// Build SQl
$sql = "\n\t\tSELECT R.`post_id` AS `ID`\n\t\tFROM `" . RP4WP_Related_Word_Manager::get_database_table() . "` O\n\t\tINNER JOIN `" . RP4WP_Related_Word_Manager::get_database_table() . "` R ON R.`word` = O.`word` ";
// only join post table when max post age is set
if ($max_post_age > 0) {
$sql .= "INNER JOIN `" . $wpdb->posts . "` P ON P.`ID` = R.`post_id`";
}
// add WHERE statements
$sql .= "\n\t\tWHERE 1=1\n\t\tAND O.`post_id` = %d\n\t\tAND R.`post_type` IN " . $formatted_post_types . "\n\t\tAND R.`post_id` != %d\n\t\t";
// get excluded ids
$excluded_ids = get_option(RP4WP_Constants::OPTION_EXCLUDED, '');
// check if there are excluded ids
if (false !== $excluded_ids && !empty($excluded_ids)) {
// add excluded where statement to query
$sql .= "AND R.`post_id` NOT IN (" . $excluded_ids . ")\n\t\t\t";
}
// check if we got a maximum post age for this post type
// check is max post age is > 0
if ($max_post_age > 0) {
// calculate date in past
$date_time_oldest = new DateTime();
$date_time_oldest = $date_time_oldest->modify('-' . $max_post_age . 'days');
// make the post age key filterable
$post_age_column = apply_filters('rp4wp_post_age_column', 'post_date');
// add to SQL
$sql .= "AND P.`" . $post_age_column . "` >= '" . $date_time_oldest->format('Y-m-d') . "'\n\t\t\t\t";
}
// add group by and order by to SQL
$sql .= "GROUP BY R.`post_id`\n\t\tORDER BY SUM( R.`weight` ) DESC\n\t\t";
// Check & Add Limit
if (-1 != $limit) {
$sql .= "\n\t\t\tLIMIT 0,%d";
// Prepare SQL
$sql = $wpdb->prepare($sql, $post_id, $post_id, $limit);
} else {
// Prepare SQL
$sql = $wpdb->prepare($sql, $post_id, $post_id);
}
// Allow filtering of SQL to find related posts
$sql = apply_filters('rp4wp_get_related_posts_sql', $sql, $post_id, $post_type, $limit);
// Get post from related cache
return $wpdb->get_results($sql);
}
