I created a file to keep my db clean, but cannot get it to work.
Someone told me to use it as a cron file, so it gets activated by time or so.
I named the file scheduler.php and here is the code.
Do i have to change something in this or is there another way to get it to work?
Thx
Marc
#!/usr/bin/php -q
<?
$r_users = q("SELECT * FROM dt_members WHERE system_status='1' AND system_status_end<='".(strtotime(date("d M Y H:i:s")))."'");
while($f_user = f($r_users))
{
q("UPDATE dt_members SET system_status='0' AND system_status_end='-1' WHERE id='$f_user[id]'");
mailSend($f_user[ email ], "service expired");
}
$r_users = q("SELECT * FROM dt_members WHERE unlimited='1' AND unlimited_end<='".(strtotime(date("d M Y H:i:s")))."'");
while($f_user = f($r_users))
{
q("UPDATE dt_members SET unlimited='0' AND unlimited_end='-1' WHERE id='$f_user[id]'");
mailSend($f_user[ email ], "unlimited service expired");
}
$r_users = q("SELECT * FROM dt_prepared_members WHERE idate-".(strtotime(date("d M Y H:i:s")))." > 172800");
while($f_user = f($r_users))
{
q("DELETE FROM dt_prepared_members WHERE id='$f_user[id]'");
}
$r_users = q("SELECT * FROM dt_profile WHERE lastlogin > $lastlogin" > 1);
$lastlogin = mktime() - 9000;
while($f_user = f($r_users))
{
q("DELETE FROM dt_members, dt_profile WHERE id='$f_user[id]'");
}
?>
