public function run($post_id)
{
// Check if the current user can delete posts
if (!current_user_can('delete_posts')) {
return;
}
// Related Post Manager
$related_word_manager = new RP4WP_Related_Word_Manager();
$related_word_manager->delete_words_by_post_id($post_id);
}
public function run()
{
// Get the PPR
$ppr = isset($_POST['ppr']) ? $_POST['ppr'] : 25;
// Related Post Manager
$related_word_manager = new RP4WP_Related_Word_Manager();
// Save words
$related_word_manager->save_all_words($ppr);
// Get uncached post count
$uncached_post_count = $related_word_manager->get_uncached_post_count();
// Echo the uncached posts
echo $uncached_post_count;
exit;
}
public function run()
{
// Check nonce
check_ajax_referer(RP4WP_Constants::NONCE_AJAX, 'nonce');
// Get the PPR
$ppr = isset($_POST['ppr']) ? $_POST['ppr'] : 25;
// Related Post Manager
$related_word_manager = new RP4WP_Related_Word_Manager();
// Save words
$related_word_manager->save_all_words($ppr);
// Get uncached post count
$uncached_post_count = $related_word_manager->get_uncached_post_count();
// Echo the uncached posts
echo $uncached_post_count;
exit;
}
/**
* 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($new_status, $old_status, $post)
{
// verify this is not an auto save routine.
if (defined('DOING_AUTOSAVE') && DOING_AUTOSAVE) {
return;
}
// Only count on post type 'post'
if ('post' != $post->post_type) {
return;
}
// Post status must be publish
if ('publish' != $new_status) {
return;
}
// Save Words
$related_word_manager = new RP4WP_Related_Word_Manager();
$related_word_manager->save_words_of_post($post->ID);
}
public function run($new_status, $old_status, $post)
{
// verify this is not an auto save routine.
if (defined('DOING_AUTOSAVE') && DOING_AUTOSAVE) {
return;
}
// Post status must be publish
if ('publish' != $new_status) {
return;
}
// Check if this post type is installed
$pt_manager = new RP4WP_Post_Type_Manager();
if (!$pt_manager->is_post_type_installed($post->post_type)) {
return;
}
// Save Words
$related_word_manager = new RP4WP_Related_Word_Manager();
$related_word_manager->save_words_of_post($post->ID, $post->post_type);
}
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;
}
public function run($post_id, $post)
{
// verify this is not an auto save routine.
if (defined('DOING_AUTOSAVE') && DOING_AUTOSAVE) {
return;
}
// Only count on post type 'post'
if ('post' != $post->post_type) {
return;
}
// Check permission
if (!current_user_can('edit_post', $post_id)) {
return;
}
// Post status must be publish
if ('publish' != $post->post_status) {
return;
}
// Save Words
$related_word_manager = new RP4WP_Related_Word_Manager();
$related_word_manager->save_words_of_post($post_id);
}
/**
* Get related posts by post id and post type
*
* @param $post_id
*
* @return array
*/
public function get_related_posts($post_id, $limit = -1)
{
global $wpdb;
// Build SQl
$sql = "\n\t\tSELECT O.`word`, P.`ID`, P.`post_title`, SUM( R.`weight` ) AS `related_weight`\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`\n\t\tINNER JOIN `" . $wpdb->posts . "` P ON P.`ID` = R.`post_id`\n\t\tWHERE 1=1\n\t\tAND O.`post_id` = %d\n\t\tAND R.`post_type` = 'post'\n\t\tAND R.`post_id` != %d\n\t\tAND P.`post_status` = 'publish'\n\t\tGROUP BY P.`id`\n\t\tORDER BY `related_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);
// Get post from related cache
return $wpdb->get_results($sql);
}
/**
* The screen content
*
* @since 1.0.0
* @access public
*/
public function content()
{
// Do we have a reinstall?
if (isset($_GET['reinstall'])) {
// Check nonce
if (!wp_verify_nonce(isset($_GET['rp4wp_nonce']) ? $_GET['rp4wp_nonce'] : '', RP4WP_Constants::NONCE_REINSTALL)) {
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>');
}
global $wpdb;
// Get ID's of related post link posts
$link_ids = get_posts(array('post_type' => RP4WP_Constants::LINK_PT, 'fields' => 'ids', 'posts_per_page' => -1));
// Only run queries if we have ID's
if (count($link_ids) > 0) {
// Delete all link posts
$wpdb->query("DELETE FROM {$wpdb->posts} WHERE `ID` IN (" . implode(",", $link_ids) . ");");
// Delete all link post meta
$wpdb->query("DELETE FROM {$wpdb->postmeta} WHERE `post_id` IN (" . implode(",", $link_ids) . ");");
}
// Remove the post meta we attached to posts
$wpdb->query("DELETE FROM {$wpdb->postmeta} WHERE `meta_key` = 'rp4wp_auto_linked' OR `meta_key` = 'rp4wp_cached' ");
// Empty word cache
$wpdb->query("DELETE FROM " . RP4WP_Related_Word_Manager::get_database_table() . " WHERE 1=1");
}
// The steps
$steps = array(1 => __('Caching Posts', 'related-posts-for-wp'), 2 => __('Linking Posts', 'related-posts-for-wp'), 3 => __('Finished', 'related-posts-for-wp'));
// What's the current step?
$cur_step = isset($_GET['step']) ? $_GET['step'] : 1;
// Check installer resume options
if (1 == $cur_step) {
// Add is installing site option
add_site_option(RP4WP_Constants::OPTION_IS_INSTALLING, true);
} elseif (3 == $cur_step) {
// Installer is done, remove the option
delete_site_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
$cur_step = isset($_GET['step']) ? $_GET['step'] : 1;
echo "<div class='rp4wp-step rp4wp-step-" . $cur_step . "' rel='" . $cur_step . "'>";
echo "<input type='hidden' id='rp4wp_total_posts' value='" . wp_count_posts('post')->publish . "' />" . PHP_EOL;
echo "<input type='hidden' id='rp4wp_admin_url' value='" . admin_url() . "' />" . PHP_EOL;
if (1 == $cur_step) {
// Echo current uncached posts
$related_word_manager = new RP4WP_Related_Word_Manager();
echo "<input type='hidden' id='rp4wp_uncached_posts' value='" . $related_word_manager->get_uncached_post_count() . "' />" . 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="progressbar"></div>
<?php
} elseif (2 == $cur_step) {
// Echo current uncached posts
$related_post_manager = new RP4WP_Related_Post_Manager();
echo "<input type='hidden' id='rp4wp_uncached_posts' value='" . $related_post_manager->get_uncached_post_count() . "' />" . PHP_EOL;
?>
<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" />
<p class="rp4wp-install-link-box">
<label for="rp4wp_related_posts_amount"><?php
_e('Amount of related posts per post:', 'related-posts-for-wp');
?>
</label><input class="form-input-tip" type="text" id="rp4wp_related_posts_amount" value="<?php
echo RP4WP()->settings->get_option('automatic_linking_post_amount');
?>
" />
<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();
?>
?page=rp4wp_install&step=3" class="button"><?php
_e('Skip linking', 'related-posts-for-wp');
?>
</a>
</p>
<br class="clear" />
<div id="progressbar"></div>
<?php
} elseif (3 == $cur_step) {
?>
<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>
<?php
}
?>
</div>
</div>
<?php
}
/**
* 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
}
/**
* Install a post type. This includes caching and linking post types.
*
* ## OPTIONS
*
* <post_type>
* : The post type where related posts are linked to
*
* <linked_post_types>
* : The post types (comma separated) which are linked to the first argument
*
* <rel_amount>
* : The amount of related posts per post
*
* [<max_post_age>]
* : The maximum age of a related post in days
*
* ## EXAMPLE
*
* wp rp4wp remove_related post
*
* @synopsis <post_type> <linked_post_types> <rel_amount> [<max_post_age>]
*/
public function install($args, $assoc_args)
{
// args
$post_type = trim($args[0]);
$linked_post_types = explode(',', trim($args[1]));
$rel_amount = intval($args[2]);
$max_post_age = intval(isset($args[3]) ? $args[3] : 0);
// we need at least one linked post type to continue
if (count($linked_post_types) > 0) {
/**
* SETTINGS
*/
// set the linked post types
$ptm = new RP4WP_Post_Type_Manager();
$ptm->add_post_type($post_type, $linked_post_types);
// set the post type options
if (isset(RP4WP::get()->settings['general_' . $post_type])) {
$options = RP4WP::get()->settings['general_' . $post_type]->get_options();
$options['automatic_linking_post_amount'] = $rel_amount;
$options['max_post_age'] = $max_post_age;
update_option('rp4wp_general_' . $post_type, $options);
}
/**
* CACHE POSTS
*/
WP_CLI::line('Caching Words');
// related word manage
$related_word_manager = new RP4WP_Related_Word_Manager();
// cache words of parent post type
$related_word_manager->save_all_words($post_type);
// cache words of linked post types
foreach ($linked_post_types as $linked_post_type) {
$related_word_manager->save_all_words($linked_post_type);
}
/**
* LINK POSTS
*/
WP_CLI::line('Linking Posts');
$related_post_manager = new RP4WP_Related_Post_Manager();
$related_post_manager->link_related_posts($rel_amount, $post_type);
// output success
WP_CLI::success(sprintf('Successfully installed %s', $post_type));
}
}
/**
* 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);
}
/**
* Remove all links from post type
*
* ## OPTIONS
*
* <lang>
* : The language
*
* ## EXAMPLE
*
* wp rp4wp-dev dedupe_words nl_NL
*
* @synopsis <lang>
*/
public function dedupe_words($args)
{
$wm = new RP4WP_Related_Word_Manager();
$wm->dedupe_and_order_ignored_words($args[0]);
}
/**
* 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);
}
