opt(); session_start(); if (!isset($_SESSION["userid"])) { header("Location: " . getFullPath("login.php")); exit; } else if ($_SESSION["admin"] != 1) { echo "You don't have admin privileges."; exit; } else { $userid = $_SESSION["userid"]; } $action = $_GET["action"]; if ($action == "approve") { $pwd = generatePassword($opt); if ($_GET["familyid"] != "") { $stmt = $smarty->dbh()->prepare("INSERT INTO {$opt["table_prefix"]}memberships(userid,familyid) VALUES(?, ?)"); $stmt->bindValue(1, (int) $_GET["userid"], PDO::PARAM_INT); $stmt->bindValue(2, (int) $_GET["familyid"], PDO::PARAM_INT); $stmt->execute(); } $stmt = $smarty->dbh()->prepare("UPDATE {$opt["table_prefix"]}users SET approved = 1, password = {$opt["password_hasher"]}(?) WHERE userid = ?"); $stmt->bindParam(1, $pwd, PDO::PARAM_INT); $stmt->bindValue(2, (int) $_GET["userid"], PDO::PARAM_INT); $stmt->execute(); // send the e-mails $stmt = $smarty->dbh()->prepare("SELECT username, email FROM {$opt["table_prefix"]}users WHERE userid = ?"); $stmt->bindValue(1, (int) $_GET["userid"], PDO::PARAM_INT); $stmt->execute(); if ($row = $stmt->fetch()) { mail( $row["email"], "Gift Registry application approved", "Your Gift Registry application was approved by " . $_SESSION["fullname"] . ".\r\n" . "Your username is " . $row["username"] . " and your password is $pwd.", "From: {$opt["email_from"]}\r\nReply-To: {$opt["email_reply_to"]}\r\nX-Mailer: {$opt["email_xmailer"]}\r\n" ) or die("Mail not accepted for " . $row["email"]); } header("Location: " . getFullPath("index.php")); exit; } else if ($action == "reject") { // send the e-mails $stmt = $smarty->dbh()->prepare("SELECT email FROM {$opt["table_prefix"]}users WHERE userid = ?"); $stmt->bindValue(1, (int) $_GET["userid"], PDO::PARAM_INT); $stmt->execute(); if ($row = $stmt->fetch()) { mail( $row["email"], "Gift Registry application denied", "Your Gift Registry application was denied by " . $_SESSION["fullname"] . ".", "From: {$opt["email_from"]}\r\nReply-To: {$opt["email_reply_to"]}\r\nX-Mailer: {$opt["email_xmailer"]}\r\n" ) or die("Mail not accepted for " . $row["email"]); } $stmt = $smarty->dbh()->prepare("DELETE FROM {$opt["table_prefix"]}users WHERE userid = ?"); $stmt->bindValue(1, (int) $_GET["userid"], PDO::PARAM_INT); $stmt->execute(); header("Location: " . getFullPath("index.php")); exit; } ?>