<?php
if(isset($_GET["id"]) == false) {
    die("No id");
}
$id = steam32to64($_GET["id"]);
$sqluser = "stn6swebhost";
$sqlpassword = "oaw8dojfas";
$database = "stn6swebhost_mybb";
$dsn = "mysql:dbname=" . $database . ";host=localhost";
try {
    $pdo = new PDO($dsn, $sqluser, $sqlpassword);
}
catch(PDOException $e) {
    die("SQL Connection failed");
}
$query = 'SELECT * FROM mybb_users WHERE loginname=:loginname';
$prep = $pdo->prepare($query);
$prep->bindParam(':loginname', $id, PDO::PARAM_STR);
$prep->execute();

if($prep != false) {
    $fetched = $prep->fetchAll();
    if(empty($fetched) == false) {
        echo "true";
    }
    else {
        echo "false";
    }
}
else {
    echo "false";
}

function steam32to64($steamId) {

    $gameType = 0;
    $authServer = 0;
    $clientId = '';


    $steamId = str_replace('STEAM_', '' ,$steamId);


    $parts = explode(':', $steamId);
    $gameType = $parts[0];
    $authServer = $parts[1];
    $clientId = $parts[2];


	$result = 76561197960265728 + $authServer;
	$result = $result + ($clientId * 2);
    return $result;
}
?>