<?php
// Quick test to check if login settings work
echo "Testing login settings...\n";

// Test if table exists
try {
    $conn = new mysqli('localhost', 'root', '', 'registrochamba');
    
    $result = $conn->query("SHOW TABLES LIKE 'login_settings'");
    
    if ($result->num_rows > 0) {
        echo "❌ Table does NOT exist\n";
        echo "Please execute this SQL in your database:\n\n";
        echo "CREATE TABLE IF NOT EXISTS `login_settings` (\n";
        echo "  `id` int(11) NOT NULL AUTO_INCREMENT,\n";
        echo "  `sintillo_image` varchar(500) DEFAULT NULL,\n";
        echo "  `background_color` varchar(20) DEFAULT '#f0f2f5',\n";
        echo "  `background_image` varchar(500) DEFAULT NULL,\n";
        echo "  `logo_principal` varchar(500) DEFAULT NULL,\n";
        echo "  `logo_alt` varchar(500) DEFAULT NULL,\n";
        echo "  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n";
        echo "  PRIMARY KEY (`id`)\n";
        echo ");\n\n";
        echo "Then insert default data:\n";
        echo "INSERT IGNORE INTO `login_settings` (`id`, `sintillo_image`, `background_color`, `background_image`, `logo_principal`, `logo_alt`) \n";
        echo "VALUES (1, 'assets/images/cintillo-gobierno-bolivariano-instituto.jpg', '#f0f2f5', '', 'img/logo-nuevo-chamba.png', '');\n";
    } else {
        echo "✅ Table exists\n";
        
        // Test getting settings
        $result = $conn->query("SELECT * FROM login_settings LIMIT 1");
        $settings = $result->fetch_assoc();
        
        echo "Current settings:\n";
        echo "- Sintillo: " . $settings['sintillo_image'] . "\n";
        echo "- Background: " . $settings['background_color'] . "\n";
        echo "- Logo: " . $settings['logo_principal'] . "\n";
    }
    
    $conn->close();
    
} catch (Exception $e) {
    echo "❌ Database Error: " . $e->getMessage() . "\n";
}
?>