26th February 2020, 23:10
|
|
Senior Member
|
|
Join Date: Jan 2008
Posts: 172
|
|
something like that
Quote:
$secs = 45*86400;
$dt = sqlesc(get_date_time(gmtime() - $secs)); // calculate date.
$maxclass = UC_POWER_USER;
mysql_query("DELETE FROM users WHERE parked='no' AND status='confirmed' AND class <= $maxclass AND last_access < $dt");
|
|