'.$this->asgarosforum->pagination->renderPagination('search').'
';
echo esc_html__('Search results:', 'asgaros-forum').' '.esc_html($this->search_keywords_for_output);
echo ''.esc_html__('Last post', 'asgaros-forum').'';
echo '
';
echo '';
if ($results) {
foreach ($results as $topic) {
$this->asgarosforum->render_topic_element($topic, 'topic-normal', true);
}
} else {
$notice = __('No results found for:', 'asgaros-forum').' '.$this->search_keywords_for_output.'';
$this->asgarosforum->render_notice($notice);
}
echo '
';
echo $paginationRendering;
}
public function get_search_results() {
if (!empty($this->search_keywords_for_query)) {
$categories = $this->asgarosforum->content->get_categories();
$categoriesFilter = array();
foreach ($categories as $category) {
$categoriesFilter[] = $category->term_id;
}
// Do not execute a search-query when no categories are accessible.
if (empty($categoriesFilter)) {
return false;
}
$where = 'AND f.parent_id IN ('.implode(',', $categoriesFilter).')';
$start = $this->asgarosforum->current_page * $this->asgarosforum->options['topics_per_page'];
$end = $this->asgarosforum->options['topics_per_page'];
$limit = $this->asgarosforum->db->prepare("LIMIT %d, %d", $start, $end);
$shortcodeSearchFilter = $this->asgarosforum->shortcode->shortcodeSearchFilter;
$match_name = "MATCH (name) AGAINST ('{$this->search_keywords_for_query}*' IN BOOLEAN MODE)";
$match_text = "MATCH (text) AGAINST ('{$this->search_keywords_for_query}*' IN BOOLEAN MODE)";
$query_answers = "SELECT (COUNT(*) - 1) FROM {$this->asgarosforum->tables->posts} WHERE parent_id = t.id";
$query_match_name = "SELECT id AS topic_id, {$match_name} AS score_name, 0 AS score_text FROM {$this->asgarosforum->tables->topics} WHERE {$match_name} GROUP BY topic_id";
$query_match_text = "SELECT parent_id AS topic_id, 0 AS score_name, {$match_text} AS score_text FROM {$this->asgarosforum->tables->posts} WHERE {$match_text} GROUP BY topic_id";
$query = "SELECT t.*, f.id AS forum_id, f.name AS forum_name, ({$query_answers}) AS answers, su.topic_id, SUM(su.score_name + su.score_text) AS score FROM ({$query_match_name} UNION {$query_match_text}) AS su, {$this->asgarosforum->tables->topics} AS t, {$this->asgarosforum->tables->forums} AS f WHERE su.topic_id = t.id AND t.parent_id = f.id AND t.approved = 1 {$where} {$shortcodeSearchFilter} GROUP BY su.topic_id ORDER BY score DESC, su.topic_id DESC {$limit}";
$results = $this->asgarosforum->db->get_results($query);
if (!empty($results)) {
return $results;
}
}
return false;
}
}