ilham_gmail
14 lines
556 B
PHP
14 lines
556 B
PHP
<?php
|
|
include __DIR__ . '/../src/config/koneksi.php';
|
|
header('Content-Type: text/plain; charset=utf-8');
|
|
|
|
echo "Running assistance expiry (30 days)...\n";
|
|
$q = "UPDATE lokasi SET assisted = 0, last_assisted_at = NULL, sumber_bantuan = NULL, bentuk_bantuan = NULL, assistance_notes = NULL WHERE assisted = 1 AND last_assisted_at IS NOT NULL AND last_assisted_at <= DATE_SUB(NOW(), INTERVAL 30 DAY)";
|
|
if($conn->query($q)){
|
|
echo "OK. Affected rows: " . $conn->affected_rows . "\n";
|
|
} else {
|
|
echo "Failed: " . $conn->error . "\n";
|
|
}
|
|
echo "Done.\n";
|
|
?>
|