emlog获取文章评论数、未审核文章、已审核文章

<?php
//评论
function comments_count(){
    global $userData;
    $DB = Database::getInstance();
    $result=$DB->query('SELECT count(*) as "counts" FROM '.DB_PREFIX.'comment where mail="'.$userData['email'].'"');
    $res = $DB->fetch_array($result);
    return $res['counts'];
}
//未审核文章数
function count_no(){
    global $userData;
    $DB = Database::getInstance();
    $result=$DB->query('SELECT COUNT(*) AS "total" FROM ' . DB_PREFIX . 'blog WHERE author="'.$userData['uid'].'" AND checked = "n" AND type = "blog"');
    $res = $DB->fetch_array($result);
    return $res['total'];
}
//已审核文章数
function count_yes(){
    global $userData;
    $DB = Database::getInstance();
    $result=$DB->query('SELECT COUNT(*) AS "total" FROM ' . DB_PREFIX . 'blog WHERE author="'.$userData['uid'].'" AND checked = "y" AND type = "blog"');
    $res = $DB->fetch_array($result);
    return $res['total'];
}
?>