eventespresso / event-espresso-core

	 * @return void

	 */

	public static function reset_page_for_posts_on_change( $option, $old_value = '', $value = '' ) {

		if ( $option == 'page_for_posts' ) {

			global $wpdb;

			$table = $wpdb->posts;

			$SQL = "SELECT post_name from $table WHERE post_type='posts' OR post_type='page' AND post_status='publish' AND ID=%d";

			$new_page_for_posts = $value ? $wpdb->get_var( $wpdb->prepare( $SQL, $value ) ) : 'posts';

			PostShortcodeTracking::set_post_shortcodes_for_posts_page( $new_page_for_posts );

		}

	}

		$current_post = apply_filters( 'FHEE__EE_Front_Controller__initialize_shortcodes__current_post_name', $this->Request_Handler->get( 'post_name' ));

		$show_on_front = get_option( 'show_on_front' );

		// if it's not set, then check if frontpage is blog

		if ( empty( $current_post ) ) {

			// yup.. this is the posts page, prepare to load all shortcode modules

			$current_post = 'posts';

			// unless..

			if ( $show_on_front === 'page' ) {

				// some other page is set as the homepage

				$page_on_front = get_option( 'page_on_front' );

				if ( $page_on_front ) {

					// k now we need to find the post_name for this page

					global $wpdb;

					$page_on_front = $wpdb->get_var(

						$wpdb->prepare(

							"SELECT post_name from $wpdb->posts WHERE post_type='page' AND post_status='publish' AND ID=%d",

							$page_on_front

						)

					);

					// set the current post slug to what it actually is

					$current_post = $page_on_front ? $page_on_front : $current_post;

				}

			}

		}

		// where are posts being displayed ?

		$page_for_posts = EE_Config::get_page_for_posts();

		// in case $current_post is hierarchical like: /parent-page/current-page