Extended backend receiver management

1 files changed, 10 insertions, 0 deletions

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);
         }
     }