iftomkins

You guys are the best! It’s easy to feel a bit nervous since I couldn’t find an actual account of someone doing this before (though I’m sure it’s been done), so your advice is heartening.

So you don’t think I need to do a full search and replace to remove wp_8 prefix and replace with just wp_? Renaming the tables should be enough, even on the plugins?

I’m trying to do this right now, and I can say if you can avoid trying to migrate a subsite into a single installation, definitely avoid it. I was testing it on a local server using MAMP and I thought I had it, and then I ran into this redirect loop problem.

One thing I’m debating is whether to export the wp_users and wp_usermeta from the multisite installation. I’m going with no for now.

Any tips will be appreciated. I’ll let you know how it turns out, and if I develop a “flow” I’ll share it.

Hi, I had this same problem, and for some reason.

The main issue for me, it seems (maybe on account of wordpress 3.1), is that the posts were in multiple categories, not just the one i want to exclude. If the post is JUST in the one I wanted to exclude, then all the excluding plugins, and basic fixes seem to work. But in my situation, this is the query_posts that worked for me! Finally!

I am excluding category 28, and including category ‘brands’.

<?php query_posts( array( ‘category__not_in’ => array(28), ‘category_name’ => ‘brands’, ‘posts_per_page’ => ’12’, ‘paged’ => $paged, ‘orderby’ => ‘title’, ‘order’ => ‘ASC’ ) );?>

Hey, I tried to do a similar thing, where a link will take the user to a random page from the WordPress Site. I based it on your code and some code I found here.

I added this to my functions.php file.

function get_randompost() {
	$sql = "SELECT ID FROM wp_posts WHERE post_type = 'page' AND post_status = 'publish' AND id <> 2 AND id <> 729 AND id <> 2724 AND id <> 2223 AND id <> 2814 AND id <> 738 AND id <> 744 AND id <> 747 AND id <> 751 AND id <> 753 AND id <> 775 AND id <> 889 AND id <> 973 AND id <> 997 AND id <> 1029 AND id <> 1106 AND id <> 1101 AND id <> 954 AND id <> 26 AND id <> 29 AND id <> 416 ORDER BY RAND() LIMIT 1";
    return mysql_result(mysql_query($sql), 0, 0);
    }

Then I used this link in a custom widget: (with some button styling)

<a href="http://nextgenresale.com/?page_id=<?php echo get_randompost() ?>" class="small-button smallsilver"><span>Shuffle Knowledge</span></a>

Notes:

post_parent – I tried using this, and it worked, but it only gave me the child pages immediately under the post_parent ID I defined. What I needed was the is_tree function, but I didn’t know how to do that via SQL. I decided to just exclude the page IDs that i didn’t want to show up.

<> – as you can see, I’m a novice, as I didn’t even know how to exclude an array of pages, I had to do it one by one! Ha!

Thanks, Scott! I hope it comes out, soon, too, since the site launch is hopefully happening in a couple days.