<?php
// Cricket Exchange - Database Configuration
define('DB_HOST', 'localhost');
define('DB_USER', 'flightbo_game');
define('DB_PASS', 'flightbo_game');
define('DB_NAME', 'flightbo_game');

define('SITE_URL', 'https://skycrestaviationacademy.com/cricket-exchange');
define('ADMIN_URL', SITE_URL . '/admin');
define('SITE_NAME', 'Cricket Exchange');

// Session configuration
ini_set('session.cookie_httponly', 1);
ini_set('session.use_only_cookies', 1);
session_start();

// Database connection
mysqli_report(MYSQLI_REPORT_OFF);
$db_connected = false;
$conn = @new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
if (!$conn || $conn->connect_error) {
    $conn = @new mysqli('162.55.65.66', DB_USER, DB_PASS, DB_NAME);
}
if ($conn && !$conn->connect_error) {
    $db_connected = true;
    $conn->set_charset('utf8mb4');
}

// Helper functions
function sanitize($data) {
    global $conn, $db_connected;
    $clean = htmlspecialchars(strip_tags(trim($data)));
    if (!empty($db_connected) && $conn) {
        return mysqli_real_escape_string($conn, $clean);
    }
    return addslashes($clean);
}

function redirect($url) {
    header("Location: $url");
    exit();
}

function isLoggedIn() {
    return isset($_SESSION['user_id']) && isset($_SESSION['role']);
}

function requireLogin($role = null) {
    if (!isLoggedIn()) {
        redirect(SITE_URL . '/admin/index.php');
    }
    if ($role && $_SESSION['role'] !== $role) {
        redirect(SITE_URL . '/admin/index.php');
    }
}

function generateUniqueCode($prefix = 'SA') {
    return $prefix . strtoupper(substr(md5(uniqid(rand(), true)), 0, 8));
}

function formatINR($amount) {
    return '₹' . number_format($amount, 2, '.', ',');
}

function timeAgo($datetime) {
    $time = time() - strtotime($datetime);
    if ($time < 60) return 'just now';
    if ($time < 3600) return floor($time/60) . ' min ago';
    if ($time < 86400) return floor($time/3600) . ' hr ago';
    return date('d M Y', strtotime($datetime));
}
?>