<?php
/**
 * Panel Database Configuration
 * Centralized connection for all selection-related files
 */

function getPanelDBConnection() {
    static $panelPdo = null;
    
    if ($panelPdo === null) {
        try {
            $panelPdo = new PDO(
                'mysql:host=localhost;dbname=u752449863_rrpanel;charset=utf8mb4',
                'u752449863_rrpaneladmin',      // ← UPDATE: Your panel database username
                'S@n@h2016',     // ← UPDATE: Your panel database password
                [
                    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
                    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
                    PDO::ATTR_EMULATE_PREPARES => false
                ]
            );
        } catch (PDOException $e) {
            error_log("Panel database connection failed: " . $e->getMessage());
            throw new Exception('Panel database connection failed: ' . $e->getMessage());
        }
    }
    
    return $panelPdo;
}

// Also check if profiler tables exist
function hasProfilerTables() {
    static $hasTables = null;
    
    if ($hasTables === null) {
        try {
            $pdo = getPanelDBConnection();
            $stmt = $pdo->query("SHOW TABLES LIKE 'profiler_questions'");
            $hasTables = ($stmt->rowCount() > 0);
        } catch (Exception $e) {
            $hasTables = false;
        }
    }
    
    return $hasTables;
}