<?php

    function newPDO() {
        $host = 'gnetwork.site';
        $db   = 'xxxxx';
        $user = 'xxxxxxx';
        $pass = 'xxxxxxxx';
        $charset = 'UTF-8';

        $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
        $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;
    }
    function regUser() {
        $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 {
        //To access the $steamprofile array
        //Protected content
        include ('steamauth/userInfo.php');
        if(regUser()) {
            DoStuffAfterReg();
        } else {
            displayErrorToUser();
        }

?>