eventespresso / event-espresso-core

            $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

     */

    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 );

        }

    }