<?php

error_reporting(E_ERROR);

require_once __DIR__ . '/application/config/config.php';

$db = new mysqli(
    $config['db_host'],
    $config['db_username'],
    $config['db_password'],
    $config['db_name']
);

if ($db->connect_error) {
    echo 'DB connection failed: ' . $db->connect_error . PHP_EOL;
    exit(1);
}

$db->set_charset('utf8');

$sql = "DELETE FROM azonics_user_events WHERE created_at < DATE_SUB(NOW(), INTERVAL 60 DAY)";
$result = $db->query($sql);

if ($result) {
    echo date('Y-m-d H:i:s') . ' - Deleted ' . $db->affected_rows . ' old user event(s).' . PHP_EOL;
} else {
    echo date('Y-m-d H:i:s') . ' - Error: ' . $db->error . PHP_EOL;
}

$db->close();