BuddyPress.org

One more question, and then I will try to leave everyone alone, promise!

Would anyone be willing to give me the SQL query to plug into phpMyAdmin that will delete all of the new blog post from blog ID 1 (or, by name: RiotCart.com) activity entries from my db altogether? I’m still testing my fix, but even if it does work, there’s still the issue of my activity stream being all clogged up by the doubles from the past, and I really need to get rid of those.

@boonebgorges, thanks, and I have to ask why would you advise against doing it? Having those duplicates in the activity stream is actually an extremely bad thing for my site, because they are essentially items for sale. If a user is able to view the copy of a post made to my main site by the SWT plugin (as you are able to on certain posts that have been natively posted to one of my network’s child sites), the “add to form” cart renders using MY paypal info, rather than the seller’s info, as it does when you view the item on their site!

Here is an example of a child site post (copied to the main site via SWT) that you can get to via one of the duplicate activity entries:

http://www.riotcart.com/blog/2011/01/30/medium-juliette-skirty/

And here is the item on the seller’s own site (a child site on my network):

http://www.riotcart.com/hedgieshideaway/?p=115

As you can imagine, it’s extremely important that users/front-end viewers are NOT given the option of which version (the original or the copy to the main site) they’d like to click into!

@nahummadrid, I honestly have no idea what was going on. Like I mentioned, as soon as I removed the “before_blog_post” and “after_blog_post” BP codes from around my query for the featured post, the problem was non-existent, and I was able to just use the block activity stream types plugin you had recommended

For the record, here is my query for the featured post. I use the Featured Content Showcase plugin for various reasons, but it displays a slideshow. All I wanted was one static, random post with an image, title, and excerpt on each page load, so I dug around and found the meta key/velue that the FCS plugin was adding to posts marked as featured, and ran with it:

`$args=array(
‘orderby’ => ‘rand’,
‘post_type’ => ‘post’,
‘post_status’ => ‘publish’,
‘numberposts’ =>1,
‘post_type’ => ‘post’,
‘meta_key’ => ‘_fcs_featured’,
‘meta_value’ => ‘true’,
);

$latest = get_posts($args);
$count = 0;
foreach($latest as $post) {

$blogid = get_post_meta($post->ID, ‘blogid’, true);
$image = get_post_meta($post->ID, ‘thumbnail’, true);
$title = get_post_meta($post->ID, ‘_fcs_title’, true);
$text = get_post_meta($post->ID, ‘_fcs_text’, true);
if ( empty($title) ) {
$title = get_the_title($post->ID);
}

if ( empty($text) ) {
$text = $post->post_excerpt;
if ( post_password_required($post) ) {
$text = __(‘There is no excerpt because this is a protected post.’);
} elseif ( !empty($post->post_excerpt) ) {
$text = apply_filters(‘get_the_excerpt’, $post->post_excerpt);
} else {
$text = $this->_makeExcerpt($post->post_content);
}
}`

LOL, I would never do that (and I would export a backup first). Under those conditions, does it seem like a safe choice?