date_default_timezone_set('America/Sao_Paulo');
abstract class BancoDados
{
const host = 'localhost';
const novoweb = 'novoweb';
const WebAccount = 'Web_Account';
const Member = 'Member';
const user = 'usuario';
const password = 'senha';
static function conectarW()
{
    try
    {
        $pdoW = new PDO("mysql:host=".self::host.";dbname=".self::novoweb.";charset=utf8", self::user, self::password);
        $pdoW->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        return $pdoW;
    } catch(PDOException $e) {
        echo 'ERROR: ' . $e->getMessage();
    }
}
static function conectarWA()
{
    try
    {
        $pdoWA = new PDO("mysql:host=".self::host.";dbname=".self::WebAccount.";charset=utf8", self::user, self::password);
        $pdoWA->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        return $pdoWA;
    } catch(PDOException $e) {
        echo 'ERROR: ' . $e->getMessage();
    }
}

static function historicoshopweb($pdoWA,$id,$admin)
{
    try {
        if ($admin == 1) {
            $historico = $pdoWA->prepare("SELECT * FROM GameTail  ORDER BY RegDate DESC");
            $historico->execute();
        } else {
            $historico = $pdoWA->prepare("SELECT * FROM GameTail WHERE IdIdx = :id ORDER BY RegDate DESC");
            $historico->bindValue(":id",$id);
            $historico->execute();
        }
            $historicos = $historico->fetchAll(PDO::FETCH_OBJ);

            return $historicos;

    } catch (PDOException $e) {
        echo "ERROR: ".$e->getMessage();
    }
}