- $id = $a->argv[2];
-
- $r = q("SELECT `nickname` FROM `user` WHERE `uid` = %d LIMIT 1",
- intval($id)
- );
- if (dbm::is_result($r)) {
- $r = q("SELECT `id` FROM `contact` WHERE `uid` = %d AND `nurl` = '%s' LIMIT 1",
- intval(local_user()),
- dbesc(normalise_link(App::get_baseurl() . '/profile/' . $r[0]['nickname']))
- );
- if (dbm::is_result($r)) {
- q("INSERT INTO `manage` ( `uid`, `mid` ) VALUES ( %d , %d ) ",
- intval($a->argv[2]),
- intval(local_user())
- );
+ $user_id = $a->argv[2];
+
+ $user = dba::selectFirst('user', ['nickname'], ['uid' => $user_id]);
+ if (DBM::is_result($user)) {
+ $condition = [
+ 'uid' => local_user(),
+ 'nurl' => normalise_link(System::baseUrl() . '/profile/' . $user['nickname'])
+ ];
+ if (dba::exists('contact', $condition)) {
+ dba::insert('manage', ['uid' => $user_id, 'mid' => local_user()]);