register.php és insert.php

<?php
define('SERVER', 'mysql.hostinger.hu');
define('USERNAME', 'u794663015_users');
define('PASSWORD', '****');
define('NAME', 'u794663015_users');

/* Attempt to connect to MySQL database */
$user = mysqli_connect(SERVER, USERNAME, PASSWORD, NAME);

// Check connection
if($users === false){
    die("Csatlakozás az adatbázishoz nem sikerült. "/* . mysqli_connect_error()*/);
}



$username    = htmlspecialchars($_POST['username']);
$firstname = htmlspecialchars($_POST['firstname']);
$lastname = htmlspecialchars($_POST['lastname']);
$password = htmlspecialchars($_POST['password']);
$password2 = htmlspecialchars($_POST['password2']);
$email    = htmlspecialchars($_POST['email']);
$gender = $_POST['gender'];
$year = $_POST['year'];
$month = $_POST['month'];
$day = htmlspecialchars($_POST['day']);
$vnev = htmlspecialchars($_POST['firstname']);
$knev = htmlspecialchars($_POST['lastname']);
$birth = $year.'-'.$month.'-'.$day;
$salt = bin2hex(openssl_random_pseudo_bytes(255, $cstrong)); //Salt https://en.wikipedia.org/wiki/Salt_(cryptography)

if (!empty($username))
    {
        if(strlen($username) >= 3)
        {
            if(strlen($username) <= 32)
            {
                if (preg_match("/([\w\-]+\@[\w\-]+\.[\w\-]+)/",$email))
                {
                    if(!empty($firstname))
                    {
                        if(strlen($firstname) >= 3)
                        {
                            if(strlen($firstname) <= 32)
                            {
                                if(!empty($lastname))
                                {
                                    if(strlen($lastname) >= 3)
                                    {
                                        if(strlen($lastname) <= 32)
                                        {
                                            if(!empty($password))
                                            {
                                                if(strlen($password) >= 6)
                                                {
                                                    if(strlen($password) <=60)
                                                    {
                                                        if ($password == $password2) {

$password = $password."".$salt; //Jelszó+Salt
$password = hash('sha512',$password); //sha512-vel hasheljük
mysqli_query($users,$sql="INSERT INTO users (
  sor,
  email,
  nyelv,
  gender,
  birth,
  firstname,
  lastname,
  gold,
  silver,
  lv,
  xp,
  asxp,
  alapero,
  eropont,
  alaphp,
  password,
  username
) VALUES (
'A1',

$email,
'hu',
$gender,
$birth,
$vnev,
$knev,
'10',
'50',
'1',
'0',
'100',
'100',
'0',
'1000',
$password,
$username");
/*A2 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
  username
) VALUES (
'A2',
$username");
/*A3 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
  username
)VALUES (
'A3',
$username");
/*A4 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
  username
)VALUES (
'A4',
$username");
/*A5 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
  username
) VALUES (
'A5',
$username");
/*A6 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'A6',
$username");
/*A7 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'A7',
$username");
/*A8 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'A8',
$username");
/*A9 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'A9',
$username");


/*B1 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'B1',
$username");
/*B2 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'B2',
$username");
/*B3 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'B3',
$username");
/*B4 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'B4',
$username");
/*B5 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'B5,
$username");

/*B6 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'B6',
$username");
/*B7 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'B7',
$username");

/*B8 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'B8',
$username");
/*B9 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'B9',
$username");


/*C1 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'C1',
$username");
/*C2 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'C2',
$username");
/*C3 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'C3',
$username");
/*C4 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'C4',
$username");
/*C5 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'C5',
$username");
/*C6 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'C6',
$username");
/*C7 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'C7',
$username");
/*C8 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'C8',
$username");
/*C9 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'C9',
$username");



/*P1 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'P1',
$username");
/*P2 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'P2',
$username");
/*P3 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'P3',
$username");
/*P4 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'P4',
$username");
/*P5 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'P5',
$username");
/*AU1 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'AU1',
$username");
/*AU2 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'AU2',
$username");
/*AU3 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'AU3',
$username");
/*AU4 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'AU4',
$username");
/*AU5 sor*/
mysqli_query($users,$sql="INSERT INTO users (
  sor,
   username
) VALUES (
'AU5',

$username");
mysqli_query($users,$sql="INSERT INTO userlist (username)
  VALUES ($username)");
header ("Location:index.php");



                                                        }else
                                                        {
                                                        echo("A 2 jelszo nem egyezik!");
                                                        }
                                                    }else
                                                    {
                                                    echo("A jelszó túl hosszú! Max 60 karakter!");
                                                    }
                                                }else
                                                {
                                                echo("A jelszó rövid! Min 6 karakter!");
                                                }
                                            }else
                                            {
                                            echo("A jelszó mező nem lehet üres!");
                                            }
                                        } else
                                        {
                                        echo("A vezetéknév túl hosszú! Max 32 karakter!");
                                        }
                                    } else
                                    {
                                    echo("A vezetéknév rövid! Min 3 karakter!");
                                    }
                                } else
                                {
                                echo("A vezetéknév mező nem lehet üres!");
                                }
                            } else
                            {
                            echo("A keresztnév túl hosszú! Max 32 karakter!");
                            }
                        } else
                        {
                        echo("A keresztnév rövid! Min 3 karakter!");
                        }
                    }else
                    {
                    echo("A keresztnév mező nem lehet üres!");
                    }
                }else
                {
                echo("E-mail address not valid");

                }


        } else
        {
        echo("A felhasználó név túl hosszú! Max 32 karakter!");
        }
        } else
        {
        echo("A felhasználó név rövid! Min 3 karakter!");
        }
    }else
    {
    echo("A felhasználó név mező nem lehet üres!");
    }
?>