Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $connection = mysql_connect("localhost","root","");
- if (!$connection)
- {
- die('Connection interupted, please try again later' . mysql_error());
- }
- mysql_select_db("game", $connection);
- if(isset($_POST['submit']))
- {
- $user = mysql_real_escape_string($_POST['user']);
- $pass = mysql_real_escape_string($_POST['pass']);
- $name = mysql_real_escape_string($_POST['name']);
- $lname = mysql_real_escape_string($_POST['lname']);
- $email = mysql_real_escape_string($_POST['email']);
- $secq = mysql_real_escape_string($_POST['secq']);
- $secansw = mysql_real_escape_string($_POST['secansw']);
- if(empty($user) || empty($pass) || empty($name) || empty($lname) || empty($email) || empty($secq))
- {
- $errors[] = 'You have left empty fields';
- }
- else
- {
- $user_test_query = mysql_query("SELECT acc_name FROM account WHERE acc_name = '$user' LIMIT 1") or die(mysql_error());
- if (mysql_num_rows($user_test_query) == 1)
- {
- $errors[] = 'This username already exists. Please try again.';
- }
- if(!preg_match('#^[a-z0-9]{8,16}$#i', $pass))
- {
- $errors[] = 'Bad password, make sure the password contains 0-9 and a-z ! and is longer then 8 characters and smaller then 16 characters';
- }
- }
- if(count((array) $errors)
- {
- $user_insert = mysql_query("INSERT INTO account (acc_name,acc_pw,acc_rn,acc_rsn,acc_em,acc_sq,acc_sa) VALUES ('" . $user . "', '" . $pass . "', '" . $name . "', '" . $lname . "', '" . $email . "', "' . $secq . "', '" . $secansw . "')") or die(mysql_error());
- if(isset($user_insert))
- {
- echo 'Registration succesfull, you can now log in';
- }
- }
- else
- {
- implode("<br />", $errors);
- }
- }
- mysql_close($connection);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement