/** * Returns TRUE if the event is available to the user (see comment for getAvailableEventsForUser) * * @global wpdb $wpdb * @param int $userID * @param int $eventID * @return boolean */ public static function isEventAvailable($userID, $eventID) { global $wpdb; $mandantID = EventDatabaseManager::getMandantID($userID); $query = "SELECT count(*) AS total FROM datr_Events JOIN datr_User_has_Topics \n ON datr_Events.topicID = datr_User_has_Topics.topicID \n JOIN datr_Addresses ON datr_Addresses.addressID = datr_Events.addressID \n JOIN datr_User_has_Locations ON datr_User_has_Locations.locationID = datr_Addresses.locationID \n AND datr_User_has_Locations.userID = datr_User_has_Topics.userID \n WHERE datr_User_has_Topics.userID = {$userID} AND mandantID = {$mandantID} AND eventID = {$eventID} AND (date_time > NOW() OR eventType = 'elearning') AND event_visible = 1"; $res = $wpdb->get_results($query, ARRAY_A); return $res[0]['total'] != 0; }