diff options
author | Andrew Dolgov <[email protected]> | 2021-03-05 21:14:35 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2021-03-05 21:14:35 +0300 |
commit | 2b8b845abe7c13ecbb266613910484310cffe8e1 (patch) | |
tree | 90bd2e93737c2aad17cfb09496cc57cf3f9968cd /useradm.php | |
parent | b2341679d53b227fc90fba34c3a7e6453e3cad6e (diff) |
* use ORM for trivial queries
* environment-based configuration
* useradm.php -> update.php with new options
* support for schema migrations
* various fixes
Diffstat (limited to 'useradm.php')
-rw-r--r-- | useradm.php | 82 |
1 files changed, 0 insertions, 82 deletions
diff --git a/useradm.php b/useradm.php deleted file mode 100644 index 30a7a06..0000000 --- a/useradm.php +++ /dev/null @@ -1,82 +0,0 @@ -<?php - if (!defined('STDIN')) { - print "Please run this script via PHP CLI interpreter (php ./useradm.php)."; - exit; - } - - require_once "config.php"; - require_once "db.php"; - - $dbh = Db::get(); - - $longopts = [ "add:", "del:", "list", "help" ]; - - $options = getopt("", $longopts); - - if (count($options) == 0 || isset($options["help"])) { - print "Manage Epube user database. Usage: - --add USER - --del USER - --list\n"; - } - - if (isset($options["del"])) { - $user = $options["del"]; - - $sth = $dbh->prepare("SELECT id FROM epube_users WHERE user = ?"); - $sth->execute([$user]); - - if ($sth->fetch()) { - print "Deleting user $user...\n"; - - $sth = $dbh->prepare("DELETE FROM epube_users WHERE user = ?"); - $sth->execute([$user]); - } else { - print "User $user not found.\n"; - } - } - - if (isset($options["list"])) { - $res = $dbh->query("SELECT id, user FROM epube_users ORDER BY user"); - - while ($line = $res->fetch()) { - print $line["user"] . "\n"; - } - - } - - if (isset($options["add"])) { - $user = $options["add"]; - - if (!$user) { - print "Not enough arguments.\n"; - exit; - } - - print "Enter password for user $user: "; - $pass = fgets(STDIN); - - $user = trim(mb_strtolower($user)); - $pass = trim($pass); - $pass_hash = 'SHA256:' . hash('sha256', "$user:" . trim($pass)); - - print "Adding user $user with password $pass...\n"; - - $sth = $dbh->prepare("SELECT user FROM epube_users WHERE user = ?"); - $sth->execute([$user]); - - if ($line = $sth->fetch()) { - print "User already exists, updating password.\n"; - - $sth = $dbh->prepare("UPDATE epube_users SET pass = ? WHERE user = ?"); - $sth->execute([$pass_hash, $user]); - - } else { - $sth = $dbh->prepare("INSERT INTO epube_users (user, pass) - VALUES (?, ?)"); - $sth->execute([$user, $pass_hash]); - } - - } - -?> |