[en3r0]

I know what to do, I'm just not sure what files to cron!

I would like to be able to remove stories from the queue after so many days. What file is used for this?

I know to import a feed you just cron /rss/import_feeds.php


For others who are looking to cron on a command line interface, here is a quick resource:

http://www.modwest.com/help/kb5-125.html

[kapengbarako]

yes. you just need to cron import_feeds.php

[en3r0]

What about for removing stories older than so many days?

[kbeeveer46]

The Pligg wiki is down right now. When it's back up I can show you a file that will hopefully do what you want.

[en3r0]

Alright, thanks!

[en3r0]

Bump* wiki up?

[kbeeveer46]

Here is that script I was referring to http://www.pligg.com/wiki/index.php?...stories_script

[en3r0]

sweet, thank you very much!

[smcgw]

hi there, thanks for the script, but i am having some problems getting it to work for some reason

just as a test, i went ahead and tried to remove articles that were 3 days old, and it didnt work, any suggestions?

i replacced db host, etc with my information, and than set the time for 3 and 3 for the days

thanks for your time

<?php

mysql_connect("localhost", "my db name", "my db pass") or die("error1");
mysql_select_db("my db name") or die("error2");

$fourteen_days   = 3;
$now = date("U") - $fourteen_days; 
$ninety_days   = 3;
$now2 = date("U") - $ninety_days; 

$now = date("Y-m-d H:i:s",$now);
$now2 = date("Y-m-d H:i:s",$now2);

mysql_query("delete from links where link_date < '$now' AND link_status = 'queued'");
mysql_query("delete from links where link_date < '$now2' AND link_status = 'published'");
mysql_query("delete from links where link_status = 'discard'");

?>

[kbeeveer46]

$fourteen_days = 3;

$ninety_days = 3;

the number does not equal days. You have to specify the time in seconds. That's why it looks like this for fourteen days

$fourteen_days = 1209600;