The best way would be to use the built-in Options API to add info to the wp_options table. To add the option: http://codex.wordpress.org/Function_Reference/add_option To read the option value: http://codex.wordpress.org/Function_Reference/get_option
That field is longtext so it should be more than you could ever use– about 4GB
SELECT * FROM wp_posts, wp_2_posts, wp_3_posts WHERE wp_posts.post_content LIKE ‘%foo’ OR wp_2_posts.post_content LIKE ‘%foo’ OR wp_3_posts.post_content LIKE ‘%foo’; should do the trick. (Note that in Multisite, there shouldn’t be a wp_1_posts — your root site uses wp_posts etc.)
The function bbp_forum_id() will directly echo its value, you want to use bbp_get_forum_id() which will return the value for use in the context of an API call.
If you’re not using WP’s built in Ajax handlers, which includes things for you, you will need to include the WP core yourself. Try adding define(‘WP_USE_THEMES’, false); global $wpdb; require(BASE_PATH . ‘wp-load.php’); to the top of your file. I should point out that the path to wp-load.php may not be the same and hard coding … Read more
I know my way around WordPress’ database pretty well and I would never call editing user permissions via PhpMyAdmin an easy thing to do. You are editing serialized strings– very easy to get wrong, actually. So don’t feel bad. There is something very wrong with that statement that “he should easily know how to … … Read more
prepare() takes at least 2 parameters. Most of your calls to prepare() are not needed. For example: $blogids = $wpdb->get_col($wpdb->prepare(“SELECT blog_id FROM $wpdb->blogs”)); In this code, if the call to $wpdb->prepare() were valid, it wouldn’t do anything. The function doesn’t do anything to the first parameter. It manipulates the values in the other parameters passed … Read more
The basic process – on activation, check if is_multisite, get all of the sites with wp_get_sites, loop over the results with foreach and switch_to_blog for each site ID, and create the table. You’ll also need to hook the wpmu_new_blog action, check if is_plugin_active_for_network, switch to that blog ID and run your activation code, so sites … Read more
Yes you will need to activate the plugins on the plugins page. A side note: For future reference if you need to disable plugins during a migration. Don’t migrate the plugins across and wordpress will automatically disable them. Then you would copy them to the plugins folder and active as usual. This would also keep … Read more
This is a variable scope, an pure PHP, problem at heart. I didn’t close it because I am assuming that mistake is in turn due to a misunderstanding of the init hook, or hooks in general perhaps, which is WordPress specific. In PHP, a global must be declared global before the first time it is … Read more