#!/usr/bin/php -q
<?php
  // Add a user to Origo's database
  // NOTE: this is *not* the recommended way to add users!
  //	If you're not sure why this script exists, use Origo's web frontend!
  //	You have been warned!
  //
  // $Id $

function add_user($usr, $pass, $email) {
  $conf_data = parse_ini_file("/etc/aranea/aranea.conf");
  mysql_connect($conf_data['storage_hostd'], $conf_data['storage_user'], $conf_data['storage_password']) or die ("DB Connection failed.");
  mysql_select_db($conf_data['storage_db']);

  $add_user = "INSERT INTO `origo`.`user` (`user_id` ,`name` ,`pass` ,`email` ,`user_key` ,`disabled`) VALUES (NULL , '$usr', '$pass', '$email', '', 'false')";
  mysql_query($add_user);

  $user_assoc = "INSERT INTO `origo`.`user_association` (`user_id` ,`group_id`)
    VALUES (
      (SELECT `user_id` FROM `origo`.`user` WHERE `name`='$usr'),
      '2'
    )";
  mysql_query($user_assoc);
  mysql_close();
}

function usage() {
  $usage_msg = "
origo_user_add.php [ USER PASSWORD EMAIL ]


This utility script can be used to manually add users to Origo via commandline.
It supports two modes of input:

1. Command-line arguments
    If exactly three arguments are passed, they are assumed to be 
      a. the username
      b. the the password
      c. the email address.

2. Interactive prompt
    If insufficient arguments, or too many, are passed, all values are prompted for.
\n\n";
  echo $usage_msg;
  exit(0);
}

$usr = '';
$pwd = '';
$email = '';
// parse cmd-arguments
if ($argc >= 2 && ($argv[1]=='--help' || $argv[1]=='-help')) {
  usage();
}

if ($argc != 4) {
  // prompt for all values
  fwrite(STDOUT, "Enter username: ");
  $usr = trim(fgets(STDIN));
  echo "\tusing \"$usr\"\n";

  fwrite(STDOUT, "Enter password: ");
  $pwd = trim(fgets(STDIN));
  echo "\tusing \"$pwd\"\n";

  fwrite(STDOUT, "Enter email-address: ");
  $email = trim(fgets(STDIN));
  echo "\tusing \"$email\"\n";
} else {
  // use values from cmdline
  $usr = (string)($argv[1]);
  $pwd = (string)($argv[2]);
  $email = (string)($argv[3]);
}

add_user($usr, $pwd, $email);
?>