��JFIF��`�`��Viewing File: /home/u820193700/domains/throtllr.com/public_html/backend/fix_premium_features.php

<?php
require_once 'api/db.php';
header('Content-Type: text/plain');

$columns = [
    'route_description' => 'TEXT',
    'tarmac_pc' => 'INT(11) DEFAULT 70',
    'offroad_pc' => 'INT(11) DEFAULT 30',
    'max_altitude' => 'VARCHAR(50) DEFAULT "14,500 ft"',
    'route_image_url' => 'VARCHAR(255)'
];

echo "Checking tours table columns...\n";
foreach ($columns as $col => $type) {
    $res = $conn->query("SHOW COLUMNS FROM tours LIKE '$col'");
    if ($res->num_rows == 0) {
        echo "Adding column $col...\n";
        if ($conn->query("ALTER TABLE tours ADD COLUMN $col $type")) {
            echo "Successfully added $col.\n";
        }
        else {
            echo "Failed to add $col: " . $conn->error . "\n";
        }
    }
    else {
        echo "Column $col already exists.\n";
    }
}

echo "\nChecking tour_packages table columns...\n";
foreach ($columns as $col => $type) {
    if ($col === 'route_image_url')
        $type = 'VARCHAR(255)'; // adjustment if needed
    $res = $conn->query("SHOW COLUMNS FROM tour_packages LIKE '$col'");
    if ($res->num_rows == 0) {
        echo "Adding column $col to tour_packages...\n";
        if ($conn->query("ALTER TABLE tour_packages ADD COLUMN $col $type")) {
            echo "Successfully added $col to tour_packages.\n";
        }
        else {
            echo "Failed to add $col: " . $conn->error . "\n";
        }
    }
    else {
        echo "Column $col already exists in tour_packages.\n";
    }
}

echo "\nEnsuring booking supporting tables exist...\n";
$conn->query("CREATE TABLE IF NOT EXISTS booking_passengers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    booking_id INT NOT NULL,
    full_name VARCHAR(255) NOT NULL,
    age INT,
    gender VARCHAR(10),
    emergency_contact VARCHAR(50),
    FOREIGN KEY (booking_id) REFERENCES bookings(id) ON DELETE CASCADE
)");

$conn->query("CREATE TABLE IF NOT EXISTS booking_addons (
    id INT AUTO_INCREMENT PRIMARY KEY,
    booking_id INT NOT NULL,
    addon_id INT NOT NULL,
    price_snapshot DECIMAL(10,2) NOT NULL,
    FOREIGN KEY (booking_id) REFERENCES bookings(id) ON DELETE CASCADE,
    FOREIGN KEY (addon_id) REFERENCES tour_addons(id) ON DELETE CASCADE
)");

echo "\nEnsuring upload directory exists...\n";
$upload_dir = __DIR__ . '/../frontend/uploads/tours/';
if (!is_dir($upload_dir)) {
    if (mkdir($upload_dir, 0777, true)) {
        echo "Created directory: $upload_dir\n";
    }
    else {
        echo "Failed to create directory: $upload_dir\n";
    }
}
else {
    echo "Upload directory already exists.\n";
}

echo "\nDone.\n";
?>

Back to Directory ��}�!1AQa"q2��#B��R��$3br� %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz�� w�!1AQaq"2�B�� #3R�br� $4�%�&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz��?��_��+��?��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��(��