Source: my-calendar-events.php

  1. <?php
  2. /**
  3.  * Get event data. Queries to fetch events and create or modify objects.
  4.  *
  5.  * @category Events
  6.  * @package  My Calendar
  7.  * @author   Joe Dolson
  8.  * @license  GPLv2 or later
  9.  * @link     https://www.joedolson.com/my-calendar/
  10.  */
  12. if ( ! defined( 'ABSPATH' ) ) {
  13. 	exit;
  14. }
  16. /**
  17.  * Processes objects to add needed properties.
  18.  *
  19.  * @param object $event Event object.
  20.  *
  21.  * @return object $event Modifed event.
  22.  */
  23. function mc_event_object( $event ) {
  24. 	if ( is_object( $event ) ) {
  25. 		if ( ! property_exists( $event, 'categories' ) ) {
  26. 			$event->categories = mc_get_categories( $event, 'objects' );
  27. 		}
  28. 		if ( ! property_exists( $event, 'location' ) && is_numeric( $event->event_location ) && 0 !== (int) $event->event_location ) {
  29. 			$event->location = mc_get_location( $event->event_location );
  30. 		}
  31. 		if ( ! property_exists( $event, 'uid' ) ) {
  32. 			$guid = (string) get_post_meta( $event->event_post, '_mc_guid', true );
  33. 			if ( '' === $guid ) {
  34. 				$guid = mc_create_guid( $event );
  35. 			}
  36. 			$event->uid = $guid;
  37. 		}
  38. 		/**
  39. 		 * Customize the My Calendar event object.
  40. 		 *
  41. 		 * @hook mc_event_object
  42. 		 *
  43. 		 * @param {object} $object A My Calendar event.
  44. 		 *
  45. 		 * @return {object}
  46. 		 */
  47. 		$event = apply_filters( 'mc_event_object', $event );
  48. 	}
  50. 	return $event;
  51. }
  53. /**
  54.  * Get the first and last event stored in the database.
  55.  *
  56.  * @param int|false $site Optional. Site to check.
  57.  *
  58.  * @return array Array containing the date of the first and last event.
  59.  */
  60. function mc_get_date_bounds( $site = false ) {
  61. 	$return = get_transient( 'mc_get_date_bounds' );
  62. 	if ( ! $return ) {
  63. 		$mcdb  = mc_is_remote_db();
  64. 		$first = $mcdb->get_var( 'SELECT occur_begin FROM ' . my_calendar_event_table( $site ) . ' ORDER BY occur_begin ASC LIMIT 0, 1' );
  65. 		$last  = $mcdb->get_var( 'SELECT occur_end FROM ' . my_calendar_event_table( $site ) . ' ORDER BY occur_end DESC LIMIT 0, 1' );
  67. 		$return = array(
  68. 			'first' => $first,
  69. 			'last'  => $last,
  70. 		);
  71. 		set_transient( 'mc_get_date_bounds', $return, DAY_IN_SECONDS );
  72. 	}
  74. 	return $return;
  75. }
  78. /**
  79.  * Create a GUID for an event.
  80.  *
  81.  * @param object $event Event object.
  82.  *
  83.  * @return string GUID
  84.  */
  85. function mc_create_guid( $event ) {
  86. 	$guid = md5( home_url() . $event->event_post . $event->event_id . $event->event_title );
  87. 	update_post_meta( $event->event_post, '_mc_guid', $guid );
  89. 	return $guid;
  90. }
  92. /**
  93.  * Function for extracting event timestamps from MySQL. My Calendar expects the MySQL server to be in UTC.
  94.  *
  95.  * @param bool $test Test offset time.
  96.  *
  97.  * @return string|array
  98.  */
  99. function mc_ts( $test = false ) {
  100. 	$db_engine = mc_get_db_type();
  101. 	$ts_sql    = get_transient( 'mc_ts_string' );
  102. 	$ts_db     = get_transient( 'mc_ts_db' );
  103. 	if ( $ts_db && $test ) {
  104. 		return $ts_db;
  105. 	}
  106. 	if ( $test || ! $ts_sql || ! $ts_db ) {
  107. 		global $wpdb;
  108. 		if ( 'sqlite' === $db_engine ) {
  109. 			$offset = $wpdb->get_var( "SELECT STRFTIME('%Y-%m-%dT%H:%M:%S', DATETIME('now', 'localtime')) || PRINTF('%+.2d:%.2d', ROUND((JULIANDAY('now', 'localtime') - JULIANDAY('now')) * 24), ABS(ROUND((JULIANDAY('now', 'localtime') - JULIANDAY('now')) * 24 * 60) % 60));" );
  110. 		} else {
  111. 			$offset = $wpdb->get_var( 'SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);' );
  112. 		}
  113. 		/**
  114. 		 * Filter timezone offset applied when displaying events. Can fix issues with an incorrect server time.
  115. 		 *
  116. 		 * @hook mc_filter_offset
  117. 		 *
  118. 		 * @param {string} $offset Timezone offset format -HH:MM:SS.
  119. 		 *
  120. 		 * @return {string}
  121. 		 */
  122. 		$offset = apply_filters( 'mc_filter_offset', $offset );
  123. 		$offset = substr( $offset, 0, -3 );
  124. 		if ( strpos( $offset, '-' ) !== 0 ) {
  125. 			$offset = '+' . $offset;
  126. 		}
  128. 		$wp_time  = get_option( 'gmt_offset', '0' );
  129. 		$wp_time  = ( $wp_time < 0 ) ? '-' . str_pad( absint( $wp_time ), 2, 0, STR_PAD_LEFT ) : '+' . str_pad( $wp_time, 2, 0, STR_PAD_LEFT );
  130. 		$wp_time .= ':00';
  132. 		if ( $test ) {
  133. 			$return = array(
  134. 				'db' => $offset,
  135. 				'wp' => $wp_time,
  136. 			);
  137. 			set_transient( 'mc_ts_db', $return, WEEK_IN_SECONDS );
  139. 			return $return;
  140. 		}
  141. 		// Converts occur_begin value from the WordPress timezone to the db timezone.
  142. 		// Has weakness that if an event was entered during DST, it's wrong during ST and vice versa.
  143. 		$ts_sql = "UNIX_TIMESTAMP( CONVERT_TZ( `occur_begin`, '$wp_time', '$offset' ) ) AS ts_occur_begin, UNIX_TIMESTAMP( CONVERT_TZ( `occur_end`, '$wp_time', '$offset' ) ) AS ts_occur_end ";
  144. 		if ( 'sqlite' === $db_engine ) {
  145. 			$ts_sql = "datetime( `occur_begin`, '$offset hour' ) || '+$wp_time' AS ts_occur_begin, datetime( `occur_end`, '$offset hour' ) || '+$wp_time' AS ts_occur_end ";
  146. 		}
  147. 		set_transient( 'mc_ts_string', $ts_sql, WEEK_IN_SECONDS );
  148. 	}
  150. 	return $ts_sql;
  151. }
  153. /**
  154.  * Grab all events for the requested dates from calendar
  155.  *
  156.  * This function needs to be able to react to URL parameters for most factors, with the arguments being the default shown.
  157.  *
  158.  * @param array $args parameters to use for selecting events.
  159.  *
  160.  * @return array qualified events
  161.  */
  162. function my_calendar_get_events( $args ) {
  163. 	$get      = map_deep( $_GET, 'sanitize_text_field' );
  164. 	$from     = isset( $args['from'] ) ? $args['from'] : '';
  165. 	$to       = isset( $args['to'] ) ? $args['to'] : '';
  166. 	$category = isset( $args['category'] ) ? $args['category'] : 'all';
  167. 	$ltype    = isset( $args['ltype'] ) ? $args['ltype'] : 'all';
  168. 	$lvalue   = isset( $args['lvalue'] ) ? $args['lvalue'] : 'all';
  169. 	$author   = isset( $args['author'] ) ? $args['author'] : 'all';
  170. 	$host     = isset( $args['host'] ) ? $args['host'] : 'all';
  171. 	$search   = isset( $args['search'] ) ? $args['search'] : '';
  172. 	$holidays = isset( $args['holidays'] ) ? $args['holidays'] : null;
  173. 	$site     = isset( $args['site'] ) ? $args['site'] : false;
  174. 	$site     = ! is_array( $site ) ? array( $site ) : $site;
  175. 	$mcdb     = mc_is_remote_db();
  177. 	if ( 'holidays' === $holidays && '' === $category ) {
  178. 		return array();
  179. 	}
  181. 	if ( null === $holidays ) {
  182. 		$ccategory = ( isset( $get['mcat'] ) && '' !== trim( $get['mcat'] ) ) ? $get['mcat'] : $category;
  183. 	} else {
  184. 		$ccategory = $category;
  185. 	}
  186. 	$cltype  = ( isset( $get['ltype'] ) ) ? $get['ltype'] : $ltype;
  187. 	$clvalue = ( isset( $get['loc'] ) ) ? $get['loc'] : $lvalue;
  188. 	$clauth  = ( isset( $get['mc_auth'] ) ) ? $get['mc_auth'] : $author;
  189. 	$clhost  = ( isset( $get['mc_host'] ) ) ? $get['mc_host'] : $host;
  191. 	// If location value is not set, then location type shouldn't be set.
  192. 	if ( 'all' === $clvalue ) {
  193. 		$cltype = 'all';
  194. 	}
  196. 	$from = mc_checkdate( $from );
  197. 	$to   = mc_checkdate( $to );
  198. 	if ( ! $from || ! $to ) {
  199. 		return array();
  200. 	} // Not valid dates.
  202. 	$cat_limit          = ( 'all' !== $ccategory ) ? mc_select_category( $ccategory ) : array();
  203. 	$join               = ( isset( $cat_limit[0] ) ) ? $cat_limit[0] : '';
  204. 	$select_category    = ( isset( $cat_limit[1] ) ) ? $cat_limit[1] : '';
  205. 	$select_author      = ( 'all' !== $clauth ) ? mc_select_author( $clauth ) : '';
  206. 	$select_host        = ( 'all' !== $clhost ) ? mc_select_host( $clhost ) : '';
  207. 	$select_location    = mc_select_location( $cltype, $clvalue );
  208. 	$select_access      = ( isset( $get['access'] ) ) ? mc_access_limit( $get['access'] ) : '';
  209. 	$select_published   = mc_select_published();
  210. 	$search             = mc_prepare_search_query( $search );
  211. 	$exclude_categories = mc_private_categories();
  212. 	$arr_events         = array();
  213. 	$ts_string          = mc_ts();
  215. 	/**
  216. 	 * Set primary sort for getting events. Default 'occur_begin'.
  217. 	 *
  218. 	 * @hook mc_primary_sort
  219. 	 *
  220. 	 * @param {string} $primary_sort SQL sort column.
  221. 	 * @param {string} $context Current function.
  222. 	 *
  223. 	 * @return {string}
  224. 	 */
  225. 	$primary_sort = apply_filters( 'mc_primary_sort', 'occur_begin', 'my_calendar_get_events' );
  226. 	/**
  227. 	 * Set secondary sort for getting events. Default 'event_title ASC'.
  228. 	 *
  229. 	 * @hook mc_secondary_sort
  230. 	 *
  231. 	 * @param {string} $secondary_sort SQL sort column.
  232. 	 * @param {string} $context Current function.
  233. 	 *
  234. 	 * @return {string}
  235. 	 */
  236. 	$secondary_sort = apply_filters( 'mc_secondary_sort', 'event_title ASC', 'my_calendar_get_events' );
  238. 	$location_join = ( $select_location ) ? 'JOIN (SELECT location_id FROM ' . my_calendar_locations_table() . " WHERE $select_location) l on e.event_location = l.location_id" : '';
  239. 	/**
  240. 	 * Filter site parameter in queries on a multisite network. Allows a query to show events merged from multiple sites using a single shortcode.
  241. 	 *
  242. 	 * @hook mc_get_events_sites
  243. 	 *
  244. 	 * @param {array} $site Array of sites or a single site if displaying events from a different site on the network.
  245. 	 * @param {array} $args Shortcode arguments.
  246. 	 *
  247. 	 * @return {array}
  248. 	 */
  249. 	$site = apply_filters( 'mc_get_events_sites', $site, $args );
  250. 	$site = ! is_array( $site ) ? array( $site ) : $site;
  252. 	foreach ( $site as $s ) {
  253. 		$event_query = '
  254. 	SELECT *, ' . $ts_string . '
  255. 	FROM ' . my_calendar_event_table( $s ) . ' AS o
  256. 	JOIN ' . my_calendar_table( $s ) . ' AS e
  257. 	ON (event_id=occur_event_id)
  258. 	JOIN ' . my_calendar_categories_table( $s ) . " AS c 
  259. 	ON (event_category=category_id)
  260. 	$join
  261. 	$location_join
  262. 	WHERE $select_published $select_category $select_author $select_host $select_access $search
  263. 	AND ( DATE(occur_begin) BETWEEN '$from 00:00:00' AND '$to 23:59:59'
  264. 		OR DATE(occur_end) BETWEEN '$from 00:00:00' AND '$to 23:59:59'
  265. 		OR ( DATE('$from') BETWEEN DATE(occur_begin) AND DATE(occur_end) )
  266. 		OR ( DATE('$to') BETWEEN DATE(occur_begin) AND DATE(occur_end) ) )
  267. 	$exclude_categories
  268. 	GROUP BY o.occur_id ORDER BY $primary_sort, $secondary_sort";
  270. 		$events = $mcdb->get_results( $event_query );
  272. 		if ( ! empty( $events ) ) {
  273. 			$cats = array();
  274. 			$locs = array();
  275. 			foreach ( array_keys( $events ) as $key ) {
  276. 				$event          =& $events[ $key ];
  277. 				$event->site_id = $s;
  278. 				$object_id      = $event->event_id;
  279. 				$location_id    = $event->event_location;
  280. 				if ( ! isset( $cats[ $object_id ] ) ) {
  281. 					$categories         = mc_get_categories( $event, 'objects' );
  282. 					$event->categories  = $categories;
  283. 					$cats[ $object_id ] = $categories;
  284. 				} else {
  285. 					$event->categories = $cats[ $object_id ];
  286. 				}
  287. 				if ( 0 !== (int) $location_id ) {
  288. 					if ( ! isset( $locs[ $object_id ] ) ) {
  289. 						$location           = mc_get_location( $location_id );
  290. 						$event->location    = $location;
  291. 						$locs[ $object_id ] = $location;
  292. 					} else {
  293. 						$event->location = $locs[ $object_id ];
  294. 					}
  295. 				}
  296. 				$object = mc_event_object( $event );
  297. 				if ( false !== $object ) {
  298. 					$arr_events[] = $object;
  299. 				}
  300. 			}
  301. 		}
  302. 	}
  304. 	/**
  305. 	 * Filter events returned by my_calendar_get_events queries. Function returns a range of events between a start and end date.
  306. 	 *
  307. 	 * @hook mc_filter_events
  308. 	 *
  309. 	 * @param {array} $arr_events Array of event objects.
  310. 	 * @param {array} $args Event query arguments.
  311. 	 * @param {string} $context Current function context.
  312. 	 *
  313. 	 * @return {array}
  314. 	 */
  315. 	return apply_filters( 'mc_filter_events', $arr_events, $args, 'my_calendar_get_events' );
  316. }
  318. /**
  319.  * Fetch events for upcoming events list. Not date based; fetches the nearest events regardless of date.
  320.  *
  321.  * @param array $args array of event limit parameters.
  322.  *
  323.  * @return array Set of matched events.
  324.  */
  325. function mc_get_all_events( $args ) {
  326. 	$category = isset( $args['category'] ) ? $args['category'] : 'default';
  327. 	$before   = isset( $args['before'] ) ? $args['before'] : 0;
  328. 	$after    = isset( $args['after'] ) ? $args['after'] : 6;
  329. 	$author   = isset( $args['author'] ) ? $args['author'] : 'default';
  330. 	$host     = isset( $args['host'] ) ? $args['host'] : 'default';
  331. 	$ltype    = isset( $args['ltype'] ) ? $args['ltype'] : '';
  332. 	$lvalue   = isset( $args['lvalue'] ) ? $args['lvalue'] : '';
  333. 	$site     = isset( $args['site'] ) ? $args['site'] : false;
  334. 	$search   = isset( $args['search'] ) ? $args['search'] : '';
  335. 	$offset   = intval( get_option( 'gmt_offset', 0 ) ) * 60 * 60;
  336. 	$time     = isset( $args['time'] ) && '' !== $args['time'] ? strtotime( $args['time'] ) + $offset : 'now';
  337. 	$mcdb     = mc_is_remote_db();
  339. 	$now                = ( 'now' === $time ) ? 'NOW()' : $time;
  340. 	$now_limit          = ( 'now' === $time ) ? 'NOW()' : "from_unixtime($time)";
  341. 	$exclude_categories = mc_private_categories();
  342. 	$cat_limit          = ( 'default' !== $category ) ? mc_select_category( $category ) : array();
  343. 	$join               = ( isset( $cat_limit[0] ) ) ? $cat_limit[0] : '';
  344. 	$select_category    = ( isset( $cat_limit[1] ) ) ? $cat_limit[1] : '';
  345. 	$select_location    = mc_select_location( $ltype, $lvalue );
  346. 	$location_join      = ( $select_location ) ? 'JOIN (SELECT location_id FROM ' . my_calendar_locations_table() . " WHERE $select_location) l on e.event_location = l.location_id" : '';
  348. 	$select_access    = ( isset( $_GET['access'] ) ) ? mc_access_limit( $_GET['access'] ) : '';
  349. 	$select_published = mc_select_published();
  350. 	$select_author    = ( 'default' !== $author ) ? mc_select_author( $author ) : '';
  351. 	$select_host      = ( 'default' !== $host ) ? mc_select_host( $host ) : '';
  352. 	$ts_string        = mc_ts();
  353. 	$select_window    = ( ! $before ) ? 'AND occur_begin > ' . $now_limit : '';
  354. 	$select_window    = ( ! $after ) ? 'AND occur_end < ' . $now_limit : $select_window;
  355. 	$limit            = "$select_published $select_category $select_author $select_host $select_access $search $select_window";
  357. 	// New Query style.
  358. 	$total     = absint( $before ) + absint( $after ) + 30;
  359. 	$db_engine = mc_get_db_type();
  360. 	$ordering  = ( 'sqlite' === $db_engine ) ? 'ABS( ( SELECT unixepoch() ) - ( SELECT unixepoch(occur_begin) ))' : 'ABS(TIMESTAMPDIFF(SECOND, ' . $now . ', occur_begin))';
  361. 	$events    = $mcdb->get_results(
  362. 		'SELECT *, ' . $ts_string . '
  363. 		FROM ' . my_calendar_event_table( $site ) . '
  364. 		JOIN ' . my_calendar_table( $site ) . " AS e
  365. 		ON (event_id=occur_event_id)
  366. 		$join
  367. 		$location_join
  368. 		JOIN " . my_calendar_categories_table( $site ) . " as c
  369. 		ON (e.event_category=c.category_id)
  370. 		WHERE $limit
  371. 		$exclude_categories
  372. 		ORDER BY $ordering ASC LIMIT 0,$total"
  373. 	);
  375. 	$cats = array();
  376. 	foreach ( array_keys( $events ) as $key ) {
  377. 		$event          =& $events[ $key ];
  378. 		$event->site_id = $site;
  379. 		$object_id      = $event->event_id;
  380. 		if ( ! isset( $fetched[ $object_id ] ) ) {
  381. 			$cats                  = mc_get_categories( $event, 'objects' );
  382. 			$event->categories     = $cats;
  383. 			$fetched[ $object_id ] = $cats;
  384. 		} else {
  385. 			$event->categories = $fetched[ $object_id ];
  386. 		}
  387. 		$object = mc_event_object( $event );
  388. 		if ( false !== $object ) {
  389. 			$events[ $key ] = $object;
  390. 		}
  391. 	}
  393. 	/**
  394. 	 * Filter events returned by mc_get_all_events queries. Function returns a range of events based on proximity to the current date using parameters for number of days/events before or after today.
  395. 	 *
  396. 	 * @hook mc_filter_events
  397. 	 *
  398. 	 * @param {array} $events Array of event objects.
  399. 	 * @param {array} $args Event query arguments.
  400. 	 * @param {string} $context Current function context.
  401. 	 *
  402. 	 * @return {array}
  403. 	 */
  404. 	return apply_filters( 'mc_filter_events', $events, $args, 'mc_get_all_events' );
  405. }
  407. /**
  408.  * Fetch only the defined holiday category
  409.  *
  410.  * @param int    $before Number of events before.
  411.  * @param int    $after Number of events after.
  412.  * @param string $time Time/date to center collection on.
  413.  *
  414.  * @return array events
  415.  */
  416. function mc_get_all_holidays( $before, $after, $time = '' ) {
  417. 	if ( ! mc_get_option( 'skip_holidays_category' ) ) {
  418. 		return array();
  419. 	} else {
  420. 		$category = absint( mc_get_option( 'skip_holidays_category' ) );
  421. 		$args     = array(
  422. 			'category' => $category,
  423. 			'before'   => $before,
  424. 			'after'    => $after,
  425. 			'time'     => $time,
  426. 		);
  428. 		return mc_get_all_events( $args );
  429. 	}
  430. }
  432. /**
  433.  * Get most recently added events.
  434.  *
  435.  * @param integer|false $cat_id Category ID.
  436.  *
  437.  * @return array Event objects, limited by category if category ID passed.
  438.  */
  439. function mc_get_new_events( $cat_id = false ) {
  440. 	$mcdb      = mc_is_remote_db();
  441. 	$ts_string = mc_ts();
  442. 	$public    = implode( ',', mc_event_states_by_type( 'public' ) );
  443. 	if ( $cat_id ) {
  444. 		$cat = "WHERE event_category = $cat_id AND event_approved IN (' . $public . ') AND event_flagged <> 1";
  445. 	} else {
  446. 		$cat = 'WHERE event_approved IN (' . $public . ') AND event_flagged <> 1';
  447. 	}
  448. 	$exclude_categories = mc_private_categories();
  449. 	/**
  450. 	 * Filter how many days of newly added events will be included in ICS subscription links.
  451. 	 *
  452. 	 * @hook mc_rss_feed_date_range
  453. 	 *
  454. 	 * @param {int} $limit Number of days. Default 7.
  455. 	 *
  456. 	 * @return {int}
  457. 	 */
  458. 	$limit  = apply_filters( 'mc_rss_feed_date_range', 7 );
  459. 	$events = $mcdb->get_results(
  460. 		'SELECT *, ' . $ts_string . '
  461. 		FROM ' . my_calendar_event_table() . '
  462. 		JOIN ' . my_calendar_table() . ' ON (event_id=occur_event_id)
  463. 		JOIN ' . my_calendar_categories_table() . " AS c ON (event_category=category_id) $cat
  464. 		AND event_added > NOW() - INTERVAL $limit DAY 
  465. 		$exclude_categories
  466. 		ORDER BY event_added DESC"
  467. 	);
  469. 	if ( empty( $events ) ) {
  470. 		$events = $mcdb->get_results(
  471. 			'SELECT *, ' . $ts_string . '
  472. 			FROM ' . my_calendar_event_table() . '
  473. 			JOIN ' . my_calendar_table() . ' ON (event_id=occur_event_id)
  474. 			JOIN ' . my_calendar_categories_table() . " AS c ON (event_category=category_id) $cat
  475. 			$exclude_categories
  476. 			ORDER BY event_added DESC LIMIT 0,30"
  477. 		);
  478. 	}
  479. 	$groups = array();
  480. 	$output = array();
  481. 	foreach ( array_keys( $events ) as $key ) {
  482. 		$event =& $events[ $key ];
  483. 		if ( ! in_array( $event->occur_group_id, $groups, true ) ) {
  484. 			$output[ $event->event_begin ][] = $event;
  485. 		}
  486. 		if ( 1 === (int) $event->event_span ) {
  487. 			$groups[] = $event->occur_group_id;
  488. 		}
  489. 	}
  491. 	return $output;
  492. }
  494. /**
  495.  * Get all existing instances of an ID. Assemble into array with dates as keys
  496.  *
  497.  * @param int $id Event ID.
  498.  *
  499.  * @return array of event dates & instance IDs
  500.  */
  501. function mc_get_instances( $id ) {
  502. 	global $wpdb;
  503. 	$id      = (int) $id;
  504. 	$results = $wpdb->get_results( $wpdb->prepare( 'SELECT occur_id, occur_begin FROM ' . my_calendar_event_table() . ' WHERE occur_event_id = %d', $id ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
  505. 	$return  = array();
  507. 	foreach ( $results as $result ) {
  508. 		$key            = sanitize_key( mc_date( 'Y-m-d H:i:s', strtotime( $result->occur_begin ), false ) );
  509. 		$return[ $key ] = $result->occur_id;
  510. 	}
  512. 	return $return;
  513. }
  515. /**
  516.  * Fetch results of an event search.
  517.  *
  518.  * @param array|string $search array (PRO) or string (Simple).
  519.  * @param string       $time A date/time string used as the baseline for relative date results. Optional.
  520.  *
  521.  * @return array of event objects
  522.  */
  523. function mc_get_search_results( $search, $time = '' ) {
  524. 	/**
  525. 	 * Filter number of past search results to return. Default 0.
  526. 	 *
  527. 	 * @hook mc_past_search_results
  528. 	 *
  529. 	 * @param {int} $before Number of results.
  530. 	 *
  531. 	 * @return {int}
  532. 	 */
  533. 	$before = apply_filters( 'mc_past_search_results', 0 );
  534. 	/**
  535. 	 * Filter number of future search results to return. Default 15.
  536. 	 *
  537. 	 * @hook mc_future_search_results
  538. 	 *
  539. 	 * @param {int} $after Number of results.
  540. 	 *
  541. 	 * @return {int}
  542. 	 */
  543. 	$after = apply_filters( 'mc_future_search_results', 15 );
  544. 	if ( is_array( $search ) ) {
  545. 		// If from & to are set, we need to use a date-based event query.
  546. 		$from     = mc_checkdate( $search['from'] );
  547. 		$to       = mc_checkdate( $search['to'] );
  548. 		$category = ( isset( $search['category'] ) ) ? $search['category'] : null;
  549. 		$ltype    = ( isset( $search['ltype'] ) ) ? $search['ltype'] : null;
  550. 		$lvalue   = ( isset( $search['lvalue'] ) ) ? $search['lvalue'] : null;
  551. 		$author   = ( isset( $search['author'] ) ) ? $search['author'] : null;
  552. 		$host     = ( isset( $search['host'] ) ) ? $search['host'] : null;
  553. 		$search   = ( isset( $search['search'] ) ) ? $search['search'] : '';
  554. 		$args     = array(
  555. 			'from'     => $from,
  556. 			'to'       => $to,
  557. 			'category' => $category,
  558. 			'ltype'    => $ltype,
  559. 			'lvalue'   => $lvalue,
  560. 			'author'   => $author,
  561. 			'host'     => $host,
  562. 			'search'   => $search,
  563. 			'source'   => 'search',
  564. 		);
  566. 		/**
  567. 		 * Filter advanced search query arguments.
  568. 		 *
  569. 		 * @hook mc_search_attributes
  570. 		 *
  571. 		 * @param {array} $args Search query arguments.
  572. 		 * @param {string} $search Search term.
  573. 		 *
  574. 		 * @return {array}
  575. 		 */
  576. 		$args        = apply_filters( 'mc_search_attributes', $args, $search );
  577. 		$event_array = my_calendar_events( $args );
  578. 	} else {
  579. 		// If not, we use relational event queries.
  580. 		$args = array(
  581. 			'before' => $before,
  582. 			'after'  => $after,
  583. 			'search' => $search,
  584. 		);
  585. 		if ( $time ) {
  586. 			$args['time'] = $time;
  587. 		}
  589. 		$arr_events    = mc_get_all_events( $args );
  590. 		$holidays      = mc_get_all_holidays( $before, $after );
  591. 		$holiday_array = mc_set_date_array( $holidays );
  593. 		if ( is_array( $arr_events ) && ! empty( $arr_events ) ) {
  594. 			$event_array = mc_set_date_array( $arr_events );
  595. 			if ( is_array( $holidays ) && count( $holidays ) > 0 ) {
  596. 				$event_array = mc_holiday_limit( $event_array, $holiday_array ); // if there are holidays, rejigger.
  597. 			}
  598. 		}
  599. 	}
  601. 	/**
  602. 	 * Filter search events.
  603. 	 *
  604. 	 * @hook mc_searched_events
  605. 	 *
  606. 	 * @param {array} $event_array Array of found event objects.
  607. 	 * @param {array} $args Search query arguments.
  608. 	 *
  609. 	 * @return {array}
  610. 	 */
  611. 	return (array) apply_filters( 'mc_searched_events', $event_array, $args );
  612. }
  614. /**
  615.  * Get event basic info
  616.  *
  617.  * @param int     $id Event ID in my_calendar db.
  618.  * @param boolean $rebuild Get core data only if doing an event rebuild.
  619.  *
  620.  * @return object|false My Calendar Event
  621.  */
  622. function mc_get_event_core( $id, $rebuild = false ) {
  623. 	if ( ! is_numeric( $id ) ) {
  624. 		return false;
  625. 	}
  626. 	$mcdb      = mc_is_remote_db();
  627. 	$ts_string = mc_ts();
  629. 	if ( $rebuild ) {
  630. 		$event = $mcdb->get_row( $mcdb->prepare( 'SELECT * FROM ' . my_calendar_table() . ' JOIN ' . my_calendar_categories_table() . ' ON (event_category=category_id) WHERE event_id=%d', $id ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
  631. 	} else {
  632. 		$event = $mcdb->get_row( $mcdb->prepare( 'SELECT *, ' . $ts_string . ' FROM ' . my_calendar_event_table() . ' JOIN ' . my_calendar_table() . ' ON (event_id=occur_event_id) JOIN ' . my_calendar_categories_table() . ' ON (event_category=category_id) WHERE event_id = %d ORDER BY occur_id ASC LIMIT 1', $id ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
  633. 		$event = mc_event_object( $event );
  634. 	}
  636. 	return $event;
  637. }
  639. /**
  640.  * Fetches the first fully-realized event object with all parameters even if the specific instance ID isn't available.
  641.  *
  642.  * @param int $id Event core ID.
  643.  *
  644.  * @return object|boolean Event or false if no event found.
  645.  */
  646. function mc_get_first_event( $id ) {
  647. 	$mcdb      = mc_is_remote_db();
  648. 	$ts_string = mc_ts();
  649. 	$event     = ( ! is_admin() ) ? get_transient( 'mc_first_event_cache_' . $id ) : false;
  650. 	if ( $event ) {
  651. 		return $event;
  652. 	} else {
  653. 		$event = $mcdb->get_row( $mcdb->prepare( 'SELECT *, ' . $ts_string . 'FROM ' . my_calendar_event_table() . ' JOIN ' . my_calendar_table() . ' ON (event_id=occur_event_id) JOIN ' . my_calendar_categories_table() . ' ON (event_category=category_id) WHERE occur_event_id=%d', $id ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
  654. 		if ( $event ) {
  655. 			$event = mc_event_object( $event );
  656. 			set_transient( 'mc_first_event_cache_' . $id, $event, WEEK_IN_SECONDS );
  657. 		} else {
  658. 			$event = false;
  659. 		}
  660. 	}
  662. 	return $event;
  663. }
  665. /**
  666.  * Get the instance-specific information about a single event instance.
  667.  *
  668.  * @param int $instance_id Event instance ID.
  669.  *
  670.  * @return object|null query result
  671.  */
  672. function mc_get_instance_data( $instance_id ) {
  673. 	$mcdb   = mc_is_remote_db();
  674. 	$result = $mcdb->get_row( $mcdb->prepare( 'SELECT * FROM ' . my_calendar_event_table() . ' WHERE occur_id = %d', $instance_id ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
  676. 	return $result;
  677. }
  679. /**
  680.  * Fetch the instance of an event closest to today.
  681.  *
  682.  * @param int  $id Event core ID.
  683.  * @param bool $next If true, return closest event that's in the future. If false, return the event object for $id.
  684.  *
  685.  * @return object Event
  686.  */
  687. function mc_get_nearest_event( $id, $next = false ) {
  688. 	$next_event = false;
  689. 	$mcdb       = mc_is_remote_db();
  690. 	$ts_string  = mc_ts();
  691. 	$event      = $mcdb->get_row( $mcdb->prepare( 'SELECT *, ' . $ts_string . ' FROM ' . my_calendar_event_table() . ' JOIN ' . my_calendar_table() . ' ON (event_id=occur_event_id) JOIN ' . my_calendar_categories_table() . ' ON (event_category=category_id) WHERE occur_event_id=%d ORDER BY ABS( DATEDIFF( occur_begin, NOW() ) )', $id ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
  692. 	if ( true === $next ) {
  693. 		$next_event = $mcdb->get_row( $mcdb->prepare( 'SELECT *, ' . $ts_string . ' FROM ' . my_calendar_event_table() . ' JOIN ' . my_calendar_table() . ' ON (event_id=occur_event_id) JOIN ' . my_calendar_categories_table() . ' ON (event_category=category_id) WHERE occur_event_id=%d AND occur_begin > NOW() ORDER BY ABS( DATEDIFF( occur_begin, NOW() ) )', $id ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
  694. 	}
  695. 	$event = ( $next_event ) ? mc_event_object( $next_event ) : mc_event_object( $event );
  697. 	return $event;
  698. }
  700. /**
  701.  * Returns the event object for a specific instance of an event. Use mc_get_first_event() if the instance ID is unknown.
  702.  *
  703.  * @param int    $id  Event instance ID.
  704.  * @param string $type  'object' or 'html'.
  705.  *
  706.  * @return object|string
  707.  */
  708. function mc_get_event( $id, $type = 'object' ) {
  709. 	if ( ! is_numeric( $id ) ) {
  710. 		return false;
  711. 	}
  712. 	$ts_string = mc_ts();
  713. 	$mcdb      = mc_is_remote_db();
  714. 	$event     = $mcdb->get_row( $mcdb->prepare( 'SELECT *, ' . $ts_string . ' FROM ' . my_calendar_event_table() . ' JOIN ' . my_calendar_table() . ' ON (event_id=occur_event_id) JOIN ' . my_calendar_categories_table() . ' ON (event_category=category_id) WHERE occur_id=%d', $id ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
  715. 	if ( 'object' === $type ) {
  716. 		$event = mc_event_object( $event );
  717. 		return $event;
  718. 	} else {
  719. 		$date         = mc_date( 'Y-m-d', strtotime( $event->occur_begin ), false );
  720. 		$time         = mc_date( 'H:i:s', strtotime( $event->occur_begin ), false );
  721. 		$event_output = my_calendar_draw_event( $event, 'single', $date, $time, 'single' );
  722. 		$value        = '<div id="mc_event">' . $event_output['html'] . '</div>';
  724. 		return $value;
  725. 	}
  726. }
  728. /**
  729.  * Get a single data field from an event.
  730.  *
  731.  * @param string $field database column.
  732.  * @param int    $id Event core ID.
  733.  *
  734.  * @return mixed string/integer value
  735.  */
  736. function mc_get_data( $field, $id ) {
  737. 	$mcdb   = mc_is_remote_db();
  738. 	$result = $mcdb->get_var( $mcdb->prepare( "SELECT $field FROM " . my_calendar_table() . ' WHERE event_id = %d', $id ) );
  740. 	return $result;
  741. }
  743. /**
  744.  * Fetch all events according to date parameters and supported limits.
  745.  *
  746.  * @since 2.3.0
  747.  *
  748.  * @param array $args array of My Calendar display & limit parameters.
  749.  *
  750.  * @return array Array of event objects with dates as keys.
  751.  */
  752. function my_calendar_events( $args ) {
  753. 	/**
  754. 	 * Filter calendar event query arguments.
  755. 	 *
  756. 	 * @hook my_calendar_events_args
  757. 	 *
  758. 	 * @param {array} $args Array of arguments for display and limiting of events.
  759. 	 *
  760. 	 * @return {array}
  761. 	 */
  762. 	$args          = apply_filters( 'my_calendar_events_args', $args );
  763. 	$events        = my_calendar_get_events( $args );
  764. 	$event_array   = array();
  765. 	$holiday_array = array();
  766. 	$holidays      = array();
  767. 	// Get holidays to filter out.
  768. 	if ( mc_get_option( 'skip_holidays_category' ) ) {
  769. 		$args['category'] = mc_get_option( 'skip_holidays_category' );
  770. 		$args['holidays'] = 'holidays';
  771. 		$holidays         = my_calendar_get_events( $args );
  772. 		$holiday_array    = mc_set_date_array( $holidays );
  773. 	}
  774. 	// Get events into an easily parseable set, keyed by date.
  775. 	if ( is_array( $events ) && ! empty( $events ) ) {
  776. 		$event_array = mc_set_date_array( $events );
  777. 		if ( is_array( $holidays ) && count( $holidays ) > 0 ) {
  778. 			$event_array = mc_holiday_limit( $event_array, $holiday_array ); // if there are holidays, rejigger.
  779. 		}
  780. 	}
  782. 	return $event_array;
  783. }
  785. /**
  786.  * Get one event currently happening.
  787.  *
  788.  * @param string|integer      $category category ID or 'default'.
  789.  * @param string              $template display Template.
  790.  * @param integer|string|bool $site Site ID if fetching events from a different multisite instance.
  791.  *
  792.  * @return string output HTML
  793.  */
  794. function my_calendar_events_now( $category = 'default', $template = '<strong>{link_title}</strong> {timerange}', $site = false ) {
  795. 	if ( $site ) {
  796. 		$site = ( 'global' === $site ) ? BLOG_ID_CURRENT_SITE : $site;
  797. 		switch_to_blog( $site );
  798. 	}
  799. 	$mcdb               = mc_is_remote_db();
  800. 	$arr_events         = array();
  801. 	$select_published   = mc_select_published();
  802. 	$cat_limit          = ( 'default' !== $category ) ? mc_select_category( $category ) : array();
  803. 	$join               = ( isset( $cat_limit[0] ) ) ? $cat_limit[0] : '';
  804. 	$select_category    = ( isset( $cat_limit[1] ) ) ? $cat_limit[1] : '';
  805. 	$exclude_categories = mc_private_categories();
  806. 	$ts_string          = mc_ts();
  808. 	// May add support for location/author/host later.
  809. 	$select_location = '';
  810. 	$select_author   = '';
  811. 	$select_host     = '';
  812. 	/**
  813. 	 * Set primary sort for getting today's events. Default 'occur_begin'.
  814. 	 *
  815. 	 * @hook mc_primary_sort
  816. 	 *
  817. 	 * @param {string} $primary_sort SQL sort column.
  818. 	 * @param {string} $context Current function.
  819. 	 *
  820. 	 * @return {string}
  821. 	 */
  822. 	$primary_sort = apply_filters( 'mc_primary_sort', 'occur_begin', 'my_calendar_events_now' );
  823. 	/**
  824. 	 * Set secondary sort for getting today's events. Default 'event_title ASC'.
  825. 	 *
  826. 	 * @hook mc_secondary_sort
  827. 	 *
  828. 	 * @param {string} $secondary_sort SQL sort column.
  829. 	 * @param {string} $context Current function.
  830. 	 *
  831. 	 * @return {string}
  832. 	 */
  833. 	$secondary_sort = apply_filters( 'mc_secondary_sort', 'event_title ASC', 'my_calendar_events_now' );
  834. 	$now            = current_time( 'Y-m-d H:i:s' );
  835. 	$event_query    = 'SELECT *, ' . $ts_string . '
  836. 					FROM ' . my_calendar_event_table( $site ) . ' AS o
  837. 					JOIN ' . my_calendar_table( $site ) . " AS e
  838. 					ON (event_id=occur_event_id)
  839. 					$join
  840. 					JOIN " . my_calendar_categories_table( $site ) . " AS c
  841. 					ON (event_category=category_id)
  842. 					WHERE $select_published $select_category $select_location $select_author $select_host
  843. 					$exclude_categories
  844. 					AND ( CAST('$now' AS DATETIME) BETWEEN occur_begin AND occur_end )
  845. 					ORDER BY $primary_sort, $secondary_sort";
  846. 	$events         = $mcdb->get_results( $event_query );
  847. 	if ( ! empty( $events ) ) {
  848. 		foreach ( array_keys( $events ) as $key ) {
  849. 			$event        =& $events[ $key ];
  850. 			$arr_events[] = $event;
  851. 		}
  852. 	}
  853. 	if ( ! empty( $arr_events ) ) {
  854. 		$event = mc_create_tags( $arr_events[0] );
  856. 		if ( mc_key_exists( $template ) ) {
  857. 			$template = mc_get_custom_template( $template );
  858. 		}
  860. 		$args    = array(
  861. 			'event'    => $arr_events[0],
  862. 			'tags'     => $event,
  863. 			'template' => $template,
  864. 			'class'    => ( str_contains( $template, 'list_preset_' ) ) ? "list-preset $template" : '',
  865. 		);
  866. 		$details = mc_load_template( 'event/now', $args );
  867. 		if ( $details ) {
  868. 			$return = $details;
  869. 		} else {
  870. 			/**
  871. 			 * Customize the template used to draw the "happening now" shortcode output.
  872. 			 *
  873. 			 * @hook mc_happening_next_template
  874. 			 *
  875. 			 * @param {string} $template HTML and template tags.
  876. 			 * @param {object} $event Event object to draw.
  877. 			 *
  878. 			 * @return {string}
  879. 			 */
  880. 			$output = mc_draw_template( $event, apply_filters( 'mc_happening_now_template', $template, $event ) );
  881. 			$return = mc_run_shortcodes( $output );
  882. 		}
  883. 		$return = '<div class="mc-event-list">' . $return . '</div>';
  884. 	} else {
  885. 		$return = '';
  886. 	}
  888. 	if ( $site ) {
  889. 		restore_current_blog();
  890. 	}
  892. 	return $return;
  893. }
  895. /**
  896.  * Get the next scheduled event, not currently happening.
  897.  *
  898.  * @param string|integer      $category category ID or 'default'.
  899.  * @param string              $template display Template.
  900.  * @param integer             $skip Number of events to skip.
  901.  * @param integer|string|bool $site Site ID if fetching events from a different multisite instance.
  902.  *
  903.  * @return string output HTML
  904.  */
  905. function my_calendar_events_next( $category = 'default', $template = '<strong>{link_title}</strong> {timerange}', $skip = 0, $site = false ) {
  906. 	if ( $site ) {
  907. 		$site = ( 'global' === $site ) ? BLOG_ID_CURRENT_SITE : $site;
  908. 		switch_to_blog( $site );
  909. 	}
  910. 	$mcdb               = mc_is_remote_db();
  911. 	$arr_events         = array();
  912. 	$select_published   = mc_select_published();
  913. 	$cat_limit          = ( 'default' !== $category ) ? mc_select_category( $category ) : array();
  914. 	$join               = ( isset( $cat_limit[0] ) ) ? $cat_limit[0] : '';
  915. 	$select_category    = ( isset( $cat_limit[1] ) ) ? $cat_limit[1] : '';
  916. 	$exclude_categories = mc_private_categories();
  917. 	$ts_string          = mc_ts();
  919. 	// May add support for location/author/host later.
  920. 	$select_location = '';
  921. 	$select_author   = '';
  922. 	$select_host     = '';
  923. 	$now             = current_time( 'Y-m-d H:i:s' );
  924. 	$event_query     = 'SELECT *, ' . $ts_string . '
  925. 			FROM ' . my_calendar_event_table( $site ) . '
  926. 			JOIN ' . my_calendar_table( $site ) . " AS e
  927. 			ON (event_id=occur_event_id)
  928. 			$join
  929. 			JOIN " . my_calendar_categories_table( $site ) . " as c
  930. 			ON (e.event_category=c.category_id)
  931. 			WHERE $select_published $select_category $select_location $select_author $select_host
  932. 					$exclude_categories
  933. 			AND DATE(occur_begin) > CAST('$now' as DATETIME) ORDER BY occur_begin LIMIT $skip,1";
  935. 	$events = $mcdb->get_results( $event_query );
  936. 	if ( ! empty( $events ) ) {
  937. 		foreach ( array_keys( $events ) as $key ) {
  938. 			$event        =& $events[ $key ];
  939. 			$arr_events[] = $event;
  940. 		}
  941. 	}
  942. 	if ( ! empty( $arr_events ) ) {
  943. 		$event = mc_create_tags( $arr_events[0] );
  945. 		if ( mc_key_exists( $template ) ) {
  946. 			$template = mc_get_custom_template( $template );
  947. 		}
  949. 		$args    = array(
  950. 			'event'    => $arr_events[0],
  951. 			'tags'     => $event,
  952. 			'template' => $template,
  953. 			'class'    => ( str_contains( $template, 'list_preset_' ) ) ? "list-preset $template" : '',
  954. 		);
  955. 		$details = mc_load_template( 'event/next', $args );
  956. 		if ( $details ) {
  957. 			$return = $details;
  958. 		} else {
  959. 			/**
  960. 			 * Customize the template used to draw the next event shortcode output.
  961. 			 *
  962. 			 * @hook mc_happening_next_template
  963. 			 *
  964. 			 * @param {string} $template HTML and template tags.
  965. 			 * @param {object} $event Event object to draw.
  966. 			 *
  967. 			 * @return {string}
  968. 			 */
  969. 			$output = mc_draw_template( $event, apply_filters( 'mc_happening_next_template', $template, $event ) );
  970. 			$return = mc_run_shortcodes( $output );
  971. 		}
  972. 		$return = '<div class="mc-event-list">' . $return . '</div>';
  973. 	} else {
  974. 		$return = '';
  975. 	}
  977. 	if ( $site ) {
  978. 		restore_current_blog();
  979. 	}
  981. 	return $return;
  982. }
  985. /**
  986.  *  Get all occurrences associated with an event.
  987.  *
  988.  * @param int $id Event ID.
  989.  *
  990.  * @return array of objects with instance and event IDs.
  991.  */
  992. function mc_get_occurrences( $id ) {
  993. 	$mcdb = mc_is_remote_db();
  994. 	$id   = absint( $id );
  995. 	if ( 0 === $id ) {
  996. 		return array();
  997. 	}
  998. 	$results = $mcdb->get_results( $mcdb->prepare( 'SELECT occur_id, occur_event_id FROM ' . my_calendar_event_table() . ' WHERE occur_event_id=%d ORDER BY occur_begin ASC', $id ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
  1000. 	return $results;
  1001. }
  1003. /**
  1004.  * Return all instances of a given event.
  1005.  *
  1006.  * @param array $args Arguments describing the output type.
  1007.  *
  1008.  * @return string HTML list of instance data & single event view
  1009.  */
  1010. function mc_instance_list( $args ) {
  1011. 	$id = isset( $args['event'] ) ? $args['event'] : false;
  1012. 	if ( ! $id ) {
  1013. 		return '';
  1014. 	}
  1015. 	$template = isset( $args['template'] ) ? $args['template'] : '<h3>{title}</h3>{description}';
  1016. 	$list     = isset( $args['list'] ) ? $args['list'] : '<li>{date}, {time}</li>';
  1017. 	$before   = isset( $args['before'] ) ? $args['before'] : '<ul>';
  1018. 	$after    = isset( $args['after'] ) ? $args['after'] : '</ul>';
  1019. 	$instance = isset( $args['instance'] ) ? $args['instance'] : false;
  1021. 	global $wpdb;
  1022. 	$output = '';
  1023. 	if ( true === $instance || '1' === $instance ) {
  1024. 		$sql = 'SELECT * FROM ' . my_calendar_event_table() . ' WHERE occur_id=%d ORDER BY occur_begin ASC';
  1025. 	} else {
  1026. 		$sql = 'SELECT * FROM ' . my_calendar_event_table() . ' WHERE occur_event_id=%d ORDER BY occur_begin ASC';
  1027. 	}
  1028. 	$results = $wpdb->get_results( $wpdb->prepare( $sql, $id ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
  1029. 	if ( is_array( $results ) ) {
  1030. 		$details = '';
  1031. 		foreach ( $results as $result ) {
  1032. 			$event_id = $result->occur_id;
  1033. 			$event    = mc_get_event( $event_id );
  1034. 			$array    = mc_create_tags( $event );
  1035. 			if ( in_array( $template, array( 'details', 'grid', 'list', 'mini', 'card' ), true ) || mc_key_exists( $template ) ) {
  1036. 				if ( 1 === (int) mc_get_option( 'use_' . $template . '_template' ) ) {
  1037. 					$template = mc_get_template( $template );
  1038. 				} elseif ( mc_key_exists( $template ) ) {
  1039. 					$template = mc_get_custom_template( $template );
  1040. 				} else {
  1041. 					$details = my_calendar_draw_event( $event, 'single', $event->event_begin, $event->event_time, '', '', $array );
  1042. 				}
  1043. 			}
  1044. 			$item = ( '' !== $list ) ? mc_draw_template( $array, $list ) : '';
  1045. 			if ( '' === $details ) {
  1046. 				$details = ( '' !== $template ) ? mc_draw_template( $array, $template ) : '';
  1047. 			}
  1048. 			$output .= $item;
  1049. 			if ( '' === $list ) {
  1050. 				break;
  1051. 			}
  1052. 		}
  1053. 		$output = $details . $before . $output . $after;
  1055. 	}
  1057. 	return mc_run_shortcodes( $output );
  1058. }
  1060. /**
  1061.  * Generate a list of instances for the currently edited event
  1062.  *
  1063.  * @param int $id Event ID.
  1064.  * @param int $occur Specific occurrence ID.
  1065.  *
  1066.  * @return bool|string
  1067.  */
  1068. function mc_admin_instances( $id, $occur = 0 ) {
  1069. 	global $wpdb;
  1070. 	$output    = '';
  1071. 	$ts_string = mc_ts();
  1072. 	$results   = $wpdb->get_results( $wpdb->prepare( 'SELECT *, ' . $ts_string . ' FROM ' . my_calendar_event_table() . ' WHERE occur_event_id=%d ORDER BY occur_begin ASC', $id ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
  1073. 	if ( empty( $results ) ) {
  1074. 		return false;
  1075. 	}
  1076. 	$count = count( $results );
  1077. 	if ( is_array( $results ) && is_admin() ) {
  1078. 		foreach ( $results as $result ) {
  1079. 			$start = $result->ts_occur_begin;
  1080. 			$end   = $result->ts_occur_end;
  1081. 			if ( ( ( $end + 1 ) - $start ) === DAY_IN_SECONDS || ( $end - $start ) === DAY_IN_SECONDS ) {
  1082. 				$time = '';
  1083. 			} elseif ( ( $end - $start ) <= HOUR_IN_SECONDS ) {
  1084. 				$time = mc_date( mc_time_format(), $start );
  1085. 			} else {
  1086. 				$time = mc_date( mc_time_format(), $start ) . ' - ' . mc_date( mc_time_format(), $end );
  1087. 			}
  1088. 			// Omitting format from mc_date() returns timestamp.
  1089. 			$date  = date_i18n( mc_date_format(), mc_date( '', $start ) );
  1090. 			$date  = "<span id='occur_date_$result->occur_id'><strong>" . $date . '</strong><br />' . $time . '</span>';
  1091. 			$class = ( my_calendar_date_xcomp( mc_date( 'Y-m-d H:i:00', $start ), mc_date( 'Y-m-d H:i:00', time() ) ) ) ? 'past-event' : 'future-event';
  1092. 			if ( (int) $result->occur_id === (int) $occur || 1 === $count ) {
  1093. 				$control  = '';
  1094. 				$control .= "<p>$date</p><p><em>" . __( 'Editing Now', 'my-calendar' ) . '</em></p>';
  1095. 				$class    = 'current-event';
  1096. 			} else {
  1097. 				$control  = "<p>$date</p>";
  1098. 				$control .= "<p class='instance-buttons'>";
  1099. 				$control .= "<button class='button delete_occurrence' type='button' data-event='$result->occur_event_id' data-begin='$result->occur_begin' data-end='$result->occur_end' data-value='$result->occur_id' aria-describedby='occur_date_$result->occur_id' />" . __( 'Delete', 'my-calendar' ) . '</button> ';
  1100. 				$control .= "<button class='button edit_occurrence' type='button' data-event='$result->occur_event_id' data-begin='$result->occur_begin' data-end='$result->occur_end' data-value='$result->occur_id' aria-describedby='occur_date_$result->occur_id' />" . __( 'Edit Date', 'my-calendar' ) . '</button>';
  1101. 				$control .= '</p><p>';
  1102. 				$control .= "<a href='" . admin_url( 'admin.php?page=my-calendar' ) . "&amp;mode=edit&amp;event_id=$id&amp;date=$result->occur_id' aria-describedby='occur_date_$result->occur_id'>" . __( 'Edit Details', 'my-calendar' ) . '</a>';
  1103. 				$control .= '</p>';
  1104. 			}
  1105. 			$output .= "<li class='$class'>$control</li>";
  1106. 		}
  1107. 	}
  1109. 	return $output;
  1110. }
  1112. /**
  1113.  * Get all events with a grouped relationship with the current event.
  1114.  *
  1115.  * @param int $id Group ID.
  1116.  *
  1117.  * @return array Array event IDs of grouped events
  1118.  */
  1119. function mc_get_grouped_events( $id ) {
  1120. 	global $wpdb;
  1121. 	$id = (int) $id;
  1122. 	if ( 0 === $id ) {
  1123. 		return array();
  1124. 	}
  1125. 	$results = $wpdb->get_results( $wpdb->prepare( 'SELECT event_id FROM ' . my_calendar_table() . ' WHERE event_group_id=%d', $id ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
  1127. 	return $results;
  1128. }
  1131. /**
  1132.  * Get the events adjacent to the currently displayed event.
  1133.  *
  1134.  * @param integer $mc_id ID of current event.
  1135.  * @param string  $adjacent Next/Previous.
  1136.  * @param array   $args Additional arguments to pass to query and return.
  1137.  *
  1138.  * @return array|object Event template array or object.
  1139.  */
  1140. function mc_adjacent_event( $mc_id, $adjacent = 'previous', $args = array() ) {
  1141. 	$mcdb               = mc_is_remote_db();
  1142. 	$adjacence          = ( 'next' === $adjacent ) ? '>' : '<';
  1143. 	$order              = ( 'next' === $adjacent ) ? 'ASC' : 'DESC';
  1144. 	$site               = false;
  1145. 	$arr_events         = array();
  1146. 	$select_published   = mc_select_published();
  1147. 	$exclude_categories = mc_private_categories();
  1148. 	$category           = ( isset( $args['category'] ) ) ? $args['category'] : 'default';
  1149. 	$ltype              = ( isset( $args['ltype'] ) ) ? $args['ltype'] : '';
  1150. 	$lvalue             = ( isset( $args['lvalue'] ) ) ? $args['lvalue'] : '';
  1151. 	$author             = ( isset( $args['author'] ) ) ? $args['author'] : '';
  1152. 	$host               = ( isset( $args['host'] ) ) ? $args['host'] : '';
  1153. 	$cat_limit          = ( 'default' !== $category ) ? mc_select_category( $category ) : array();
  1154. 	$join               = ( isset( $cat_limit[0] ) ) ? $cat_limit[0] : '';
  1155. 	$select_category    = ( isset( $cat_limit[1] ) ) ? $cat_limit[1] : '';
  1156. 	$select_location    = mc_select_location( $ltype, $lvalue );
  1157. 	$location_join      = ( $select_location ) ? 'JOIN (SELECT location_id FROM ' . my_calendar_locations_table() . " WHERE $select_location) l on e.event_location = l.location_id" : '';
  1158. 	$select_author      = ( 'default' !== $author ) ? mc_select_author( $author ) : '';
  1159. 	$select_host        = ( 'default' !== $host ) ? mc_select_host( $host ) : '';
  1160. 	$ts_string          = mc_ts();
  1161. 	$source             = mc_get_event( $mc_id );
  1162. 	$return             = array();
  1164. 	$offset = ( isset( $args['offset'] ) ) ? absint( $args['offset'] ) : 0;
  1165. 	if ( is_object( $source ) ) {
  1166. 		$date        = mc_date( 'Y-m-d H:i:s', strtotime( $source->occur_begin ), false );
  1167. 		$event_query = 'SELECT *, ' . $ts_string . '
  1168. 				FROM ' . my_calendar_event_table( $site ) . '
  1169. 				JOIN ' . my_calendar_table( $site ) . ' AS e
  1170. 				ON (event_id=occur_event_id)
  1171. 				JOIN ' . my_calendar_categories_table( $site ) . " as c
  1172. 				ON (e.event_category=c.category_id)
  1173. 				$join
  1174. 				$location_join
  1175. 				WHERE $select_published $select_category $select_author $select_host $exclude_categories
  1176. 				AND occur_begin $adjacence CAST('$date' as DATETIME) ORDER BY occur_begin $order LIMIT $offset,1";
  1178. 		$events = $mcdb->get_results( $event_query );
  1179. 		if ( ! empty( $events ) ) {
  1180. 			foreach ( array_keys( $events ) as $key ) {
  1181. 				$event        =& $events[ $key ];
  1182. 				$arr_events[] = $event;
  1183. 			}
  1184. 		}
  1185. 		if ( ! empty( $arr_events ) ) {
  1186. 			$return = ( isset( $args['return'] ) && 'object' === $args['return'] ) ? $arr_events[0] : mc_create_tags( $arr_events[0] );
  1187. 		} else {
  1188. 			$return = array();
  1189. 		}
  1190. 	}
  1192. 	return $return;
  1193. }
  1195. /**
  1196.  * Remove non-holiday events from data if a holiday is present.
  1197.  *
  1198.  * @param array $events Array of event objects.
  1199.  * @param array $holidays Array of event objects.
  1200.  *
  1201.  * @return array Array of event objects with conflicts removed.
  1202.  */
  1203. function mc_holiday_limit( $events, $holidays ) {
  1204. 	foreach ( array_keys( $events ) as $key ) {
  1205. 		if ( ! empty( $holidays[ $key ] ) ) {
  1206. 			foreach ( $events[ $key ] as $k => $event ) {
  1207. 				if ( (int) mc_get_option( 'skip_holidays_category' ) !== (int) $event->event_category && 1 === (int) $event->event_holiday ) {
  1208. 					unset( $events[ $key ][ $k ] );
  1209. 				}
  1210. 			}
  1211. 		}
  1212. 	}
  1214. 	return $events;
  1215. }
  1217. /**
  1218.  * For date-based views, manipulate array to be organized by dates
  1219.  *
  1220.  * @param array $events Array of event objects returned by query.
  1221.  *
  1222.  * @return array $events indexed by date
  1223.  */
  1224. function mc_set_date_array( $events ) {
  1225. 	$event_array = array();
  1226. 	if ( is_array( $events ) && ! empty( $events ) ) {
  1227. 		foreach ( $events as $event ) {
  1228. 			$date = mc_date( 'Y-m-d', strtotime( $event->occur_begin ), false );
  1229. 			$end  = mc_date( 'Y-m-d', strtotime( $event->occur_end ), false );
  1230. 			if ( $date !== $end ) {
  1231. 				$start = strtotime( $date );
  1232. 				$end   = strtotime( $end );
  1233. 				do {
  1234. 					$date                   = mc_date( 'Y-m-d', $start, false );
  1235. 					$event_array[ $date ][] = $event;
  1236. 					$start                  = strtotime( '+1 day', $start );
  1237. 				} while ( $start <= $end );
  1238. 			} else {
  1239. 				$event_array[ $date ][] = $event;
  1240. 			}
  1241. 		}
  1242. 	}
  1244. 	return $event_array;
  1245. }
  1247. /**
  1248.  * Verify that a given occurrence ID is valid.
  1249.  *
  1250.  * @param int $mc_id Occurrence ID.
  1251.  *
  1252.  * @return boolean|int Returns event ID on valid value.
  1253.  */
  1254. function mc_valid_id( $mc_id ) {
  1255. 	$mcdb   = mc_is_remote_db();
  1256. 	$result = $mcdb->get_var( $mcdb->prepare( 'SELECT occur_event_id FROM ' . my_calendar_event_table() . ' WHERE occur_id = %d', $mc_id ) );
  1258. 	if ( null !== $result ) {
  1259. 		return $result;
  1260. 	}
  1262. 	return false;
  1263. }
  1265. /**
  1266.  * Get post associated with a given My Calendar event
  1267.  *
  1268.  * @param int $event_id Event ID.
  1269.  *
  1270.  * @return mixed int/boolean post ID if found; else false
  1271.  */
  1272. function mc_get_event_post( $event_id ) {
  1273. 	$event = mc_get_first_event( $event_id );
  1274. 	if ( is_object( $event ) ) {
  1275. 		if ( property_exists( $event, 'event_post' ) && get_post_status( $event->event_post ) ) {
  1276. 			return $event->event_post;
  1277. 		}
  1278. 	}
  1280. 	return false;
  1281. }
  1283. /**
  1284.  * Check the type of database, so handling of search queries is correct.
  1285.  *
  1286.  * @return string type of database engine in use;
  1287.  */
  1288. function mc_get_db_type() {
  1289. 	// If running sqlite, return that.
  1290. 	$db_engine = defined( 'DB_ENGINE' ) && 'sqlite' === DB_ENGINE ? 'sqlite' : 'mysql';
  1291. 	if ( 'sqlite' === $db_engine ) {
  1292. 		return 'sqlite';
  1293. 	}
  1294. 	// This is unlikely to change, but it's not impossible.
  1295. 	$db_type = get_transient( 'mc_db_type' );
  1296. 	if ( ! $db_type ) {
  1297. 		$db_type     = 'MyISAM';
  1298. 		$mcdb        = mc_is_remote_db();
  1299. 		$my_calendar = my_calendar_table();
  1300. 		$dbs         = $mcdb->get_results( $mcdb->prepare( 'SHOW TABLE STATUS WHERE name=%s', $my_calendar ) );
  1301. 		foreach ( $dbs as $db ) {
  1302. 			$db = (array) $db;
  1303. 			if ( my_calendar_table() === $db['Name'] ) {
  1304. 				$db_type = $db['Engine'];
  1305. 			}
  1306. 		}
  1307. 		set_transient( 'mc_db_type', $db_type, MONTH_IN_SECONDS );
  1308. 	}
  1310. 	return $db_type;
  1311. }
  1313. /**
  1314.  * Produce list of statuses & counts for events manager.
  1315.  *
  1316.  * @param bool $allow_filters Whether current user can see spam filters.
  1317.  *
  1318.  * @return string
  1319.  */
  1320. function mc_status_links( $allow_filters ) {
  1321. 	$counts = get_option( 'mc_count_cache' );
  1322. 	if ( empty( $counts ) ) {
  1323. 		$counts = mc_update_count_cache();
  1324. 	}
  1325. 	$all            = isset( $counts['all'] ) ? $counts['all'] : $counts['published'] + $counts['draft'] + $counts['trash'];
  1326. 	$all_attributes = ( isset( $_GET['limit'] ) && 'all' === $_GET['limit'] ) ? ' aria-current="true"' : '';
  1327. 	// Translators: Number of total events.
  1328. 	$all_text = sprintf( __( 'All (%d)', 'my-calendar' ), $all );
  1330. 	$pub_attributes = ( isset( $_GET['limit'] ) && 'published' === $_GET['limit'] ) ? ' aria-current="true"' : '';
  1331. 	// Translators: Number of total events.
  1332. 	$pub_text = sprintf( __( 'Published (%d)', 'my-calendar' ), $counts['published'] );
  1334. 	$dra_attributes = ( isset( $_GET['limit'] ) && 'draft' === $_GET['limit'] ) ? ' aria-current="true"' : '';
  1335. 	// Translators: Number of total events.
  1336. 	$dra_text = sprintf( __( 'Drafts (%d)', 'my-calendar' ), $counts['draft'] );
  1338. 	$tra_attributes = ( isset( $_GET['limit'] ) && 'trashed' === $_GET['limit'] ) ? ' aria-current="true"' : '';
  1339. 	// Translators: Number of total events.
  1340. 	$tra_text = sprintf( __( 'Trashed (%d)', 'my-calendar' ), $counts['trash'] );
  1342. 	$arc_attributes = ( isset( $_GET['restrict'] ) && 'archived' === $_GET['restrict'] ) ? ' aria-current="true"' : '';
  1343. 	// Translators: Number of total events.
  1344. 	$arc_text = sprintf( __( 'Archived (%d)', 'my-calendar' ), $counts['archive'] );
  1346. 	$can_text = '';
  1347. 	if ( isset( $counts['cancel'] ) && 0 < (int) $counts['cancel'] ) {
  1348. 		$can_attributes = ( isset( $_GET['limit'] ) && 'cancelled' === $_GET['limit'] ) ? ' aria-current="true"' : '';
  1349. 		// Translators: Number of total events.
  1350. 		$can_text = sprintf( __( 'Cancelled (%d)', 'my-calendar' ), $counts['cancel'] );
  1351. 	}
  1352. 	$pri_text = '';
  1353. 	if ( isset( $counts['private'] ) && 0 < (int) $counts['private'] ) {
  1354. 		$pri_attributes = ( isset( $_GET['limit'] ) && 'private' === $_GET['limit'] ) ? ' aria-current="true"' : '';
  1355. 		// Translators: Number of total events.
  1356. 		$pri_text = sprintf( __( 'Private (%d)', 'my-calendar' ), $counts['private'] );
  1357. 	}
  1359. 	$spa_attributes = ( isset( $_GET['restrict'] ) && 'flagged' === $_GET['restrict'] ) ? ' aria-current="true"' : '';
  1360. 	// Translators: Number of total events.
  1361. 	$spa_text = sprintf( __( 'Spam (%d)', 'my-calendar' ), $counts['spam'] );
  1363. 	$output = '
  1364. 	<ul class="links">
  1365. 		<li>
  1366. 			<a ' . $all_attributes . ' href="' . mc_admin_url( 'admin.php?page=my-calendar-manage&amp;limit=all' ) . '">' . $all_text . '</a>
  1367. 		</li>
  1368. 		<li>
  1369. 			<a ' . $pub_attributes . ' href="' . mc_admin_url( 'admin.php?page=my-calendar-manage&amp;limit=published' ) . '">' . $pub_text . '</a>
  1370. 		</li>
  1371. 		<li>
  1372. 			<a ' . $dra_attributes . ' href="' . mc_admin_url( 'admin.php?page=my-calendar-manage&amp;limit=draft' ) . '">' . $dra_text . '</a>
  1373. 		</li>
  1374. 		<li>
  1375. 			<a ' . $tra_attributes . ' href="' . admin_url( 'admin.php?page=my-calendar-manage&amp;limit=trashed' ) . '">' . $tra_text . '</a>
  1376. 		</li>
  1377. 		<li>
  1378. 			<a ' . $arc_attributes . ' href="' . mc_admin_url( 'admin.php?page=my-calendar-manage&amp;restrict=archived' ) . '">' . $arc_text . '</a>
  1379. 		</li>';
  1380. 	if ( $can_text ) {
  1381. 		$output .= '
  1382. 		<li>
  1383. 			<a ' . $can_attributes . ' href="' . admin_url( 'admin.php?page=my-calendar-manage&amp;limit=cancelled' ) . '">' . $can_text . '</a>
  1384. 		</li>';
  1385. 	}
  1386. 	if ( $pri_text ) {
  1387. 		$output .= '
  1388. 		<li>
  1389. 			<a ' . $pri_attributes . ' href="' . admin_url( 'admin.php?page=my-calendar-manage&amp;limit=private' ) . '">' . $pri_text . '</a>
  1390. 		</li>';
  1391. 	}
  1392. 	if ( ( function_exists( 'akismet_http_post' ) || ( 0 < (int) $counts['spam'] ) ) && $allow_filters ) {
  1393. 		$output .= '
  1394. 		<li>
  1395. 			<a ' . $spa_attributes . ' href="' . mc_admin_url( 'admin.php?page=my-calendar-manage&amp;restrict=flagged&amp;filter=1' ) . '">' . $spa_text . '</a>
  1396. 		</li>';
  1397. 	}
  1398. 	$output .= '</ul>';
  1400. 	return $output;
  1401. }