Merge branch 'release/ui-improvements'

[friendica.git] / include / follow.php

diff --git a/include/follow.php b/include/follow.php
index fc167bb82be792316f8101baaf05673ba418fd37..285f864b94d1424257c9bf8c044bb1a676d8237f 100644 (file)
--- a/include/follow.php
+++ b/include/follow.php
@@ -111,7 +111,7 @@ function new_contact($uid,$url,$interactive = false) {
 
        if($ret['network'] === NETWORK_MAIL) {
                $writeable = 1;
-               
+
        }
        if($ret['network'] === NETWORK_DIASPORA)
                $writeable = 1;
@@ -123,13 +123,13 @@ function new_contact($uid,$url,$interactive = false) {
        $r = q("SELECT * FROM `contact` WHERE `uid` = %d AND `poll` = '%s' LIMIT 1",
                intval($uid),
                dbesc($ret['poll'])
-       );                      
+       );
 
 
        if(count($r)) {
                // update contact
                if($r[0]['rel'] == CONTACT_IS_FOLLOWER || ($network === NETWORK_DIASPORA && $r[0]['rel'] == CONTACT_IS_SHARING)) {
-                       q("UPDATE `contact` SET `rel` = %d , `subhub` = %d, `readonly` = 0 WHERE `id` = %d AND `uid` = %d LIMIT 1",
+                       q("UPDATE `contact` SET `rel` = %d , `subhub` = %d, `readonly` = 0 WHERE `id` = %d AND `uid` = %d",
                                intval(CONTACT_IS_FRIEND),
                                intval($subhub),
                                intval($r[0]['id']),
@@ -222,13 +222,13 @@ function new_contact($uid,$url,$interactive = false) {
 
        $photos = import_profile_photo($ret['photo'],$uid,$contact_id);
 
-       $r = q("UPDATE `contact` SET `photo` = '%s', 
+       $r = q("UPDATE `contact` SET `photo` = '%s',
                        `thumb` = '%s',
-                       `micro` = '%s', 
-                       `name-date` = '%s', 
-                       `uri-date` = '%s', 
+                       `micro` = '%s',
+                       `name-date` = '%s',
+                       `uri-date` = '%s',
                        `avatar-date` = '%s'
-                       WHERE `id` = %d LIMIT 1
+                       WHERE `id` = %d
                ",
                        dbesc($photos[0]),
                        dbesc($photos[1]),
@@ -237,7 +237,7 @@ function new_contact($uid,$url,$interactive = false) {
                        dbesc(datetime_convert()),
                        dbesc(datetime_convert()),
                        intval($contact_id)
-               );                      
+               );
 
 
        // pull feed and consume it, which should subscribe to the hub.
@@ -262,7 +262,7 @@ function new_contact($uid,$url,$interactive = false) {
                '$ostat_follow' => ''
        ));
 
-       $r = q("SELECT `contact`.*, `user`.* FROM `contact` LEFT JOIN `user` ON `contact`.`uid` = `user`.`uid` 
+       $r = q("SELECT `contact`.*, `user`.* FROM `contact` INNER JOIN `user` ON `contact`.`uid` = `user`.`uid`
                        WHERE `user`.`uid` = %d AND `contact`.`self` = 1 LIMIT 1",
                        intval($uid)
        );