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();
}
users_id INT NOT NULL,
groups_id INT NOT NULL,
INDEX users_groups_users_in (users_id),
INDEX users_groups_groups_in (groups_id)
)
');
$query->exec();
$query = new MysqlQuery('
CREATE TABLE session (
id CHAR(40) NOT NULL PRIMARY KEY,
data VARCHAR(8192),
last_access DATETIME NOT NULL,
INDEX session_access_in (last_access)
)
');
$query->exec();
$query = new MysqlQuery('
INSERT INTO groups
(name)
VALUES
($1),
($2)
');
$query->addParam("admin");
$query->addParam("users");
echo "Info for admin user:\n";
echo "username: "******"firstname: ";
$firstname = trim(fgets(STDIN));
echo "lastname: ";
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();
}
