From 15793496e8d56769c792cf39673c6e6dea3ec4d9 Mon Sep 17 00:00:00 2001 From: Marvin Borner Date: Thu, 28 Jun 2018 21:15:57 +0200 Subject: Preparing for complete rewrite.. --- .../admin/src/Controller/WormholeController.php | 147 --------------------- 1 file changed, 147 deletions(-) delete mode 100644 main/app/sprinkles/admin/src/Controller/WormholeController.php (limited to 'main/app/sprinkles/admin/src/Controller/WormholeController.php') diff --git a/main/app/sprinkles/admin/src/Controller/WormholeController.php b/main/app/sprinkles/admin/src/Controller/WormholeController.php deleted file mode 100644 index e25f890..0000000 --- a/main/app/sprinkles/admin/src/Controller/WormholeController.php +++ /dev/null @@ -1,147 +0,0 @@ -verifyAccessToken($args)) { - $user_id = $args['user_id']; - $session_id = $args['session_id']; - $session_file = file_get_contents("../app/sessions/" . $session_id); - $session_user_id = unserialize(substr($session_file, strpos($session_file, "account|") + 8))["current_user_id"]; - if ($session_user_id == $user_id) { - return $response->withStatus(200); - } else { - throw new NotFoundException(); - } - } - } - - /** - * @param $request - * @param Response $response - * @param $args - * @return Response - * @throws BadRequestException - * @throws NotFoundException - */ - public function newMessage($request, Response $response, $args) { - if ($this->verifyAccessToken($args)) { - $sender_id = $args['sender_id']; - $receiver_id = $args['receiver_id']; - $message = $request->getParsedBody()["message"]; - if (($sender_id != $receiver_id) && $message) { - $MessageId = DB::table('chat_messages') - ->insertGetId(['sender_id' => $sender_id, 'receiver_id' => $receiver_id, 'message' => $message], 'message_id'); - $response->write($MessageId); - return $response->withStatus(200); - } else { - throw new BadRequestException(); - } - } - } - - /** - * @param Request $request - * @param Response $response - * @param $args - * @return Response - * @throws NotFoundException - */ - public function getInfo(Request $request, Response $response, $args) { - /** @var UserFrosting\Sprinkle\Core\Util\ClassMapper $classMapper */ - $classMapper = $this->ci->classMapper; - - if ($this->verifyAccessToken($args)) { - $user = $classMapper->staticMethod('user', 'where', 'id', $args['user_id']) - ->first(); - if (!$user) { - throw new NotFoundException($request, $response); - } - - $UsersFollower = DB::table('user_follow') - ->where('user_id', $user->id) - ->join("users", "users.id", "=", "user_follow.followed_by_id") - ->select("user_follow.followed_by_id as id", "users.user_name as username") - ->get(); - - $UsersFollows = DB::table('user_follow') - ->where('followed_by_id', $user->id) - ->join("users", "users.id", "=", "user_follow.user_id") - ->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"); - /** @var UserFrosting\Sprinkle\Core\Util\ClassMapper $classMapper */ - $classMapper = $this->ci->classMapper; - foreach ($UsersFriends as $Key => $UsersFriendId) { // NOT THAT EFFICIENT... - $UsersFriendInformation = $classMapper->createInstance('user')// select doesnt work with instance - ->where('id', $UsersFriendId->id) - ->get(); - $UsersFriends[$Key]->id = $UsersFriendInformation[0]->id; - $UsersFriends[$Key]->username = $UsersFriendInformation[0]->user_name; - $UsersFriends[$Key]->avatar = $UsersFriendInformation[0]->avatar; - $UsersFriends[$Key]->full_name = $UsersFriendInformation[0]->full_name; - } - - $result = $user->toArray(); - $result["avatar"] = $user->avatar; - $result["followers"] = $UsersFollower; - $result["follows"] = $UsersFollows; - $result["friends"] = $UsersFriends; - return $response->withJson($result, 200, JSON_PRETTY_PRINT); - } - } - - /** - * @param $args - * @return bool - * @throws NotFoundException - */ - private function verifyAccessToken($args) { - $currentUser = $this->ci->currentUser; // FOR DATABASE QUERY - $access_token = $args['access_token']; - if (DB::table('access_token') - ->where('id', 1) - ->where('token', '=', $access_token) - ->exists()) { - return TRUE; - } else { - throw new NotFoundException(); // IT'S A FORBIDDEN - } - } -} \ No newline at end of file -- cgit v1.2.3