<?php

session_start();
include 'database.php';


$database = new Database();
$connexion = $database->getConnection();

if ($connexion) {
    
    if(isset($_SESSION['login'])){
        $username = $_SESSION['login'];
    }
    
    $sql = "SELECT * from users where pseudo = '$username'";
    $statement = $connexion->prepare($sql);
    $statement->execute();
                
    $results = $statement->fetchAll(PDO::FETCH_ASSOC);
    foreach ($results as $row) {
        $id = $row['id_user'];
        $vie = $row['vie'];
        $vivres = $row['vivres'];
        $gold = $row['gold'];
        $monde = $row['monde'];
        $quest = $row['quest'];
        $niv = $row['niv'];
        $bateau = $row['bateau'];
        $mess = $row['mess'];
    }

    if(isset($_POST['cause'])){
        $cause = $_POST['cause'];
        if($cause == "lookfor"){
            echo $vie;
            echo ",";
            echo $vivres;
            echo ',';
            echo $gold;
            echo ',';
            echo $monde;
            echo ',';
            echo $quest;
            echo ',';
            echo $niv;
            echo ',';
            echo $bateau;
            echo ',';
            echo $mess;
            
        }
        if($cause == "give"){
            $vie = $_POST['vie'];
            $vivres = $_POST['vivres'];
            $gold = $_POST['gold'];
            $monde = $_POST['monde'];
            $quest = $_POST['quest'];
            $niv = $_POST['niv'];
            $bateau = $_POST['bateau'];
            $mess = $_POST['mess'];
            
            $sql = "UPDATE `users` SET `vie`='$vie',`vivres`='$vivres',`gold`='$gold',`monde`='$monde',`quest`='$quest',`niv`='$niv',`bateau`='$bateau',`mess`='$mess' where pseudo = '$username'";
            $statement = $connexion->prepare($sql);
            $statement->execute();
            
            echo $username;
        }
        
    }
    
    
        
        

}

?>