Multisite – use one table?

If I am correct, only wp_posts and post meta would be not compat at moment? rest of tables are global

add_filter('bp_core_get_table_prefix', 'sb_filter_bp_table_prefix', 2001);
function sb_filter_bp_table_prefix($prefix ){
    global $wpdb;
    return $wpdb->prefix;
}

Here is an old function we used to allow us to insert a post into two blogs at the same time

			// post to smeak.tv
			
			global $switched, $video_post_pe;
			switch_to_blog(44);
			$video_post_id = wp_insert_post($video_post);
			update_post_meta($video_post_id, 'dp_video_url', $_POST['insert_video_link'], true);
			$video_post_pe = get_permalink( $video_post_id );
			restore_current_blog(); 

aah that is good news Stiofan… all i am really trying to achieve is to have the install on the 2nd blog use the same listings and locations on the main site…. i see all the geodir tables are global, except that the wp_posts and wp_postmeta tables are not “multiste” so on root blog it uses wp_posts and wp_postmeta and on say blog id 331 it uses wp_331_posts and wp_331_postmeta.

So if u look in the sublog under Places you see no listings… this is because it is reading wp_331_posts and wp_331_postmeta and not wp_posts and wp_postmeta

users have one login across all sites in install … we have the listings site, and the 2nd is a buddypress social site that pulls in the listings as well in widgets allowing users to rate, and mark as favourites etc… places they have been to. The social site uses a completely different theme – which we have to retain, the listings in both the main blog and subsite have to be shared or the same on both.

When you install the plugins at moment on the 2nd site – it does not totally share the posts across both blogs

@m33 – will keep you posted on this – I tried yesterday to replace all references to $wpdb->prefix with $wpdb->base_prefix which forces the plugin to use the “root” blog or site tables – that did not work as much as i wanted – i then tried replacing all db calls to $wpdb->posts. terms etc to wp_posts, wp_terms etc… that only got some parts working as in now at least i can see the locations taxonomy in the 2nd blog… also some listings show up now in 2nd blog, but not in admin….

At the end of it this is not the way to go… what needs to be done is to have a network admin screen that asks if the plugin must be installed network wide or not.

Before in another plugin we used the switch blog function to access any references to posts or terms and taxonomies… I will spend some time on this, for us a solution is not a “want” it is a MUST… without this we cannot use the system in our business model. Either way, any help or suggestions appreciated – Lets get this done !!!!

Maybe a function using switch_to_blog( $site->blog_id );??

or

global $wpdb;

$base_prefix = $wpdb->get_blog_prefix(0);
$base_prefix = str_replace( ‘1_’, ” , $base_prefix );
Best Regards

tx – stiofan – i do not want to change the core plugin but abandon the idea i cannot – this is not a personal request from me – i have no choice as this is what i have to provide for the client – so trust me, i will do my best to share ALL i can and NOt try to change the core plugin – there are many multi site plugins, why is it so “impossible” to have a multisite wpgeodirectory plugin?

I bought your old geodirectory/geotheme system many moons ago, and i did many changes to that and had that working fine on muktisite, i then also tried for over a year geomywp which IS multisite, i even integrated that into the DIRECTORY theme on themeforest… I decided to switch back to your system, as i felt you guys have done a great job so far and i would like to support you….

as i said i don’t have the luxury of cannot… I MUST achieve this, i have no options, and i also know that NOTHING in programming is unachievable – to have a multisite version of your great system is NO train smash – it can be done