connect_error) {
die("Connection failed: " . $db->connect_error);
}
$db->set_charset('utf8mb4');
// Function to execute a prepared statement and increment query counter
function executeQuery($db, $sql, $params = [], $types = '') {
global $queryCount;
$queryCount++;
$stmt = $db->prepare($sql);
if (!$stmt) {
return false;
}
if (!empty($params) && !empty($types)) {
$stmt->bind_param($types, ...$params);
}
$result = $stmt->execute();
if (!$result) {
$stmt->close();
return false;
}
$result = $stmt->get_result();
$data = $result ? $result->fetch_all(MYSQLI_ASSOC) : [];
$stmt->close();
return $data;
}
// Function to execute a prepared statement and get single result
function executeQuerySingle($db, $sql, $params = [], $types = '') {
global $queryCount;
$queryCount++;
$stmt = $db->prepare($sql);
if (!$stmt) {
return false;
}
if (!empty($params) && !empty($types)) {
$stmt->bind_param($types, ...$params);
}
$result = $stmt->execute();
if (!$result) {
$stmt->close();
return false;
}
$result = $stmt->get_result();
$data = $result ? $result->fetch_assoc() : false;
$stmt->close();
return $data;
}
// Function to execute a count query
function executeCountQuery($db, $sql, $params = [], $types = '') {
global $queryCount;
$queryCount++;
$stmt = $db->prepare($sql);
if (!$stmt) {
return 0;
}
if (!empty($params) && !empty($types)) {
$stmt->bind_param($types, ...$params);
}
$result = $stmt->execute();
if (!$result) {
$stmt->close();
return 0;
}
$result = $stmt->get_result();
$row = $result ? $result->fetch_assoc() : false;
$stmt->close();
return $row ? (int)$row['total'] : 0;
}
// CSRF protection
if (!isset($_SESSION['csrf_token'])) {
$_SESSION['csrf_token'] = bin2hex(random_bytes(32));
}
function validateCSRF($token) {
return isset($_SESSION['csrf_token']) && hash_equals($_SESSION['csrf_token'], $token);
}
// Function to get player name and avatar from Steam API with caching
function getSteamUserInfo($steamId64, $apiKey) {
$defaultAvatar = 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/fe/fef49e7fa7e1997310d705b2a6158ff8dc1cdfeb_full.jpg';
// Check session cache first (faster than file cache)
$cacheKey = 'steam_user_' . $steamId64;
if (isset($_SESSION[$cacheKey]) && $_SESSION[$cacheKey]['expires'] > time()) {
return $_SESSION[$cacheKey]['data'];
}
// Try file cache (persists across sessions)
$cacheDir = sys_get_temp_dir() . '/steam_cache';
if (!is_dir($cacheDir)) {
@mkdir($cacheDir, 0755, true);
}
$cacheFile = $cacheDir . '/' . $steamId64 . '.json';
if (file_exists($cacheFile) && (time() - filemtime($cacheFile)) < 3600) { // 1 hour cache
$cached = json_decode(file_get_contents($cacheFile), true);
if ($cached) {
$_SESSION[$cacheKey] = ['data' => $cached, 'expires' => time() + 300];
return $cached;
}
}
// Fetch from Steam API
$url = "https://api.steampowered.com/ISteamUser/GetPlayerSummaries/v0002/?key={$apiKey}&steamids={$steamId64}";
$context = stream_context_create(['http' => ['timeout' => 3]]); // 3 second timeout
$response = @file_get_contents($url, false, $context);
$data = json_decode($response, true);
$result = [
'name' => 'Unknown',
'avatar' => $defaultAvatar
];
if (isset($data['response']['players'][0])) {
$player = $data['response']['players'][0];
$result = [
'name' => $player['personaname'] ?? 'Unknown',
'avatar' => $player['avatarfull'] ?? $defaultAvatar
];
}
// Save to cache
@file_put_contents($cacheFile, json_encode($result));
$_SESSION[$cacheKey] = ['data' => $result, 'expires' => time() + 300];
return $result;
}
// MGE-specific functions
function getMGERating($db, $steamId) {
$row = executeQuerySingle($db, "SELECT rating FROM mgemod_stats WHERE steamid = ?", [$steamId], 's');
return $row ? $row['rating'] : null;
}
function getMGEDuels($db, $steamId, $limit = 10) {
$stmt = $db->prepare("
SELECT * FROM (
SELECT
'1v1' AS type,
id,
endtime,
winner,
NULL AS winner2,
loser,
NULL AS loser2,
winnerscore,
loserscore,
winlimit,
mapname,
arenaname,
winnerclass,
NULL AS winner2class,
loserclass,
NULL AS loser2class,
starttime
FROM mgemod_duels
WHERE (winner = ? OR loser = ?)
AND winner IS NOT NULL
AND loser IS NOT NULL
-- AND canceled = 0
UNION ALL
SELECT
'2v2' AS type,
id,
endtime,
winner,
winner2,
loser,
loser2,
winnerscore,
loserscore,
winlimit,
mapname,
arenaname,
winnerclass,
winner2class,
loserclass,
loser2class,
starttime
FROM mgemod_duels_2v2
WHERE (winner = ? OR winner2 = ? OR loser = ? OR loser2 = ?)
AND winner IS NOT NULL
AND loser IS NOT NULL
-- AND canceled = 0
) AS combined
ORDER BY endtime DESC
LIMIT ?
");
$stmt->bind_param('ssssssi',
$steamId, $steamId, // 1v1: winner / loser
$steamId, $steamId, $steamId, $steamId, // 2v2: winner, winner2, loser, loser2
$limit
);
$stmt->execute();
$result = $stmt->get_result();
$duels = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
// If processDuelWinners already exists in your build, keep it.
// Otherwise this is a minimal fallback that sets is_winner.
$processedDuels = [];
foreach ($duels as $duel) {
$isWinner = false;
if ($duel['type'] === '1v1') {
if ($duel['winner'] === $steamId) {
$isWinner = true;
}
} else { // 2v2
if ($duel['winner'] === $steamId || $duel['winner2'] === $steamId) {
$isWinner = true;
}
}
$duel['is_winner'] = $isWinner;
$processedDuels[] = $duel;
}
mge_debug_log("DEBUG: Fetched {$limit} duels for SteamID $steamId -> found: " . count($processedDuels));
return $processedDuels;
}
function getMGEStats($db, $steamId) {
$row = executeQuerySingle($db, "SELECT wins, losses FROM mgemod_stats WHERE steamid = ?", [$steamId], 's');
$wins = $row['wins'] ?? 0;
$losses = $row['losses'] ?? 0;
$winrate = ($wins + $losses) > 0 ? round(($wins / ($wins + $losses)) * 100, 2) : 0;
return [
'wins' => $wins,
'losses' => $losses,
'winrate' => $winrate
];
}
// Function to get top players
function getTopPlayers($db, $limit = 10, $orderBy = 'rating', $orderDir = 'DESC') {
static $cache = []; // Cache for top players
$cacheKey = "top_players_{$limit}_{$orderBy}_{$orderDir}";
if (isset($cache[$cacheKey])) {
return $cache[$cacheKey];
}
// Validate order by field to prevent SQL injection
$allowedFields = ['rating', 'wins', 'losses', 'winrate', 'last_duel'];
if (!in_array($orderBy, $allowedFields)) {
$orderBy = 'rating';
}
// Validate order direction
$orderDir = strtoupper($orderDir) === 'ASC' ? 'ASC' : 'DESC';
// Special handling for 'last_duel' sort
if ($orderBy === 'last_duel') {
$sql = "
SELECT ms.steamid, ms.rating, ms.wins, ms.losses, ms.name,
COALESCE(
GREATEST(
(SELECT MAX(endtime) FROM mgemod_duels WHERE winner = ms.steamid OR loser = ms.steamid),
(SELECT MAX(endtime) FROM mgemod_duels_2v2 WHERE winner = ms.steamid OR winner2 = ms.steamid OR loser = ms.steamid OR loser2 = ms.steamid)
), 0
) as last_duel_time_val
FROM mgemod_stats ms
WHERE ms.rating IS NOT NULL
ORDER BY last_duel_time_val {$orderDir}
LIMIT ?
";
$stmt = $db->prepare($sql);
$stmt->bind_param('i', $limit);
$stmt->execute();
$result = $stmt->get_result();
$players = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
} else if ($orderBy === 'winrate') {
// For winrate sorting, calculate winrate in the query
$players = executeQuery($db, "
SELECT ms.steamid, ms.rating, ms.wins, ms.losses, ms.name,
CASE
WHEN (ms.wins + ms.losses) > 0 THEN ROUND((ms.wins / (ms.wins + ms.losses)) * 100, 2)
ELSE 0
END as winrate_calc
FROM mgemod_stats ms
WHERE ms.rating IS NOT NULL
ORDER BY winrate_calc {$orderDir}
LIMIT ?
", [$limit], 'i');
} else {
$players = executeQuery($db, "
SELECT ms.steamid, ms.rating, ms.wins, ms.losses, ms.name
FROM mgemod_stats ms
WHERE ms.rating IS NOT NULL
ORDER BY ms.{$orderBy} {$orderDir}
LIMIT ?
", [$limit], 'i');
}
$cache[$cacheKey] = $players;
return $players;
}
// Function to get recent duels with pagination
// Function to get recent duels with pagination (OPTIMIZED VERSION)
function getRecentDuels($db, $limit = 10, $offset = 0, $orderBy = 'endtime', $orderDir = 'DESC') {
// Validate order by field to prevent SQL injection
$allowedFields = ['endtime', 'id', 'winnerscore', 'loserscore'];
if (!in_array($orderBy, $allowedFields)) {
$orderBy = 'endtime';
}
// Validate order direction
$orderDir = strtoupper($orderDir) === 'ASC' ? 'ASC' : 'DESC';
// Calculate how many records to fetch from each table
// We fetch more than needed to account for data distribution
$fetchLimit = $limit + $offset + 10; // Add buffer
// First, try to get from 1v1 table
$sql1v1 = "
SELECT
'1v1' as type,
id, endtime, winner, loser, winnerclass, loserclass,
winnerscore, loserscore, mapname, arenaname,
winner_new_elo, winner_previous_elo, loser_new_elo, loser_previous_elo,
NULL as winner2, NULL as winner2class, NULL as loser2, NULL as loser2class
FROM mgemod_duels
ORDER BY {$orderBy} {$orderDir}
LIMIT ?
";
$duels1v1 = executeQuery($db, $sql1v1, [$fetchLimit], 'i');
// Then get from 2v2 table
$sql2v2 = "
SELECT
'2v2' as type,
id, endtime, winner, loser, winnerclass, loserclass,
winnerscore, loserscore, mapname, arenaname,
winner_new_elo, winner_previous_elo, loser_new_elo, loser_previous_elo,
winner2, winner2class, loser2, loser2class
FROM mgemod_duels_2v2
ORDER BY {$orderBy} {$orderDir}
LIMIT ?
";
$duels2v2 = executeQuery($db, $sql2v2, [$fetchLimit], 'i');
// Merge and sort all results in PHP
$allDuels = array_merge($duels1v1, $duels2v2);
// Sort the combined array
usort($allDuels, function($a, $b) use ($orderBy, $orderDir) {
$valA = $a[$orderBy];
$valB = $b[$orderBy];
if ($orderDir === 'ASC') {
return $valA <=> $valB;
} else {
return $valB <=> $valA;
}
});
// Apply offset and limit
$result = array_slice($allDuels, $offset, $limit);
return $result;
}
// Function to get total duels count for pagination
function getTotalDuelsCount($db) {
static $cache = []; // Cache for total duels count
if (isset($cache['total_duels_count'])) {
return $cache['total_duels_count'];
}
// Count duels from both tables in a single query for better performance
$sql = "
SELECT
(SELECT COUNT(*) FROM mgemod_duels) +
(SELECT COUNT(*) FROM mgemod_duels_2v2) as total_count
";
$row = executeQuerySingle($db, $sql);
$totalCount = $row ? $row['total_count'] : 0;
$cache['total_duels_count'] = $totalCount;
return $totalCount;
}
// Function to get duel details by ID
function getDuelDetails($db, $duelId, $type) {
$table = $type === '1v1' ? 'mgemod_duels' : 'mgemod_duels_2v2';
$duel = executeQuerySingle($db, "
SELECT * FROM {$table} WHERE id = ?
", [$duelId], 'i');
return $duel;
}
function normalizeMgeSlotValue($value, $defaultSlot) {
$slot = (int)$value;
return $slot > 0 ? $slot : (int)$defaultSlot;
}
function getMgeClassNameById($classId) {
static $classMap = [
0 => 'unknown',
1 => 'scout',
2 => 'sniper',
3 => 'soldier',
4 => 'demoman',
5 => 'medic',
6 => 'heavy',
7 => 'pyro',
8 => 'spy',
9 => 'engineer',
10 => 'civilian'
];
return $classMap[(int)$classId] ?? 'unknown';
}
function getMgeSlotSteamIdFromDuel(array $duel, string $duelType, int $slot): ?string {
if ($slot <= 0) {
return null;
}
if ($duelType === '2v2') {
$winnerSlot = normalizeMgeSlotValue($duel['winner_slot'] ?? 0, 1);
$winner2Slot = normalizeMgeSlotValue($duel['winner2_slot'] ?? 0, 3);
$loserSlot = normalizeMgeSlotValue($duel['loser_slot'] ?? 0, 2);
$loser2Slot = normalizeMgeSlotValue($duel['loser2_slot'] ?? 0, 4);
if ($slot === $winnerSlot) return isset($duel['winner']) ? trim((string)$duel['winner']) : null;
if ($slot === $winner2Slot) return isset($duel['winner2']) ? trim((string)$duel['winner2']) : null;
if ($slot === $loserSlot) return isset($duel['loser']) ? trim((string)$duel['loser']) : null;
if ($slot === $loser2Slot) return isset($duel['loser2']) ? trim((string)$duel['loser2']) : null;
return null;
}
$winnerSlot = normalizeMgeSlotValue($duel['winner_slot'] ?? 0, 1);
$loserSlot = normalizeMgeSlotValue($duel['loser_slot'] ?? 0, 2);
if ($slot === $winnerSlot) return isset($duel['winner']) ? trim((string)$duel['winner']) : null;
if ($slot === $loserSlot) return isset($duel['loser']) ? trim((string)$duel['loser']) : null;
return null;
}
function getMgeRoundTeamSlotByPlayerSlot($slot, $duelType, $duel = []) {
$slot = (int)$slot;
if ($slot <= 0) {
return 0;
}
if ($duelType === '2v2') {
$winnerSlot = normalizeMgeSlotValue($duel['winner_slot'] ?? 0, 1);
$winner2Slot = normalizeMgeSlotValue($duel['winner2_slot'] ?? 0, 3);
$loserSlot = normalizeMgeSlotValue($duel['loser_slot'] ?? 0, 2);
$loser2Slot = normalizeMgeSlotValue($duel['loser2_slot'] ?? 0, 4);
if ($slot === $winnerSlot || $slot === $winner2Slot) {
return 1;
}
if ($slot === $loserSlot || $slot === $loser2Slot) {
return 2;
}
if ($slot === 1 || $slot === 3) {
return 1;
}
if ($slot === 2 || $slot === 4) {
return 2;
}
return 0;
}
$winnerSlot = normalizeMgeSlotValue($duel['winner_slot'] ?? 0, 1);
$loserSlot = normalizeMgeSlotValue($duel['loser_slot'] ?? 0, 2);
if ($slot === $winnerSlot) {
return 1;
}
if ($slot === $loserSlot) {
return 2;
}
if ($slot === 1 || $slot === 2) {
return $slot;
}
return 0;
}
function buildMgeRoundsFromCompactJson(array $duel, string $duelType): array {
$compactRaw = trim((string)($duel['rounds_compact_json'] ?? ''));
if ($compactRaw === '') {
return [];
}
$decoded = json_decode($compactRaw, true);
if (!is_array($decoded) || !isset($decoded['r']) || !is_array($decoded['r'])) {
return [];
}
$is2v2 = ($duelType === '2v2');
$slots = $is2v2 ? [1, 2, 3, 4] : [1, 2];
$version = (int)($decoded['v'] ?? 1);
$rows = [];
$scoreRed = 0;
$scoreBlu = 0;
foreach ($decoded['r'] as $index => $roundData) {
if (!is_array($roundData)) {
continue;
}
$isV2Shape = $version >= 2;
if (!$isV2Shape) {
$roundLen = count($roundData);
$isV2Shape = (!$is2v2 && $roundLen >= 7) || ($is2v2 && $roundLen >= 11);
}
$scoringWeaponDefindex = $isV2Shape ? (int)($roundData[2] ?? 0) : 0;
$classOffset = $isV2Shape ? 3 : 2;
$weaponOffset = $isV2Shape ? ($is2v2 ? 7 : 5) : ($is2v2 ? 6 : 4);
$hpOffset = $isV2Shape ? ($is2v2 ? 11 : 7) : -1;
$scorerSlot = (int)($roundData[0] ?? 0);
$duration = max(0, (int)($roundData[1] ?? 0));
$winnerTeamSlot = 0;
if ($scorerSlot > 0) {
$winnerTeamSlot = (int)getMgeRoundTeamSlotByPlayerSlot($scorerSlot, $duelType, $duel);
if ($winnerTeamSlot !== 1 && $winnerTeamSlot !== 2) {
$winnerTeamSlot = 0;
}
}
$row = [
'round_number' => ((int)$index + 1),
'duration' => $duration,
'winner_team_slot' => $winnerTeamSlot,
'score_red_before' => $scoreRed,
'score_blu_before' => $scoreBlu,
'score_red_after' => $scoreRed,
'score_blu_after' => $scoreBlu,
'scorer_slot' => $scorerSlot,
'scoring_weapon_defindex' => $scoringWeaponDefindex
];
foreach ($slots as $slot) {
$classId = (int)($roundData[$classOffset + ($slot - 1)] ?? 0);
$weaponValue = $roundData[$weaponOffset + ($slot - 1)] ?? '';
$weaponIds = is_string($weaponValue) ? trim($weaponValue) : trim((string)$weaponValue);
$hpRaw = ($hpOffset >= 0) ? ($roundData[$hpOffset + ($slot - 1)] ?? null) : null;
$hp = null;
if ($hpRaw !== null && $hpRaw !== '') {
$hp = max(0, (int)$hpRaw);
}
$row["slot{$slot}_steamid"] = (string)(getMgeSlotSteamIdFromDuel($duel, $duelType, $slot) ?? '');
$row["slot{$slot}_class_id"] = $classId;
$row["slot{$slot}_class"] = getMgeClassNameById($classId);
$row["slot{$slot}_hp"] = $hp;
$row["slot{$slot}_weaponids"] = $weaponIds;
}
if ($winnerTeamSlot === 1) {
$scoreRed++;
} elseif ($winnerTeamSlot === 2) {
$scoreBlu++;
}
$row['score_red_after'] = $scoreRed;
$row['score_blu_after'] = $scoreBlu;
$rows[] = $row;
}
return $rows;
}
function buildMgeRoundsHtmlSimple(array $duel, string $duelType): string {
$rounds = buildMgeRoundsFromCompactJson($duel, $duelType);
if (empty($rounds)) {
return '' . htmlspecialchars(t('rounds_not_found'), ENT_QUOTES, 'UTF-8') . '
' . $nickEsc . ' ';
}
$slotTitle = htmlspecialchars(t('slot_label') . ' ' . $slot . ' (' . $sideText . ')', ENT_QUOTES, 'UTF-8');
$classEsc = htmlspecialchars($className, ENT_QUOTES, 'UTF-8');
$hpText = '';
if ($hp !== null && $hp !== '') {
$hpText = ' | ' . htmlspecialchars(t('hp_label'), ENT_QUOTES, 'UTF-8') . ': ' . (int)$hp;
}
$badge = '';
if ($scorerSlot === $slot) {
$badge = '' . htmlspecialchars(t('point_plus'), ENT_QUOTES, 'UTF-8') . ' ';
}
$html = '';
$html .= '
' . $slotTitle . $badge . '
';
$html .= '
' . $nickEsc . '
';
$html .= '
' . htmlspecialchars(t('class_label'), ENT_QUOTES, 'UTF-8') . ': ' . $classEsc . $hpText . '
';
$html .= '
';
$html .= '
' . htmlspecialchars(t('rounds_title', ['count' => count($rounds)]), ENT_QUOTES, 'UTF-8') . ' ';
$html .= '
';
foreach ($rounds as $round) {
$roundNumber = (int)($round['round_number'] ?? 0);
$duration = max(0, (int)($round['duration'] ?? 0));
$winnerTeamSlot = (int)($round['winner_team_slot'] ?? 0);
$scoreAfter = (int)($round['score_red_after'] ?? 0) . ':' . (int)($round['score_blu_after'] ?? 0);
$scorerSlot = (int)($round['scorer_slot'] ?? 0);
$winnerClass = '';
if ($winnerTeamSlot === 1) {
$winnerClass = ' duel-round-center-red';
} elseif ($winnerTeamSlot === 2) {
$winnerClass = ' duel-round-center-blu';
}
$html .= '
';
$html .= '
';
foreach ($topSlots as $slot) {
$html .= $renderSlotCard($slot, $round, $winnerTeamSlot, $scorerSlot);
}
$html .= '
';
$html .= '
';
$html .= '
';
$html .= '
' . htmlspecialchars(t('round_label') . ' #' . $roundNumber . ' - ' . t('score_label') . ': ' . $scoreAfter, ENT_QUOTES, 'UTF-8') . '
';
$html .= '
' . htmlspecialchars(t('duration_label') . ': ' . $duration . 's', ENT_QUOTES, 'UTF-8') . '
';
$html .= '
';
$html .= '
';
$html .= '
';
foreach ($bottomSlots as $slot) {
$html .= $renderSlotCard($slot, $round, $winnerTeamSlot, $scorerSlot);
}
$html .= '
';
$html .= '
';
}
$html .= '
';
$html .= '
- ';
$duel['loser_class_html'] = !empty($duel['loserclass']) ? getClassIconsHtml($duel['loserclass'], "38") : '- ';
if (isset($duel['winner2']) && $duel['winner2']) {
$winner2Nick = getPlayerNickname($db, $duel['winner2']);
$loser2Nick = getPlayerNickname($db, $duel['loser2']);
$duel['winner2_nick'] = $winner2Nick;
$duel['loser2_nick'] = $loser2Nick;
$duel['winner2_class_html'] = !empty($duel['winner2class']) ? getClassIconsHtml($duel['winner2class'], "38") : '- ';
$duel['loser2_class_html'] = !empty($duel['loser2class']) ? getClassIconsHtml($duel['loser2class'], "38") : '- ';
}
}
mge_debug_log("DEBUG AJAX: Sending duels data: " . json_encode(array_slice($duels, 0, 2)));
echo json_encode([
'duels' => $duels,
'current_page' => $page,
'total_pages' => $totalPages,
'total_duels' => $totalDuels
]);
exit;
}
if ($_GET['ajax'] === 'get_duel_details') {
$duelId = (int)$_GET['duel_id'];
$type = $_GET['type'];
$duel = getDuelDetails($db, $duelId, $type);
if ($duel) {
$duel['winner_nick'] = getPlayerNickname($db, $duel['winner']);
$duel['loser_nick'] = getPlayerNickname($db, $duel['loser']);
if ($type === '2v2') {
$duel['winner2_nick'] = getPlayerNickname($db, $duel['winner2']);
$duel['loser2_nick'] = getPlayerNickname($db, $duel['loser2']);
}
}
echo json_encode([
'duel' => $duel
]);
exit;
}
if ($_GET['ajax'] === 'search_players') {
$query = sanitizeInput($_GET['q'] ?? '');
$orderBy = trim(strtolower($_GET['sort_by'] ?? 'rating'));
$orderDir = trim(strtoupper($_GET['sort_dir'] ?? 'DESC'));
// Validate sort parameters to prevent SQL injection
list($orderBy, $orderDir) = validateSortParams($orderBy, $orderDir);
// Debug: Check if debug mode is enabled
if (mge_is_debug_enabled()) {
echo "" . htmlspecialchars(t('debug_search_title'), ENT_QUOTES, "UTF-8") . " ";
echo "" . htmlspecialchars(t('debug_search_query'), ENT_QUOTES, "UTF-8") . ": " . htmlspecialchars($query) . "
";
// Check if the player exists in the database with exact match
$checkStmt = $db->prepare("SELECT name, steamid FROM mgemod_stats WHERE name = ?");
$checkStmt->bind_param('s', $query);
$checkStmt->execute();
$checkResult = $checkStmt->get_result();
$exactMatch = $checkResult->fetch_assoc();
$checkStmt->close();
if ($exactMatch) {
echo "" . htmlspecialchars(t('debug_exact_match_found'), ENT_QUOTES, "UTF-8") . ": " . htmlspecialchars($exactMatch['name']) . " (" . htmlspecialchars($exactMatch['steamid']) . ")
";
} else {
echo "" . htmlspecialchars(t('debug_exact_match_not_found'), ENT_QUOTES, "UTF-8") . "
";
}
// Check for partial match
$partialSearch = "%{$query}%";
$checkPartialStmt = $db->prepare("SELECT name, steamid FROM mgemod_stats WHERE name LIKE ?");
$checkPartialStmt->bind_param('s', $partialSearch);
$checkPartialStmt->execute();
$checkPartialResult = $checkPartialStmt->get_result();
$partialMatches = $checkPartialResult->fetch_all(MYSQLI_ASSOC);
$checkPartialStmt->close();
if (!empty($partialMatches)) {
echo "" . htmlspecialchars(t('debug_partial_matches_found'), ENT_QUOTES, "UTF-8") . ": " . count($partialMatches) . "
";
foreach ($partialMatches as $match) {
echo "- " . htmlspecialchars($match['name']) . " (" . htmlspecialchars($match['steamid']) . ")
";
}
} else {
echo "" . htmlspecialchars(t('debug_partial_matches_not_found'), ENT_QUOTES, "UTF-8") . "
";
}
// Check for case-insensitive match
$checkCaseStmt = $db->prepare("SELECT name, steamid FROM mgemod_stats WHERE LOWER(name) = LOWER(?)");
$checkCaseStmt->bind_param('s', $query);
$checkCaseStmt->execute();
$checkCaseResult = $checkCaseStmt->get_result();
$caseMatch = $checkCaseResult->fetch_assoc();
$checkCaseStmt->close();
if ($caseMatch) {
echo "" . htmlspecialchars(t('debug_case_match_found'), ENT_QUOTES, "UTF-8") . ": " . htmlspecialchars($caseMatch['name']) . " (" . htmlspecialchars($caseMatch['steamid']) . ")
";
} else {
echo "" . htmlspecialchars(t('debug_case_match_not_found'), ENT_QUOTES, "UTF-8") . "
";
}
}
$stmt = $db->prepare("
SELECT ms.steamid, ms.rating, ms.wins, ms.losses, ms.name,
CASE
WHEN (ms.wins + ms.losses) > 0 THEN ROUND((ms.wins / (ms.wins + ms.losses)) * 100, 2)
ELSE 0
END as winrate,
CASE
WHEN ms.name = ? THEN 1 -- Exact name match
WHEN ms.name LIKE ? THEN 2 -- Partial name match
WHEN ms.steamid = ? THEN 3 -- Exact SteamID match
WHEN ms.steamid LIKE ? THEN 4 -- Partial SteamID match
ELSE 5
END as relevance_order
FROM mgemod_stats ms
WHERE (ms.name IS NOT NULL AND ms.name LIKE ?) OR ms.steamid LIKE ?
ORDER BY relevance_order ASC, ms.{$orderBy} {$orderDir}
LIMIT 10
");
if ($stmt) {
$searchTerm = "%{$query}%";
$exactSearch = $query;
$stmt->bind_param('ssssss', $exactSearch, $searchTerm, $exactSearch, $searchTerm, $searchTerm, $searchTerm);
$stmt->execute();
$result = $stmt->get_result();
$players = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
foreach ($players as &$player) {
$player['nick'] = $player['name'] ?: $player['steamid'];
}
echo json_encode([
'players' => $players
]);
} else {
echo json_encode(['players' => []]);
}
exit;
}
if ($_GET['ajax'] === 'get_players_page') {
$page = isset($_GET['page']) ? max(1, (int)$_GET['page']) : 1;
$orderBy = trim(strtolower($_GET['sort_by'] ?? 'rating'));
$orderDir = trim(strtoupper($_GET['sort_dir'] ?? 'DESC'));
$limit = 25;
$offset = ($page - 1) * $limit;
// Validate sort parameters to prevent SQL injection
list($orderBy, $orderDir) = validateSortParams($orderBy, $orderDir);
// Get total count for pagination
$totalCount = executeCountQuery($db, "SELECT COUNT(*) as total FROM mgemod_stats ms WHERE ms.rating IS NOT NULL");
// Special handling for 'last_duel' sort
if ($orderBy === 'last_duel') {
$sql = "
SELECT ms.steamid, ms.rating, ms.wins, ms.losses, ms.name,
COALESCE(
GREATEST(
(SELECT MAX(endtime) FROM mgemod_duels WHERE winner = ms.steamid OR loser = ms.steamid),
(SELECT MAX(endtime) FROM mgemod_duels_2v2 WHERE winner = ms.steamid OR winner2 = ms.steamid OR loser = ms.steamid OR loser2 = ms.steamid)
), 0
) as last_duel_time_val
FROM mgemod_stats ms
WHERE ms.rating IS NOT NULL
ORDER BY last_duel_time_val {$orderDir}
LIMIT ? OFFSET ?
";
$stmt = $db->prepare($sql);
$stmt->bind_param('ii', $limit, $offset);
$stmt->execute();
$result = $stmt->get_result();
$players = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
}
// Special handling for 'winrate' sort
else if ($orderBy === 'winrate') {
// For winrate sorting, we need to calculate winrate in the query
$stmt = $db->prepare("
SELECT ms.steamid, ms.rating, ms.wins, ms.losses, ms.name,
CASE
WHEN (ms.wins + ms.losses) > 0 THEN ROUND((ms.wins / (ms.wins + ms.losses)) * 100, 2)
ELSE 0
END as winrate_calc
FROM mgemod_stats ms
WHERE ms.rating IS NOT NULL
ORDER BY winrate_calc {$orderDir}
LIMIT ? OFFSET ?
");
} else {
$stmt = $db->prepare("
SELECT ms.steamid, ms.rating, ms.wins, ms.losses, ms.name
FROM mgemod_stats ms
WHERE ms.rating IS NOT NULL
ORDER BY ms.{$orderBy} {$orderDir}
LIMIT ? OFFSET ?
");
}
$players = [];
if ($orderBy !== 'last_duel') {
if ($stmt) {
$stmt->bind_param('ii', $limit, $offset);
$stmt->execute();
$result = $stmt->get_result();
$players = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
}
}
$totalPages = ceil($totalCount / $limit);
foreach ($players as &$player) {
$player['nick'] = $player['name'] ?: $player['steamid'];
// If we're sorting by winrate, use the calculated value from the query
if ($orderBy === 'winrate' && isset($player['winrate_calc'])) {
$player['winrate'] = $player['winrate_calc'];
} else {
// Otherwise calculate winrate as before
$winrate = ($player['wins'] + $player['losses']) > 0 ?
round(($player['wins'] / ($player['wins'] + $player['losses'])) * 100, 2) : 0;
$player['winrate'] = $winrate;
}
// Get the most recent duel for this player
$lastDuel = getLastDuelForPlayer($db, $player['steamid']);
$player['last_duel_time'] = $lastDuel ? date('d.m.Y H:i', $lastDuel['endtime']) : t('no_data');
// Add last duel time value for sorting if needed
if ($orderBy === 'last_duel') {
$player['last_duel_time_val'] = $player['last_duel_time_val'] ?? 0;
}
}
echo json_encode([
'players' => $players,
'current_page' => $page,
'total_pages' => $totalPages,
'total_players' => $totalCount
]);
exit;
}
if ($_GET['ajax'] === 'get_profile_duels_page') {
$steamId = sanitizeInput($_GET['steam_id'] ?? '');
$page = isset($_GET['page']) ? max(1, (int)$_GET['page']) : 1;
$limit = 10;
$offset = ($page - 1) * $limit;
$duels = getMGEDuelsPaginated($db, $steamId, $limit, $offset);
$totalDuels = getMGEDuelsCount($db, $steamId);
$totalPages = ceil($totalDuels / $limit);
// Debug: Log the duels before adding nicknames
mge_debug_log("DEBUG AJAX: Before adding nicknames, duels count: " . count($duels));
foreach ($duels as $index => $duel) {
mge_debug_log("DEBUG AJAX: Pre-nickname duel $index - Type: {$duel['type']}, ID: {$duel['id']}, Winner: {$duel['winner']}, Loser: {$duel['loser']}, Is Winner: " . ($duel['is_winner'] ? 'YES' : 'NO'));
}
foreach ($duels as &$duel) {
$winnerNick = getPlayerNickname($db, $duel['winner']);
$loserNick = getPlayerNickname($db, $duel['loser']);
$duel['winner_nick'] = $winnerNick;
$duel['loser_nick'] = $loserNick;
$duel['winnerclass_html'] = !empty($duel['winnerclass']) ? getClassIconsHtml($duel['winnerclass'], "32") : '- ';
$duel['loserclass_html'] = !empty($duel['loserclass']) ? getClassIconsHtml($duel['loserclass'], "32") : '- ';
if (isset($duel['winner2']) && $duel['winner2']) {
$winner2Nick = getPlayerNickname($db, $duel['winner2']);
$loser2Nick = getPlayerNickname($db, $duel['loser2']);
$duel['winner2_nick'] = $winner2Nick;
$duel['loser2_nick'] = $loser2Nick;
$duel['winner2class_html'] = !empty($duel['winner2class']) ? getClassIconsHtml($duel['winner2class'], "32") : '- ';
$duel['loser2class_html'] = !empty($duel['loser2class']) ? getClassIconsHtml($duel['loser2class'], "32") : '- ';
}
}
// Debug: Log the duels after adding nicknames (this is what gets sent to browser)
mge_debug_log("DEBUG AJAX: After adding nicknames, duels count: " . count($duels));
foreach ($duels as $index => $duel) {
mge_debug_log("DEBUG AJAX: Final duel $index - Type: {$duel['type']}, ID: {$duel['id']}, Winner: {$duel['winner_nick']}, Loser: {$duel['loser_nick']}, Is Winner: " . ($duel['is_winner'] ? 'YES' : 'NO'));
}
echo json_encode([
'duels' => $duels,
'current_page' => $page,
'total_pages' => $totalPages,
'total_duels' => $totalDuels
]);
exit;
}
if ($_GET['ajax'] === 'get_player_nickname') {
$steamId = sanitizeInput($_GET['steam_id'] ?? '');
if (empty($steamId)) {
http_response_code(400);
echo htmlspecialchars(t('error_invalid_steamid'), ENT_QUOTES, "UTF-8");
exit;
}
$nickname = getPlayerNickname($db, $steamId);
echo htmlspecialchars($nickname, ENT_QUOTES, 'UTF-8');
exit;
}
if ($_GET['ajax'] === 'get_daily_duels') {
header('Content-Type: application/json; charset=utf-8');
$steamId = sanitizeInput($_GET['steam_id'] ?? '');
$date = sanitizeInput($_GET['date'] ?? '');
if (empty($steamId)) {
http_response_code(400);
echo json_encode(['error' => t('error_invalid_steamid')]);
exit;
}
// Validate date format
if (!strtotime($date)) {
http_response_code(400);
echo json_encode(['error' => t('error_invalid_date_format')]);
exit;
}
// Get duels for the specific date
$stmt = $db->prepare("
SELECT
HOUR(FROM_UNIXTIME(endtime)) as hour,
COUNT(*) as duel_count
FROM (
SELECT endtime FROM mgemod_duels WHERE (winner = ? OR loser = ?) AND DATE(FROM_UNIXTIME(endtime)) = ?
UNION ALL
SELECT endtime FROM mgemod_duels_2v2 WHERE (winner = ? OR winner2 = ? OR loser = ? OR loser2 = ?) AND DATE(FROM_UNIXTIME(endtime)) = ?
) AS all_duels
GROUP BY HOUR(FROM_UNIXTIME(endtime))
ORDER BY hour
");
if (!$stmt) {
http_response_code(500);
echo json_encode(['error' => 'Failed to prepare daily duels query']);
exit;
}
$stmt->bind_param('ssssssss', $steamId, $steamId, $date, $steamId, $steamId, $steamId, $steamId, $date);
$stmt->execute();
$result = $stmt->get_result();
$hourlyData = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
// Format data for chart (ensure all 24 hours are represented)
$hourlyCounts = array_fill(0, 24, 0); // Initialize all hours to 0
foreach ($hourlyData as $data) {
$hour = (int)$data['hour'];
$hourlyCounts[$hour] = (int)$data['duel_count'];
}
// Create labels and dataset
$labels = array_map(function($hour) {
return sprintf('%02d:00', $hour);
}, range(0, 23));
$dataset = [
'label' => t('js_duels'),
'data' => array_values($hourlyCounts),
'borderColor' => 'rgb(74, 222, 128)',
'backgroundColor' => 'rgba(74, 222, 128, 0.1)',
'tension' => 0.4,
'fill' => true
];
$payload = json_encode([
'labels' => $labels,
'datasets' => [$dataset]
], JSON_UNESCAPED_UNICODE);
if ($payload === false) {
http_response_code(500);
echo json_encode(['error' => 'JSON encode failed: ' . json_last_error_msg()], JSON_UNESCAPED_UNICODE);
exit;
}
if (ob_get_length()) {
ob_clean();
}
echo $payload;
exit;
}
if ($_GET['ajax'] === 'get_activity_heatmap') {
header('Content-Type: application/json; charset=utf-8');
$steamId = sanitizeInput($_GET['steam_id'] ?? '');
$year = (int)$_GET['year'];
if (!$steamId || !$year) {
http_response_code(400);
echo json_encode(['error' => t('error_missing_steam_year')]);
exit;
}
// Get activity data for the specified year
$stmt = $db->prepare("
SELECT
DATE(FROM_UNIXTIME(endtime)) as duel_date,
COUNT(*) as duel_count
FROM (
SELECT endtime FROM mgemod_duels WHERE (winner = ? OR loser = ?) AND YEAR(FROM_UNIXTIME(endtime)) = ?
UNION ALL
SELECT endtime FROM mgemod_duels_2v2 WHERE (winner = ? OR winner2 = ? OR loser = ? OR loser2 = ?) AND YEAR(FROM_UNIXTIME(endtime)) = ?
) AS all_duels
GROUP BY DATE(FROM_UNIXTIME(endtime))
ORDER BY duel_date
");
if (!$stmt) {
http_response_code(500);
echo json_encode(['error' => 'Failed to prepare activity query'], JSON_UNESCAPED_UNICODE);
exit;
}
$stmt->bind_param('ssissssi', $steamId, $steamId, $year, $steamId, $steamId, $steamId, $steamId, $year);
$stmt->execute();
$result = $stmt->get_result();
$activity = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
// Get all years with activity
$stmtYears = $db->prepare("
SELECT DISTINCT YEAR(FROM_UNIXTIME(endtime)) as year
FROM (
SELECT endtime FROM mgemod_duels WHERE (winner = ? OR loser = ?)
UNION ALL
SELECT endtime FROM mgemod_duels_2v2 WHERE (winner = ? OR winner2 = ? OR loser = ? OR loser2 = ?)
) AS all_duels
ORDER BY year DESC
");
if (!$stmtYears) {
http_response_code(500);
echo json_encode(['error' => 'Failed to prepare activity years query'], JSON_UNESCAPED_UNICODE);
exit;
}
$stmtYears->bind_param('ssssss', $steamId, $steamId, $steamId, $steamId, $steamId, $steamId);
$stmtYears->execute();
$yearsResult = $stmtYears->get_result();
$availableYears = [];
while ($row = $yearsResult->fetch_assoc()) {
$availableYears[] = $row['year'];
}
$stmtYears->close();
// Format the data
$activityData = [];
foreach ($activity as $item) {
$activityData[$item['duel_date']] = (int)$item['duel_count'];
}
// Generate heatmap HTML
ob_start();
$selectedYear = $year;
// GitHub-style heatmap: columns = weeks, rows = days of week
// Cell size increased by 40% (10px -> 14px)
$cellSize = 15;
$cellWidth = 14;
$start = new DateTime("$selectedYear-01-01");
$end = new DateTime("$selectedYear-12-31");
$interval = new DateInterval('P1D');
// Find the first Sunday on or before Jan 1
$firstSunday = clone $start;
while ($firstSunday->format('w') != 0) {
$firstSunday->sub($interval);
}
// Find the last Saturday on or after Dec 31
$lastSaturday = clone $end;
while ($lastSaturday->format('w') != 6) {
$lastSaturday->add($interval);
}
// Calculate positions for all days
$dayPositions = [];
$tempCurrent = clone $firstSunday;
$weekNumber = 0;
while ($tempCurrent <= $lastSaturday) {
$dateStr = $tempCurrent->format('Y-m-d');
$dayOfWeek = (int)$tempCurrent->format('w');
$dayPositions[] = [
'date' => $dateStr,
'x' => $weekNumber * $cellSize,
'y' => $dayOfWeek * $cellSize,
'month' => $tempCurrent->format('n'),
'in_year' => $tempCurrent->format('Y') == $selectedYear
];
$tempCurrent->add($interval);
if ($tempCurrent->format('w') == 0) {
$weekNumber++;
}
}
$svgWidth = ($weekNumber + 1) * $cellSize + 40;
$svgHeight = 7 * $cellSize + 25;
// Month labels
$months = [];
$lastMonth = null;
foreach ($dayPositions as $pos) {
if (!$pos['in_year']) continue;
$month = $pos['month'];
if ($month !== $lastMonth) {
$months[$month] = [
'x' => $pos['x'],
'name' => DateTime::createFromFormat('!m', $month)->format('M')
];
$lastMonth = $month;
}
}
?>
$monthData): ?>
'.$dateStr.': '.htmlspecialchars(t('duels_count_short', ['count' => $count]), ENT_QUOTES, 'UTF-8').' ';
}
?>
0): ?>
$heatmapHtml,
'year' => $year,
'available_years' => $availableYears
], JSON_UNESCAPED_UNICODE);
if ($payload === false) {
http_response_code(500);
echo json_encode(['error' => 'JSON encode failed: ' . json_last_error_msg()], JSON_UNESCAPED_UNICODE);
exit;
}
if (ob_get_length()) {
ob_clean();
}
echo $payload;
exit;
}
}
// Function to get player matchups (practice duels)
function getPlayerMatchups($db, $steamId) {
$stmt = $db->prepare("
SELECT
id, endtime, winner, loser, winnerclass, loserclass,
winnerscore, loserscore, mapname, arenaname,
winner_new_elo, winner_previous_elo, loser_new_elo, loser_previous_elo
FROM mgemod_duels
WHERE (winner = ? OR loser = ?)
AND mapname = '???????????'
AND arenaname LIKE '??????%'
ORDER BY endtime DESC
LIMIT 10
");
$stmt->bind_param('ss', $steamId, $steamId);
$stmt->execute();
$result = $stmt->get_result();
$matchups = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
// Get opponent nicknames
foreach ($matchups as &$matchup) {
if ($matchup['winner'] === $steamId) {
$matchup['opponent'] = getPlayerNickname($db, $matchup['loser']);
$matchup['result'] = 'win';
} else {
$matchup['opponent'] = getPlayerNickname($db, $matchup['winner']);
$matchup['result'] = 'loss';
}
}
return $matchups;
}
// Function to get matchup ratings for heatmap
function getMatchupRatings($db, $steamId) {
$stmt = $db->prepare("SELECT my_class, opponent_class, rating FROM mgemod_matchup_ratings WHERE steamid = ?");
if (!$stmt) {
return [];
}
$stmt->bind_param('s', $steamId);
$stmt->execute();
$result = $stmt->get_result();
$ratings = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
// Initialize all matchups with default rating of 1500
$classOrder = ['scout', 'soldier', 'pyro', 'demoman', 'heavy', 'engineer', 'medic', 'sniper', 'spy'];
$matchupRatings = [];
foreach ($classOrder as $myClass) {
foreach ($classOrder as $oppClass) {
$matchupRatings[$myClass][$oppClass] = 1500;
}
}
// Fill in actual ratings from database
foreach ($ratings as $rating) {
$myClassId = (int)$rating['my_class'];
$oppClassId = (int)$rating['opponent_class'];
$ratingValue = (int)$rating['rating'];
// Map class IDs to class names
$classIdMap = [
1 => 'scout',
2 => 'sniper',
3 => 'soldier',
4 => 'demoman',
5 => 'medic',
6 => 'heavy',
7 => 'pyro',
8 => 'spy',
9 => 'engineer'
];
$myClass = $classIdMap[$myClassId] ?? null;
$oppClass = $classIdMap[$oppClassId] ?? null;
if ($myClass && $oppClass && $ratingValue > 0) {
$matchupRatings[$myClass][$oppClass] = $ratingValue;
}
}
return $matchupRatings;
}
// Function to get matchup statistics
function getMatchupStats($db, $steamId) {
$classOrder = ['scout', 'soldier', 'pyro', 'demoman', 'heavy', 'engineer', 'medic', 'sniper', 'spy'];
$matchupStats = [];
// Initialize all matchups with zero stats
foreach ($classOrder as $myClass) {
foreach ($classOrder as $oppClass) {
$matchupStats[$myClass][$oppClass] = [
'total' => 0,
'wins' => 0
];
}
}
// Parse class string (can contain multiple classes like "scout,pyro,sniper")
$parseClasses = function($classString) use ($classOrder) {
if (empty($classString)) return [];
$classes = array_map('trim', explode(',', $classString));
$result = [];
foreach ($classes as $class) {
$class = strtolower(trim($class));
if (in_array($class, $classOrder)) {
$result[] = $class;
}
}
return $result;
};
// Get 1v1 duels - parse classes from winnerclass/loserclass fields
$query1v1 = "SELECT
id,
winner,
loser,
winnerclass,
loserclass
FROM mgemod_duels
WHERE (winner = ? OR loser = ?)
AND (winnerclass IS NOT NULL AND winnerclass != '')
AND (loserclass IS NOT NULL AND loserclass != '')";
$stmt = $db->prepare($query1v1);
if ($stmt) {
$stmt->bind_param('ss', $steamId, $steamId);
if ($stmt->execute()) {
$result = $stmt->get_result();
$processedDuels = [];
while ($row = $result->fetch_assoc()) {
$duelId = (int)$row['id'];
$isWinner = ($row['winner'] === $steamId);
$myClasses = $isWinner ? $parseClasses($row['winnerclass']) : $parseClasses($row['loserclass']);
$oppClasses = $isWinner ? $parseClasses($row['loserclass']) : $parseClasses($row['winnerclass']);
// Count all combinations of my classes vs opponent classes
foreach ($myClasses as $myClass) {
foreach ($oppClasses as $oppClass) {
$key = $myClass . '_' . $oppClass;
$duelKey = $key . '_' . $duelId;
if (!isset($processedDuels[$duelKey])) {
$processedDuels[$duelKey] = true;
$matchupStats[$myClass][$oppClass]['total'] += 1;
if ($isWinner) {
$matchupStats[$myClass][$oppClass]['wins'] += 1;
}
}
}
}
}
}
$stmt->close();
}
// Get 2v2 duels - parse classes from all class fields
$query2v2 = "SELECT
id,
winner,
winner2,
loser,
loser2,
winnerclass,
winner2class,
loserclass,
loser2class
FROM mgemod_duels_2v2
WHERE (winner = ? OR winner2 = ? OR loser = ? OR loser2 = ?)
AND ((winnerclass IS NOT NULL AND winnerclass != '') OR (winner2class IS NOT NULL AND winner2class != ''))
AND ((loserclass IS NOT NULL AND loserclass != '') OR (loser2class IS NOT NULL AND loser2class != ''))";
$stmt = $db->prepare($query2v2);
if ($stmt) {
$stmt->bind_param('ssss', $steamId, $steamId, $steamId, $steamId);
if ($stmt->execute()) {
$result = $stmt->get_result();
$processedDuels = [];
while ($row = $result->fetch_assoc()) {
$duelId = (int)$row['id'];
$isWinner = ($row['winner'] === $steamId || $row['winner2'] === $steamId);
// Get all my classes (from winner or loser side)
$myClasses = [];
if ($row['winner'] === $steamId && !empty($row['winnerclass'])) {
$myClasses = array_merge($myClasses, $parseClasses($row['winnerclass']));
}
if ($row['winner2'] === $steamId && !empty($row['winner2class'])) {
$myClasses = array_merge($myClasses, $parseClasses($row['winner2class']));
}
if ($row['loser'] === $steamId && !empty($row['loserclass'])) {
$myClasses = array_merge($myClasses, $parseClasses($row['loserclass']));
}
if ($row['loser2'] === $steamId && !empty($row['loser2class'])) {
$myClasses = array_merge($myClasses, $parseClasses($row['loser2class']));
}
// Get all opponent classes
$oppClasses = [];
if ($row['winner'] !== $steamId && $row['winner2'] !== $steamId) {
if (!empty($row['winnerclass'])) {
$oppClasses = array_merge($oppClasses, $parseClasses($row['winnerclass']));
}
if (!empty($row['winner2class'])) {
$oppClasses = array_merge($oppClasses, $parseClasses($row['winner2class']));
}
}
if ($row['loser'] !== $steamId && $row['loser2'] !== $steamId) {
if (!empty($row['loserclass'])) {
$oppClasses = array_merge($oppClasses, $parseClasses($row['loserclass']));
}
if (!empty($row['loser2class'])) {
$oppClasses = array_merge($oppClasses, $parseClasses($row['loser2class']));
}
}
// Count all combinations
foreach ($myClasses as $myClass) {
foreach ($oppClasses as $oppClass) {
$key = $myClass . '_' . $oppClass;
$duelKey = $key . '_' . $duelId;
if (!isset($processedDuels[$duelKey])) {
$processedDuels[$duelKey] = true;
$matchupStats[$myClass][$oppClass]['total'] += 1;
if ($isWinner) {
$matchupStats[$myClass][$oppClass]['wins'] += 1;
}
}
}
}
}
}
$stmt->close();
}
return $matchupStats;
}
// Function to get rating color based on value
function getRatingColor($rating) {
if ($rating > 2000) return '#4caf50'; // Very high - green
if ($rating > 1700) return '#8bc34a'; // High - light green
if ($rating == 1500) return '#cddc39'; // Default rating - yellow-green
if ($rating > 1300) return '#9ccc65'; // Medium - light green
if ($rating > 1000) return '#ff9800'; // Low - orange
return '#f44336'; // Very low - red
}
// Function to get class display name
function getClassDisplayName($className) {
$classKey = 'class_' . strtolower((string)$className);
$translated = t($classKey);
if ($translated !== $classKey) {
return $translated;
}
return ucfirst((string)$className);
}
// Function to get class icon path
function getClassIconPath($className) {
$iconMap = [
'scout' => 'Scout_emblem_RED_beta.png',
'soldier' => 'Soldier_emblem_RED.png',
'pyro' => 'Pyro_emblem_RED.png',
'demoman' => 'Demoman_emblem_RED.png',
'heavy' => '145px-Heavy_emblem_RED.png',
'engineer' => 'Engineer_emblem_RED.png',
'medic' => 'Medic_emblem_RED.png',
'sniper' => 'Sniper_emblem_RED.png',
'spy' => 'Spy_emblem_RED.png'
];
return $iconMap[strtolower($className)] ?? '';
}
// Function to get player activity data for heatmap
function getPlayerActivity($db, $steamId) {
// Get ALL activity data from duels (no date limit)
$stmt = $db->prepare("
SELECT
DATE(FROM_UNIXTIME(endtime)) as duel_date,
COUNT(*) as duel_count
FROM (
SELECT endtime FROM mgemod_duels WHERE (winner = ? OR loser = ?)
UNION ALL
SELECT endtime FROM mgemod_duels_2v2 WHERE (winner = ? OR winner2 = ? OR loser = ? OR loser2 = ?)
) AS all_duels
GROUP BY DATE(FROM_UNIXTIME(endtime))
ORDER BY duel_date
");
$stmt->bind_param('ssssss', $steamId, $steamId, $steamId, $steamId, $steamId, $steamId);
$stmt->execute();
$result = $stmt->get_result();
$activity = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
// Format the data for the heatmap
$heatmapData = [];
foreach ($activity as $item) {
$heatmapData[] = [
'date' => $item['duel_date'],
'count' => (int)$item['duel_count']
];
}
return $heatmapData;
}
// Handle duel view
$viewDuel = isset($_GET['duel']) ? (int)$_GET['duel'] : null;
$duelType = isset($_GET['type']) ? $_GET['type'] : '1v1';
// Get sorting parameters
$orderBy = trim(strtolower($_GET['sort_by'] ?? 'rating'));
$orderDir = trim(strtoupper($_GET['sort_dir'] ?? 'DESC'));
// DEBUG: Show raw values in HTML
if (mge_is_debug_enabled()) {
echo "\n";
}
// Validate sort parameters to prevent SQL injection
$allowedFields = ['rating', 'wins', 'losses', 'winrate', 'last_duel'];
if (!in_array($orderBy, $allowedFields)) {
$orderBy = 'rating';
}
$orderDir = strtoupper($orderDir) === 'ASC' ? 'ASC' : 'DESC';
// Handle profile view
$viewProfile = isset($_GET['profile']) ? $_GET['profile'] : null;
// Handle search
$searchQuery = isset($_GET['search']) ? sanitizeInput(trim($_GET['search'])) : '';
$searchResults = [];
if ($searchQuery) {
// Debug: Check if debug mode is enabled
if (mge_is_debug_enabled()) {
echo "" . htmlspecialchars(t('debug_regular_search_title'), ENT_QUOTES, "UTF-8") . " ";
echo "" . htmlspecialchars(t('debug_search_query'), ENT_QUOTES, "UTF-8") . ": " . htmlspecialchars($searchQuery) . "
";
// Check if the player exists in the database with exact match
$checkStmt = $db->prepare("SELECT name, steamid FROM mgemod_stats WHERE name = ?");
$checkStmt->bind_param('s', $searchQuery);
$checkStmt->execute();
$checkResult = $checkStmt->get_result();
$exactMatch = $checkResult->fetch_assoc();
$checkStmt->close();
if ($exactMatch) {
echo "" . htmlspecialchars(t('debug_exact_match_found'), ENT_QUOTES, "UTF-8") . ": " . htmlspecialchars($exactMatch['name']) . " (" . htmlspecialchars($exactMatch['steamid']) . ")
";
} else {
echo "" . htmlspecialchars(t('debug_exact_match_not_found'), ENT_QUOTES, "UTF-8") . "
";
}
// Check for partial match
$partialSearch = "%{$searchQuery}%";
$checkPartialStmt = $db->prepare("SELECT name, steamid FROM mgemod_stats WHERE name LIKE ?");
$checkPartialStmt->bind_param('s', $partialSearch);
$checkPartialStmt->execute();
$checkPartialResult = $checkPartialStmt->get_result();
$partialMatches = $checkPartialResult->fetch_all(MYSQLI_ASSOC);
$checkPartialStmt->close();
if (!empty($partialMatches)) {
echo "" . htmlspecialchars(t('debug_partial_matches_found'), ENT_QUOTES, "UTF-8") . ": " . count($partialMatches) . "
";
foreach ($partialMatches as $match) {
echo "- " . htmlspecialchars($match['name']) . " (" . htmlspecialchars($match['steamid']) . ")
";
}
} else {
echo "" . htmlspecialchars(t('debug_partial_matches_not_found'), ENT_QUOTES, "UTF-8") . "
";
}
// Check for case-insensitive match
$checkCaseStmt = $db->prepare("SELECT name, steamid FROM mgemod_stats WHERE LOWER(name) = LOWER(?)");
$checkCaseStmt->bind_param('s', $searchQuery);
$checkCaseStmt->execute();
$checkCaseResult = $checkCaseStmt->get_result();
$caseMatch = $checkCaseResult->fetch_assoc();
$checkCaseStmt->close();
if ($caseMatch) {
echo "" . htmlspecialchars(t('debug_case_match_found'), ENT_QUOTES, "UTF-8") . ": " . htmlspecialchars($caseMatch['name']) . " (" . htmlspecialchars($caseMatch['steamid']) . ")
";
} else {
echo "" . htmlspecialchars(t('debug_case_match_not_found'), ENT_QUOTES, "UTF-8") . "
";
}
}
// Debug: Show the actual search query being executed
if (mge_is_debug_enabled()) {
echo "";
}
$stmt = $db->prepare("
SELECT DISTINCT ms.steamid, ms.rating, ms.wins, ms.losses, ms.name,
CASE
WHEN (ms.wins + ms.losses) > 0 THEN ROUND((ms.wins / (ms.wins + ms.losses)) * 100, 2)
ELSE 0
END as winrate,
CASE
WHEN ms.name = ? THEN 1 -- Exact name match
WHEN ms.name LIKE ? THEN 2 -- Partial name match
WHEN ms.steamid = ? THEN 3 -- Exact SteamID match
WHEN ms.steamid LIKE ? THEN 4 -- Partial SteamID match
ELSE 5
END as relevance_order
FROM mgemod_stats ms
WHERE (ms.name IS NOT NULL AND ms.name LIKE ?) OR ms.steamid LIKE ?
ORDER BY relevance_order ASC, ms.{$orderBy} {$orderDir}
LIMIT 50
");
if ($stmt) {
$searchTerm = "%{$searchQuery}%";
$exactSearch = $searchQuery;
$stmt->bind_param('ssssss', $exactSearch, $searchTerm, $exactSearch, $searchTerm, $searchTerm, $searchTerm);
$stmt->execute();
$result = $stmt->get_result();
$searchResults = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
foreach ($searchResults as &$player) {
$player['nick'] = $player['name'] ?: $player['steamid'];
$winrate = ($player['wins'] + $player['losses']) > 0 ?
round(($player['wins'] / ($player['wins'] + $player['losses'])) * 100, 2) : 0;
$player['winrate'] = $winrate;
}
// Debug: Show results after processing
if (mge_is_debug_enabled()) {
echo "";
foreach ($searchResults as $idx => $player) {
echo "";
}
}
// If no results found in main tables, search in duel tables
if (empty($searchResults)) {
// Search for players who participated in duels but may not be in mgemod_stats
$duelSearchStmt = $db->prepare("
SELECT DISTINCT
CASE
WHEN winner LIKE ? THEN winner
WHEN loser LIKE ? THEN loser
WHEN winner2 LIKE ? AND winner2 IS NOT NULL THEN winner2
WHEN loser2 LIKE ? AND loser2 IS NOT NULL THEN loser2
END as steamid
FROM (
SELECT winner, loser, NULL as winner2, NULL as loser2 FROM mgemod_duels
UNION ALL
SELECT winner, loser, winner2, loser2 FROM mgemod_duels_2v2
) all_duels
WHERE winner LIKE ? OR loser LIKE ? OR (winner2 LIKE ? AND winner2 IS NOT NULL) OR (loser2 LIKE ? AND loser2 IS NOT NULL)
LIMIT 50
");
if ($duelSearchStmt) {
$duelSearchTerm = "%{$searchQuery}%";
$duelSearchStmt->bind_param('ssssssss', $duelSearchTerm, $duelSearchTerm, $duelSearchTerm, $duelSearchTerm, $duelSearchTerm, $duelSearchTerm, $duelSearchTerm, $duelSearchTerm);
$duelSearchStmt->execute();
$duelResult = $duelSearchStmt->get_result();
$duelSteamIds = [];
while ($row = $duelResult->fetch_assoc()) {
if (!empty($row['steamid'])) {
$duelSteamIds[] = $row['steamid'];
}
}
$duelSearchStmt->close();
// Now get full player info for these SteamIDs
if (!empty($duelSteamIds)) {
$placeholders = str_repeat('?,', count($duelSteamIds) - 1) . '?';
$duelInfoStmt = $db->prepare("
SELECT ms.steamid, ms.rating, ms.wins, ms.losses, ms.name
FROM mgemod_stats ms
WHERE ms.steamid IN ($placeholders)
");
if ($duelInfoStmt) {
$types = str_repeat('s', count($duelSteamIds));
$duelInfoStmt->bind_param($types, ...$duelSteamIds);
$duelInfoStmt->execute();
$duelInfoResult = $duelInfoStmt->get_result();
$searchResults = $duelInfoResult->fetch_all(MYSQLI_ASSOC);
$duelInfoStmt->close();
// Update nick field for search results from duels
foreach ($searchResults as &$player) {
$player['nick'] = $player['name'] ?: $player['steamid'];
$winrate = ($player['wins'] + $player['losses']) > 0 ?
round(($player['wins'] / ($player['wins'] + $player['losses'])) * 100, 2) : 0;
$player['winrate'] = $winrate;
}
// Debug: Show results from duels after processing
if (mge_is_debug_enabled()) {
echo "";
foreach ($searchResults as $idx => $player) {
}
}
}
}
}
}
}
}
// Debug: Check search results
if ($searchQuery && mge_is_debug_enabled()) {
echo "";
echo "";
if (!empty($searchResults)) {
foreach ($searchResults as $idx => $player) {
echo "";
}
}
}
// Get player data if authenticated
$playerData = null;
$steamUserInfo = null;
if ($isAuthenticated) {
// Get SteamID64 from session
$steamId64 = $_SESSION['steamid64'] ?? null;
if ($steamId64) {
// Get API key from config
$apiKey = $config['steam_api_key'] ?? '';
if ($apiKey) {
$steamUserInfo = getSteamUserInfo($steamId64, $apiKey);
}
}
$rating = getMGERating($db, $steamId);
$stats = getMGEStats($db, $steamId);
$duels = getMGEDuels($db, $steamId);
$playerData = [
'steamid' => $steamId,
'steamid64' => $steamId64,
'name' => $steamUserInfo['name'] ?? 'Unknown',
'rating' => $rating,
'stats' => $stats,
'duels' => $duels
];
}
// Pagination for players
$page = isset($_GET['page']) ? max(1, (int)$_GET['page']) : 1;
$limit = 25; // Using 25 players per page
$offset = ($page - 1) * $limit;
// Get top players with pagination
// Special handling for 'last_duel' sort
if ($orderBy === 'last_duel') {
$sql = "
SELECT ms.steamid, ms.rating, ms.wins, ms.losses, ms.name
FROM mgemod_stats ms
WHERE ms.rating IS NOT NULL
ORDER BY ms.rating {$orderDir}
LIMIT ? OFFSET ?
";
$stmt = $db->prepare($sql);
$stmt->bind_param('ii', $limit, $offset);
$stmt->execute();
$result = $stmt->get_result();
$topPlayers = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
foreach ($topPlayers as &$player) {
$steamId = $player['steamid'];
$lastDuelSql = "
SELECT MAX(endtime) as last_duel_time FROM (
SELECT MAX(endtime) as endtime FROM mgemod_duels WHERE winner = ? OR loser = ?
UNION ALL
SELECT MAX(endtime) FROM mgemod_duels_2v2 WHERE winner = ? OR winner2 = ? OR loser = ? OR loser2 = ?
) as t
";
$stmt2 = $db->prepare($lastDuelSql);
$stmt2->bind_param('ssssss', $steamId, $steamId, $steamId, $steamId, $steamId, $steamId);
$stmt2->execute();
$result2 = $stmt2->get_result();
$row = $result2->fetch_assoc();
$player['last_duel_time_val'] = $row['last_duel_time'] ?? 0;
$stmt2->close();
}
usort($topPlayers, function($a, $b) use ($orderDir) {
$aTime = $a['last_duel_time_val'] ?? 0;
$bTime = $b['last_duel_time_val'] ?? 0;
if ($orderDir === 'ASC') {
return $aTime <=> $bTime;
} else {
return $bTime <=> $aTime;
}
});
}
// Special handling for 'winrate' sort
else if ($orderBy === 'winrate') {
// For winrate sorting, we need to calculate winrate in the query
$stmt = $db->prepare("
SELECT ms.steamid, ms.rating, ms.wins, ms.losses, ms.name,
CASE
WHEN (ms.wins + ms.losses) > 0 THEN ROUND((ms.wins / (ms.wins + ms.losses)) * 100, 2)
ELSE 0
END as winrate_calc
FROM mgemod_stats ms
WHERE ms.rating IS NOT NULL
ORDER BY winrate_calc {$orderDir}
LIMIT ? OFFSET ?
");
if ($stmt) {
$stmt->bind_param('ii', $limit, $offset);
$stmt->execute();
$result = $stmt->get_result();
$topPlayers = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
} else {
$topPlayers = [];
}
} else {
$stmt = $db->prepare("
SELECT ms.steamid, ms.rating, ms.wins, ms.losses, ms.name
FROM mgemod_stats ms
WHERE ms.rating IS NOT NULL
ORDER BY ms.{$orderBy} {$orderDir}
LIMIT ? OFFSET ?
");
if ($stmt) {
$stmt->bind_param('ii', $limit, $offset);
$stmt->execute();
$result = $stmt->get_result();
$topPlayers = $result->fetch_all(MYSQLI_ASSOC);
$stmt->close();
} else {
$topPlayers = [];
}
}
// Get total count for players pagination
$totalPlayers = executeCountQuery($db, "SELECT COUNT(*) as total FROM mgemod_stats ms WHERE ms.rating IS NOT NULL");
$totalPagesPlayers = ceil($totalPlayers / $limit);
$totalStats = getTotalStats($db);
// Pagination for recent duels
$duelLimit = 10;
$duelOffset = ($page - 1) * $duelLimit;
// Get sorting parameters for duels
$duelOrderBy = trim(strtolower($_GET['duel_sort_by'] ?? 'endtime'));
$duelOrderDir = trim(strtoupper($_GET['duel_sort_dir'] ?? 'DESC'));
// Validate duel sort parameters
$allowedDuelFields = ['endtime', 'id', 'winnerscore', 'loserscore'];
if (!in_array($duelOrderBy, $allowedDuelFields)) {
$duelOrderBy = 'endtime';
}
$duelOrderDir = $duelOrderDir === 'ASC' ? 'ASC' : 'DESC';
$recentDuels = getRecentDuels($db, $duelLimit, $duelOffset, $duelOrderBy, $duelOrderDir);
$totalDuels = getTotalDuelsCount($db);
$totalPages = ceil($totalDuels / $duelLimit);
// Get profile data if viewing a specific profile
$profileData = null;
$profileUserInfo = null;
if ($viewProfile) {
$profileRating = getMGERating($db, $viewProfile);
$profileStats = getMGEStats($db, $viewProfile);
// Get profile duels with pagination
$profileDuelsPage = isset($_GET['duels_page']) ? max(1, (int)$_GET['duels_page']) : 1;
$profileDuelsLimit = 10;
$profileDuelsOffset = ($profileDuelsPage - 1) * $profileDuelsLimit;
$profileDuels = getMGEDuelsPaginated($db, $viewProfile, $profileDuelsLimit, $profileDuelsOffset);
$profileDuelsCount = getMGEDuelsCount($db, $viewProfile);
$profileDuelsTotalPages = ceil($profileDuelsCount / $profileDuelsLimit);
$profileNemesis = getPlayerNemesis($db, $viewProfile);
$profileRatingHistory = getRatingHistory($db, $viewProfile);
if (mge_is_debug_enabled()) {
echo "";
}
// Get player nickname
$profileNickname = getPlayerNickname($db, $viewProfile);
// Try to get SteamID64 from the profile
if (preg_match('/STEAM_0:(\d+):(\d+)/', $viewProfile, $matches)) {
$y = $matches[1];
$z = $matches[2];
$profileSteamId64 = bcadd(bcmul($z, '2'), bcadd('76561197960265728', $y));
$apiKey = $config['steam_api_key'] ?? '';
if ($apiKey) {
$profileUserInfo = getSteamUserInfo($profileSteamId64, $apiKey);
}
}
$profileData = [
'steamid' => $viewProfile,
'name' => $profileNickname,
'rating' => $profileRating,
'stats' => $profileStats,
'duels' => $profileDuels,
'duels_count' => $profileDuelsCount,
'duels_total_pages' => $profileDuelsTotalPages,
'duels_current_page' => $profileDuelsPage,
'nemesis' => $profileNemesis,
'rating_history' => $profileRatingHistory,
'matchups' => getPlayerMatchups($db, $viewProfile),
'activity' => getPlayerActivity($db, $viewProfile),
'matchup_ratings' => getMatchupRatings($db, $viewProfile),
'matchup_stats' => getMatchupStats($db, $viewProfile)
];
if (mge_is_debug_enabled()) {
echo "";
}
}
// Get duel data if viewing a specific duel
$duelData = null;
if ($viewDuel) {
$duelData = getDuelDetails($db, $viewDuel, $duelType);
if ($duelData) {
$duelData['winner_nick'] = getPlayerNickname($db, $duelData['winner']);
$duelData['loser_nick'] = getPlayerNickname($db, $duelData['loser']);
if ($duelType === '2v2') {
$duelData['winner2_nick'] = getPlayerNickname($db, $duelData['winner2']);
$duelData['loser2_nick'] = getPlayerNickname($db, $duelData['loser2']);
}
}
}
?>
<?php
if ($viewDuel) echo t('site_title_duel', ['id' => $viewDuel]);
elseif ($viewProfile) echo t('site_title_profile', ['name' => (string)($profileData['name'] ?? '')]);
else echo t('site_title_main');
?>
+
()
- (int)$profileData['nemesis']['duels_count']]), ENT_QUOTES, 'UTF-8') ?>
";
}
?>
DEBUG: Has rating history:
DEBUG: Rating history count:
DEBUG: No rating history data available for this player
$oppClasses) {
foreach ($oppClasses as $oppClass => $stats) {
if ($stats['total'] > $maxDuels) {
$maxDuels = $stats['total'];
$mostFrequentMatchup = ['myClass' => $myClass, 'oppClass' => $oppClass];
}
}
}
?>
2000 ? t('rating_highest') : ($rating > 1700 ? t('rating_high') : ($rating >= 1500 ? t('rating_medium') : ($rating > 1000 ? t('rating_low') : t('rating_lowest'))));
$myClassDisplay = getClassDisplayName($myClass);
$oppClassDisplay = getClassDisplayName($oppClass);
$stats = $matchupStats[$myClass][$oppClass];
$isMostFrequent = ($mostFrequentMatchup && $mostFrequentMatchup['myClass'] === $myClass && $mostFrequentMatchup['oppClass'] === $oppClass);
?>
0): ?>
14px)
$cellSize = 15; // 14px cell + 1px gap
$cellWidth = 14;
// Generate calendar for selected year
$start = new DateTime("$selectedYear-01-01");
$end = new DateTime("$selectedYear-12-31");
$interval = new DateInterval('P1D');
// Find the first Sunday on or before Jan 1 (GitHub starts weeks on Sunday)
$firstSunday = clone $start;
while ($firstSunday->format('w') != 0) {
$firstSunday->sub($interval);
}
// Find the last Saturday on or after Dec 31
$lastSaturday = clone $end;
while ($lastSaturday->format('w') != 6) {
$lastSaturday->add($interval);
}
// Calculate positions for all days
$dayPositions = [];
$tempCurrent = clone $firstSunday;
$weekNumber = 0;
while ($tempCurrent <= $lastSaturday) {
$dateStr = $tempCurrent->format('Y-m-d');
$dayOfWeek = (int)$tempCurrent->format('w');
$dayPositions[] = [
'date' => $dateStr,
'x' => $weekNumber * $cellSize,
'y' => $dayOfWeek * $cellSize,
'month' => $tempCurrent->format('n'),
'in_year' => $tempCurrent->format('Y') == $selectedYear
];
$tempCurrent->add($interval);
if ($tempCurrent->format('w') == 0) {
$weekNumber++;
}
}
// SVG dimensions (40% larger)
$svgWidth = ($weekNumber + 1) * $cellSize + 40;
$svgHeight = 7 * $cellSize + 25;
// Month labels
$months = [];
$lastMonth = null;
foreach ($dayPositions as $pos) {
if (!$pos['in_year']) continue;
$month = $pos['month'];
if ($month !== $lastMonth) {
$months[$month] = [
'x' => $pos['x'],
'name' => DateTime::createFromFormat('!m', $month)->format('M')
];
$lastMonth = $month;
}
}
?>
$monthData): ?>
'.$dateStr.': '.t('duels_count_short', ['count' => $count]).' ';
}
?>
0): ?>
'']), ENT_QUOTES, 'UTF-8') ?>
ID
";
}
?>
DEBUG: ID=, Type=, Winner=, Winner2=, Loser=, Loser2=, ProfileID=, IsWinner=
-
-
-
-
:
0 ? '+' : '') . $eloChange : '-' ?>
1): ?>
$searchQuery]), ENT_QUOTES, 'UTF-8') ?>
$player):
$winrate = ($player['wins'] + $player['losses']) > 0 ?
round(($player['wins'] / ($player['wins'] + $player['losses'])) * 100, 2) : 0;
// Get the most recent duel for this player
$lastDuel = getLastDuelForPlayer($db, $player['steamid']);
// Get player name - use name from mgemod_stats or fallback to steamid
$playerName = !empty($player['name']) ? $player['name'] : $player['steamid'];
?>
%
ID
ELO
-
-
0 ? 'positive' : ($eloChange < 0 ? 'negative' : 'neutral');
echo '' . ($eloChange > 0 ? '+' : '') . $eloChange . ' ';
} else {
echo '- ';
}
?>
:
: |
:
