function mb_set_user_topic_count($user_id)
{
global $wpdb;
$open_status = mb_get_open_post_status();
$close_status = mb_get_close_post_status();
$publish_status = mb_get_publish_post_status();
$hidden_status = mb_get_hidden_post_status();
$private_status = mb_get_private_post_status();
$where = $wpdb->prepare("WHERE post_author = %d AND post_type = %s", $user_id, mb_get_topic_post_type());
$status_where = "AND (post_status = '{$open_status}' OR post_status = '{$close_status}' OR post_status = '{$publish_status}' OR post_status = '{$private_status}' OR post_status = '{$hidden_status}')";
$count = $wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->posts} {$where} {$status_where}");
update_user_meta($user_id, mb_get_user_topic_count_meta_key(), $count);
return $count;
}
/**
* Displays admin notices for the edit forum screen.
*
* @since 1.0.0
* @access public
* @return void
*/
public function admin_notices()
{
$allowed_notices = array(mb_get_open_post_status(), mb_get_close_post_status(), mb_get_archive_post_status());
/* If we have an allowed notice. */
if (isset($_GET['mb_forum_notice']) && in_array($_GET['mb_forum_notice'], $allowed_notices) && isset($_GET['forum_id'])) {
$notice = $_GET['mb_forum_notice'];
$forum_id = mb_get_forum_id(absint($_GET['forum_id']));
if (mb_get_close_post_status() === $notice) {
$text = sprintf(__('The forum "%s" was successfully closed.', 'message-board'), mb_get_forum_title($forum_id));
} elseif (mb_get_open_post_status() === $notice) {
$text = sprintf(__('The forum "%s" was successfully opened.', 'message-board'), mb_get_forum_title($forum_id));
} elseif (mb_get_archive_post_status() === $notice) {
$text = sprintf(__('The forum "%s" was successfully archived.', 'message-board'), mb_get_forum_title($forum_id));
}
if (!empty($text)) {
printf('<div class="updated"><p>%s</p></div>', $text);
}
}
}
/**
* Makes sure the correct post status is used when loading forums on the nav menus screen. By
* default, WordPress will only load them if they have the "publish" post status.
*
* @since 1.0.0
* @access public
* @param object $object
* @return object
*/
public function nav_menu_meta_box_object($object)
{
if (isset($object->name) && mb_get_forum_post_type() === $object->name) {
$statuses = array(mb_get_open_post_status(), mb_get_close_post_status(), mb_get_publish_post_status(), mb_get_private_post_status(), mb_get_hidden_post_status(), mb_get_archive_post_status());
$object->_default_query = wp_parse_args(array('post_status' => $statuses), $object->_default_query);
}
return $object;
}
/**
* Adds sticky posts to the front of the line with any given set of posts and stickies.
*
* @since 1.0.0
* @access public
* @param array $posts Array of post objects.
* @param array $sticky_posts Array of post IDs.
* @param int $forum_id Limit to specific forum.
* @return array
*/
function mb_add_stickies($posts, $sticky_posts, $forum_id = 0)
{
/* Only do this if on the first page and we indeed have stickies. */
if (!is_paged() && !empty($sticky_posts)) {
$num_posts = count($posts);
$sticky_offset = 0;
/* Loop over posts and relocate stickies to the front. */
for ($i = 0; $i < $num_posts; $i++) {
if (in_array($posts[$i]->ID, $sticky_posts)) {
$sticky_post = $posts[$i];
/* Remove sticky from current position. */
array_splice($posts, $i, 1);
/* Move to front, after other stickies. */
array_splice($posts, $sticky_offset, 0, array($sticky_post));
/* Increment the sticky offset. The next sticky will be placed at this offset. */
$sticky_offset++;
/* Remove post from sticky posts array. */
$offset = array_search($sticky_post->ID, $sticky_posts);
unset($sticky_posts[$offset]);
}
}
/* Fetch sticky posts that weren't in the query results. */
if (!empty($sticky_posts)) {
$args = array('post__in' => $sticky_posts, 'post_type' => mb_get_topic_post_type(), 'post_status' => array(mb_get_open_post_status(), mb_get_close_post_status(), mb_get_publish_post_status()), 'nopaging' => true);
if (0 < $forum_id) {
$args['post_parent'] = $forum_id;
}
$stickies = get_posts($args);
foreach ($stickies as $sticky_post) {
array_splice($posts, $sticky_offset, 0, array($sticky_post));
$sticky_offset++;
}
}
}
return $posts;
}
/**
* Changes a topic's post status to "close" if it has a different status.
*
* @since 1.0.0
* @access public
* @param int $topic_id
* @return int|WP_Error
*/
function mb_close_topic($topic_id)
{
return mb_update_post_status($topic_id, mb_get_close_post_status());
}
/**
* Displays admin notices for the edit forum screen.
*
* @since 1.0.0
* @access public
* @return void
*/
public function admin_notices()
{
$allowed_notices = array('restore', mb_get_spam_post_status(), mb_get_open_post_status(), mb_get_close_post_status(), 'sticky', 'unsticky', 'super', 'unsuper');
if (isset($_GET['mb_topic_notice']) && in_array($_GET['mb_topic_notice'], $allowed_notices) && isset($_GET['topic_id'])) {
$notice = $_GET['mb_topic_notice'];
$topic_id = mb_get_topic_id(absint($_GET['topic_id']));
if (mb_get_spam_post_status() === $notice) {
$text = sprintf(__('The topic "%s" was successfully marked as spam.', 'message-board'), mb_get_topic_title($topic_id));
} elseif ('restore' === $notice) {
$text = sprintf(__('The topic "%s" was successfully removed from spam.', 'message-board'), mb_get_topic_title($topic_id));
} elseif (mb_get_close_post_status() === $notice) {
$text = sprintf(__('The topic "%s" was successfully closed.', 'message-board'), mb_get_topic_title($topic_id));
} elseif (mb_get_open_post_status() === $notice) {
$text = sprintf(__('The topic "%s" was successfully opened.', 'message-board'), mb_get_topic_title($topic_id));
} elseif ('sticky' === $notice) {
$text = sprintf(__('The topic "%s" was successfully added as a sticky topic.', 'message-board'), mb_get_topic_title($topic_id));
} elseif ('unsticky' === $notice) {
$text = sprintf(__('The topic "%s" was successfully removed from sticky topics.', 'message-board'), mb_get_topic_title($topic_id));
} elseif ('super' === $notice) {
$text = sprintf(__('The topic "%s" was successfully added as a super sticky topic.', 'message-board'), mb_get_topic_title($topic_id));
} elseif ('unsuper' === $notice) {
$text = sprintf(__('The topic "%s" was successfully removed from super sticky topics.', 'message-board'), mb_get_topic_title($topic_id));
}
if (!empty($text)) {
printf('<div class="updated"><p>%s</p></div>', $text);
}
}
}
/**
* Resets the forum's "latest" data.
*
* @since 1.0.0
* @access public
* @param int $forum_id
* @return int
*/
function mb_reset_forum_latest($forum_id)
{
global $wpdb;
$forum_id = mb_get_forum_id($forum_id);
$open_status = mb_get_open_post_status();
$close_status = mb_get_close_post_status();
$publish_status = mb_get_publish_post_status();
$private_status = mb_get_private_post_status();
$hidden_status = mb_get_hidden_post_status();
$status_where = "AND (post_status = '{$open_status}' OR post_status = '{$close_status}' OR post_status = '{$publish_status}' OR post_status = '{$private_status}' OR post_status = '{$hidden_status}')";
$topic_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM {$wpdb->posts} WHERE post_type = %s {$status_where} AND post_parent = %d ORDER BY menu_order DESC", mb_get_topic_post_type(), $forum_id));
if (!empty($topic_id)) {
$t_status_where = "AND (topic.post_status = '{$open_status}' OR topic.post_status = '{$close_status}' OR topic.post_status = '{$publish_status}' OR topic.post_status = '{$private_status}' OR topic.post_status = '{$hidden_status}')";
$r_status_where = "AND reply.post_status = '{$publish_status}'";
$status_where = $t_status_where . $r_status_where;
$reply_id = $wpdb->get_var($wpdb->prepare("SELECT reply.ID FROM {$wpdb->posts} AS reply INNER JOIN {$wpdb->posts} AS topic ON reply.post_parent = topic.ID WHERE topic.post_parent = %d {$status_where} ORDER BY reply.post_date DESC", $forum_id));
if ($reply_id) {
mb_set_forum_last_reply_id($forum_id, $reply_id);
mb_set_forum_last_topic_id($forum_id, $topic_id);
$last_date = get_post($reply_id)->post_date;
$epoch_date = mysql2date('U', $last_date);
mb_set_forum_activity_datetime($forum_id, $last_date);
mb_set_forum_activity_epoch($forum_id, $epoch_date);
} else {
delete_post_meta($forum_id, mb_get_forum_last_reply_id_meta_key());
mb_set_forum_last_topic_id($forum_id, $topic_id);
$last_date = get_post($topic_id)->post_date;
$epoch_date = mysql2date('U', $last_date);
mb_set_forum_activity_datetime($forum_id, $last_date);
mb_set_forum_activity_epoch($forum_id, $epoch_date);
}
} else {
delete_post_meta($forum_id, mb_get_forum_last_reply_id_meta_key());
delete_post_meta($forum_id, mb_get_forum_last_topic_id_meta_key());
delete_post_meta($forum_id, mb_get_forum_activity_datetime_meta_key());
delete_post_meta($forum_id, mb_get_forum_activity_datetime_epoch_meta_key());
}
}
function mb_get_forum_toggle_close_link($forum_id = 0)
{
$forum_id = mb_get_forum_id($forum_id);
$url = mb_get_forum_toggle_close_url($forum_id);
if (empty($url)) {
return '';
}
$status = get_post_status_object(mb_get_close_post_status());
$link = sprintf('<a class="mb-forum-close-link" href="%s">%s</a>', $url, $status->mb_label_verb);
return $link;
}
