Untitled

<?php // settings/setting.php
function connectdb()
{
    $hostname = "localhost";
    $username = "root";
    $password = "";
    $database = "armazmcrp";
    $connect = mysqli_connect($hostname, $username, $password, $database);
    if (!$connect)) {
        echo "Verifique as configurações de conexão com o banco de dados.";
    }
}
?>
-----------------------------------------------------------------------------------------------------------
<?php

include_once("settings/setting.php");
connectdb();
@session_start();

$usuario = $_SESSION['Username'];

if(isset($_SESSION['temposessao'])) {
    if($_SESSION['temposessao'] < time()) {
        header("Location: leave.php");
        exit;
    } else {
        $_SESSION['temposessao'] = time() + 3600;
    }
}

if(!isset($_SESSION['Username'])) {
    header("Location: login.php");
    exit;
}

?>

<!DOCTYPE html>

<html lang="pt-br">

<head>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">

    <title>ALT:RP | Painel de Controle do Usuário</title>

    <link href="dist/css/bootstrap.min.css" rel="stylesheet">

    <link href="assets/css/ie10-viewport-bug-workaround.css" rel="stylesheet">

    <link href="styleatt.css" rel="stylesheet">

    <script src="assets/js/ie-emulation-modes-warning.js"></script>

</head>

<body>

<nav class="navbar navbar-inverse navbar-fixed-top">
    <div class="container-fluid">
        <div class="navbar-header">
            <a class="navbar-brand" href="index.php">County Roleplay</a>
        </div>
        <div id="navbar" class="navbar-collapse collapse">
            <ul class="nav navbar-nav navbar-right">
                <li class="dropdown">
                    <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false"><?php echo $usuario;?><span class="caret"></span></a>
                    <ul class="dropdown-menu">
                        <li><a href="leave.php">Deslogar</a></li>
                    </ul>
                </li>
            </ul>
        </div>
    </div>
</nav>

<div class="container-fluid">
    <div class="row">
        <div class="col-sm-3 col-md-2 sidebar">
            <ul class="nav nav-sidebar">
                <li><a href="index.php">Início</a></li>
                <li class="active"><a href="personagens.php">Personagens<span class="sr-only">(current)</span></a></li>
                <li><a href="mcp.php">Paínel De Controle do Moderador</a></li>
                <li><a href="acp.php">Paínel De Controle do Administrador</a></li>
            </ul>
        </div>
        <div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">
            <h1 class="page-header">Personagens</h1>
            <div>
                <div class="alert alert-warning btn-block">
                    <center>Os dados solicitados abaixo deverão ser preenchidos em nome de seu personagem.</center>
                </div>
                <div class="alert alert-warning btn-block">
                    <center>Após finalizar a aplicação, você deverá aguardar até que a mesma seja avaliada por um administrador.</center>
                </div>
            </div>
            <div class="col-md-3">

                <form class="form-signin" method="POST" enctype="multiparty/form-data">

                    <input type="text" name="nome" class="form-control" placeholder="Nome_Sobrenome" required autofocus>
            </div>
            <div class="col-md-3">
                <input type="date" name="birthdate" class="form-control" required>
            </div><br/><br/>
            <div class="col-md-3">
                <input type="text" name="origin" class="form-control" placeholder="Origem" required>
            </div>
            <div class="col-md-3">
                <select style="width:100%;" name="gender" class="form-control" >
                    <option>Masculino</option>
                    <option>Feminino</option>
                </select>
            </div>
            <div class="col-md-4"><button class="btn btn-lg btn-primary btn-block" type="submit" value="criar">Enviar</button>
                <input type="hidden" name="criar" value="criar">
            </div>
            </form>
        </div>
        <?php

        if(isset($_POST['criar'])) {
            $nome = $_POST['nome'];
            $birthdate = $_POST['birthdate'];
            $origin = $_POST['origin'];
            $gender = $_POST['gender'];
            $birthdate = str_replace("-", "", $birthdate);

            if(empty($nome) || empty($origin)) {
                echo "Preencha todos os campos.";
            } else {
                $query = "SELECT * FROM characters WHERE `Character` = '$nome'";
                $result = mysqli_query($connect, $query);
                $conta = mysqli_num_rows($result);
                $busca = mysqli_fetch_assoc($result);

                if($conta > 0) {
                    echo "Este personagem já existe.";
                }     if($conta > 0) {
                    echo "Este personagem já existe.";
                } else {
                    $criar = "INSERT INTO characters (`Username`, `Character`, `Birthdate`, `Origin`, `Gender`, `Created`, `Skin`, `Money`, `BankMoney` ) VALUES ('$usuario', $nome', '$birthdate', '$origin', '$gender', '1', '26', '250', '250' )";
                    mysqli_query($connect, $criar);
                    echo "Você criou um personagem com sucesso.";

                }


            }
        }

        ?>
    </div>
</div>
</div>

<script src="libs/jquery/jquery.min.js"></script>
<script>window.jQuery || document.write('<script src="assets/js/vendor/jquery.min.js"><\/script>')</script>
<script src="dist/js/bootstrap.min.js"></script>

<script src="assets/js/vendor/holder.min.js"></script>

<script src="assets/js/ie10-viewport-bug-workaround.js"></script>
<!-- jQuery -->
<script src="assets/js/jquery-1.11.3.min.js"></script>

<!-- Bootstrap Core JavaScript -->
<script src="assets/js/bootstrap.min.js"></script>

<!-- Plugin JavaScript -->
<script src="assets/js/jquery.easing.min.js"></script>

<!-- Custom Javascript -->
<script src="assets/js/custom.js"></script>

</body>

</html>