26 lines
742 B
PHP
Executable File
26 lines
742 B
PHP
Executable File
<?php
|
|
require_once __DIR__ . '/config/config.php';
|
|
require_once __DIR__ . '/includes/db.php';
|
|
|
|
if ($argc < 2) {
|
|
echo "Uso: php reset_status.php <schedule_id>\n";
|
|
exit(1);
|
|
}
|
|
|
|
$scheduleId = $argv[1];
|
|
|
|
try {
|
|
$stmt = $pdo->prepare("UPDATE schedules SET status = 'pending', error_message = NULL, sent_at = NULL WHERE id = ?");
|
|
$stmt->execute([$scheduleId]);
|
|
|
|
if ($stmt->rowCount() > 0) {
|
|
echo "El estado del schedule ID {$scheduleId} ha sido reseteado a 'pending'.\n";
|
|
} else {
|
|
echo "No se encontró ningún schedule con el ID {$scheduleId} o ya estaba en estado 'pending'.\n";
|
|
}
|
|
} catch (PDOException $e) {
|
|
echo "Error al actualizar la base de datos: " . $e->getMessage() . "\n";
|
|
exit(1);
|
|
}
|
|
?>
|