Thêm widget Top Bình luận cho website WordPress

//Widget Top bình luận như Hocban.vn
add_shortcode('top_commenters', function(): string {
global $wpdb;
$admins = get_users(['role' => 'Administrator', 'fields' => 'ID']);
$exclude = !empty($admins) ? implode(',', array_map('intval', $admins)) : '0';
$results = $wpdb->get_results("SELECT COUNT(comment_ID) AS count, comment_author, comment_author_email, MAX(comment_author_url) AS author_url FROM {$wpdb->comments} WHERE comment_date > DATE_SUB(NOW(), INTERVAL 30 DAY) AND comment_approved = '1' AND comment_type = 'comment' AND user_id NOT IN ($exclude) GROUP BY comment_author_email ORDER BY count DESC LIMIT 8");
$html = '<style>
.hb-list { list-style: none !important; padding: 0 !important; margin: 0 !important; }
.hb-item { display: flex !important; align-items: center !important; white-space: nowrap !important; overflow: hidden !important; padding: 8px 0 !important; border-bottom: 1px solid rgba(0,0,0,0.05); margin-bottom: 0 !important; }
.hb-item:last-child { border-bottom: none !important; }
.hb-item *, .hb-thumb img { margin-bottom: 0 !important; margin-top: 0 !important; }
.hb-thumb { flex-shrink: 0; margin-right: 10px; line-height: 0; }
.hb-thumb img { border-radius: 5px !important; display: block; border: 1px solid rgba(0,0,0,0.05); }
.hb-text { overflow: hidden; text-overflow: ellipsis; display: inline-flex; align-items: center; flex-grow: 1; }
.hb-link { color: inherit; text-decoration: none !important; flex-shrink: 1; overflow: hidden; text-overflow: ellipsis; }
.hb-link:hover { text-decoration: underline !important; }
.hb-count { font-weight: 500 !important; margin-left: 5px; font-size: 95%; }
</style>';
if ($results) {
$html .= '<ul class="hb-list">';
foreach ($results as $res) {
$avatar = get_avatar($res->comment_author_email, 28);
$name = esc_html($res->comment_author);
$url = esc_url(trim((string)$res->author_url));
$count = (int)$res->count;
$has_link = (!empty($url) && strlen($url) > 8);
$name_html = $has_link ? "<a class='hb-link' href='{$url}' rel='nofollow ugc noopener noreferrer' target='_blank'>{$name}</a>" : "<span class='hb-link'>{$name}</span>";
$html .= "<li class='hb-item'><div class='hb-thumb'>{$avatar}</div><div class='hb-text'>{$name_html}<span class='hb-count'>({$count})</span></div></li>";
}
$html .= '</ul>';
} else { $html .= '<p>Chưa có dữ liệu.</p>'; }
return $html;
});
//Widget Top bình luận như Hocban.vn