adduser

   1 #! /usr/bin/env php
   2 <?php
   3 $db=new SQLite3("database/data.db");
   4 if(!empty($_SERVER["argv"][1]) && !empty($_SERVER["argv"][2]) && !empty($_SERVER["argv"][3]) && !empty($_SERVER["argv"][4])){
   5   $stmt=$db->prepare("SELECT * FROM users WHERE user=:user");
   6   $stmt->bindValue(":user",$_SERVER["argv"][1]);
   7   if($stmt->execute()->fetchArray()){
   8     $stmt=$db->prepare("UPDATE users SET usergroup=:usergroup,department=:department,hash=:hash WHERE user=:user");
   9     $stmt->bindValue(":user", $_SERVER["argv"][1]);
  10     $stmt->bindValue(":usergroup", $_SERVER["argv"][2]);
  11     $stmt->bindValue(":department", $_SERVER["argv"][3]);
  12     $stmt->bindValue(":hash", password_hash($_SERVER["argv"][4], PASSWORD_DEFAULT));
  13     $stmt->execute();
  14   }
  15   else{
  16     $stmt=$db->prepare("INSERT INTO users (user,usergroup,department,hash) VALUES (:user,:usergroup,:department,:hash)");
  17     $stmt->bindValue(":user", $_SERVER["argv"][1]);
  18     $stmt->bindValue(":usergroup", $_SERVER["argv"][2]);
  19     $stmt->bindValue(":department", $_SERVER["argv"][3]);
  20     $stmt->bindValue(":hash", password_hash($_SERVER["argv"][4], PASSWORD_DEFAULT));
  21     $stmt->execute();
  22   }
  23 }
  24 else{
  25   echo basename(__FILE__)." [username] [usergroup] [department] [password]\n";
  26 }
  27 ?>