<?php
require ('steamauth/steamauth.php');
include ('steamauth/userInfo.php');
include ('database.php');

if(!$_SESSION['steamid']){
    header("location: login.php");
    exit();
}

$hexsteam = base_convert ($steamprofile['steamid'], 10, 16);

$sql = "SELECT * FROM users WHERE identifier='steam:".$hexsteam."'";
$result = $conn->query($sql);

$sqlphone = "SELECT * FROM gksphone_settings WHERE identifier='steam:".$hexsteam."'";
$resultphone = $conn->query($sqlphone);

$sqlblack = "SELECT * FROM user_accounts WHERE identifier='steam:".$hexsteam."'";
$resultblack = $conn->query($sqlblack);

while($row = $result->fetch_assoc()) {
    $cabarp['nom'] = $row['name'];
    $cabarp['nombre'] = $row['firstname'];
    $cabarp['apellido'] = $row['lastname'];
    $cabarp['cumple'] = $row['dateofbirth'];
    $cabarp['plata'] = $row['money'];
    $cabarp['banco'] = $row['bank'];
    $cabarp['trabajo'] = $row['job'];
    $cabarp['trabajogrupo'] = $row['job_grade'];
}

$sqljob_name = "SELECT * FROM jobs  WHERE name='".$cabarp['trabajo']."'";
$resultjob_name = $conn->query($sqljob_name);

$sqljob = "SELECT * FROM job_grades WHERE grade='".$cabarp['trabajogrupo']."'  AND job_name='".$cabarp['trabajo']."'";
$resultjob = $conn->query($sqljob);

?>
<!doctype html>
<html>
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link rel="stylesheet" href="../css.css">
    <script src="https://kit.fontawesome.com/5a5d8733bd.js" crossorigin="anonymous"></script>
    <style>
        @import url('https://fonts.googleapis.com/css2?family=Rowdies:wght@300&display=swap');
        @import url('https://fonts.googleapis.com/css2?family=Michroma&display=swap');
    </style>
    <title>Caba RP</title>
</head>
<body class="luz">
<header>
        <nav id="navegador">
            <img class="logo" src="../caba.png" alt="cabarp">
            <ul>
                <li><a href="../index.html">Home</a></li>
                <li><a href="../normativas.html">Normativas</a></li>
                <li><a href="../dashboard.php">Formulario</a></li>
                <li ><a id="pcu" href="usuario/dashboard.php"><i class="fa-solid fa-desktop"></i> PCU</a></li>
                <li  id="discord"><a class="btn" href=""><i class="fa-brands fa-discord"></i> Discord</a></li>
            </ul>
            <div class="botoncolor">
                <button class="switch" id="switch">
                    <span><i class="fa-solid fa-moon"></i></span>
                    <span><i class="fa-solid fa-sun"></i></span>
                </button>
            </div>
        </nav>
    </header>
    <div class="titulo">
        <h3> Bienvenido al <h3 class="tipotitulo">Panel de control del usuario de</h3></h3>
        <img class="logo" src="../caba.png" alt="">
        
    </div>
    <div class="tarjeta">
        <div class="steams">
        <img class="discordimg" width="64px" src="<?php echo $steamprofile['avatarfull']?>" title="" alt="" />
        <h2><?php echo $steamprofile['personaname'] ?> </h2>
        
        </div>
        <h2>Hola <?php 
        if ($result->num_rows > 0) {  
            echo "".$cabarp['nom']."";
            } else {
                echo "no encontrado";
            };
        ?></h2>
        <div>
        <h4 id="linea1" class="normal"><?php 
        if ($resultjob_name->num_rows > 0) {
            // output data of each row
            while($rowjob_name = $resultjob_name->fetch_assoc()) {
                echo "" . $rowjob_name["label"]. "";
            }
        } else {
            echo "no encontrado";
        }                              
        ?></h4>
        <p class="normal"><?php
        if ($resultjob->num_rows > 0) {
            // output data of each row
            while($rowjob = $resultjob->fetch_assoc()) {
                echo "" . $rowjob["label"]. "";
                
            }
        } else {
            echo "no encontrado";
        }   
        ?></p>
        <div>
        <?php logoutbutton(); ?>
        </div>
        </div>
    </div>
    <div class="ucp">
        <div class="tarjeta">
            <h3>Informacion del personaje</h3>
            <div>
                <form>
                    <div class="grupoform">
                        <label>Nombre y Apellido:</label>
                        <div class="flex">
                        <input class="ucpinput" value= <?php 
                        if ($result->num_rows > 0) {
                            // output data of each row
                            print ("".$cabarp['nombre']. "".$cabarp['apellido']."");
                        } else {
                            echo "no encontrado";
                        };
                        ?> type="text" readonly>
                        </div>
                    </div>
                    <div class="grupoform">
                        <label>Fecha de nacimiento:</label>
                        <div class="flex">
                        <input class="ucpinput" value= <?php 
                        if ($result->num_rows > 0) {  
                        echo "".$cabarp['cumple']."";
                        } else {
                            echo "no encontrado";
                        };
                        ?> type="text" readonly>
                        </div>
                    </div>
                    <div class="grupoform">
                        <label>Numero de telefono:</label>
                        <div class="flex">
                        <input class="ucpinput" value= <?php  
                        if ($resultphone->num_rows > 0) {
                            // output data of each row
                            while($rowphone = $resultphone->fetch_assoc()) {
                                echo "" . $rowphone["phone_number"]. "";
                            }
                        } else {
                            echo "no encontrado";
                        }   
                        
                        ?> type="text" readonly>
                        </div>    
                    </div>
                </form>
            </div>
            <h3>Informacion bancaria</h3>
            <div>
                <form>
                    <div class="grupoform">
                        <label>Plata en efectivo:</label>
                        <div class="flex">
                        <input class="ucpinput" value= <?php 
                        if ($result->num_rows > 0) {  
                            echo "$".$cabarp['plata']."";
                            } else {
                                echo "no encontrado";
                            };                        
                        ?> type="text" readonly>
                        </div>
                    </div>
                    <div class="grupoform">
                        <label>Plata en el banco:</label>
                        <div class="flex">
                        <input class="ucpinput" value= <?php 
                        if ($result->num_rows > 0) {  
                        echo "$".$cabarp['banco']."";
                        } else {
                            echo "no encontrado";
                        };
                        ?> type="text" readonly>
                        </div>
                    </div>
                    <div class="grupoform">
                        <label>Plata negra:</label>
                        <div class="flex">
                        <input class="ucpinput" value= 
                        <?php  
                        if ($resultblack->num_rows > 0) {
                            // output data of each row
                            while($rowblack = $resultblack->fetch_assoc()) {
                                echo "$" . $rowblack["money"]. "";
                            }
                        } else {
                            echo "no encontrado";
                        }   
                        
                        ?> 
                        type="text" readonly>
                        </div>    
                    </div>
                    <div class="grupoform">
                        <label>Plata negra:</label>
                        <div class="flex">
                        <input class="ucpinput" value= " xd lol" type="text" readonly>
                        </div>    
                        
                    </div>
                </form>
            </div>
        </div>
    </div>

</body>
</html>