Joomla Extensions Club 20,483 posts

[joeluvny Friend joeluvnyJoin date: June 2009Posts: 130Downloads:39Uploads:2 Thanks: 8 Thanked: 1 times in 1 posts]

#201860

Hello, is their a way for the JA System Social Feed Plugin to only the most pull in the most recent page feeds and not the entire Facebook feed history. I was using it to pull over 30 Facebook pages but it would not only pull in the most recent post but the entire Facebook post history which cause my database to get bloated and the data useless.

It was pulling feeds from pages all the way back to 2007

Also do you plan on added an expiration date feature to the plugin?
This feature would unpublish and automatically delete any feeds that as past a certain date, ex.( delete any feed that is more than 7 days old)

Thank you
Joseph

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#551973

Hi there,
Please allow me a bit time. I’ll check code of this plugin than we can see what can we do.

Thank you,
Viet Vu

[joeluvny Friend joeluvnyJoin date: June 2009Posts: 130Downloads:39Uploads:2 Thanks: 8 Thanked: 1 times in 1 posts]

#551974

Thank you, that would be great! 🙂
I would love to start using it again

Joseph

[joeluvny Friend joeluvnyJoin date: June 2009Posts: 130Downloads:39Uploads:2 Thanks: 8 Thanked: 1 times in 1 posts]

#553449

Hello Viet, do you have any updates on this issue yet?

Joseph

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#553675

Hi there,
I’m sorry was bit busy with some issues. I’ll reply you update today.

Thank you,
Viet Vu

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#553677

Hi there,
I have just checked into this plugin source code.
Let’s try to play with it.

pluginssystemjasocial_feedtablesjoomla.php

This’s table for Joomla! content. We’r using it to save data to Joomla! com_content article


$item['id'] = $id;
$item['created_by'] = $post['created_by'];
$item['created_by_alias'] = html_entity_decode($post['source_author'], ENT_COMPAT, 'UTF-8');
$item['catid'] = $post['catid'];
$item['alias'] = $post['source_alias'];
$item['title'] = html_entity_decode($post['source_title'], ENT_COMPAT, 'UTF-8');
$item['created'] = $this->dateToDb($post['source_published_date']);
$item['publish_up'] = date('Y-m-d H:i:s', time()-86400);
$item['publish_down'] = '';



$item['created'] = $this->dateToDb($post['source_published_date']);

As you can see, this item created time will stored by get from facebook source_published_date. Yup ! At this point we can inject our code to check time diferent


http://stackoverflow.com/questions/2040560/finding-the-number-of-days-between-two-dates

For sample you want to limit 7 days from current day with created time.

I’m not sure our developer will include it in next version but at least we got solution.

Thank you,
Viet Vu

[joeluvny Friend joeluvnyJoin date: June 2009Posts: 130Downloads:39Uploads:2 Thanks: 8 Thanked: 1 times in 1 posts]

#553689

Thank you for looking into this for me Viet but can you help me by giving me the code that i would inject after the
$item[‘created’] = $this->dateToDb($post[‘source_published_date’]);

So that it only seek Facebook feeds that are not older than 7 days.

Thank you

Joseph

[Author]

Posts