T.ME/BIBIL_0DAY
CasperSecurity


Server : Apache/2
System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64
User : gositeme ( 1004)
PHP Version : 8.2.29
Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname
Directory :  /home/gositeme/.cursor-server/data/User/History/-376c5281/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home/gositeme/.cursor-server/data/User/History/-376c5281/978B.php
<?php
/**
 * Fix call_sign column length
 * Updates call_sign from VARCHAR(10) to VARCHAR(50)
 */

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

$pdo = getDBConnection();

if (!$pdo) {
    die("Database connection failed\n");
}

// Check if running from CLI or web
$is_cli = php_sapi_name() === 'cli';

if (!$is_cli) {
    echo "<!DOCTYPE html><html><head><title>Fix Call Sign Length</title>";
    echo "<style>body{font-family:Arial;padding:2rem;background:#f5f5f5;}";
    echo ".success{color:#10b981;}.error{color:#ef4444;}</style>";
    echo "</head><body><h1>Fix Call Sign Column Length</h1><pre>";
}

try {
    echo "Checking radio_stations table...\n";
    
    // Check current column definition
    $stmt = $pdo->query("SHOW COLUMNS FROM radio_stations WHERE Field = 'call_sign'");
    $column = $stmt->fetch();
    
    if ($column) {
        echo "Current call_sign definition: " . $column['Type'] . "\n";
        
        if (strpos($column['Type'], 'varchar(10)') !== false || strpos($column['Type'], 'varchar(10)') !== false) {
            echo "Updating call_sign from VARCHAR(10) to VARCHAR(50)...\n";
            $pdo->exec("ALTER TABLE radio_stations MODIFY COLUMN call_sign VARCHAR(50) UNIQUE");
            echo "✓ call_sign column updated to VARCHAR(50)\n";
        } else {
            echo "ℹ call_sign column is already VARCHAR(50) or larger\n";
        }
    } else {
        echo "⚠ call_sign column not found\n";
    }
    
    echo "\n✅ Migration completed successfully!\n";
    
    if (!$is_cli) {
        echo "</pre><div style='background:#d1fae5;padding:1rem;border-radius:4px;margin-top:1rem;'>";
        echo "<strong class='success'>✅ Call sign column updated!</strong>";
        echo "<p>You can now register stations with longer call signs.</p>";
        echo "<p><a href='/radio/register.php'>Go to Registration</a></p>";
        echo "</div></body></html>";
    }
    
} catch (PDOException $e) {
    $error = "❌ Error: " . $e->getMessage();
    if ($is_cli) {
        echo $error . "\n";
        exit(1);
    } else {
        echo "</pre><div style='background:#fee2e2;padding:1rem;border-radius:4px;margin-top:1rem;'>";
        echo "<strong class='error'>$error</strong>";
        echo "</div></body></html>";
        exit(1);
    }
}


CasperSecurity Mini