ZAhST2Dv

1<?php
2
3# Get variables from post method
4
5$Username = $_POST['Username'];
6$Password = $_POST['Password'];
7$HWID     = $_POST['HWID'];
8
9# Static variables
10
11$Inifile = $_SERVER['DOCUMENT_ROOT'];
12$Inifile .= "/Files/Settings.ini";
13$Settings = parse_ini_file($Inifile, true);
14
15$Serverhostname = $Settings['Database']['Hostname'];
16$Databaseuser   = $Settings['Database']['Username'];
17$Databasepass   = $Settings['Database']['Password'];
18$Databasename   = $Settings['Database']['Database'];
19
20$Adminuser = $Settings['Admin']['Username'];
21$Adminpass = $Settings['Admin']['Password'];
22
23$Usertable = $Settings['Tables']['Usertable'];
24$Codetable = $Settings['Tables']['Codetable'];
25
26# Connect to Server
27
28$conn = new mysqli($Serverhostname, $Databaseuser, $Databasepass);
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,
43HWID VARCHAR(255),
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 "{'Username':'${Username}','Authenticated':'false','Description':'Sorry account ${Username} already exists.'}";
54}
55else {
56    $conn->query("INSERT INTO ${Usertable} (Username, Password, Betastatus, HWID, Expires) VALUES ('${Username}', '${Password}', '0', '${HWID}', '0')");
57
58    echo "{'Username':'${Username}','Authenticated':'true','Description':'Account ${Username} successfully created.'}";
59}
60
61# Close our connection
62
63$conn->close();
64
65?>