Debian Codegraph @

hs20/server/www/remediation.php

raw
1 <html>
2 <head>
3 <title>Hotspot 2.0 subscription remediation</title>
4 </head>
5 <body>
6
7 <?php
8
9 require('config.php');
10
11 $db = new PDO($osu_db);
12 if (!$db) {
13 die($sqliteerror);
14 }
15
16 if (isset($_GET["session_id"]))
17 $id = preg_replace("/[^a-fA-F0-9]/", "", $_GET["session_id"]);
18 else
19 $id = 0;
20 echo "SessionID: " . $id . "<br>\n";
21
22 $row = $db->query("SELECT * FROM sessions WHERE id='$id'")->fetch();
23 if ($row == false) {
24 die("Session not found");
25 }
26
27 $username = $row['user'];
28 echo "User: " . $username . "@" . $row['realm'] . "<br>\n";
29
30 $user = $db->query("SELECT machine_managed,methods FROM users WHERE identity='$username'")->fetch();
31 if ($user == false) {
32 die("User not found");
33 }
34
35 echo "<hr><br>\n";
36
37 $cert = $user['methods'] == "TLS" || strncmp($username, "cert-", 5) == 0;
38
39 if ($cert) {
40 echo "<a href=\"redirect.php?id=" . $_GET["session_id"] . "\">Complete user subscription remediation</a><br>\n";
41 } else if ($user['machine_managed'] == "1") {
42 echo "<a href=\"redirect.php?id=" . $_GET["session_id"] . "\">Complete user subscription remediation</a><br>\n";
43 echo "This will provide a new machine-generated password.<br>\n";
44 } else {
45 echo "<form action=\"remediation-pw.php\" method=\"POST\">\n";
46 echo "<input type=\"hidden\" name=\"id\" value=\"$id\">\n";
47 echo "New password: <input type=\"password\" name=\"password\"><br>\n";
48 echo "<input type=\"submit\" value=\"Change password\">\n";
49 echo "</form>\n";
50 }
51
52 ?>
53
54 </body>
55 </html>