View file update_db_bot.php

<?php
require 'db.php';

try {
    $columns = $pdo->query("SHOW COLUMNS FROM rooms LIKE 'bot_active'")->fetchAll();
    if (empty($columns)) {
        $pdo->exec("ALTER TABLE rooms ADD COLUMN bot_active TINYINT(1) DEFAULT 0");
        echo "Added bot_active column to rooms table.<br>";
    } else {
        echo "bot_active column already exists.<br>";
    }
    echo "Database update complete.";
} catch (PDOException $e) {
    echo "Error: " . $e->getMessage();
}
?>