<?php
function countNewRegisteredUsers() {
global $wpdb;
$sql = "SELECT COUNT(*) as countNewUser FROM wp_users WHERE DATE(user_registered) = DATE(CONCAT(year(now()), '-', month(now()), '-', day(now())));";
return (int) $wpdb->get_var($sql);
}
function txt_func() {
return _e('New members', 'buddypress') . " " . countNewRegisteredUsers();
}