public function update($id, $name)
{
$query = new MysqlQuery("UPDATE groups\n SET name = \$2\n WHERE id = \$1");
$query->addParam($id);
$query->addParam($name);
return $query->exec();
}
$query->addParam("admin");
$query->addParam("users");
echo "Info for admin user:\n";
echo "username: "******"firstname: ";
$firstname = trim(fgets(STDIN));
echo "lastname: ";
$lastname = trim(fgets(STDIN));
echo "password: "******"sha256", trim(fgets(STDIN)));
$rand_bits = strongRand(32);
$rand_bits = preg_replace('/[\\/=+]/', '', $rand_bits);
$rand_bits = substr($rand_bits, 0, 22);
$salt = '$2a$07$' . $rand_bits . '$';
$hash = crypt($password, $salt);
$query = new MysqlQuery('
INSERT INTO users VALUES
(username,
firstname,
lastname,
salt,
password)
VALUES
($1, $2, $3, $4, $5)
');
$query->addParam($username);
$query->addParam($firstname);
$query->addParam($lastname);
$query->addParam($salt);
$query->addParam($password);
public function updatePassword($user_id, $new_password)
{
$salt = $this->genBcryptSalt();
$pass_hash = $this->bcrypt($new_password, $salt);
$query = new MysqlQuery('UPDATE users
SET salt = $1
, password = $2
WHERE id = $3');
$query->addParam($salt);
$query->addParam($pass_hash);
$query->addParam($user_id);
return $query->exec();
}
