<?php

session_start();

require_once("mysql/core.php");

$username = mysql_real_escape_string($_POST['username']);

$password = mysql_real_escape_string(SHA1($_POST['password']));

$mail = mysql_real_escape_string($_POST['mail']);

$look = mysql_real_escape_string($_POST['look']);

$ip_last = mysql_real_escape_string($_POST['ip_last']);


if(isset($_POST['submit'])){


if(mysql_result(mysql_query("SELECT * FROM users WHERE username = '".$username."' AND password = '".$password."'"),0) == 0)

{

$query = mysql_query("INSERT INTO users (username,password,mail,look,ip_last,last_timestamp) VALUES('".$username."','".$password."','".$mail."','".$look."','".$ip_last."',CURRENT_TIMESTAMP)")or die (mysql_error());

}


else


{

echo"<div style=\"width: 100%; background-color: red; color: white; font-size: 24px;margin-top:-10px;margin-left:-8px;text-align:center;height:40px;\">Dein Username ist besetzt!</div>";

}

if(mysql_num_rows($query) == 0)

{

echo"<div style=\"width: 100%; background-color: red; color: white; font-size: 24px;margin-top:-10px;margin-left:-8px;text-align:center;height:40px;\">Du wurdest registiert!</div>";

header("location:home.php");

}


else

{



echo"<div style=\"width: 100%; background-color: red; color: white; font-size: 24px;margin-top:-10px;margin-left:-8px;text-align:center;height:40px;\">Oder du hast nichts angegeben!</div>";

echo"<div style=\"width: 100%; background-color: red; color: white; font-size: 24px;margin-top:-10px;margin-left:-8px;text-align:center;height:40px;\">Captcha nicht angegeben!</div>";


}

}