WP Multi-Network Plugin Fix for WordPress

I love small powerful WordPress Plugins. The kind that get the job done with a small amount of code. One of the things that actually convinced me to install WordPress was a little plugin called WP Multi-Network. Currently we are running about three dozen blogs (including this one) across almost as many networks! WordPress and the WP Multi-Network plugin has done a beautiful job, until this morning!

I woke up this morning ready to add a new blog on a new domain we just acquired, phlife.org. pH Life will be a blog about the eating part of the New LipHe Lifestyle (say that “New Life Lifestyle”). Besides the normal meaning of pH, the balance between Acidity and Basicity, we are considering that pH Life can also mean Philippine Life or Potentially Healthy Life! So I was looking forward to adding this site when all of a sudden, I could not find the WP Multi-Network plugin menu.

“What’cha gonna do when they come for you, Bad Bugs, Bad Bugs!”

Back in WP3.0.x everything was working fine… I did the update to WP3.1.1 and even checked to verify I could view and log into all sites – it was all working good! However, I did not check the Super-Admin menu… I had not need to do that since all the sites were running just fine…

A quick check to the WordPress.org plugin site showed no updates. In fact a post on the forum showed me someone else was also having problems. The vote for the version 1.1 plugin and the current WP3.2.1 showed just one vote, for broken! So, I decided to hack the plugin code and see what I could find.

Scroll to the bottom to get the complete replacement file!

It did not take me too long to realize that with WP3.1 there was a switch from multi-site files having an “ms-” to the multi-site files having their own folder… /wp-admin/network/ A few hours later I had tweaked the plugin enough to get something working. But it was not quite as sleek as what I had before.

Then I had one of those “Duh” moments when I decided to check the WP Repository! Sure enough Brian Layman over at http://WebDevStudios.com and The Code Cave had been working on Version: 1.2. In fact it was farther along than my hack… So I decided to give it a run. First of all, I would like to heap A TON OF PRAISE ON BRIAN! He has really improved this little plugin… Anything I say from this point on, even if sounds a little critical, is only to ad minor improvements to the fantastic and huge improvements he has made!

The Beauty and The Beast!

In our case that would be AKA: The Logical, and those Bad Bugs!

“What’cha gonna do when they come for you, Bad Bugs, Bad Bugs!”

The Beauty

Since “Code is Poetry”, “Beauty is Functionality!”

One of the things I enjoy about WordPress is the logic behind it. It is of course, beautiful. However, behind that beauty is the logic of the code, the functionality. The beauty of the logic. For example…

Have you ever noticed that when you load a plugin, right at the top of each page generated by that plugin is usually the name of the plugin… Most of the time, but not this time. This time, it just says Networks. Likewise when you open the links to those pages, again the plugin name is there for you to see, as well as in the title at the top of your screen. It is only logical… but not here…

Although these are “cosmetic” in nature, these still guide us to get to where we want to go. I mean we could name them pizza and apple, but what good would that do. On the other hand, naming the link and title “WP Multi-Network” would give a reasonable expectation that that is where we were going and what we were going to do. Much more than just “Networks” which may actually be better associated with a half dozen other plugins!

Suggestion One:

Change all human readable links, titles and headings to
“WP Multi-Network”

Furthermore there is a logic to where the links are placed, they are grouped together. For example pick one of these choices to place WP Multi-Networking… Keep in mind that this is an extension to the WordPress Multi-Site Function.

1. ms-admin (as in “multi-site admin”)
2. options-general (as in the “general-options” that are stored in the database, per site)
3. tools (“tools” as in automatic updates from the WordPress download site)

So what is your choice, 1) ms-admin, 2) options-general, or 3) tools? Actually when asked this way, the logical way, it is really a no brainier. The answer, ms-admin, or multi-site admin is the easy or best choice of the three to put WP Multi-Network. Right? Beauty is logical!

Suggestion Two

Use any WordPress area associated with ms-admin!

It may surprise you to know that I did not just make these three up. They are already a part of WordPress!

The icon next to the menu called Updates is named… icon-tools.

The icon nest to the menu called Settings is named… icon-options-general.

The icon next to the menu called Sites is named… icon-ms-admin.

It is also interesting to note that the WP Network Plugin starts with the words…

“A site will be created…” As well as the fact that the only page the WP Multi-Network links into is the Multi-Site “Sites” page and that links back to to the WP Network Plugin in the “Move” link.

I think it is pretty clear that WP Multi-Network belongs on the Sites menu.

So here is what is needed to do that…

Replace Line 508:

                $result = esc_url(network_admin_url('settings.php?page=networks'));
//...

With:

                $result = esc_url(network_admin_url('sites.php?page=networks'));
//...

Replace Line 525:

            add_submenu_page('settings.php', __( 'Networks' ), __( 'Networks' ), 'manage_options', 'networks', array( &$this, 'networks_page' ));
//...

With:

            add_submenu_page('sites.php', __( 'WP Multi-Network' ), __( 'WP Multi-Network' ), 'manage_options', 'networks', array( &$this, 'networks_page' ));
//...

Replace Lines 671-672:

<div id="icon-tools" class="icon32"></div>
<h2><?php _e( 'Networks' ) ?></h2>
//...

With:

<div id="icon-ms-admin" class="icon32"></div>
<h2><?php _e( 'WP Multi-Network' ) ?></h2>
//...

Replace Lines 934-935:

            <div id="icon-tools" class="icon32"></div>
            <h2><?php _e( 'Networks' ) ?></h2>
//...

With:

            <div id="icon-ms-admin" class="icon32"></div>
            <h2><?php _e( 'WP Multi-Network' ) ?></h2>
//...

Replace Lines 1042-1043:

            <div id="icon-tools" class="icon32"></div>
            <h2><?php _e( 'Networks' ) ?></h2>
//...

With:

            <div id="icon-ms-admin" class="icon32"></div>
            <h2><?php _e( 'WP Multi-Network' ) ?></h2>
//...

Replace Lines 1246-1247:

            <div id="icon-tools" class="icon32"></div>
            <h2><?php _e( 'Networks' ) ?></h2>
//...

With:

            <div id="icon-ms-admin" class="icon32"></div>
            <h2><?php _e( 'WP Multi-Network' ) ?></h2>
//...

Replace Lines 1307-1308:

                    <div id="icon-tools" class="icon32"></div>
                    <h2><?php _e( 'Networks' ) ?></h2>
//...

With:

                    <div id="icon-ms-admin" class="icon32"></div>
                    <h2><?php _e( 'WP Multi-Network' ) ?></h2>
//...

Replace Lines 1379-1380:

            <div id="icon-tools" class="icon32"></div>
            <h2><?php _e( 'Networks' ) ?></h2>
//...

With:

            <div id="icon-ms-admin" class="icon32"></div>
            <h2><?php _e( 'WP Multi-Network' ) ?></h2>
//...

The Beast

If debugging is the process of removing bugs…
then programming must be the process of putting them in.
— Dykstra’s Observation

The Beast, of course, is those little slips or programming errors. In this case, due to the change of file names from:

wp-admin/ms-sites.php

To:

wp-admin/network/sites.php

“What’cha gonna do when they come for you, Bad Bugs, Bad Bugs!”

So I guess it is time to fix the bad bugs, bad bugs…

Replace Line 792:

                            <td valign='top'><a href="http://<?php echo $site['domain'] . $site['blog_path'];?>wp-admin/ms-sites.php" title="<?php _e('Sites on this network'); ?>"><?php echo $site['blogs'] ?></a></td>
//...

With:

                            <td valign='top'><a href="http://<?php echo $site['domain'] . $site['blog_path'];?>wp-admin/network/sites.php" title="<?php _e('Sites on this network'); ?>"><?php echo $site['blogs'] ?></a></td>
//...

Replace Line 976:

                    <a class="button" href="./ms-sites.php"><?php _e('Cancel'); ?></a>
//...

With:

                    <a class="button" href="./sites.php"><?php _e('Cancel'); ?></a>
//...

Bug: An elusive creature living in a program that makes it incorrect.
The activity of “debugging,” or removing bugs from a program,
ends when people get tired of doing it,
not when the bugs are removed.

wp-multi-network.php

Again, many thanks to Brian Layman, he did a great job!

Rather than making you do each of these changes character by character, here is the complete wp-multi-network.php file ready for you to plug into your plugins/wp-multi-network folder!

I have also made a couple hundred stylized changes to comply more with the WordPress style guide. Just copy this, paste it in a file called wp-multi-network.php and overwrite the file with the same name in your plugins/wp-multi-network folder!

wp-multi-network.php

<?php
/**
Plugin Name: WP Multi-Network
Plugin URI: http://wordpress.org/extend/plugins/wp-multi-network/
Description: Adds a Multi-Network Management User Interface for super admins in a WordPress Multisite environment
Version: 1.2
Author: Brian Layman
Author URI: http://WebDevStudios.com
Tags: multi, networks, site, network, blog, domain, subdomain, path, multisite, MS

*/

/* ========================================================================== */

/*
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.

 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */

 /* Plugin originally created by David Dean,
    Refreshed by John James Jacoby for WP3.0,
    Refreshed by Brian Layman for WP3.1+ 
    See readme.txt for */
 
 
 /* true = enable the holding network, must be true to save orphaned blogs, below */
if ( !defined( 'ENABLE_NETWORK_ZERO' ) )
    define( 'ENABLE_NETWORK_ZERO', true );

/***
 * true = redirect blogs from deleted network to holding network, instead of deleting them.
 * Requires network zero above.
 * false = allow blogs belonging to deleted networks to be deleted.
 */
if ( !defined( 'RESCUE_ORPHANED_BLOGS' ) )
    define( 'RESCUE_ORPHANED_BLOGS', false );

/* blog options affected by URL */
$options_list = array( 'siteurl', 'home', 'fileupload_url' );

/* sitemeta options to be copied on clone */
$options_to_copy = array(
    'admin_email'            => __( 'Network admin email' ),
    'admin_user_id'          => __( 'Admin user ID - deprecated' ),
    'allowed_themes'         => __( 'OLD List of allowed themes - deprecated' ),
    'allowedthemes'          => __( 'List of allowed themes' ),
    'banned_email_domains'   => __( 'Banned email domains' ),
    'first_post'             => __( 'Content of first post on a new blog' ),
    'limited_email_domains'  => __( 'Permitted email domains' ),
    'site_admins'            => __( 'List of network admin usernames' ),
    'welcome_email'          => __( 'Content of welcome email' )
);

define( 'NETWORKS_PER_PAGE', 10 );

/**
 * Check to see if new WPDB functions (insert, update, prepare) are available and cache the result
 * @return boolean Result of check for these functions
 */
if ( !function_exists( 'wpmn_are_new_wpdb_funcs_available' ) ) {
    function wpmn_are_new_wpdb_funcs_available() {
        static $available = 'unchecked';

        if ( is_bool( $available ) )
            return $available;

        global $wpdb;

        $available = method_exists( $wpdb, 'insert' );

        return $available;
    }
}

/**
 * Check to see if a network exists. Will check the networks object before checking the database.
 * @param integer $site_id ID of network to verify
 * @return boolean true if found, false otherwise
 */
if ( !function_exists( 'wpmn_network_exists' ) ) {
    function wpmn_network_exists( $site_id ) {
        global $sites, $wpdb;
        $site_id = (int)$site_id;

        $sites = (array)$sites;
        foreach ( $sites as $network ) {
            if ( $site_id == $network->id )
                return true;
        }

        /* check db just to be sure */
        $network_list = $wpdb->get_results( $wpdb->prepare('SELECT id FROM ' . $wpdb->site ));
        if ( $network_list ) {
            foreach( $network_list as $network ) {
                if ( $network->id == $site_id )
                    return true;
            }
        }

        return false;
    }
}

/**
 * Problem: the various *_site_options() functions operate only on the current network
 * Workaround: change the current network
 * @param integer $new_network ID of network to manipulate
 */
if ( !function_exists( 'wpmn_switch_to_network' ) ) {
    function wpmn_switch_to_network( $new_network ) {
        global $old_network_details, $wpdb, $site_id, $switched_network, $switched_network_stack, $current_site, $sites;

        if ( !wpmn_network_exists( $new_network ) )
            $new_network = $site_id;

        if ( empty( $switched_network_stack ) )
            $switched_network_stack = array();

        $switched_network_stack[] = $site_id;

        if ( $new_network == $site_id )
            return;

        // backup
        $old_network_details['site_id'] = $site_id;
        $old_network_details['id'] = $current_site->id;
        $old_network_details['domain'] = $current_site->domain;
        $old_network_details['path'] = $current_site->path;
        $old_network_details['site_name'] = $current_site->site_name;

        foreach ( $sites as $network ) {
            if ( $network->id == $new_network ) {
                $current_site = $network;
                break;
            }
        }

        $wpdb->siteid = $new_network;
        $current_site->site_name = get_site_option('site_name' );
        $site_id = $new_network;

        do_action( 'switch_network', $site_id, $old_network_details[ 'site_id' ] );
        $switched_network = true;
    }
}

/**
 * Return to the operational network after our operations
 */
if ( !function_exists( 'wpmn_restore_current_network' ) ) {
    function wpmn_restore_current_network() {
        global $old_network_details, $wpdb, $site_id, $switched_network, 
                $switched_network_stack, $current_site;

        if ( !$switched_network )
            return;

        $site_id = array_pop( $switched_network_stack );

        if ( $site_id == $current_site->id )
            return;

        $prev_site_id = $wpdb->siteid;

        $wpdb->siteid = $site_id;
        $current_site->id = $old_network_details[ 'id' ];
        $current_site->domain = $old_network_details[ 'domain' ];
        $current_site->path = $old_network_details[ 'path' ];
        $current_site->site_name = $old_network_details[ 'site_name' ];

        unset( $old_network_details );

        do_action( 'switch_network', $site_id, $prev_site_id );
        $switched_network = false;
    }
}

/**
 * Add a new network
 * @param string $domain domain name for new network - for VHOST=no, this should be FQDN, otherwise domain only
 * @param string $path path to root of network hierarchy - should be '/' unless WP is cohabiting with another product on a domain
 * @param string $site_name Name of the root blog to be created on the new network
 * @param integer $clone_network ID of network whose networkmeta values are to be copied - default NULL
 * @param array $options_to_clone override default networkmeta options to copy when cloning - default NULL
 * @return integer ID of newly created network
 */
if ( !function_exists( 'wpmn_add_network' ) ) {
    function wpmn_add_network( $domain, $path, $site_name = NULL, $clone_network = NULL, $options_to_clone = NULL ) {

        if ( $site_name == NULL )
            $site_name = __( 'New Network Created' );

        global $wpdb, $sites, $options_to_copy;

        if ( is_null( $options_to_clone ) )
            $options_to_clone = array_keys( $options_to_copy );

        $query = "SELECT * FROM {$wpdb->site} WHERE domain='" . $wpdb->escape( $domain ) . "' AND path='" . $wpdb->escape( $path ) . "' LIMIT 1";
        $network = $wpdb->get_row( $wpdb->prepare( $query ) );

        if ( $network )
            return new WP_Error( 'wpmn_network_exists', __( 'Network already exists.' ) );


        if ( wpmn_are_new_wpdb_funcs_available() ) {
            $wpdb->insert( $wpdb->site, array(
                'domain'  => $domain,
                'path'    => $path
            ));
            $new_network_id =  $wpdb->insert_id;
        } else {
            $query = "INSERT INTO {$wpdb->site} (domain, path) VALUES ('" . $wpdb->escape( $domain ) . "','" . $wpdb->escape( $path ) . "')";
            $wpdb->query( $wpdb->prepare( $query ) );
            $new_network_id =  $wpdb->insert_id;
        }

        /* update network list */
        $sites = $wpdb->get_results( $wpdb->prepare( 'SELECT * FROM ' . $wpdb->site ) );

        if ( $new_network_id ) {

            if ( !defined( 'WP_INSTALLING' ) )
                define( 'WP_INSTALLING', true );

            $new_blog_id = wpmu_create_blog( $domain,$path, $site_name, get_current_user_id(), '', (int)$new_network_id );

            if ( is_a( $new_blog_id, 'WP_Error' ) )
                return $new_blog_id;
        }

        /** if selected, clone the networkmeta from an existing network */

        if ( !is_null( $clone_network ) && wpmn_network_exists( $clone_network ) ) {

            $options_cache = array();

            wpmn_switch_to_network( (int)$clone_network );

            foreach ( $options_to_clone as $option ) {
                $options_cache[$option] = get_site_option( $option );
            }

            wpmn_restore_current_network();

            wpmn_switch_to_network( $new_network_id );

            foreach ( $options_to_clone as $option ) {
                if ( $options_cache[$option] !== false ) {
                    add_site_option( $option, $options_cache[$option] );
                }
            }
            unset( $options_cache );

            wpmn_restore_current_network();
        }

        do_action( 'wpmn_add_network' , $new_network_id );
        return $new_network_id;
    }
}

/**
 * Modify the domain and path of an existing network - and update all of its blogs
 * @param integer id ID of network to modify
 * @param string $domain new domain for network
 * @param string $path new path for network
 */
if ( !function_exists( 'wpmn_update_network' ) ) {
    function wpmn_update_network( $id, $domain, $path = '' ) {
        global $wpdb, $options_list;

        if ( !wpmn_network_exists( (int)$id ) )
            return new WP_Error( 'network_not_exist', __( 'Network does not exist.' ) );

        $query = "SELECT * FROM {$wpdb->site} WHERE id=" . (int)$id;
        $network = $wpdb->get_row( $wpdb->prepare( $query ) );
        if ( !$network )
            return new WP_Error('network_not_exist',__( 'Network does not exist.' ));

        if ( wpmn_are_new_wpdb_funcs_available() ) {

            $update = array('domain'  => $domain);
            if ( $path != '' )
                $update['path'] = $path;

            $where = array('id'  => (int)$id);
            $update_result = $wpdb->update( $wpdb->site, $update, $where );
        } else {
            $domain = $wpdb->escape($domain);
            $path   = $wpdb->escape($path);

            $query = "UPDATE {$wpdb->site} SET domain='" . $domain . "' ";

            if ( $path != '' )
                $query .= ", path='" . $path . "' ";

            $query .= ' WHERE id=' . (int)$id;
            $update_result = $wpdb->query( $wpdb->prepare( $query ) );
        }

        if ( !$update_result )
            return new WP_Error( 'network_not_updated', __( 'Network could not be updated.' ) );

        $path = (($path != '') ? $path : $network->path );
        $full_path = $domain . $path;
        $old_path = $network->domain . $network->path;

        /** also updated any associated blogs */
        $query = "SELECT * FROM {$wpdb->blogs} WHERE site_id=" . (int)$id;
        $sites = $wpdb->get_results( $wpdb->prepare( $query ) );

        if ( $sites ) {
            foreach( $sites as $site ) {
                $domain = str_replace( $network->domain, $domain, $site->domain );
                if( wpmn_are_new_wpdb_funcs_available() ) {
                    $wpdb->update(
                        $wpdb->blogs,
                        array(
                            'domain'   => $domain,
                            'path'     => $path
                        ),
                        array(
                            'blog_id'  => (int)$site->blog_id
                        )
                    );
                } else {
                    $query = "UPDATE {$wpdb->blogs} SET domain='" . $domain . "', path='" . $path . "' WHERE blog_id=" . (int)$site->blog_id;
                    $wpdb->query( $wpdb->prepare( $query ) );
                }

                /** fix options table values */
                $optionTable = $wpdb->get_blog_prefix( $site->blog_id ) . "options";

                foreach ( $options_list as $option_name ) {
                    $option_value = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $optionTable WHERE option_name='$option_name'" ) );
                    if ( $option_value ) {
                        $new_value = str_replace( $old_path, $full_path, $option_value->option_value );
                        update_blog_option( $site->blog_id, $option_name, $new_value );
                    }
                }
            }
        }
        do_action( 'wpmn_update_network' , $id, array( 'domain'=>$network->domain, 'path'=>$network->path ) );
    }
}

/**
 * Delete a network and all its blogs
 * @param integer id ID of network to delete
 * @param boolean $delete_blogs flag to permit blog deletion - default setting of false will prevent deletion of occupied networks
 */
if ( !function_exists( 'wpmn_delete_network' ) ) {
    function wpmn_delete_network( $id, $delete_blogs = false ) {
        global $wpdb;

        $override = $delete_blogs;

        /* ensure we got a valid network id */
        $query = "SELECT * FROM {$wpdb->site} WHERE id=" . (int)$id;
        $network = $wpdb->get_row( $wpdb->prepare( $query ) );

        if ( !$network )
            return new WP_Error( 'network_not_exist', __( 'Network does not exist.' ) );

        /* ensure there are no blogs attached to this network */
        $query = "SELECT * FROM {$wpdb->blogs} WHERE site_id=" . (int)$id;
        $sites = $wpdb->get_results( $wpdb->prepare( $query ) );

        if ( $sites && !$override )
            return new WP_Error( 'network_not_empty', __( 'Cannot delete network with sites.' ) );

        if ( $override && $sites ) {
            foreach( $sites as $site ) {
                if ( RESCUE_ORPHANED_BLOGS && ENABLE_NETWORK_ZERO )
                    wpmn_move_site( $site->blog_id, 0 );
                else
                    wpmu_delete_blog( $site->blog_id, true );
            }
        }

        $query = "DELETE FROM {$wpdb->site} WHERE id=" . (int)$id;
        $wpdb->query( $wpdb->prepare( $query ) );

        $query = "DELETE FROM {$wpdb->sitemeta} WHERE site_id=" . (int)$id;
        $wpdb->query( $wpdb->prepare( $query ) );

        do_action( 'wpmn_delete_network' , $network );
    }
}

/**
 * Move a blog from one network to another
 * @param integer $site_id ID of blog to move
 * @param integer $new_network_id ID of destination network
 */
if ( !function_exists( 'wpmn_move_site' ) ) {
    function wpmn_move_site( $site_id, $new_network_id ) {
        global $wpdb, $options_list;

        /* sanity checks */
        $query = "SELECT * FROM {$wpdb->blogs} WHERE blog_id=" . (int)$site_id;
        $site = $wpdb->get_row( $wpdb->prepare( $query ) );

        if ( !$site )
            return new WP_Error( 'blog not exist', __( 'Site does not exist.' ) );

        if ( (int)$new_network_id == $site->site_id )
            return true;

        $old_network_id = $site->site_id;

        if ( ENABLE_NETWORK_ZERO && $site->site_id == 0 ) {
            $old_network->domain = 'holding.blogs.local';
            $old_network->path = '/';
            $old_network->id = 0;
        } else {
            $query = "SELECT * FROM {$wpdb->site} WHERE id=" . (int)$site->site_id;
            $old_network = $wpdb->get_row( $wpdb->prepare( $query ) );
            if ( !$old_network )
                return new WP_Error( 'network_not_exist', __( 'Network does not exist.' ) );
        }

        if ( $new_network_id == 0 && ENABLE_NETWORK_ZERO ) {
            $new_network->domain = 'holding.blogs.local';
            $new_network->path = '/';
            $new_network->id = 0;
        } else {
            $query = "SELECT * FROM {$wpdb->site} WHERE id=" . (int)$new_network_id;
            $new_network = $wpdb->get_row( $wpdb->prepare( $query ) );

            if ( !$new_network )
                return new WP_Error( 'network_not_exist', __( 'Network does not exist.' ) );

        }

        if ( defined('VHOST') && VHOST == 'yes' ) {
            $ex_dom = substr( $site->domain, 0, ( strpos( $site->domain, '.' ) + 1 ) );
            $domain = $ex_dom . $new_network->domain;
        } else {
            $domain = $new_network->domain;
        }
        $path = $new_network->path . substr( $site->path, strlen( $old_network->path ) );

        if ( wpmn_are_new_wpdb_funcs_available() ) {
            $update_result = $wpdb->update(
                $wpdb->blogs,
                array(    'site_id'  => $new_network->id,
                        'domain'     => $domain,
                        'path'       => $path
                ),
                array(    'blog_id'  => $site->blog_id )
            );
        } else {

            $update_result = $query = "UPDATE {$wpdb->blogs} SET site_id=" . $new_network->id . ", domain='" . $domain . "', path='" . $path . "' WHERE blog_id=" . $site->blog_id;
            $wpdb->query( $query );

        }

        if ( !$update_result )
            return new WP_Error( 'blog_not_moved', __( 'Site could not be moved.' ) );


        /** change relevant blog options */
        $options_table = $wpdb->get_blog_prefix( $site->blog_id ) . "options";

        $old_domain = $old_network->domain . $old_network->path;
        $new_domain = $new_network->domain . $new_network->path;

        foreach($options_list as $option_name) {
            $option = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $options_table WHERE option_name='" . $option_name . "'" ) );
            $new_value = str_replace( $old_domain, $new_domain, $option->option_value );
            update_blog_option( $site->blog_id, $option_name, $new_value );
        }

        do_action( 'wpmn_move_blog', $site_id, $old_network_id, $new_network_id );
    }
}

if ( !class_exists( 'MS_Networks' ) ) :
    class MS_Networks {

        function MS_Networks()    {
            if ( function_exists( 'add_action' ) ) {
                add_action( 'init', array( &$this, 'wpmn_admin_url' ) );
                add_action( 'admin_menu', array( &$this, 'wpmn_admin_menu' ) );
                add_action( 'network_admin_menu', array( &$this, 'wpmn_network_admin_menu' ) );
                add_action( 'wpmublogsaction', array( &$this, 'assign_blogs_link' ) );
            }
        }

        function wpmn_admin_url() {
            global $wp_version;
            if ( version_compare( $wp_version, '3.0.9', '<=' ) ) {
                $result = esc_url(network_admin_url('options-general.php?page=networks' ));
            } else {
                $result = esc_url(network_admin_url('sites.php?page=networks' ));
            }
            return $result;
        }

        function assign_blogs_link($cur_blog_id) {
            echo '<a href="' . $this->wpmn_admin_url() . '&action=move&blog_id=' . (int) $cur_blog_id . '" class="edit">' . __( 'Move' ) . '</a>';
        }

        function wpmn_admin_menu() {
            global $wp_version;
            if ( version_compare( $wp_version, '3.0.9', '<=' ) ) {
                add_options_page(__( 'Networks' ), __( 'Networks' ), 'manage_options', 'networks', array( &$this, 'networks_page' ));
            }
        }
        
        function wpmn_network_admin_menu() {
            add_submenu_page('sites.php', __( 'WP Multi-Network' ), __( 'WP Multi-Network' ), 'manage_options', 'networks', array( &$this, 'networks_page' ));
        }

        /* Config Page*/
        function networks_page() {
            global $wpdb,  $options_to_copy;

            if ( !function_exists( 'is_super_admin' ) || !is_super_admin() )
                wp_die( __( '<p>You do not have permission to access this page.</p>' ) );

            if ( isset( $_POST['update'] ) && isset( $_GET['id'] ) )
                $this->wpmn_update_network_page();

            if ( isset( $_POST['delete'] ) && isset( $_GET['id'] ) )
                $this->wpmn_delete_network_page();

            if ( isset( $_POST['delete_multiple'] ) && isset( $_POST['deleted_networks'] ) )
                $this->wpmn_delete_multiple_network_page();

            if ( isset( $_POST['add'] ) && isset( $_POST['domain'] ) && isset( $_POST['path'] ) )
                $this->wpmn_add_network_page();

            if ( isset( $_POST['move'] ) && isset( $_GET['blog_id'] ) )
                $this->wpmn_move_site_page();

            if ( isset( $_POST['reassign'] ) && isset( $_GET['id'] ) )
                $this->wpmn_reassign_site_page();

            if ( isset( $_GET['updated'] ) ) :
                ?><div id="message" class="updated fade"><p><?php _e( 'Options saved.' ) ?></p></div><?php
            elseif ( isset($_GET['added'] ) ) :
                ?><div id="message" class="updated fade"><p><?php _e( 'Network created.' ); ?></p></div><?php
            elseif( isset( $_GET['deleted'] ) ) :
                ?><div id="message" class="updated fade"><p><?php _e( 'Network(s) deleted.' ); ?></p></div><?php
            endif;

            print '<div class="wrap" style="position: relative">';

            if ( isset( $_GET[ 'action' ] )) {
                $action = $_GET[ 'action' ];
            } else {
                $action = '';
            }

            switch( $action ) {
                case 'move':
                    $this->wpmn_move_site_page();
                    break;
                case 'assignblogs':
                    $this->wpmn_reassign_site_page();
                    break;
                case 'deletenetwork':
                    $this->wpmn_delete_network_page();
                    break;
                case 'editnetwork':
                    $this->wpmn_update_network_page();
                    break;
                case 'delete_multinetworks':
                    $this->wpmn_delete_multiple_network_page();
                    break;
                default:
                    /* Strip off the action tag */
                    $query_str = substr( $_SERVER['REQUEST_URI'], 0, ( strpos( $_SERVER['REQUEST_URI'], '?' ) + 1 ) );
                    $get_params = array();
                    $bad_params = array( 'action', 'id', 'updated', 'deleted' );
                    foreach ( $_GET as $get_param => $get_value ) {
                        if ( !in_array( $get_param,$bad_params ) ) {
                            $get_params[] = $get_param . '=' . $get_value;
                        }
                    }
                    $query_str .= implode( '&', $get_params );

                    $search_conditions = '';
                    if ( isset( $_GET['s'] ) ) {
                        if ( isset( $_GET['search'] ) && $_GET['search'] == __( 'Search Domains' ) )
                            $search_conditions = 'WHERE ' . $wpdb->site . '.domain LIKE ' . "'%" . $wpdb->escape( $_GET['s'] ) . "%'";
                    }

                    $count = $wpdb->get_col( $wpdb->prepare( 'SELECT COUNT(id) FROM ' . $wpdb->site . $search_conditions ) );
                    $total = $count[0];

                    if ( isset( $_GET[ 'start' ] ) == false )
                        $start = 1;
                    else
                        $start = intval( $_GET[ 'start' ] );

                    if ( isset( $_GET[ 'num' ] ) == false )
                        $num = NETWORKS_PER_PAGE;
                    else
                        $num = intval( $_GET[ 'num' ] );

                    $query = "SELECT {$wpdb->site}.*, COUNT({$wpdb->blogs}.blog_id) as blogs, {$wpdb->blogs}.path as blog_path
                        FROM {$wpdb->site} LEFT JOIN {$wpdb->blogs} ON {$wpdb->blogs}.site_id = {$wpdb->site}.id $search_conditions GROUP BY {$wpdb->site}.id" ;

                    if ( isset( $_GET[ 'sortby' ] )) {
                        $sortby = $_GET[ 'sortby' ];
                    } else {
                        $sortby = 'ID';
                    }

                    switch ( $sortby ) {
                        case 'Domain':
                            $query .= ' ORDER BY ' . $wpdb->site . '.domain ';
                            break;
                        case 'Path':
                            $query .= ' ORDER BY ' . $wpdb->site . '.path ';
                            break;
                        case 'Blogs':
                            $query .= ' ORDER BY blogs ';
                            break;
                        case 'ID':
                        default:
                            $query .= ' ORDER BY ' . $wpdb->site . '.id ';
                    }

                    if ( isset( $_GET[ 'order' ] ) && ( $_GET[ 'order' ] == 'DESC' ))
                        $query .= 'DESC';
                    else
                        $query .= 'ASC';

                    $query .= ' LIMIT ' . (((int)$start - 1 ) * $num ) . ', ' . intval( $num );

                    $site_list = $wpdb->get_results( $wpdb->prepare( $query ), ARRAY_A );

                    if ( count( $site_list ) < $num )
                        $next = false;
                    else
                        $next = true;

                    // define the columns to display, the syntax is 'internal name' => 'display name'
                    $sites_columns = array(
                        'check'   => '',
                        'domain'  => __( 'Domain' ),
                        'id'      => __( 'Site ID' ),
                        'path'    => __( 'Path' ),
                        'blogs'   => __( 'Sites' ),
                    );
                    $sites_columns = apply_filters( 'manage_networks_columns', $sites_columns );

                    // Pagination
                    $network_navigation = paginate_links( array(
                        'base'    => add_query_arg( 'start', '%#%' ),
                        'format'  => '',
                        'total'   => ceil($total / $num),
                        'current' => $start
                    ));?>
<div id="icon-ms-admin" class="icon32"></div>
<h2><?php _e( 'WP Multi-Network' ) ?></h2>
<div id="col-container">
    <div id="col-right">
        <div class="tablenav"> 
                    <?php 
                    if ( isset( $_GET['s'] ) ) : ?>
            <div class="alignleft">
                <?php _e( 'Filter' ); ?>: <?php echo $wpdb->escape( $_GET['s'] ) ?> <a href="<?php echo $this->wpmn_admin_url();?>" class="button" title="<?php _e( 'Remove this filter' ) ?>"><?php _e( 'Remove' ) ?></a>
            </div>
                    <?php 
                    endif; ?>
            <div class="alignright">
                <form name="searchform" action="<?php echo $_SERVER['REQUEST_URI']; ?>" method="get">
                    <input type="text" name="s" />
                    <input type="hidden" name="page" value="networks" />
                    <input type="submit" name="search" id="search" class="button" value="<?php _e( 'Search Domains' ); ?>" />
                </form>
            </div>
        </div>
        <form name='formlist' action='<?php echo $_SERVER['REQUEST_URI'] . "&action=delete_multinetworks"; ?>' method='POST'>
            <div class="tablenav">
                    <?php
                    if ( $network_navigation ) echo "<div class='tablenav-pages'>$network_navigation</div>"; ?>
                <div class="alignleft">
                    <input type="submit" class="button-secondary delete" name="allnetwork_delete" value="<?php _e( 'Delete' ); ?>" />
                </div>
            </div>
            <br class="clear" />
            <table width="100%" cellpadding="3" cellspacing="3" class="widefat">
                <thead>
                    <tr>
                    <?php 
                    foreach( $sites_columns as $col_name => $column_display_name ) { 
                        if ( $col_name == 'check' ) : ?>
                        <th scope="col" class="column-cb check-column">
                            <input type="checkbox" id="select_all">
                        <?php 
                        else : ?>
                        <th scope="col"><a href="<?php echo $this->wpmn_admin_url();?>&sortby=<?php echo urlencode( $column_display_name ) ?>&<?php if( $_GET[ 'sortby' ] == $column_display_name ) { if( $_GET[ 'order' ] == 'DESC' ) { echo "order=ASC&" ; } else { echo "order=DESC&"; } } ?>start=<?php echo $start ?>"><?php echo $column_display_name; ?></a>
                        <?php 
                        endif; ?>
                        </th>
                    <?php 
                    } ?>
                    </tr>
                </thead>
                <tfoot>
                    <tr>
                    <?php
                    foreach( $sites_columns as $col_name => $column_display_name ) { 
                        if ( $col_name == 'check' ) : ?>
                            <th scope="col" class="column-cb check-column">
                                <input type="checkbox" id="select_all">
                        <?php 
                        else : ?>
                            <th scope="col"><a href="<?php echo $this->wpmn_admin_url();?>&sortby=<?php echo urlencode( $column_display_name ) ?>&<?php if( isset($_GET[ 'sortby' ]) && $_GET[ 'sortby' ] == $column_display_name ) { if( $_GET[ 'order' ] == 'DESC' ) { echo "order=ASC&" ; } else { echo "order=DESC&"; } } ?>start=<?php echo $start ?>"><?php echo $column_display_name; ?></a>
                        <?php 
                        endif; ?>
                            </th>
                        <?php 
                        } ?>
                        </tr>
                    </tfoot>
                    <tbody>
                <?php    
                if ( $site_list ) {
                    $bgcolor = '';
                    foreach ( $site_list as $site ) {?>
                        <tr>
                        <?php
                        if ( constant( "VHOST" ) == 'yes' )
                            $sitename = str_replace( '.' . $current_site->domain, '', $site[ 'domain' ] );
                        else
                            $sitename = $site[ 'path' ];
                        
                        $cur_site_id = (int) $site[ 'id' ];
                        $cur_site_url = esc_url('http://' . $site['domain'] . $site['path']);

                        foreach( $sites_columns as $column_name => $column_display_name ) {
                            switch( $column_name ) {
                                case 'check' :
                                    if ( $site['blogs'] == 0 || $site['id'] != 1 ) : ?>
                            <th scope="row" class="check-column" style="width: auto"><input type='checkbox' id='<?php echo $site[ 'id' ] ?>' name='allnetworks[]' value='<?php echo $site[ 'id' ] ?>'><label for='<?php echo $cur_site_id ?>'></label</th>
                                    <?php
                                    else : ?>
                            <th></th>
                                    <?php
                                    endif;
                                    break;
                                case 'id':?>
                            <td><?php echo $cur_site_id ?></td>
                                    <?php
                                    break;
                                case 'domain':?>
                            <td>
                                    <?php 
                                    echo $site['domain'];
                                    $actions    = array();
                                    $actions[]    = '<a class="edit" href="' . $cur_site_url . 'wp-admin/" title="' . __( 'Site Admin' ) . '">' . __( 'Site Admin' ) . '</a>';
                                    $actions[]    = '<a class="edit" href="' . $cur_site_url . 'wp-admin/network/" title="' . __( 'Network Admin' ) . '">' . __( 'Network Admin' ) . '</a>';
                                    $actions[]    = '<a class="edit" href="' . $query_str . "&action=assignblogs&id=" . $site['id'] . '" title="' . __( 'Assign sites to this network' ) . '">' . __( 'Assign Sites' ) . '</a>';
                                    $actions[]    = '<a class="edit" href="' . $query_str . "&action=editnetwork&id=" .  $site['id'] . '" title="' . __( 'Edit this network' ) . '">' . __( 'Edit' ) . '</a>';
                                    if ( $site['blogs'] == 0 || $site['id'] != 1 )
                                        $actions[] = '<a class="delete" href="' . $query_str . "&action=deletenetwork&id=" . $site['id'] . '" title="' . __( 'Delete this network' ) . '">' . __( 'Delete' ) . '</a>';

                                    if ( count( $actions ) ) : ?>
                                <div class="row-actions">
                                    <?php echo implode(' | ', $actions); ?>
                                </div>
                                    <?php
                                    endif; ?>
                            </td>
                                    <?php
                                    break;

                                case 'path' : ?>
                            <td valign='top'><label for='<?php echo $cur_site_id ?>'><?php echo $site['path'] ?></label></td>
                                    <?php
                                    break;
                                case 'blogs' : ?>
                            <td valign='top'><a href="http://<?php echo $site['domain'] . $site['blog_path'];?>wp-admin/network/sites.php" title="<?php _e( 'Sites on this network' ); ?>"><?php echo $site['blogs'] ?></a></td>
                                    <?php
                                    break;

                                default:?>
                            <td valign='top'><?php do_action( 'manage_networks_custom_column', $column_name, $site['id'] ); ?></td>
                                    <?php
                                    break;
                            }
                        }?>
                        </tr>
                    <?php
                    }
                } else { ?>
                        <tr style=''>
                            <td colspan="8"><?php _e( 'No networks found.' ) ?></td>
                        </tr>
                <?php
                } // end if ($sites)?>
                    </tbody>
                </table>
                <div class="tablenav">
                <?php     
                if ( $network_navigation ) echo "<div class='tablenav-pages'>$network_navigation</div>"; ?>
                    <div class="alignleft">
                        <input type="submit" class="button-secondary delete" name="allnetwork_delete" value="<?php _e( 'Delete' ); ?>" />
                    </div>
                </div>
            </form>
        </div>
        <div id="col-left">
            <h3><?php _e( 'Add Network' ); ?></h3>
            <p><?php _e( 'A site will be created at the root of the new network' ); ?>.</p>
                <form method="POST" action="<?php echo $_SERVER['REQUEST_URI'] . "&action=addnetwork"; ?>">
                    <table class="form-table">
                        <tr><th scope="row"><label for="newName"><?php _e( 'Network Name' ); ?>:</label></th><td><input type="text" name="name" id="newName" title="<?php _e( 'A friendly name for your new network' ); ?>" /></td></tr>
                        <tr><th scope="row"><label for="newDom"><?php _e( 'Domain' ); ?>:</label></th><td> http://<input type="text" name="domain" id="newDom" title="<?php _e( 'The domain for your new network' ); ?>" /></td></tr>
                        <tr><th scope="row"><label for="newPath"><?php _e( 'Path' ); ?>:</label></th><td><input type="text" name="path" id="newPath" title="<?php _e( 'If you are unsure, put in /' ); ?>" /></td></tr>
                        <tr><th scope="row"><label for="newSite"><?php _e( 'Site Name' ); ?>:</label></th><td><input type="text" name="newSite" id="newSite" title="<?php _e( 'The name for the new network\'s site.' ); ?>" /></td></tr>
                    </table>
                    <div class="metabox-holder meta-box-sortables" id="advanced_network_options">
                        <div class="postbox if-js-closed">
                            <div title="Click to toggle" class="handlediv"><br/></div>
                            <h3><span><?php _e( 'Clone Network Options' ); ?></span></h3>
                            <div class="inside">
                                <table class="form-table">
                                <tr>
                                    <th scope="row"><label for="cloneNetwork"><?php _e( 'Clone Network' ); ?>:</label></th>
                                    <?php $network_list = $wpdb->get_results( $wpdb->prepare( 'SELECT id, domain FROM ' . $wpdb->site ), ARRAY_A );    ?>
                                    <td colspan="2">
                                        <select name="cloneNetwork" id="cloneNetwork">
                                            <option value="0"><?php _e( 'Do Not Clone' ); ?></option>
                <?php 
                foreach($network_list as $network) { 
                    echo '                                            ' . 
                         '<option value="' . $network['id'] . '"' . ($network['id'] == 1 ? ' selected' : '' ) . '>' . $network['domain'] . '</option>'; 
                }?>
                                        </select></td>
                                </tr>
                                <tr>
                <?php
                $all_network_options = $wpdb->get_results( $wpdb->prepare( 'SELECT DISTINCT meta_key FROM ' . $wpdb->sitemeta ) );

                $known_networkmeta_options = $options_to_copy;
                $known_networkmeta_options = apply_filters( 'manage_networkmeta_descriptions' , $known_networkmeta_options );

                $options_to_copy = apply_filters( 'manage_network_clone_options' , $options_to_copy );?>
                                    <td colspan="3">
                                        <table class="widefat">
                                            <thead>
                                                <tr>
                                                    <th scope="col" class="check-column"></th>
                                                    <th scope="col"><?php _e( 'Meta Value' ); ?></th>
                                                    <th scope="col"><?php _e( 'Description' ); ?></th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php foreach ($all_network_options as $count => $option) { ?>
                                                <tr class="<?php echo $class = ('alternate' == $class) ? '' : 'alternate'; ?>">
                                                    <th scope="row" class="check-column"><input type="checkbox" id="option_<?php echo $count; ?>" name="options_to_clone[<?php echo $option->meta_key; ?>]"<?php echo (array_key_exists($option->meta_key,$options_to_copy) ? ' checked' : '' ); ?> /></th>
                                                    <td><label for="option_<?php echo $count; ?>"><?php echo $option->meta_key; ?></label></td>
                                                    <td><label for="option_<?php echo $count; ?>"><?php echo (array_key_exists($option->meta_key,$known_networkmeta_options) ? __($known_networkmeta_options[$option->meta_key]) : '' ); ?></label></td>
                                                </tr>
                                                <?php } ?>
                                            </tbody>
                                        </table>
                                    </td>
                                </table>
                            </div>
                        </div>
                    </div>
                    <input type="submit" class="button" name="add" value="<?php _e( 'Create Network' ); ?>" />
                </form>
            </div>
<script type="text/javascript">
jQuery('.if-js-closed' ).removeClass('if-js-closed' ).addClass('closed' );
jQuery('.postbox' ).children('h3' ).click(function() {
    if (jQuery(this.parentNode).hasClass('closed' )) {
        jQuery(this.parentNode).removeClass('closed' );
    } else {
        jQuery(this.parentNode).addClass('closed' );
    }
});
</script>
                    <?php
                    break;
            } // end switch( $action ) ?>
</div>
        <?php
        } // function networks_page

        function wpmn_move_site_page() {
            global $wpdb;

            if ( isset( $_POST['move'] ) && isset( $_GET['blog_id'] ) ) {
                if ( isset( $_POST['from'] ) && isset( $_POST['to'] ) ) {
                    wpmn_move_site( $_GET['blog_id'], $_POST['to'] );
                    $_GET['updated'] = 'yes';
                    $_GET['action'] = 'saved';
                }
            } else {
                if( !isset( $_GET['blog_id'] ) )
                    die( __( 'You must select a blog to move.' ) );

                $query = "SELECT * FROM {$wpdb->blogs} WHERE blog_id=" . (int)$_GET['blog_id'];
                $site = $wpdb->get_row( $wpdb->prepare( $query ) );

                if ( !$site )
                    die( __( 'Invalid blog id.' ) );

                $table_name = $wpdb->get_blog_prefix( $site->blog_id ) . "options";
                $details = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$table_name} WHERE option_name='blogname'" ) );

                if ( !$details )
                    die( __( 'Invalid blog id.' ) );

                $sites = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$wpdb->site}" ) );

                foreach ( $sites as $key => $network ) {
                    if ( $network->id == $site->site_id )
                        $myNetwork = $sites[$key];
                }?>
            <div id="icon-ms-admin" class="icon32"></div>
            <h2><?php _e( 'WP Multi-Network' ) ?></h2>
            <h3><?php echo __( 'Moving' ) . ' ' . stripslashes( $details->option_value ); ?></h3>
            <form method="post" action="<?php echo $_SERVER['REQUEST_URI']; ?>">
                <table class="widefat">
                    <thead>
                        <tr>
                            <th scope="col"><?php _e( 'From' ); ?>:</th>
                            <th scope="col"><label for="to"><?php _e( 'To' ); ?>:</label></th>
                        </tr>
                    </thead>
                    <tr>
                        <td><?php echo $myNetwork->domain; ?></td>
                        <td>
                            <select name="to" id="to">
                                <option value="0"><?php _e( 'Select a Network' ); ?></option>
                <?php
                foreach ( $sites as $network ) {
                    if ( $network->id != $myNetwork->id ) : ?>
                                <option value="<?php echo $network->id ?>"><?php echo $network->domain ?></option>
                    <?php
                    endif;
                } ?>
                            </select>
                        </td>
                    </tr>
                </table>
                <br />
                <?php             
                if ( has_action( 'add_move_blog_option' ) ) : ?>
                <table class="widefat">
                    <thead>
                        <tr scope="col"><th colspan="2"><?php _e( 'Options' ); ?>:</th></tr>
                    </thead>
                    <?php do_action( 'add_move_blog_option', $site->blog_id ); ?>
                </table>
                <br />
                <?php
                endif; ?>
                <div>
                    <input type="hidden" name="from" value="<?php echo $site->site_id; ?>" />
                    <input class="button" type="submit" name="move" value="<?php _e( 'Move Site' ); ?>" />
                    <a class="button" href="./sites.php"><?php _e( 'Cancel' ); ?></a>
                </div>
            </form>
            <?php
            }
        } // wpmn_move_site_page

        function wpmn_reassign_site_page() {
            global $wpdb;

            if ( isset( $_POST['reassign'] ) && isset( $_GET['id'] ) ) {
                /** Javascript enabled for client - check the 'to' box */
                if ( isset( $_POST['jsEnabled'] ) ) {
                    if ( !isset( $_POST['to'] ) )
                        die( __( 'No blogs selected.' ) );

                    $sites = $_POST['to'];

                /** Javascript disabled for client - check the 'from' box */
                } else {
                    if ( !isset( $_POST['from'] ) )
                        die( __( 'No blogs seleceted.' ) );

                    $sites = $_POST['from'];
                }

                $current_blogs = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$wpdb->blogs} WHERE site_id=" . (int)$_GET['id'] ) );

                foreach( $sites as $site ) {
                    wpmn_move_site( $site, (int)$_GET['id'] );
                }

                /* true sync - move any unlisted blogs to 'zero' network */
                if ( ENABLE_NETWORK_ZERO ) {
                    foreach( $current_blogs as $current_blog ) {
                        if ( !in_array( $current_blog->blog_id, $sites ) )
                            wpmn_move_site( $current_blog->blog_id, 0 );

                    }
                }

                $_GET['updated'] = 'yes';
                $_GET['action'] = 'saved';

            } else {

                // get network by id
                $query = "SELECT * FROM {$wpdb->site} WHERE id=" . (int)$_GET['id'];
                $network = $wpdb->get_row( $wpdb->prepare( $query ) );

                if ( !$network )
                    die( __( 'Invalid network id.' ) );

                $sites = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$wpdb->blogs}" ) );
                if ( !$sites )
                    die( __( 'Site table inaccessible.' ) );

                foreach( $sites as $key => $site ) {
                    $table_name = $wpdb->get_blog_prefix( $site->blog_id ) . "options";
                    $site_name = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $table_name WHERE option_name='blogname'" ) );

                    if ( !$site_name )
                        die( __( 'Invalid blog.' ) );

                    $sites[$key]->name = stripslashes( $site_name->option_value );
                } ?>
            <div id="icon-ms-admin" class="icon32"></div>
            <h2><?php _e( 'WP Multi-Network' ) ?></h2>
            <h3><?php _e( 'Assign Sites to' ); ?>: http://<?php echo $network->domain . $network->path ?></h3>
            <noscript>
                <div id="message" class="updated"><p><?php _e( 'Select the blogs you want to assign to this network from the column at left, and click "Update Assignments."' ); ?></p></div>
            </noscript>
            <form method="post" action="<?php echo $_SERVER['REQUEST_URI']; ?>">
                <table class="widefat">
                    <thead>
                        <tr>
                            <th><?php _e( 'Available' ); ?></th>
                            <th style="width: 2em;"></th>
                            <th><?php _e( 'Assigned' ); ?></th>
                        </tr>
                    </thead>
                    <tr>
                        <td>
                            <select name="from[]" id="from" multiple style="height: auto; width: 98%">
                <?php
                foreach ( $sites as $site ) {
                    if ( $site->site_id != $network->id ) echo '<option value="' . $site->blog_id . '">' . $site->name  . ' (' . $site->domain . ')</option>';
                } ?>
                            </select>
                        </td>
                        <td>
                            <input type="button" name="unassign" id="unassign" value="<<" /><br />
                            <input type="button" name="assign" id="assign" value=">>" />
                        </td>
                        <td valign="top">
                            <?php if ( !ENABLE_NETWORK_ZERO ) { ?><ul style="margin: 0; padding: 0; list-style-type: none;">
                                <?php foreach( $sites as $site ) {
                                    if ( $site->site_id == $network->id ) { ?>
                                    <li><?php echo $site->name . ' (' . $site->domain . ')'; ?></li>
                                <?php } } ?>
                            </ul><?php } ?>
                            <select name="to[]" id="to" multiple style="height: auto; width: 98%">
                            <?php
                            if ( ENABLE_NETWORK_ZERO ) {
                                foreach( $sites as $site ) {
                                    if ( $site->site_id == $network->id ) echo '<option value="' . $site->blog_id . '">' . $site->name . ' (' . $site->domain . ')</option>';
                                }
                            }
                            ?>
                            </select>
                        </td>
                    </tr>
                </table>
                <br class="clear" />
                <?php
                if ( has_action( 'add_move_blog_option' ) ) : ?>
                <table class="widefat">
                    <thead>
                        <tr scope="col"><th colspan="2"><?php _e( 'Options' ); ?>:</th></tr>
                    </thead>
                    <?php
                    do_action( 'add_move_blog_option', $site->blog_id ); ?>
                </table>
                <br />
                <?php
                endif; ?>
                <input type="submit" name="reassign" value="<?php _e( 'Update Assigments' ); ?>" class="button" />
                <a href="<?php echo $this->wpmn_admin_url();?>"><?php _e( 'Cancel' ); ?></a>
            </form>
            <script type="text/javascript">
                if(document.getElementById) {

                    var unassignButton = document.getElementById('unassign' );
                    var assignButton = document.getElementById('assign' );
                    var fromBox = document.getElementById('from' );
                    var toBox = document.getElementById('to' );

                    /* add field to signal javascript is enabled */
                    var myJSVerifier = document.createElement('input' );
                    myJSVerifier.type = "hidden";
                    myJSVerifier.name = "jsEnabled";
                    myJSVerifier.value = "true";

                    assignButton.parentNode.appendChild(myJSVerifier);

                    assignButton.onclick   = function() { move(fromBox, toBox); };
                    unassignButton.onclick = function() { move(toBox, fromBox); };
                    assignButton.form.onsubmit = function() { selectAll(toBox); };
                }

                // PickList II script (aka Menu Swapper)- By Phil Webb (http://www.philwebb.com)
                // Visit JavaScript Kit (http://www.javascriptkit.com) for this JavaScript and 100s more
                // Please keep this notice intact

            function move(fbox, tbox) {
                 var arrFbox = new Array();
                 var arrTbox = new Array();
                 var arrLookup = new Array();
                 var i;
                 for(i=0; i<tbox.options.length; i++) {
                      arrLookup[tbox.options[i].text] = tbox.options[i].value;
                      arrTbox[i] = tbox.options[i].text;
                 }
                 var fLength = 0;
                 var tLength = arrTbox.length
                 for(i=0; i<fbox.options.length; i++) {
                      arrLookup[fbox.options[i].text] = fbox.options[i].value;
                      if(fbox.options[i].selected && fbox.options[i].value != "") {
                           arrTbox[tLength] = fbox.options[i].text;
                           tLength++;
                      } else {
                           arrFbox[fLength] = fbox.options[i].text;
                           fLength++;
                      }
                 }
                 arrFbox.sort();
                 arrTbox.sort();
                 fbox.length = 0;
                 tbox.length = 0;
                 var c;
                 for(c=0; c<arrFbox.length; c++) {
                      var no = new Option();
                      no.value = arrLookup[arrFbox[c]];
                      no.text = arrFbox[c];
                      fbox[c] = no;
                 }
                 for(c=0; c<arrTbox.length; c++) {
                     var no = new Option();
                     no.value = arrLookup[arrTbox[c]];
                     no.text = arrTbox[c];
                     tbox[c] = no;
                 }
            }

            function selectAll(box) {    for(var i=0; i<box.length; i++) {  box[i].selected = true;  } }

            </script>
            <?php

            }
        } // wpmn_reassign_site_page

        function wpmn_add_network_page() {
            global $wpdb, $options_to_copy;

            if ( isset( $_POST['add'] ) && isset( $_POST['domain'] ) && isset( $_POST['path'] ) ) {

                /** grab custom options to clone if set */
                if ( isset( $_POST['options_to_clone'] ) && is_array( $_POST['options_to_clone'] ) )
                    $options_to_clone = array_keys( $_POST['options_to_clone'] );
                else
                    $options_to_clone = $options_to_copy;

                $result = wpmn_add_network(
                    $_POST['domain'],
                    $_POST['path'],
                    ( isset( $_POST['newSite'] ) ? $_POST['newSite'] : __( 'New Network Created' ) ) ,
                    ( isset( $_POST['cloneNetwork'] ) ? $_POST['cloneNetwork'] : NULL ),
                    $options_to_clone
                );

                if ( $result && !is_wp_error($result)) {
                    if ( isset( $_POST['name'] ) ) {
                        wpmn_switch_to_network( $result );
                        add_site_option( 'site_name', $_POST['name'] );
                        wpmn_restore_current_network();
                    }

                    $_GET['updated'] = 'yes';
                    $_GET['action'] = 'saved';
                } else {
                    foreach ($result->errors as $i => $error) {
                        echo("<h2>Error: " . $error[0] . "</h2>");
                    }
                }
            }
        } // wpmn_add_network_page

        function wpmn_update_network_page() {
            global $wpdb;

            if ( isset( $_POST['update'] ) && isset( $_GET['id'] ) ) {
                $query = "SELECT * FROM {$wpdb->site} WHERE id=" . (int)$_GET['id'];
                $network = $wpdb->get_row( $wpdb->prepare( $query ) );
                if ( !$network )
                    die( __( 'Invalid network id.' ) );

                wpmn_update_network( (int)$_GET['id'], $_POST['domain'], $_POST['path'] );
                $_GET['updated'] = 'true';
                $_GET['action'] = 'saved';

            } else {

                // get network by id
                $query = "SELECT * FROM {$wpdb->site} WHERE id=" . (int)$_GET['id'];
                $network = $wpdb->get_row( $wpdb->prepare( $query ) );

                if ( !$network )
                    wp_die(__( 'Invalid network id.' ));

                /* strip off the action tag */
                $query_str = substr( $_SERVER['REQUEST_URI'], 0, ( strpos( $_SERVER['REQUEST_URI'], '?' ) + 1 ) );
                $get_params = array();

                foreach ( $_GET as $get_param => $get_value ) {
                    if ( $get_param != 'action' )
                        $get_params[] = $get_param . '=' . $get_value;

                }
                $query_str .= implode( '&', $get_params );?>
            <div id="icon-ms-admin" class="icon32"></div>
            <h2><?php _e( 'WP Multi-Network' ) ?></h2>
            <h3><?php _e( 'Edit Network' ); ?>: http://<?php echo $network->domain . $network->path ?></h3>
            <form method="post" action="<?php echo $query_str; ?>">
                <table class="form-table">
                    <tr class="form-field"><th scope="row"><label for="domain"><?php _e( 'Domain' ); ?></label></th><td> http://<input type="text" id="domain" name="domain" value="<?php echo $network->domain; ?>"></td></tr>
                    <tr class="form-field"><th scope="row"><label for="path"><?php _e( 'Path' ); ?></label></th><td><input type="text" id="path" name="path" value="<?php echo $network->path; ?>" /></td></tr>
                </table>
                <?php
                if ( has_action( 'add_edit_network_option' ) ) : ?>
                <h3><?php _e( 'Options:' ) ?></h3>
                <table class="form-table">
                    <?php do_action( 'add_edit_network_option' ); ?>
                </table>
                <?php
                endif; ?>
                <p>
                    <input type="hidden" name="networkId" value="<?php echo $network->id; ?>" />
                    <input class="button" type="submit" name="update" value="<?php _e( 'Update Network' ); ?>" />
                    <a href="<?php echo $this->wpmn_admin_url();?>"><?php _e( 'Cancel' ); ?></a>
                </p>
            </form>
            <?php
            }
        } // wpmn_update_network_page

        function wpmn_delete_network_page() {
            global $wpdb;

            if ( isset( $_POST['delete'] ) && isset( $_GET['id'] ) ) {
                $result = wpmn_delete_network( (int)$_GET['id'], ( isset( $_POST['override'] ) ) );

                if ( is_a( $result, 'WP_Error' ) )
                    wp_die( $result->get_error_message() );

                $_GET['deleted'] = 'yes';
                $_GET['action'] = 'saved';

            } else {

                /* get network by id */
                $query = "SELECT * FROM {$wpdb->site} WHERE id=" . (int)$_GET['id'];
                $network = $wpdb->get_row( $wpdb->prepare( $query ) );

                if ( !$network )
                    die( __( 'Invalid network id.' ) );

                $query = "SELECT * FROM {$wpdb->blogs} WHERE site_id=" . (int)$_GET['id'];
                $sites = $wpdb->get_results( $wpdb->prepare( $query ) );

                /* strip off the action tag */
                $query_str = substr( $_SERVER['REQUEST_URI'], 0, ( strpos( $_SERVER['REQUEST_URI'], '?' ) + 1 ) );
                $get_params = array();

                foreach( $_GET as $get_param => $get_value ) {
                    if ( $get_param != 'action' )
                        $get_params[] = $get_param . '=' . $get_value;
                }
                $query_str .= implode( '&', $get_params );?>
            <form method="POST" action="<?php echo $query_str; ?>">
                <div>
                    <div id="icon-ms-admin" class="icon32"></div>
                    <h2><?php _e( 'WP Multi-Network' ); ?></h2>
                    <h3><?php _e( 'Delete Network' ); ?>: <?php echo $network->domain . $network->path; ?></h3>
                    <?php
                if ( $sites ) {
                    if ( RESCUE_ORPHANED_BLOGS && ENABLE_NETWORK_ZERO ) {?>
                    <div id="message" class="error">
                        <p><?php _e( 'There are blogs associated with this network. ' );  _e( 'Deleting it will move them to the holding network.' ); ?></p>
                        <p><label for="override"><?php _e( 'If you still want to delete this network, check the following box' ); ?>:</label> <input type="checkbox" name="override" id="override" /></p>
                    </div>
                    <?php
                    } else { ?>
                    <div id="message" class="error">
                        <p><?php _e( 'There are blogs associated with this network. ' ); _e( 'Deleting it will delete those blogs as well.' ); ?></p>
                        <p><label for="override"><?php _e( 'If you still want to delete this network, check the following box' ); ?>:</label> <input type="checkbox" name="override" id="override" /></p>
                    </div>
                    <?php
                    }
                } ?>
                    <p><?php _e( 'Are you sure you want to delete this network?' ); ?></p>
                    <input type="submit" name="delete" value="<?php _e( 'Delete Network' ); ?>" class="button" /> <a href="<?php echo $this->wpmn_admin_url();?>"><?php _e( 'Cancel' ); ?></a>
                </div>
            </form>
            <?php
            }
        } // wpmn_delete_network_page

        function wpmn_delete_multiple_network_page() {

            global $wpdb;

            if(isset($_POST['delete_multiple']) && isset($_POST['deleted_networks'])) {
                foreach($_POST['deleted_networks'] as $deleted_network) {
                    $result = wpmn_delete_network((int)$deleted_network,(isset($_POST['override'])));
                    if(is_a($result,'WP_Error' )) {
                        wp_die($result->get_error_message());
                    }
                }
                $_GET['deleted'] = 'yes';
                $_GET['action'] = 'saved';
            } else {

                /** ensure a list of networks was sent */
                if(!isset($_POST['allnetworks'])) {
                    wp_die(__( 'You have not selected any networks to delete.' ));
                }
                $allnetworks = array_map(create_function('$val','return (int)$val;'),$_POST['allnetworks']);

                /** ensure each network is valid */
                foreach($allnetworks as $network) {
                    if(!wpmn_network_exists((int)$network)) {
                        wp_die(__( 'You have selected an invalid network for deletion.' ));
                    }
                }
                /** remove primary network from list */
                if(in_array(1,$allnetworks)) {
                    $sites = array();
                    foreach($allnetworks as $network) {
                        if($network != 1) $sites[] = $network;
                    }
                    $allnetworks = $sites;
                }

                $query = "SELECT * FROM {$wpdb->site} WHERE id IN (" . implode(',',$allnetworks) . ')';
                $network = $wpdb->get_results( $wpdb->prepare( $query ) );
                if(!$network) {
                    wp_die(__( 'You have selected an invalid network or networks for deletion' ));
                }

                $query = "SELECT * FROM {$wpdb->blogs} WHERE site_id IN (" . implode(',',$allnetworks) . ')';
                $sites = $wpdb->get_results($wpdb->prepare($query));?>
            <form method="POST" action="<?php echo $this->wpmn_admin_url();?>"><div>
            <div id="icon-ms-admin" class="icon32"></div>
            <h2><?php _e( 'WP Multi-Network' ) ?></h2>
            <h3><?php _e( 'Delete Multiple Networks' ); ?></h3>
                <?php
                if ( $sites ) {
                    if ( RESCUE_ORPHANED_BLOGS && ENABLE_NETWORK_ZERO ) {?>
            <div id="message" class="error">
                <h3><?php _e( 'You have selected the following networks for deletion' ); ?>:</h3>
                <ul>
                <?php
                foreach( $network as $deleted_network ) { ?>
                    <li><input type="hidden" name="deleted_networks[]" value="<?php echo $deleted_network->id; ?>" /><?php echo $deleted_network->domain . $deleted_network->path ?></li>
                <?php
                } ?>
                </ul>
                <p><?php _e( 'There are blogs associated with one or more of these networks.  Deleting them will move these blgos to the holding network.' ); ?></p>
                <p><label for="override"><?php _e( 'If you still want to delete these networks, check the following box' ); ?>:</label> <input type="checkbox" name="override" id="override" /></p>
            </div>
                <?php 
                } else { ?>
            <div id="message" class="error">
                <h3><?php _e( 'You have selected the following networks for deletion' ); ?>:</h3>
                <ul>
                    <?php
                    foreach( $network as $deleted_network ) { ?>
                    <li><input type="hidden" name="deleted_networks[]" value="<?php echo $deleted_network->id; ?>" /><?php echo $deleted_network->domain . $deleted_network->path ?></li>
                    <?php
                    } ?>
                </ul>
                <p><?php _e( 'There are blogs associated with one or more of these networks.  Deleting them will delete those blogs as well.' ); ?></p>
                <p><label for="override"><?php _e( 'If you still want to delete these networks, check the following box' ); ?>:</label> <input type="checkbox" name="override" id="override" /></p>
            </div>
                    <?php
                    }
                } else { ?>
            <div id="message">
                <h3><?php _e( 'You have selected the following networks for deletion' ); ?>:</h3>
                <ul>
                    <?php 
                    foreach($network as $deleted_network) { ?>
                    <li><input type="hidden" name="deleted_networks[]" value="<?php echo $deleted_network->id; ?>" /><?php echo $deleted_network->domain . $deleted_network->path ?></li>
                    <?php                
                    } ?>
                </ul>
            </div>
                <?php
                }?>
                <p><?php _e( 'Are you sure you want to delete these networks?' ); ?></p>
                <input type="submit" name="delete_multiple" value="<?php _e( 'Delete Networks' ); ?>" class="button" /> <input type="submit" name="cancel" value="<?php _e( 'Cancel' ); ?>" class="button" />
            </div></form>
            <?php
            }
        } // wpmn_delete_multiple_network_page
    } // class MS_Networks 
endif; // if ( !class_exists( 'MS_Networks' ) )

$wp_multi_network = new MS_Networks();