/** * * MemberMouse(TM) (http://www.membermouse.com) * (c) MemberMouse, LLC. All rights reserved. */ global $wpdb; global $current_user; $startDate = MM_Utils::dateToUTC(MM_Utils::getCurrentTime(), "Y-m-d H:i", "00:00:00"); /* * start calculations */ $activeStatus = MM_Status::$ACTIVE; $pendingCancellationStatus = MM_Status::$PENDING_CANCELLATION; $canceledStatus = MM_Status::$CANCELED; $statistics = MM_MemberMouseService::generateStatistics(); $newMembersPaid = 0; $newMembersFree = 0; $sql = "SELECT count(1) as members, memberships.is_free FROM " . MM_TABLE_USER_DATA . " u, " . MM_TABLE_MEMBERSHIP_LEVELS . " memberships "; $sql .= " WHERE u.membership_level_id=memberships.id AND u.became_active >= '{$startDate}' AND (u.status='{$activeStatus}' OR u.status='{$pendingCancellationStatus}')"; $sql .= " GROUP BY memberships.is_free"; $memberResults = $wpdb->get_results($sql); if ($memberResults != null && is_array($memberResults) && count($memberResults) > 0) { foreach ($memberResults as $k => $memberCount) { if ($memberCount->is_free == 1) { $newMembersFree = $memberCount->members; } else { $newMembersPaid = $memberCount->members; } } }