SQL Query to Get list of all users along with their blogs

You can use get_blogs_of_user() to get all the blogs of a given user. So to get a list sorted by the users: global $wpdb; $blogs = array(); $user_ids = $wpdb->get_col( ‘SELECT ID FROM $wpdb->users’ ); foreach( $user_ids as $user_id ) { $blogs[$user_id] = get_blogs_of_user( $user_id ); } // you can use var_dump( $blogs ); to … Read more

setup Multi Multi-site with one installation?

I’ve ended up with using such solution: 1) Created folders like: wp-base – wp-admin – wp-includes – …. all wp-php files and I’ve created “symlink” that 2-folder and wp standard php files inside other folders: my-wp-1 – wp-content & wp.config.php & htaccess my-wp-2 – wp-content & wp.config.php & htaccess The only thing I had to … Read more

Customizing Deleted/Archived blogs warning pages

The function that deals with this is ms_site_check(). If existent, it will use the following files. And they should render a full custom HTML page. WP_CONTENT_DIR . ‘/blog-deleted.php’ WP_CONTENT_DIR . ‘/blog-inactive.php’ WP_CONTENT_DIR . ‘/blog-suspended.php’ Another option is to short-circuit the process and redirect the visitor. It has to be done with a Must Use plugin … Read more

How to use Multiple-Domains in one Multi-Site Installation?

As far as I know, Multi-Domains from WPMUDEV is the only plugin which works flawlessly with the lastest version of WordPress. It is BuddyPress compatible, has a single signon and even a multi-subdomain feature (blog1.subdomain.site.com, blog2.subdomain.site.com). There is a free alternative, but it has not been updated for the latest version of WordPress (the author … Read more

Full Domain Mapping with WP3 in Multiuser Mode

You can map regular domains to a WordPress Multisite installation using the WordPress MU Domain Mapping plugin. There’s also a great tutorial available: WordPress 3.0: Multisite Domain Mapping Tutorial For reference … I asked a similar question yesterday. I have a client who hosts multiple blogs with unique domains, but it becomes a hassle to … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)