include.php

<?php

declare(strict_types=1);

class Player
{
    public int $player_id;
    public string $name;
    public int $elo1;
    public int $free_elo1;
    public int $elo2;
    public int $free_elo2;
}

require 'identity.php';
$pdo = new PDO("mysql:host=$MYSQL_SERVER;dbname=$MYSQL_DB_NAME", $MYSQL_USER, $MYSQL_PASSWORD);

// $pdo = new PDO('mysql:host=localhost;dbname=elo', 'root', '');

//$pdo->query("SET time_zone = 'Europe/Berlin'");

function add_player(string $name, PDO $pdo): bool
{
    try {
        $statement = $pdo->prepare("INSERT INTO `player` (`name`) VALUES (:new_name)");
        return $statement->execute([':new_name' => $name]);
    } catch (PDOException $th) {
        return false;
    }
}

function add_game1(Player $winner, Player $loser, PDO $pdo): bool
{
    $statement = $pdo->prepare(
        "INSERT INTO `game` (`winner1_id`, `winner1_old_elo`, `loser1_id`, `loser1_old_elo`) VALUES (:winner_id, :winner_old_elo, :loser_id, :loser_old_elo)"
    );
    return $statement->execute(
        [
            ':winner_id' => $winner->player_id,
            ':winner_old_elo' => $winner->elo1,
            ':loser_id' => $loser->player_id,
            ':loser_old_elo' => $loser->elo1
        ]
    );
}

function add_game2(Player $winner1, Player $winner2, Player $loser1, Player $loser2, PDO $pdo): bool
{
    $statement = $pdo->prepare(
        "INSERT INTO `game` (`winner1_id`, `winner1_old_elo`, `winner2_id`, `winner2_old_elo`, `loser1_id`, `loser1_old_elo`, `loser2_id`, `loser2_old_elo`)
        VALUES (:winner1_id, :winner1_old_elo, :winner2_id, :winner2_old_elo, :loser1_id, :loser1_old_elo, :loser2_id, :loser2_old_elo)"
    );
    return $statement->execute(
        [
            ':winner1_id' => $winner1->player_id,
            ':winner1_old_elo' => $winner1->elo2,
            ':winner2_id' => $winner2->player_id,
            ':winner2_old_elo' => $winner2->elo2,
            ':loser1_id' => $loser1->player_id,
            ':loser1_old_elo' => $loser1->elo2,
            ':loser2_id' => $loser2->player_id,
            ':loser2_old_elo' => $loser2->elo2
        ]
    );
}

function get_player_by_name(string $name, PDO $pdo): Player|false
{
    $statement = $pdo->prepare("SELECT *  FROM `player` WHERE `name` LIKE :name");
    $statement->execute([':name' => $name]);
    return $statement->fetchObject('Player');
}

function get_player_by_id(int $player_id, PDO $pdo): Player|false
{
    $statement = $pdo->prepare("SELECT *  FROM `player` WHERE `player_id` LIKE :player_id");
    $statement->execute([':player_id' => $player_id]);
    return $statement->fetchObject('Player');
}

/**
 * @return array<int, Player>
 */
function get_players(PDO $pdo)
{
    $statement = $pdo->query('SELECT * FROM `player` ORDER BY GREATEST(`player`.`elo1`,`player`.`elo2`) DESC, `player`.`player_id` ASC');
    $statement->setFetchMode(PDO::FETCH_CLASS, 'Player');
    $return = $statement->fetchAll();
    return ($return != false) ? $return : [];
}

function set_player(Player $player, PDO $pdo): bool
{
    $statement = $pdo->prepare(
        "UPDATE `player` SET `name` = :name, `elo1` = :elo1, `free_elo1` = :free_elo1, `elo2` = :elo2, `free_elo2` = :free_elo2 WHERE `player`.`player_id` = :player_id"
    );
    return $statement->execute(
        [
            ':player_id' => $player->player_id,
            ':name' => $player->name,
            ':elo1' => $player->elo1,
            ':free_elo1' => $player->free_elo1,
            ':elo2' => $player->elo2,
            ':free_elo2' => $player->free_elo2
        ]
    );
}

function regex_print_players(array $players)
{
    $first = true;
    foreach ($players as $player) {
        $name = str_replace("\-", "-", preg_quote($player->name));
        if ($first) {
            echo $name;
            $first = false;
        } else {
            echo "|" . $name;
        }
    }
}