- $r = q("INSERT INTO `user` (`guid`, `username`, `password`, `email`, `openid`, `nickname`,
- `pubkey`, `prvkey`, `spubkey`, `sprvkey`, `register_date`, `verified`, `blocked`, `timezone`, `default-location`)
- VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, %d, 'UTC', '')",
- dbesc(generate_user_guid()),
- dbesc($username),
- dbesc($new_password_encoded),
- dbesc($email),
- dbesc($openid_url),
- dbesc($nickname),
- dbesc($pubkey),
- dbesc($prvkey),
- dbesc($spubkey),
- dbesc($sprvkey),
- dbesc(datetime_convert()),
- intval($verified),
- intval($blocked)
- );
-
- if ($r) {
- $r = q("SELECT * FROM `user`
- WHERE `username` = '%s' AND `password` = '%s' LIMIT 1",
- dbesc($username),
- dbesc($new_password_encoded)
- );
- if (DBM::is_result($r)) {
- $u = $r[0];
- $newuid = intval($r[0]['uid']);
- }
+ $insert_result = dba::insert('user', [
+ 'guid' => generate_user_guid(),
+ 'username' => $username,
+ 'password' => $new_password_encoded,
+ 'email' => $email,
+ 'openid' => $openid_url,
+ 'nickname' => $nickname,
+ 'pubkey' => $pubkey,
+ 'prvkey' => $prvkey,
+ 'spubkey' => $spubkey,
+ 'sprvkey' => $sprvkey,
+ 'verified' => $verified,
+ 'blocked' => $blocked,
+ 'timezone' => 'UTC',
+ 'register_date' => datetime_convert(),
+ 'default-location' => ''
+ ]);
+
+ if ($insert_result) {
+ $uid = dba::lastInsertId();
+ $user = dba::select('user', [], ['uid' => $uid], ['limit' => 1]);