Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.84.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u176134211

Directory:

/home/u176134211/domains/chikhalikar.com/public_html/cron

Free Space:

8.3 TB

🔧 Quick Actions

✏️ Editing: cleanup_tokens.php

<?php
// cron/cleanup_tokens.php - Run Hourly (7.2)

// Define the time offsets (in days) for cleanup
define('TOKEN_RETENTION_DAYS', 3); // Remove OTP/Reset tokens older than 3 days
define('RATE_LIMIT_RETENTION_DAYS', 30); // Keep rate limits for abuse analysis for 30 days

// Load configuration and PDO connection
// Note: We redefine the path to config.php as cron scripts run outside the web root context in some hosting environments.
// For shared/VPS hosting where cron runs from the project root, this path should be accurate.
require_once __DIR__ . '/../config.php';

$now = date('Y-m-d H:i:s');
$success_count = 0;
$error_flag = false;

echo "--- CHIKHALIKAR TOKEN CLEANUP STARTED: {$now} ---\n";

try {
    // 1. Cleanup expired or used OTP codes (2.3)
    $cutoff_otp = date('Y-m-d H:i:s', strtotime("-". TOKEN_RETENTION_DAYS ." days"));
    $stmt = $pdo->prepare("DELETE FROM otp_codes WHERE used_at IS NOT NULL OR expires_at < ?");
    $stmt->execute([$cutoff_otp]);
    $deleted_otp = $stmt->rowCount();
    $success_count += $deleted_otp;
    echo "Deleted {$deleted_otp} expired/used OTP codes.\n";

// 2. Cleanup expired or used Password Reset tokens (2.8)
    $cutoff_reset = date('Y-m-d H:i:s', strtotime("-". TOKEN_RETENTION_DAYS ." days"));
    $stmt = $pdo->prepare("DELETE FROM password_resets WHERE used_at IS NOT NULL OR expires_at < ?");
    $stmt->execute([$cutoff_reset]);
    $deleted_resets = $stmt->rowCount();
    $success_count += $deleted_resets;
    echo "Deleted {$deleted_resets} expired/used Password Reset tokens.\n";
    
    // 3. Cleanup expired QR Login tokens (2.5)
    $cutoff_qr = date('Y-m-d H:i:s', strtotime("-". TOKEN_RETENTION_DAYS ." days"));
    $stmt = $pdo->prepare("DELETE FROM qr_logins WHERE status != 'pending' OR expires_at < ?");
    $stmt->execute([$cutoff_qr]);
    $deleted_qr = $stmt->rowCount();
    $success_count += $deleted_qr;
    echo "Deleted {$deleted_qr} expired/used QR Login tokens.\n";

// 4. Cleanup old Rate Limits (2.6)
    $cutoff_rate_limit = date('Y-m-d H:i:s', strtotime("-". RATE_LIMIT_RETENTION_DAYS ." days"));
    $stmt = $pdo->prepare("DELETE FROM rate_limits WHERE period_start < ?");
    $stmt->execute([$cutoff_rate_limit]);
    $deleted_rate = $stmt->rowCount();
    $success_count += $deleted_rate;
    echo "Deleted {$deleted_rate} old rate limit entries.\n";

} catch (PDOException $e) {
    echo "FATAL ERROR during token cleanup: " . $e->getMessage() . "\n";
    $error_flag = true;
}

echo "--- CHIKHALIKAR TOKEN CLEANUP FINISHED. Total deleted records: {$success_count} ---\n";
exit($error_flag ? 1 : 0); // Exit code 0 for success, 1 for error
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: cleanup_tokens.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation