GFY Coders --> How difficult would it be? - GoFuckYourself.com

Fat Panda · 01-30-2009, 07:01 PM

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 · 01-30-2009, 07:03 PM

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

marcjacob · 01-30-2009, 07:04 PM

Not that difficult.

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

marcjacob · 01-30-2009, 07:04 PM

Quote:

Originally Posted by Brujah

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 · 01-30-2009, 07:09 PM

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 · 01-30-2009, 07:09 PM

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 · 01-30-2009, 07:13 PM

Quote:

Originally Posted by 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.

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

Matt 26z · 01-30-2009, 07:37 PM

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 · 01-31-2009, 10:51 AM

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 · 01-31-2009, 10:52 AM

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

polle54 · 01-31-2009, 02:10 PM

Quote:

Originally Posted by marcjacob

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 · 01-31-2009, 03:08 PM

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 · 01-31-2009, 06:37 PM

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 Code:


			
<?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);

}



?>

01-30-2009, 07:01 PM	#1
Fat Panda Porn is Dead. Move along. Industry Role: Join Date: Aug 2006 Posts: 13,295	GFY Coders --> How difficult would it be? 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!

01-30-2009, 07:03 PM	#2
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	To see when they were last updated, you could use an RSS feed reader if all of your blogs publish rss feed. __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com

01-30-2009, 07:04 PM	#3
marcjacob Confirmed User Join Date: Jun 2003 Location: England Posts: 1,063	Not that difficult. Especially if the script that does this has mysql access to all the blogs. __________________ Free Site Express GFY Launch Offer Gay Demo Video - Straight Demo Video Icq: 191127710 Email: [email protected]

01-30-2009, 07:37 PM	#8
Matt 26z So Fucking Banned Industry Role: Join Date: Apr 2002 Location: ¤ª"˜¨๑۩۞۩๑¨˜"ª¤ Posts: 18,481	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. Last edited by Matt 26z; 01-30-2009 at 07:38 PM..

01-31-2009, 10:51 AM	#9
borked Totally Borked Industry Role: Join Date: Feb 2005 Posts: 6,284	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. __________________ For coding work - hit me up on andy // borkedcoder // com (consider figuring out the email as test #1) All models are wrong, but some are useful. George E.P. Box. p202

01-30-2009, 07:09 PM	#5
Fat Panda Porn is Dead. Move along. Industry Role: Join Date: Aug 2006 Posts: 13,295	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

01-30-2009, 07:09 PM	#6
doridori So Fucking Banned Join Date: Jul 2008 Location: Canadia Posts: 2,222	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.

01-31-2009, 10:52 AM	#10
Reak AGV Confirmed User Join Date: Dec 2004 Location: Unknown Posts: 4,283	Doesn't sound very hard to me, it can be done. __________________ Need Mainstream Content and SEO? SEO * Website Copy * Blogs Blogging - PR Work - Forum Marketing - Social Marketing - Link building - Articles 100% Guaranteed Content!

01-31-2009, 03:08 PM	#12
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,372	not hard at all, you would just parse each blog db for the title or whatever, you can check published, or in the queue. __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

01-31-2009, 06:37 PM	#13
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,372	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 Code: `<?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); } ?>` __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff