From 3873cad7baf5d2f63b4399b7bfb0ec4d7d66adb9 Mon Sep 17 00:00:00 2001 From: Connor Thomson Date: Sat, 19 Sep 2026 17:02:13 -0700 Subject: Add signup and other stuff --- signup/verify/verify.php | 96 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 96 insertions(+) create mode 100644 signup/verify/verify.php (limited to 'signup/verify/verify.php') diff --git a/signup/verify/verify.php b/signup/verify/verify.php new file mode 100644 index 0000000..e5e729f --- /dev/null +++ b/signup/verify/verify.php @@ -0,0 +1,96 @@ +. + */ + +if ($_SERVER["REQUEST_METHOD"] == "POST") { + $code = $_POST['code']; + $user_id = $_COOKIE['user_id'] ?? null; + + if (!$user_id) { + echo "Not logged in."; + exit; + } + + $host = '127.0.0.1'; + $db = 'gnufaultdb'; + $db_user = 'gnufaultdb_user'; + $pass = trim(file_get_contents('/etc/gnufault.d/password')); + + $charset = 'utf8mb4'; + $dsn = "mysql:host=$host;dbname=$db;charset=$charset"; + + $options = [ + PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, + PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, + PDO::ATTR_EMULATE_PREPARES => false, + ]; + + try { + $pdo = new PDO($dsn, $db_user, $pass, $options); + } catch (\PDOException $e) { + throw new \PDOException($e->getMessage(), (int)$e->getCode()); + } + + try { + $sql = "SELECT verification_code FROM users WHERE id = :id"; + $stmt = $pdo->prepare($sql); + + $stmt->execute(['id' => $user_id]); + + $user = $stmt->fetch(); + if (!$user) { + echo "User not found."; + exit; + } + + $real_code = $user['verification_code']; + } catch (\PDOException $e) { + echo "Error: " . $e->getMessage(); + exit; + } + + if ($real_code == '0001') { + echo "Account is already verifed"; + exit; + } + + if ($code != $real_code) { + echo "Code is not correct!"; + exit; + } + + try { + $sql = "UPDATE users SET verification_code = :code WHERE id = :id"; + $stmt = $pdo->prepare($sql); + + $stmt->execute([ + 'code' => '0001', + 'id' => $user_id + ]); + + if ($stmt->rowCount() == 0) { + echo "User not found."; + } + } catch (\PDOException $e) { + echo "Error: " . $e->getMessage(); + exit; + } + + header("Location: /signin"); +} +?> -- cgit v1.2.3