From e912515ecdbf82658d27ea161597dc47270efc9e Mon Sep 17 00:00:00 2001
From: Marvin Borner
Date: Thu, 17 May 2018 00:19:29 +0200
Subject: Extended backend receiver management

---
 main/app/sprinkles/admin/src/Controller/WormholeController.php | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'main/app/sprinkles/admin/src/Controller')

diff --git a/main/app/sprinkles/admin/src/Controller/WormholeController.php b/main/app/sprinkles/admin/src/Controller/WormholeController.php
index 889c438..68bbca7 100644
--- a/main/app/sprinkles/admin/src/Controller/WormholeController.php
+++ b/main/app/sprinkles/admin/src/Controller/WormholeController.php
@@ -82,10 +82,20 @@ class WormholeController extends SimpleController
                 ->select("user_follow.user_id as id", "users.user_name as username")
                 ->get();
 
+            $UsersFriends = DB::select("SELECT id FROM (SELECT user_id AS id FROM user_follow WHERE followed_by_id = $user->id UNION ALL SELECT followed_by_id FROM user_follow WHERE user_id = $user->id) t GROUP BY id HAVING COUNT(id) > 1");
+            foreach ($UsersFriends as $Key => $UsersFriendId) { // NOT THAT EFFICIENT...
+                $UsersFriendInformation = DB::table('users')
+                    ->where('id', "=", $UsersFriendId->id)
+                    ->select("users.id", "users.user_name as username")
+                    ->get();
+                $UsersFriends[$Key] = $UsersFriendInformation[0];
+            }
+
             $result = $user->toArray();
             $result["avatar"] = $user->avatar;
             $result["followers"] = $UsersFollower;
             $result["follows"] = $UsersFollows;
+            $result["friends"] = $UsersFriends;
             return $response->withJson($result, 200, JSON_PRETTY_PRINT);
         }
     }
-- 
cgit v1.2.3