Remove join profile table

[friendica.git] / src / Module / NoScrape.php

diff --git a/src/Module/NoScrape.php b/src/Module/NoScrape.php
index 07ecf23d8ac26d9ec87cc6e67563001be3beca0f..53b3fc4e3ee63b812cb61af32584b3a1ea79a756 100644 (file)
--- a/src/Module/NoScrape.php
+++ b/src/Module/NoScrape.php
@@ -33,7 +33,7 @@ class NoScrape extends BaseModule
                        exit();
                }
 
-               Profile::load($a, $nickname);
+               Profile::load($a, $which);
 
                $json_info = [
                        'addr'         => $a->profile['addr'],
@@ -67,11 +67,20 @@ class NoScrape extends BaseModule
                $json_info['language'] = $a->profile['language'];
 
                if (!($a->profile['hide-friends'] ?? false)) {
-                       /// @todo What should this value tell us?
-                       $result = DBA::p("SELECT `gcontact`.`updated` FROM `contact` INNER JOIN `gcontact` WHERE `gcontact`.`nurl` = `contact`.`nurl` AND `self` AND `uid` = ? LIMIT 1", intval($a->profile['uid']));
-                       if (DBA::isResult($result)) {
-                               $json_info["updated"] = date("c", strtotime($result[0]['updated']));
+                       $stmt = DBA::p(
+                               "SELECT `gcontact`.`updated`
+                               FROM `contact`
+                               INNER JOIN `gcontact`
+                               WHERE `gcontact`.`nurl` = `contact`.`nurl`
+                                 AND `self`
+                                 AND `uid` = ?
+                               LIMIT 1",
+                               intval($a->profile['uid'])
+                       );
+                       if ($gcontact = DBA::fetch($stmt)) {
+                               $json_info["updated"] = date("c", strtotime($gcontact['updated']));
                        }
+                       DBA::close($stmt);
 
                        $json_info['contacts'] = DBA::count('contact',
                                [
@@ -103,7 +112,7 @@ class NoScrape extends BaseModule
                $json_info['last-activity'] = date('o-W', $last_active);
 
                //These are optional fields.
-               $profile_fields = ['pdesc', 'locality', 'region', 'postal-code', 'country-name', 'about'];
+               $profile_fields = ['pdesc', 'locality', 'region', 'postal-code', 'country-name'];
                foreach ($profile_fields as $field) {
                        if (!empty($a->profile[$field])) {
                                $json_info["$field"] = $a->profile[$field];