1Jk7eRdp

1<?php
2///////////////////////
3/// set consts
4//////////////////////
5$DEBUG_MODE = true;
6$USER = "USER";
7$PASSWORD = "PASSWORD";
8$ERROR_NODB = "COULD NOT CONNECT";
9$ERROR_EXISTS = "ID ALREADY EXISTS";
10
11 
12
13///////////////////////
14/// get hardware id and code and validate
15//////////////////////
16$hwid = $_POST["hwid"];
17$code = $_POST["code"];
18if ($hwid == "" || $code == "") return;
19if (!ctype_alnum($hwid) || !ctype_alnum($hwid)) return;
20
21$hwid = mysql_real_escape_string($hwid);
22$code = mysql_real_escape_string($code);
23
24
25
26//////////////////////
27/// connect to db
28//////////////////////
29$con = mysql_connect("localhost", $USER, $PASSWORD);
30if (!$con) die($ERROR_NODB . " " . mysql_error());
31
32
33
34//////////////////////
35/// create table if not exists
36//////////////////////
37mysql_select_db("somesite_users", $con);
38$sql = "CREATE TABLE IF NOT EXISTS USERS(HWID varchar(15), CODE varchar(15))";
39mysql_query($sql, $con);
40
41
42
43
44//////////////////////
45/// show all
46//////////////////////
47$result = mysql_query("SELECT HWID FROM USERS WHERE HWID = '$hwid'");
48while($row = mysql_fetch_array($result)) {
49      echo $ERROR_EXISTS;
50      return;
51}
52
53
54
55//////////////////////
56/// write the values (if they don't exist)
57//////////////////////
58mysql_query("INSERT INTO USERS(HWID, CODE) VALUES ('$hwid', '$code')");
59
60
61
62
63if ($DEBUG_MODE) {
64//////////////////////
65/// show all
66//////////////////////
67$result = mysql_query("SELECT * FROM USERS");
68while($row = mysql_fetch_array($result)) {
69  echo $row['HWID'] . " -- " . $row['CODE'];
70  echo "<br>";
71}
72}
73
74
75mysql_close($con);
76?>