<?php
/*##############################################
  #            Shadowcms             #
  #                 © 2011                     #
  #                Devbest                     #
  #                                            #
  ##############################################
*/

//Database Info
$dbhost = "localhost"; // Default is localhost
$dbname = "shadowcms"; //Database
$dbuser = "root"; // Default is root
$dbpass = "PASSWORD"; //phpmyadmin password

//Connecting to database yay!
mysql_connect($dbhost, $dbuser, $dbpass) or die ("Could not conenct: ".mysql_error());
mysql_select_db($dbname) or die (mysql_error());

//Getting started with the real script
$name = $_POST['name'];
$email = $_POST['email'];
$username = $_POST['username'];
$password = md5($_POST['password']); //Passwords are now secured with MD5

$checkuser = mysql_query("SELECT username FROM users WHERE username = '$username'");
$username_exist = mysql_num_rows($checkuser);

if($username_exist > 0) {
  echo "Sorry but this username is already registered according to our database records.";
  unset($username);
  exit();
}

// No errors right? Lets insert it into our database
$query ="INSERT INTO users(name, email, username, password) VALUES('$name', '$email', '$username', '$password')";
mysql_query($query) or die (mysql_error());
mysql_close();

echo "You have successfully registered";
?>