<?php
include __DIR__ . '/../src/config/koneksi.php';
header('Content-Type: text/plain; charset=utf-8');

echo "Simulating an assisted row older than 31 days...\n";

$q = "SELECT id FROM lokasi WHERE 1 LIMIT 1";
$res = $conn->query($q);
if(!$res){
    echo "Failed to select: " . $conn->error . "\n";
    exit(1);
}
$row = $res->fetch_assoc();
if(!$row){
    echo "No rows in lokasi to simulate.\n";
    exit(1);
}
$id = intval($row['id']);
echo "Using id = $id\n";

$u = "UPDATE lokasi SET assisted = 1, last_assisted_at = DATE_SUB(NOW(), INTERVAL 31 DAY) WHERE id = $id";
if($conn->query($u)){
    echo "Updated id $id. Affected rows: " . $conn->affected_rows . "\n";
} else {
    echo "Failed to update: " . $conn->error . "\n";
    exit(1);
}

echo "Done.\n";
?>