score2) OR (team2 = r.team_name AND score2 > score1))) AS wins, (SELECT COUNT(*) FROM BATTLEDATA WHERE status = 2 AND ((team1 = r.team_name AND score1 < score2) OR (team2 = r.team_name AND score2 < score1))) AS losses FROM robots r JOIN users u ON r.user_id = u.id ORDER BY r.rating DESC "; $ranking = $conn->query($sql); ?> <?php echo $t['title_hof']; ?>

num_rows > 0) { $pos = 1; while($row = $ranking->fetch_assoc()) { $class = ""; $medal = "#$pos"; if ($pos == 1) { $class = "rank-1"; $medal = "🥇 1º"; } elseif ($pos == 2) { $class = "rank-2"; $medal = "🥈 2º"; } elseif ($pos == 3) { $class = "rank-3"; $medal = "🥉 3º"; } echo ""; echo ""; echo ""; echo ""; // Colunas de Vitórias e Derrotas com badges coloridos echo ""; echo ""; echo ""; echo ""; $pos++; } } else { echo ""; } ?>
Elo
$medal" . htmlspecialchars($row['team_name']) . "" . htmlspecialchars($row['username']) . "" . $row['wins'] . "" . $row['losses'] . "⭐ " . $row['rating'] . "
" . $t['no_ranking'] . "
close(); ?>