File: //home/dfwparty/dfwchat.net/wp-content/themes/buddyboss-theme/inc/plugins/related-posts-helper.php
<?php
/**
* Related Posts Helper Functions
*/
namespace BuddyBossTheme;
if ( ! class_exists( '\BuddyBossTheme\RelatedPostsHelper' ) ) {
class RelatedPostsHelper {
protected $_is_active = false;
/**
* Constructor
*/
public function __construct() {
add_action( 'after_switch_theme', array( $this, 'crp_create_index' ) );
}
public function set_active() {
$this->_is_active = true;
}
public function is_active() {
return $this->_is_active;
}
public function crp_create_index() {
global $wpdb;
/**
* Filter to disable related posts index creation.
*
* @since 2.17.0
*
* @param bool $disable Whether to disable index creation. Default false.
*/
if ( apply_filters( 'bb_disable_related_posts_index', false ) ) {
return;
}
try {
$wpdb->hide_errors();
// Check if all indexes already exist - if so, return early.
$existing_indexes = $wpdb->get_var(
"SELECT COUNT(DISTINCT INDEX_NAME) FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_SCHEMA = DATABASE()
AND TABLE_NAME = '{$wpdb->posts}'
AND INDEX_NAME IN ('crp_related', 'crp_related_title', 'crp_related_content')"
);
if ( 3 === (int) $existing_indexes ) {
$wpdb->show_errors();
return;
}
$mysql_server_type = $wpdb->db_server_info();
$mysql_server_version = $wpdb->db_version();
$is_mariadb = false;
if ( stristr( $mysql_server_type, 'mariadb' ) ) {
$is_mariadb = true;
// Account for MariaDB version being prefixed with '5.5.5-' on older PHP 8.0.15 versions.
if ( '5.5.5' === $mysql_server_version && PHP_VERSION_ID < 80016 ) {
$mysql_server_type = preg_replace( '/^5\.5\.5-(.*)/', '$1', $mysql_server_type );
$mysql_server_version = preg_replace( '/[^0-9.].*/', '', $mysql_server_type );
}
}
if ( $is_mariadb && version_compare( 10.3, $mysql_server_version, '<=' ) ) {
$table_engine = 'InnoDB';
} elseif ( ! $is_mariadb && version_compare( 5.6, $mysql_server_version, '<=' ) ) {
$table_engine = 'InnoDB';
} else {
$table_engine = 'MyISAM';
}
$current_engine = $wpdb->get_row(
"
SELECT engine FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema=DATABASE()
AND table_name = '{$wpdb->posts}'
"
);
if ( isset( $current_engine->engine ) && $current_engine->engine !== $table_engine ) {
$wpdb->query( "ALTER TABLE {$wpdb->posts} ENGINE = {$table_engine};" ); // WPCS: unprepared SQL OK.
}
if ( ! $wpdb->get_results( "SHOW INDEX FROM {$wpdb->posts} where Key_name = 'crp_related'" ) ) {
$wpdb->query( "ALTER TABLE {$wpdb->posts} ADD FULLTEXT crp_related (post_title, post_content);" );
}
if ( ! $wpdb->get_results( "SHOW INDEX FROM {$wpdb->posts} where Key_name = 'crp_related_title'" ) ) {
$wpdb->query( "ALTER TABLE {$wpdb->posts} ADD FULLTEXT crp_related_title (post_title);" );
}
if ( ! $wpdb->get_results( "SHOW INDEX FROM {$wpdb->posts} where Key_name = 'crp_related_content'" ) ) {
$wpdb->query( "ALTER TABLE {$wpdb->posts} ADD FULLTEXT crp_related_content (post_content);" );
}
$wpdb->show_errors();
} catch ( \Exception $e ) {
$wpdb->show_errors();
return;
}
}
public function get_related_posts( $args = array() ) {
global $wpdb, $post;
$fields = '';
$where = '';
$orderby = '';
$limits = '';
$match_fields = '';
$limit_num = buddyboss_theme_get_option( 'blog_related_posts_limit' );
$limit = ! empty( $limit_num ) ? $limit_num : 5;
$defaults = array(
'postid' => false,
'limit' => $limit,
'offset' => 0,
'match_content' => true,
);
$args = wp_parse_args( $args, $defaults );
$source_post = ( empty( $args['postid'] ) ) ? $post : get_post( $args['postid'] );
$limit = ! empty( $args['limit'] ) ? $args['limit'] : $limit;
$offset = ! empty( $args['offset'] ) ? $args['offset'] : 0;
$post_types = (array) $source_post->post_type;
$match_fields = array(
'post_title',
);
$match_fields_content = array(
$source_post->post_title,
);
if ( $args['match_content'] ) {
$match_fields[] = 'post_content';
// Due to limit in FTS phrase or proximity search depending on engine like in InnoDB,
// So restricted and truncated the search string.
$excerpt_length = apply_filters( 'bb_related_posts_excerpt_length', 100 );
$output = self::get_the_excerpt( $source_post, $excerpt_length );
$match_fields_content[] = $output;
}
$match_fields = implode( ',', $match_fields );
$stuff = implode( ' ', $match_fields_content );
$time_difference = get_option( 'gmt_offset' );
$now = gmdate( 'Y-m-d H:i:s', ( time() + ( $time_difference * 3600 ) ) );
if ( is_int( $source_post->ID ) ) {
$fields = " $wpdb->posts.ID ";
$match = $wpdb->prepare( ' AND MATCH (' . $match_fields . ") AGAINST ('%s') ", $stuff );
$now_clause = $wpdb->prepare( " AND $wpdb->posts.post_date < '%s' ", $now );
$where = $match;
$where .= $now_clause;
$where .= " AND $wpdb->posts.post_status = 'publish' ";
$where .= $wpdb->prepare( " AND {$wpdb->posts}.ID != %d ", $source_post->ID );
$where .= " AND $wpdb->posts.post_type IN ('" . join( "', '", $post_types ) . "') ";
$limits .= $wpdb->prepare( ' LIMIT %d, %d ', $offset, $limit );
if ( ! empty( $orderby ) ) {
$orderby = 'ORDER BY ' . $orderby;
}
$sql = "SELECT DISTINCT $fields FROM $wpdb->posts WHERE 1=1 $where $orderby $limits";
$results = $wpdb->get_results( apply_filters( 'bb_get_related_posts_sql', $sql ) );
} else {
$results = false;
}
return $results;
}
/**
* Function to create an excerpt for the post.
*
* @since 2.6.40
*
* @param int|\WP_Post $post Post ID or WP_Post instance.
* @param int|string $excerpt_length Length of the excerpt in words.
*
* @return string Excerpt
*/
public static function get_the_excerpt( $post, $excerpt_length = 0 ) {
$post = get_post( $post );
if ( empty( $post ) ) {
return '';
}
$content = $post->post_content;
$output = strip_shortcodes( $content );
$output = wp_strip_all_tags( $output, true );
$output = self::strip_stopwords( $output );
/**
* Filters excerpt generated before it is trimmed.
*
* @since 2.6.40
*
* @param string $output Formatted excerpt.
* @param \WP_Post $post Source Post instance.
* @param int $excerpt_length Length of the excerpt.
* @param string $content Content that is used to create the excerpt.
*/
$output = apply_filters( 'bb_related_posts_excerpt_pre_trim', $output, $post, $excerpt_length, $content );
if ( 0 === (int) $excerpt_length || 100 < (int) $excerpt_length ) {
$excerpt_length = 100;
}
if ( $excerpt_length > 0 ) {
$output = wp_trim_words( $output, $excerpt_length );
}
if ( post_password_required( $post ) ) {
$output = __( 'There is no excerpt because this is a protected post.', 'buddyboss-theme' );
}
/**
* Filters generated excerpt.
*
* @since 2.6.40
*
* @param string $output Formatted excerpt.
* @param \WP_Post $post Source Post instance.
* @param int $excerpt_length Length of the excerpt.
*/
return apply_filters( 'bb_related_posts_excerpt', $output, $post, $excerpt_length );
}
/**
* Strip stopwords from a text.
*
* @since 2.6.40
*
* @param string|array $subject The string or an array with strings to search and replace. .
* @param string|array $search The pattern to search for. It can be either a string or an array with strings.
* @param string|array $replace The string or an array with strings to replace.
*
* @return string Filtered string
*/
public static function strip_stopwords( $subject = '', $search = '', $replace = '' ) {
$pattern = array();
if ( empty( $search ) ) {
$get_search_stopwords = new \ReflectionMethod( 'WP_Query', 'get_search_stopwords' );
$get_search_stopwords->setAccessible( true );
$search = $get_search_stopwords->invoke( new \WP_Query() );
array_push( $search, 'from', 'where' );
}
foreach ( (array) $search as $s ) {
$pattern[] = '/\b' . $s . '\b/ui';
}
$output = preg_replace( $pattern, $replace, $subject );
$output = preg_replace( '/\b[a-z\-]\b/i', '', $output );
$output = preg_replace( '/\s+/', ' ', $output );
return $output;
}
}
}