[prasan21]

I want to delete the old posts from the database, is there any inside the pligg to do it. I want to utilize my database space to the maximum

[kbeeveer46]

http://www.pligg.com/wiki/index.php?...stories_script

Something I put together a long time ago.

[prasan21]

Thanks Can you please throw more light on this code, You mean i have to save this in a separate file or i have to incorporate this below code.
And more im little bit confused on the numbers 1209600 and 7776000 plz explain thanks once again.
<?php

mysql_connect("dbhost", "dbname", "dbpass") or die("error1");
mysql_select_db("dbname") or die("error2");

$fourteen_days = 1209600;
$now = date("U") - $fourteen_days;
$ninety_days = 7776000;
$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]

Those numbers are what 14 and 90 days are in seconds.