Navigation

← Previous Change
Next Change →

Changeset 1447 for trunk/wpmu-settings.php

Timestamp:

08/25/08 16:06:29 (3 months ago)

Author:

donncha

Message:

Prepare SQL, fixes #719, props momo360modena

Files:

trunk/wpmu-settings.php (modified) (8 diffs)

Legend:

: Unmodified
: Added
: Removed
: Modified
: Copied
: Moved

trunk/wpmu-settings.php

r1428	r1447
51	51	$path = substr( $_SERVER[ 'REQUEST_URI' ], 0, 1 + strpos( $_SERVER[ 'REQUEST_URI' ], '/', 1 ) );
52	52	if( constant( 'VHOST' ) == 'yes' ) {
53		$current_site = $wpdb->get_row( ~~"SELECT * FROM $wpdb->site WHERE domain = '$domain' AND path='$path'"~~ );
	53	$current_site = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->site WHERE domain = %s AND path = %s", $domain, $path) );
54	54	if( $current_site != null )
55	55	return $current_site;
56		$current_site = $wpdb->get_row( ~~"SELECT * FROM $wpdb->site WHERE domain = '$domain' AND path='/'"~~ );
	56	$current_site = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->site WHERE domain = %s AND path='/'", $domain) );
57	57	if( $current_site != null ) {
58	58	$path = '/';
59	59	return $current_site;
60	60	}
	61
61	62	$sitedomain = substr( $domain, 1 + strpos( $domain, '.' ) );
62		$current_site = $wpdb->get_row( ~~"SELECT * FROM $wpdb->site WHERE domain = '$sitedomain' AND path='$path'"~~ );
	63	$current_site = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->site WHERE domain = %s AND path = %s", $sitedomain, $path) );
63	64	if( $current_site != null )
64	65	return $current_site;
65		$current_site = $wpdb->get_row( ~~"SELECT * FROM $wpdb->site WHERE domain = '$sitedomain' AND path='/'"~~ );
	66	$current_site = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->site WHERE domain = %s AND path='/'", $sitedomain) );
66	67	if( $current_site == null && defined( "WP_INSTALLING" ) == false ) {
67	68	if( count( $sites ) == 1 ) {
…	…
75	76	}
76	77	} else {
77		$current_site = $wpdb->get_row( ~~"SELECT * FROM $wpdb->site WHERE domain = '$domain' AND path='$path'"~~ );
	78	$current_site = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->site WHERE domain = %s AND path = %s", $domain, $path) );
78	79	if( $current_site != null )
79	80	return $current_site;
80		$current_site = $wpdb->get_row( ~~"SELECT * FROM $wpdb->site WHERE domain = '$domain' AND path='/'"~~ );
	81	$current_site = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->site WHERE domain = %s AND path='/'", $domain) );
81	82	if( $current_site == null && defined( "WP_INSTALLING" ) == false ) {
82	83	if( count( $sites ) == 1 ) {
…	…
98	99	$current_blog = wp_cache_get( 'current_blog_' . $domain, 'site-options' );
99	100	if( !$current_blog ) {
100		$current_blog = $wpdb->get_row(~~"SELECT * FROM $wpdb->blogs WHERE domain = '$domain'"~~);
	101	$current_blog = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->blogs WHERE domain = %s", $domain) );
101	102	if( $current_blog )
102	103	wp_cache_set( 'current_blog_' . $domain, $current_blog, 'site-options' );
103	104	}
104	105	if( $current_blog != null && $current_blog->site_id != $current_site->id ) {
105		$current_site = $wpdb->get_row(~~"SELECT * FROM $wpdb->site WHERE id='{$current_blog->site_id}'"~~);
	106	$current_site = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->site WHERE id = %d", $current_blog->site_id) );
106	107	} else {
107	108	$blogname = substr( $domain, 0, strpos( $domain, '.' ) );
…	…
115	116	$blognames = array( 'page', 'comments', 'blog', 'wp-admin', 'wp-includes', 'wp-content', 'files', 'feed' );
116	117	if( $blogname == '' \|\| in_array( $blogname, $blognames ) \|\| is_file( $blogname ) \|\| is_blogname_page( $blogname ) ) {
117		$current_blog = $wpdb->get_row(~~"SELECT * FROM $wpdb->blogs WHERE domain = '$domain' AND path = '$path'"~~);
118		} else {
119		$current_blog = $wpdb->get_row(~~"SELECT * FROM $wpdb->blogs WHERE domain = '$domain' AND path = '{$path}{$blogname}/'"~~);
	118	$current_blog = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->blogs WHERE domain = %s AND path = %s", $domain, $path) );
	119	} else {
	120	$current_blog = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->blogs WHERE domain = %s AND path = %s", $domain, $path.$blogname.'/') );
120	121	}
121	122	}
…	…
123	124	if( defined( "WP_INSTALLING" ) == false ) {
124	125	if( $current_site && $current_blog == null ) {
125		$current_blog = $wpdb->get_row(~~"SELECT * FROM {$wpdb->blogs} WHERE domain = '{$current_site->domain}' AND path = '{$current_site->path}'"~~);
	126	$current_blog = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->blogs WHERE domain = %s AND path = %s", $current_site->domain, $current_site->path) );
126	127	}
127	128	if( $current_blog == false \|\| $current_site == false )
…	…
132	133	global $wpdb, $table_prefix, $domain, $path;
133	134
134		$blog_id = $wpdb->get_var(~~"SELECT blog_id FROM $wpdb->blogs WHERE domain = '$domain' AND path = '$path'"~~);
	135	$blog_id = $wpdb->get_var( $wpdb->prepare("SELECT blog_id FROM $wpdb->blogs WHERE domain = %s AND path = %s", $domain, $path) );
135	136
136	137	// is the request for a page of the main blog? We need to cache this information somewhere to save a request
…	…
155	156
156	157
157		$current_site->site_name = $wpdb->get_var( ~~"SELECT meta_value FROM $wpdb->sitemeta WHERE site_id = '$site_id' AND meta_key = 'site_name'"~~ );
	158	$current_site->site_name = $wpdb->get_var( $wpdb->prepare("SELECT meta_value FROM $wpdb->sitemeta WHERE site_id = %d AND meta_key = 'site_name'", $site_id) );
158	159	if( $current_site->site_name == null )
159	160	$current_site->site_name = ucfirst( $current_site->domain );
…	…
162	163	// no blog found, are we installing? Check if the table exists.
163	164	if ( defined('WP_INSTALLING') ) {
164		$query = "SELECT blog_id FROM ".$wpdb->blogs." limit 0,1";
165		$blog_id = $wpdb->get_var( $query );
	165	$blog_id = $wpdb->get_var( "SELECT blog_id FROM $wpdb->blogs LIMIT 0,1" );
166	166	if( $blog_id == false ) {
167	167	// table doesn't exist. This is the first blog

Navigation

Changeset 1447 for trunk/wpmu-settings.php

Legend:

trunk/wpmu-settings.php

Download in other formats: