/**
* Display recent comments dashboard widget content.
*
* @since 2.5.0
*/
function nxt_dashboard_recent_comments()
{
global $nxtdb;
if (current_user_can('edit_posts')) {
$allowed_states = array('0', '1');
} else {
$allowed_states = array('1');
}
// Select all comment types and filter out spam later for better query performance.
$comments = array();
$start = 0;
$widgets = get_option('dashboard_widget_options');
$total_items = isset($widgets['dashboard_recent_comments']) && isset($widgets['dashboard_recent_comments']['items']) ? absint($widgets['dashboard_recent_comments']['items']) : 5;
while (count($comments) < $total_items && ($possible = $nxtdb->get_results("SELECT * FROM {$nxtdb->comments} c LEFT JOIN {$nxtdb->posts} p ON c.comment_post_ID = p.ID WHERE p.post_status != 'trash' ORDER BY c.comment_date_gmt DESC LIMIT {$start}, 50"))) {
foreach ($possible as $comment) {
if (count($comments) >= $total_items) {
break;
}
if (in_array($comment->comment_approved, $allowed_states) && current_user_can('read_post', $comment->comment_post_ID)) {
$comments[] = $comment;
}
}
$start = $start + 50;
}
if ($comments) {
?>
<div id="the-comment-list" class="list:comment">
<?php
foreach ($comments as $comment) {
_nxt_dashboard_recent_comments_row($comment);
}
?>
</div>
<?php
if (current_user_can('edit_posts')) {
?>
<?php
_get_list_table('nxt_Comments_List_Table')->views();
}
nxt_comment_reply(-1, false, 'dashboard', false);
nxt_comment_trashnotice();
} else {
?>
<p><?php
_e('No comments yet.');
?>
</p>
<?php
}
// $comments;
}
if (1 == $screen_layout_columns) {
'page' == $post_type ? do_action('submitpage_box') : do_action('submitpost_box');
$side_meta_boxes = do_meta_boxes($post_type, 'side', $post);
}
do_meta_boxes(null, 'normal', $post);
'page' == $post_type ? do_action('edit_page_form') : do_action('edit_form_advanced');
do_meta_boxes(null, 'advanced', $post);
do_action('dbx_post_sidebar');
?>
</div>
</div>
<br class="clear" />
</div><!-- /poststuff -->
</form>
</div>
<?php
if (post_type_supports($post_type, 'comments')) {
nxt_comment_reply();
}
?>
<?php
if (isset($post->post_title) && '' == $post->post_title || isset($_GET['message']) && 2 > $_GET['message']) {
?>
<script type="text/javascript">
try{document.post.title.focus();}catch(e){}
</script>
<?php
}
echo esc_attr($nxt_list_table->get_pagination_arg('per_page'));
?>
" />
<input type="hidden" name="_page" value="<?php
echo esc_attr($nxt_list_table->get_pagination_arg('page'));
?>
" />
<?php
if (isset($_REQUEST['paged'])) {
?>
<input type="hidden" name="paged" value="<?php
echo esc_attr(absint($_REQUEST['paged']));
?>
" />
<?php
}
?>
<?php
$nxt_list_table->display();
?>
</form>
</div>
<div id="ajax-response"></div>
<?php
nxt_comment_reply('-1', true, 'detail');
nxt_comment_trashnotice();
include './admin-footer.php';
