A9MxgqMj

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