Untitled

registrace.php
<?php
/**
 * Created by PhpStorm.
 * User: marti_000
 * Date: 7. 1. 2016
 * Time: 9:44
 */
?>
<!DOCTYPE html>
<html>
<head>
    <title>
        Registrace - Vaom
    </title>
    <link rel="stylesheet" href="css/index.css">
    <meta charset="UTF-8">
    <meta name="keywords" content="vaom,metin,metin2,metin privat,metin2 privat ">
    <meta name="author" content="Martin Horáček">
    <meta name="description" content="vaom.eu,metin,metin2 privátní server">
    <link rel="shortcut icon" href="/img/favicon.png" type="image/png">
    <link rel="icon" href="/img/favicon.png" type="image/png">
</head>
<body>
<div id="obal">
    <div id="header">
        <img src="img/favicon.png" height="125px" align="left">
        <a href="registrace.php">
            <h2>
                Registrace
            </h2>
        </a>
        <a href="prihlaseni.php">
            <h2>
                Přihlášení
            </h2>
        </a>
    </div>
    <div id="text">
        <?php
        if(isset($_GET['chyba'])) {
            echo "<h3>$_GET[chyba]</h3>";
        }
        ?>
        <form method="post" action="register.php">
            <table align="center">
                <tr>
                    <td>
                        Jméno :
                    </td>
                    <td>
                        <input type="text" name="name">
                    </td>
                </tr>
                <tr>
                    <td>
                        Příjmení :
                    </td>
                    <td>
                        <input type="text" name="surname">
                    </td>
                </tr>
                <tr>
                    <td>
                        Přihlašovací jméno * :
                    </td>
                    <td>
                        <input type="text" name="username" required>
                    </td>
                </tr>
                <tr>
                    <td>
                        Heslo * :
                    </td>
                    <td>
                        <input type="password" name="password" required>
                    </td>
                </tr>
                <tr>
                    <td>
                        E-Mail * :
                    </td>
                    <td>
                        <input type="email" name="mail" required>
                    </td>
                </tr>
                <tr>
                    <td>
                        Přijímám <a href="/files/podminky.php" target="_blank">podmínky registrace</a> *
                    </td>
                    <td>
                        <input type="checkbox" required>
                    </td>
                </tr>
                <tr>
                    <td>
                        Označená pole hvězdičkou jsou povinná!
                    </td>
                </tr>
                <tr>
                    <td>
                        <input type="submit" value="Odeslat">
                    </td>
                    <td>
                        <input type="reset">
                    </td>
                </tr>
            </table>
        </form>
    </div>
</div>
</body>
</html>


register.php
<?php
/**
 * Created by PhpStorm.
 * User: marti_000
 * Date: 7. 1. 2016
 * Time: 9:39
 */
?>
<?php
session_start();
include_once "db.php";
$database = new MyDB("mysql","localhost","c9martinho1","heslo","c9vaom_eu");
$test = $database->queryAll("SELECT * FROM users WHERE username=:username AND mail=:mail",
    array(
        ":username" => $_POST['username'],
        ":mail" => $_POST['mail']
    )
);
if(count($test)==0){
    $obsazeno=0;
}
else {
    $obsazeno=1;
}
if($obsazeno=0) {
    $database->query("INSERT INTO users (username,password,mail,name,surname,vop) VALUES (:username,:password,:mail,:name,:surname,:vop)",
        array(
            ":username" => $_POST['username'],
            ":password" => sha1($_POST['password']),
            ":mail" => $_POST['mail'],
            ":name" => $_POST['name'],
            ":surname" => $_POST['surname'],
            ":vop" => 'ANO'
        )
    );
    mkdir("users/$_POST[username]");
    copy("nepristupne/.htaccess","users/$_POST[username]/.htaccess");
    copy("nepristupne/new-user.php","users/$_POST[username]/index.php");
    copy("nepristupne/db.php","users/$_POST[username]/db.php");
    ?>
    <meta http-equiv="refresh" content="0;prihlaseni.php?chyba=Registrace úspěšná.">
    <?php
}
if($obsazeno=1) {
    ?>
    <meta http-equiv="refresh" content="0;registrace.php?chyba=Uživateslké jméno či Email je používán.">
    <?php
}
?>