PHP:TYPECHO:获得访客最近评论数

gistfile1.php

    //获得访客最近评论数
    function get_author_comments_num($email = "") {
        if(empty($email)) return;
        $commentsNum = Helper::options()->commentsNum;
        $time = time() - (24 * 60 * 60 * $commentsNum);  //当前时间戳减去30天的时间戳
        $db = Typecho_Db::get();
        $sql = $db->select('COUNT(mail) as emailnum')->from('table.comments')
            ->where('status = ?','approved')
            ->where('mail = ?',$email)
            ->where('created > ?',$time);
        $result = $db->fetchAll($sql);
        echo $result[0]['emailnum'];
    }