<?php

    $MysqlHote='localhost';
    $MysqlPort='3306';
    $MysqlBDD='bddname';
    $MysqlUser='root';
    $MysqlPassword='';

    $DisplaypersonnagePrivee = "true"; // affiche les personnage privée mais leur profil reste indisponible


    // ne pas toucher
    try
    {
        $bdd = new PDO('mysql:host='.$MysqlHote.';port='.$MysqlPort.';dbname='.$MysqlBDD, $MysqlUser, $MysqlPassword);
    }
    catch (Exception $e)
    {
            die('BDD_erreur: ' . $e->getMessage());
    }

    $account = htmlentities($_GET["name"]);
    $accountName = null;
    $accountId = null;

    // affichage des compte
    $sql = 'SELECT * FROM accounts WHERE account="'.$account.'"'; //requete sql
    $req = $bdd->query($sql);
    while($row = $req->fetch()) {
                $accountName = $row['account'];
                $accountId = $row['guid'];
            }
    $req->closeCursor();


    // affichage des personnage du compte
    $sql = 'SELECT * FROM personnages WHERE account="'.$accountId.'"';
    $req = $bdd->query($sql);

    while($row = $req->fetch()) {

                if ($DisplaypersonnagePrivee == "true") {
                    if ($row['public'] == "true") {
                        echo "<a href=\"index.php?name=".$accountName."&id=".$row['guid']."\">".$row['name']."</a><br/>";
                    } else {
                        echo $row['name']."<br/>";
                    }
                } else {
                    if ($row['public'] == "true") {
                        echo "<a href=\"index.php?name=".$accountName."&id=".$row['guid']."\">".$row['name']."</a><br/>";
                    }
                }
            }
    $req->closeCursor();



    // sélection du perso + affichage des données
    $personnageID = htmlentities($_GET['id']);
        $sql = 'SELECT * FROM personnages WHERE guid="'.$personnageID.'"';
            $req = $bdd->query($sql);

            while($row = $req->fetch()) {

                        if ($row['public'] == "true") { // si le personnage est privée

                        echo "Nom: ".$row['name']."<br/>";
                        switch ($row['sexe']) {
                            // 0 = Garçon, 1 = Fille
                            case 0:
                                $PySex = "Garçon";
                            break;
                            case 1:
                                $PySex = "Fille";
                            break;
                        }
                        switch ($row['class']) {
                            case 1:
                                echo "Féca";
                                $PyClasse = "Féca";
                            break;
                            case 2:
                                $PyClasse = "Osamodas";
                            break;
                            case 3:
                                $PyClasse = "Enutrof";
                            break;
                            case 4:
                                $PyClasse = "Sram";
                            break;
                            case 5:
                                $PyClasse = "Xélor";
                            break;
                            case 6:
                                $PyClasse = "Ecaflip";
                            break;
                            case 7:
                                $PyClasse = "Eniripsa";
                            break;
                            case 8:
                                $PyClasse = "Iop";
                            break;
                            case 9:
                                $PyClasse = "Crâ";
                            break;
                            case 10:
                                $PyClasse = "Sadida";
                            break;
                            case 11:
                                $PyClasse = "Sacrieur";
                            break;
                            case 12:
                                $PyClasse = "Pandawan";
                            break;
                        }

                        } else {
                            echo "Ce personnage est privée<br/>";
                        }
                    }

    $req->closeCursor();

    if (isset($PySex)) {
        echo "Sex :".$PySex."<br/>";
        echo "Classe :".$PyClasse."<br/>";
    }
?>