Make WordPress Core

Opened 15 years ago

Closed 15 years ago

#13633 closed enhancement (worksforme)

multisite prefixes

Reported by: angeloverona's profile Angeloverona Owned by: ryan's profile ryan
Milestone: Priority: normal
Severity: normal Version: 3.0
Component: Database Keywords: wpdb, prefix, prefixes
Focuses: Cc:

Description

since WordPress is multiblog site, we have still only one prefix function like "wpdb->prefix;" for now we have many blogs with unique prefixes... in modules we can easily use this "wpdb->prefix; to get unique prefix of active site...but how can we get a primary prefix for main blog in modules? i have funtion like:

substr($wpdb->prefix, 0, stripos($wpdb->prefix, "_")+1);

but this can be used only if prefix look like as "cars_", if someone use prefix like "my_cars_" this method will fail.

it will be good to enhance this prefixes like get prefix by id, or more simply get base prefix.
$wpdb[0]->prefix,$wpdb->prefix_id,$wpdb->base_prefix

Change History (3)

#1 @Angeloverona
15 years ago

don't use this $wpdb[0]->prefix :)

#2 @Angeloverona
15 years ago

add "base prefix" to db table(_site) or to (_blogs) table prefix column for all blogs

#3 @nacin
15 years ago

  • Milestone 3.0 deleted
  • Resolution set to worksforme
  • Status changed from new to closed

$wpdb->get_blog_prefix( $blog_id );

Note: See TracTickets for help on using tickets.