Custom Functions

function get_latest_public_event() {
    global $db;
    $sql = "
        SELECT eb.id AS booking_id,
               eb.event_id,
               eb.custom_image_path,
               eb.air_date,
               e.name,
               e.image_path
        FROM event_bookings eb
        JOIN events e ON eb.event_id = e.id
        WHERE eb.booking_status = 'PUBLIC'
        ORDER BY eb.air_date DESC
        LIMIT 1
    ";
    if ($stmt = $db->prepare($sql)) {
        $stmt->execute();
        $res = $stmt->get_result();
        return $res->fetch_assoc() ?: false;
    }
    return false;
}

function display_latest_public_event_highlight() {
    $event = get_latest_public_event();
    if (!$event) {
        echo '<div class="cf-placeholder">No latest event found</div>';
        return;
    }
    $filename = $event['custom_image_path'] ?: $event['image_path'];
    $url      = '/uploads/show-logos/' . rawurlencode($filename);
    $link     = "/event/" . (int)$event['booking_id'];
    $name     = htmlspecialchars($event['name'], ENT_QUOTES, 'UTF-8');
    $date     = date('F j, Y', strtotime($event['air_date']));
    $text     = "{$name} – {$date}";

    echo '<div class="cf-box">'
       . '<a href="' . $link . '" class="cf-box__link">'
       . '<img src="' . $url . '" alt="' . $name . '">'
       . '<div class="cf-badge cf-badge--topleft">LATEST EVENT</div>'
       . '<div class="cf-badge cf-badge--bottomright">' . $text . '</div>'
       . '</a>'
       . '</div>';
}

function get_next_upcoming_event() {
    global $db;
    $sql = "
        SELECT eb.id AS booking_id,
               eb.event_id,
               eb.custom_image_path,
               eb.air_date,
               e.name,
               e.image_path
        FROM event_bookings eb
        JOIN events e ON eb.event_id = e.id
        WHERE eb.booking_status = 'BOOKING'
          AND eb.air_date >= CURDATE()
        ORDER BY eb.air_date ASC
        LIMIT 1
    ";
    if ($stmt = $db->prepare($sql)) {
        $stmt->execute();
        $res = $stmt->get_result();
        return $res->fetch_assoc() ?: false;
    }
    return false;
}

function display_next_upcoming_event_highlight() {
    $event = get_next_upcoming_event();
    if (!$event) return;
    $filename = $event['custom_image_path'] ?: $event['image_path'];
    $url      = '/uploads/show-logos/' . rawurlencode($filename);
    $link     = "/preview/" . (int)$event['booking_id'];
    $name     = htmlspecialchars($event['name'], ENT_QUOTES, 'UTF-8');
    $date     = date('F j, Y', strtotime($event['air_date']));
    $text     = "{$name} – {$date}";

    echo '<div class="cf-box">'
       . '<a href="' . $link . '" class="cf-box__link">'
       . '<img src="' . $url . '" alt="' . $name . '">'
       . '<div class="cf-badge cf-badge--topleft">UPCOMING EVENT</div>'
       . '<div class="cf-badge cf-badge--bottomright">' . $text . '</div>'
       . '</a>'
       . '</div>';
}

function display_current_champions_highlight() {
    $link = '/champions';
    $img  = 'https://ironcity.wrestleuta.com/uploads/title-images/1758640556_trustfundtitle.png';
    echo '<div class="cf-box">'
       . '<a href="' . $link . '" class="cf-box__link">'
       . '<img src="' . $img . '" alt="Current Champions">'
       . '<div class="cf-badge cf-badge--topleft">CURRENT</div>'
       . '<div class="cf-badge cf-badge--bottomright">CHAMPIONS</div>'
       . '</a>'
       . '</div>';
}

function get_random_active_quote() {
    global $db;
    $sql = "
        SELECT cq.quote AS quote_text,
               c.name AS character_name
        FROM character_quotes cq
        JOIN characters c ON cq.character_id = c.id
        WHERE c.alumni = 0
          AND c.deleted = 0
          AND cq.is_deleted = 0
        ORDER BY RAND()
        LIMIT 1
    ";
    if ($stmt = $db->prepare($sql)) {
        $stmt->execute();
        $res = $stmt->get_result();
        return $res->fetch_assoc() ?: false;
    }
    return false;
}

function display_random_active_quote() {
    $row = get_random_active_quote();
    echo '<div class="cf-section-header">RANDOM QUOTE</div>';
    if (!$row) {
        echo '<div class="cf-empty-block">No quotes available.</div>';
        return;
    }
    $quote = htmlspecialchars($row['quote_text'], ENT_QUOTES, 'UTF-8');
    $name  = htmlspecialchars($row['character_name'], ENT_QUOTES, 'UTF-8');
    echo '<div class="cf-quote-block">'
       . '<blockquote>“' . $quote . '”</blockquote>'
       . '<p>— ' . $name . '</p>'
       . '</div>';
}

function get_random_active_fact() {
    global $db;
    $sql = "
        SELECT cf.fact AS fact_text,
               c.name AS character_name
        FROM character_facts cf
        JOIN characters c ON cf.character_id = c.id
        WHERE c.alumni = 0
          AND c.deleted = 0
          AND cf.is_deleted = 0
        ORDER BY RAND()
        LIMIT 1
    ";
    if ($stmt = $db->prepare($sql)) {
        $stmt->execute();
        $res = $stmt->get_result();
        return $res->fetch_assoc() ?: false;
    }
    return false;
}

function display_random_active_fact() {
    $row = get_random_active_fact();
    echo '<div class="cf-section-header">RANDOM FACT</div>';
    if (!$row) {
        echo '<div class="cf-empty-block">No facts available.</div>';
        return;
    }
    $fact = htmlspecialchars($row['fact_text'], ENT_QUOTES, 'UTF-8');
    $name = htmlspecialchars($row['character_name'], ENT_QUOTES, 'UTF-8');
    echo '<div class="cf-fact-block">'
       . '<p>' . $name . ':</p>'
       . '<blockquote>“' . $fact . '”</blockquote>'
       . '</div>';
}

function get_top_power_rankings() {
    global $db;

    $snap = $db->query("SELECT id, week_start FROM power_ranking_snapshots ORDER BY week_start DESC LIMIT 1")->fetch_assoc();
    if (!$snap) {
        return [];
    }

    $snapshotId = (int)$snap['id'];

    $sql = "
        SELECT
            c.name,
            r.total_points,
            r.movement
        FROM power_ranking_scores r
        JOIN characters c ON c.id = r.character_id
        JOIN bio_configs bc ON c.config_id = bc.id
        JOIN bio_config_styles bcs ON bc.style_id = bcs.id
        WHERE r.snapshot_id = ?
          AND (c.deleted = 0 OR c.deleted IS NULL)
          AND bcs.name = 'Singles'
          AND (c.alumni = 0 OR c.alumni IS NULL)
          AND (c.injured = 'No' OR c.injured IS NULL OR c.injured = '')
        ORDER BY r.total_points DESC, c.name ASC
        LIMIT 10
    ";

    $stmt = $db->prepare($sql);
    $stmt->bind_param('i', $snapshotId);
    $stmt->execute();
    $res = $stmt->get_result();

    $results = [];
    $prevPoints = null;
    $rank = 0;
    $count = 0;

    while ($row = $res->fetch_assoc()) {
        $count++;
        $cur = (float)$row['total_points'];

        if ($prevPoints !== $cur) {
            $rank = $count;
            $prevPoints = $cur;
        }

        $mv = $row['movement'] ?: 'same';
        $arrow = $mv === 'up' ? '▲' : ($mv === 'down' ? '▼' : '＝');

        $results[] = [
            'rank'   => $rank,
            'name'   => $row['name'],
            'points' => $cur,
            'arrow'  => $arrow
        ];
    }

    $stmt->close();
    return $results;
}

function display_top_power_rankings() {
    $rankings = get_top_power_rankings();
    echo '<h5 class="section-title mt-4">POWER RANKINGS</h5>';
    echo '<div class="cf-section">';
    if (empty($rankings)) {
        echo '<div>No power rankings available.</div>';
    } else {
        foreach ($rankings as $item) {
            echo '<div class="cf-ranking-item">#'.$item['rank'].' '.htmlspecialchars($item['name'], ENT_QUOTES, 'UTF-8').' — '.number_format($item['points'],2).' pts '.$item['arrow'].'</div>';
        }
        echo '<p align="right"><a href="/power-rankings">FULL RANKINGS →</a></p>';
    }
    echo '</div>';
}

function get_latest_promos($limit = 5) {
    global $db;
    $sql = "
        SELECT p.character_id, p.slug, c.name
        FROM promos p
        JOIN characters c ON p.character_id = c.id
        WHERE p.is_draft = 0
        AND p.is_deleted = 0
        AND c.deleted = 0
        ORDER BY p.created_at DESC
        LIMIT ?
    ";
    if ($stmt = $db->prepare($sql)) {
        $stmt->bind_param('i', $limit);
        $stmt->execute();
        $res = $stmt->get_result();
        $arr = [];
        while ($row = $res->fetch_assoc()) $arr[] = $row;
        return $arr;
    }
    return [];
}

function display_latest_promos() {
    $promos = get_latest_promos(5);
    echo '<div class="cf-section-header">LATEST PROMOS</div>';
    echo '<div class="cf-section">';
    if (empty($promos)) {
        echo '<div>No promos available.</div>';
    } else {
        echo '<div class="cf-promos-list">';
        foreach ($promos as $p) {
            $id = (int)$p['character_id'];
            $slug = htmlspecialchars($p['slug'], ENT_QUOTES, 'UTF-8');
            $name = htmlspecialchars($p['name'], ENT_QUOTES, 'UTF-8');
            $img = "/render_character_image.php?character_id={$id}&series_id=3";
            echo '<a href="/promo/'.$slug.'" title="'.$name.'" class="cf-promo-link">';
            echo '<img src="'.$img.'" alt="'.$name.'" class="cf-promo-img">';
            echo '</a>';
        }
        echo '</div>';
    }
    echo '</div>';
}

function get_upcoming_booking_events($limit = 5) {
    global $db;
    $sql = "
        SELECT eb.id AS booking_id, eb.event_id, eb.custom_image_path, eb.air_date, e.name, e.image_path
        FROM event_bookings eb
        JOIN events e ON eb.event_id = e.id
        WHERE eb.booking_status = 'BOOKING'
          AND eb.air_date >= CURDATE()
        ORDER BY eb.air_date ASC
        LIMIT ?
    ";
    if ($stmt = $db->prepare($sql)) {
        $stmt->bind_param('i', $limit);
        $stmt->execute();
        $res = $stmt->get_result();
        $arr = [];
        while ($row = $res->fetch_assoc()) $arr[] = $row;
        return $arr;
    }
    return [];
}

function display_upcoming_booking_events_list($limit = 5) {
    $events = get_upcoming_booking_events($limit);
    if (empty($events)) {
        echo '<div class="cf-empty-list">No upcoming events in booking status.</div>';
        return;
    }
    echo '<ul class="cf-list">';
    foreach ($events as $ev) {
        $fn = $ev['custom_image_path'] ?: $ev['image_path'];
        $url = '/preview/'.(int)$ev['booking_id'];
        $dt = date('F j, Y', strtotime($ev['air_date']));
        $nm = htmlspecialchars($ev['name'], ENT_QUOTES, 'UTF-8');
        echo '<li class="cf-list-item"><a href="'.$url.'" class="cf-list-link">';
        echo '<img src="/uploads/show-logos/'.rawurlencode($fn).'" alt="" class="cf-list-icon">';
        echo $nm.' – '.$dt;
        echo '</a></li>';
    }
    echo '</ul>';
}

function get_character_music() {
    global $db;
    $sql = "
        SELECT cm.character_id, cm.song_title, cm.filename, c.name AS character_name
        FROM character_music cm
        JOIN characters c ON cm.character_id = c.id
        WHERE c.deleted = 0
        ORDER BY cm.uploaded_at DESC
    ";
    if ($stmt = $db->prepare($sql)) {
        $stmt->execute();
        $res = $stmt->get_result();
        $arr = [];
        while ($row = $res->fetch_assoc()) {
            $arr[] = $row;
        }
        return $arr;
    }
    return [];
}

function display_character_music_player() {
    $songs = get_character_music();
    echo '<div class="cf-section">';
    if (empty($songs)) {
        echo '<div>No theme songs available.</div>';
    } else {
        echo '<audio id="themePlayer" controls class="cf-audio"></audio>';
        echo '<div class="cf-playlist" id="themePlaylist">';
        foreach ($songs as $song) {
            $txt  = htmlspecialchars($song['character_name'].' - '.$song['song_title'], ENT_QUOTES, 'UTF-8');
            $file = '/themesongs/'.rawurlencode($song['filename']);
            echo '<div class="cf-playlist-track" data-src="'.$file.'" title="'.$txt.'">'.$txt.'</div>';
        }
        echo '</div>';
        echo '<script>'
           . '(function(){'
           . 'var player=document.getElementById("themePlayer"),tracks=document.querySelectorAll("#themePlaylist .cf-playlist-track");'
           . 'tracks.forEach(function(t){t.addEventListener("click",function(){tracks.forEach(function(x){x.style.backgroundColor=""});this.style.backgroundColor="rgba(255,215,0,0.2)";player.src=this.getAttribute("data-src");player.play();});});'
           . 'if(tracks.length>0){tracks[0].style.backgroundColor="rgba(255,215,0,0.2)";player.src=tracks[0].getAttribute("data-src");}'
           . '})();'
           . '</script>';
    }
    echo '</div>';
}

function get_latest_public_events($limit = 5) {
    global $db;
    $sql = "
        SELECT eb.id AS booking_id, eb.event_id, eb.custom_image_path, eb.air_date, e.name, e.image_path
        FROM event_bookings eb
        JOIN events e ON eb.event_id = e.id
        WHERE eb.booking_status = 'PUBLIC'
          AND eb.air_date <= CURDATE()
        ORDER BY eb.air_date DESC
        LIMIT ?
    ";
    if ($stmt = $db->prepare($sql)) {
        $stmt->bind_param('i', $limit);
        $stmt->execute();
        $res = $stmt->get_result();
        $arr = [];
        while ($row = $res->fetch_assoc()) $arr[] = $row;
        return $arr;
    }
    return [];
}

function display_latest_public_events_list($limit = 5) {
    $events = get_latest_public_events($limit);
    if (empty($events)) {
        echo '<div class="cf-empty-list">No recent public events found.</div>';
        return;
    }
    echo '<ul class="cf-list">';
    foreach ($events as $ev) {
        $fn = $ev['custom_image_path'] ?: $ev['image_path'];
        $url = '/event/'.(int)$ev['booking_id'];
        $dt = date('F j, Y', strtotime($ev['air_date']));
        $nm = htmlspecialchars($ev['name'], ENT_QUOTES, 'UTF-8');
        echo '<li class="cf-list-item"><a href="'.$url.'" class="cf-list-link">';
        echo '<img src="/uploads/show-logos/'.rawurlencode($fn).'" alt="" class="cf-list-icon">';
        echo $nm.' – '.$dt;
        echo '</a></li>';
    }
    echo '</ul>';
}

function get_current_superstar_of_week() {
    global $db;
    $sql = "
        SELECT cap.winner_id, c.name AS character_name, cap.start_date, cap.end_date
        FROM character_award_periods cap
        JOIN character_awards ca ON cap.award_id = ca.id
        JOIN characters c ON cap.winner_id = c.id
        WHERE ca.name = 'Superstar of the Week'
          AND cap.winner_id IS NOT NULL
          AND cap.end_date <= CURDATE()
        ORDER BY cap.end_date DESC
        LIMIT 1
    ";
    if ($stmt = $db->prepare($sql)) {
        $stmt->execute();
        $res = $stmt->get_result();
        return $res->fetch_assoc() ?: false;
    }
    return false;
}

function display_current_superstar_of_week() {
    $award = get_current_superstar_of_week();
    echo '<h5 class="section-title">SUPERSTAR OF THE WEEK</h5>';
    if (!$award) {
        echo '<div class="cf-section">No Superstar of the Week selected yet.</div>';
        return;
    }
    $id   = (int)$award['winner_id'];
    $name = htmlspecialchars($award['character_name'], ENT_QUOTES, 'UTF-8');
    $date = date('F j, Y', strtotime($award['end_date']));
    $img  = "/render_character_image.php?character_id={$id}&series_id=3";
    $url  = "/roster/{$id}";

    echo '<div class="cf-superstar">'
       . '<a href="' . $url . '" class="cf-superstar-link">'
       . '<img src="' . $img . '" alt="' . $name . '" class="cf-superstar-img">'
       . '</a>'
       . '<div>'
       . '<p class="cf-superstar-name">' . $name . '</p>'
       . '<p class="cf-superstar-date">Awarded: ' . $date . '</p>'
       . '</div>'
       . '</div>';
}

function discord_notify(string $webhookUrl, string $message): void {
    $payload = json_encode(['content' => $message]);
    $ch = curl_init($webhookUrl);
    curl_setopt_array($ch, [
        CURLOPT_POST           => true,
        CURLOPT_POSTFIELDS     => $payload,
        CURLOPT_HTTPHEADER     => ['Content-Type: application/json'],
        CURLOPT_RETURNTRANSFER => true,
    ]);
    curl_exec($ch);
    curl_close($ch);
}

function get_current_superstar_of_month() {
    global $db;
    $sql = "
        SELECT cap.winner_id, c.name AS character_name, cap.start_date, cap.end_date
        FROM character_award_periods cap
        JOIN character_awards ca ON cap.award_id = ca.id
        JOIN characters c ON cap.winner_id = c.id
        WHERE ca.name = 'Superstar of the Month'
          AND cap.winner_id IS NOT NULL
          AND cap.end_date <= CURDATE()
        ORDER BY cap.end_date DESC
        LIMIT 1
    ";
    if ($stmt = $db->prepare($sql)) {
        $stmt->execute();
        $res = $stmt->get_result();
        return $res->fetch_assoc() ?: false;
    }
    return false;
}

function display_current_superstar_of_month() {
    $award = get_current_superstar_of_month();
    echo '<h5 class="section-title">SUPERSTAR OF THE MONTH</h5>';
    if (!$award) {
        echo '<div class="cf-section">No Superstar of the Month selected yet.</div>';
        return;
    }
    $id   = (int)$award['winner_id'];
    $name = htmlspecialchars($award['character_name'], ENT_QUOTES, 'UTF-8');
    $date = date('F j, Y', strtotime($award['end_date']));
    $img  = "/render_character_image.php?character_id={$id}&series_id=3";
    $url  = "/roster/{$id}";

    echo '<div class="cf-superstar">'
       . '<a href="' . $url . '" class="cf-superstar-link">'
       . '<img src="' . $img . '" alt="' . $name . '" class="cf-superstar-img">'
       . '</a>'
       . '<div>'
       . '<p class="cf-superstar-name">' . $name . '</p>'
       . '<p class="cf-superstar-date">Awarded: ' . $date . '</p>'
       . '</div>'
       . '</div>';
}

function get_recent_zaps($db, $limit = 3) {
    if (!is_numeric($limit) || $limit <= 0) $limit = 3;

    $stmt = $db->prepare("
        SELECT z.id, z.character_id, z.content, z.created_at, c.name
        FROM xconnect_zaps z
        JOIN characters c ON c.id = z.character_id
        WHERE z.is_deleted = 0
        ORDER BY z.created_at DESC
        LIMIT ?
    ");
    $stmt->bind_param("i", $limit);
    $stmt->execute();
    $result = $stmt->get_result();

    while ($zap = $result->fetch_assoc()) {
        $charId   = (int)$zap['character_id'];
        $charName = htmlspecialchars($zap['name']);
        $avatar   = "/render_character_image.php?character_id={$charId}&series_id=3";
        $date     = date("M j, Y", strtotime($zap['created_at']));

        $content = trim($zap['content']);
        $content = preg_replace('/\n{3,}/', "\n\n", $content);
        $content = preg_replace('/#(\w+)/', '<span class="hashtag">#$1</span>', $content);
        $content = preg_replace('/#(\w+)/', '<span class="hashtag">#$1</span>', $content);

        echo <<<HTML
<div class="zap-mini-card">
    <div class="zap-header-row">
        <img src="{$avatar}" alt="{$charName}" class="zap-mini-avatar">
        <div class="zap-header-text">
            <div class="name-line"><strong>{$charName}</strong> <span class="date-line">{$date}</span></div>
        </div>
    </div>
    <div class="zap-mini-content">{$content}</div>
</div>
HTML;
    }

    $stmt->close();
}

function displayRandomChamp() {
    global $db;

    $result = $db->query("SELECT * FROM titles WHERE active = 1 AND image_path IS NOT NULL");
    $titles = [];
    while ($row = $result->fetch_assoc()) {
        $titles[] = $row;
    }

    if (empty($titles)) {
        echo "No active titles found.";
        return;
    }

    $selected = $titles[array_rand($titles)];
    $titleImagePath = 'uploads/title-images/' . $selected['image_path'];
    $titleName = $selected['name'];
    $championId = $selected['current_champion_id'];

    $championName = "Vacant";
    $championImagePath = null;

    if (!empty($championId)) {
        $stmt = $db->prepare("
            SELECT ci.image_file, c.name
            FROM character_images ci
            JOIN characters c ON c.id = ci.character_id
            WHERE ci.character_id = ? AND ci.series_id = 3
            ORDER BY ci.id ASC LIMIT 1
        ");
        $stmt->bind_param("i", $championId);
        $stmt->execute();
        $stmt->bind_result($championImage, $championNameResult);
        $stmt->fetch();
        $stmt->close();

        if (!empty($championNameResult)) {
            $championName = $championNameResult;
        }

        if (!empty($championImage)) {
            $championImagePath = 'images/characters/characters/' . $championImage;
        }
    }

    $backgroundPath = 'images/characters/background/championship_bg.jpg';

    $queryParams = [
        'background' => $backgroundPath,
        'title'      => $titleImagePath
    ];

    if (!empty($championImagePath)) {
        $queryParams['champion'] = $championImagePath;
    }

    $renderUrl = '/render_random_champion.php?' . http_build_query($queryParams);

    echo '<div class="cf-box">'
       . '<a href="/champions" class="cf-box__link">'
       . '<img src="' . htmlspecialchars($renderUrl) . '" alt="Random Champion">'
       . '<div class="cf-badge cf-badge--topleft">CURRENT CHAMPION</div>'
       . '<div class="cf-badge cf-badge--bottomright">'
       .     '<div class="badge-title">' . htmlspecialchars($titleName, ENT_QUOTES, 'UTF-8') . '</div>'
       .     '<div class="badge-champ">' . htmlspecialchars($championName, ENT_QUOTES, 'UTF-8') . '</div>'
       . '</div>'
       . '</a>'
       . '</div>';
}