<?php

function newPDO() {
        $host = 'x';
        $db   = 'x';
        $user = 'x';
        $pass = 'x';


        $dsn = "mysql:host=$host;dbname=$db";
        $opt = [
            PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
            PDO::ATTR_EMULATE_PREPARES   => false,
        ];
        $pdo = new PDO($dsn, $user, $pass, $opt);
        return $pdo;
    }

    {
        $pdo = newPDO();
        $stmt = $pdo->prepare('INSERT INTO players (uid, name, avatar) VALUES (:uid, :name, :avatar)');
        $stmt->execute(['uid' => $_SESSION['steam_steamid'], 'name' => $_SESSION['steam_personaname'], 'avatar' => $_SESSION['steam_avatar']]);
        if($pdo->lastInsertId()) {
            //login successfull
            return true;
        } else {
            //registration failed
            return false;
        }
    }

if(!isset($_SESSION['steamid'])) {
    loginbutton("rectangle"); //login button

}  else {
    include ('steamauth/userInfo.php');
    //Protected content
    echo $steamprofile['personaname'];
    echo '<img src="'.$steamprofile['avatar'].'" title="" alt="" />'; // Display their avatar!

    logoutbutton("rectangle");
}
?>