prepare("SELECT * FROM mm_current_rating WHERE mob = ?"); $query->execute([$mob]); $result = $query->fetch(PDO::FETCH_ASSOC); return $result["rating"]; } function addMatch(int $mob1, int $mob2, int $winner, string $session): void { global $pdo; $query = $pdo->prepare("INSERT INTO mm_matches (mob1fk, mob2fk, winner, session) VALUES (?, ?, ?, ?) RETURNING id"); $query->execute([$mob1, $mob2, $winner, $session]); $result = $query->fetch(PDO::FETCH_ASSOC); auditLog(AUDIT_EVENT_MATCH_ADDED, session_id(), $result["id"]); } function getMobsWithMetaData($orderBy = "rating", $direction = "DESC"): array { global $pdo; $query = $pdo->prepare(<<execute(); return $query->fetchAll(PDO::FETCH_ASSOC); } function getRatingTrends(): array { global $pdo; $query = $pdo->prepare(<<execute(); $results = $query->fetchAll(PDO::FETCH_ASSOC); $trends = []; foreach ($results as $result) { $trendsForMob = []; if (isset($trends[$result['mob']])) { $trendsForMob = $trends[$result['mob']]; } $trendsForMob[] = $result; $trends[$result['mob']] = $trendsForMob; } return $trends; }