function _token_example_get_comment

Builds a list of available comments.

Related topics

File

token_example/token_example.module, line 165

Code

function _token_example_get_comment() {
    if (!module_exists('comment') || !user_access('access comments') && !user_access('administer comments')) {
        return array();
    }
    $comment_query = db_select('comment', 'c');
    $comment_query->innerJoin('node', 'n', 'n.nid = c.nid');
    $comment_query->fields('c', array(
        'cid',
        'subject',
    ));
    $comment_query->condition('n.status', NODE_PUBLISHED);
    $comment_query->condition('c.status', COMMENT_PUBLISHED);
    $comment_query->orderBy('c.created', 'DESC');
    $comment_query->range(0, 10);
    $comment_query->addTag('node_access');
    $comments = $comment_query->execute()
        ->fetchAllKeyed();
    $comments = array_map('check_plain', $comments);
    return $comments;
}