eme-functions.php

<?php

if ( ! defined( 'ABSPATH' ) ) {
	exit; // Exit if accessed directly.
}

function eme_plugin_url() {
	$url = wp_cache_get( 'eme_plugin_url' );
	if ( $url === false ) {
		$url = plugin_dir_url( __FILE__ );
		wp_cache_set( 'eme_plugin_url', $url, '', 60 );
	}
	return $url;
}
function eme_plugin_dir() {
	$dir = wp_cache_get( 'eme_plugin_dir' );
	if ( $dir === false ) {
		$dir = plugin_dir_path( __FILE__ );
		wp_cache_set( 'eme_plugin_dir', $dir, '', 60 );
	}
	return $dir;
}

add_action( 'wp_ajax_eme_client_clock', 'eme_client_clock_ajax' );
add_action( 'wp_ajax_nopriv_eme_client_clock', 'eme_client_clock_ajax' );
function eme_client_clock_ajax() {
	$valid = true;
	$ret   = '0';
	// Set php clock values in an array
	$phptime_obj = new ExpressiveDate( 'now', EME_TIMEZONE );
	// if clock data not set
	if ( ! isset( $_COOKIE['eme_client_time'] ) ) {
		// no valid data received
		$valid = false;
		// ret=1 will cause the client browser to refresh, this will allow the cookie to be read upon refresh (and so no global var is needed)
		$ret = '1';
		// Preset php clock values in client cookie for fall-back if valid client clock data isn't received.
		$client_timeinfo['eme_client_unixtime'] = (int) $phptime_obj->format( 'U' ); // Integer seconds since 1/1/1970 @ 12:00 AM
		$client_timeinfo['eme_client_seconds']  = (int) $phptime_obj->format( 's' ); // Integer second this minute (0-59)
		$client_timeinfo['eme_client_minutes']  = (int) $phptime_obj->format( 'i' ); // Integer minute this hour (0-59)
		$client_timeinfo['eme_client_hours']    = (int) $phptime_obj->format( 'h' ); // Integer hour this day (0-23)
		$client_timeinfo['eme_client_wday']     = (int) $phptime_obj->format( 'w' ); // Integer day this week (0-6), 0 = Sunday, ... , 6 = Saturday
		$client_timeinfo['eme_client_mday']     = (int) $phptime_obj->format( 'j' ); // Integer day this month 1-31)
		$client_timeinfo['eme_client_month']    = (int) $phptime_obj->format( 'n' ); // Integer month this year (1-12)
		$client_timeinfo['eme_client_fullyear'] = (int) $phptime_obj->format( 'Y' ); // Integer year (1970-9999)
	} else {
		try {
			$client_timeinfo = eme_sanitize_request( json_decode( $_COOKIE['eme_client_time'], true ) );
			if ( ! is_array( $client_timeinfo ) ) {
				$client_timeinfo = [];
			}
			$ret = '0';
		} catch ( Exception $error ) {
			$client_timeinfo = [];
			$valid = false;
		}
		if ( ! isset( $client_timeinfo['eme_client_unixtime'] ) ) {
			$client_timeinfo['eme_client_unixtime'] = (int) $phptime_obj->format( 'U' );
		}
		if ( ! isset( $client_timeinfo['eme_client_seconds'] ) ) {
			$client_timeinfo['eme_client_seconds'] = (int) $phptime_obj->format( 's' );
		}
		if ( ! isset( $client_timeinfo['eme_client_minutes'] ) ) {
			$client_timeinfo['eme_client_minutes'] = (int) $phptime_obj->format( 'i' );
		}
		if ( ! isset( $client_timeinfo['eme_client_hours'] ) ) {
			$client_timeinfo['eme_client_hours'] = (int) $phptime_obj->format( 'h' );
		}
		if ( ! isset( $client_timeinfo['eme_client_wday'] ) ) {
			$client_timeinfo['eme_client_wday'] = (int) $phptime_obj->format( 'w' );
		}
		if ( ! isset( $client_timeinfo['eme_client_mday'] ) ) {
			$client_timeinfo['eme_client_mday'] = (int) $phptime_obj->format( 'j' );
		}
		if ( ! isset( $client_timeinfo['eme_client_month'] ) ) {
			$client_timeinfo['eme_client_month'] = (int) $phptime_obj->format( 'n' );
		}
		if ( ! isset( $client_timeinfo['eme_client_fullyear'] ) ) {
			$client_timeinfo['eme_client_fullyear'] = (int) $phptime_obj->format( 'Y' );
		}
	}

	// Cast client clock values as integers to avoid mathematical errors and set in temporary local variables.
	$client_unixtime = isset( $_POST['page'] ) ? intval( $_POST['client_unixtime'] ) : 0;
	$client_seconds  = isset( $_POST['page'] ) ? intval( $_POST['client_seconds'] ) : 0;
	$client_minutes  = isset( $_POST['page'] ) ? intval( $_POST['client_minutes'] ) : 0;
	$client_hours    = isset( $_POST['page'] ) ? intval( $_POST['client_hours'] ) : 0;
	$client_wday     = isset( $_POST['page'] ) ? intval( $_POST['client_wday'] ) : 0;
	$client_mday     = isset( $_POST['page'] ) ? intval( $_POST['client_mday'] ) : 0;
	$client_month    = isset( $_POST['client_month'] ) ? intval( $_POST['client_month'] ) : 0;
	$client_fullyear = isset( $_POST['client_fullyear'] ) ? intval( $_POST['client_fullyear'] ) : 0;

	// Client clock sanity tests
	if ( abs( $client_unixtime - $client_timeinfo['eme_client_unixtime'] ) > 300 ) {
		$valid = false; // allow +/-5 min difference
	}
	if ( abs( $client_seconds - 30 ) > 30 ) {
		$valid = false; // Seconds <0 or >60
	}
	if ( abs( $client_minutes - 30 ) > 30 ) {
		$valid = false; // Minutes <0 or >60
	}
	if ( abs( $client_hours - 12 ) > 12 ) {
		$valid = false; // Hours <0 or >24
	}
	if ( abs( $client_wday - 3 ) > 3 ) {
		$valid = false; // Weekday <0 or >6
	}
	if ( abs( $client_mday - $client_timeinfo['eme_client_mday'] ) > 30 ) {
		$valid = false; // >30 day difference
	}
	if ( abs( $client_month - $client_timeinfo['eme_client_month'] ) > 11 ) {
		$valid = false; // >11 month difference
	}
	if ( abs( $client_fullyear - $client_timeinfo['eme_client_fullyear'] ) > 1 ) {
		$valid = false; // >1 year difference
	}

	// To insure mutual consistency, don't use any client values unless they all passed the tests.
	if ( $valid ) {
		$client_timeinfo['eme_client_unixtime'] = $client_unixtime;
		$client_timeinfo['eme_client_seconds']  = $client_seconds;
		$client_timeinfo['eme_client_minutes']  = $client_minutes;
		$client_timeinfo['eme_client_hours']    = $client_hours;
		$client_timeinfo['eme_client_wday']     = $client_wday;
		$client_timeinfo['eme_client_mday']     = $client_mday;
		$client_timeinfo['eme_client_month']    = $client_month;
		$client_timeinfo['eme_client_fullyear'] = $client_fullyear;
	}

	// client cookie lifetime = 0 (the session)
	// the cookie is stored using wp_json_encode and not eme_serialize, to avoid for Object Injection
	// See https://www.owasp.org/index.php/PHP_Object_Injection
	setcookie( 'eme_client_time', wp_json_encode( $client_timeinfo ), 0, COOKIEPATH, COOKIE_DOMAIN );
	echo $ret;
	wp_die();
}

function eme_captcha_generate( $file ) {
	// 23 letters (not the "l",o","q")
	$alphabet = 'abcdefghjkmnpqrstuvwxyz';
	$random1  = substr( $alphabet, rand( 1, 23 ) - 1, 1 );
	$random2  = rand( 2, 9 );
	$rand     = rand( 1, 23 ) - 1;
	$random3  = substr( $alphabet, rand( 1, 23 ) - 1, 1 );
	$random4  = rand( 2, 9 );
	$rand     = rand( 1, 23 ) - 1;
	$random5  = substr( $alphabet, rand( 1, 23 ) - 1, 1 );

	$randomtext = $random1 . $random2 . $random3 . $random4 . $random5;
	// strtolower not needed, $alphabet lowercase only
	//$randomtext=strtolower($randomtext);

	$res = 'eme_captcha_' . $file . '-' . md5( $randomtext );
		touch( get_temp_dir() . $res );

	$im = imagecreatetruecolor( 120, 38 );

	// some colors
	$white             = imagecolorallocate( $im, 255, 255, 255 );
	$grey              = imagecolorallocate( $im, 128, 128, 128 );
	$black             = imagecolorallocate( $im, 0, 0, 0 );
	$red               = imagecolorallocate( $im, 255, 0, 0 );
	$blue              = imagecolorallocate( $im, 0, 0, 255 );
	$green             = imagecolorallocate( $im, 0, 255, 0 );
	$background_colors = [ $red, $blue, $green, $black ];

	// draw rectangle in random color
	$background_color = $background_colors[ rand( 0, 3 ) ];
	imagefilledrectangle( $im, 0, 0, 120, 38, $background_color );

	// replace font.ttf with the location of your own ttf font file
	$eme_plugin_dir = eme_plugin_dir();
	$font           = $eme_plugin_dir . 'font.ttf';

	if ( function_exists( 'imagettftext' ) ) {
		// add shadow
		imagettftext( $im, 25, 8, 15, 28, $grey, $font, $random1 );
		imagettftext( $im, 25, -8, 35, 28, $grey, $font, $random2 );
		imagettftext( $im, 25, 8, 55, 28, $grey, $font, $random3 );
		imagettftext( $im, 25, -8, 75, 28, $grey, $font, $random4 );
		imagettftext( $im, 25, 8, 95, 28, $grey, $font, $random5 );

		// add text
		imagettftext( $im, 25, 8, 8, 30, $white, $font, $random1 );
		imagettftext( $im, 25, -8, 28, 30, $white, $font, $random2 );
		imagettftext( $im, 25, 8, 48, 30, $white, $font, $random3 );
		imagettftext( $im, 25, -8, 68, 30, $white, $font, $random4 );
		imagettftext( $im, 25, 8, 88, 30, $white, $font, $random5 );
	} else {
		// add shadow
		imagestring( $im, 5, 15, 5, $random1, $grey );
		imagestring( $im, 5, 35, 5, $random2, $grey );
		imagestring( $im, 5, 55, 5, $random3, $grey );
		imagestring( $im, 5, 75, 5, $random4, $grey );
		imagestring( $im, 5, 95, 5, $random5, $grey );
		// add text
		imagestring( $im, 5, 15, 7, $random1, $white );
		imagestring( $im, 5, 35, 7, $random2, $white );
		imagestring( $im, 5, 55, 7, $random3, $white );
		imagestring( $im, 5, 75, 7, $random4, $white );
		imagestring( $im, 5, 95, 7, $random5, $white );
	}

	// give image back
	header( 'Content-type: image/gif' );
	imagegif( $im );
	imagedestroy( $im );
	exit;
}

function eme_load_captcha_html() {
	$captcha_id  = eme_random_id();
	$captcha_url = eme_captcha_url( $captcha_id );
	if ( $captcha_url ) {
		$replacement = "<input type='hidden' name='eme_captcha_id' value='$captcha_id'><img id='eme_captcha_img' src='$captcha_url'><br><input required='required' type='text' name='captcha_check' id='captcha_check' autocomplete='off' class='nodynamicupdates'>";
	} else {
		$replacement = __( 'Problem while generating the captcha, please check with the site administrator', 'events-made-easy' );
	}
	return $replacement;
}

function eme_load_recaptcha_html() {
	if ( ! wp_script_is( 'eme-recaptcha', 'enqueued' ) ) {
		wp_enqueue_script( 'eme-recaptcha' );
	}

	$eme_recaptcha_sitekey = get_option( 'eme_recaptcha_site_key' );
		return '<!-- Google reCAPTCHA widget -->
            <div class="g-recaptcha" data-sitekey="' . $eme_recaptcha_sitekey . '"></div>';
}

function eme_load_hcaptcha_html() {
	if ( ! wp_script_is( 'eme-hcaptcha', 'enqueued' ) ) {
		wp_enqueue_script( 'eme-hcaptcha' );
	}

	$eme_hcaptcha_sitekey = get_option( 'eme_hcaptcha_site_key' );
		return '<!-- hCaptcha widget -->
            <div class="h-captcha" data-sitekey="' . $eme_hcaptcha_sitekey . '"></div>';
}

function eme_load_cfcaptcha_html() {
	if ( ! wp_script_is( 'eme-cfcaptcha', 'enqueued' ) ) {
		wp_enqueue_script( 'eme-cfcaptcha' );
	}

	$eme_cfcaptcha_sitekey = get_option( 'eme_cfcaptcha_site_key' );
		return '<!-- Cloudflare Turnstile Captcha widget -->
            <div class="cf-turnstile" data-sitekey="' . $eme_cfcaptcha_sitekey . '"></div>';
}

function eme_check_recaptcha() {
	$eme_recaptcha     = get_option( 'eme_recaptcha_for_forms' );
	$eme_recaptcha_key = get_option( 'eme_recaptcha_secret_key' );
	if ( isset( $_POST['g-recaptcha-response'] ) && ! empty( $eme_recaptcha_key ) && $eme_recaptcha ) {
		$url      = 'https://www.google.com/recaptcha/api/siteverify?secret=' . $eme_recaptcha_key . '&response=' . eme_sanitize_request( $_POST['g-recaptcha-response'] );
                $response = wp_remote_get( $url );
		if ( is_wp_error( $response ) ) {
			return false;
		} else {
			$body = wp_remote_retrieve_body( $response );
			$responseCaptchaData = json_decode( $body );
			if ( $responseCaptchaData->success ) {
				return true;
			} else {
				return false;
			}
		}
	} else {
		return false;
	}
}

function eme_check_hcaptcha() {
	$eme_hcaptcha     = get_option( 'eme_hcaptcha_for_forms' );
	$eme_hcaptcha_key = get_option( 'eme_hcaptcha_secret_key' );
	if ( isset( $_POST['h-captcha-response'] ) && ! empty( $eme_hcaptcha_key ) && $eme_hcaptcha ) {
		$url      = 'https://hcaptcha.com/siteverify';
		$data     = [
			'secret'   => $eme_hcaptcha_key,
			'response' => eme_sanitize_request( $_POST['h-captcha-response'] ),
		];
		$response = wp_remote_post( $url, [ 'body' => $data ] );
		if ( is_wp_error( $response ) ) {
			return false;
		} else {
			$body = wp_remote_retrieve_body( $response );
			$responseCaptchaData = json_decode( $body );
			if ( $responseCaptchaData->success ) {
				return true;
			} else {
				return false;
			}
		}
	} else {
		return false;
	}
}

function eme_check_cfcaptcha() {
	$eme_cfcaptcha     = get_option( 'eme_cfcaptcha_for_forms' );
	$eme_cfcaptcha_key = get_option( 'eme_cfcaptcha_secret_key' );
	if ( isset( $_POST['cf-turnstile-response'] ) && ! empty( $eme_cfcaptcha_key ) && $eme_cfcaptcha ) {
		$url      = 'https://challenges.cloudflare.com/turnstile/v0/siteverify';
		$data     = [
			'secret'   => $eme_cfcaptcha_key,
			'response' => eme_sanitize_request( $_POST['cf-turnstile-response'] ),
		];
		$response = wp_remote_post( $url, [ 'body' => $data ] );
		if ( is_wp_error( $response ) ) {
			return false;
		} else {
			$body = wp_remote_retrieve_body( $response );
			$responseCaptchaData = json_decode( $body );
			if ( $responseCaptchaData->success ) {
				return true;
			} else {
				return false;
			}
		}
	} else {
		return false;
	}
}

function eme_check_emecaptcha( $remove_upon_success = 0 ) {
	if ( empty( $_POST['eme_captcha_id'] ) ) {
		return false;
	}
	if ( empty( $_POST['captcha_check'] ) ) {
		return false;
	}
	$captcha_id = eme_sanitize_filenamechars( $_POST['eme_captcha_id'] );
	if ( empty( $captcha_id ) ) {
		return false;
	}
	// make it a bit easier for people and lowercase their response
	$captcha_response = eme_sanitize_filenamechars( strtolower( $_POST['captcha_check'] ) );
	if ( empty( $captcha_response ) ) {
		return false;
	}
	$res = get_temp_dir() . 'eme_captcha_' . $captcha_id . '-' . md5( $captcha_response );

	// normally the captcha gets removed upon validation
	// sometimes you do other form validations later on, and then this is not desired
	// because if other form validation would fail, the captcha would still be gone
	// and people would need to re-enter it
	// In such cases, call eme_captcha_remove on the file later on
	// (although there's also a cron that removes captchas older than xxx minutes, so no real requirement)
	if ( file_exists( $res ) ) {
		if ( $remove_upon_success ) {
			wp_delete_file( $res );
			return true;
		} else {
			return $res;
		}
	} else {
		return false;
	}
}

function eme_check_captcha( $properties = [], $remove_captcha_if_ok = 0 ) {
	$captcha_res = false;
	if ( (! empty( $properties ) && !empty($properties['captcha_only_logged_out'])) ||
		(empty( $properties ) && get_option( 'eme_captcha_only_logged_out' ) ) ) 	 {
		if (is_user_logged_in()) {
			return true;
		}
	}
	$configured_captchas = eme_get_configured_captchas();
	if (! empty( $properties ) && isset($properties['selected_captcha']))
		$selected_captcha = $properties['selected_captcha'];
	else
		$selected_captcha = '';

	if ( ( ! empty( $properties ) && $selected_captcha == 'recaptcha' ) || ( empty( $properties ) && isset( $configured_captchas['recaptcha'] ) ) ) {
		$captcha_res = eme_check_recaptcha();
		if ( ! $captcha_res ) {
			$message = esc_html__( 'Please check the Google reCAPTCHA box', 'events-made-easy' );
			echo wp_json_encode(
				[
					'Result'      => 'NOK',
					'htmlmessage' => $message,
				]
			);
			wp_die();
		}
	}
	if ( ( ! empty( $properties ) && $selected_captcha == 'hcaptcha' ) || ( empty( $properties ) && isset( $configured_captchas['hcaptcha'] ) ) ) {
		$captcha_res = eme_check_hcaptcha();
		if ( ! $captcha_res ) {
			$message = esc_html__( 'Please check the hCaptcha box', 'events-made-easy' );
			echo wp_json_encode(
				[
					'Result'      => 'NOK',
					'htmlmessage' => $message,
				]
			);
			wp_die();
		}
	}
	if ( ( ! empty( $properties ) && $selected_captcha == 'cfcaptcha' ) || ( empty( $properties ) && isset( $configured_captchas['cfcaptcha'] ) ) ) {
		$captcha_res = eme_check_cfcaptcha();
		if ( ! $captcha_res ) {
			$message = esc_html__( 'Please check the Cloudflare Turnstile box', 'events-made-easy' );
			echo wp_json_encode(
				[
					'Result'      => 'NOK',
					'htmlmessage' => $message,
				]
			);
			wp_die();
		}
	}
	if ( ( ! empty( $properties ) && $selected_captcha == 'captcha' ) || ( empty( $properties ) && isset( $configured_captchas['captcha'] ) ) ) {
		$captcha_res = eme_check_emecaptcha( $remove_captcha_if_ok );
		if ( ! $captcha_res ) {
			$message = esc_html__( 'You entered an incorrect code', 'events-made-easy' );
			echo wp_json_encode(
				[
					'Result'      => 'NOK',
					'htmlmessage' => $message,
				]
			);
			wp_die();
		}
	}
	return $captcha_res;
}

function eme_generate_captchas_html($selected_captcha = '') {
	if ( eme_is_admin_request() ) {
		return '';
	}
	if ( get_option( 'eme_captcha_only_logged_out' ) && is_user_logged_in() ) {
		return '';
	}

	$configured_captchas = eme_get_configured_captchas();
	if (!empty($configured_captchas)) {
		if (empty($selected_captcha))
			$selected_captcha = array_key_first($configured_captchas);
		elseif (!empty($selected_captcha) && !array_key_exists($selected_captcha, $configured_captchas))
			$selected_captcha = array_key_first($configured_captchas);
		$captcha_function = 'eme_load_'.$selected_captcha.'_html';
		if (function_exists($captcha_function))
			return $captcha_function();
	}
}

function eme_add_captcha_submit( $format, $captcha = '', $add_dyndata = 0 ) {
	if ( $add_dyndata && ! preg_match( '/#_DYNAMICDATA/', $format ) ) {
		$text = '#_DYNAMICDATA';
		if ( preg_match( '/#_SUBMIT/', $format ) ) {
			$format = preg_replace( '/#_SUBMIT/', "$text<br>#_SUBMIT", $format );
		} else {
			$format .= $text;
		}
	}
	$configured_captchas = eme_get_configured_captchas();
	if (empty($configured_captchas)) {
		$captcha = "";
	} elseif (!empty($captcha) && !array_key_exists($captcha, $configured_captchas)) {
		$captcha = array_key_first($configured_captchas);
	}
	if ( !empty($captcha) && ! preg_match( '/#_CFCAPTCHA|#_HCAPTCHA|#_RECAPTCHA|#_CAPTCHA/', $format ) ) {
		if ($captcha == 'captcha')
			$captcha_text = '<p>' . __( 'Please enter the displayed code.', 'events-made-easy' ) . '</p> #_CAPTCHA';
		else
			$captcha_text = '#_CAPTCHA';
		if ( preg_match( '/#_SUBMIT/', $format ) ) {
			$format = preg_replace( '/#_SUBMIT/', "$captcha_text<br>#_SUBMIT", $format );
		} else {
			$format .= $captcha_text;
		}
	}
	if ( ! preg_match( '/#_SUBMIT/', $format ) ) {
		$format .= '<br>#_SUBMIT';
	}
	return $format;
}

function eme_captcha_remove( $captcha_file ) {
	if ( ! empty( $captcha_file ) && is_string( $captcha_file ) && file_exists( $captcha_file ) ) {
		wp_delete_file( $captcha_file );
	}
}

function eme_if_shortcode( $atts, $content ) {
	extract(
	    shortcode_atts(
		    [
			    'tag'         => '',
			    'value'       => '',
			    'eq'          => '',
			    'notvalue'    => '',
			    'ne'          => '',
			    'lt'          => '',
			    'le'          => '',
			    'gt'          => '',
			    'ge'          => '',
			    'contains'    => '',
			    'notcontains' => '',
			    'is_empty'    => 0,
			    'incsv'       => '',
			    'notincsv'    => '',
		    ],
		    $atts
		)
	);
	// replace placeholders if eme_if is used outside EME shortcodes
	$tag     = eme_replace_generic_placeholders( $tag );
	$content = eme_replace_generic_placeholders( $content );
	if ( $is_empty ) {
		if ( empty( $tag ) ) {
			return do_shortcode( $content );
		}
	} elseif ( is_numeric( $value ) || ! empty( $value ) ) {
		if ( $tag == $value ) {
			return do_shortcode( $content );
		}
	} elseif ( is_numeric( $eq ) || ! empty( $eq ) ) {
		if ( $tag == $eq ) {
			return do_shortcode( $content );
		}
	} elseif ( is_numeric( $ne ) || ! empty( $ne ) ) {
		if ( $tag != $ne ) {
			return do_shortcode( $content );
		}
	} elseif ( is_numeric( $notvalue ) || ! empty( $notvalue ) ) {
		if ( $tag != $notvalue ) {
			return do_shortcode( $content );
		}
	} elseif ( is_numeric( $lt ) || ! empty( $lt ) ) {
		if ( $tag < $lt ) {
			return do_shortcode( $content );
		}
	} elseif ( is_numeric( $le ) || ! empty( $le ) ) {
		if ( $tag <= $le ) {
			return do_shortcode( $content );
		}
	} elseif ( is_numeric( $gt ) || ! empty( $gt ) ) {
		if ( $tag > $gt ) {
			return do_shortcode( $content );
		}
	} elseif ( is_numeric( $ge ) || ! empty( $ge ) ) {
		if ( $tag >= $ge ) {
			return do_shortcode( $content );
		}
	} elseif ( is_numeric( $contains ) || ! empty( $contains ) ) {
		if ( strpos( $tag, "$contains" ) !== false ) {
			return do_shortcode( $content );
		}
	} elseif ( is_numeric( $notcontains ) || ! empty( $notcontains ) ) {
		if ( strpos( $tag, "$notcontains" ) === false ) {
			return do_shortcode( $content );
		}
	} elseif ( is_numeric( $incsv ) || ! empty( $incsv ) ) {
		if ( preg_match( '/,/', $incsv ) ) {
			$incsv_arr = explode( ',', $incsv );
			foreach ( $incsv_arr as $incsv ) {
				$incsv = trim( $incsv );
				if ( in_array( $incsv, explode( ',', $tag ) ) || in_array( $incsv, explode( ', ', $tag ) ) ) {
					return do_shortcode( $content );
				}
			}
		} elseif ( preg_match( '/\+/', $incsv ) ) {
			$incsv_arr = preg_split( '/\+/', $incsv, 0, PREG_SPLIT_NO_EMPTY );
			$found = 1;
			foreach ( $incsv_arr as $incsv ) {
				$incsv = trim( $incsv );
				if ( ! ( in_array( $incsv, explode( ',', $tag ) ) || in_array( $incsv, explode( ', ', $tag ) ) ) ) {
						$found = 0;
				}
			}
			if ( $found ) {
				return do_shortcode( $content );
			}
		} else {
			$incsv = trim( $incsv );
			if ( in_array( $incsv, explode( ',', $tag ) ) || in_array( $incsv, explode( ', ', $tag ) ) ) {
				return do_shortcode( $content );
			}
		}
	} elseif ( is_numeric( $notincsv ) || ! empty( $notincsv ) ) {
		if ( preg_match( '/,/', $notincsv ) ) {
			$notincsv_arr = explode( ',', $notincsv );
			$found = 0;
			foreach ( $notincsv_arr as $notincsv ) {
				$notincsv = trim( $notincsv );
				if ( in_array( $notincsv, explode( ',', $tag ) ) || in_array( $notincsv, explode( ', ', $tag ) ) ) {
					$found = 1;
				}
			}
			if ( ! $found ) {
				return do_shortcode( $content );
			}
		} elseif ( preg_match( '/\+/', $notincsv ) ) {
			$notincsv_arr = preg_split( '/\+/', $notincsv, 0, PREG_SPLIT_NO_EMPTY );
			$found = 0;
			foreach ( $notincsv_arr as $notincsv ) {
				$notincsv = trim( $notincsv );
				if ( in_array( $notincsv, explode( ',', $tag ) ) || in_array( $notincsv, explode( ', ', $tag ) ) ) {
						$found = 1;
				} else {
					$found = 0;
				}
			}
			if ( ! $found ) {
				return do_shortcode( $content );
			}
		} else {
			$notincsv = trim( $notincsv );
			if ( ! ( in_array( $notincsv, explode( ',', $tag ) ) || in_array( $notincsv, explode( ', ', $tag ) ) ) ) {
				return do_shortcode( $content );
			}
		}
	} elseif ( ! empty( $tag ) ) {
		return do_shortcode( $content );
	}
	// return empty in all other cases
	return '';
}

function eme_for_shortcode( $atts, $content ) {
	extract(
	    shortcode_atts(
		    [
			    'min'  => 1,
			    'max'  => 0,
			    'list' => '',
			    'sep'  => ',',
		    ],
		    $atts
	    )
	);
	$min         = intval( $min );
	$max         = intval( $max );
	$result      = '';
	$loopcounter = 1;
	if ( ! empty( $list ) ) {
		$list   = eme_replace_generic_placeholders($list); // currently mainly usefull to loop over all categories when using #_ALLCATEGORYIDS
		$search = [ '#_LOOPVALUE', '#URL_LOOPVALUE', '#_LOOPCOUNTER' ];
		$array_values = explode( $sep, $list );
		foreach ( $array_values as $val ) {
			$url_val     = rawurlencode( $val );
			$esc_val     = eme_sanitize_request( eme_esc_html( preg_replace( '/\n|\r/', '', $val ) ) );
			$replace     = [ $esc_val, $url_val, $loopcounter ];
			$tmp_content = str_replace( $search, $replace, $content );
			$result     .= do_shortcode( $tmp_content );
			++$loopcounter;
		}
	} else {
		$search = [ '#_LOOPVALUE', '#_LOOPCOUNTER' ];
		while ( $min <= $max ) {
			$replace     = [ $min, $loopcounter ];
			$tmp_content = str_replace( $search, $replace, $content );
			$result     .= do_shortcode( $tmp_content );
			++$min;
			++$loopcounter;
		}
	}
	return $result;
}

// Returns true if the page in question is the events page
function eme_is_events_page() {
	$events_page_id = eme_get_events_page_id();
	if ( $events_page_id ) {
		return is_page( $events_page_id );
	} else {
		return false;
	}
}

function eme_get_events_page_id() {
	// in theory every call to get_option is cached, but since we also check for polylang translation issues
	// we don't want to call the pll_ functions too often ...
	$page_id = wp_cache_get( "eme_page_id" );
        if ( $page_id === false ) {
		$page_id = get_option( 'eme_events_page' );
		// if a language is set, then remove it
		// this needs a bit optimising so it is not executed each time though ...
		if ( function_exists( 'pll_get_post_language' ) ) {
			$post_lang = pll_get_post_language($page_id);
			if (!empty($post_lang)) {
				pll_set_post_language($page_id,'');
			}
		}
		wp_cache_set( "eme_page_id", $page_id, '', 5 );
        }
	return $page_id;
}

function eme_get_events_page( $justurl = 1, $text = '' ) {
	$events_page_id = eme_get_events_page_id();
	if (!empty($events_page_id)) {
                $page_link      = get_permalink( $events_page_id );
        } else {
                $page_link      = trailingslashit( home_url() );
        }
	if ( $justurl || empty( $text ) ) {
		$result = $page_link;
	} else {
		$text   = eme_esc_html( $text );
		$result = "<a href='$page_link' title='$text'>$text</a>";
	}
	return $result;
}

function eme_is_single_day_page() {
	return ( eme_is_events_page() && ! empty( get_query_var( 'calendar_day' ) ) );
}

function eme_is_single_event_page() {
	return ( eme_is_events_page() && ! empty( get_query_var( 'event_id' ) ) );
}

function eme_is_single_location_page() {
	return ( eme_is_events_page() && ! empty( get_query_var( 'location_id' ) ) && empty( get_query_var( 'calendar_day' ) ) );
}

function eme_get_contact( $contact_id = 0 ) {
	$userinfo = false;
	if ($contact_id > 0 ) {
		$userinfo = get_userdata( $contact_id );
	}
	// suppose the user has been deleted ...
	if ( $userinfo === false ) {
		$contact_id = intval(get_option( 'eme_default_contact_person',0) );
		$userinfo = get_userdata( $contact_id );
	}
	// still false? Means the user doesn't exist and the default contact person neither
	if ( $userinfo === false ) {
		if ( function_exists( 'is_multisite' ) && is_multisite() ) {
			$thisblog = get_current_blog_id();
			$userinfo = get_user_by( 'email', get_blog_option( $thisblog, 'admin_email' ) );
		} else {
			$userinfo = get_user_by( 'email', get_option( 'admin_email' ) );
		}
		// still nothing ? Can be if the main admin email is not matching a user, so get the first admin
		if ( ! $userinfo ) {
			$user_query = new WP_User_Query( array( 'role' => 'administrator', 'number' => 1 ) );
			$users      = $user_query->get_results(); // array of WP_User objects, like get_users
			$userinfo   = $users[0];
		}
	}
	return $userinfo;
}

function eme_get_event_contact( $event = null ) {
	if ( ! is_null( $event ) && ! empty( $event['event_contactperson_id'] ) ) {
		$contact_id = $event['event_contactperson_id'];
		if ( $contact_id < 1 && isset( $event['event_author'] ) && $event['event_author'] > 0 ) {
			$contact_id = $event['event_author'];
		}
	} else {
		$contact_id = intval(get_option( 'eme_default_contact_person',0) );
	}
	return eme_get_contact( $contact_id );
}

function eme_get_author( $event ) {
	$author_id = $event['event_author'];
	if ( $author_id < 1 ) {
		if ( function_exists( 'is_multisite' ) && is_multisite() ) {
			$thisblog = get_current_blog_id();
			$userinfo = get_user_by( 'email', get_blog_option( $thisblog, 'admin_email' ) );
		} else {
			$userinfo = get_user_by( 'email', get_option( 'admin_email' ) );
		}
		#$contact_id = get_current_user_id();
	} else {
		$userinfo = get_userdata( $author_id );
	}
	return $userinfo;
}

function eme_get_user_phone( $user_id ) {
	return get_user_meta( $user_id, 'eme_phone', true );
}

function eme_update_user_phone( $user_id, $phone ) {
	update_user_meta( $user_id, 'eme_phone', $phone );
}

// got from http://davidwalsh.name/php-email-encode-prevent-spam
function eme_ascii_encode( $e, $target = 'html' ) {
	return eme_email_obfuscate( $e, $target );
}
function eme_email_obfuscate( $e, $target = 'html' ) {
	if ( $target == 'htmlmail' ) {
		return eme_esc_html( $e );
	} elseif ( $target == 'text' ) {
		return $e;
	} else {
		$output = '';
		if ( has_filter( 'eme_email_obfuscate_filter' ) ) {
			$output = apply_filters( 'eme_email_obfuscate_filter', $e );
		} else {
			for ( $i = 0; $i < strlen( $e ); $i++ ) {
				$output .= '&#' . ord( $e[ $i ] ) . ';';
			}
		}
		return $output;
	}
}

function eme_unique_slug( $slug, $table, $column, $index_col, $index_colval = 0 ) {
	global $wpdb;
	$table_name = EME_DB_PREFIX . $table;
	$slug       = untrailingslashit( $slug );
	// code taken from function wp_unique_term_slug
	$query = $wpdb->prepare( "SELECT $column FROM $table_name WHERE $index_col<> $index_colval AND $column = %s", $slug );
	// it exists .... so strip of the last numbers and start finding new ones
	if ( $wpdb->get_var( $query ) ) {
		$slug = preg_replace( '/\-\d+$/', '', $slug );
		$num  = 2;
		do {
			$alt_slug = $slug . "-$num";
			++$num;
			$slug_check = $wpdb->get_var( $wpdb->prepare( "SELECT $column FROM $table_name WHERE $index_col<> $index_colval AND $column = %s", $alt_slug ) );
		} while ( $slug_check );
			$slug = $alt_slug;
	}
	return $slug;
}

function eme_permalink_convert_noslash( $val ) {
	// return the permalink without trailing slash
	return eme_permalink_convert( $val, 0 );
}

function eme_permalink_convert( $val, $trailing_slash = 1 ) {
	// WP provides a function to convert accents to their ascii counterparts
	// called remove_accents, but we also want to replace spaces with "-"
	// and trim the last space. sanitize_title_with_dashes does all that
	// first call untrailingslashit to remove a trailing '/' if at all present in the value
	$val = sanitize_title_with_dashes( remove_accents( untrailingslashit( $val ) ) );
	// now remove anything that would be a html char
	// from https://stackoverflow.com/questions/2103797/url-friendly-username-in-php
	$val = strtolower( trim( preg_replace( '~[^0-9a-z]+~i', '-', html_entity_decode( preg_replace( '~&([a-z]{1,2})(?:acute|cedil|circ|grave|lig|orn|ring|slash|th|tilde|uml);~i', '$1', htmlentities( $val, ENT_QUOTES, 'UTF-8' ) ), ENT_QUOTES, 'UTF-8' ) ), '-' ) );

	// and then, add a trailing slash
	if ( $trailing_slash ) {
		return trailingslashit( $val );
	} else {
		return $val;
	}
}

function eme_event_url( $event, $language = '' ) {
	global $wp_rewrite;

	if ( $event['event_url'] != '' && get_option( 'eme_use_external_url' ) && eme_is_url( $event['event_url'] ) ) {
		$the_link = $event['event_url'];
		$parsed   = parse_url( $the_link );
		if ( empty( $parsed['scheme'] ) ) {
			$the_link = 'https://' . ltrim( $the_link, '/' );
		}
		$the_link = esc_url( $the_link );
	} else {
		if ( empty( $language ) ) {
			$language = eme_detect_lang();
		}
		if ( isset( $wp_rewrite ) && $wp_rewrite->using_permalinks() && get_option( 'eme_seo_permalink' ) ) {
			$events_prefixes = explode( ',', get_option( 'eme_permalink_events_prefix', 'events' ) );
			if ( ! empty( $event['event_prefix'] ) && in_array( $event['event_prefix'], $events_prefixes ) ) {
				$events_prefix = eme_permalink_convert( $event['event_prefix'] );
			} else {
				$events_prefix = eme_permalink_convert( $events_prefixes[0] );
			}
			if ( empty( $event['event_slug'] ) ) {
				$name = $events_prefix . $event['event_id'] . '/' . eme_permalink_convert_noslash( $event['event_name'] );
			} elseif ( substr( $event['event_slug'], -1 ) == '/' ) { // old style stuff
				$name = $events_prefix . $event['event_id'] . '/' . eme_permalink_convert_noslash( $event['event_slug'] );
			} else {
				$name = $events_prefix . eme_permalink_convert_noslash( $event['event_slug'] );
			}
			$the_link = eme_uri_add_lang( $name, $language );
		} else {
			$the_link = eme_get_events_page();
			$the_link = add_query_arg( [ 'event_id' => $event['event_id'] ], $the_link );
			if ( ! empty( $language ) ) {
				// some plugins add the lang info to the home_url, remove it so we don't get into trouble or add it twice
				$the_link = remove_query_arg( 'lang', $the_link );
				$the_link = add_query_arg( [ 'lang' => $language ], $the_link );
			}
		}
	}
	return $the_link;
}

function eme_location_url( $location, $language = '' ) {
	global $wp_rewrite;

	$the_link = '';
	if ( $location['location_url'] != '' && ( get_option( 'eme_use_external_url' ) || $location['location_properties']['online_only'] ) && eme_is_url( $location['location_url'] ) ) {
		$the_link = $location['location_url'];
		$parsed   = parse_url( $the_link );
		if ( empty( $parsed['scheme'] ) ) {
			$the_link = 'https://' . ltrim( $the_link, '/' );
		}
		$the_link = esc_url( $the_link );
	} elseif ( isset( $location['location_id'] ) && isset( $location['location_name'] ) ) {
		if ( empty( $language ) ) {
			$language = eme_detect_lang();
		}
		if ( isset( $wp_rewrite ) && $wp_rewrite->using_permalinks() && get_option( 'eme_seo_permalink' ) ) {
			$locations_prefixes = explode( ',', get_option( 'eme_permalink_locations_prefix', 'locations' ) );
			if ( ! empty( $location['location_prefix'] ) && in_array( $location['location_prefix'], $locations_prefixes ) ) {
				$locations_prefix = eme_permalink_convert( $location['location_prefix'] );
			} else {
				$locations_prefix = eme_permalink_convert( $locations_prefixes[0] );
			}

			if ( empty( $location['location_slug'] ) ) {
				$name = $locations_prefix . $location['location_id'] . '/' . eme_permalink_convert_noslash( $location['location_name'] );
			} elseif ( substr( $location['location_slug'], -1 ) == '/' ) {
				$name = $locations_prefix . $location['location_id'] . '/' . eme_permalink_convert_noslash( $location['location_slug'] );
			} else {
				$name = $locations_prefix . eme_permalink_convert_noslash( $location['location_slug'] );
			}
			$the_link = eme_uri_add_lang( $name, $language );
		} else {
			$the_link = eme_get_events_page();
			$the_link = add_query_arg( [ 'location_id' => $location['location_id'] ], $the_link );
			if ( ! empty( $language ) ) {
				// some plugins add the lang info to the home_url, remove it so we don't get into trouble or add it twice
				$the_link = remove_query_arg( 'lang', $the_link );
				$the_link = add_query_arg( [ 'lang' => $language ], $the_link );
			}
		}
	}
	return $the_link;
}

function eme_calendar_day_url( $day ) {
	global $wp_rewrite;

	$language = eme_detect_lang();

	if ( isset( $wp_rewrite ) && $wp_rewrite->using_permalinks() && get_option( 'eme_seo_permalink' ) ) {
		$cal_prefix_option = get_option( 'eme_permalink_calendar_prefix', '' );
		if ( empty( $cal_prefix_option ) ) {
			$events_prefixes = explode( ',', get_option( 'eme_permalink_events_prefix', 'events' ) );
			$cal_prefix = eme_permalink_convert( $events_prefixes[0] );
		} else {
			$cal_prefix = eme_permalink_convert( $cal_prefix_option );
		}
		$name     = $cal_prefix . eme_permalink_convert_noslash( $day );
		$the_link = eme_uri_add_lang( $name, $language );
	} else {
		$the_link = eme_get_events_page();
		$the_link = add_query_arg( [ 'calendar_day' => $day ], $the_link );
		if ( ! empty( $language ) ) {
			// some plugins add the lang info to the home_url, remove it so we don't get into trouble or add it twice
			$the_link = remove_query_arg( 'lang', $the_link );
			$the_link = add_query_arg( [ 'lang' => $language ], $the_link );
		}
	}
	return $the_link;
}

function eme_booking_confirm_url( $payment ) {
	// the user confirm url is actually going to the payment page as well, but we use another permalink to be nicer to people
	global $wp_rewrite;

	$language = eme_detect_lang();
	if ( isset( $wp_rewrite ) && $wp_rewrite->using_permalinks() && get_option( 'eme_seo_permalink' ) ) {
		$events_prefixes = explode( ',', get_option( 'eme_permalink_events_prefix', 'events' ) );
		$confirm_prefix  = eme_permalink_convert( $events_prefixes[0] ) . 'confirm/';
		$name            = $confirm_prefix . $payment['random_id'];
		$the_link        = eme_uri_add_lang( $name, $language );
	} else {
		$the_link = eme_get_events_page();
		$the_link = add_query_arg(
			[
				'eme_pmt_rndid'    => $payment['random_id'],
				'eme_rsvp_confirm' => 1,
			],
		    $the_link
		);
		if ( ! empty( $language ) ) {
			// some plugins add the lang info to the home_url, remove it so we don't get into trouble or add it twice
			$the_link = remove_query_arg( 'lang', $the_link );
			$the_link = add_query_arg( [ 'lang' => $language ], $the_link );
		}
	}
	return $the_link;
}

function eme_payment_url( $payment, $resultcode = 0 ) {
	global $wp_rewrite;

	$language = eme_detect_lang();
	if ( isset( $wp_rewrite ) && $wp_rewrite->using_permalinks() && get_option( 'eme_seo_permalink' ) ) {
		$payments_prefix_option = get_option( 'eme_permalink_payments_prefix', '' );
		if ( empty( $payments_prefix_option ) ) {
			$events_prefixes = explode( ',', get_option( 'eme_permalink_events_prefix', 'events' ) );
			$payments_prefix = eme_permalink_convert( $events_prefixes[0] ) . 'p/';
		} else {
			$payments_prefix = eme_permalink_convert( $payments_prefix_option );
		}
		$name     = $payments_prefix . $payment['random_id'];
		$the_link = eme_uri_add_lang( $name, $language );
	} else {
		$the_link = eme_get_events_page();
		$the_link = add_query_arg( [ 'eme_pmt_rndid' => $payment['random_id'] ], $the_link );
		if ( ! empty( $language ) ) {
			// some plugins add the lang info to the home_url, remove it so we don't get into trouble or add it twice
			$the_link = remove_query_arg( 'lang', $the_link );
			$the_link = add_query_arg( [ 'lang' => $language ], $the_link );
		}
	}
	if ( $resultcode > 0 ) {
		// we return the payment url but we want to indicate a payment failure too
		$the_link = add_query_arg( [ 'res_fail' => $resultcode ], $the_link );
	}
	return $the_link;
}

function eme_category_url( $category ) {
	global $wp_rewrite;

	$language = eme_detect_lang();
	if ( isset( $wp_rewrite ) && $wp_rewrite->using_permalinks() && get_option( 'eme_seo_permalink' ) ) {
		$categories_prefixes = explode( ',', get_option( 'eme_permalink_categories_prefix', '' ) );
		if ( empty( $categories_prefixes ) ) {
			$categories_prefixes = explode( ',', get_option( 'eme_permalink_events_prefix', 'events' ) );
			$extra_prefix = 'cat/';
		} else {
			$extra_prefix = '';
		}
		if ( ! empty( $category['category_prefix'] ) && in_array( $category['category_prefix'], $categories_prefixes ) ) {
				$cats_prefix = eme_permalink_convert( $category['category_prefix'] );
		} else {
			$cats_prefix = eme_permalink_convert( $categories_prefixes[0] );
		}
		if ( empty( $category['category_slug'] ) ) {
			$name = $cats_prefix . $extra_prefix . eme_permalink_convert_noslash( $category['category_name'] );
		} else {
			$name = $cats_prefix . $extra_prefix . eme_permalink_convert_noslash( $category['category_slug'] );
		}

		$the_link = eme_uri_add_lang( $name, $language );
	} else {
		$the_link = eme_get_events_page();
		$slug     = $category['category_slug'] ? $category['category_slug'] : $category['category_name'];
		$the_link = add_query_arg( [ 'eme_event_cat' => $slug ], $the_link );
		if ( ! empty( $language ) ) {
			// some plugins add the lang info to the home_url, remove it so we don't get into trouble or add it twice
			$the_link = remove_query_arg( 'lang', $the_link );
			$the_link = add_query_arg( [ 'lang' => $language ], $the_link );
		}
	}
	return $the_link;
}

function eme_check_invite_url( $event_id ) {
	if ( isset( $_REQUEST['eme_invite'] ) ) {
		$invite_get = eme_sanitize_request( $_REQUEST['eme_invite'] );
	} else {
		return 0;
	}
	if ( isset( $_REQUEST['eme_email'] ) ) {
		$hash_string = eme_sanitize_email( $_REQUEST['eme_email'] );
	} else {
		return 0;
	}
	if ( ! empty( $_REQUEST['eme_ln'] ) ) {
		$hash_string .= eme_sanitize_request( $_REQUEST['eme_ln'] );
	}
	if ( ! empty( $_REQUEST['eme_fn'] ) ) {
		$hash_string .= eme_sanitize_request( $_REQUEST['eme_fn'] );
	}
	$invite_check = wp_hash( $hash_string . '|' . $event_id, 'nonce' );
	if ( $invite_check != $invite_get ) {
		return 0;
	} else {
		return 1;
	}
}

function eme_invite_url( $event, $email, $lastname, $firstname, $lang ) {
	$the_link    = eme_event_url( $event, $lang );
	$hashstring  = $email . $lastname . $firstname;
	$invite_hash = wp_hash( $hashstring . '|' . $event['event_id'], 'nonce' );
	$the_link    = add_query_arg(
		[
			'eme_email'  => $email,
			'eme_invite' => $invite_hash,
		],
		$the_link
	);
	if ( ! empty( $lastname ) ) {
		$the_link = add_query_arg( [ 'eme_ln' => $lastname ], $the_link );
	}
	if ( ! empty( $firstname ) ) {
		$the_link = add_query_arg( [ 'eme_fn' => $firstname ], $the_link );
	}
	return $the_link;
}

function eme_check_rsvp_url( $payment, $booking_id ) {
	$the_link = eme_get_events_page();
	$the_link = add_query_arg(
		[
			'eme_check_rsvp' => 1,
			'eme_pmt_rndid'  => $payment['random_id'],
			'bid'  => $booking_id,
		],
	    $the_link
	);
	return $the_link;
}

function eme_cpi_url( $person_id, $orig_email ) {
	$language = eme_detect_lang();

	$the_link = eme_get_events_page();
	$nonce    = wp_create_nonce( "change_pi $person_id $orig_email" );
	$the_link = add_query_arg(
		[
			'eme_cpi'       => $person_id,
			'email'         => $orig_email,
			'eme_cpi_nonce' => $nonce,
		],
	    $the_link
	);
	if ( ! empty( $language ) ) {
		// some plugins add the lang info to the home_url, remove it so we don't get into trouble or add it twice
		$the_link = remove_query_arg( 'lang', $the_link );
		$the_link = add_query_arg( [ 'lang' => $language ], $the_link );
	}
	return $the_link;
}

function eme_check_member_url() {
	if ( isset( $_GET['member_id'] ) ) {
		$member_id = intval( $_GET['member_id'] );
	} else {
		return 0;
	}
	if ( isset( $_GET['eme_nonce'] ) ) {
		$nonce_get = eme_sanitize_request( $_GET['eme_nonce'] );
	} else {
		return 0;
	}
	$nonce_check = wp_hash( $member_id, 'nonce' );
	if ( $nonce_check != $nonce_get ) {
		return 0;
	} else {
		return eme_is_active_memberid( $member_id );
	}
}

function eme_member_url( $member ) {
	$the_link = eme_get_events_page();
	$the_link = add_query_arg( [ 'eme_check_member' => 1 ], $the_link );
	$the_link = add_query_arg( [ 'member_id' => $member['member_id'] ], $the_link );
	$hash     = wp_hash( $member['member_id'], 'nonce' );
	$the_link = add_query_arg( [ 'eme_nonce' => $hash ], $the_link );
	return $the_link;
}

function eme_payment_return_url( $payment, $resultcode ) {
	$the_link = eme_get_events_page();
	if ( is_numeric( $resultcode ) && $resultcode == 0 ) {
		$res = 'success';
	} elseif ( is_numeric( $resultcode ) && $resultcode == 1 ) {
		//$res="fail";
		return eme_payment_url( $payment, $resultcode );
	} else {
		// if the resultcode is not 1 or 2, we return it literally
		// this is used for e.g. mollie, which in background first transfers the
		// payment result using the notification link and then redirects to the return url
		$res = $resultcode;
	}
	$the_link = add_query_arg( [ 'eme_pmt_result' => $res ], $the_link );
	$the_link = add_query_arg( [ 'eme_pmt_rndid' => $payment['random_id'] ], $the_link );
	return $the_link;
}

function eme_tasksignup_cancel_url( $signup ) {
	$language = eme_detect_lang();

	$the_link = eme_get_events_page();
	$the_link = add_query_arg( [ 'eme_cancel_signup' => $signup['random_id'] ], $the_link );
	if ( ! empty( $language ) ) {
		// some plugins add the lang info to the home_url, remove it so we don't get into trouble or add it twice
		$the_link = remove_query_arg( 'lang', $the_link );
		$the_link = add_query_arg( [ 'lang' => $language ], $the_link );
	}
	return $the_link;
}

function eme_cancel_url( $payment ) {
	$language = eme_detect_lang();

	$the_link = eme_get_events_page();
	$the_link = add_query_arg( [ 'eme_cancel' => $payment['random_id'] ], $the_link );
	if ( ! empty( $language ) ) {
		// some plugins add the lang info to the home_url, remove it so we don't get into trouble or add it twice
		$the_link = remove_query_arg( 'lang', $the_link );
		$the_link = add_query_arg( [ 'lang' => $language ], $the_link );
	}
	return $the_link;
}

function eme_unsub_url() {
	$language = eme_detect_lang();

	$the_link = eme_get_events_page();
	$the_link = add_query_arg( [ 'eme_unsub' => 1 ], $the_link );
	if ( ! empty( $language ) ) {
		// some plugins add the lang info to the home_url, remove it so we don't get into trouble or add it twice
		$the_link = remove_query_arg( 'lang', $the_link );
		$the_link = add_query_arg( [ 'lang' => $language ], $the_link );
	}
	return $the_link;
}

function eme_unsub_confirm_url( $email, $groups ) {
	$language = eme_detect_lang();

	$the_link = eme_get_events_page();
	$nonce    = wp_create_nonce( "unsub $email$groups" );
	$the_link = add_query_arg(
		[
			'eme_unsub_confirm' => $email,
			'eme_unsub_nonce'   => $nonce,
		],
		$the_link
	);
	if ( ! empty( $groups ) ) {
		$the_link = add_query_arg( [ 'g' => $groups ], $the_link );
	}
	if ( ! empty( $language ) ) {
		// some plugins add the lang info to the home_url, remove it so we don't get into trouble or add it twice
		$the_link = remove_query_arg( 'lang', $the_link );
		$the_link = add_query_arg( [ 'lang' => $language ], $the_link );
	}
	return $the_link;
}

function eme_sub_confirm_url( $lastname, $firstname, $email, $groups ) {
	$language = eme_detect_lang();

	$the_link = eme_get_events_page();
	$nonce    = wp_create_nonce( "sub $lastname$firstname$email$groups" );
	$the_link = add_query_arg(
		[
			'eme_sub_confirm' => $email,
			'lastname'        => $lastname,
			'firstname'       => $firstname,
			'eme_sub_nonce'   => $nonce,
		],
		$the_link
	);
	if ( ! empty( $groups ) ) {
		$the_link = add_query_arg( [ 'g' => $groups ], $the_link );
	}
	if ( ! empty( $language ) ) {
		// some plugins add the lang info to the home_url, remove it so we don't get into trouble or add it twice
		$the_link = remove_query_arg( 'lang', $the_link );
		$the_link = add_query_arg( [ 'lang' => $language ], $the_link );
	}
	return $the_link;
}

function eme_single_event_ical_url( $id ) {
	$language = eme_detect_lang();

	$the_link = site_url( '/?eme_ical=public_single&event_id=' . $id );
	if ( ! empty( $language ) ) {
		$the_link = add_query_arg( [ 'lang' => $language ], $the_link );
	}
	return $the_link;
}

function eme_captcha_url( $file ) {
	$the_link = '';
	// if there's an issue with the tmp dir, return false so we can show a message in the form
	$tmp_dir = get_temp_dir();
	if ( ! @is_dir( $tmp_dir ) || ! wp_is_writable( $tmp_dir ) ) {
		return false;
	}
	// ts added to try and prevent initial caching
	$the_link = add_query_arg(
		[
			'eme_captcha' => 'generate',
			'f'           => $file,
			'ts'          => time(),
		],
		$the_link
	);
	return $the_link;
}

function eme_tracker_url( $random_id ) {
	$the_link = eme_get_events_page();
	$the_link = add_query_arg( [ 'eme_tracker_id' => $random_id ], $the_link );
	return $the_link;
}

function eme_current_page_url( $extra_arg = [] ) {
	global $wp;
	$the_link = home_url( add_query_arg( [], $wp->request ) );
	if ( ! empty( $extra_arg ) ) {
		$extra_arg = array_map( 'esc_attr', $extra_arg );
		$the_link  = add_query_arg( $extra_arg, $the_link );
	}
	return $the_link;
}

function eme_check_event_exists( $id ) {
	$event = eme_get_event( $id );
	return $event;
}

function eme_check_location_exists( $id ) {
	$location = eme_get_location( $id );
	return $location;
}

function eme_are_dates_valid( $dates ) {
	// if it is a series of dates
	if ( strstr( $dates, ',' ) ) {
		$dates_arr = explode( ',', $dates );
		foreach ( $dates_arr as $date ) {
			if ( ! eme_is_date( $date ) ) {
				return false;
			}
		}
	} elseif ( ! eme_is_date( $dates ) ) {
		return false;
	}
	return true;
}

function eme_is_date( $date ) {
	// check the format yyyy-mm-dd
	if ( strlen( $date ) != 10 ) {
		return false;
	}
	$year  = intval( substr( $date, 0, 4 ) );
	$month = intval( substr( $date, 5, 2 ) );
	$day   = intval( substr( $date, 8 ) );
	return ( checkdate( $month, $day, $year ) );
}

function eme_is_datetime( $date ) {
	$format = 'Y-m-d H:i:s';
	$d      = DateTime::createFromFormat( $format, $date );
	return $d && $d->format( $format ) == $date;
}

function eme_capNamesCB( $cap ) {
	$cap = str_replace( '_', ' ', $cap );
	$cap = ucfirst( $cap );
	return $cap;
}
function eme_get_all_caps() {
	global $wp_roles;
	$capabilities = [];

	foreach ( $wp_roles->roles as $role ) {
		if ( $role['capabilities'] ) {
			foreach ( $role['capabilities'] as $cap => $val ) {
				if ( ! preg_match( '/^level/', $cap ) ) {
					$capabilities[ $cap ] = eme_capNamesCB( $cap );
				}
			}
		}
	}

	#   $sys_caps = get_option('syscaps');
	#   if ( is_array($sys_caps) ) {
	#      $capabilities = array_merge($sys_caps, $capabilities);
	#   }

	asort( $capabilities );
	return $capabilities;
}

function eme_status_array() {
	$status_array                              = [];
	$status_array[ EME_EVENT_STATUS_PUBLIC ]   = __( 'Public', 'events-made-easy' );
	$status_array[ EME_EVENT_STATUS_PRIVATE ]  = __( 'Private', 'events-made-easy' );
	$status_array[ EME_EVENT_STATUS_UNLISTED ] = __( 'Unlisted (hidden)', 'events-made-easy' );
	$status_array[ EME_EVENT_STATUS_DRAFT ]    = __( 'Draft', 'events-made-easy' );
	$status_array[ EME_EVENT_STATUS_FS_DRAFT ] = __( 'Frontend Draft (unpaid)', 'events-made-easy' );
	return $status_array;
}

function eme_member_status_array() {
	$status_array                              = [];
	$status_array[ EME_MEMBER_STATUS_PENDING ] = __( 'Pending', 'events-made-easy' );
	$status_array[ EME_MEMBER_STATUS_ACTIVE ]  = __( 'Active', 'events-made-easy' );
	$status_array[ EME_MEMBER_STATUS_GRACE ]   = __( 'Grace period', 'events-made-easy' );
	$status_array[ EME_MEMBER_STATUS_EXPIRED ] = __( 'Expired', 'events-made-easy' );
	return $status_array;
}

// The next function is to format the datetime in the expected format for the calendar javascript to be able to parse it
// If the argument is just a date (no time portion), this function doesn't need to be called since the calendar JS can cope with that already
function eme_js_datetime( $mydate, $timezone = '' ) {
	if ( empty( $timezone ) ) {
		$timezone = EME_TIMEZONE;
	}

	//  $ExactBrowserNameUA=strtolower($_SERVER['HTTP_USER_AGENT']);
	//  if (strpos($ExactBrowserNameUA, "safari/") and strpos($ExactBrowserNameUA, "opr/")==false and strpos($ExactBrowserNameUA, "chrome/")==false) {
	//     $safari=1;
	//  } else {
	//     $safari=0;
	//  }

	if ( empty( $mydate ) || preg_match( '/^0000-00-00/', $mydate ) ) {
		return '';
	} elseif ( strstr( $mydate, ',' ) ) {
		$dates   = explode( ',', $mydate );
		$res_arr = [];
		foreach ( $dates as $date ) {
			$eme_date_obj = new ExpressiveDate( $date, $timezone );
			//if ($safari)
			//     $res_arr[]=$eme_date_obj->format('U')*1000;
			//  else
				$res_arr[] = $eme_date_obj->format( 'Y-m-d\TH:i:s' );
		}
		return join( ',', $res_arr );
	} else {
		$eme_date_obj = new ExpressiveDate( $mydate, $timezone );
		//if ($safari)
		//     return $eme_date_obj->format('U')*1000;
		//  else
		return $eme_date_obj->format( 'Y-m-d\TH:i:s' );
	}
}

function eme_get_time_from_dt( $datetime ) {
	return substr( $datetime, 11, 8 );
}
function eme_get_date_from_dt( $datetime ) {
	return substr( $datetime, 0, 10 );
}

function eme_N_weekday( $date_obj ) {
	return $date_obj->format( 'N' );
}

function eme_localized_datetime( $mydate, $timezone = '', $datetime_format = '' ) {
	if ( eme_is_empty_datetime( $mydate ) ) {
		return '';
	}
	if ( $datetime_format == 1 ) {
		return eme_localized_date( $mydate, $timezone, 1 ) . ' ' . eme_localized_time( $mydate, $timezone, 1 );
	} elseif ( ! empty( $datetime_format ) ) {
		return eme_localized_date( $mydate, $timezone, $datetime_format );
	} else {
		return eme_localized_date( $mydate, $timezone ) . ' ' . eme_localized_time( $mydate, $timezone );
	}
}

function eme_localized_date( $mydate, $timezone = '', $date_format = '' ) {
	if ( eme_is_empty_date( $mydate ) ) {
		return '';
	}
	if ( $date_format == 1 ) {
		$date_format = get_option( 'eme_backend_dateformat' );
	}
	if ( empty( $date_format ) ) {
		$date_format = EME_WP_DATE_FORMAT;
	}
	if ( empty( $timezone ) ) {
		$timezone = EME_TIMEZONE;
	}

	// catch possible issues with invalid/unparseable dates etc ...
	try {
		// $mydate contains the timezone, but in case it doesn't we provide it
		$eme_date_obj = new ExpressiveDate( $mydate, $timezone );
	} catch ( Exception $error ) {
		return $mydate;
	}

	$eme_tz_obj = new DateTimeZone( $timezone );
	$result     = wp_date( $date_format, $eme_date_obj->getTimestamp(), $eme_tz_obj );
	return $result;
}

function eme_localized_time( $mytime, $timezone = '', $time_format = '' ) {
	if ( $time_format == 1 ) {
		$time_format = get_option( 'eme_backend_timeformat' );
	}
	if ( empty( $time_format ) ) {
		$time_format = EME_WP_TIME_FORMAT;
	}
	if ( empty( $timezone ) ) {
		$timezone = EME_TIMEZONE;
	}

	// if strlen is >6, we assume it includes the date-portion in the string too
	if ( strlen( $mytime ) < 6 ) {
		$result = eme_localized_date( '2012-01-01 ' . $mytime, $timezone, $time_format );
	} else {
		$result = eme_localized_date( $mytime, $timezone, $time_format );
	}
	if ( get_option( 'eme_time_remove_leading_zeros' ) ) {
		$result = str_replace( ':00', '', $result );
		$result = str_replace( ':0', ':', $result );
	}
	return $result;
}

function eme_convert_localized_time( $time_format, $mytime ) {
	if ( empty( $time_format ) ) {
		$time_format = EME_WP_TIME_FORMAT;
	}

	if ( empty ( $mytime ) ) {
		return '';
	}
	$date_obj = ExpressiveDate::createfromformat( $time_format, $mytime, ExpressiveDate::parseSuppliedTimezone( EME_TIMEZONE ) );
	return $date_obj->format( 'H:i:00' );
}

// the following is the same as eme_localized_date, but for rfc822 format
function eme_rfc822_date( $mydate, $tz ) {
	//$result = date('r', strtotime($mydate));
	$eme_date_obj = new ExpressiveDate( $mydate, $tz );
	return $eme_date_obj->format( 'r' );
}

function eme_localized_currencysymbol( $cur, $target = 'html' ) {
	if ( ! class_exists( 'NumberFormatter' ) ) {
		return $cur;
	} else {
		$locale    = determine_locale();
		$formatter = new NumberFormatter( $locale . "@currency=$cur", NumberFormatter::CURRENCY );
		return $formatter->getSymbol( NumberFormatter::CURRENCY_SYMBOL );
	}
}

function eme_localized_price( $price, $cur, $target = 'html' ) {
	// number_format needs a floating point, so if price is empty (for e.g. discounts), make it 0
	if ( empty( $price ) ) {
		$price = 0;
	}
	if ( eme_is_multi( $price ) ) {
		$price_arr = eme_convert_multi2array( $price );
	} else {
		$price_arr = [ $price ];
	}

	$locale = determine_locale();
	if ( class_exists( 'NumberFormatter' ) && get_option( 'eme_localize_price' ) ) {
			$eme_localize_price = 1;
	} else {
		$eme_localize_price = 0;
	}

	if ( $eme_localize_price ) {
		$formatter = new NumberFormatter( $locale . "@currency=$cur", NumberFormatter::CURRENCY );
	}

	$eme_zero_decimal_currencies_arr = eme_zero_decimal_currencies();
	if ( in_array( $cur, $eme_zero_decimal_currencies_arr ) ) {
		$decimals = 0;
	} else {
		$decimals = intval( get_option( 'eme_decimals' ) );
	}

	$res = [];
	foreach ( $price_arr as $t_price ) {
		if ( $eme_localize_price ) {
			$result = $formatter->formatCurrency( $t_price, $cur );
		} else {
			$result = number_format_i18n( $t_price, $decimals );
		}

		// the result can contain html entities, for e.g. text mails we don't want that of course
		if ( $target == 'html' ) {
			$res[] = $result;
		} else {
			$res[] = html_entity_decode( $result );
		}
	}
	return implode( '||', $res );
}

function eme_int_price( $price ) {
	// number_format needs a floating point, so if price is empty (for e.g. discounts), make it 0
	if ( empty( $price ) ) {
		$price = 0;
	}

	$locale = determine_locale();
	if ( class_exists( 'NumberFormatter' ) ) {
		$formatter = new NumberFormatter( $locale, NumberFormatter::DECIMAL );
		$res       = numfmt_parse( $formatter, $price );
		if ( $res === false ) {
			$res = $price;
		}
	} else {
		$res = $price;
	}
	if ( is_numeric( $res ) ) {
		return $res;
	} else {
		return 0;
	}
}

function eme_currency_array() {
	$currency_array         = [];
	$currency_array ['ARS'] = __( 'Argentine Peso', 'events-made-easy' );
	$currency_array ['AUD'] = __( 'Australian Dollar', 'events-made-easy' );
	$currency_array ['BIF'] = __( 'Burundian Franc', 'events-made-easy' );
	$currency_array ['BRL'] = __( 'Brazilian Real', 'events-made-easy' );
	$currency_array ['CAD'] = __( 'Canadian Dollar', 'events-made-easy' );
	$currency_array ['CLP'] = __( 'Chilean Peso', 'events-made-easy' );
	$currency_array ['CNY'] = __( 'Chinese Yuan Renminbi', 'events-made-easy' );
	$currency_array ['CZK'] = __( 'Czech Koruna', 'events-made-easy' );
	$currency_array ['DKK'] = __( 'Danish Krone', 'events-made-easy' );
	$currency_array ['DJF'] = __( 'Djiboutian Franc', 'events-made-easy' );
	$currency_array ['EUR'] = __( 'Euro', 'events-made-easy' );
	$currency_array ['GBP'] = __( 'Pound Sterling', 'events-made-easy' );
	$currency_array ['GNF'] = __( 'Guinean Franc', 'events-made-easy' );
	$currency_array ['HKD'] = __( 'Hong Kong Dollar', 'events-made-easy' );
	$currency_array ['HUF'] = __( 'Hungarian Forint', 'events-made-easy' );
	$currency_array ['INR'] = __( 'Indian Rupee', 'events-made-easy' );
	$currency_array ['ILS'] = __( 'Israeli New Sheqel', 'events-made-easy' );
	$currency_array ['JPY'] = __( 'Japanese Yen', 'events-made-easy' );
	$currency_array ['KMF'] = __( 'Comoro Franc', 'events-made-easy' );
	$currency_array ['KRW'] = __( 'South Korean Won', 'events-made-easy' );
	$currency_array ['MGA'] = __( 'Malagasy Ariary', 'events-made-easy' );
	$currency_array ['MXN'] = __( 'Mexican Peso', 'events-made-easy' );
	$currency_array ['NOK'] = __( 'Norwegian Krone', 'events-made-easy' );
	$currency_array ['NZD'] = __( 'New Zealand Dollar', 'events-made-easy' );
	$currency_array ['PHP'] = __( 'Philippine Peso', 'events-made-easy' );
	$currency_array ['PLN'] = __( 'Polish Zloty', 'events-made-easy' );
	$currency_array ['PYG'] = __( 'Paraguayan Guarani', 'events-made-easy' );
	$currency_array ['RUB'] = __( 'Russian Ruble', 'events-made-easy' );
	$currency_array ['RWF'] = __( 'Rwandan Franc', 'events-made-easy' );
	$currency_array ['SGD'] = __( 'Singapore Dollar', 'events-made-easy' );
	$currency_array ['SEK'] = __( 'Swedish Krona', 'events-made-easy' );
	$currency_array ['CHF'] = __( 'Swiss Franc', 'events-made-easy' );
	$currency_array ['THB'] = __( 'Thai Baht', 'events-made-easy' );
	$currency_array ['USD'] = __( 'U.S. Dollar', 'events-made-easy' );
	$currency_array ['VND'] = __( 'Vietnamese dong', 'events-made-easy' );
	$currency_array ['VUV'] = __( 'Vanuatu vatu', 'events-made-easy' );
	$currency_array ['XAF'] = __( 'CFA Franc BEAC', 'events-made-easy' );
	$currency_array ['XOF'] = __( 'CFA Franc BCEAO', 'events-made-easy' );
	$currency_array ['XPF'] = __( 'CFP Franc (Franc Pacifique)', 'events-made-easy' );
	$currency_array ['ZAR'] = __( 'South African Rand', 'events-made-easy' );

	# the next filter allows people to add extra currencies:
	if ( has_filter( 'eme_add_currencies' ) ) {
		$currency_array = apply_filters( 'eme_add_currencies', $currency_array );
	}
	natcasesort( $currency_array );
	return $currency_array;
}

function eme_currency_codes() {
	$currency_array         = [];
	$currency_array ['ARS'] = '032';
	$currency_array ['AUD'] = '036';
	$currency_array ['BIF'] = '108';
	$currency_array ['BRL'] = '986';
	$currency_array ['CAD'] = '124';
	$currency_array ['CLP'] = '152';
	$currency_array ['CNY'] = '156';
	$currency_array ['CZK'] = '203';
	$currency_array ['DKK'] = '208';
	$currency_array ['DJF'] = '262';
	$currency_array ['EUR'] = '978';
	$currency_array ['GBP'] = '826';
	$currency_array ['GNF'] = '978';
	$currency_array ['HKD'] = '344';
	$currency_array ['HUF'] = '348';
	$currency_array ['INR'] = '356';
	$currency_array ['ILS'] = '376';
	$currency_array ['JPY'] = '392';
	$currency_array ['KMF'] = '174';
	$currency_array ['KRW'] = '410';
	$currency_array ['MGA'] = '969';
	$currency_array ['MXN'] = '484';
	$currency_array ['NOK'] = '578';
	$currency_array ['NZD'] = '554';
	$currency_array ['PHP'] = '608';
	$currency_array ['PLN'] = '985';
	$currency_array ['PYG'] = '600';
	$currency_array ['RWF'] = '646';
	$currency_array ['SGD'] = '702';
	$currency_array ['SEK'] = '752';
	$currency_array ['CHF'] = '756';
	$currency_array ['THB'] = '764';
	$currency_array ['USD'] = '840';
	$currency_array ['VND'] = '704';
	$currency_array ['VUV'] = '548';
	$currency_array ['XAF'] = '950';
	$currency_array ['XOF'] = '952';
	$currency_array ['XPF'] = '953';
	$currency_array ['ZAR'] = '710';

	# the next filter allows people to add extra currencies:
	if ( has_filter( 'eme_add_currency_codes' ) ) {
		$currency_array = apply_filters( 'eme_add_currency_codes', $currency_array );
	}
	return $currency_array;
}

function eme_zero_decimal_currencies() {
	# returns an array of currencies that don't have decimals
	$currency_array = [
		'BIF',
		'CLP',
		'DJF',
		'GNF',
		'JPY',
		'KMF',
		'KRW',
		'MGA',
		'PYG',
		'RWF',
		'VND',
		'VUV',
		'XAF',
		'XOF',
		'XPF',
	];
	# the next filter allows people to add extra currencies:
	if ( has_filter( 'eme_add_zero_decimal_currencies' ) ) {
		$currency_array = apply_filters( 'eme_add_zero_decimal_currencies', $currency_array );
	}
	return $currency_array;
}

function eme_thumbnail_sizes() {
	$sizes = [];
	foreach ( get_intermediate_image_sizes() as $s ) {
		$sizes[ $s ] = $s;
	}
	return $sizes;
}

function eme_unique_nbr_check( $my_nbr ) {
	// zero pad to the left with zeros (if string length is smaller than 12)
	// and make sure to only take the last 10 chars (if string lenght is greater than 12)
	$unique_nbr        = substr( sprintf( '%012d', $my_nbr ), -12 );
	$unique_nbr_main   = substr( $unique_nbr, 0, 10 );
	$unique_nbr_verify = eme_unique_nbr( $unique_nbr_main );
	return ( $unique_nbr == $unique_nbr_verify );
}

function eme_unique_nbr( $my_nbr ) {
	// zero pad to the left with zeros (if string length is smaller than 10)
	// and make sure to only take the last 10 chars (if string lenght is greater than 10)
	$unique_nbr_main = substr( sprintf( '%010d', $my_nbr ), -10 );
	// the control number is the %97 result, or 97 in case %97=0
	$unique_nbr_check = $unique_nbr_main % 97;
	if ( $unique_nbr_check == 0 ) {
		$unique_nbr_check = 97;
	}
	$unique_nbr_check = sprintf( '%02d', $unique_nbr_check );
	return $unique_nbr_main . $unique_nbr_check;
}

function eme_array_has_dupes($my_arr) {
	if (!empty($my_arr) && is_array($my_arr)) {
		return count($my_arr) !== count(array_unique($my_arr));
	} else {
		return false;
	}
}

function eme_unique_nbr_formatted( $my_nbr ) {
	if ( empty( $my_nbr ) ) {
		return $my_nbr;
	}
	return '+++' . substr( $my_nbr, 0, 3 ) . '/' . substr( $my_nbr, 3, 4 ) . '/' . substr( $my_nbr, 7, 5 ) . '+++';
}

// returns 1 if each element of array1 is > than the correspondig element of array2
function eme_array_gt( $array1, $array2 ) {
	if ( count( $array1 ) != count( $array2 ) ) {
		return false;
	}
	foreach ( $array1 as $key => $value ) {
		if ( $array1[ $key ] <= $array2[ $key ] ) {
			return 0;
		}
	}
	return 1;
}

// returns 1 if each element of array1 is >= the correspondig element of array2
function eme_array_ge( $array1, $array2 ) {
	if ( count( $array1 ) != count( $array2 ) ) {
		return false;
	}
	foreach ( $array1 as $key => $value ) {
		if ( $array1[ $key ] < $array2[ $key ] ) {
			return 0;
		}
	}
	return 1;
}

// returns 1 if each element of array1 is < than the correspondig element of array2
function eme_array_lt( $array1, $array2 ) {
	if ( count( $array1 ) != count( $array2 ) ) {
		return false;
	}
	foreach ( $array1 as $key => $value ) {
		if ( $array1[ $key ] >= $array2[ $key ] ) {
			return 0;
		}
	}
	return 1;
}

// returns 1 if each elements of array1 is <= than the correspondig element of array2
function eme_array_le( $array1, $array2 ) {
	if ( count( $array1 ) != count( $array2 ) ) {
		return false;
	}
	foreach ( $array1 as $key => $value ) {
		if ( $array1[ $key ] > $array2[ $key ] ) {
			return 0;
		}
	}
	return 1;
}

// returns true if the array values are all numeric
function eme_is_numeric_array( $only_numbers ) {
	if ( ! is_array( $only_numbers ) ) {
		return false;
	}
	return array_filter( $only_numbers, 'is_numeric' ) === $only_numbers;
}

function eme_is_list_of_numbers( $text ) {
	if ( strstr( $text, ',' ) ) {
		$id_arr = explode( ',', $text );
		return eme_is_numeric_array( $id_arr );
	} elseif ( ! is_numeric( $text ) ) {
		return false;
	}
	return true;
}

// returns true if the array values are all integers
function eme_is_integer_array( $only_integers ) {
	if ( ! is_array( $only_integers ) ) {
		return false;
	}
	return array_filter( $only_integers, 'eme_isInt' ) === $only_integers;
}

function eme_is_list_of_int( $text ) {
	$id_arr = explode( ',', $text );
	return eme_is_integer_array( $id_arr );
}

function eme_array_remove_empty_elements( $arr ) {
	$arr = array_filter( $arr, 'strlen' );
	return $arr;
}

function eme_nl2br( $arg ) {
	return preg_replace( "/\r\n?|\n\r?/", '<br>', $arg );
}

function eme_br2nl( $arg ) {
	return preg_replace( '/<br ?\/?>/', "\n", $arg );
}

function eme_str_numbers_only( $arg ) {
	return preg_replace( '/[^0-9]/', '', $arg );
}

function eme_str_only( $arg ) {
	return preg_replace( '/[^0-9a-z_\.\-]/i', '', $arg );
}

function eme_is_url( $url ) {
	if ( eme_is_empty_string( $url ) ) {
		return false;
	}
	$parsed = parse_url( $url );
	if ( empty( $parsed['scheme'] ) ) {
		$url = 'https://' . ltrim( $url, '/' );
	}
	return filter_var( $url, FILTER_VALIDATE_URL );
}

// emails entered via frontend form need to be checked better
function eme_is_email_frontend( $email ) {
	return eme_is_email( $email, 1);
}

function eme_is_email( $email, $extra_checks_required = 0 ) {
	if ( eme_is_empty_string( $email ) ) {
		return false;
	}
	// FILTER_VALIDATE_EMAIL is not utf-8 compliant
	// so we add an extra regex too, which allows pretty much every unicode word characters
	$email_regex_ok = 0;
	if ( filter_var( $email, FILTER_VALIDATE_EMAIL ) ) {
		$email_regex_ok = 1;
	} elseif ( preg_match( '/^[\w\-\.\+]+@([\w\-]+\.)+[\w\-]{2,63}$/u', $email ) ) {
		$email_regex_ok = 1;
	}
	if (!$email_regex_ok) {
		return false;
	}

	if ( $extra_checks_required ) {
		// check the blacklist
		$mail_blacklist = get_option( 'eme_mail_blacklist' );
		if ( ! empty( $mail_blacklist ) ) {
			foreach ( preg_split( "/((\r?\n)|(\r\n?))/", $mail_blacklist ) as $line ) {
				$line = preg_quote( trim( $line ) );
				if ( preg_match( "/$line$/", $email ) ) {
					return false;
				}
			}
		}

		// now do a dns lookup
		// get the part after the '@'
		$fqdn = substr( strrchr( $email, '@' ), 1 );
		// add trailing '.'
		$fqdn .= ( substr( $fqdn, -1 ) == '.' ? '' : '.' );
		$mx_records = [];
		$result = getmxrr( $fqdn, $mx_records );
		if ( $result ) {
			if ( ! isset( $mx_records ) || ( count( $mx_records ) == 0 ) ) {
				$result = false;
			}
			$mx_resolve = false;
			foreach ( $mx_records as $mx_record ) {
				$result = filter_var( gethostbyname( $mx_record ), FILTER_VALIDATE_IP );
				if ( ! empty( $result ) ) {
					$mx_resolve = true;
				}
			}
			if ( ! $mx_resolve ) {
				$result = false;
			}
		}
		// no mx found? Then try the hostname
		if ( ! $result ) {
			$result = filter_var( gethostbyname( $fqdn ), FILTER_VALIDATE_IP );
		}
		if ( empty( $result ) ) {
			return false;
		}
	}
	return true;
}

function eme_is_multi( $element ) {
	if ( preg_match( '/\|\|/', $element ) ) {
		return 1;
	} else {
		return 0;
	}
}

function eme_convert_multi2br( $multistring ) {
	if (empty($multistring)) {
		return '';
	}
	return str_replace( '||', '<br>', $multistring );
}

function eme_convert_multi2array( $multistring ) {
	if (empty($multistring)) {
		return [];
	}
	return explode( '||', $multistring );
}

function eme_convert_array2multi( $multiarr, $sep = '||' ) {
	if (empty($multiarr)) {
		return '';
	}
	return join( $sep, $multiarr );
}

function eme_random_id() {
	$length = 14 + 32;
	if ( function_exists( 'random_bytes' ) ) {
		$bytes = random_bytes( ceil( $length / 2 ) );
		return substr( bin2hex( $bytes ), 0, $length );
	} elseif ( function_exists( 'openssl_random_pseudo_bytes' ) ) {
		$bytes = openssl_random_pseudo_bytes( ceil( $length / 2 ) );
		return substr( bin2hex( $bytes ), 0, $length );
	} else {
		// the original function, and added substr to it so it never goes beyond 50 chars
		return substr( uniqid(), 0, 13 ) . '_' . substr( md5( mt_rand() ), 0, 32 );
	}
}

// API function so people can call this from their theme's search.php
function eme_wordpress_search_locations() {
	if ( isset( $_REQUEST['s'] ) ) {
		return eme_search_locations( eme_sanitize_request($_REQUEST['s']) );
	}
}

// API function so people can call this from their theme's search.php
function eme_wordpress_search( $scope = 'future' ) {
	return eme_wordpress_search_events( $scope );
}
function eme_wordpress_search_events( $scope = 'future' ) {
	if ( isset( $_REQUEST['s'] ) ) {
		return eme_search_events( eme_sanitize_request($_REQUEST['s']), $scope );
	}
}

function eme_fake_booking( $event ) {
	$booking = eme_booking_from_form( $event );
	// indicate a negative person ID, so we can check on that later on if needed
	$booking['person_id'] = -1;
	return $booking;
}

function eme_booking_from_form( $event ) {
	$booking        = eme_new_booking();
	$bookedSeats    = 0;
	$bookedSeats_mp = [];
	$dcodes_entered = [];
	$event_id       = $event['event_id'];
	if ( ! eme_is_multi( $event['price'] ) ) {
		if ( isset( $_POST['bookings'][ $event_id ]['bookedSeats'] ) ) {
			$bookedSeats = intval( $_POST['bookings'][ $event_id ]['bookedSeats'] );
		} else {
			$bookedSeats = 0;
		}
	} else {
		// for multiple prices, we have multiple booked Seats as well
		// the next foreach is only valid when called from the frontend

		// make sure the array contains the correct keys first
		$booking_prices_mp = eme_convert_multi2array( $event['price'] );
		foreach ( $booking_prices_mp as $key => $value ) {
			$bookedSeats_mp[ $key ] = 0;
		}
		if ( isset( $_POST['bookings'][ $event_id ] ) ) {
			foreach ( $_POST['bookings'][ $event_id ] as $key => $value ) {
				if ( preg_match( '/bookedSeats(\d+)/', eme_sanitize_request( $key ), $matches ) ) {
					$field_id                    = intval( $matches[1] ) - 1;
					$bookedSeats                += intval( $value );
					$bookedSeats_mp[ $field_id ] = intval( $value );
				}
			}
		}
	}
	if ( isset( $_POST['bookings'][ $event_id ] ) ) {
		foreach ( $_POST['bookings'][ $event_id ] as $key => $value ) {
			if ( preg_match( '/^DISCOUNT/', eme_sanitize_request( $key ), $matches ) ) {
				$discount_value = eme_sanitize_request( $value );
				if ( ! empty( $value ) ) {
					$dcodes_entered[] = $discount_value;
				}
			}
		}
	}

	// for non-multi event seats, let's check the waitinglist option too
	if ( ! eme_is_multi( $event['event_seats'] ) ) {
		$waitinglist_seats = $event['event_properties']['waitinglist_seats'];
		// check for real available seats excluding waitinglis
		$avail_seats = eme_get_available_seats( $event_id, 1 );
		if ( $waitinglist_seats > 0 && $avail_seats <= 0 ) {
			$booking['waitinglist'] = 1;
		}
	}

	if ( isset( $_POST['bookings'][ $event_id ]['eme_rsvpcomment'] ) ) {
		$bookerComment = eme_sanitize_textarea( $_POST['bookings'][ $event_id ]['eme_rsvpcomment'] );
	} elseif ( isset( $_POST['eme_rsvpcomment'] ) ) {
		$bookerComment = eme_sanitize_textarea( $_POST['eme_rsvpcomment'] );
	} else {
		$bookerComment = '';
	}

	$booking['booking_id']       = 0;
	$booking['event_id']         = $event_id;
	$booking['booking_seats']    = $bookedSeats;
	$booking['booking_seats_mp'] = eme_convert_array2multi( $bookedSeats_mp );
	$booking['event_price']      = $event['price'];
	$booking['booking_comment']  = $bookerComment;
	$booking['extra_charge']     = eme_store_booking_answers( $booking, 0 );

	$booking['dcodes_entered'] = $dcodes_entered;
	$calc_discount             = eme_booking_discount( $event, $booking );
	$booking['discount']       = $calc_discount['discount'];
	$booking['dcodes_used']    = $calc_discount['dcodes_used'];
	$booking['discountids']    = $calc_discount['discountids'];
	$booking['dgroupid']       = $calc_discount['dgroupid'];
	$booking['remaining']      = eme_get_total_booking_price( $booking );
	return $booking;
}

add_action( 'wp_ajax_eme_calc_bookingprice', 'eme_calc_bookingprice_ajax' );
add_action( 'wp_ajax_nopriv_eme_calc_bookingprice', 'eme_calc_bookingprice_ajax' );
function eme_calc_bookingprice_ajax() {
        // has an extra frontend nonce set (even if executed in the backend)
        check_ajax_referer( 'eme_frontend', 'eme_frontend_nonce' );

	header( 'Content-type: application/json; charset=utf-8' );
	// first detect multibooking
	$event_ids = [];
	if ( isset( $_POST['bookings'] ) ) {
		foreach ( $_POST['bookings'] as $key => $val ) {
			$event_ids[] = intval( $key );
		}
	}
	$total = 0;
	$cur   = '';

	foreach ( $event_ids as $event_id ) {
		$event = eme_get_event( $event_id );
		if ( ! empty( $event ) ) {
			$fake_booking = eme_fake_booking( $event );
			$total       += $fake_booking['remaining'];
			$cur          = $event['currency'];
		}
	}

	$result = eme_localized_price( $total, $cur );
	echo wp_json_encode( [ 'total' => $result ] );
	wp_die();
}

// the people dyndata only gets called from the backend, so we use wp ajax and check the admin nonce
add_action( 'wp_ajax_eme_people_dyndata', 'eme_dyndata_people_ajax' );
function eme_dyndata_people_ajax() {
	check_admin_referer( 'eme_admin', 'eme_admin_nonce' );
	// for new persons, the id=0
	if ( isset( $_POST['person_id'] ) ) {
		$person_id = intval( $_POST['person_id'] );
	} else {
		$person_id = 0;
	}
	$dynamic_field_class = 'nodynamicupdates dynamicfield';

	if ( $person_id ) {
		$answers = eme_get_person_answers( $person_id );
		$files   = eme_get_uploaded_files( $person_id, 'people' );
	} else {
		$answers = [];
		$files   = [];
	}

	if ( isset( $_POST['groups'] ) && eme_is_numeric_array( $_POST['groups'] ) ) {
		$groups = eme_sanitize_request( $_POST['groups'] );
	} else {
		$groups = [];
	}
	// We need the groupid 0 as the first element, to show fields not belonging to a specific group (the array keys are not important here, only the values)
	array_unshift( $groups, '0' );
	$form_html = '';
	foreach ( $groups as $group_id ) {
		$group      = eme_get_group( $group_id );
		$fields = eme_get_dyndata_people_fields( 'group:' . $group_id );
		if ( ! empty( $fields ) ) {
			if ( ! $group_id ) {
				$form_html .= "<hr><div><span id='eme-people-dyndata-group-" . $group_id . "'>" . eme_esc_html( __( 'Extra info', 'events-made-easy' ) ) . '</span><table>';
			} else {
				$form_html .= "<hr><div><span id='eme-people-dyndata-group-" . $group_id . "'>" . eme_esc_html( __( 'Group', 'events-made-easy' ) . ' ' . $group['name'] ) . '</span><table>';
			}
			foreach ( $fields as $formfield ) {
				$field_id       = $formfield['field_id'];
				$form_html     .= '<tr><td>';
				$name           = eme_trans_esc_html( $formfield['field_name'] );
				$form_html     .= "$name</td><td>";
				$var_prefix     = "dynamic_personfields[$person_id][";
				$var_postfix    = ']';
				$postfield_name = "{$var_prefix}FIELD" . $field_id . $var_postfix;
				$postvar_arr    = [ 'dynamic_personfields', $person_id, 'FIELD' . $field_id ];
				// the first time there's no $_POST yet
				if ( ! empty( $_POST ) ) {
					$entered_val = eme_getValueFromPath( $_POST, $postvar_arr );
				} else {
					$entered_val = false;
				}

				if ( $entered_val === false ) {
					foreach ( $answers as $answer ) {
						if ( $answer['field_id'] == $field_id ) {
							$entered_val = $answer['answer'];
						}
					}
				}
				// the next code prevents uploading a file for a file field if already done
				if ( $formfield['field_type'] == 'file' || $formfield['field_type'] == 'multifile' ) {
					$entered_files = [];
					foreach ( $files as $file ) {
						if ( $file['field_id'] == $field_id ) {
							$entered_files[] = $file;
						}
					}
					$entered_val = $entered_files;
				}
				if ( $formfield['field_required'] ) {
					$required = 1;
				} else {
					$required = 0;
				}
				$form_html .= eme_get_formfield_html( $formfield, $postfield_name, $entered_val, $required, $dynamic_field_class );
				if ( $formfield['field_required'] ) {
					$form_html .= "<div class='eme-required-field'>" . get_option( 'eme_form_required_field_string' ) . '</div>';
				}
				$form_html .= '</td></tr>';
			}
			$form_html .= '</table></div>';
		}
	}
	echo wp_json_encode( [ 'Result' => $form_html ] );
	wp_die();
}

add_action( 'wp_ajax_eme_dyndata_rsvp', 'eme_dyndata_rsvp_ajax' );
add_action( 'wp_ajax_nopriv_eme_dyndata_rsvp', 'eme_dyndata_rsvp_ajax' );
function eme_dyndata_rsvp_ajax() {
	// has an extra frontend nonce set (even if executed in the backend)
        check_ajax_referer( 'eme_frontend', 'eme_frontend_nonce' );

	header( 'Content-type: application/json; charset=utf-8' );
	// first detect multibooking
	$event_ids = [];
	if ( ! empty( $_POST['eme_event_ids'] ) ) {
		$event_ids = array_map( 'intval', $_POST['eme_event_ids'] );
	} elseif ( eme_is_admin_request() && ! empty( $_POST['event_id'] ) ) {
		// the case when adding a booking in the backend
		$event_ids = [ 0 => intval( $_POST['event_id'] ) ];
	}

	if ( ! empty( $_POST['booking_id'] ) ) {
		// the case when editing a booking in the backend
		$booking_id = intval( $_POST['booking_id'] );
		check_admin_referer( "eme_admin", 'eme_admin_nonce' );
		$booking   = eme_get_booking( $booking_id );
		$event_ids = [ 0 => $booking['event_id'] ];
	} else {
		$booking = [];
	}

	$form_html = '';
	foreach ( $event_ids as $event_id ) {
		$event = eme_get_event( $event_id );
		if ( empty( $event ) ) {
			continue;
		}
		// we use a fake booking to get an initial price based on current entered data
		$fake_booking = eme_fake_booking( $event );
		if ( ! empty( $booking ) ) {
			// if we work on an existing booking (backend), take some values from the fake booking and keep the rest
			$booking['booking_seats']    = $fake_booking['booking_seats'];
			$booking['booking_seats_mp'] = $fake_booking['booking_seats_mp'];
			$booking['booking_comment']  = $fake_booking['booking_comment'];
			$fake_booking                = $booking;
		}

		if ( isset( $event['event_properties']['rsvp_dyndata'] ) ) {
			$conditions = $event['event_properties']['rsvp_dyndata'];
			foreach ( $conditions as $count => $condition ) {
				// the next check is mostly to eliminate older conditions that didn't have the field-param
				if ( empty( $condition['field'] ) ) {
					continue;
				}
				// sensible values ...
				if ( empty( $condition['grouping'] ) ) {
					$grouping = $count;
				} else {
					$grouping = intval( $condition['grouping'] );
				}

				if ( $condition['field'] == '#_GROUPS' ) {
					$wp_id       = eme_get_wpid_by_post();
					$entered_val = join( ',', eme_esc_html( eme_get_persongroup_names( 0, $wp_id ) ) );
				} else {
					// indicate "1" to make sure the answers are taken from the POST, and not from the existing member
					$entered_val = eme_replace_booking_placeholders( $condition['field'], $event, $fake_booking, 0, 'html', '', 1 );
				}

				if ( $condition['condition'] == 'eq' && $entered_val == $condition['condval'] ) {
					$template   = eme_get_template_format( $condition['template_id'] );
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_header'] ) );
					$form_html .= eme_replace_dynamic_rsvp_formfields_placeholders( $event, $fake_booking, $template, $grouping );
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_footer'] ) );
				}
				if ( $condition['condition'] == 'ne' && $entered_val != $condition['condval'] ) {
					$template   = eme_get_template_format( $condition['template_id'] );
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_header'] ) );
					$form_html .= eme_replace_dynamic_rsvp_formfields_placeholders( $event, $fake_booking, $template, $grouping );
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_footer'] ) );
				}
				if ( $condition['condition'] == 'contains' && strpos( $entered_val, $condition['condval'] ) !== false ) {
					$template   = eme_get_template_format( $condition['template_id'] );
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_header'] ) );
					$form_html .= eme_replace_dynamic_rsvp_formfields_placeholders( $event, $fake_booking, $template, $grouping );
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_footer'] ) );
				}
				if ( $condition['condition'] == 'notcontains' && strpos( $entered_val, $condition['condval'] ) === false ) {
					$template   = eme_get_template_format( $condition['template_id'] );
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_header'] ) );
					$form_html .= eme_replace_dynamic_rsvp_formfields_placeholders( $event, $fake_booking, $template, $grouping );
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_footer'] ) );
				}
				if ( $condition['condition'] == 'incsv' && ( in_array( $condition['condval'], explode( ',', $entered_val ) ) || in_array( $condition['condval'], explode( ', ', $entered_val ) ) ) ) {
					$template   = eme_get_template_format( $condition['template_id'] );
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_header'] ) );
					$form_html .= eme_replace_dynamic_rsvp_formfields_placeholders( $event, $fake_booking, $template, $grouping );
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_footer'] ) );
				}
				if ( $condition['condition'] == 'notincsv' && ! ( in_array( $condition['condval'], explode( ',', $entered_val ) ) || in_array( $condition['condval'], explode( ', ', $entered_val ) ) ) ) {
					$template   = eme_get_template_format( $condition['template_id'] );
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_header'] ) );
					$form_html .= eme_replace_dynamic_rsvp_formfields_placeholders( $event, $fake_booking, $template, $grouping );
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_footer'] ) );
				}
				if ( $condition['condition'] == 'lt' && $entered_val < $condition['condval'] ) {
					$template   = eme_get_template_format( $condition['template_id'] );
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_header'] ) );
					if ( $condition['repeat'] ) {
						$entered_val          = intval( $entered_val );
						$condition['condval'] = intval( $condition['condval'] );
						for ( $i = $entered_val;$i < $condition['condval'];$i++ ) {
							$form_html .= eme_replace_dynamic_rsvp_formfields_placeholders( $event, $fake_booking, $template, $grouping, $i - $entered_val );
						}
					} else {
						$form_html .= eme_replace_dynamic_rsvp_formfields_placeholders( $event, $fake_booking, $template, $grouping );
					}
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_footer'] ) );
				}
				if ( $condition['condition'] == 'gt' && $entered_val > $condition['condval'] ) {
					$template   = eme_get_template_format( $condition['template_id'] );
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_header'] ) );
					if ( $condition['repeat'] ) {
						$entered_val          = intval( $entered_val );
						$condition['condval'] = intval( $condition['condval'] );
						for ( $i = $condition['condval'];$i < $entered_val;$i++ ) {
							$form_html .= eme_replace_dynamic_rsvp_formfields_placeholders( $event, $fake_booking, $template, $grouping, $i - $condition['condval'] );
						}
					} else {
						$form_html .= eme_replace_dynamic_rsvp_formfields_placeholders( $event, $fake_booking, $template, $grouping );
					}
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_footer'] ) );
				}
				if ( $condition['condition'] == 'ge' && $entered_val >= $condition['condval'] ) {
					$template   = eme_get_template_format( $condition['template_id'] );
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_header'] ) );
					if ( $condition['repeat'] ) {
						$entered_val          = intval( $entered_val );
						$condition['condval'] = intval( $condition['condval'] );
						for ( $i = $condition['condval'];$i <= $entered_val;$i++ ) {
							$form_html .= eme_replace_dynamic_rsvp_formfields_placeholders( $event, $fake_booking, $template, $grouping, $i - $condition['condval'] );
						}
					} else {
						$form_html .= eme_replace_dynamic_rsvp_formfields_placeholders( $event, $fake_booking, $template, $grouping );
					}
					$form_html .= eme_replace_generic_placeholders( eme_get_template_format( $condition['template_id_footer'] ) );
				}
			}
		}
	}
	echo wp_json_encode( [ 'Result' => do_shortcode( $form_html ) ] );
	wp_die();
}

function eme_safe_css_attributes( $array ) {
	$eme_allowed = get_option( 'eme_allowed_style_attr' );
	foreach ( preg_split( "/((\r?\n)|(\r\n?))/", $eme_allowed ) as $line ) {
		$array[] = $line;
	}
	return $array;
}
function eme_safe_css_remove_attributes( $array ) {
	$eme_allowed = get_option( 'eme_allowed_style_attr' );
	foreach ( preg_split( "/((\r?\n)|(\r\n?))/", $eme_allowed ) as $line ) {
		unset( $array[ $line ] );
	}
	return $array;
}

function _eme_kses_single( $value, $allow_unfiltered ) {
	if ( empty( $value ) ) {
		return $value;
	}
	$value = eme_strip_weird( $value );
	// To filter out JS, we should use domdocument, but the problem is that sometimes the
	// html is intentional incomplete, which would cause issues with domdocument
	// See https://codereview.stackexchange.com/questions/30045/regex-to-remove-inline-javascript-from-string
	if ( $allow_unfiltered ) {
		// even for unfiltered: strip out javascript
		$res = preg_replace( '#<\s*script(.*?)>(.*?)<\s*/\s*script\s*>#is', '', wp_unslash( $value ) );
		# also strip out inline javascript (onalert etc)
		$res = preg_replace( '#\b[^(\?|\&|\S)]on\w+\s*=\s*\S+(?=.*>)#', '', $res );
		return $res;
	}
	$allowed_html = wp_kses_allowed_html( 'post' );
	// this option is per line
	// one line is first the tag and then the allowed attributes, all seperated by ','
	$eme_allowed = get_option( 'eme_allowed_html' );
	foreach ( preg_split( "/((\r?\n)|(\r\n?))/", $eme_allowed ) as $line ) {
		$line = preg_replace( '/\s+/', '', $line );
		$info = explode( ',', $line );
		// the first element is the tag, the rest the attributes
		$tag = array_shift( $info );
		if ( ! array_key_exists( $tag, $allowed_html ) ) {
			$allowed_html[ $tag ] = [];
		}
		foreach ( $info as $attr ) {
			$allowed_html[ $tag ][ $attr ] = true;
		}
	}
	// always allow span, style and meta
	$allowed_html[ 'span '] = [];
	$allowed_html[ 'meta '] = [];
	$allowed_html[ 'style '] = [];

	add_filter( 'safe_style_css', 'eme_safe_css_attributes' );
	// brute-force remove script tags, even if wp_kses wouldn't do it
	$res = preg_replace( '#<\s*script(.*?)>(.*?)<\s*/\s*script\s*>#is', '', wp_kses( wp_unslash( $value ), $allowed_html ) );
	# also strip out inline javascript (onalert etc)
	$res = preg_replace( '#\bon\w+\s*=\s*\S+(?=.*>)#', '', $res );
	add_filter( 'safe_style_css', 'eme_safe_css_remove_attributes' );
	return $res;
}

function eme_kses( $value ) {
	$allow_unfiltered = 0;
	if ( is_array( $value ) ) {
		return array_map( 'eme_kses', $value );
	} else {
		return _eme_kses_single( $value, $allow_unfiltered );
	}
}

function eme_kses_maybe_unfiltered( $value ) {
	$allow_unfiltered = 1;
	// if allow_unfiltered is on: check if the user is actually allowed do it
	if ( ! current_user_can( 'unfiltered_html' ) ) {
		$allow_unfiltered = 0;
	}
	if ( is_array( $value ) ) {
		return array_map( 'eme_kses_maybe_unfiltered', $value );
	} else {
		return _eme_kses_single( $value, $allow_unfiltered );
	}
}

// backwards compatible
function eme_strip_js( $value ) {
	return eme_kses( $value );
}

function eme_strip_weird( $value ) {
	if ( empty( $value ) ) {
		return $value;
	}
	if ( is_array( $value ) ) {
		return array_map( 'eme_strip_weird', $value );
	} else {
		# the next preg_replace would remove emoji codes from html, so we don't do this
		#$value = preg_replace('/[\x00-\x08\x10\x0B\x0C\x0E-\x19\x7F]'.
		#                      '|[\x00-\x7F][\x80-\xBF]+'.
		#                      '|([\xC0\xC1]|[\xF0-\xFF])[\x80-\xBF]*'.
		#                      '|[\xC2-\xDF]((?![\x80-\xBF])|[\x80-\xBF]{2,})'.
		#                      '|[\xE0-\xEF](([\x80-\xBF](?![\x80-\xBF]))|(?![\x80-\xBF]{2})|[\x80-\xBF]{3,})/S',
		#                       '?', $value);
		//reject overly long 3 byte sequences and UTF-16 surrogates and replace with ?
		$value = preg_replace(
		    '/\xE0[\x80-\x9F][\x80-\xBF]' .
			'|\xED[\xA0-\xBF][\x80-\xBF]/S',
		    '?',
		    $value
		);
		return $value;
	}
}

function eme_get_editor_settings( $name, $tinymce = true, $quicktags = true, $media_buttons = true, $rows = 10 ) {
	if ( ! $tinymce && ! has_action( 'eme_add_my_quicktags' ) ) {
		add_action( 'admin_print_footer_scripts', 'eme_add_my_quicktags' );
	}

	return [
		'textarea_name' => $name,
		'textarea_rows' => $rows,
		'tinymce'       => $tinymce,
		'quicktags'     => $quicktags,
		'media_buttons' => $media_buttons,
	];
}

function eme_nl2br_save_html( $string ) {
	if ( empty($string) ) {
		return $string;
	}
	// no \n found: do nothing (this also allow this function to be called multiple times on the same string without doing anything on subsequent calls
	if ( ! strstr( $string, "\n" ) ) {
		return $string;
	}
	// avoid looping if no tags in the string.
	if ( ! preg_match( '#<.+>#', $string ) ) {
		return nl2br( $string );
	}

	// replace other lineendings
	$string = str_replace( [ "\r\n", "\r" ], "\n", $string );

	// if br is found, replace it by BREAK
	$string = preg_replace( "/\n?<br\W*?\/?>\n?/", 'BREAK', $string );

	$lines      = explode( "\n", $string );
	$last_index = count( $lines ) - 1;
	$add_br     = 1;
	foreach ( $lines as $i => $line ) {
		if ( $i != $last_index ) {
			// no br if certain tags are found
			if ( strstr( $line, '<script' ) ) {
				$add_br = 0;
				continue;
			}
			if ( strstr( $line, '</script>' ) ) {
				$add_br = 1;
				continue;
			}
			if ( $add_br ) {
				// if the line finishes with a html opening or closing tag or an eme_if (or events_if), we don't add a br-tag
				if ( ! preg_match( '#</?(\w+).*?>\s*$|\[\/?(eme|events)_if.*?\]\s*$#', $line ) ) {
					# add a br only if the next line doesn't begin with a opening or closing tag or eme_if (or events_if)
					if ( ! preg_match( '#^\s*</?|^\s*\[\/?(eme|events)_if#', $lines[ $i + 1 ] ) ) {
						$lines[ $i ] .= '<br>';
					}
				} elseif ( preg_match( '#</span>\s*$#', $line ) && preg_match( '#^\s*<span#', $lines[ $i + 1 ] ) ) {
					# add a br if one line ends on closing span and the next starts with opening span too
					$lines[ $i ] .= '<br>';
				}
			}
		}
	}
	// now that we added the needed br-tags, join back together and return the modified string
	$res = join( "\n", $lines );
	return str_replace( 'BREAK', "<br>\n", $res );
}

function eme_wp_date_format_php_to_datepicker_js( $php_format ) {
	return $php_format;
	$SYMBOLS_MATCHING   = [
		// Day
		'd' => 'dd',
		'D' => 'D',
		'j' => 'd',
		'l' => 'DD',
		'N' => '',
		'S' => '',
		'w' => '',
		'z' => 'o',
		// Week
		'W' => '',
		// Month
		'F' => 'MM',
		'm' => 'mm',
		'M' => 'M',
		'n' => 'm',
		't' => '',
		// Year
		'L' => '',
		'o' => '',
		'Y' => 'yyyy',
		'y' => 'yy',
	];
	$fdatepicker_format = '';
	for ( $i = 0; $i < strlen( $php_format ); $i++ ) {
		$char = $php_format[ $i ];
		if ( $char === '\\' ) { // PHP date format escaping character
			++$i;
			$fdatepicker_format .= $php_format[ $i ];
		} elseif ( isset( $SYMBOLS_MATCHING[ $char ] ) ) {
			$fdatepicker_format .= $SYMBOLS_MATCHING[ $char ];
		} else {
			$fdatepicker_format .= $char;
		}
	}
	return $fdatepicker_format;
}

function eme_wp_time_format_php_to_datepicker_js( $php_format ) {
	return $php_format;
	$SYMBOLS_MATCHING   = [
		'a' => 'aa', // am/pm
		'A' => 'AA', // AM/PM
		'g' => 'h', // 12-hour format of an hour without leading zeros
		'h' => 'hh', // 12-hour format of an hour with leading zeros
		'G' => 'h', // 24-hour format of an hour without leading zeros
		'H' => 'hh', // 24-hour format of an hour with leading zeros
		'i' => get_option( 'eme_time_remove_leading_zeros' ) ? 'i' : 'ii', // Minutes with leading zeros
		's' => '', // seconds with leading zeros
		'e' => '', // Timezone identifier
		'I' => '', // Whether or not the date is in daylight saving time
		'O' => '', // Difference to Greenwich time (GMT) in hours
		'P' => '', // Difference to Greenwich time (GMT) with colon between hours and minutes
		'T' => '', // Timezone abbreviation
		'Z' => '', // Timezone offset in seconds
	];
	$fdatepicker_format = '';
	for ( $i = 0; $i < strlen( $php_format ); $i++ ) {
		$char = $php_format[ $i ];
		if ( $char === '\\' ) { // PHP date format escaping character
			++$i;
			$fdatepicker_format .= $php_format[ $i ];
		} elseif ( isset( $SYMBOLS_MATCHING[ $char ] ) ) {
			$fdatepicker_format .= $SYMBOLS_MATCHING[ $char ];
		} else {
			$fdatepicker_format .= $char;
		}
	}
	return $fdatepicker_format;
}

function eme_getValueFromPath( $arr, $path ) {
	// todo: add checks on $path
	$dest     = $arr;
	$finalKey = array_pop( $path );
	foreach ( $path as $key ) {
		if ( ! isset( $dest[ $key ] ) ) {
			return false;
		}
		$dest = $dest[ $key ];
	}
	if ( ! isset( $dest[ $finalKey ] ) ) {
		return false;
	}
	return $dest[ $finalKey ];
}

function eme_get_wp_image( $image_id ) {
	$image = get_post( $image_id );
	if (empty($image)) {
		return false;
	}
	return [
		'alt'         => get_post_meta( $image->ID, '_wp_attachment_image_alt', true ),
		'caption'     => $image->post_excerpt,
		'description' => $image->post_content,
		'href'        => get_permalink( $image->ID ),
		'src'         => $image->guid,
		'title'       => $image->post_title,
	];
}

function eme_column_exists( $table_name, $column_name ) {
	global $wpdb;
	foreach ( $wpdb->get_col( "DESC $table_name", 0 ) as $column ) {
		if ( $column == $column_name ) {
			return true;
		}
	}
		return false;
}

function eme_table_exists( $table_name ) {
	global $wpdb;
	$query     = $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->esc_like( $table_name ) );
	$db_result = $wpdb->get_var( $query );
	if ( empty( $db_result ) ) {
		return false;
	} else {
		return strtolower( $db_result ) === strtolower( $table_name );
	}
}

function eme_maybe_drop_column( $table_name, $column_name ) {
	global $wpdb;
	if ( eme_column_exists( $table_name, $column_name ) ) {
		$wpdb->query( "ALTER TABLE $table_name DROP COLUMN $column_name;" );
	}
	return true;
}

function eme_drop_table( $table ) {
	global $wpdb;
	$wpdb->query( "DROP TABLE IF EXISTS $table" );
}

function eme_convert_charset( $table, $charset, $collate ) {
	global $wpdb;
	$table = EME_DB_PREFIX . $table;
	$sql   = "ALTER TABLE $table CONVERT TO $charset $collate;";
	$wpdb->query( $sql );
}

function eme_get_total( $multistring ) {
	if ( eme_is_multi( $multistring ) ) {
		return array_sum( eme_convert_multi2array( $multistring ) );
	} else {
		return $multistring+0; // convert to a number (type is float if string is a float, otherwise it is int)
	}
}

function eme_get_wpid_by_post() {
	if ( ! empty( $_POST['wp_id'] ) ) {
		return intval( $_POST['wp_id'] );
	} else {
		return 0;
	}
}

// sanitize_text_field and sanitize_textarea_field strip html tags, be aware
function eme_sanitize_textarea( $value ) {
	if ( is_array( $value ) ) {
		return array_map( 'eme_sanitize_textarea', $value );
	}
	if ( function_exists( 'sanitize_textarea_field' ) ) {
		return sanitize_textarea_field( wp_unslash( $value ) );
	} else {
		return sanitize_text_field( wp_unslash( $value ) );
	}
}

// sanitize_text_field and sanitize_textarea_field strip html tags, be aware
function eme_sanitize_request( $value ) {
	if ( is_array( $value ) ) {
		return array_map( 'eme_sanitize_request', $value );
	} else {
		return sanitize_text_field( wp_unslash( $value ) );
	}
}

function eme_sanitize_email( $email ) {
	// first replace " " by PLUSSIGN
	// then sanitize_email
	// then replace PLUSSIGN by "+" since sanitize_email doesn't allow "+" but it is in fact valid ...
	$email = str_replace( ' ', 'PLUSSIGN', $email );
	$email = sanitize_email( $email );
	$email = str_replace( 'PLUSSIGN', '+', $email );
	return $email;
}

// same as wp sanitize_sql_orderby function, but also allow the "." for table names
function eme_verify_sql_orderby( $orderby ) {
	if ( preg_match( '/^\s*(([a-z0-9_\.]+|`[a-z0-9_\.]+`)(\s+(ASC|DESC))?\s*(,\s*(?=[a-z0-9_\.`])|$))+$/i', $orderby ) || preg_match( '/^\s*RAND\(\s*\)\s*$/i', $orderby ) ) {
		return $orderby;
	}
	return false;
}

function eme_sort_stringlenth( $a, $b ) {
	return strlen( $b ) - strlen( $a );
}

function eme_rss_cdata( $value ) {
	#$value =  str_replace ( ">", "&gt;", str_replace ( "<", "&lt;", $value ) );
	return '<![CDATA[' . $value . ']]>';
}

function eme_esc_html_keep_br( $value ) {
	if ( is_null( $value ) || $value === '' ) {
		return $value;
	}
	if ( is_array( $value ) ) {
		return array_map( 'eme_esc_html_keep_br', $value );
	} else {
		// if br is found, replace it by BREAK
		$value = preg_replace( "/<br\W*?\/?>/", 'BREAK', $value );
		$value = esc_html( $value );
		$value = str_replace( 'BREAK', "<br>", $value );
		return $value;
	}
}

function eme_esc_html( $value, $keep_br=0 ) {
	if ( is_null( $value ) || $value === '' ) {
		return $value;
	}
	if ( is_array( $value ) ) {
		return array_map( 'eme_esc_html', $value );
	} else {
		return esc_html( $value );
	}
}

// unused function
function eme_strip_tags( $value ) {
	if ( is_null( $value ) ) {
		return $value;
	}
	if ( is_array( $value ) ) {
		return array_map( 'eme_strip_tags', $value );
	} else {
		$value = preg_replace( '/^\s*$/', '', wp_strip_all_tags( $value ) );
		return eme_sanitize_request( eme_strip_weird( $value ) );
	}
	return $value;
}

function eme_sanitize_filenamechars( $filepart ) {
	$filepart = trim( $filepart );
	return preg_replace( '/[^\da-z]/i', '_', $filepart );
}

function eme_sanitize_filename( $fName ) {
	$fName    = trim( $fName );
	if ( empty( $fName ) ) {
		return false;
	}
	$indexOFF = strrpos( $fName, '.' );
	if ( $indexOFF ) {
		$nameFile  = substr( $fName, 0, $indexOFF );
		$extension = substr( $fName, $indexOFF + 1 );
	} else {
		$nameFile  = $fName;
		$extension = 'none';
	}
	if ( empty( $nameFile ) ) {
		return false;
	}
	$clean     = eme_sanitize_filenamechars( $nameFile );
	$clean_ext = eme_sanitize_filenamechars( $extension );
	return "$clean.$clean_ext";
}

function eme_sanitize_upload_filename( $fName, $field_id, $extra_id = '' ) {
	if ( empty( $fName ) ) {
		return false;
	}
	$sanitized_fName = eme_sanitize_filename( $fName );
	if ( empty( $sanitized_fName ) ) {
		return false;
	}
	$rand_id   = eme_random_id();
	return "$rand_id-$field_id-$extra_id-$sanitized_fName";
}

function eme_upload_file_err( $code ) {
	switch ( $code ) {
		case UPLOAD_ERR_INI_SIZE:
			$message = __( 'The uploaded file exceeds the upload_max_filesize directive in php.ini', 'events-made-easy' );
			break;
		case UPLOAD_ERR_FORM_SIZE:
			$message = __( 'The uploaded file exceeds the MAX_FILE_SIZE directive that was specified in the HTML form', 'events-made-easy' );
			break;
		case UPLOAD_ERR_PARTIAL:
			$message = __( 'The uploaded file was only partially uploaded', 'events-made-easy' );
			break;
		case UPLOAD_ERR_NO_FILE:
			$message = __( 'No file was uploaded', 'events-made-easy' );
			break;
		case UPLOAD_ERR_NO_TMP_DIR:
			$message = __( 'Missing a temporary folder', 'events-made-easy' );
			break;
		case UPLOAD_ERR_CANT_WRITE:
			$message = __( 'Failed to write file to disk', 'events-made-easy' );
			break;
		case UPLOAD_ERR_EXTENSION:
			$message = __( 'File upload stopped by extension', 'events-made-easy' );
			break;

		default:
			$message = __( 'Unknown upload error', 'events-made-easy' );
			break;
	}
	return $message;
}

function eme_upload_files( $id, $type = 'bookings' ) {
	//$supported_mime_types = wp_get_mime_types();
	$errors               = [];
	$max_upload_wp        = wp_max_upload_size();
	$eme_is_admin_request = eme_is_admin_request();
	foreach ( $_FILES as $key => $value ) {
		if ( preg_match( '/^FIELD(\d+)_(.*)/', $key, $matches ) ) {
			$field_id = intval( $matches[1] );
			// the extra_id variable contains numbers, this is the case where we upload dynamic fields etc ... where the name is not just FIELD22 but e.g. FIELD22_1
			$extra_id = intval( $matches[2] );
		} elseif ( preg_match( '/^FIELD(\d+)/', $key, $matches ) ) {
			$field_id = intval( $matches[1] );
			$extra_id = '';
		}
		if ( ! $field_id ) {
			continue;
		}

		// if it is a person-field, override the type
		$formfield = eme_get_formfield( $field_id );
		if ( $formfield['field_purpose'] == 'people' ) {
			if ( $type == 'bookings' ) {
				$booking = eme_get_booking( $id );
				$id      = $booking['person_id'];
			} elseif ( $type == 'members' ) {
				$member = eme_get_member( $id );
				$id     = $member['person_id'];
			}
			$type     = 'people';
			$extra_id = '';
		}
		// now we know where to store it, so create the dir
		$targetPath = EME_UPLOAD_DIR . '/' . $type . '/' . $id;
		$mkdir_res = eme_mkdir_with_index( $targetPath );
		if ( ! $mkdir_res ) {
			$errors[] = __( 'Failure creating upload dir, please check your permissions.', 'events-made-easy' );
			continue;
		}
		if ( $eme_is_admin_request && isset( $_REQUEST['eme_admin_action'] ) ) {
			if ( ! empty( $formfield['admin_values'] ) ) {
				$field_values = $formfield['admin_values'];
			} else {
				$field_values = $formfield['field_values'];
			}
		} else {
			$field_values = $formfield['field_values'];
		}
		if ( intval( $field_values ) > 0 ) {
			$mb = 1024 * 1024 * intval( $field_values );
			if ( $mb > $max_upload_wp ) {
				$max_size = $max_upload_wp;
			} elseif ( $mb > 0 ) {
				$max_size = $mb;
			}
		} else {
			$max_size = $max_upload_wp;
		}

		if ( ! is_array( $_FILES[ $key ]['name'] ) ) {
			// check for upload issues
			$fileName        = eme_sanitize_request( $_FILES[ $key ]['name'] );
			$fileNameChanged = eme_sanitize_upload_filename( $fileName, $field_id, $extra_id );
			$temp_name       = $_FILES[ $key ]['tmp_name'];
			$file_size       = $_FILES[ $key ]['size'];
			$fileError       = $_FILES[ $key ]['error'];

			// first check if upload is required but nothing uploaded
			if ( $fileError == UPLOAD_ERR_NO_FILE || empty( $fileName ) || empty( $fileNameChanged ) || $file_size == 0 ) {
				// nothing uploaded, so check if we wanted something
				if ( $formfield['field_required'] && ! $eme_is_admin_request ) {
					$errors[] = __( 'File upload is required.', 'events-made-easy' );
				} else {
					continue;
				}
			}

			// now check the filename being ok
			if ( $fileNameChanged === false ) {
				$errors[] = __( 'Illegal filename.', 'events-made-easy' );
				continue;
			}

			// if already uploaded
			if ( file_exists( $targetPath . '/' . $fileNameChanged ) ) {
				$errors[] = $fileName . ': ' . __( 'File already exists.', 'events-made-easy' );
				continue;
			}

			// if too large
			if ( $file_size > $max_size ) {
				$errors[] = $fileName . ': ' . __( 'File too large.', 'events-made-easy' );
				continue;
			}

			// if any upload error (the UPLOAD_ERR_NO_FILE code is already handled)
			if ( $fileError > 0 ) {
				$errors[] = $fileName . ': ' . eme_upload_file_err( $fileError );
				continue;
			}
			// this checks if the filetype detected matches with the extension given
			// based on code from WordPress file upload, but stricter (no upload if anything goes wrong)
			$wp_filetype     = wp_check_filetype_and_ext( $temp_name, $fileNameChanged );
			$t_ext           = empty( $wp_filetype['ext'] ) ? '' : $wp_filetype['ext'];
			$t_type          = empty( $wp_filetype['type'] ) ? '' : $wp_filetype['type'];
			$proper_filename = empty( $wp_filetype['proper_filename'] ) ? '' : $wp_filetype['proper_filename'];
			if ( ! $t_type || ! $t_ext || ! empty( $proper_filename ) ) {
				$errors[] = $fileName . ': ' . __( 'Incorrect file type.', 'events-made-easy' );
				continue;
			}

			if ( ! move_uploaded_file( $temp_name, $targetPath . '/' . $fileNameChanged ) ) {
				$errors[] = $fileName . ': ' . __( 'Upload failed.', 'events-made-easy' );
				continue;
			}
		} else {
			// multiple upload case
			// Count # of uploaded files in array
			$total = count( $_FILES[ $key ]['name'] );
			// Loop through each file
			for ( $i = 0; $i < $total; $i++ ) {
				// check for upload issues
				$fileName        = eme_sanitize_request( $_FILES[ $key ]['name'][ $i ] );
				$fileNameChanged = eme_sanitize_upload_filename( $fileName, $field_id, $extra_id );
				$temp_name       = $_FILES[ $key ]['tmp_name'][ $i ];
				$file_size       = $_FILES[ $key ]['size'][ $i ];
				$fileError       = $_FILES[ $key ]['error'][ $i ];

				// first check if upload is required but nothing uploaded
				if ( $fileError == UPLOAD_ERR_NO_FILE || empty( $fileName ) || empty( $fileNameChanged ) || $file_size == 0 ) {
					// nothing uploaded, so check if we wanted something
					if ( $formfield['field_required'] && ! $eme_is_admin_request ) {
						$errors[] = __( 'File upload is required.', 'events-made-easy' );
					} else {
						continue;
					}
				}

				// now check the filename being ok
				if ( $fileNameChanged === false ) {
					$errors[] = __( 'Illegal filename.', 'events-made-easy' );
					continue;
				}

				// if already uploaded
				if ( file_exists( $targetPath . '/' . $fileNameChanged ) ) {
					$errors[] = $fileName . ': ' . __( 'File already exists.', 'events-made-easy' );
					continue;
				}

				// if too large
				if ( $file_size > $max_size ) {
					$errors[] = $fileName . ': ' . __( 'File too large.', 'events-made-easy' );
					continue;
				}

				// if any upload error (the UPLOAD_ERR_NO_FILE code is already handled)
				if ( $fileError > 0 ) {
					$errors[] = $fileName . ': ' . eme_upload_file_err( $fileError );
					continue;
				}
				// this checks if the filetype detected matches with the extension given
				// based on code from WordPress file upload, but stricter (no upload if anything goes wrong)
				$wp_filetype     = wp_check_filetype_and_ext( $temp_name, $fileNameChanged );
				$t_ext           = empty( $wp_filetype['ext'] ) ? '' : $wp_filetype['ext'];
				$t_type          = empty( $wp_filetype['type'] ) ? '' : $wp_filetype['type'];
				$proper_filename = empty( $wp_filetype['proper_filename'] ) ? '' : $wp_filetype['proper_filename'];
				if ( ! $t_type || ! $t_ext || ! empty( $proper_filename ) ) {
					$errors[] = $fileName . ': ' . __( 'Incorrect file type.', 'events-made-easy' );
					continue;
				}

				if ( ! move_uploaded_file( $temp_name, $targetPath . '/' . $fileNameChanged ) ) {
					$errors[] = $fileName . ': ' . __( 'Upload failed.', 'events-made-easy' );
					continue;
				}
			}
		}
	}
	if ( ! empty( $errors ) ) {
		return '<p>' . __( 'Errors encountered while uploading files', 'events-made-easy' ) . '<br>' . join( '<br>', eme_esc_html( $errors ) ) . '</p>';
	} else {
		return '';
	}
}

function eme_get_uploaded_files( $id, $type = 'bookings' ) {
	$res = [];
	$dir = EME_UPLOAD_DIR . '/' . $type . '/' . $id;
	if ( is_dir( $dir ) ) {
		$handle = opendir( $dir );
		if ( $handle ) {
			while ( ( $entry = readdir( $handle ) ) !== false ) {
				if ( $entry != '.' && $entry != '..' ) {
					$info = explode( '-', $entry );
					// ignore files not matching the uploaded scheme
					// this already ignores the ticket.pdf, member.pdf and qrcode.gif files
					if ( count( $info ) != 4 ) {
						continue;
					}
					$line              = [];
					$line['id']        = $id;
					$line['type']      = $type;
					$line['random_id'] = $info[0];
					$line['field_id']  = $info[1];
					$formfield         = eme_get_formfield( $info[1] );
					if ( $formfield ) {
						$line['field_name'] = eme_trans_esc_html( $formfield['field_name'] );
					} else {
						// unknown ...
						$line['field_name'] = $entry;
					}

					$line['extra_id'] = $info[2];
					// the name of the file given by the person
					$line['name'] = $info[3];
					$line['url']  = EME_UPLOAD_URL . "/$type/$id/$entry";
					$res[]        = $line;
				}
			}
			closedir( $handle );
		}
	}
	return $res;
}

function eme_get_uploaded_file_linkdelete( $file ) {
	$style_del = 'eme_del_upload-button';
	// the name of the file given by the person
	$name = $file['name'];
	$url  = $file['url'];
	// person/member/... id
	$id = $file['id'];
	// person, member ...
	$type      = $file['type'];
	$random_id = $file['random_id'];
	$extra_id  = $file['extra_id'];
	$field_id  = $file['field_id'];
	$html      = "<a href='$url'>$name</a> <a class='$style_del' href='#' data-id='$id' data-name='$name' data-random_id='$random_id' data-type='$type' data-extra_id='$extra_id' data-field_id='$field_id'><img src=" . esc_url(EME_PLUGIN_URL) . 'images/cross.png></a>';
	return "<span id='span_$random_id'>$html<br></span>";
}

function eme_get_uploaded_file_html( $file ) {
	// the name of the file given by the person
	$name = $file['name'];
	$url  = $file['url'];
	return "<a href='$url'>$name</a><br>";
}

function eme_delTree( $dir ) {
	$files = array_diff( scandir( $dir ), [ '.', '..' ] );
	foreach ( $files as $file ) {
		( is_dir( "$dir/$file" ) ) ? delTree( "$dir/$file" ) : wp_delete_file( "$dir/$file" );
	}
	return rmdir( $dir );
}
function eme_delete_uploaded_files( $id, $type = 'bookings' ) {
	$dir = EME_UPLOAD_DIR . '/' . $type . '/' . $id;
	if ( is_dir( $dir ) ) {
		eme_delTree( $dir );
	}
}
function eme_delete_uploaded_file( $file, $id, $type = 'bookings' ) {
	$dir = EME_UPLOAD_DIR . '/' . $type . '/' . $id;
	if ( is_dir( $dir ) ) {
		wp_delete_file( "$dir/$file" );
	}
}

// the next 2 functions allow us to parse html-text and return the urls as "name [url]"
function eme_buildlink_callback( $matches ) {
	// Remove spaces in URL (#1487805)
	$url = str_replace( ' ', '', $matches[3] );
	return $matches[5] . ' [' . $url . ']';
}

function eme_replacelinks( $text ) {
	$linksearch = '/<(a) [^>]*href=("|\')([^"\']+)\2([^>]*)>(.*?)<\/a>/i';
	return preg_replace_callback( $linksearch, 'eme_buildlink_callback', $text );
}

function eme_is_admin_request() {
	// Get admin URL and referrer.
	$admin_url = strtolower( admin_url() );
	$referrer  = strtolower( wp_get_referer() );

	// Check if this is a admin request. If true, it
	// could also be a AJAX request from the frontend.
	if ( is_user_logged_in() && is_admin() ) {
		// Check if the user comes from an admin page.
		if ( 0 === strpos( $referrer, $admin_url ) ) {
			return true;
		} else {
			// Check for AJAX requests.
			if ( function_exists( 'wp_doing_ajax' ) ) {
				return ! wp_doing_ajax();
			} else {
				return ! ( defined( 'DOING_AJAX' ) && DOING_AJAX );
			}
		}
	} else {
		return false;
	}
}

// a eme_fputcsv function to replace the original fputcsv
// reason: we want to enclose all fields with $enclosure
function eme_fputcsv( $fh, $fields, $delimiter = ';', $enclosure = '"' ) {
	$delimiter_esc = preg_quote( $delimiter, '/' );
	$enclosure_esc = preg_quote( $enclosure, '/' );

	// not an array, then return
	if ( ! is_array( $fields ) ) {
		return;
	}

	$output = [];
	foreach ( $fields as $field ) {
		$output[] = preg_match( "/(?:{$delimiter_esc}|{$enclosure_esc}|\s|\r|\t|\n)/", $field ) ? (
		    $enclosure . str_replace( $enclosure, $enclosure . $enclosure, $field ) . $enclosure
		) : $enclosure . $field . $enclosure;
	}

	fwrite( $fh, join( $delimiter, $output ) . "\r\n" );
}

function eme_nocache_headers() {
	header( 'Expires: Sun, 01 Jan 2014 00:00:00 GMT' );
	header( 'Cache-Control: no-store, no-cache, must-revalidate, max-age=0' );
	header( 'Cache-Control: post-check=0, pre-check=0', false );
	header( 'Pragma: no-cache' );
}

function eme_text_split_newlines( $text ) {
	// returns an array of trimmed lines, based on text input
	$text  = str_replace( [ "\r\n", "\r" ], "\n", $text );
	$lines = explode( "\n", $text );
	return $lines;
}

function eme_ajax_record_list( $tablename, $cap ) {
	global $wpdb;
	$table        = EME_DB_PREFIX . $tablename;
	$jTableResult = [];
	// The toolbar search input
	$q           = isset( $_REQUEST['q'] ) ? eme_sanitize_request($_REQUEST['q']) : '';
	$opt         = isset( $_REQUEST['opt'] ) ? eme_sanitize_request($_REQUEST['opt']) : '';
	$where       = '';
	$where_array = [];
	if ( $q ) {
		for ( $i = 0; $i < count( $opt ); $i++ ) {
			$fld           = esc_sql( $opt[ $i ] );
			$where_array[] = "`$fld` LIKE '%" . esc_sql( $wpdb->esc_like( $q[ $i ] ) ) . "%'";
		}
		$where = ' WHERE ' . implode( ' AND ', $where_array );
	}
	if ( current_user_can( get_option( $cap ) ) ) {
		$sql         = "SELECT COUNT(*) FROM $table $where";
		$recordCount = $wpdb->get_var( $sql );
		$sorting     = ( ! empty( $_REQUEST['jtSorting'] ) && ! empty( eme_verify_sql_orderby( $_REQUEST['jtSorting'] ) ) ) ? 'ORDER BY ' . esc_sql( $_REQUEST['jtSorting'] ) : '';
		if ( isset( $_REQUEST['jtStartIndex'] ) && isset( $_REQUEST['jtPageSize'] ) ) {
			$limit = ' LIMIT ' . intval( $_REQUEST['jtStartIndex'] ) . ',' . intval( $_REQUEST['jtPageSize'] );
		} else {
			$limit = '';
		}

		$sql                    = "SELECT * FROM $table $where $sorting $limit";
		$rows                   = $wpdb->get_results( $sql, ARRAY_A );
		$jTableResult['Result'] = 'OK';
		if ( isset( $_REQUEST['options_list'] ) ) {
			$jTableResult['Options'] = $rows;
		} else {
			$jTableResult['TotalRecordCount'] = $recordCount;
			$jTableResult['Records']          = $rows;
		}
	} else {
		$jTableResult['Result']  = 'Error';
		$jTableResult['Message'] = __( 'Access denied!', 'events-made-easy' );
	}
	print wp_json_encode( $jTableResult );
	wp_die();
}

function eme_ajax_record_delete( $tablename, $cap, $postvar ) {
	global $wpdb;
	$table        = EME_DB_PREFIX . $tablename;
	$jTableResult = [];

	if ( current_user_can( get_option( $cap ) ) && isset( $_POST[ $postvar ] ) ) {
		// check the POST var
		$ids_arr = explode( ',', eme_sanitize_request($_POST[ $postvar ]) );
		if ( eme_is_numeric_array( $ids_arr ) ) {
			$wpdb->query( "DELETE FROM $table WHERE $postvar IN ( " . eme_sanitize_request($_POST[ $postvar ]) . ')' );
		}
		$jTableResult['Result']      = 'OK';
		$jTableResult['htmlmessage'] = __( 'Records deleted!', 'events-made-easy' );
	} else {
		$jTableResult['Result']      = 'Error';
		$jTableResult['Message']     = __( 'Access denied!', 'events-made-easy' );
		$jTableResult['htmlmessage'] = __( 'Access denied!', 'events-made-easy' );
	}
	print wp_json_encode( $jTableResult );
	wp_die();
}

function eme_ajax_record_edit( $tablename, $cap, $id_column, $record, $record_function = '', $update = 0 ) {
	global $wpdb;
	$table        = EME_DB_PREFIX . $tablename;
	$jTableResult = [];
	if ( ! $record ) {
		$jTableResult['Result']  = 'Error';
		$jTableResult['Message'] = __( 'No such record', 'events-made-easy' );
		print wp_json_encode( $jTableResult );
		wp_die();
	}
	if ( current_user_can( get_option( $cap ) ) ) {
		if ( $update ) {
			$wpdb->update( $table, $record, [ $id_column => $record[ $id_column ] ] );
		} else {
			$wpdb->insert( $table, $record );
		}
		if ( $wpdb->last_error !== '' ) {
			$jTableResult['Result'] = 'Error';
			if ( $update ) {
				$jTableResult['Message'] = __( 'Update failed: ', 'events-made-easy' ) . $wpdb->last_error;
			} else {
				$jTableResult['Message'] = __( 'Insert failed: ', 'events-made-easy' ) . $wpdb->last_error;
			}
		} else {
			$jTableResult['Result'] = 'OK';
			if ( ! $update ) {
				$record_id = $wpdb->insert_id;
				if ( $record_function ) {
					$record = $record_function( $record_id );
				} else {
					$record[ $id_column ] = $record_id;
				}
				$jTableResult['Record'] = eme_esc_html( $record );
			}
		}
	} else {
		$jTableResult['Result']  = 'Error';
		$jTableResult['Message'] = __( 'Access denied!', 'events-made-easy' );
	}

	//Return result to jTable
	print wp_json_encode( $jTableResult );
	wp_die();
}

function eme_str_split_unicode( $str, $l = 0 ) {
	if ( $l > 0 ) {
		$ret = [];
		$len = mb_strlen( $str, 'UTF-8' );
		for ( $i = 0; $i < $len; $i += $l ) {
			$ret[] = mb_substr( $str, $i, $l, 'UTF-8' );
		}
		return $ret;
	}
	return preg_split( '//u', $str, -1, PREG_SPLIT_NO_EMPTY );
}

function eme_get_attachment_link( $id ) {
	if ( ! empty( $id ) ) {
		if ( is_numeric( $id ) ) {
			$_post = get_post( $id );
			if ( ! empty( $_post ) ) {
				$url       = esc_url( wp_get_attachment_url( $_post->ID ) );
				$link_text = $_post->post_title;
				if ( '' === trim( $link_text ) ) {
					$link_text = esc_html( pathinfo( get_attached_file( $_post->ID ), PATHINFO_FILENAME ) );
				}
				return "<a target='_blank' href='$url'>$link_text</a>";
			}
		} elseif ( is_array( $id ) ){
			if (eme_is_empty_string($id[0])) {
				$link_text = pathinfo( $id[1], PATHINFO_FILENAME ); // the link shouldn't show the extension
				// now rename parts of the file
				$link_text = preg_replace( '/(member-\d+|booking-\d+)-.*/', '$1', $filename );
				$link_text = preg_replace( '/.*-(qrcode.*)/', '$1', $filename );
			} else {
				$link_text = pathinfo( $id[0], PATHINFO_FILENAME ); // the link shouldn't show the extension
			}
			$url = str_replace( EME_UPLOAD_DIR, EME_UPLOAD_URL, $id[1] );
			return "<a target='_blank' href='$url'>".esc_html($link_text)."</a>";
		} else {
			// not numeric ? Then it is a path
			$link_text = pathinfo( $id, PATHINFO_FILENAME ); // the link shouldn't show the extension
			$link_text = preg_replace( '/(member-\d+|booking-\d+)-.*/', '$1', $filename );
			$link_text = preg_replace( '/.*-(qrcode.*)/', '$1', $filename );
			#$link_text = var_dump($id);
			$url = str_replace( EME_UPLOAD_DIR, EME_UPLOAD_URL, $id );
			return "<a target='_blank' href='$url'>".esc_html($link_text)."</a>";
		}
	}
	return '';
}

function eme_excerpt( $text, $cache_id = '' ) {
	// since the excerpt is also asked for in og-headers and such, let's cache it
	if ( ! empty( $cache_id ) ) {
		$excerpt = wp_cache_get( $cache_id );
	} else {
		$excerpt = false;
	}
	if ( $excerpt === false ) {
		// taken from wp_trim_excerpt function
		$excerpt = strip_shortcodes( $text );
		$excerpt = excerpt_remove_blocks( $excerpt );

		/** This filter is documented in wp-includes/post-template.php */
		$excerpt = apply_filters( 'the_content', $excerpt );
		$excerpt = str_replace( ']]>', ']]&gt;', $excerpt );
		if ( ! empty( $cache_id ) ) {
			wp_cache_set( $cache_id, $excerpt, '', 5 );
		}
	}
	return $excerpt;
}

function eme_generate_unique_wp_username( $name ) {
	$basic_username = preg_replace( '/\s+/', '', $name );
	$username       = sanitize_user( $basic_username );
	while ( username_exists( $username ) ) {
		$rnd_str  = sprintf( '%0d', mt_rand( 1, 999999 ) );
		$username = sanitize_user( $basic_username . '-' . $rnd_str );
	}
	return $username;
}

function eme_create_wp_user( $person ) {
	$username = eme_generate_unique_wp_username( $person['lastname'] . $person['firstname'] );
	// use register_new_user so the person gets a mail
	// $user_id = register_new_user( $username, $person['email'] ) ;
	$user_pass = wp_generate_password( 12, false );
	if ( has_filter( 'eme_wp_userdata_filter' ) ) {
		$userdata = apply_filters( 'eme_wp_userdata_filter', $person );
	} else {
		$userdata = [];
	}

	// let's do everything in one go
	$userdata['user_pass']  = $user_pass;
	if (!isset($userdata['user_login']))
		$userdata['user_login'] = wp_slash( $username );
	else
		$userdata['user_login'] = wp_slash( $userdata['user_login'] );
	$userdata['user_email'] = wp_slash( $person['email'] );
	$userdata['last_name']  = $person['lastname'];
	$userdata['first_name'] = $person['firstname'];
	if ( ! isset( $userdata['meta_input']['eme_phone'] ) && ! empty( $person['phone'] ) ) {
		$userdata['meta_input']['eme_phone'] = $person['phone'];
	}
	$user_id = wp_insert_user( $userdata );

	if ( ! is_wp_error( $user_id ) ) {
		wp_send_new_user_notifications( $user_id );
		// now link the wp user to the EME person
		$person['wp_id'] = $user_id;
		$person['properties']['wp_delete_user'] = 1;
		eme_db_update_person( $person['person_id'], $person );
		return $user_id;
	} else {
		return 0;
	}
}

function eme_format_full_name( $firstname, $lastname, $email='' ) {
	// the special case where the firstname/lastname are empty: then we use email as name if given as arg
	if (empty($firstname) && empty($lastname) && !empty($email)) {
		return $email;
	}
	$format = get_option( 'eme_full_name_format' );
	if ( ! strstr( $format, '#_LASTNAME' ) ) {
		$format .= ' #_LASTNAME';
	}
	if ( ! strstr( $format, '#_FIRSTNAME' ) ) {
		$format .= ' #_FIRSTNAME';
	}
	$patterns        = [];
	$patterns[0]     = '/#_LASTNAME/';
	$patterns[1]     = '/#_FIRSTNAME/';
	$replacements    = [];
	$replacements[0] = $lastname;
	$replacements[1] = $firstname;
	$res             = preg_replace( $patterns, $replacements, $format );
	$res             = trim( $res );
	// if $res is a string that only contains spaces: return empty string
	if ( eme_is_empty_string( $res ) ) {
		return '';
	} else {
		return eme_translate($res);
	}
}

function eme_extra_event_headers( $event ) {
	if ( $event['event_status'] != EME_EVENT_STATUS_PUBLIC && ! is_user_logged_in() ) {
		return;
	}

	$header = '<meta property="og:type" content="article">
<meta property="og:title" content="#_NAME">
<meta property="og:url" content="#_EVENTPAGEURL">
<meta property="og:image" content="#_EVENTIMAGEURL">
<meta property="og:description" content="#_EXCERPT">
<meta name="twitter:image" content="#_EVENTIMAGEURL">
<meta name="twitter:description" content="#_EXCERPT">
<meta name="twitter:title" content="#_NAME">
<meta name="twitter:card" content="summary">
<meta name="description" content="#_EXCERPT">';
	if ( has_filter( 'eme_extra_event_headers_filter' ) ) {
		$header = apply_filters( 'eme_extra_event_headers_filter', $header, $event );
	}
	$header             .= "\n";
	$header             .= '<script type="application/ld+json">';
	$footer              = '</script>';
	$content             = [];
	$content['@context'] = 'http://www.schema.org';
	$content['@type']    = 'Event';
	$content['name']     = '#_EVENTNAME';
	$content['url']      = '#_EVENTPAGEURL';
	// to make sure description is not empty
	if ( empty( $event['event_notes'] ) ) {
		$content['description'] = '#_EVENTNAME';
	} else {
		$content['description'] = '#_EXCERPT';
	}
	if ( $event['event_properties']['all_day'] ) {
		$content['startDate'] = '#_STARTDATE{Y-m-d}';
		$content['endDate']   = '#_ENDDATE{Y-m-d}';
	} else {
		$content['startDate'] = '#_STARTDATETIME_8601';
		$content['endDate']   = '#_ENDDATETIME_8601';
	}
	if ( ! empty( $event['event_image_id'] ) ) {
		$content['image'] = '#_EVENTIMAGEURL';
	}

	// location is a required property, so add it, even if empty
	$loc      = [];
	$location = eme_get_location( $event['location_id'] );
	if ( ! empty( $location ) && ! empty( $location['location_url'] ) ) {
		if ( $location['location_properties']['online_only'] ) {
			$content['eventAttendanceMode'] = 'https://schema.org/OnlineEventAttendanceMode';
			$loc['@type']                   = 'VirtualLocation';
			$loc['url']                     = '#_LOCATION_EXTERNAL_URL';
		} else {
			$content['eventAttendanceMode'] = 'https://schema.org/MixedEventAttendanceMode';
			$location1                      = [];
			$location1['@type']             = 'VirtualLocation';
			$location1['url']               = '#_LOCATION_EXTERNAL_URL';
			$location2                      = [];
			$location2['@type']             = 'Place';
			$location2['name']              = '#_LOCATION';
			$address                        = [];
			$address['@type']               = 'PostalAddress';
			$address['streetAddress']       = '#_ADDRESS';
			$address['addressLocality']     = '#_CITY';
			$address['postalCode']          = '#_ZIP';
			$address['addressCountry']      = '#_COUNTRY';
			$location2['address']           = $address;
			$loc[]                          = $location1;
			$loc[]                          = $location2;
		}
	} else {
		$content['eventAttendanceMode'] = 'https://schema.org/OfflineEventAttendanceMode';
		$loc['@type']                   = 'Place';
		$loc['name']                    = '#_LOCATION';
		$address                        = [];
		$address['@type']               = 'PostalAddress';
		$address['streetAddress']       = '#_ADDRESS';
		$address['addressLocality']     = '#_CITY';
		$address['postalCode']          = '#_ZIP';
		$address['addressCountry']      = '#_COUNTRY';
		$loc['address']                 = $address;
	}
	$content['location'] = $loc;

	if ( $event['event_rsvp'] ) {
		$offers          = [];
		$offers['@type'] = 'Offer';
		$offers['url']   = '#_EVENTPAGEURL';
		if ( ! eme_is_multi( $event['price'] ) ) {
			$price = $event['price'];
		} else {
			$prices = eme_convert_multi2array( $event['price'] );
			// let's take the lowest price then
			$price = min( $prices );
		}
		$offers['price']         = $price;
		$offers['priceCurrency'] = $event['currency'];

		// allow rsvp from rsvp_start_number_days:rsvp_start_number_hours before the event starts/ends (rsvp_start_target)
		if ( ( $event['event_properties']['rsvp_start_number_days'] > 0 || $event['event_properties']['rsvp_start_number_hours'] > 0 ) ) {
			$event_rsvp_startdatetime = new ExpressiveDate( $event['event_start'], EME_TIMEZONE );
			$event_rsvp_enddatetime   = new ExpressiveDate( $event['event_end'], EME_TIMEZONE );
			if ( $event['event_properties']['rsvp_start_target'] == 'end' ) {
				$event_rsvp_start = $event_rsvp_enddatetime->copy();
			} else {
				$event_rsvp_start = $event_rsvp_startdatetime->copy();
			}

			$event_rsvp_start->minusDays( $event['event_properties']['rsvp_start_number_days'] )->minusHours( $event['event_properties']['rsvp_start_number_hours'] );
			$validfrom = $event_rsvp_start->format( 'c' );
		} elseif ( eme_is_empty_datetime( $event['creation_date'] ) ) {
			$validfrom = '#_STARTDATETIME_8601';
		} else {
			$eme_date_obj = new ExpressiveDate( $event['creation_date'], EME_TIMEZONE );
			$validfrom    = $eme_date_obj->format( 'c' );
		}
		$offers['validFrom'] = $validfrom;
		$seats_available     = eme_are_seats_available( $event );
		if ( $seats_available ) {
			$offers['availability'] = 'https://schema.org/InStock';
		} else {
			$offers['availability'] = 'https://schema.org/SoldOut';
		}
		$content['offers'] = $offers;
	}
	// performer is a recommended option, so lets add one if a custom field of name "performer" is present
	$formfield = eme_get_formfield( 'performer' );
	if ( ! empty( $formfield ) && $formfield['field_purpose'] == 'events' ) {
		$field_id = $formfield['field_id'];
		$answers  = eme_get_event_cf_answers( $event['event_id'] );
		foreach ( $answers as $answer ) {
			if ( $answer['field_id'] == $field_id ) {
				$val = eme_answer2readable( $answer['answer'], $formfield );
				if ( ! empty( $val ) ) {
					$performer            = [];
					$performer['@type']   = 'Person';
					$performer['name']    = $val;
					$content['performer'] = $performer;
				}
				break;
			}
		}
	}

	// add something, in case no performer custom field exists
	if ( ! isset( $content['performer'] ) ) {
		$performer            = [];
		$performer['@type']   = 'Person';
		$performer['name']    = '#_EVENTNAME';
		$content['performer'] = $performer;
	}
	$organizer          = [];
	$organizer['@type'] = 'Organization';
	$organizer['name']  = '#_CONTACTNAME';
	$organizer['url']   = '#_EVENTPAGEURL';
	$content['organizer']   = $organizer;
	$content['eventStatus'] = 'https://schema.org/EventScheduled';

	if ( has_filter( 'eme_extra_event_headers_json_filter' ) ) {
		$content = apply_filters( 'eme_extra_event_headers_json_filter', $content, $event );
	}

	return $header . wp_json_encode( $content, JSON_UNESCAPED_SLASHES ) . $footer;
}

function eme_isjson( $data ) {
	if (!is_string($data)) return false;
	$decoded_data = json_decode($data);
	return (json_last_error() == JSON_ERROR_NONE);
}

function eme_is_serialized( $data ) {
	return ( eme_isjson($data) || is_serialized( $data ) );
}

// the function is called serialize, but in fact prefers to do json_encde for security
function eme_serialize( $data ) {
	if ( !eme_is_serialized( $data )) {
		return json_encode( $data );
	} elseif (is_serialized( $data )) {
		$data = unserialize( $data, ['allowed_classes' => false] );
		return json_encode( $data );
	} else {
		return $data;
	}
}

function eme_unserialize( $data ) {
	if ( is_serialized( $data ) ) {
		return unserialize( $data, ['allowed_classes' => false] );
	} elseif (eme_isjson($data)) {
		// add TRUE to make sure the return is an array
		return json_decode ($data, TRUE);
	} else {
		return $data;
	}
}

function eme_prettyprint_assoc( $jsonData, $pre = '' ) {
	$pretty = '';
	foreach ( $jsonData as $key => $val ) {
		$pretty .= $pre . htmlspecialchars( ucfirst( $key ) ) . ': ';
		if ( strcmp( gettype( $val ), 'array' ) == 0 ) {
			$pretty .= "<br>\n";
			$sno     = 1;
			foreach ( $val as $value ) {
				$pretty .= $pre . '&nbsp;' . $sno++ . ":<br>\n";
				$pretty .= eme_prettyprint_assoc( $value, $pre . '&nbsp;&nbsp;' );
			}
		} else {
			$pretty .= htmlspecialchars( $val ) . "<br>\n";
		}
	}
	return $pretty;
}

function eme_generate_qrcode( $url_to_encode, $targetBasePath, $targetBaseUrl, $size ) {
	eme_mkdir_with_index( $targetBasePath );
	if ( $size == 'small' ) {
		$real_size = 1;
	} elseif ( $size == 'medium' ) {
		$real_size = 2;
	} elseif ( $size == 'large' ) {
		$real_size = 4;
	} elseif ( $size == 'huge' ) {
		$real_size = 8;
	} else {
		$real_size = intval( $size );
	}
	if ( $real_size < 1 || $real_size > 8 ) {
		$real_size = 2;
	}

	if ( $real_size == 2 ) {
		$name = 'qrcode.gif';
	} else {
		$name = 'qrcode_' . $real_size . '.gif';
	}

	$qr_arr = glob( "$targetBasePath/*-$name" );
	if ( ! empty( $qr_arr ) ) {
		$existing_file = $qr_arr[0];
		#if (file_exists($existing_file) && time()-filemtime($existing_file) > 24 * 3600) {
		#   // file older than a day: remove it
		#   // if not older: we use that one
		#   wp_delete_file($existing_file);
		#   $existing_file = "";
		#}
	} else {
		$existing_file = '';
	}
	if ( empty( $existing_file ) ) {
		$rand_id     = eme_random_id();
		$target_file = $targetBasePath . '/' . $rand_id . '-' . $name;
		$target_url  = $targetBaseUrl . '/' . $rand_id . '-' . $name;
		if ( ! class_exists( 'QRCode' ) ) {
			require_once 'class-qrcode.php';
		}
		if ( $real_size <= 2 ) {
			$qr_error_level = QR_ERROR_CORRECT_LEVEL_M;
		} else {
			$qr_error_level = QR_ERROR_CORRECT_LEVEL_Q;
		}
		$qr = QRCode::getMinimumQRCode( $url_to_encode, $qr_error_level );
		$im = $qr->createImage( $real_size );
		imagegif( $im, $target_file );
		imagedestroy( $im );
	} else {
		$target_file = $targetBasePath . '/' . basename( $existing_file );
		$target_url  = $targetBaseUrl . '/' . basename( $existing_file );
	}
	return [ $target_file, $target_url ];
}

function eme_check_access( $post_id ) {
	$access_allowed = wp_cache_get( "eme_access $post_id" );
	if ( $access_allowed === false ) {
		$access_allowed = 1;
		$custom_values  = @get_post_custom( $post_id );
		if ( is_array( $custom_values ) ) {
			$eme_drip_counter  = ! empty( $custom_values['eme_drip_counter'] ) ? intval( $custom_values['eme_drip_counter'][0] ) : 0;
			$eme_membershipids = isset( $custom_values['eme_membershipids'] ) ? $custom_values['eme_membershipids'][0] : '';
			$eme_groupids      = isset( $custom_values['eme_groupids'] ) ? $custom_values['eme_groupids'][0] : '';
			if ( eme_is_serialized( $eme_membershipids ) ) {
				$page_membershipids = eme_unserialize( $eme_membershipids );
			} else {
				$page_membershipids = [];
			}
			if ( eme_is_serialized( $eme_groupids ) ) {
				$page_groupids = eme_unserialize( $eme_groupids );
			} else {
				$page_groupids = [];
			}
			if ( ! empty( $page_membershipids ) ) {
				// check if the memberships still exist
				$existing_membershipids = eme_memberships_exists( $page_membershipids );
				if ( ! empty( $existing_membershipids ) ) {
					// not logged in? then no access since at least one EME membership is required
					$wp_id = get_current_user_id();
					if ( ! $wp_id ) {
						$access_allowed = 0;
					} else {
						$person_membershipids = eme_get_active_membershipids_by_wpid( $wp_id );
						if ( ! empty( $person_membershipids ) ) {
							$res_intersect = array_intersect( $person_membershipids, $existing_membershipids );
						} else {
							$res_intersect = 0;
						}
						if ( empty( $res_intersect ) ) {
							$access_allowed = 0;
						} elseif ( $eme_drip_counter ) {
							// if we need to drip content, get the member and check the payment date
							$person_id        = eme_get_personid_by_wpid( $wp_id );
							$show_content     = 0;
							$eme_date_obj_now = new ExpressiveDate( 'now', EME_TIMEZONE );
							foreach ( $res_intersect as $membership_id ) {
								$member = eme_get_active_member_by_personid_membershipid( $person_id, $membership_id );
								if ( ! empty( $member ) ) {
									$payment_obj = new ExpressiveDate( $member['payment_date'], EME_TIMEZONE );
									if ( $member['paid'] && $eme_date_obj_now >= $payment_obj->modifyDays( $eme_drip_counter ) ) {
										$show_content = 1;
										break;
									}
								}
							}
							if ( ! $show_content ) {
								$access_allowed = 0;
							}
						}
					}
				}
			}
			if ( ! empty( $page_groupids ) ) {
				// check if the groups still exist
				$existing_groupids = eme_groups_exists( $page_groupids );
				if ( ! empty( $existing_groupids ) ) {
					// not logged in? then no access since at least one EME group is required
					$wp_id = get_current_user_id();
					if ( ! $wp_id ) {
						$access_allowed = 0;
					} else {
						$person_groupids = eme_get_persongroup_ids( 0, $wp_id );
						if ( ! empty( $person_groupids ) ) {
							$res_intersect = array_intersect( $person_groupids, $existing_groupids );
						} else {
							$res_intersect = 0;
						}
						if ( empty( $res_intersect ) ) {
							$access_allowed = 0;
						}
					}
				}
			}
			wp_cache_set( "eme_access $post_id", $access_allowed, '', 60 );
		}
	}
	return $access_allowed;
}

function eme_migrate_event_payment_options() {
	global $wpdb;
	$table_name = EME_DB_PREFIX . EME_EVENTS_TBNAME;

	$payment_options = [ 'use_paypal', 'use_2co', 'use_webmoney', 'use_fdgg', 'use_mollie' ];
	foreach ( $payment_options as $payment_option ) {
		$sql = "SELECT event_id from $table_name WHERE $payment_option=1";
		$ids = $wpdb->get_col( $sql );
		if ( ! empty( $ids ) ) {
			foreach ( $ids as $id ) {
				$event = eme_get_event( $id );
				if ( ! empty( $event ) ) {
					$event['event_properties'][ $payment_option ] = 1;
					eme_db_update_event( $event, $id );
				}
			}
		}
	}
}

function eme_migrate_event_rsvpstartend_options() {
	global $wpdb;
	$table_name = EME_DB_PREFIX . EME_EVENTS_TBNAME;

	$sql = "SELECT event_id, rsvp_number_days, rsvp_number_hours from $table_name WHERE rsvp_number_days>0 OR rsvp_number_hours>0";
	$res = $wpdb->get_results( $sql, ARRAY_A );
	if ( ! empty( $res ) ) {
		foreach ( $res as $row ) {
			$event = eme_get_event( $row['event_id'] );
			$event['event_properties'][ 'rsvp_end_number_days' ] = $row['rsvp_number_days'];
			$event['event_properties'][ 'rsvp_end_number_hours' ] = $row['rsvp_number_hours'];
			eme_db_update_event( $event, $row['event_id'] );
		}
	}
}

function eme_is_empty_string( $text ) {
	if ( empty( $text ) ) {
		return 1;
	} elseif ( is_array( $text ) ) {
		$text = array_map( 'trim', $text );
	} else {
		$text = trim( $text );
	}
	if ( $text == '' ) {
		return 1;
	} else {
		return 0;
	}
}

function eme_is_empty_date( $mydate ) {
	if ( empty( $mydate ) || $mydate == '0000-00-00' || $mydate == 'NULL' ) {
		return 1;
	} else {
		return 0;
	}
}

function eme_is_empty_datetime( $mydate ) {
	if ( empty( $mydate ) || $mydate == '0000-00-00 00:00:00' || $mydate == 'NULL' ) {
		return 1;
	} else {
		return 0;
	}
}

function eme_wysiwyg_textarea( $name, $value, $show_wp_editor = 0, $show_full = 0 ) {
	$editor_id =  preg_replace( '/\[|\]/', '_', $name);
	if ( $show_wp_editor ) {
		if ( $show_full ) {
			$eme_editor_settings = eme_get_editor_settings($name);
		} else {
			$eme_editor_settings = eme_get_editor_settings($name, false );
		}
		wp_editor( $value, $editor_id, $eme_editor_settings );
	} else { ?>
		<textarea name="<?php echo $name; ?>" id="<?php echo $editor_id; ?>" rows="6" style="width: 95%" ><?php echo eme_esc_html( $value ); ?></textarea>
		<?php
	}
}

function eme_get_answerid( $answers, $related_id, $type, $field_id, $grouping = 0, $occurence = 0 ) {
	foreach ( $answers as $answer ) {
		if ( $answer['related_id'] == $related_id &&
			$answer['type'] == $type &&
			$answer['field_id'] == $field_id &&
			$answer['eme_grouping'] == $grouping &&
			$answer['occurence'] == $occurence ) {
			return $answer['answer_id'];
		}
	}
	return 0;
}
function eme_insert_answer( $type, $related_id, $field_id, $answer, $grouping_id = 0, $occurence = 0 ) {
	global $wpdb;
	$answers_table = EME_DB_PREFIX . EME_ANSWERS_TBNAME;
	$sql           = $wpdb->prepare( "INSERT INTO $answers_table (type,related_id,field_id,answer,eme_grouping,occurence) VALUES (%s,%d,%d,%s,%d,%d)", $type, $related_id, $field_id, $answer, $grouping_id, $occurence );
	$wpdb->query( $sql );
	return $wpdb->insert_id;
}

function eme_update_answer( $answer_id, $value ) {
	global $wpdb;
	$answers_table = EME_DB_PREFIX . EME_ANSWERS_TBNAME;
	$sql           = $wpdb->prepare( "UPDATE $answers_table SET answer=%s WHERE answer_id=%d", $value, $answer_id );
	$wpdb->query( $sql );
}
function eme_delete_answer( $answer_id ) {
	global $wpdb;
	$answers_table = EME_DB_PREFIX . EME_ANSWERS_TBNAME;
	$sql           = $wpdb->prepare( "DELETE FROM $answers_table WHERE answer_id=%d", $answer_id );
	$wpdb->query( $sql );
}

function eme_get_db_prefix() {
	global $wpdb;
	if ( is_multisite() && get_option( 'eme_multisite_active' ) ) {
		return $wpdb->base_prefix;
	} else {
		return $wpdb->prefix;
	}
}

function eme_is_datamaster() {
	global $wpdb;
	if ( is_multisite() && get_option( 'eme_multisite_active' ) ) {
		if ( $wpdb->base_prefix == $wpdb->prefix ) {
			return 1;
		} else {
			return 0;
		}
	} else {
		return 1;
	}
}

function eme_get_initials( $myname ) {
	$words = preg_split( '/\s/', $myname, -1, PREG_SPLIT_NO_EMPTY );
	$res   = implode(
		'.',
		array_map(
			function ( $a ) {
				return mb_substr( $a[0], 0, 1, 'UTF-8' );
			},
			$words
		)
	);
	// add trailing '.'
	$res .= ( mb_substr( $res, -1 ) == '.' ? '' : '.' );
	return $res;
}

function eme_js_redirect( $mylink, $timeout=0 ) {
	$mylink = wp_sanitize_redirect( $mylink );
	$res = '<script type="text/javascript">';
	if ($timeout) {
		// timeout is in seconds
		$timeout *= 1000;
		$res .= "setTimeout(() => window.location.href='$mylink', $timeout);";
	} else {
		$res .= "window.location.href='$mylink';";
	}
	$res .= '</script>';
	return $res;
}

function eme_mkdir_with_index( $targetPath ) {
	$mkdir_res = true;
	if ( ! is_dir( $targetPath ) ) {
		$mkdir_res = wp_mkdir_p( $targetPath );
	}
	if ( $mkdir_res && is_writable( $targetPath ) && ! is_file( $targetPath . '/index.html' ) ) {
		touch( $targetPath . '/index.html' );
	}
	return $mkdir_res;
}

function eme_isFloat($amount ): bool {
	// if not numeric, return false
	if (!is_numeric($amount)) return false;
        $amount +=0; // this converts strings to int or float
	// we want to know if it is really a floating point, not an integer
	return is_float( $amount ) && intval( $amount ) != $amount;
}

function eme_isInt($amount ): bool {
	// if not numeric, return false
	if (!is_numeric($amount)) return false;
        $amount +=0; // this converts strings to int or float
	return is_int( $amount );
}

function eme_get_field_name($eme_opt_group, $opt_name, $is_arr=0) {
	if ($is_arr)
		return sprintf( '%s[%s][]', $eme_opt_group, $opt_name );
	else
		return sprintf( '%s[%s]', $eme_opt_group, $opt_name );
}

function eme_get_configured_captchas() {
	$captchas = wp_cache_get( 'eme_configured_captchas' );
        if ( $captchas === false ) {
		$captchas = [];
		if ( ! empty( get_option( 'eme_recaptcha_for_forms' ) ) && ! empty( get_option( 'eme_recaptcha_site_key' ) ) )
			$captchas['recaptcha'] = __('Google reCAPTCHA','events-made-easy');
		if ( ! empty( get_option( 'eme_hcaptcha_for_forms' ) ) && ! empty( get_option( 'eme_hcaptcha_site_key' ) ) )
			$captchas['hcaptcha'] = __('hCaptcha','events-made-easy');
		if ( ! empty( get_option( 'eme_cfcaptcha_for_forms' ) ) && ! empty( get_option( 'eme_cfcaptcha_site_key' ) ) )
			$captchas['cfcaptcha'] = __('Cloudflare Turnstile','events-made-easy');
		if ( ! empty( get_option( 'eme_captcha_for_forms' ) ) && function_exists( 'imagecreatetruecolor' ) )
			$captchas['captcha'] = __('Basic EME Captcha','events-made-easy');
		wp_cache_set( 'eme_configured_captchas', $captchas, '', 60 );
	}
	return $captchas;
}

// easy function that allows transition from old use_* properties for captcha to newer
function eme_get_selected_captcha($properties) {
	$selected_captcha = '';
	if (isset($properties['selected_captcha']))
                $selected_captcha = $properties['selected_captcha'];
        elseif (!empty($properties['use_recaptcha']))
                $selected_captcha = 'recaptcha';
        elseif (!empty($properties['use_hcaptcha']))
                $selected_captcha = 'hcaptcha';
        elseif (!empty($properties['use_cfcaptcha']))
                $selected_captcha = 'cfcaptcha';
        elseif (!empty($properties['use_captcha']))
                $selected_captcha = 'captcha';

	$configured_captchas = eme_get_configured_captchas();
	if (!empty($selected_captcha) && !array_key_exists($selected_captcha, $configured_captchas))
		$selected_captcha = array_key_first($configured_captchas);
	return $selected_captcha;
}

?>