QvR9HEXg

1<?php
2$Username = $_POST['Username'];
3$Email    = $_POST['Email'];
4$Password = $_POST['Password'];
5
6# Static variables
7
8$Inifile = $_SERVER['DOCUMENT_ROOT'];
9$Inifile .= "/files/Settings.ini";
10$Settings = parse_ini_file($Inifile, true);
11
12$Serverhostname = $Settings['Database']['Hostname'];
13$Databaseuser   = $Settings['Database']['Username'];
14$Databasepass   = $Settings['Database']['Password'];
15$Databasename   = $Settings['Database']['Database'];
16
17$Adminuser = $Settings['Admin']['Username'];
18$Adminpass = $Settings['Admin']['Password'];
19
20$Usertable = $Settings['Tables']['Usertable'];
21
22# Connect to Server
23
24$conn = new mysqli($Serverhostname, $Databaseuser, $Databasepass);
25
26if($conn->connect_error) {
27    die("connection failed: " . $conn->connect_error);
28}
29
30# Check if Database exists if not create it
31
32$conn->query("CREATE DATABASE IF NOT EXISTS ${Databasename}");
33
34# Check if Table exists if not create it
35
36$conn = new mysqli($Serverhostname, $Databaseuser, $Databasepass, $Databasename);
37
38$sql = "CREATE TABLE IF NOT EXISTS ${Usertable} (
39id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
40Username VARCHAR(255) NOT NULL,
41Password VARCHAR(255) NOT NULL,
42Betastatus VARCHAR(1) NOT NULL,
43Email VARCHAR(255) NOT NULL,
44Expires VARCHAR(255),
45Updated TIMESTAMP
46)";
47
48$conn->query($sql);
49
50# Calculate results
51
52if ($conn->query("SELECT * FROM ${Usertable} WHERE Username = '${Username}'")->num_rows >= 1) {
53    echo "<script>
54		alert('Sorry account ${Username} already exists.');
55		window.history.go(-1);
56	 </script>";
57}
58elseif ($conn->query("SELECT * FROM ${Usertable} WHERE Email = '${Email}'")->num_rows >= 1) {
59        echo "<script>
60		alert('Sorry Email: ${Email} is alreay registered.');
61		window.history.go(-1);
62	 </script>";
63}
64else {
65    $conn->query("INSERT INTO ${Usertable} (Username, Password, Email, Betastatus, Expires) VALUES ('${Username}', '${Password}', '${Email}', '0', '0') ");
66  
67    echo "<script>
68		alert('You are registered. Your Username is: ${Username}.');
69		window.history.go(-2);
70	 </script>";
71}
72
73# Close our connection
74
75$conn->close();
76
77?>