5 $db = new PDO($osu_db);
10 if (isset($_POST["id"]))
11 $id = preg_replace("/[^a-fA-F0-9]/", "", $_POST["id"]);
13 die("Missing session id");
15 die("Invalid session id");
17 $row = $db->query("SELECT rowid,* FROM sessions WHERE id='$id'")->fetch();
19 die("Session not found");
22 $uri = $row['redirect_uri'];
23 $rowid = $row['rowid'];
24 $realm = $row['realm'];
26 $row = $db->query("SELECT value FROM osu_config WHERE realm='$realm' AND field='free_account'")->fetch();
27 if (!$row || strlen($row['value']) == 0) {
28 die("Free account disabled");
31 $user = $row['value'];
33 $row = $db->query("SELECT password FROM users WHERE identity='$user' AND realm='$realm'")->fetch();
35 die("Free account not found");
37 $pw = $row['password'];
39 if (!$db->exec("UPDATE sessions SET user='$user', password='$pw', realm='$realm', machine_managed='1' WHERE rowid=$rowid")) {
40 die("Failed to update session database");
43 $db->exec("INSERT INTO eventlog(user,realm,sessionid,timestamp,notes) " .
44 "VALUES ('$user', '$realm', '$id', " .
45 "strftime('%Y-%m-%d %H:%M:%f','now'), " .
46 "'completed user input response for a new PPS MO')");
48 header("Location: $uri", true, 302);