Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-687.39.1.el9_8.x86_64

PHP Version:

8.2.33

User:

flightbo

Directory:

/home2/flightbo/public_html/ibvte.com

Free Space:

130.46 GB

🔧 Quick Actions

✏️ Editing: db_patch.php

<?php
/**
 * DB Patch - Add missing columns for Affiliations Revamp
 */
require_once __DIR__ . '/config.php';
require_once __DIR__ . '/includes/db.php';

if (!checkDBConnection()) {
    die("Database connection failed!");
}

$pdo = getDB();

echo "<h3>Running DB Migrations on " . (ENVIRONMENT === 'production' ? 'PRODUCTION' : 'DEVELOPMENT') . " Database...</h3>";
echo "<ul>";

try {
    // Check if column registration_number already exists
    $check = $pdo->query("SHOW COLUMNS FROM `affiliation_applications` LIKE 'registration_number'")->fetch();
    if ($check) {
        echo "<li>Column <b>registration_number</b> already exists. Skipping.</li>";
    } else {
        $pdo->exec("ALTER TABLE `affiliation_applications` ADD COLUMN `registration_number` VARCHAR(100) DEFAULT ''");
        echo "<li style='color:green;'>Column <b>registration_number</b> added successfully!</li>";
    }
} catch (Exception $e) {
    echo "<li style='color:red;'>Error adding registration_number: " . htmlspecialchars($e->getMessage()) . "</li>";
}

echo "</ul>";
echo "<h4>DB Migrations Completed!</h4>";

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: db_patch.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation