asgarosforum = $asgarosforum;
$widget_ops = array('classname' => 'asgarosforumrecenttopics_widget', 'description' => __('Shows recent topics in Asgaros Forum.', 'asgaros-forum'));
parent::__construct('asgarosforumrecenttopics_widget', __('Asgaros Forum: Recent Topics', 'asgaros-forum'), $widget_ops);
}
public function widget($args, $instance) {
// Ensure that the correct location is set.
$location_check = AsgarosForumWidgets::setUpLocation();
if (!$location_check) {
$output = __('The forum has not been configured correctly.', 'asgaros-forum');
$this->widget_output($args, $instance, $output);
return;
}
// Ensure that there are accessible categories available.
$available_categories = $this->asgarosforum->content->get_categories_ids();
if (empty($available_categories)) {
$output = __('No topics yet!', 'asgaros-forum');
$this->widget_output($args, $instance, $output);
return;
}
// Generate stringified list of available categories.
$available_categories = implode(',', $available_categories);
// Ensure that there are accessible forums available.
$available_forums = $this->asgarosforum->db->get_col("SELECT id FROM {$this->asgarosforum->tables->forums} WHERE parent_id IN ({$available_categories});");
if (empty($available_forums)) {
$output = __('No topics yet!', 'asgaros-forum');
$this->widget_output($args, $instance, $output);
return;
}
// Ensure that there are forums available after applying possible filters.
$forum_filters = !empty($instance['forum_filter']) ? $instance['forum_filter'] : array();
if (!empty($forum_filters)) {
$available_forums = array_intersect($available_forums, $forum_filters);
}
if (empty($available_forums)) {
$output = __('No topics yet!', 'asgaros-forum');
$this->widget_output($args, $instance, $output);
return;
}
// Generate stringified list of available forums.
$available_forums = implode(',', $available_forums);
// Try to get forum topics.
$number = empty($instance['number']) ? 3 : absint($instance['number']);
$elements = $this->asgarosforum->db->get_results("SELECT p.id, p.text, p.date, p.parent_id, p.author_id, t.name, (SELECT COUNT(*) FROM {$this->asgarosforum->tables->posts} WHERE parent_id = p.parent_id) AS post_counter FROM {$this->asgarosforum->tables->posts} AS p LEFT JOIN {$this->asgarosforum->tables->topics} AS t ON (t.id = p.parent_id) WHERE p.forum_id IN({$available_forums}) AND p.id IN (SELECT MAX(p_inner.id) FROM {$this->asgarosforum->tables->posts} AS p_inner GROUP BY p_inner.parent_id) AND t.approved = 1 ORDER BY t.id DESC LIMIT {$number};");
// Ensure that there are forum topics available.
if (empty($elements)) {
$output = __('No topics yet!', 'asgaros-forum');
$this->widget_output($args, $instance, $output);
return;
}
// Get options.
$show_avatar = isset($instance['show_avatar']) ? $instance['show_avatar'] : true;
$show_excerpt = isset($instance['show_excerpt']) ? $instance['show_excerpt'] : false;
// Get custom values.
$title_length = apply_filters('asgarosforum_filter_widget_title_length', 33);
$excerpt_length = apply_filters('asgarosforum_widget_excerpt_length', 66);
$avatar_size = apply_filters('asgarosforum_filter_widget_avatar_size', 30);
// Generate output.
$output = '
';
foreach ($elements as $element) {
$output .= '
';
// Add avatars
if ($show_avatar) {
$output .= '