GFY Coders --> How difficult would it be?

[Fat Panda]

To create a program that would pull a list of the latest 10-20 wordpress blog posts (title and date only) for every blog entered.

Basically I'd like to enter the user and pass of each blog I own. Open the program on my desktop, see a list of the blogs I entered, click one and see a list of the latest 10-20 published or scheduled posts for that blog.

I am sick of logging into 30+ blogs just to see when they were last updated or when they are updated till. Help me!

[Brujah]

To see when they were last updated, you could use an RSS feed reader if all of your blogs publish rss feed.

[marcjacob]

Not that difficult.

Especially if the script that does this has mysql access to all the blogs.

[marcjacob]

To see when they were last updated, you could use an RSS feed reader if all of your blogs publish rss feed.

Or that would work very well to.

[Fat Panda]

yes but the rss feed only shows the published posts, I need to see the schelduled posts so I know what ones I need to update

ie...if i only have 2 scheduled posts ready i need to do more

[doridori]

above mentioned methods all work. it would be very easy if those blogs shared the same db. if no rss feed, then brute force method would be to scrape. again, many ways to achieve this, and should not be particularly difficult.

[marcjacob]

above mentioned methods all work. it would be very easy if those blogs shared the same db. if no rss feed, then brute force method would be to scrape. again, many ways to achieve this, and should not be particularly difficult.

Like he said, the RSS only shows published posts. So Id guess shared mysql is the easiest to code, and thus cheaper.

[Matt 26z]

Here is probably the most simple, ghetto way of doing it.

Set up an HTML page with an iFrame for each blog. In each iFrame, print a list if the X most recent and Y scheduled updates for that blog. Probably just posted on date and subject.

[borked]

really quite easy - they're all wordpress, so exactly the same sql for each. Just one config file with mysql user/passes (if there isn't one master user/pass that can query all the db's), then there you go. A quick htpasswd protection for the script and Bob's your Uncle.

[Reak AGV]

Doesn't sound very hard to me, it can be done.

[polle54]

Not that difficult.

Especially if the script that does this has mysql access to all the blogs.

Exactly with mysql access I think I can code that in 4 hours. depending on demands to the GUI and usability.

$100/hour.

[fris]

not hard at all, you would just parse each blog db for the title or whatever, you can check published, or in the queue.

[fris]

heres a small snippet, just an example how its done, but you would need to build a db of sites that it would parse.

and of course change published to future

<?php
$how_many=15; //how many posts to display
require('blog1/wp-config.php'); //the path to the wp-config file of the blog I want to use
$news=$wpdb->get_results("SELECT 'ID','post_title','post_content' FROM $wpdb->posts WHERE 'post_type'=\"post\" AND 'post_status'=\"publish\" ORDER BY post_date DESC LIMIT $how_many"); 

foreach($news as $np){
printf ("<div class='normalText'>%s</div>", $np->post_content);
}

?>