dvalin

Nah its still taking way to long to load, I dont get it tho, I didnt update or download any new plugins so cant think what made it screw up.

gona go try that right now

Ah, I didnt know about those commands…

What I am doing now is this.

$sql2="SELECT wp_".$row['blog_id']."_posts.post_date, wp_".$row['blog_id']."_posts.post_title, wp_".$row['blog_id']."_posts.post_content, wp_".$row['blog_id']."_options.option_value,wp_blogs.blog_id,wp_blogs.domain FROM wp_".$row['blog_id']."_posts, wp_".$row['blog_id']."_options,wp_blogs WHERE option_name = 'template' and wp_blogs.blog_id='".$row['blog_id']."' AND post_type='post' AND post_status='publish' ORDER BY post_date DESC LIMIT 0,1 ";

So with a single query I get out the info I need, that query is then part of a loop that goes through all the blogs we have.

never mind solved the problem

$result = $wpdb->get_results($SQL);
        //$result = mysql_query($SQL)  or die("A MySQL error has occurred.<br />Your Query: " . $your_query . "<br /> Error: (" . mysql_errno() . ") " . mysql_error());;

        while($row=mysql_fetch_assoc($result)){

thats what I am trying to do but its not working.. the comment out is how I was doing it before.

cracked it.

SELECT wp_13_posts.post_date, wp_13_posts.post_title, wp_13_posts.post_content, wp_13_options.option_value
FROM wp_13_posts, wp_13_options
WHERE option_name = “template”
ORDER BY post_date DESC
LIMIT 1

this will grab the info needed from one blog, as date,title,content,themepath which will be the most recent post from that given blog.

Now I just need to loop through all blogs, and only display the top 5.

this is the sql Im trying to sort out.

SELECT
wp_13_posts.post_date,
wp_13_posts.post_title,
wp_13_posts.post_content,
wp_13_options.option_name
FROM
wp_13_posts,
wp_13_options
ORDER BY wp_13_posts.post_date
DESC
LIMIT 1;

the idea is to select the date, title content and template from the posts and options tables and list only 1 row.

but I keep getting a join error or something.

im sure its the theme, but really cant think of whats stopping it from displaying.

read that link and my head and foot are in the right place..

yup it’s there. still same problem. works on all my other themes that are on my other blogs just not this one .

yeah its in the header file, I actually had to move it as it was in the wrong place, before the body, however I now see the space where the bar would be but still not bar.

Ah. I thought that meant the plugin could then be USED by the other blogs..

but then should it still not show up on the list, active or not?

edit :: Ah now I get whats happening, when I network Activate that forces it on for all blogs on the network. so if I turn that off I can then turn it on per blog.

I have another question tho, with our community, we have our main blog, and then clan/game specific blogs, those are the ones I want linked through, however we also have member blogs.

Ideally what I would like is that all blogs are set to not post to main blog, but that I can then turn ON! the specific blogs I want.

kinda the reverse of whats happening now.

hope that makes sence.

Hi Andrea_r thanks..

I am still having problems tho so with a bit of luck you can fix it or see what Iv done wrong.

I took that line and did this with it.

echoblock.php

<?php
/*
Plugin Name: Stop Echo to Main Site
Plugin URI: https://www.cruel-gaming.com
Description: This Plugin will stop blog posts being piped through to the main blog site.
Version: 1.0
Author URI: https://cruel-gaming.com/
*/

remove_action('save_post', 'sitewide_tags_post', 10, 2);

?>

I put that single file in to my wp plugins folder, so its path is content/plugins/echoblock.php

I then went to network admin, plugins, saw it on the list and clicked Network Activate.

However when I then goto admin on say my dev blog, I cant see the plugin in the list to activate or deactivate it, its not showing up.

Yeah I have this installed now, but it’s not quite what I need.

the functionality seems fine, when I post things on other blogs I have them also post on my main blog, thats cool.

However I would like to tell it which blogs to post from for example I have 10 blogs, but I only want 2 of them to have their posts shoved onto the main blog page.

is this possible with this addon ?

Oh no sorry yeah using the new one.

Is sitewide tags still the plugin im looking for ?