aDriv4 website!

Linux premium133.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
LiteSpeed
162.0.232.69

File Name : fetch_winners.php

<?php

include "../database/config.php";
include "../database/temp_db.php";

$contestants_data = [];
$select_contestants = "SELECT * FROM contestants WHERE status = 1";
$select_contestants_result = mysqli_query($conn, $select_contestants);

while ($contestant = mysqli_fetch_assoc($select_contestants_result)) {
    $id = $contestant["id"];
    $name = $contestant["name"];
    $code = $contestant["code"];
    $profile = $contestant["profile"];
    $vote = $contestant["votes"];

// Calculate vote percentage
    $vote_percentage = 0.01 * $vote;

// Calculate other percentages
    $originality_percentage = calculate_percentage($conn, "originality", $code);
    $fan_club_percentage = calculate_percentage($conn, "fan_club", $code);
    $stage_performance_percentage = calculate_percentage($conn, "stage_performance", $code);
    $dressing_percentage = calculate_percentage($conn, "dressing", $code);
    $time_percentage = calculate_percentage($conn, "timing", $code);
    $audience_appeal_percentage = calculate_percentage($conn, "audience_appeal", $code);
    $overall_impression_percentage = calculate_percentage($conn, "overall_impression", $code);

// Calculate final percentage
    $final_percentage = $vote_percentage + $originality_percentage + $stage_performance_percentage +
                        $fan_club_percentage + $dressing_percentage + $time_percentage +
                        $audience_appeal_percentage + $overall_impression_percentage;

// Store contestant data
    $contestants_data[] = [
        'id' => $id,
        'name' => $name,
        'code' => $code,
        'profile' => $profile,
        'final_percentage' => $final_percentage
    ];
}

// Sort contestants by final_percentage in descending order
usort($contestants_data, function ($a, $b) {
    return $b['final_percentage'] <=> $a['final_percentage'];
});

// Output the sorted data
$position = 1;
foreach ($contestants_data as $contestant) {
    ?>
    <div class="col-md-4" style="height: 390px; margin-bottom:235px;">
        <div class="profile_pic">
            <img src="img/contestants/<?= $contestant['profile'] ?>" alt="<?= $contestant['name'] ?>" style="width:100%; height:100%; object-fit: cover; border-radius:30px">
        </div>
        <div class="profile_details text-center" style="margin-top: 24px;">
            <h3 style="color: gold; font-weight:700; margin: 0px; font-size: 32px; -webkit-text-stroke: medium black;">Contestant No.00<?= $contestant['code'] ?></h3>
            <h6 style="color: white; font-weight:400; margin: 0px; font-family: monospace;" class="position-blink">
                <img src="img/position.jpg" alt="" style="border-radius: 50%; width:35px; height:35px"> Position <?= $position ?>
            </h6>
            <h4 style="color: white; font-weight:700; margin: 5px; font-family: cursive;"><?= $contestant['final_percentage'] . "%" ?></h4>
        </div>
    </div>
    <?php
    $position++;
}

// Helper function to calculate percentage
function calculate_percentage($conn, $column, $code) {
    $query = "SELECT SUM($column) AS total_$column FROM final_scores WHERE contestant_code = '$code'";
    $result = mysqli_query($conn, $query);
    $data = mysqli_fetch_assoc($result);
    $total = $data["total_$column"] ?? 0;
    return round($total / 3, 2);
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	mboniqkj/mboniqkj	0755	2025-09-02 04:50:11
..	dir	-	mboniqkj/nobody	0750	2025-12-28 06:54:12
api	dir	-	mboniqkj/mboniqkj	0755	2025-09-30 01:23:52
.htaccess	text/plain	127 B	mboniqkj/mboniqkj	0444	2025-09-01 12:44:23
card_processing.php	text/x-php	1.08 KB	mboniqkj/mboniqkj	0644	2024-04-29 05:11:58
card_voting.php	text/x-php	3.18 KB	mboniqkj/mboniqkj	0644	2024-11-26 07:25:10
check_payment_status.php	text/x-php	2.73 KB	mboniqkj/mboniqkj	0644	2024-11-26 07:25:16
fetch_winners.php	text/x-php	3.32 KB	mboniqkj/mboniqkj	0644	2024-12-19 06:05:07
get_votes.php	text/x-php	591 B	mboniqkj/mboniqkj	0644	2024-11-27 10:55:44
initiate_payment.php	text/x-php	2.36 KB	mboniqkj/mboniqkj	0644	2024-11-26 07:25:54
jurry_vote.php	text/x-php	1.5 KB	mboniqkj/mboniqkj	0644	2024-12-19 06:05:25
vote.php	text/x-php	5.53 KB	mboniqkj/mboniqkj	0644	2024-08-26 02:10:22

For more Private tool come to me!

https://t.me/aDriv4vz