Get All Entries for Today

function mycred_todays_entries_all( $user_id = NULL )
{
    global $wpdb;

    // The myCRED Log
    $db = $wpdb->prefix . 'myCRED_log';

    // Get myCRED
    $mycred = mycred_get_settings();

    // Get Now
    $now = date_i18n( 'U' );

    // Get start of today
    $today = date_i18n( 'Y/m/d 00:00:00' );
    $today = strtotime( $today );

    // The DB Query
    if ( $user_id !== NULL ) {
        // Query todays entries for a specific user
        $sql = "SELECT creds FROM {$db} WHERE user_id = %d AND time >= %d AND time <= %d ORDER BY time ";
        $query = $wpdb->get_results( $wpdb->prepare( $sql, $user_id, $today, $now ) );
    }
    else {
        // Query todays entries for everyone
        $sql = "SELECT creds FROM {$db} WHERE time >= %d AND time <= %d ORDER BY time ";
        $query = $wpdb->get_results( $wpdb->prepare( $sql, $today, $now ) );
    }

    $count = 0;
    // if we have results we add creds up
    if ( !empty( $query ) ) {
        foreach ( $query as $entry ) {
            $count = $count+$entry->creds;
        }
    }

    return $mycred->number( $count );
}