Remove join profile table

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

diff --git a/src/Module/NoScrape.php b/src/Module/NoScrape.php
index 2a705ff6eaf9d767334ff6360911efb911480611..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',
                                [