26 lines
537 B
PHP
26 lines
537 B
PHP
<?php
|
|
include "db.php";
|
|
|
|
$time = strtotime("2010-05-01 00:00:00");
|
|
$etime = strtotime("2011-08-01 00:00:00");
|
|
|
|
while ($time < $etime) {
|
|
$date = date("Y-m-d",$time);
|
|
|
|
// activity_log
|
|
// db_query("delete FROM activity_log WHERE activity_time < '$time'");
|
|
// sleep(1);
|
|
|
|
// email_send_log
|
|
db_query("delete FROM email_send_log WHERE processed < '$date'");
|
|
// sleep(1);
|
|
|
|
// email_header
|
|
db_query("delete FROM email_header WHERE posted < '$date'");
|
|
|
|
echo(date("Y-m-d",$time)."\n");
|
|
$time += 60 * 60 * 24;
|
|
}
|
|
|
|
?>
|