コード例 #1
0
ファイル: header.php プロジェクト: MrBoy31/helpful-intranet
echo "\n\t\t.page-template-page-news-php h1 {\n\t\tborder-bottom: " . $gisheight . "px solid " . RGBToHTML($topborder) . ";\n\t\t} \n\t\t.tax-team h2 {\n\t\tborder-bottom: " . $gisheight . "px solid " . RGBToHTML($topborder) . ";\n\t\t} \n\t\t";
//write custom css for logo
$gis = "general_intranet_header_logo";
$gisid = get_option($gis);
$gislogow = wp_get_attachment_image_src($gisid[0]);
$gislogo = $gislogow[0];
$gisw = $gislogow[1] + 10;
echo "\n\t\t#crownlink  {\n\t\tbackground: url('" . $gislogo . "') no-repeat;\t \n\t\tbackground-position:left 10px;\n\t\tpadding: 16px 0 0 " . $gisw . "px;\n\t\theight: auto;\n\t\tmin-height: 50px;\n\t\tmargin-bottom: 0.6em;\n\t\t}\n\t\t";
echo "\n\t\t#primarynav ul li  {\n\t\tborder-bottom: 1px solid " . $gishex . ";\n\t\tborder-top: 1px solid " . $gishex . ";\n\t\tborder-right: 1px solid " . $gishex . ";\n\t\t}\n\t\t";
$terms = get_terms('category');
if ($terms) {
    foreach ((array) $terms as $taxonomy) {
        $themeid = $taxonomy->term_id;
        $themeURL = $taxonomy->slug;
        $thistheme = new pod('category', $themeid);
        $background = $thistheme->get_field('cat_background_colour');
        $foreground = $thistheme->get_field('cat_foreground_colour');
        echo ".t" . $themeid . "{color: " . $foreground . "; background: " . $background . ";} \n";
        echo ".t" . $themeid . " a {color: " . $foreground . " !important;} \n";
        echo ".brd" . $themeid . "{border-left: 1.2em solid " . $background . ";} \n";
        echo ".hr" . $themeid . "{border-bottom: 1px solid " . $background . ";} \n";
        echo ".h1_" . $themeid . "{border-bottom: " . $gisheight . "px solid " . $background . "; margin-bottom: 0.4em; padding-bottom: 0.3em;} \n";
        echo ".b" . $themeid . "{border-left: 20px solid " . $background . ";} \n";
        echo ".glyphicon.glyphicon-stop.gb" . $themeid . "{color: " . $background . ";} \n";
    }
}
?>
	</style>
	<!--Google Analytics-->
	<?php 
//write script for google analytics (only do on homepage if homepage tracking is set)
コード例 #2
0
ファイル: ht_g4up.php プロジェクト: meowrika/govintranet
function ht_g4up_options()
{
    if (!current_user_can('manage_options')) {
        wp_die(__('You do not have sufficient permissions to access this page.'));
    }
    ob_start();
    echo "<div class='wrap'>";
    //	screen_icon();
    echo "<h2>" . __(' GovIntranet 4 upgrade') . "</h2>";
    if ($_REQUEST['action'] == "processimport") {
        echo "<br><strong>Upgrading tasks</strong> ";
        global $wpdb;
        /*
        		$query = $wpdb->get_results("select ID, post_title from $wpdb->posts where post_status = 'publish' and post_type = 'task' and post_title like '[%%]%%';"); 
        		if ($query):
        			foreach ((array)$query as $q){
        				  $my_post = array(
        				      'ID'           => intval($q->ID),
        				      'post_title' => trim(preg_replace('/\[.*\]/i','',$q->post_title))
        				  );
        				  wp_update_post( $my_post ); echo ".";		ob_flush();
        			}
        		endif;
        		echo "<br>Upgraded ".count($query)." task titles";
        		ob_flush();
        		unset($query);
        */
        $query = $wpdb->query("UPDATE {$wpdb->posts}, {$wpdb->postmeta} SET post_parent = {$wpdb->postmeta}.meta_value WHERE {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id and {$wpdb->postmeta}.meta_key='parent_guide' and {$wpdb->posts}.post_type = 'task';");
        echo "<br>Upgraded " . $query . " guide chapters";
        $query = $wpdb->get_results("select post_id, meta_value from {$wpdb->postmeta} where meta_key='_pods_children_chapters';");
        if ($query) {
            foreach ((array) $query as $q) {
                $cs = get_post_meta($q->post_id, 'children_chapters', false);
                //print_r($cs);
                $ordercount = 0;
                foreach ($cs as $key => $oldchapter) {
                    $o = $oldchapter['ID'];
                    $ordercount = $ordercount + 10;
                    $query2 = $wpdb->query("UPDATE {$wpdb->posts} SET menu_order = " . $ordercount . " WHERE {$wpdb->posts}.ID = " . $o . ";");
                }
            }
        }
        ob_flush();
        unset($query);
        $query = $wpdb->query("UPDATE {$wpdb->postmeta} set meta_key = 'related' WHERE meta_key = 'related_tasks';");
        echo "<br>Upgraded " . $query . " related task records";
        ob_flush();
        unset($query);
        $query = $wpdb->get_results("select distinct post_id from {$wpdb->postmeta} where {$wpdb->postmeta}.meta_key = 'document_attachments' and {$wpdb->postmeta}.meta_value <> '';");
        if ($query) {
            foreach ((array) $query as $q) {
                $attachcount = 0;
                $cpost = get_post($q->post_id);
                $cposttype = $cpost->post_type;
                $att = new pod($cposttype, $q->post_id);
                $docs = $att->get_field('document_attachments');
                if ($docs) {
                    $attachtotal = count($docs);
                    foreach ((array) $docs as $d) {
                        //print_r($d); echo "<br>";
                        add_post_meta($q->post_id, 'document_attachments_' . $attachcount . '_document_attachment', $d['ID']);
                        add_post_meta($q->post_id, '_document_attachments_' . $attachcount . '_document_attachment', 'field_53bd6e229b9b3');
                        delete_post_meta($q->post_id, 'document_attachments', $d['ID']);
                        $attachcount++;
                    }
                    add_post_meta($q->post_id, 'document_attachments', $attachtotal);
                    add_post_meta($q->post_id, '_document_attachments', 'field_536ec90dc8419');
                }
            }
        }
        echo "<br>Upgraded " . count($query) . " document records";
        ob_flush();
        unset($query);
        $query = $wpdb->get_results("select post_id from {$wpdb->postmeta} where {$wpdb->postmeta}.meta_key = 'external_link' and {$wpdb->postmeta}.meta_value <> '';");
        if ($query) {
            foreach ((array) $query as $q) {
                set_post_format($q->post_id, 'link');
            }
        }
        echo "<br>Upgraded " . count($query) . " external links";
        ob_flush();
        echo "<br><br><strong>Upgrading news</strong> ";
        unset($query);
        $query = $wpdb->query("UPDATE {$wpdb->postmeta} set meta_key = 'related' WHERE meta_key = 'related_stories';");
        echo "<br>Upgraded " . $query . " related news records";
        ob_flush();
        unset($query);
        $query = $wpdb->query("UPDATE {$wpdb->postmeta} set meta_key = 'news_expiry_action' WHERE meta_key = 'expiry_action';");
        echo "<br>Upgraded " . $query . " news expiry actions";
        ob_flush();
        unset($query);
        $query = $wpdb->query("UPDATE {$wpdb->postmeta} set meta_key = 'news_expiry_date' WHERE meta_key = 'expiry_date';");
        echo "<br>Upgraded " . $query . " news expiry dates";
        ob_flush();
        unset($query);
        $query = $wpdb->query("update {$wpdb->postmeta} set meta_value = DATE_FORMAT(meta_value, '%Y%m%d') where  meta_key = 'news_expiry_date';");
        echo "<br>Formatted " . $query . " news expiry dates";
        ob_flush();
        unset($query);
        $query = $wpdb->query("UPDATE {$wpdb->postmeta} set meta_key = 'news_expiry_time' WHERE meta_key = 'expiry_time';");
        echo "<br>Upgraded " . $query . " news expiry times";
        ob_flush();
        unset($query);
        $query = $wpdb->get_results("select post_id from {$wpdb->postmeta} where {$wpdb->postmeta}.meta_key = 'news_listing_type' and {$wpdb->postmeta}.meta_value=1;");
        if ($query) {
            foreach ((array) $query as $q) {
                set_post_format($q->post_id, 'status');
            }
        }
        echo "<br>Upgraded " . count($query) . " need to know news records";
        ob_flush();
        unset($query);
        $newsquery = get_posts("post_type=news&posts_per_page=-1");
        if ($newsquery) {
            foreach ($newsquery as $n) {
                $newsterms = get_the_terms($n->ID, 'category');
                if (count($newsterms) > 0) {
                    foreach ($newsterms as $nt) {
                        if ($nt->slug == 'uncategorized') {
                            continue;
                        }
                        $term_title = $nt->slug;
                        $term_desc = $nt->description;
                        unset($new);
                        if ($term_title && strtolower($term_title) != 'uncategorized') {
                            $termslug = "news-" . $term_title;
                            $new = term_exists($termslug, 'news-type');
                        }
                        if (!is_array($new)) {
                            $new = wp_insert_term($nt->name, 'news-type', array('slug' => $termslug, 'description' => $description));
                            $newid = $new['term_id'];
                        } else {
                            $newid = $new['term_id'];
                        }
                        wp_set_object_terms($n->ID, $termslug, 'news-type', true);
                        wp_remove_object_terms($n->ID, $term_title, 'category');
                        sleep(0.1);
                    }
                }
            }
        }
        echo "<br>Upgraded " . count($newsquery) . " news story categories";
        echo "<br><br><strong>Upgrading events</strong> ";
        unset($query);
        $query = $wpdb->query("UPDATE {$wpdb->postmeta} set meta_key = 'event_gravityforms_id' WHERE meta_key = 'event_booking_form_id';");
        echo "<br>Upgraded " . $query . " booking form entries";
        ob_flush();
        unset($query);
        $query = $wpdb->get_results("select post_id from {$wpdb->postmeta} where {$wpdb->postmeta}.meta_key = 'event_start_date';");
        if ($query) {
            foreach ((array) $query as $q) {
                $eventdate = get_post_meta($q->post_id, 'event_start_date', true);
                add_post_meta($q->post_id, 'event_start_time', date('H:i', strtotime($eventdate)));
                delete_post_meta($q->post_id, 'event_start_date');
                add_post_meta($q->post_id, 'event_start_date', date('Ymd', strtotime($eventdate)));
            }
        }
        echo "<br>Upgraded " . count($query) . " event start dates and times";
        ob_flush();
        unset($query);
        $query = $wpdb->get_results("select post_id from {$wpdb->postmeta} where {$wpdb->postmeta}.meta_key = 'event_end_date';");
        if ($query) {
            foreach ((array) $query as $q) {
                $eventdate = get_post_meta($q->post_id, 'event_end_date', true);
                delete_post_meta($q->post_id, 'event_end_time');
                add_post_meta($q->post_id, 'event_end_time', date('H:i', strtotime($eventdate)));
                delete_post_meta($q->post_id, 'event_end_date');
                add_post_meta($q->post_id, 'event_end_date', date('Ymd', strtotime($eventdate)));
            }
        }
        echo "<br>Upgraded " . count($query) . " event end dates and times";
        ob_flush();
        echo "<br><br><strong>Upgrading projects</strong> ";
        unset($query);
        $query = $wpdb->query("UPDATE {$wpdb->posts}, {$wpdb->postmeta} SET post_parent = {$wpdb->postmeta}.meta_value WHERE {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id and {$wpdb->postmeta}.meta_key='parent_project' and {$wpdb->posts}.post_type = 'project';");
        echo "<br>Upgraded " . $query . " parent projects";
        ob_flush();
        unset($query);
        $query = $wpdb->get_results("select post_id, meta_value from {$wpdb->postmeta} where meta_key='_pods_children_pages';");
        if ($query) {
            foreach ((array) $query as $q) {
                $cs = get_post_meta($q->post_id, 'children_pages', false);
                //print_r($cs);
                $ordercount = 0;
                foreach ($cs as $key => $oldchapter) {
                    $o = $oldchapter['ID'];
                    $ordercount = $ordercount + 10;
                    $query2 = $wpdb->query("UPDATE {$wpdb->posts} SET menu_order = " . $ordercount . " WHERE {$wpdb->posts}.ID = " . $o . ";");
                }
            }
        }
        $query = $wpdb->query("UPDATE {$wpdb->postmeta} set meta_key = 'related' WHERE meta_key = 'related_projects';");
        echo "<br>Upgraded " . $query . " related project records";
        ob_flush();
        unset($query);
        $query = $wpdb->query("UPDATE {$wpdb->postmeta} set meta_key = 'project_policy_link' WHERE meta_key = 'policy_link';");
        echo "<br>Upgraded " . $query . " policy links";
        ob_flush();
        unset($query);
        $query = $wpdb->get_results("select post_id from {$wpdb->postmeta} where {$wpdb->postmeta}.meta_key = 'project_start_date';");
        if ($query) {
            foreach ((array) $query as $q) {
                $eventdate = get_post_meta($q->post_id, 'project_start_date', true);
                add_post_meta($q->post_id, 'project_start_time', date('H:i', strtotime($eventdate)));
                delete_post_meta($q->post_id, 'project_start_date');
                add_post_meta($q->post_id, 'project_start_date', date('Ymd', strtotime($eventdate)));
            }
        }
        echo "<br>Upgraded " . count($query) . " project start dates and times";
        ob_flush();
        unset($query);
        $query = $wpdb->get_results("select post_id from {$wpdb->postmeta} where {$wpdb->postmeta}.meta_key = 'project_end_date';");
        if ($query) {
            foreach ((array) $query as $q) {
                $eventdate = get_post_meta($q->post_id, 'project_end_date', true);
                delete_post_meta($q->post_id, 'project_end_time');
                add_post_meta($q->post_id, 'project_end_time', date('H:i', strtotime($eventdate)));
                delete_post_meta($q->post_id, 'project_end_date');
                add_post_meta($q->post_id, 'project_end_date', date('Ymd', strtotime($eventdate)));
            }
        }
        echo "<br>Upgraded " . count($query) . " project end dates and times";
        ob_flush();
        $allproject = get_posts(array('post_type' => 'projects', 'posts_per_page' => -1));
        if ($allproject) {
            foreach ($allproject as $a) {
                $my_post = array('ID' => $a->ID, 'post_content' => $a->post_content . get_post_meta($a->ID, 'team_members', true));
                wp_update_post($my_post);
            }
        }
        echo "<br>Moved " . count($allproject) . " project team entries to main content area";
        ob_flush();
        unset($query);
        $query = $wpdb->query("UPDATE {$wpdb->posts} set post_type = 'project' WHERE post_type = 'projects';");
        echo "<br>Upgraded " . $query . " project post types";
        ob_flush();
        echo "<br><br><strong>Upgrading vacancies</strong> ";
        unset($query);
        $query = $wpdb->get_results("select post_id from {$wpdb->postmeta} where {$wpdb->postmeta}.meta_key = 'closing_date';");
        if ($query) {
            foreach ((array) $query as $q) {
                $eventdate = get_post_meta($q->post_id, 'closing_date', true);
                delete_post_meta($q->post_id, 'closing_date');
                add_post_meta($q->post_id, 'vacancy_closing_date', date('Ymd', strtotime($eventdate)));
            }
        }
        echo "<br>Upgraded " . count($query) . " vacancy closing dates";
        $allproject = get_posts(array('post_type' => 'vacancy', 'posts_per_page' => -1));
        if ($allproject) {
            $relatedcount = 0;
            foreach ($allproject as $a) {
                $extras = '';
                if (get_post_meta($a->ID, 'background', true)) {
                    $extras .= "<h2>Background</h2>" . get_post_meta($a->ID, 'background', true);
                }
                if (get_post_meta($a->ID, 'job_specification', true)) {
                    $extras .= "<h2>Job specification</h2>" . get_post_meta($a->ID, 'job_specification', true);
                }
                if (get_post_meta($a->ID, 'requirements', true)) {
                    $extras .= "<h2>Requirements</h2>" . get_post_meta($a->ID, 'requirements', true);
                }
                if (get_post_meta($a->ID, 'how_to_apply', true)) {
                    $extras .= "<h2>How to apply</h2>" . get_post_meta($a->ID, 'how_to_apply', true);
                }
                $my_post = array('ID' => $a->ID, 'post_content' => $a->post_content . $extras);
                wp_update_post($my_post);
                if ($relatedproject = get_post_meta($a->ID, 'project', true)) {
                    add_post_meta($a->ID, 'related', $relatedproject);
                    $relatedcount++;
                }
            }
        }
        echo "<br>Moved " . count($allproject) . " vacancy details to main content area";
        echo "<br>Upgraded " . $relatedcount . " related projects";
        ob_flush();
        unset($query);
        $query = $wpdb->query("UPDATE {$wpdb->posts} set post_type = 'vacancy' WHERE post_type = 'vacancies';");
        echo "<br>Upgraded " . $query . " vacancy post types";
        echo "<br><br><strong>Upgrading taxonomies</strong> ";
        $terms = get_terms('category');
        if ($terms) {
            foreach ($terms as $taxonomy) {
                $themeid = $taxonomy->term_id;
                $thistheme = new pod('category', $themeid);
                $background = $thistheme->get_field('cat_background_colour');
                $foreground = $thistheme->get_field('cat_foreground_colour');
                $description = $thistheme->get_field('category_page_description');
                add_option('category_' . $themeid . '_cat_foreground_colour', $foreground, '', 'yes');
                add_option('category_' . $themeid . '_cat_background_colour', $background, '', 'yes');
                add_option('category_' . $themeid . '_cat_long_description', $description, '', 'yes');
            }
        }
        echo "<br>Upgraded " . count($terms) . " categories";
        ob_flush();
        $terms = get_terms('grade');
        if ($terms) {
            foreach ($terms as $taxonomy) {
                $themeid = $taxonomy->term_id;
                $thistheme = new pod('grade', $themeid);
                $code = $thistheme->get_field('grade_code');
                add_option('grade_' . $themeid . '_grade_code', $code, '', 'yes');
            }
        }
        echo "<br>Upgraded " . count($terms) . " grades";
        ob_flush();
        // get all terms for parent teams
        // create team post and save array with old term id and corresponding team post id
        $team_map = array();
        $terms = get_terms('team', array('parent' => 0, 'hide_empty' => false));
        if ($terms) {
            foreach ($terms as $taxonomy) {
                $themeid = $taxonomy->term_id;
                $thistheme = new pod('team', $themeid);
                $teamhead = $thistheme->get_field('team_head');
                // Create post object
                $my_post = array('post_title' => $taxonomy->name, 'post_content' => $taxonomy->description, 'post_status' => 'publish', 'post_type' => 'team', 'post_author' => 1);
                // Insert the post into the database
                $newteamid = wp_insert_post($my_post);
                if ($newteamid && $teamhead) {
                    add_post_meta($newteamid, 'team_head', $teamhead);
                }
                $team_map[$themeid] = $newteamid;
            }
        }
        // get all terms and skip  parents
        // lookup old parent id and get new parent id to save with new team post
        // create team post and save array with old term id an corresponding team post id
        $terms = get_terms('team', array('hide_empty' => false));
        if ($terms) {
            foreach ($terms as $taxonomy) {
                if ($taxonomy->parent == 0) {
                    continue;
                }
                $themeid = $taxonomy->term_id;
                $themeparentid = $taxonomy->parent;
                $thistheme = new pod('team', $themeid);
                $teamhead = $thistheme->get_field('team_head');
                // Create post object
                $my_post = array('post_title' => $taxonomy->name, 'post_content' => $taxonomy->description, 'post_status' => 'publish', 'post_type' => 'team', 'post_author' => 1, 'post_parent' => $team_map[$themeparentid]);
                // Insert the post into the database
                $newteamid = wp_insert_post($my_post);
                if ($newteamid && $teamhead) {
                    add_post_meta($newteamid, 'team_head', $teamhead);
                }
                $team_map[$themeid] = $newteamid;
            }
        }
        // get all terms
        // for each term, get list of users in the team
        // update user with user meta using new team post id
        if ($terms) {
            foreach ($terms as $taxonomy) {
                $themeid = $taxonomy->term_id;
                $q = "select distinct user_id from {$wpdb->usermeta} join wp_terms on {$wpdb->terms}.term_id = {$wpdb->usermeta}.meta_value where user_id in (select user_id from {$wpdb->usermeta} as a where a.meta_key = 'user_team' and a.meta_value = " . $themeid . " ) ;\n\t\t ";
                $user_query = $wpdb->get_results($q);
                foreach ($user_query as $u) {
                    //print_r($u);
                    $uq = "update {$wpdb->usermeta} set meta_value = " . $team_map[$themeid] . " where user_id = " . $u->user_id . " and meta_key='user_team' and meta_value = " . $themeid;
                    $wpdb->query($uq);
                }
            }
        }
        echo "<br>Upgraded " . count($terms) . " teams";
        ob_flush();
        //NEED TO CONVERT EXISTING TAXONOMY RELATIONSHIPS TO POST META XXXxxx
        unset($query);
        $query = $wpdb->query("UPDATE {$wpdb->term_taxonomy} set taxonomy = 'document-type' WHERE taxonomy = 'document_type';");
        echo "<br>Upgraded " . $query . " document types";
        ob_flush();
        unset($query);
        $query = $wpdb->query("UPDATE {$wpdb->term_taxonomy} set taxonomy = 'event-type' WHERE taxonomy = 'event_type';");
        echo "<br>Upgraded " . $query . " event types";
        ob_flush();
        unset($query);
        $query = $wpdb->query("UPDATE {$wpdb->term_taxonomy} set taxonomy = 'a-to-z' WHERE taxonomy = 'atoz';");
        echo "<br>Upgraded " . $query . " A to Z items";
        ob_flush();
        echo "<br><br><strong>Upgrading settings</strong> ";
        unset($query);
        $query = $wpdb->query("UPDATE {$wpdb->options} SET option_name = REPLACE(option_name, 'general_intranet', 'options');");
        echo "<br>Upgraded " . $query . " general intranet settings";
        ob_flush();
        $homepage = get_page_by_title('Home', OBJECT, 'page');
        if (!$homepage) {
            $homepage = get_page_by_title('Homepage', OBJECT, 'page');
        }
        if ($homepage->ID) {
            add_post_meta($homepage->ID, 'top_news_stories', get_option('homepage_control_top_news_story'));
            add_post_meta($homepage->ID, 'top_pages', get_option('homepage_control_top_pages'));
            add_post_meta($homepage->ID, 'emergency_message_style', get_option('homepage_control_emergency_message_style'));
            add_post_meta($homepage->ID, 'emergency_message', get_option('homepage_control_emergency_message'));
            add_post_meta($homepage->ID, 'campaign_message', get_option('homepage_control_campaign_message'));
            echo "<br>Upgraded homepage configuration";
        } else {
            echo "<br>Couldn't locate the homepage. You'll need to manually update your homepage settings.";
        }
        ob_flush();
        $headerbackgroundcolour = get_option('options_header_background');
        set_theme_mod('header_background', $headerbackgroundcolour);
        set_theme_mod('header_textcolor', '#ffffff');
        echo "<br>Upgraded colour configuration";
        $pageitem = get_page_by_title('how-do-i', OBJECT, 'page');
        if (!$pageitem) {
            $pageitem = get_page_by_title('How do I', OBJECT, 'page');
        }
        if (!$pageitem) {
            $pageitem = get_page_by_title('How to', OBJECT, 'page');
        }
        if ($pageitem->ID) {
            add_option('options_module_tasks', 1);
            add_option('options_module_tasks_page', $pageitem->ID);
            echo "<br>Setup the Tasks module";
        } else {
            echo "<br>Skipping Tasks module";
        }
        $pageitem = get_page_by_title('newspage', OBJECT, 'page');
        if (!$pageitem) {
            $pageitem = get_page_by_title('News', OBJECT, 'page');
        }
        if ($pageitem->ID) {
            add_option('options_module_news', 1);
            add_option('options_module_news_page', $pageitem->ID);
            echo "<br>Setup the News module";
        } else {
            echo "<br>Skipping News module";
        }
        $pageitem = get_page_by_title('blog', OBJECT, 'page');
        if (!$pageitem) {
            $pageitem = get_page_by_title('Blogs', OBJECT, 'page');
        }
        if ($pageitem->ID) {
            add_option('options_module_blog', 1);
            add_option('options_module_blog_page', $pageitem->ID);
            echo "<br>Setup the Blog module";
        } else {
            echo "<br>Skipping Blog module";
        }
        $pageitem = get_page_by_title('events', OBJECT, 'page');
        if (!$pageitem) {
            $pageitem = get_page_by_title('Events', OBJECT, 'page');
        }
        if ($pageitem->ID) {
            add_option('options_module_events', 1);
            add_option('options_module_event_page', $pageitem->ID);
            echo "<br>Setup the Events module";
        } else {
            echo "<br>Skipping Events module";
        }
        $pageitem = get_page_by_title('jargon-buster', OBJECT, 'page');
        if (!$pageitem) {
            $pageitem = get_page_by_title('Jargon buster', OBJECT, 'page');
        }
        if ($pageitem->ID) {
            add_option('options_module_jargon_buster', 1);
            echo "<br>Setup the Jargon Buster module";
        } else {
            echo "<br>Skipping Jargon Buster module";
        }
        $pageitem = get_page_by_title('projects', OBJECT, 'page');
        if (!$pageitem) {
            $pageitem = get_page_by_title('Projects', OBJECT, 'page');
        }
        if ($pageitem->ID) {
            add_option('options_module_projects', 1);
            add_option('options_module_project_page', $pageitem->ID);
            echo "<br>Setup the Projects module";
        } else {
            echo "<br>Skipping Projects module";
        }
        $pageitem = get_page_by_title('vacancies', OBJECT, 'page');
        if (!$pageitem) {
            $pageitem = get_page_by_title('Vacancies', OBJECT, 'page');
        }
        if ($pageitem->ID) {
            add_option('options_module_vacancies', 1);
            add_option('options_module_vacancies_page', $pageitem->ID);
            echo "<br>Setup the Vacancies module";
        } else {
            echo "<br>Skipping Vacancies module";
        }
        $pageitem = get_posts('post_type=team&posts_per_page=-1');
        if (count($pageitem) > 1) {
            add_option('options_module_teams', 1);
            echo "<br>Setup the Teams module";
        }
        if (get_option('options_forum_support')) {
            $pageitem = get_page_by_title('staff-directory', OBJECT, 'page');
            if (!$pageitem) {
                $pageitem = get_page_by_title('Staff directory', OBJECT, 'page');
            }
            if ($pageitem->ID) {
                add_option('options_module_staff_directory', 1);
                add_option('options_module_staff_directory_page', $pageitem->ID);
                echo "<br>Setup the Staff directory module";
            } else {
                echo "<br>Skipping Staff directory module";
            }
        }
        unset($query);
        $query = $wpdb->get_results("select post_id, count(meta_value) from {$wpdb->postmeta} where {$wpdb->postmeta}.meta_key = 'related' group by post_id;");
        if ($query) {
            foreach ((array) $query as $q) {
                $query2 = $wpdb->get_results("select meta_value from {$wpdb->postmeta} where {$wpdb->postmeta}.meta_key = 'related' and post_id =" . $q->post_id);
                $relarray = array();
                foreach ((array) $query2 as $q2) {
                    $relarray[] = $q2->meta_value;
                }
                $query3 = $wpdb->get_results("delete from {$wpdb->postmeta} where {$wpdb->postmeta}.meta_key = 'related' and post_id =" . $q->post_id);
                add_post_meta($q->post_id, 'related', $relarray);
            }
        }
        ob_flush();
        echo "<br><br><strong>Cleaning database</strong> ";
        global $wpdb;
        $query = $wpdb->query("DELETE from {$wpdb->postmeta} WHERE {$wpdb->postmeta}.meta_key='_parent_guide';");
        $query = $wpdb->query("DELETE from {$wpdb->postmeta} WHERE {$wpdb->postmeta}.meta_key='parent_guide';");
        $query = $wpdb->query("DELETE from {$wpdb->postmeta} WHERE {$wpdb->postmeta}.meta_key='children_chapters';");
        $query = $wpdb->query("DELETE from {$wpdb->postmeta} WHERE {$wpdb->postmeta}.meta_key='page_type';");
        $query = $wpdb->query("DELETE from {$wpdb->postmeta} WHERE {$wpdb->postmeta}.meta_key='video_still';");
        $query = $wpdb->query("DELETE from {$wpdb->postmeta} WHERE {$wpdb->postmeta}.meta_key='news_listing_type';");
        $query = $wpdb->query("DELETE from {$wpdb->postmeta} WHERE {$wpdb->postmeta}.meta_key='parent_project';");
        $query = $wpdb->query("DELETE from {$wpdb->postmeta} WHERE {$wpdb->postmeta}.meta_key='children_pages';");
        $query = $wpdb->query("DELETE from {$wpdb->postmeta} WHERE {$wpdb->postmeta}.meta_key='project';");
        $query = $wpdb->query("DELETE from {$wpdb->postmeta} WHERE {$wpdb->postmeta}.meta_key='related' AND {$wpdb->postmeta}.meta_value='';");
        echo "<h1>Finished</h1>";
        echo "<h3>Almost there! Before you activate the new theme:</h3>";
        echo "<p>Print this page as a record.</p>";
        echo "<p>Go to Pods Admin, Settings, Cleanup and reset tab. Choose to Deactivate and Delete Pods data.</p>";
        echo "<p>When done, activate the Advanced Custom Fields plugin.</p>";
        echo "<p>Deactivate this upgrade widget.</p>";
        echo "<p>Install and activate new HT plugins.</p>";
        echo "<p>Activate version 4 of the GovIntranet theme.</p>";
        echo "<p>Check Appearance, Menus, Manage locations and set primary navigation</p>";
        echo "<p>Check Appearance, Widgets, and shift down where necessary.</p>";
        echo "<p>Add Google account details to Most active widget were necessary.</p>";
        echo "<p>Check Appearance, Customise, and set header colours.</p>";
        echo "<p>Check Options, Modules, and setup your content modules.</p>";
        echo "<p>Regenerate your image thumbnails.</p>";
        echo "<p>Flush permalinks.</p>";
        ob_end_flush();
    } else {
        if (function_exists('pods')) {
            echo "\n\t\t<p></p> \n\t\t <form method='post'>\n\t\t \t<p>This action will upgrade your database to GovIntranet 4.</p>\n\t\t \t<p>Backup your complete database before using.</p>\n\t\t \t<p>Keep a note of your Google Analytics settings.</p>\n\t\t \t<p>Keep a note of your header colour settings.</p>\n\t\t\t<p><input type='submit' value='Upgrade now' class='button-primary' /></p>\n\t\t\t<input type='hidden' name='page' value='g4up' />\n\t\t\t<input type='hidden' name='action' value='processimport' />\n\t\t  </form><br />\n\t\t";
        } else {
            echo "\n\t\t<p></p> \n\t\t<p>You must activate the Advanced Custom Fields Pro plugin.</p> \n\t\t";
        }
    }
    echo "</div>";
    ob_end_flush();
}